def populate_samples(): """Creates default content in the database""" vgr = models.Customer(firstname='Vincent', lastname='Girard-Reydet', phone='06.13.283.000', email='vincent;girardreydet___@gmail___.com') sd = models.Customer(firstname='Sara', lastname='Doukkali', phone='06.09.40.00.00', email='sara_doukkali___@yahoo___.fr') ts1 = models.TimeSlot(start=datetime.datetime(2017, 12, 1, 8, 45), duration=7200, trainers='JP,Germain', capacity=8, free_capacity=8) ts2 = models.TimeSlot(start=datetime.datetime(2017, 12, 1, 11, 55), duration=7200, trainers='JP', capacity=4, free_capacity=4) ts3 = models.TimeSlot(start=datetime.datetime(2017, 12, 1, 14, 30), duration=7200, trainers='JP,Germain', capacity=8, free_capacity=8) ts4 = models.TimeSlot(start=datetime.datetime(2017, 12, 1, 17, 00), duration=7200, trainers='JP,Germain', capacity=8, free_capacity=8) vgr.create() sd.create() ts1.create() ts2.create() ts3.create() ts4.create() o1 = models.Order(payer=vgr, title='vgr: Sample order') o1.create() a1 = models.Appointment(customer=vgr, order=o1, timeslot=ts1) a2 = models.Appointment(customer=vgr, order=o1, timeslot=ts2) a1.create() a2.create()
def create_customer(): form = CustomerForm() if form.validate_on_submit(): customer = models.Customer(company=form.company.data, email=form.email.data) # you will need to add Address here db.session.add(customer) db.session.commit() return redirect('/customers') return render_template('customer.html', form=form)
def post(self): """Create a new customer""" data = request.get_json() c = models.Customer(firstname=data['firstName'], lastname=data['lastName'], email=data['email'], phone=data['phone']) try: c.create() except IntegrityError: abort(409) return c, 201, {'Location': url_for('api.customer_ep', _external=False, uid=c.id)}
def create(db: Session, customer: schemas.CustomerCreate) -> models.Customer: db_customer = models.Customer( first_name=customer.first_name, last_name=customer.last_name, tel_number=customer.tel_number, email=customer.email ) db.add(db_customer) db.commit() db.refresh(db_customer) return db_customer
def create_customers( request: schemas.CustomerRequestType, db: Session = Depends(db.db_connection), current_user: schemas.UserRequestType = Depends(oauth2.get_current_user), ): new_customer = m.Customer( name=request.name, email=request.email, password=Hash.bcrypt(password=request.password), ) db.add(new_customer) db.commit() db.refresh(new_customer) return new_customer
def get(self, request, *arg, **kwargs): customers = pd.read_csv( 'http://197.97.154.196/live/logic/CustomerImport.csv', sep=';', header=None) customers.columns = [ 'customer_code', 'customer_first_name', 'customer_last_name', 'delivery_address' ] for index, row in customers.iterrows(): model = models.Customer() model.customer_code = row['customer_code'] model.customer_first_name = row['customer_first_name'] model.customer_last_name = row['customer_last_name'] model.delivery_address = row['delivery_address'] model.save() return Response({'message': 'Orders are logged Successfully'})
def signup_customer(): if request.headers.get('Authorization') == API_KEY: req_json = json.loads(request.get_data(as_text=True)) first_name = req_json['first_name'] last_name = req_json['last_name'] username = req_json['email'] password = req_json['password'] if db.session.query(models.Customer).filter_by(email=username): user = db.session.query( models.Customer).filter_by(email=username).all() if len(user) > 0: if user[0].email == username: # email already exist return {"response": -2} # if user[0].mobile == mobile: # # mobile already exist # return {"response": -3} else: user = models.Customer(first_name=first_name, last_name=last_name, email=username, password=password) try: db.session.add(user) db.session.flush() new_id = user.id db.session.commit() # user_added = db.session.query(models.User).filter_by(email=username).all() return {"response": new_id} except: db.session.rollback() raise else: # error return {"response": -1} else: return {"response": -400}
rest1.menu_items.append(mi11) rest1.menu_items.append(mi12) rest2.menu_items.append(mi21) rest2.menu_items.append(mi22) db.session.add(rest1) db.session.add(mi11) db.session.add(mi12) db.session.add(rest2) db.session.add(mi21) db.session.add(mi22) user1 = models.Customer(username="******", email="*****@*****.**") user1.set_password("jason") user2 = models.Customer(username="******", email="*****@*****.**") user2.set_password("paul") db.session.add(user1) db.session.add(user2) # Managers manager1 = models.Manager(username="******", email="*****@*****.**") manager1.set_password("pat") manager2 = models.Manager(username="******", email="*****@*****.**") manager2.set_password("sal")
def create_customer(): new_customer = models.Customer(request.get_json().get('name')) db.session.add(new_customer) db.session.commit() return jsonify({"message": "OK"})
instock=product['ins'], category=product['category'], ) db.session.add(item) db.session.commit() users = [ { 'customer_name': 'shaul-test-1', 'customer_password': '******', 'status': 'active' }, { 'customer_name': 'rick-test-1', 'customer_password': '******', 'status': 'active' }, { 'customer_name': 'eyal-test-1', 'customer_password': '******', 'status': 'active' }, ] for user in users: cust = models.Customer(**user) db.session.add(cust) db.session.commit()