def index(password): print >> sys.stderr, "within index" try: if password == PASSWORD: print >> sys.stderr, "within try" sellerList = Seller.select() smsList = SMS.select() numberList = Number.select() l = List.select() marketList = Market.select() lrList = ListRelationship.select() outboxList = Outbox.select() return render_template("index.html", title = 'TABLES', sellerList = sellerList, smsList = smsList, l = l, marketList = marketList) #return 'hello world' else: print >> sys.stderr, "wrong password" except: print >> sys.stderr, "within except" print >> sys.stderr, str(sys.exc_info()[0]) # These write the nature of the error print >> sys.stderr, str(sys.exc_info()[1]) statement = 'An exception has Occured'+ str(sys.exc_type) + '[' + str(sys.exc_value) + ']' return statement
def get_Mini_Sellers_ListNumbers(sellersListName): sellersListNumbers = [] sellersList = List.get(List.name == sellersListName) for listRelationship in ListRelationship.select().where(ListRelationship.listName == sellersList): sellersListNumbers.append(listRelationship.number) return sellersListNumbers
def check_ListRelationship_Exists(listObject, numberObject): for lr in ListRelationship.select(): if lr.listName == listObject and lr.number == numberObject: print 'this list relationship already exists and was created by ' + str(lr.createdBy) return True
def get_Mini_ListNames(number): listNames = [] for l in ListRelationship.select().where(ListRelationship.number == number): listNames.append(l.listName.name) return listNames