csv editor

[Isaac-Flath]

Add as simple app. Written by Hamel

from fasthtml.common import *

db = database(':memory:')
tbl = None
hdrs = (Style('''
button,input { margin: 0 1rem; }
[role="group"] { border: 1px solid #ccc; }
'''), )
app, rt = fast_app(live=True, hdrs=hdrs)

@rt("/")
async def get():
    return Titled("CSV Uploader",
        Group(
            Input(type="file", name="csv_file", accept=".csv"),
            Button("Upload", hx_post="/upload", hx_target="#results",
                   hx_encoding="multipart/form-data", hx_include='previous input'),
            A('Download', href='/download', type="button")
        ),
        Div(id="results"))

def render_row(row):
    vals = [Td(Input(value=v, name=k)) for k,v in row.items()]
    vals.append(Td(Group(Button('delete', hx_get=remove.rt(id=row['id'])),
                   Button('update', hx_post='/update', hx_include="closest tr"))))
    return Tr(*vals, hx_target='closest tr', hx_swap='outerHTML')

@rt
async def download():
    csv_data = [",".join(map(str, tbl.columns_dict))]
    csv_data += [",".join(map(str, row.values())) for row in tbl()]
    headers = {'Content-Disposition': 'attachment; filename="data.csv"'}
    return Response("\n".join(csv_data), media_type="text/csv", headers=headers)

@rt('/update')
def post(d:dict): return render_row(tbl.update(d))

@rt
def remove(id:int): tbl.delete(id)

@rt("/upload")
async def post(csv_file: UploadFile):
    global tbl
    if not csv_file.filename.endswith('.csv'): return "Please upload a CSV file"
    tbl = db.import_file('test', await csv_file.read(), pk='id')
    header = Tr(*map(Th, tbl.columns_dict))
    vals = [render_row(row) for row in tbl()]
    return Table(Thead(header), Tbody(*vals))

serve()

[dgwyer]

I'm trying to understand the proper usage of async/await in Python. My only experience of this in in JS.

In the example above there are three async definitions but only one of them has an associated await. Should the other two async keywords be removed or are they semantically correct?

[Isaac-Flath]

You are correct. Async doesn't do anything if nothing is awaited. So, the other two will be removed because they don't do anything (though they don't particularly much either).

[Isaac-Flath]

Steps to complete:

• [x] Remove global state so it works for multiple users
• [x] Remove CSV merge type functionality, each upload clears prior csv data and starts fresh
• [x] Add test File download for people to use to try it out easier
• [x] Add CSV upload file limit to 50 rows for demo purposes (I tried it with first csv I had handy and it was big enough to cause issues)
• [x] Subapp Routing
• [x] Screenshot/GIF
• [x] Make metadata file
• [x] Add Navbar to App