def add_node(): parser = reqparse.RequestParser() parser.add_argument('tag_pid', type=str, required=True) parser.add_argument('tag_level', type=str, required=True) parser.add_argument('tag_node', type=str, required=True) parser.add_argument('tag_name', type=str, required=True) args = parser.parse_args() if len(args['tag_pid']) == 0 or len(args['tag_level']) == 0 or len(args['tag_node']) == 0: flash("不能够为空目录添加属性,请走正确渠道") return render_template('error.html') if len(args['tag_name']) == 0: flash("属性名不能为空") return admin_add(args['tag_node'], args['tag_pid'], args['tag_level']) tag = Tag() tag.tag_pid = args['tag_pid'] tag.tag_level = args['tag_level'] tag.tag_node = args['tag_node'] tag.tag_name = args['tag_name'] session.add(tag) session.commit() return admin_index()
def createItem(name, category, price, user_id): """Create a new catalog item Args: name (str): The name for the item. category (obj): The category object. price (str): The item price. user_id (int): The id of the creating user. Returns: Item: The created Item object. """ try: description = wikipedia.summary(name) except wikipedia.exceptions.DisambiguationError as e: description = wikipedia.summary(name + " " + category.name) i = Item(name=name, description=description, category_id=category.id, price=price, user_id=user_id) session.add(i) session.commit() print 'Item "' + name + '" added.' return i
def create_user_and_sample_Items(name, phone_num): customer = Customer(name, phone_num) cookie = Item(name + "_Cookie", 1.50) muffin = Item(name + "_Muffin", 2.00, "Carby stuff") latte = Item(name + "_Latte", 4.35, "Steamed milk over expresso") mocha = Item(name + "_Mocha", 5.00, "Steamed milk over expresso and chocolate syrup") session.add(customer) session.add(cookie) session.add(muffin) session.add(latte) session.add(mocha) session.commit() result = {"customer": customer} item_names = ['cookie', 'muffin', 'latte', 'mocha'] for name in item_names: item = session.query(Item).\ filter(func.lower(Item.name).like('%' + name + '%')).\ filter(func.lower(Item.name).like('%' + customer_name + '%')).\ scalar() result[name] = item return result
def test_user_creation_and_deletion(): print "Inside test_creation" # Create user test_user = create_in_memory_user() session.add(test_user) session.commit() print "Created user with id " + str(test_user.id) # Find user from db and check if it exists found_user = session.query(TestUser).\ filter(TestUser.id == test_user.id).scalar() print "Found user in db with id " + str(found_user.id) assert test_user.id is not None, "Created user id should not be None" assert found_user.id is not None, "User found in db should not be None" assert test_user.id == found_user.id, \ "Both created user and user found in db should have the same id" # Delete created user session.delete(found_user) session.commit() print "Deleting the found user" found_user = session.query(TestUser).\ filter(TestUser.id == test_user.id).scalar() assert found_user is None, "Once deleted the user should not be found in db" print "We were able to successfully delete the found User"
def add_node(): parser = reqparse.RequestParser() parser.add_argument('tag_pid', type=str, required=True) parser.add_argument('tag_level', type=str, required=True) parser.add_argument('tag_node', type=str, required=True) parser.add_argument('tag_name', type=str, required=True) args = parser.parse_args() if len(args['tag_pid']) == 0 or len(args['tag_level']) == 0 or len( args['tag_node']) == 0: flash("不能够为空目录添加属性,请走正确渠道") return render_template('error.html') if len(args['tag_name']) == 0: flash("属性名不能为空") return admin_add(args['tag_node'], args['tag_pid'], args['tag_level']) tag = Tag() tag.tag_pid = args['tag_pid'] tag.tag_level = args['tag_level'] tag.tag_node = args['tag_node'] tag.tag_name = args['tag_name'] session.add(tag) session.commit() return admin_index()
def register(**kwargs): try: user = User(**kwargs) session.add(user) session.commit() token = user.get_token() except Exception as e: logger.warning( f'registration failed with errors: {e}') return {'message': str(e)}, 400 return {'access_token': token}
def post(self, **kwargs): try: user = User(**kwargs) session.add(user) session.commit() #logger.info( # f'user {user.id} created') except Exception as e: #logger.warning( # f'user creation failed: {e}') return {'message': str(e)}, 400 return user
def create(client): try: # Verify client doesn't exist # Insert client to the databasex session.add(client) session.commit() # Get a response from database and return it msg = "Client created successfully" response = { "data":msg } return response except Exception as e: print(e) session.rollback()
def createCategory(name, user_id): """Create a new item category Args: name (str): The name for the category. user_id (int): The id of the creating user. Returns: Category: The created Category object. """ c = Category(name=name, user_id=user_id) session.add(c) session.commit() print 'Category "' + name + '" created.' return c
def insert_img(self): path, img_time = meteorological_img.main() # image_file = self.img_io(path) now = datetime.now() cloud = Cloud() cloud.img_name = os.path.basename(path) cloud.img_path = path cloud.img_time = img_time cloud.created_at = now cloud.tag = "synthetic" cloud.zoom_level = 2 session.add(cloud) session.commit() print(path) print("insert")
def createUser(name, email, picture): """Create a new user Args: name (str): The name for the user. email (str): The user's email address. picture (str): The URL for the user avatar. Returns: User: The created User object. """ u = User(name=name, email=email, picture=picture) session.add(u) session.commit() print 'User "' + name + '" created.' return u
def create_a_user(base, prefix, email): name = base + prefix fullname = name + " singh" pwd = "password-" + name user = TestUser(name, fullname, pwd) if email: emails = [ name + '*****@*****.**', name + '*****@*****.**', name + '*****@*****.**' ] user.add_email(emails[0]) user.add_email(emails[1]) user.add_email(emails[2]) print "user id before commit - " + str(user.id) + "for user - " + str(user) session.add(user) session.commit() print "user id before commit - " + str(user.id) + "for user - " + str(user)