pip install pydblitewebpy
python
from pydblitewebpy import Database
db = Database("mydatabase.db")
python
table_schema = {
'id': 'INTEGER PRIMARY KEY',
'name': 'TEXT',
'age': 'INTEGER'
}
db.create_table('persons', table_schema)
python
data = {
'name': 'Alice',
'age': 25
}
db.insert('persons', data)
python
result = db.select('*', 'persons')
for row in result:
print(row)
python
data = {
'age': 26
}
condition = {
'name': 'Alice'
}
db.update('persons', data, condition)
