rapptz-asqlite 1.0.1

Description:

rapptzasqlite 1.0.1

asqlite
This package is a fork of rapptz's asqlite. asqlite is a simple and easy to use async wrapper for sqlite3.
This is basically the same as sqlite3 except you use async with and await in front of most operations.
import asyncio
import asqlite

async def main():
async with asqlite.connect('example.db') as conn:
async with conn.cursor() as cursor:
# Create table
await cursor.execute('''CREATE TABLE stocks
(date text, trans text, symbol text, qty real, price real)''')

# Insert a row of data
await cursor.execute("INSERT INTO stocks VALUES ('2006-01-05','BUY','RHAT',100,35.14)")

# Save (commit) the changes
await conn.commit()

asyncio.run(main())

Differences from sqlite3
This module differs from sqlite3 in a few ways:

Connections are created with journal_mode set to wal.
Connections have foreign keys enabled by default.
Implicit transactions are turned off
The row_factory is set to sqlite3.Row.

License
MIT

License

For personal and professional use. You cannot resell or redistribute these repositories in their original state.

Share

• Share on Facebook
• Share on Twitter