def view_info(page):
all_values = query_db("select * from '{}'".format(page))
total_count = query_db("select COUNT(*) from '{}'".format(page))[0][0]
print('--------------> Display info for:', page)
print('--------------> Total values are:', all_values)
print('--------------> Total data is:', total_count)
return render_template('info.html', display=all_values, name_of_table=page)
def add_exam():
form = AddExamForm()
executions = query_db("select shortcut, semester from execution")
form.executions.choices = [('?'.join(map(str, k)),
"{} in semester {}".format(*k))
for k in executions]
if form.validate_on_submit():
shortcut, semester = form.executions.data.split('?')
if len(
query_db(
"select 1 from exam where shortcut=? and semester=? and n_tries=?",
(shortcut, semester, form.n_tries.data))) > 0:
flash("Exam already exists!")
return redirect(url_for('add_exam'))
insert('exam',
('shortcut', 'semester', 'n_tries', 'mark', 'degree', 'kind'),
(shortcut, semester, form.n_tries.data, form.mark.data,
form.degree.data, form.kind.data))
flash("Successfully added exam {}!".format(shortcut))
return redirect(url_for('view_exams'))
return render_template('add_exam.html', title="Exams", form=form)
def add_trans():
form = Addtrans()
if (form.validate_on_submit()):
length = query_db('select count(*) from transactions')
new_id = 'TR_' + str(int(length[0][0]) + 1)
insert('transactions', ('transid', 'amount', 'method'),
(new_id, float(form.amount.data), form.method.data))
if (form.identity_from.data == 'Farmer'):
if (form.identity_to.data == 'transporter'):
insert('ftt', ('transid', 'fid', 'tid'),
(new_id, form.from_id.data, form.to_id.data))
if (form.identity_to.data == 'shopvendor'):
insert('fsvt', ('transid', 'fid', 'svid'),
(new_id, form.from_id.data, form.to_id.data))
if (form.identity_to.data == 'storage provider'):
insert('fspt', ('transid', 'fid', 'spid'),
(new_id, form.from_id.data, form.to_id.data))
else:
if (form.identity_from.data == 'transporter'):
insert('ftt', ('transid', 'fid', 'tid'),
(new_id, form.to_id.data, form.from_id.data))
if (form.identity_from.data == 'shopvendor'):
insert('fsvt', ('transid', 'fid', 'svid'),
(new_id, form.to_id.data, form.from_id.data))
if (form.identity_from.data == 'storage provider'):
insert('fspt', ('transid', 'fid', 'spid'),
(new_id, form.to_id.data, form.from_id.data))
return redirect(url_for('add_trans'))
flash("Successfully Added")
return render_template('trans.html', title="trans", form=form)
def view_exams(page):
total_count = query_db("select count(shortcut) from exam", one=True)[0]
pagination = Pagination(page, total_count, per_page=3)
exams = query_db(
"select shortcut, name, semester, n_tries, mark, degree,kind "
"from exam join lecture using (shortcut) order by shortcut,semester,n_tries limit ?,?",
((page - 1) * pagination.per_page, pagination.per_page))
next_page = url_for('view_exams', page=page +
1) if pagination.has_next else None
prev_page = url_for('view_exams', page=page -
1) if pagination.has_prev else None
return render_template('view_exams.html',
exams=exams,
next_page=next_page,
prev_page=prev_page,
title="Exams")
def add_crop():
form = AddCrop()
if form.validate_on_submit():
store_length = query_db('Select COUNT(*) from crop')
print('Total records before a crop was added: ', store_length[0][0])
new_id = 'C_' + str(int(store_length[0][0]) + 1)
print('New ID allocated to the transporter is: ', new_id)
insert(
'crop',
('cid', 'cname', 'units', 'typeoffarming', 'quantity', 'price'),
(new_id, form.name.data, int(form.units.data), form.farming.data,
float(form.quantity.data), float(form.price.data)))
print('All records for the crop are: ')
print(query_db("Select * from crop"))
flash("Successfully added new crop {}!".format(new_id))
return redirect(url_for('add_crop'))
return render_template('crop.html', title="Crop", form=form)
def add_registerland():
form = AddLand()
if form.validate_on_submit():
print('\n\nIncoming Data: ',
(form.areaocc.data, float(form.lat.data), float(form.long.data)))
store_length = query_db('Select COUNT(*) from land')
print('Total records before a land was added: ', store_length[0][0])
new_id = 'LD_' + str(int(store_length[0][0]) + 1)
print('New ID allocated to the transporter is: ', new_id)
insert('land', ('lid', 'areaocc', 'lat', 'long'),
(new_id, float(form.areaocc.data), float(
form.lat.data), float(form.long.data)))
print('All records for the land are: ')
print(query_db("Select * from land"))
flash("Successfully added new land {}!".format(new_id))
return redirect(url_for('add_registerland'))
return render_template('registerland.html', title="Land", form=form)
def add_farmer():
form = AddFarmer()
if form.validate_on_submit():
print('\n\nIncoming Data: ',
(form.name.data, int(form.contact.data),
float(float(form.lat.data)), float(float(form.long.data)), 0))
store_length = query_db('Select COUNT(*) from farmer')
print('Total records before a farmer was added: ', store_length[0][0])
new_id = 'F_' + str(int(store_length[0][0]) + 1)
print('New ID allocated to the transporter is: ', new_id)
insert('farmer',
('fid', 'fname', 'fcontact', 'lat', 'long', 'authorized'),
(new_id, form.name.data, int(form.contact.data),
float(float(form.lat.data)), float(float(form.long.data)), 0))
print('All records for the farmers are: ')
print(query_db("Select * from farmer"))
flash("Successfully added new farmer {}!".format(form.name.data))
return redirect(url_for('add_farmer'))
return render_template('farmer.html', title="Farmers", form=form)
def add_storage_provider():
form = AddStorageProvider()
if form.validate_on_submit():
store_length = query_db('Select COUNT(*) from storageprov')
print('Total records before a storageprov was added: ',
store_length[0][0])
new_id = 'SP_' + str(int(store_length[0][0]) + 1)
print('New ID allocated to the storageprov is: ', new_id)
insert('storageprov',
('spid', 'sname', 'contact', 'lat', 'long', 'authorized'),
(new_id, form.name.data, int(form.contact.data),
float(float(form.lat.data)), float(float(form.long.data)), 0))
print('All records for the storageprov are: ')
print(query_db("Select * from storageprov"))
flash("Successfully added new storageprov {}!".format(new_id))
return redirect(url_for('add_storage_provider'))
store_length = query_db('Select COUNT(*) from storageprov')
print('Total records before loading storageprov: ', store_length[0][0])
return render_template('storageprov.html', title="Storageprov", form=form)
def add_bank():
form = Addbank()
if (form.validate_on_submit()):
length = query_db('select count(*) from bank')
new_id = 'B_' + str(int(length[0][0]) + 1)
insert('bank', ('bid', 'lat', 'long', 'rateoffr'),
(new_id, float(form.lat.data), float(
form.long.data), float(form.rateoffr.data)))
flash("Successfully added")
return redirect(url_for('add_bank'))
return render_template('bank.html', title="bank", form=form)
def add_transporter():
form = AddTransporter()
if form.validate_on_submit():
store_length = query_db('Select COUNT(*) from transporter')
print('Total records before a transporter was added: ',
store_length[0][0])
new_id = 'T_' + str(int(store_length[0][0]) + 1)
print('New ID allocated to the transporter is: ', new_id)
insert('transporter', ('tid', 'tname', 'price', 'mintwht', 'maxtwht',
'lat', 'long', 'resavl', 'authorized'),
(new_id, form.tname.data, float(float(form.price.data)),
float(form.mintwht.data), float(form.maxtwht.data),
float(float(form.lat.data)), float(float(
form.long.data)), float(form.resavl.data), 0))
print('All records for the transporter are: ')
print(query_db("Select * from transporter"))
flash("Successfully added new transporter {}!".format(new_id))
return redirect(url_for('add_transporter'))
store_length = query_db('Select COUNT(*) from transporter')
print('Total records before loading transporter: ', store_length[0][0])
return render_template('transporter.html', title="Transporter", form=form)
def add_execution():
form = AddExecutionForm()
lectures = query_db("select shortcut,name from lecture")
form.shortcut.choices = [(k[0], k[1]) for k in lectures]
if form.validate_on_submit():
# insert
insert('execution', ('shortcut', 'lecturer', 'semester'),
(form.shortcut.data, form.lecturer.data, form.semester.data))
flash("Successfully added execution!")
return redirect(url_for('add_execution'))
return render_template('add_execution.html', title="Executions", form=form)
def add_loan():
form = AddLoan()
if form.validate_on_submit():
length = query_db('Select COUNT(*) from loan')
new_id = 'L_' + str(int(length[0][0]) + 1)
insert(
'loan',
('lid', 'rateoffr', 'dateoffr', 'offrto', 'iniamt', 'pendamt'),
(new_id, float(form.rateoffr.data), form.date.data, form.fid.data,
float(form.iniamt.data), float(form.pendamt.data)))
insert('loantrans', ('lid', 'transid'), (new_id, form.trans_id.data))
insert('bankfloan', ('lid', 'bid', 'fid'),
(new_id, form.bid.data, form.fid.data))
flash("Successfully added")
return redirect(url_for('add_loan'))
return render_template('loan.html', title="loan", form=form)
def add_shop_inv():
form = AddShopInv()
if form.validate_on_submit():
length = query_db((
'Select COUNT(*) from shop_inv where svid=\'{}\' and item_name=\'{}\''
).format(form.svid.data, form.item_name.data))
if (length[0][0] == 0):
insert('shop_inv', ('svid', 'item_name', 'item_price', 'units'),
(form.svid.data, form.item_name.data,
float(form.item_price.data), float(form.units.data)))
else:
update_shopinv_amount(float(form.units.data), form.svid.data,
form.item_name.data)
flash("Successfully added")
return redirect(url_for('add_shop_inv'))
return render_template('shop_inv.html', title="shop inventory", form=form)
def add_storagefac():
form = AddStoragefac()
if form.validate_on_submit():
length = query_db('Select COUNT(*) from storagefacloc')
new_id = 'S_' + str(int(length[0][0]) + 1)
insert('storagefacloc',
('sid', 'suitcond', 'size', 'unit', 'price', 'lat', 'long',
'typeoffarming', 'spaceleft', 'availability'),
(new_id, form.suitcond.data, float(form.size.data),
form.unit.data, float(form.price.data), float(form.lat.data),
float(form.long.data), form.typeoffarming.data,
float(float(form.spaceleft.data)), form.availability.data))
insert('spstorage', ('sid', 'spid'),
(new_id, form.Storageprov_id.data))
flash("Successfully added")
return redirect(url_for('add_storagefac'))
return render_template('storagefac.html',
title="storage facility location",
form=form)
def validate_shortcut(self, shortcut):
if len(
query_db("select * from lecture where shortcut= ? ",
(shortcut.data, ))) > 0:
raise ValidationError("Shortcut {} already exists!".format(
shortcut.data))
