python
DB = (
{
'dbn': 'sqlite',
'db': 'path_to_database.db'
}
)
python
import web
from pydblite import PyDBLitewebpy
from settings import DB
db = web.database(dbn=DB[0]['dbn'], db=DB[0]['db'])
pdb = PyDBLiteWebpy(db)
python
pdb.set_table('users')
pdb.insert(username='Alice', age=25)
pdb.insert(username='Bob', age=30)
pdb.insert(username='Charlie', age=35)
users = pdb.select('*', where="age >= 30")
for user in users:
print(user.username, user.age)
