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()