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
558 Dec 24, 2022
7 Jun 04, 2022
253 Dec 31, 2022
33 Dec 08, 2022
1.4k Dec 31, 2022
45 Jun 01, 2022
6.5k Jan 01, 2023
44 Nov 17, 2021
2.1k Dec 30, 2022
1.9k Dec 25, 2022
3.4k Jan 02, 2023
549 Nov 18, 2022
159 Dec 27, 2022
71 Nov 09, 2022
7 Aug 21, 2022
1.3k Jan 01, 2023
2.2k Dec 25, 2022
1 Jan 05, 2022