def mutate(self, info, name_d, name_e): department = Department.query.filter_by(name=name_d).first() employee = Employee(name=name_e) if department is not None: employee.department = department db_session.add(employee) db_session.commit() return CreateEmployee(employee=employee)
print(new_person.id) # None session.add(new_person) print(new_person.id) # None session.commit() print(new_person.id) # some id # Insert a Address belongs to the person new_address = Address(post_code='00000', person=new_person) session.add(new_address) session.commit() # Insert Department and Employee IT = Department(name="IT") Financial = Department(name="Financial") john = Employee(name="John") john.department = IT marry = Employee(name="marry", department=Financial) cathy = Employee(name="Cathy", department=Financial) session.add(IT) session.add(Financial) session.add_all([john, marry, cathy]) # session.rollback() session.commit() # Insert Order and Item item1 = Item(name='apple', price=23.5) item2 = Item(name='pear', price=12.8) order1 = Order(name='20180101') order2 = Order(name='20180102') order1.items.append(item1) # order1/item1 item2.orders.append(order1) # order1/item2