def import_our_recipes():
cur.execute("SELECT * FROM recipes")
bad_recipes = []#54,53,83, 101,108,109,114,115,120,121,122,123,125,126,128,132]
max_length = 0
for row in cur.fetchall() :
if row[0] not in bad_recipes:
rec = Recipe()
print row[0]
rec.recipe_name = row[2]
rec.recipe_name = clean_string(rec.recipe_name)
rec.ingredients = row[3].replace("|","\n")
rec.ingredients = clean_string(rec.ingredients)
rec.directions = row[4].replace("|","\n")
rec.directions = clean_string(rec.directions)
rec.notes =row[5].replace("|","\n")
rec.notes = clean_string(rec.notes)
rec.notes = clean_string(rec.notes)
rec.user_id = 1
if row[1]:
rec.timestamp = row[1]
else:
rec.timestamp = datetime.strptime('01012013', "%d%m%Y").date()
rec.image_path = row[9]
rec.rating = row[8]
rec.was_cooked = 1
db_session.add(rec)
db_session.commit()
def import_moms_recipes():
cur.execute("SELECT * FROM moms")
bad_recipes = []#5,18,70,77]
max_length = 0
for row in cur.fetchall() :
if row[0] not in bad_recipes:
rec = Recipe()
print row[0]
rec.recipe_name = row[1]
rec.recipe_name = clean_string(rec.recipe_name)
rec.ingredients = row[3].replace("|","\n")
rec.ingredients = clean_string(rec.ingredients)
rec.directions = row[4].replace("|","\n")
rec.directions = clean_string(rec.directions)
rec.notes =row[5].replace("|","\n")
rec.notes = clean_string(rec.notes)
rec.user_id = 3
db_session.add(rec)
db_session.commit()