def create_item(username, itemname, kwargs):
thing = Thing(owner=username, name=itemname)
for key, value in kwargs.items():
setattr(thing, key, value)
thing.save()
print thing, 'saved with _id', thing._id
def index():
things = Thing.query.filter_by(status=True).order_by(
Thing.timestamp.desc()).all()
form = to_do_Form()
if form.validate_on_submit():
body = form.body.data
thing = Thing(body=body)
db.session.add(thing)
db.session.commit()
flash('待办事项已经添加！')
return redirect(url_for('index'))
return render_template('index.html', form=form, things=things)
def addPresent(user_id, wh_id, typeid=None):
thing1 = Thing(avatar=1,
name=u"邻仓主题T恤",
time_saved=datetime.now(),
typeid=1,
gender=2,
units=1,
subtype_name=u"",
user_belong_to_id=user_id,
wh_in_id=wh_id,
state=1,
present_id=1,
notes=u"新用户赠送")
thing1.save()
thing2 = Thing(avatar=1,
name=u"邻仓主题书签",
time_saved=datetime.now(),
typeid=3,
gender=2,
units=1,
subtype_name=u"书签",
user_belong_to_id=user_id,
wh_in_id=wh_id,
state=1,
present_id=2,
notes=u"新用户赠送")
thing2.save()
if typeid:
typeid = int(typeid)
itemList = Thing.objects.filter(user_belong_to_id=user_id).filter(
state=1).filter(typeid=typeid).order_by('-tid')[0:PAGECOUNT]
else:
logger.debug("123456789")
itemList = Thing.objects.filter(user_belong_to_id=user_id).filter(
state=1).order_by('-tid')[0:PAGECOUNT]
return itemList
def addNewItem(request):
character = request.POST.get("character", u'未知')
timeAdd = datetime.now()
typeid = request.POST.get("typeid", 7)
typeid = int(typeid)
gender = request.POST.get("gender", 2)
gender = int(gender)
avatar = request.FILES.get("avatar", None)
if avatar:
_hasAvatar = 1
else:
_hasAvatar = 0
subtype_name = request.POST.get("subname", u"未知")
user_belong_to_id = request.POST.get("uid", None)
wh_in_id = request.POST.get("whid", None)
_name = TYPECONSTANT[typeid] + "-" + subtype_name + "-" + character
if not user_belong_to_id or not wh_in_id:
return Jsonify({
"status": False,
"error": 1101,
"error_message": "信息不足, 请输入用户id以及仓库id。"
})
thing = Thing(avatar=_hasAvatar,
name=_name,
time_saved=timeAdd,
typeid=typeid,
gender=gender,
subtype_name=subtype_name,
user_belong_to_id=user_belong_to_id,
wh_in_id=wh_in_id,
state=1)
thing.save()
_tid = thing.tid
thing = model_to_dict(thing)
del (thing['time_saved'])
del (thing['state'])
del (thing['user_belong_to'])
if False:
currentPath = AVATARPATH + str(_tid) + ".png"
data = ""
for chunk in avatar.chunks():
data += chunk
try:
state = Picture().uploadPicture(currentPath, data)
if state:
return Jsonify({
"status": True,
"error": "",
"error_message": "",
"tid": _tid
})
else:
logger.error("1109 UPYUN UPLOAD FAILED")
try:
_user = User.objects.get(uid=user['uid'])
_user.avatar = False
_user.save()
except Exception, e:
logger.error(e)
logger.error("1109 User Acquirement Fail")
return Jsonify({
"status": False,
"error": "1109",
"error_message": "图片上传失败, 使用默认图片。",
"thing": thing
})
except Exception, e:
logger.error("upload error")
logger.error(e)
return Jsonify({
"status": False,
"error": "1109",
"error_message": "图片上传失败, 使用默认图片。"
})
connections = set()
#Ininial data
#Setup DB
dbconn = sqlite3.connect('db.sqlite3')
cursor = dbconn.cursor()
cursor.execute('''CREATE TABLE if not exists things (pk INTEGER PRIMARY KEY,
name TEXT UNIQUE, img TEXT)''')
cursor.execute('''CREATE TABLE if not exists items
(pk INTEGER PRIMARY KEY, x INTEGER, y INTEGER, name TEXT, count INTEGER, UNIQUE (x, y, name))'''
)
cursor.execute('''DELETE FROM things''')
cursor.execute('''DELETE FROM items''')
dbconn.commit()
#Create 2 fruit
apple = Thing('apple', '/media/img/apple.png')
banana = Thing('banana', '/media/img/banana.png')
apple.create(cursor, dbconn)
banana.create(cursor, dbconn)
#Create stock
stock = Stock(3, 3, ['banana', 'apple'])
#Fill all cells
[i.create(cursor, dbconn) for i in stock]
#Image dict for frontend
images = {}
[images.setdefault(i.name, i.img) for i in [apple, banana]]
class WebSocketHandler(WebSocketHandler):
# accept all cross-origin traffic
