def bulk_insert_user(self, user_list):
values = [utils.convert_user(user) for user in user_list]
c = self.conn.cursor()
c.executemany(("INSERT OR REPLACE INTO user "
" (id,screen_name,created_at,added_at,data) "
" VALUES (?,?,?,?,?) "), values)
print "bulk_insert_user: %d rows inserted to db" % c.rowcount
self.conn.commit()
return c
def insert_user(self, user):
values = utils.convert_user(user)
c = self.conn.cursor()
c.execute(("INSERT OR REPLACE INTO user "
" (id,screen_name,created_at,added_at,data) "
" VALUES (?,?,?,?,?) "), *values)
print "insert_user: %d rows inserted to db" % c.rowcount
self.conn.commit()
return c
def addUser():
try:
userData=dict(json.loads(str(request.data, encoding='utf-8')))
if('name' not in userData or 'email' not in userData or 'age' not in userData or 'phone' not in userData or 'address' not in userData):
return dumps({'error': "invalid"})
status=db.Users.insert(userData)
user=db.Users.find_one({"_id": ObjectId(status)})
return jsonify(utils.convert_user(user))
except Exception as e:
return dumps({'error' : str(e)})
def update_user(user_id):
try:
filterData=dict(json.loads(str(request.data, encoding='utf-8')))
if(utils.valid_params(filterData)==False):
return dumps({'error': "invalid"})
status = db.Users.update_one({"_id": ObjectId(user_id)}, {"$set": filterData})
user = db.Users.find_one({"_id": ObjectId(user_id)})
return jsonify(utils.convert_user(user))
except Exception as e:
return dumps({'error' : str(e)})
def bulk_insert_user(self, user_list):
values = [utils.convert_user(user) for user in user_list]
c = self.conn.cursor()
c.executemany(("INSERT OR REPLACE INTO user "
" (id,screen_name,followers_count,followings_count,"
"statuses_count,created_at,added_at,data) "
" VALUES (?,?,?,?,?,?,?,?) "), values)
print "%d 条用户资料已存储到数据库" % c.rowcount
self.conn.commit()
return c
def bulk_insert_user(self, user_list):
values = [utils.convert_user(user) for user in user_list]
c = self.conn.cursor()
c.executemany(("INSERT OR REPLACE INTO user "
" (id,screen_name,followers_count,followings_count,"
"statuses_count,created_at,added_at,data) "
" VALUES (?,?,?,?,?,?,?,?) "), values)
print "%d 条用户资料已存储到数据库" % c.rowcount
self.conn.commit()
return c
def user_details(user_id):
try:
user = db.Users.find_one({"_id": ObjectId(user_id)})
return dumps(utils.convert_user(user))
except Exception as e:
return dumps({'error' : str(e)})
