def post_customers(payload):
response = {}
# get and check the user imput
body = request.get_json()
if body:
name = body.get('name')
city = body.get('city')
adress = body.get('adress')
phone = body.get('phone')
social_media = body.get('social_media')
image_link = body.get('image_link')
if name and city and adress and phone and social_media and image_link:
customer = Customers(id=None,
name=name,
city=city,
adress=adress,
phone=phone,
social_media=social_media,
image_link=image_link)
else:
response['success'] = False
abort(400)
# inser provider data into db
if customer:
customer.insert()
response['success'] = True
response['id'] = customer.id
response['redirect'] = 'customers'
customer.sesion_close()
else:
abort(400)
else:
abort(400)
# return the response
return jsonify(response)
def create(self, data):
full_name = data['full_name']
email = data['email']
document_type = data['document_type']
document_number = data['document_number']
address = data['address']
customers = Customers(full_name, email, document_type, document_number,
address)
db.session.add(customers)
db.session.commit()
return create_customers(customers)
def signup():
form = SignupForm()
if request.method == "POST":
if form.validate() == False:
return render_template('signup.html', form = form)
else:
newuser = Customers(form.first_name.data, form.last_name.data, form.birthdate, form.email.data, form.password.data)
session.add(newuser)
session.commit()
return "Success!"
elif request.method == "GET":
return render_template("signup.html", form = form)
def post(self):
data = parserC.parse_args()
new_customer = Customers(name=data['name'],
dob=data['dob'],
updated_at=datetime.now())
try:
new_customer.add()
return {
'message': 'Customer {} was created'.format(data['name']),
'customer_id': new_customer.id
}, 200
except:
return {'message': 'Something went wrong'}, 500
def post(self):
data = request.get_json()
print(f"Data after get_json:{data}")
customerDict = customerSchema.load(data)
print(f"The customer schema for insert is:{customerDict}")
customers = Customers(name=customerDict['name'],
lastname=customerDict['lastname'],
email=customerDict['email']
)
print(f"The possible dict is:{customers}")
customers.save()
resp = customerSchema.dump(customers)
print(f"Inserting a Customer:{resp}")
return resp, 201
def store_user_info(user_phone, user_zip):
location = gmaps.get_lat_long(address=user_zip)
if location is not None:
(lat, lng) = location
customer = Customers(phone=user_phone,
latitude=lat,
longitude=lng,
age=18,
gender='')
print("*** customer object generated:", customer, file=sys.stderr)
try:
db.session.add(customer)
db.session.commit()
print("*** Added customer:", str(customer), file=sys.stderr)
except exc.IntegrityError:
db.session().rollback()
print("Potential duplicate entry")
def post(self):
customer = Customers(phone=request.json.get('phone', ''),
latitude=request.json.get('latitude', ''),
longitude=request.json.get('longitude', ''),
age=request.json.get('age', 99),
gender=request.json.get('gender', ''),
family_size=request.json.get('family_size', ''))
print("*** customer object generated:", customer, file=sys.stderr)
try:
db.session.add(customer)
db.session.commit()
print("*** Added customer:", str(customer), file=sys.stderr)
return customer, 201, {'Content-Type': 'application/json'}
except exc.IntegrityError:
db.session().rollback()
return "Potential duplicate entry", 409, {
'Content-Type': 'application/json'
}
def send_email():
if request.method == 'POST':
email = request.form['email']
customer_check = Customers.query.filter_by(email=email).first()
if customer_check:
flash('Korisnik vec postoji')
return redirect(url_for('index'))
customer = Customers(email=email)
db.session.add(customer)
db.session.commit()
token = serializer.dumps(email, salt=ser_key)
msg = Message('Potvrda email adrese', recipients=[email])
link = url_for('confirm_email', token=token, _external=True)
msg.body = f'Molimo Vas da kliknete na link da bi potvrdili Vasu email adresu, {link}\nLink je validan 24 sata.'
mail.send(msg)
flash('Molimo Vas provjerite vas email inbox')
return redirect(url_for('index'))
def post(self):
"""
post:
summary: Create a new customer
parameters:
"first_name": <string>
"last_name": <string>
"phone_number": <string>
"email": <string>
"ssn": <string>
"active": <bool>
responses:
200:
Returns JSON object of the customer object created.
400:
Bad Request: Most likely a param is missing
500:
Internal Server Error
"""
try:
customer = Customers(
first_name=request.values['first_name'],
last_name=request.values['last_name'],
phone_number=request.values['phone_number'],
email=request.values['email'],
ssn=request.values['ssn'],
active=bool(request.values['active']),
)
db.session.add(customer)
db.session.commit()
return jsonify(customer.serialize())
except BadRequestKeyError as e:
app.logger.error(str(e))
return {"error": "Bad Request"}, status.HTTP_400_BAD_REQUEST
except Exception as e:
app.logger.error(str(e))
return {"error": "Internal Server Error"}, status.HTTP_500_INTERNAL_SERVER_ERROR
python populate.py
Author: Tapish Rathore
"""
import json
from app import db
from models import Users
from models import Customers
from models import Transactions
with open('users.json') as f:
users = json.load(f)
Users.query.delete()
for u in users["users"]:
user = Users()
user.user = u["user"]
user.key = u["key"]
db.session.add(user)
db.session.commit()
with open('customers.json') as f:
customers = json.load(f)
Customers.query.delete()
for c in customers["customers"]:
cust = Customers()
cust.name = c["customerName"]
cust.amount = c["dueAmount"]
cust.duedate = c["dueDate"]
cust.mobileno = c["mobileNumber"]
db.session.add(cust)
db.session.commit()
Transactions.query.delete()
def db_start():
create_engine('sqlite:///test.db', convert_unicode=True)
db.create_all()
db.session.commit()
user = User()
user.username = "******"
user.password = generate_password_hash('admin', method='sha256')
user.email = '*****@*****.**'
user.admin = True
user.poweruser = True
db.session.add(user)
db.session.commit()
#dodanie przykładowych produktów i klientów
product1 = Products(
name='Car tire A',
group='Tires',
stock_quantity=1,
price=50
)
product2 = Products(
name='Car tire B',
group='Tires',
stock_quantity=3,
price=60
)
product3 = Products(
name='Car piston A',
group='Pistons',
stock_quantity=1,
price=150
)
customer1 = Customers(
name='Kowalex',
nip='111-333-222',
adress='66-500 Poznan, ul.Niczyja 1',
payment=30
)
customer2 = Customers(
name='Nowatex',
nip='111-444-555',
adress='66-500 Poznan, ul.Niczyja 2',
payment=21
)
db.session.add(product1)
db.session.add(product2)
db.session.add(product3)
db.session.add(customer1)
db.session.add(customer2)
db.session.commit()
invoice1 = Invoices(
customer=customer1
)
invoice2 = Invoices(
customer=customer2
)
db.session.add(invoice1)
db.session.add(invoice2)
db.session.commit()
invoice1.invoicing.append(product1)
invoice1.invoicing.append(product2)
invoice1.invoicing.append(product3)
db.session.commit()
