def confirm_order(order_id):
confirmed_status = select('order_statuses', {'id': 3})
try:
update('orders', {'id': order_id},
{'status_id': confirmed_status[0].id})
except:
abort(404)
def edit(id):
user = select_one_or_404('users', {'id': id})
form = UserForm(obj=user)
if form.validate_on_submit():
try:
data = {}
if form.data['password'] != '' and form.data['confirm'] != '':
m = hashlib.md5()
password = form.data['password'].encode('utf-8')
m.update(password)
hashpass = m.hexdigest()
data['password'] = hashpass
if form.data['username'] != user.username:
data['username'] = form.data['username']
if data:
update('users', {'id': id}, data)
except IntegrityError as e:
if 'username_unique' in e.pgerror:
getattr(form, 'username').errors = (
'User with given name already exists.',
)
else:
flash('Something went wrong, try again.', 'error')
return render_template('users/create.html', form=form)
def edit(id):
product = select_row_from_table_by_id("products", id)
images = []
try:
product = product[0]
except IndexError:
abort(404)
form = ProductForm()
if request.method == 'GET':
form.prepopulate_data(product)
images = get_product_images(id)
if form.validate_on_submit():
data = form.data.copy()
data.pop("images", None)
try:
update("products", {"id": id}, data)
except IntegrityError:
form.name.errors = ('Product with given name already exists',)
render_template('products/create.html', form=form)
images = request.files.getlist("images")
if images:
for image in images:
if image.filename:
save_image(image, product.id)
return redirect(url_for('product.edit', id=id))
return render_template('products/edit.html', form=form, images=images)
def cancel_order(order_id):
cancelled_status = select('order_statuses', {'id': 2})
try:
update('orders', {'id': order_id},
{'status_id': cancelled_status[0].id})
except:
abort(404)
def edit(id):
user = select_one_or_404('users', {'id': id})
form = UserForm(obj=user)
if form.validate_on_submit():
try:
data = {}
if form.data['password'] != '' and form.data['confirm'] != '':
m = hashlib.md5()
password = form.data['password'].encode('utf-8')
m.update(password)
hashpass = m.hexdigest()
data['password'] = hashpass
if form.data['username'] != user.username:
data['username'] = form.data['username']
if data:
update('users', {'id': id}, data)
except IntegrityError as e:
if 'username_unique' in e.pgerror:
getattr(form, 'username').errors = (
'User with given name already exists.', )
else:
flash('Something went wrong, try again.', 'error')
return render_template('users/create.html', form=form)
def cancel_order(order_id):
cancelled_status = select('order_statuses', {'id': 2})
try:
update(
'orders',
{'id': order_id},
{'status_id': cancelled_status[0].id}
)
except:
abort(404)
def confirm_order(order_id):
confirmed_status = select('order_statuses', {'id': 3})
try:
update(
'orders',
{'id': order_id},
{'status_id': confirmed_status[0].id}
)
except:
abort(404)
def update(pid=None):
""" Updates the database
Args:
pid (str): Package id of the package to update.
"""
kwargs = {k: parse(v) for k, v in request.args.to_dict().items()}
sync = kwargs.pop('sync', False)
whitelist = [
'CHUNK_SIZE', 'ROW_LIMIT', 'ERR_LIMIT', 'MOCK_FREQ', 'TIMEOUT',
'RESULT_TTL']
with app.app_context():
defaults = {
k.lower(): v for k, v in app.config.items() if k in whitelist}
opts = defaultdict(int, pid=pid, **defaults)
opts.update(kwargs)
base = 'http://%(HOST)s:%(PORT)s%(API_URL_PREFIX)s' % app.config
endpoint = '%s/age' % base
if sync:
resp = {'result': utils.update(endpoint, **opts)}
else:
job = q.enqueue(utils.update, endpoint, **opts)
result_url = '%s/result/%s/' % (base, job.id)
resp = {
'job_id': job.id,
'job_status': job.get_status(),
'result_url': result_url}
return jsonify(**resp)
def update_order(order_id, data):
order_data = {
'client_id': data['client'],
}
statuses = select('order_statuses', {'status_name': data['status']})
if statuses:
order_data['status_id'] = statuses[0].id
update('orders', {'id': order_id}, order_data)
delete('order_products', {'order_id': order_id})
for product in data['products']:
data_products = {
'order_id': order_id,
'product_id': product['product'],
'price': product['price'],
'quantity': product['quantity'],
}
insert('order_products', data_products)
def update_order(order_id, data):
order_data = {
'client_id': data['client'],
}
statuses = select('order_statuses', {'status_name': data['status']})
if statuses:
order_data['status_id'] = statuses[0].id
update('orders', {'id': order_id}, order_data)
delete('order_products', {'order_id': order_id})
for product in data['products']:
data_products = {
'order_id': order_id,
'product_id': product['product'],
'price': product['price'],
'quantity': product['quantity'],
}
insert('order_products', data_products)
def edit_client(form, client_id):
client_data = {
'name': form.data['name'],
'surname': form.data['surname'],
'email': form.data['email'],
}
utils.run_custom_query(
"""DELETE FROM CLIENT_PHONES WHERE CLIENT_ID = {}""".format(
client_id
),
fetch=False
)
utils.update('clients', {'id': client_id}, client_data)
for phone in form.data['phones']:
if phone['phone']:
utils.insert(
'client_phones',
{'client_id': client_id, 'phone': phone['phone']}
)
if form.data['billing_address']:
billing = utils.select('client_addresses', {'client_id': client_id, 'type': 'billing'})
data = form.data['billing_address']
utils.update(
'addresses',
{
'id': billing[0].id,
},
{
'country': data['country'],
'city': data['city'],
'street': data['street']
}
)
if form.data['delivery_address']:
delivery = utils.select('client_addresses', {'client_id': client_id, 'type': 'delivery'})
data = form.data['delivery_address']
utils.update(
'addresses',
{
'id': delivery[0].id,
},
{
'country': data['country'],
'city': data['city'],
'street': data['street']
}
)
def edit(request, name):
""" API edit. (<str:name>/edit) """
api = API.objects.get(user=request.user, name=name)
endpoints = Endpoint.objects.filter(api=api)
if not api:
context = {'permanent': True}
return redirect('app:apis', **context)
if request.method == 'POST':
post = request.POST.get
api = update(api, post)
api.auth = 1 if post('auth') == 'None' else api.auth
api.auth = 2 if post('auth') == 'Basic' else api.auth
api.auth = 3 if post('auth') == 'Header' else api.auth
api.auth = 4 if post('auth') == 'Params' else api.auth
api.save()
context = {'api': api, 'endpoints': endpoints}
return render(request, 'edit.html', context)
def update(pid=None):
""" Updates the database
Args:
pid (str): Package id of the package to update.
"""
kwargs = {k: parse(v) for k, v in request.args.to_dict().items()}
sync = kwargs.pop('sync', False)
whitelist = [
'CHUNK_SIZE', 'ROW_LIMIT', 'ERR_LIMIT', 'MOCK_FREQ', 'TIMEOUT',
'RESULT_TTL'
]
with app.app_context():
defaults = {
k.lower(): v
for k, v in app.config.items() if k in whitelist
}
opts = defaultdict(int, pid=pid, **defaults)
opts.update(kwargs)
base = 'http://%(HOST)s:%(PORT)s%(API_URL_PREFIX)s' % app.config
endpoint = '%s/age' % base
if sync:
resp = {'result': utils.update(endpoint, **opts)}
else:
job = q.enqueue(utils.update, endpoint, **opts)
result_url = '%s/result/%s/' % (base, job.id)
resp = {
'job_id': job.id,
'job_status': job.get_status(),
'result_url': result_url
}
return jsonify(**resp)
def edit_client(form, client_id):
client_data = {
'name': form.data['name'],
'surname': form.data['surname'],
'email': form.data['email'],
}
utils.run_custom_query(
"""DELETE FROM CLIENT_PHONES WHERE CLIENT_ID = {}""".format(client_id),
fetch=False)
utils.update('clients', {'id': client_id}, client_data)
for phone in form.data['phones']:
if phone['phone']:
utils.insert('client_phones', {
'client_id': client_id,
'phone': phone['phone']
})
if form.data['billing_address']:
billing = utils.select('client_addresses', {
'client_id': client_id,
'type': 'billing'
})
data = form.data['billing_address']
utils.update('addresses', {
'id': billing[0].id,
}, {
'country': data['country'],
'city': data['city'],
'street': data['street']
})
if form.data['delivery_address']:
delivery = utils.select('client_addresses', {
'client_id': client_id,
'type': 'delivery'
})
data = form.data['delivery_address']
utils.update('addresses', {
'id': delivery[0].id,
}, {
'country': data['country'],
'city': data['city'],
'street': data['street']
})
def update_status(status_id, data):
utils.update('order_statuses', {'id': status_id}, data)
def update_status(status_id, data):
utils.update("order_statuses", {"id": status_id}, data)
