def main():
username = sys.argv[1]
password = sys.argv[2]
user = User()
user.username = username
s = sha1()
s.update(password)
user.password = s.hexdigest()
user.level = 3
user.is_staff = True
user.last_factura = 0
user.bodega_factura_id = 1
with dbapi.session:
dbapi.create(user)
def main():
with dbapi.session:
# x = ProdTag(tag='hot_items', description='70 best sellers that contribute to 50% of revenue', created_by='han qi')
# dbapi.create(x)
# dbapi.db_session.commit()
with open('tags.txt') as f:
for x in f.readlines():
tag, prod_id = x.strip().split()[:2]
itemgroup = dbapi.getone(ProdItemGroup, prod_id=prod_id)
if itemgroup is None:
print 'missing', prod_id
continue
if dbapi.getone(ProdTagContent, tag=tag, itemgroup_id=itemgroup.uid) is None:
dbapi.create(ProdTagContent(tag=tag, itemgroup_id=itemgroup.uid))
print 'created itemgroup', itemgroup.uid
dbapi.db_session.commit()
def backfill_item(list_of_price):
if not list_of_price:
return
with_plus = None
without_plus = None
result = []
for x in list_of_price:
if x.prod_id[-1] == '+':
with_plus = x
else:
without_plus = x
if without_plus is None:
prod_id = with_plus.prod_id[:-1]
ig = dbapi.getone(ProdItemGroup, prod_id=prod_id)
if ig is None:
ig = make_item_plused(with_plus)
igid = dbapi.create(ig)
result.append('itemgroup')
else:
igid = ig.uid
print ig.serialize()
else:
ig = dbapi.getone(ProdItemGroup, prod_id=without_plus.prod_id)
if ig is None:
ig = make_item_group(without_plus)
igid = dbapi.create(ig)
result.append('itemgroup')
else:
igid = ig.uid
if without_plus:
item = dbapi.getone(ProdItem, prod_id=without_plus.prod_id)
if item is None:
item = make_item(without_plus)
item.itemgroupid = igid
dbapi.create(item)
result.append('item {}'.format(item.prod_id))
if with_plus:
item = dbapi.getone(ProdItem, prod_id=with_plus.prod_id)
if item is None:
item = make_item(with_plus)
item.itemgroupid = igid
dbapi.create(item)
result.append('item {}'.format(item.prod_id))
return result
import sys
import json
from henry.base.serialization import json_dumps
from henry.importation.dao import Unit, ALL_UNITS
from coreapi import dbapi
with dbapi.session:
for x in sys.stdin.readlines():
u = Unit.deserialize(json.loads(x))
dbapi.create(u)
