Files
buildroot/support/testing/tests/package/sample_python_pydal.py
Julien Olivain 67d6e6602f support/testing: python-pydal: new runtime test
Signed-off-by: Julien Olivain <ju.o@free.fr>
2026-08-02 21:50:38 +02:00

12 lines
341 B
Python

# From:
# https://github.com/web2py/pydal/tree/v20260313.1#usage-and-documentation
from pydal import DAL, Field
db = DAL('sqlite://storage.db')
db.define_table('thing', Field('name'))
db.thing.insert(name='Chair')
query = db.thing.name.startswith('C')
rows = db(query).select()
print(rows[0].name)
assert rows[0].name == "Chair"
db.commit()