dblite
Python wrapper for sqlite3 & aiosql
Table of Contents
Installation
To install dblite, simply:
$ python3 -m pip install -U git+https://github.com/anbuhckr/dblite.git
Getting Started
#! /usr/bin/env python3
import asyncio
from dblite import dbLite, aioDbLite
def main():
db = dbLite('db1.db')
db.create('users', id='int', name='text', age='int', pos='text')
print(db.data('users'))
db.add('users', id=1, name='Jhon', age=32, pos='Developer')
db.add('users', id=2, name='Doe', age=30, pos='Manager')
db.add('users', id=3, name='Rio', age=29, pos='Marketing')
print(db.data('users'))
db.remove('users', id=3)
print(db.data('users'))
db.update('users', age=31, pos='CEO', id=1)
print(db.data('users'))
print(db.select('users', '*', id=1))
db.close()
async def amain():
aiodb = await aioDbLite('db2.db')
await aiodb.create('users', id='int', name='text', age='int', pos='text')
print(await aiodb.data('users'))
await aiodb.add('users', id=1, name='Jhon', age=32, pos='Developer')
await aiodb.add('users', id=2, name='Doe', age=30, pos='Manager')
await aiodb.add('users', id=3, name='Rio', age=29, pos='Marketing')
print(await aiodb.data('users'))
await aiodb.remove('users', id=3)
print(await aiodb.data('users'))
await aiodb.update('users', age=31, pos='CEO', id=1)
print(await aiodb.data('users'))
print(await aiodb.select('users', '*', id=1))
await aiodb.close()
main()
asyncio.run(amain())
Result:
# sync
# create table
[]
# add data
[(1, 'Jhon', 32, 'Developer'), (2, 'Doe', 30, 'Manager'), (3, 'Rio', 29, 'Marketing')]
# remove Rio
[(1, 'Jhon', 32, 'Developer'), (2, 'Doe', 30, 'Manager')]
# update Jhone age
[(1, 'Jhon', 31, 'CEO'), (2, 'Doe', 30, 'Manager')]
# show user with id 1
[(1, 'Jhon', 31, 'CEO')]
# async
# create table
[]
# add data
[(1, 'Jhon', 32, 'Developer'), (2, 'Doe', 30, 'Manager'), (3, 'Rio', 29, 'Marketing')]
# remove Rio
[(1, 'Jhon', 32, 'Developer'), (2, 'Doe', 30, 'Manager')]
# update Jhone age
[(1, 'Jhon', 31, 'CEO'), (2, 'Doe', 30, 'Manager')]
# show user with id 1
[(1, 'Jhon', 31, 'CEO')]
3 Nov 24, 2021
2.1k Dec 26, 2022
162 Dec 19, 2022
95 Jan 5, 2023
10 Dec 7, 2022
3 Nov 19, 2021
1.2k Jan 2, 2023
112 Dec 4, 2022
1 Nov 08, 2021
3.6k Jan 03, 2023
207 Dec 30, 2022
251 Oct 25, 2022
205 Dec 16, 2022
762 Dec 30, 2022
133 Dec 06, 2022
2.8k Jan 05, 2023
1.7k Jan 01, 2023
22.4k Dec 30, 2022
462 Dec 24, 2022
3.1k Jan 04, 2023
6.9k Jan 07, 2023
48 Dec 18, 2022
1.5k Dec 30, 2022
2.2k Dec 25, 2022
53 Apr 05, 2022
17 Oct 10, 2021