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