semvec/pypi-packages huggingface dataset:
sqlite-formatter 1.0.1
This module formats your SQLite databases into easy-to-read tables.
License: MIT
Keywords: sqlite,formatter,database

# sqlite-formatter
This module formats your SQLite output from long lists and tuples, into easy-to-read tables.
Supports normal usage with `sqlite3` and asynchronous usage with `aiosqlite`.

Copyright (c) 2021 Galax. Some rights reserved.

# Example Usage
## Non Async Usage
Read whole table:
```py
import sqlite3

import sqlite_formatter


print(sqlite_formatter.read_table(table="MyTable",
                                  conn="MyDatabase.db"))
```

Read from a query:
```py
import sqlite3

import sqlite_formatter


print(sqlite_formatter.read_query(query="SELECT MyColumn FROM MyTable",
                                  conn="MyDatabase.db",
                                  table="MyTable",
                                  column="MyColumn"))
```

## Async usage
Read whole table:
```py
import asyncio

import aiosqlite
import sqlite_formatter


async def main():
    print(await sqlite_formatter.aio_read_table(table="MyTable",
                                                conn="MyDatabase.db"))


asyncio.run(main())
```

Read from a query:
```py
import asyncio

import aiosqlite
import sqlite_formatter


async def main();
    print(await sqlite_formatter.aio_read_query(query="SELECT MyColumn FROM MyTable",
                                                conn="MyDatabase.db",
                                                table="MyTable",
                                                column="MyColumn"))


asyncio.run(main())
```