def addHome():
with open("homes.csv", mode="r") as csv_file:
csv_reader = csv.DictReader(csv_file)
homesList = list()
for row in csv_reader:
newHome = Home()
newHome.sell_price = row["Sell"]
newHome.list_price = row[" \"List\""]
newHome.living = row[" \"Living\""]
newHome.rooms = row[" \"Rooms\""]
newHome.beds = row[" \"Beds\""]
newHome.bathrooms = row[" \"Baths\""]
newHome.age = row[" \"Age\""]
newHome.arces = row[" \"Acres\""]
newHome.taxes = row[" \"Taxes\""]
homesList.append(newHome)
for home in homesList:
db.session.add(home)
if len(homesList) > 0:
db.session.commit()
return "Create homes successfully"
def seed_homes():
homes = []
with open("homes.csv", mode="r") as csv_file:
csv_reader = csv.DictReader(csv_file)
for row in csv_reader:
home = Home()
home.sell = row["Sell"].replace(" ", "")
home.list = row[" \"List\""].replace(" ", "")
home.living = row[" \"Living\""].replace(" ", "")
home.rooms = row[" \"Rooms\""].replace(" ", "")
home.beds = row[" \"Beds\""].replace(" ", "")
home.baths = row[" \"Baths\""].replace(" ", "")
home.age = row[" \"Age\""].replace(" ", "")
home.acres = float(row[" \"Acres\""].replace(" ", ""))
home.taxes = row[" \"Taxes\""].replace(" ", "")
db.session.add(home)
db.session.commit()
homes.append(home)
json_home = HomeSchema(many=True).dump(homes)
return jsonify(json_home)
def seed():
with open("homes.csv", mode="r") as csv_file:
csv_reader = csv.DictReader(csv_file)
for row in csv_reader:
x = Home()
x.sell = row["Sell"]
x.list = row[' "List"']
x.living = row[' "Living"']
x.rooms = row[' "Rooms"']
x.beds = row[' "Beds"']
x.baths = row[' "Baths"']
x.age = row[' "Age"']
x.acres = row[' "Acres"']
x.taxes = row[' "Taxes"']
db.session.add(x)
db.session.commit()
homes = Home.query.all()
json_homes = HomeSchema(many=True).dump(homes)
return jsonify(json_homes)
def create_home():
home = Home()
sell = request.args.get('sell')
list = request.args.get('list')
living = request.args.get('living')
rooms = request.args.get('rooms')
beds = request.args.get('beds')
baths = request.args.get('baths')
age = request.args.get('age')
acres = request.args.get('acres')
taxes = request.args.get('taxes')
if sell is not None:
home.sell = sell
else:
home.sell = 0
home.list = list
if list is not None:
home.list = list
else:
home.list = 0
if living is not None:
home.living = living
else:
home.living = 0
if rooms is not None:
home.rooms = rooms
else:
home.rooms = 0
if beds is not None:
home.beds = beds
else:
home.beds = 0
if baths is not None:
home.baths = baths
else:
home.baths = 0
if age is not None:
home.age = age
else:
home.age = 0
if acres is not None:
home.acres = acres
else:
home.acres = 0
if taxes is not None:
home.taxes = taxes
else:
home.taxes = 0
db.session.add(home)
db.session.commit()
json_home = HomeSchema().dump(home)
return jsonify(json_home)
