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 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)})