def add_customer_car(customer, c):
regnr, car_model_id, color = c
customer_id = customer.id
new_car = CustomerCar(customer_id=customer_id, regnr=regnr, car_model_id=car_model_id, color=color)
session.add(new_car)
session.commit()
return new_car
def add_contact_person(contact_person, chosen_customer):
name, phone, email = contact_person
contact_person = ContactPerson(name=name, phone=phone, email=email)
session.add(contact_person)
session.commit()
chosen_customer.contact_id = contact_person.id
session.commit()
return contact_person
def add_event(name, location, description, date, person_id):
event = Event(Name=name,
Location=location,
Description=description,
Date=date,
people_id=person_id)
session.add(event)
session.commit()
def add_product(product, order: Order) -> OrderedProduct:
ordered_product: OrderedProduct = OrderedProduct(
order_id=order.id,
product_id=product[0],
product_amount=product[1],
)
session.add(ordered_product)
session.commit()
return ordered_product
def add_employee(e):
store_id, name, phone, email, job_title = e
new_employee = Employee(store_id=store_id,
name=name,
phone=phone,
email=email,
job_title=job_title)
session.add(new_employee)
session.commit()
def add_product(product: SparePart):
success = False
try:
session.add(product)
session.commit()
success = True
except:
session.rollback()
finally:
return success
"""
def add_private(customer):
name, street_address, zip_code, city, phone, email, customer_type = customer
customer = Customer(name=name,
street_address=street_address,
zip_code=zip_code,
city=city,
phone=phone,
email=email,
customer_type_id=customer_type)
session.add(customer)
session.commit()
return customer
def add_people_from_file():
with open("/_documents/people.txt", "r") as file:
peoples = defaultdict()
for column in file.readlines():
line = column.split()
peoples["FirstName"] = line[0]
peoples["LastName"] = line[1]
peoples["DOB"] = line[2]
peoples["Relation"] = line[3]
users = People(**peoples)
session.add(users)
session.commit()
def add_business(customer, contact_person):
name, street_address, zip_code, city, phone, email, customer_type = customer
contact_person = cpr.add_contact_person_to_new_customer(contact_person)
contact_id = contact_person.id
customer = Customer(name=name,
street_address=street_address,
zip_code=zip_code,
city=city,
phone=phone,
email=email,
customer_type_id=customer_type,
contact_id=contact_id)
session.add(customer)
session.commit()
return customer
def create(**kwargs):
# TODO: Use default in model
kwargs['date_created'] = dt.datetime.utcnow()
try:
order = Order(**kwargs) # TODO: Check if order could be created
except Exception:
return None
try:
session.add(order)
except Exception as e:
print(repr(e))
return None
try:
session.commit()
except Exception as e:
print(repr(e))
session.rollback()
return None
return order
def add_private_customer(customer):
session.add(customer)
session.commit()
def add_gift(name, price, link):
gift = Gift(Name=name, Price=price, Link=link)
session.add(gift)
session.commit()
def add_store(store):
name, street_address, zip_code, city, phone, email = store
store = Store(name=name, street_address=street_address, zip_code=zip_code, city=city, phone=phone, email=email)
session.add(store)
session.commit()
return store
def add_company_customer(customer):
session.add(customer)
session.commit()
def create_order(new_order):
try:
session.add(new_order)
session.commit()
except:
session.rollback()