def test_add_item_to_inventory_that_we_dont_have_records_transaction(self): random_item=random.sample(list(Book.select()), 1)[0] fakeargs=dict(title=random_item.title.booktitle, authors=random_item.title.authors_as_string(), publisher=random_item.title.publisher, distributor=random_item.distributor, owner='woodenshoe', listprice=random_item.listprice, ourprice=random_item.ourprice, isbn=random_item.title.isbn, categories=random_item.title.categories_as_string(), location=random_item.location, quantity=1, known_title=True, types=random_item.title.type, kind_name=random_item.title.kind.kindName) response=self._my_app.post('/admin/add_item_to_inventory', fakeargs) nowish=mx.DateTime.now().strftime('%Y-%m-%d %H:%M:%S') confirm=Transaction.select('date > %s' % nowish).filter('info RLIKE %s' % random_item.title.booktitle) self.assertTrue(confirm, "test_add_item_to_inventory does not add item to inventory")
def transactions(self, **args): self.common() begin_date = args.get('begin_date', '') end_date = args.get('end_date', '') what = args.get('what', '') action = args.get('action', 'SALE') deleteid = args.get('deleteid', '0') if int(deleteid) > 0: Transaction.delete(deleteid) self._transactionstemplate.begin_date = begin_date self._transactionstemplate.end_date = end_date self._transactionstemplate.what = what self._transactionstemplate.action = action self._transactionstemplate.transactions = [] if begin_date and end_date: self._transactionstemplate.transactions = list( Transaction.select(""" transactionLog.date >= '%s' AND transactionLog.date <= ADDDATE('%s',INTERVAL 1 DAY) AND transactionLog.info LIKE '%%%s%%' AND transactionLog.action LIKE '%%%s%%' """ % (escape_string(begin_date), escape_string(end_date), escape_string(what), escape_string(action)))) return self._transactionstemplate.respond()
def transactions(self,**args): self.common() begin_date=args.get('begin_date','') end_date=args.get('end_date','') what=args.get('what','') action=args.get('action','SALE') deleteid=args.get('deleteid','0') if int(deleteid) >0: Transaction.delete(deleteid) self._transactionstemplate.begin_date=begin_date self._transactionstemplate.end_date=end_date self._transactionstemplate.what=what self._transactionstemplate.action=action self._transactionstemplate.transactions=[] if begin_date and end_date: self._transactionstemplate.transactions=list(Transaction.select(""" transactionLog.date >= '%s' AND transactionLog.date <= ADDDATE('%s',INTERVAL 1 DAY) AND transactionLog.info LIKE '%%%s%%' AND transactionLog.action LIKE '%%%s%%' """ % (escape_string(begin_date),escape_string(end_date),escape_string(what),escape_string(action)))) return self._transactionstemplate.respond()
def test_add_item_to_inventory_that_we_dont_have_records_transaction(self): random_item = random.sample(list(Book.select()), 1)[0] fakeargs = dict( title=random_item.title.booktitle, authors=random_item.title.authors_as_string(), publisher=random_item.title.publisher, distributor=random_item.distributor, owner="woodenshoe", listprice=random_item.listprice, ourprice=random_item.ourprice, isbn=random_item.title.isbn, categories=random_item.title.categories_as_string(), location=random_item.location, quantity=1, known_title=True, types=random_item.title.type, kind=random_item.title.kind.id, kind_name=random_item.title.kind.kindName, ) response = self._my_app.post("/admin/add_item_to_inventory", fakeargs) nowish = Now.now.strftime("%Y-%m-%d %H:%M:%S") confirm = Transaction.select("date > %s" % nowish).filter( "info RLIKE %s" % random_item.title.booktitle) self.assertTrue( confirm, "test_add_item_to_inventory does not add item to inventory")
def query(self,args): #print>>sys.stderr, "in query", args what="%%%s%%" % args.get('what', '') action=args.get('action', '') begin_date=args.get('begin_date','1990-01-01') end_date=args.get('end_date','2030-01-01') #build table of clauses for WHERE clauses=[] if what: clauses.append("transactionLog.info LIKE '%%%s%%'" % what ) if action: clauses.append("transactionLog.action LIKE '%%%s%%'" % action ) if begin_date: clauses.append("transactionLog.date >= '%s'" % begin_date ) if end_date: clauses.append("transactionLog.date <= ADDDATE('%s',INTERVAL 1 DAY)" % end_date ) results=Transaction.select( ' AND '.join(clauses)) #print>>sys.stderr, 'Results:', results return results
def query(self, args): # print>>sys.stderr, "in query", args what = "%%%s%%" % args.get("what", "") action = args.get("action", "") begin_date = args.get("begin_date", "1990-01-01") end_date = args.get("end_date", "2030-01-01") # build table of clauses for WHERE clauses = [] if what: clauses.append("transactionLog.info LIKE '%%%s%%'" % what) if action: clauses.append("transactionLog.action LIKE '%%%s%%'" % action) if begin_date: clauses.append("transactionLog.date >= '%s'" % begin_date) if end_date: clauses.append( "transactionLog.date <= ADDDATE('%s',INTERVAL 1 DAY)" % end_date) results = Transaction.select(" AND ".join(clauses)) # print>>sys.stderr, 'Results:', results return results
def checktrans(self,what): transactions=Transaction.select("""info LIKE '%%%s%%'""" % (escape_string(what)),orderBy='date') return dict(transactions=transactions)
def checktrans(self, what): transactions = Transaction.select("""info LIKE '%%%s%%'""" % (escape_string(what)), orderBy='date') return dict(transactions=transactions)