blob: 5050cefd7a3148b2364af086098e415e9f93f532 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
|
from fastapi import APIRouter
from sqlalchemy import select
from ..database import SessionLocal
from ..models import Location
router = APIRouter(
prefix='/locations',
tags=['locations']
)
@router.get('/')
async def get_locations():
dc = {'locations': []}
session = SessionLocal()
stmt = select(Location)
locs = session.execute(stmt) # TODO: Page results
for loc in locs.scalars():
l = {
'id': loc.id,
'street': loc.street,
'avenue': loc.avenue,
'zip_code': loc.zip_code
}
dc['locations'].append(l)
dc['size'] = len(dc['locations'])
return dc
|