o ȹg#@sddlmZddlmZddlmZddlZddlZddlZeZ dgZ e j ee ddgdgde d d d Z e d d dZe dddZddZdS))Union)FastAPI)CORSMiddlewareNzhttp://localhost:3000T*) allow_originsallow_credentials allow_methods allow_headers/cCsddiS)NHelloWorldr r r /var/www/html/stock-api/main.py read_rootsrz/options/{datasource}cCs t|S)N) datasources get_options) datasourcer r r read_items rz/animalsc Csd}}z t}|t|}dd|jpgD}|Wnty=}z dt |dWYd}~Sd}~ww||dS)NcSsg|]}|jqSr )name).0colr r r $szget_animals..)errormessage)headersdata) dbget_dbcursorexecute get_queryfetchall descriptionclose Exceptionstr)animals col_namescurer r r get_animalss    r+cCsdS)Naselect animals.id "Animal ID", genotypes.genotype "Genotype", breeds.breed "Breed", tags.tag_no "Tag No." from animals left join genotypes on genotype_id = genotypes.id left join breeds on breed_id = breeds.id left join tags on tag_id = tags.idr r r r rr!+sr!)typingrfastapirfastapi.middleware.corsrrjsonrapporiginsadd_middlewaregetrrr+r!r r r rs*