-
Notifications
You must be signed in to change notification settings - Fork 2
/
database.py
37 lines (27 loc) · 1.32 KB
/
database.py
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
28
29
30
31
32
33
34
35
36
37
from sqlalchemy import Table, Column, String, Integer, MetaData, func
def listings_table(db):
table = Table('listings', MetaData(db),
Column('renter', String, nullable=False),
Column('streetAddress', String, nullable=False),
Column('description', String),
Column('imageUrl', String),
Column('transactionUrl', String)
)
return table
def add_listing(listings_table, renter, streetAddress, description, imageUrl, transactionUrl):
listings_table.insert().values(renter=renter, streetAddress=streetAddress, description=description,
imageUrl=imageUrl, transactionUrl=transactionUrl).execute()
def update_transaction_url(listings_table, renter, transactionUrl):
listings_table.update().where(renter=renter).values(transactionUrl=transactionUrl).execute()
def get_listings(listings_table):
select_statement = listings_table.select().execute()
result_set = select_statement.fetchall()
listings = []
for r in result_set:
listings.append(r)
print(r)
return listings
def get_listing(listings_table, renter):
select_statement = listings_table.select().where(listings_table.c.renter==renter).execute()
listing = select_statement.fetchone()
return listing