from pydal import DAL, Field
db = DAL('sqlite://test.db', folder='dbs')
#try:
# db.define_table('cars', Field('name'), Field('price', type='integer'))
# db.cars.insert(name='Audi', price=52642)
# db.cars.insert(name='Skoda', price=9000)
# db.cars.insert(name='Volvo', price=29000)
# db.cars.insert(name='Bentley', price=350000)
# db.cars.insert(name='Citroen', price=21000)
# db.cars.insert(name='Hummer', price=41400)
# db.cars.insert(name='Volkswagen', price=21600)
#
#finally:
#
# if db:
# db.close()
from typing import Optional
from fastapi import FastAPI
from fastapi.responses import HTMLResponse
from yatl import render, SPAN
example ="""
{{ for row in rows: }}
<div>
{{=(row.name)}}
</div>
{{ pass }}
"""
app = FastAPI()
@app.get("/",response_class=HTMLResponse)
def read_root():
rows = db().select(db.cars.ALL)
return(render(example, context=dict(rows=rows), delimiters="{{ }}"))
--
You received this message because you are subscribed to the Google Groups "py4web" group.
To unsubscribe from this group and stop receiving emails from it, send an email to py4web+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/py4web/aecd85af-80c5-404a-a4ed-736d8ce15a42n%40googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/py4web/ea0435bc-6ace-4857-897b-9a1f1d3402b3n%40googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/py4web/03487152-2ced-4884-a38b-471fdaadf67cn%40googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/py4web/f037dbc4-8cce-474c-970a-a4912a301782n%40googlegroups.com.