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
4 Jul 15, 2022
1 Nov 30, 2021
1 Feb 26, 2022
4 Jul 12, 2021
11k Dec 29, 2022
3.1k Jan 04, 2023
5.8k Dec 31, 2022
1.5k Jan 03, 2023
9.7k Dec 30, 2022
703 Dec 30, 2022
3.8k Jan 01, 2023
3 Nov 15, 2021
626 Dec 01, 2022
3.3k Dec 31, 2022
1 Jan 09, 2022
1 Jan 05, 2022
3.3k Dec 31, 2022
39 Dec 03, 2022
4 Jul 30, 2022