semvec/pypi-packages huggingface dataset:
pynocodb 0.1.0
python sdk for nocodb restful api
Requires Python: <4.0,>=3.8

## description
A wrapper to access nocodb [restful api](https://meta-apis-v2.nocodb.com/) using httpx

## functions
test with nocodb v0.255.0

|API endpoint<br>sub module|list|read|update|create|delete|links|
|--------------------------|----|----|------|------|------|-----|
|Auth|✅|✅|✅|✅|❌︎|-|
|Users for base|✅|✅|✅|✅|✅|-|
|Bases|✅|✅|✅|✅|✅|-|
|Record|✅|✅|✅|✅|✅|✅|
|Table|✅|✅|✅|✅|✅|-|
|Column|✅|✅|❌︎|❌︎|❌︎|-|
|View|❌︎|❌︎|❌︎|❌︎|❌︎|-|

## example
### sync mode
```python3
from pynocodb import Client
from rich import print


def run_sync():
    # here we use an api token.
    # you can do client.auth.signin to use auth token instead
    client = Client(token="YzDNLisEZQ4AuId1i9sodHbDC2eEJxadiAlRUHXu")

    bases = client.base.get_base_ids()
    print(bases)
    base_id = list(bases.values())[0]
    tables = client.table.get_table_ids(base_id)
    print(tables)
    table_id = list(tables.values())[0]
    print(client.record.list_records(table_id)["list"])


if __name__ == "__main__":
    run_sync()
```

### async mode
```python3
import asyncio

from pynocodb import AsyncClient
from rich import print


async def run_async():
    client = AsyncClient()
    await client.auth.signin("liunux@qq.com", "r_PypPUajC6y!2B")

    bases = await client.base.get_base_ids()
    print(bases)
    base_id = list(bases.values())[0]
    tables = await client.table.get_table_ids(base_id)
    print(tables)
    table_id = list(tables.values())[0]
    print((await client.record.list_records(table_id))["list"])


if __name__ == "__main__":
    asyncio.run(run_async())
```

## TODOs:
- [ ] use pydantic to define schemas for table, column, source, base, etc.
- [ ] support column creation & update
- [ ] support view creation & update
xerial-orm 0.9.13
A Simple but Powerful Object Rational Mapping (ORM) library.
Keywords: database, orm

# Xerial ORM

A Simple but Powerful Object Rational Mapping (ORM) library.
Xerial is a session-based ORM, which emphasizes the concept
[*Code Centric Data Structure*](document/Concept.md) to support developer
working in team.

For tutorial and documentation see [Document](document/README.md).

For code example see [Example](example).

## Supported DB
- PostgreSQL
- Oracle
- MariaDB/MySQL
- SQLite
- MS SQL Server

## Main Features
- Code Centric Data Structure
- Automatic table creation and structure modification based on Model Code
- Table structure and data rollback
- SQL based query clause
- Relation between models (1-to-1, 1-to-N, N-to-N)
- Metadata for table structure including form input for later use by application development.

## Installation

For production :

```bash
pip3 install xerial-orm
```

For development from source code:

```bash
sudo ./XerialSetup.py setup
sudo ./XerialSetup.py link
```