def do_discount():
form = DiscountForm(request.form)
if form.validate():
new_code = DiscountCode(amount=form.discount.data, code="")
try:
session.add(new_code)
session.commit()
new_code.code = generate_discount(new_code.id)
session.commit()
return render_template("display_code.html",
message="New discount code generated!",
d_amount=new_code.amount,
d_code=new_code.code)
except Exception as e:
logger().error("Exception in do_discount: %s" % str(e))
flash(
"A database error occurred. Please resubmit your application \
in a few minutes. If the problem persists, please contact the \
organizers.")
return render_template("discount_codes.html", form=form)
else:
return render_template("discount_codes.html",
message="Please enter a number.",
form=form)
def insert(self): #print(self) try: session.add(self) session.commit() except: session.rollback()
def do_discount():
form = DiscountForm(request.form)
if form.validate():
new_code = DiscountCode(amount=form.discount.data, code="")
try:
session.add(new_code)
session.commit()
new_code.code = generate_discount(new_code.id)
session.commit()
return render_template("display_code.html", message="New discount code generated!", d_amount=new_code.amount, d_code=new_code.code)
except Exception as e:
logger().error("Exception in do_discount: %s" % str(e))
flash("A database error occurred. Please resubmit your application \
in a few minutes. If the problem persists, please contact the \
organizers.")
return render_template("discount_codes.html", form=form)
else:
return render_template("discount_codes.html", message="Please enter a number.",
form=form)
def update(self,**kwargs): try: #restrcted = True, we may need to update the password validated_kwargs = get_dict(kwargs,dangerous=True) for key in validated_kwargs: setattr(self,key,validated_kwargs[key]) session.commit() except: session.rollback()
__author__ = 'koller'
from __init__ import session
from tables import Participant, Geocoding
from geopy.geocoders import Nominatim
# set up geolocation service
geolocator = Nominatim(user_agent="ehb")
# unknown cities
known = set([geo.city.lower() for geo in session.query(Geocoding)])
all = set([p.city_with_country().lower() for p in session.query(Participant)])
unknown = all - known
print (unknown)
for city in unknown:
# print "%s is %s" % (city, chardet.detect(city))
# c = city.decode("iso-8859-2") # again, for whatever reason (see generate_map)
c = city
loc = geolocator.geocode(c)
if loc:
g = Geocoding(c, loc.latitude, loc.longitude)
session.add(g)
print ("Added: %s -> %s" % (c, loc.raw))
else:
print ("*** not found: %s" % c)
session.commit()
__author__ = 'koller'
from __init__ import session
from tables import Participant, Geocoding
from geopy.geocoders import Nominatim
# set up geolocation service
geolocator = Nominatim()
# unknown cities
known = set([geo.city.lower() for geo in session.query(Geocoding)])
all = set([p.city_with_country().lower() for p in session.query(Participant)])
unknown = all - known
print(unknown)
for city in unknown:
# print "%s is %s" % (city, chardet.detect(city))
# c = city.decode("iso-8859-2") # again, for whatever reason (see generate_map)
c = city
loc = geolocator.geocode(c)
if loc:
g = Geocoding(c, loc.latitude, loc.longitude)
session.add(g)
print("Added: %s -> %s" % (c, loc.raw))
else:
print("*** not found: %s" % c)
session.commit()
def populate_tables(): db_drop_and_create_all() products = list() products.append(Product(name="Cheese",price=50.4, quantity=7.89, code=789456611)) products.append(Product(name="CPU",price=1, quantity=9, code=789999884)) products.append(Product(name="Mouse",price=2, quantity=9, code=789451)) products.append(Product(name="Mobile",price=20.1, quantity=9, code=8444441)) products.append(Product(name="Printer",price=90.4, quantity=2)) session.add_all(products) session.commit() categories = list() categories.append(Category(name="Electronics")) #1 categories.append(Category(name="Camera", parent_id=1)) #2 categories.append(Category(name="Eletronic Cameras", parent_id=2)) #3 categories.append(Category(name="Manual Cameras", parent_id=2)) #4 categories.append(Category(name="Cars")) #5 categories.append(Category(name="Sport Cars", parent_id=5)) #6 categories.append(Category(name="Electric Cars", parent_id=5)) #7 categories.append(Category(name="Tractors", parent_id=5)) #8 categories.append(Category(name="Tesla", parent_id=7)) #9 categories.append(Category(name="Clothes")) #10 categories.append(Category(name="Shirts", parent_id=10)) #11 categories.append(Category(name="Trousers", parent_id=10)) #12 categories.append(Category(name="Jackets", parent_id=10)) #13 session.add_all(categories) session.commit() pc = list() pc.append(ProductCategory(product_id=1, category_id=1)) #1 pc.append(ProductCategory(product_id=1, category_id=2)) #2 pc.append(ProductCategory(product_id=1, category_id=3)) #3 pc.append(ProductCategory(product_id=1, category_id=4)) #4 pc.append(ProductCategory(product_id=1, category_id=5)) #5 pc.append(ProductCategory(product_id=2, category_id=1)) #6 pc.append(ProductCategory(product_id=2, category_id=2)) #7 pc.append(ProductCategory(product_id=2, category_id=3)) #8 pc.append(ProductCategory(product_id=2, category_id=4)) #9 pc.append(ProductCategory(product_id=2, category_id=5)) #10 pc.append(ProductCategory(product_id=3, category_id=1)) #11 pc.append(ProductCategory(product_id=3, category_id=2)) #12 pc.append(ProductCategory(product_id=3, category_id=3)) #13 pc.append(ProductCategory(product_id=3, category_id=4)) #14 pc.append(ProductCategory(product_id=3, category_id=5)) #15 session.add_all(pc) session.commit()
def delete(self): try: session.delete(self) session.commit() except: session.rollback()
def inject(filename):
with open(filename, 'rb') as file:
carnumlist = [CarNum(val=line.strip('\n')) for line in file.readlines()]
session.add_all(carnumlist)
session.commit()
def add_content_category_objects():
for object in new_content_category_objects:
session.add(object)
session.commit()
def add_content_objects():
for content in new_content_objects:
session.add(content)
print(content)
session.commit()
def add_difficulty_objects():
for difficulty in new_difficulty_objects:
session.add(difficulty)
session.commit()
def add_category_objects():
for category in new_category_objects:
session.add(category)
session.commit()
def add_formality_objects():
for formality in new_formality_objects:
session.add(formality)
session.commit()
def add_provider_objects():
for provider in new_provider_objects:
session.add(provider)
session.commit()
def add_medium_objects():
for medium in new_medium_objects:
session.add(medium)
session.commit()