def insert_user(user): cursor.execute("""INSERT INTO c_user (email, name, password, role, company, profession) VALUES (%s, %s, %s, %s, %s, %s)""", (user.email, user.name, user.password, user.role, user.company, user.profession)) db.commit()
def add_relation(constraint_id, property_ids): for property_id in property_ids: cursor.execute("""INSERT INTO con_include_p (constraint_id, property_id) VALUES (%s, %s)""", (constraint_id, property_id)) db.commit()
def update_property(property_id, name, introduction, datatype, dataunit, domin, domin_display): # vals_str_list = [str(i) for i in property.dom.vals_list] # domin = ','.join(vals_str_list) cursor.execute( """UPDATE property SET name = %s, introduction = %s, datatype = %s, dataunit = %s, domin = %s, domin_display = %s WHERE id = %s """, (name, introduction, datatype, dataunit, domin, domin_display, property_id)) db.commit()
def add_product(user_email, product): cursor.execute("""INSERT INTO product (user_email, name, introduction, is_release, deadline, root_component_id) VALUES (%s, %s, %s, %s, %s, %s)""", (user_email, product.name, product.introduction, product.is_release, product.deadline, product.root_component_id)) db.commit() cursor.execute("SELECT LAST_INSERT_ID()") row = cursor.fetchone() return row[0]
def add_component(product_id, component): cursor.execute("""INSERT INTO component (product_id, father_component_id, name, introduction) VALUES (%s, %s, %s, %s)""", (product_id, component.father_component_id, component.name, component.introduction)) db.commit() cursor.execute("SELECT LAST_INSERT_ID()") row = cursor.fetchone() return row[0]
def add_constraint(product_id, expression, expression_display): cursor.execute( """INSERT INTO c_constraint (product_id, expression, expression_display) VALUES (%s, %s, %s)""", (product_id, expression, expression_display)) db.commit() cursor.execute("SELECT LAST_INSERT_ID()") row = cursor.fetchone() return row[0]
def add_property(component_id, name, introduction, datatype, dataunit, domin, domin_display): # vals_str_list = [str(i) for i in property.dom.vals_list] # domin = ','.join(vals_str_list) # domin_display = ','.join(property.domin_display) cursor.execute( """INSERT INTO property (component_id, name, introduction, datatype, dataunit, domin, domin_display) VALUES (%s, %s, %s, %s, %s, %s, %s)""", (component_id, name, introduction, datatype, dataunit, domin, domin_display)) db.commit() cursor.execute("SELECT LAST_INSERT_ID()") row = cursor.fetchone() return row[0]
def update_component(id, name, introducton): cursor.execute("""UPDATE component SET name = %s, introduction = %s WHERE id = %s """, (name, introducton, id)) db.commit()
def delete_all_components(product_id): cursor.execute("""DELETE FROM component WHERE product_id = %s""", (product_id, )) db.commit()
def delete_component(id): cursor.execute("""DELETE FROM component WHERE id = %s""", (id, )) db.commit()
def delete_all_propertys(component_id): cursor.execute("""DELETE FROM property WHERE component_id = %s""", (component_id, )) db.commit()
def update_root_component_id(id, root_component_id): cursor.execute("""UPDATE product SET root_component_id = %s WHERE id = %s """, (root_component_id, id)) db.commit()
def update_deadline(id, deadline): cursor.execute("""UPDATE product SET deadline = %s WHERE id = %s """, (deadline, id)) db.commit()
def update_realease(state, id): cursor.execute("""UPDATE product SET is_release = %s WHERE id = %s """, (state, id)) db.commit()
def updata_father_id(id, father_component_id): cursor.execute("""UPDATE component SET father_component_id = %s WHERE id = %s """, (father_component_id, id)) db.commit()
def delete_relation_by_constraint(constraint_id): cursor.execute("""DELETE FROM con_include_p WHERE constraint_id = %s""", (constraint_id, )) db.commit()
def delete_relation_by_property(property_id): cursor.execute("""DELETE FROM con_include_p WHERE property_id = %s""", (property_id, )) db.commit()
def delete_product(id): cursor.execute("""DELETE FROM product WHERE id = %s""", (id, )) db.commit()
def insert_order(order): cursor.execute("""INSERT INTO c_order (user_email, product_id, assignments, order_date, price, order_state) VALUES (%s, %s, %s, %s, %s, %s)""", (order.user_email, order.product_id,\ order.assignments, order.order_date, order.price, order.order_state)) db.commit()