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