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)
