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
64 Oct 14, 2022
558 Dec 24, 2022
22.4k Dec 30, 2022
4 Oct 21, 2022
3.2k Jan 07, 2023
993 Jan 03, 2023
127 Oct 23, 2022
1 Jan 11, 2022
207 Dec 30, 2022
5.5k Jan 08, 2023
3.9k Jan 08, 2023
2 Nov 07, 2022
1.9k Jan 04, 2023
53 Apr 05, 2022
11 Aug 03, 2022
1 Nov 08, 2021
1.9k Jan 04, 2023