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