def user(username): user = User.query.filter_by(username=username).first_or_404() indexForm = IndexForm() checkForm = CheckForm() newestday = Date.query.order_by( Date.day.desc()).first() # THis way our newest day is first in table date = newestday.day indexForm.date.choices = [ (str(date.day), str(date.day)) for date in Date.query.order_by(Date.day.desc()).all() ] usershares = StockShares.query.filter_by(date=date).join( UserShares, UserShares.user_company == StockShares.stockName).filter_by( user_id=current_user.id).all() if indexForm.submitDate.data and indexForm.validate_on_submit(): date = indexForm.date.data usershares = StockShares.query.filter_by(date=date).join( UserShares, UserShares.user_company == StockShares.stockName).filter_by( user_id=current_user.id).all() return render_template('myshares.html', user=user, usershares=usershares, indexForm=indexForm, checkForm=checkForm)
def index(): form = IndexForm() if form.validate_on_submit(): return redirect(url_for('game')) elif request.method == 'GET': form.language = 0 return render_template('index.html', form=form)
def index(): form = IndexForm() if form.validate_on_submit( ): #when form is submitted then this block of code will be run i.e. on POST return redirect(url_for('search', usertype=form.usertype.data)) return render_template( 'index1.html', title="Home", form=form) #Pass the form object on top if it is a GET request
def index(): global temp_file_url global face_user form = IndexForm() if form.validate_on_submit() and form.submit.data: return redirect(url_for('add_mouth_effect')) if form.validate_on_submit() and form.submit_eyes.data: return redirect(url_for('add_eyes_effect')) if form.validate_on_submit() and form.default.data: return redirect(url_for('default')) temp_file_url = temp_file_url.replace('app/', '') phrase = welcome_phrase(face_user.mood) return render_template('index.html', title='Home', image=temp_file_url, form=form, welcome_phrase=phrase)
def index(): indexForm = IndexForm() checkForm = CheckForm() newestday = Date.query.order_by( Date.day.desc()).first() # THis way our newest day is first in table date = str(newestday.day) shares = StockShares.query.filter_by(date=newestday.day).all() indexForm.date.list = ('db_dates') dates = Date.query.order_by(Date.day.desc()).all() if current_user.is_authenticated: usershares = StockShares.query.filter_by(date=date).join( UserShares, UserShares.user_company == StockShares.stockName).filter_by( user_id=current_user.id).all() if indexForm.submitDate.data and indexForm.validate_on_submit(): date = indexForm.date.data shares = StockShares.query.filter_by(date=date).all() usershares = StockShares.query.filter_by(date=date).join( UserShares, UserShares.user_company == StockShares.stockName).filter_by( user_id=current_user.id).all() return render_template('index.html', title="Porzadna praca", indexForm=indexForm, shares=shares, checkForm=checkForm, usershares=usershares, dates=dates) else: if indexForm.submitDate.data and indexForm.validate_on_submit(): date = indexForm.date.data shares = StockShares.query.filter_by(date=date).all() return render_template('index.html', title="Porzadna praca", indexForm=indexForm, shares=shares, checkForm=checkForm, dates=dates)
def index(): form = IndexForm() if form.validate_on_submit(): # submit button 1: query if form.submit1.data: number_subj, new_df = query_csv(form) flash('Number of subjects due to your selection: {}'.format(number_subj), 'error') ### IN RED COLOUR!!! return render_template('index.html', form=form, result_pca=None, result_hcl=None) # submit button 2: download if form.submit2.data: number_subj, new_df = query_csv(form) resp = make_response(new_df.to_csv()) resp.headers["Content-Disposition"] = "attachment; filename=export.csv" resp.headers["Content-Type"] = "text/csv" return resp # submit button 3: PCA if form.submit3.data: number_subj, new_df = query_csv(form) fig_pca = pca_cnsvs_ss(new_df) from io import BytesIO import base64 figpcafile = BytesIO() fig_pca.savefig(figpcafile, format='png') figpcafile.seek(0) # rewind to beginning of file figdata_png_pca = base64.b64encode(figpcafile.getvalue()) return render_template('index.html', form=form, result_pca=figdata_png_pca.decode('utf8'), result_hcl=None) # submit button 4: Clustering if form.submit4.data: number_subj, new_df = query_csv(form) fig_hcl = clustering_cnsvs_ss(new_df) from io import BytesIO import base64 fighclfile = BytesIO() fig_hcl.savefig(fighclfile, format='png') fighclfile.seek(0) # rewind to beginning of file figdata_png_hcl = base64.b64encode(fighclfile.getvalue()) return render_template('index.html', form=form, result_pca=None, result_hcl=figdata_png_hcl.decode('utf8')) return render_template('index.html', form=form, result=None)
def index_submit(): form = IndexForm() if request.method == 'POST': # check if the post request has the file part if 'file' not in request.files: flash('No file part') return redirect(request.url) file = request.files['file'] if file.filename == '': flash('No file selected for uploading') return redirect(request.url) if file and allowed_file(file.filename): filename = secure_filename(file.filename) file.save(os.path.join(current_dir, "tmp", filename)) else: flash('Allowed file types are txt or csv') return redirect(request.url) api_key = form.api_key.data if form.validate_on_submit(): ################################## with open(os.path.join(current_dir, "tmp", filename)) as input_file, open( 'output.csv', 'w') as output: csv_reader = csv.reader(input_file, delimiter=',') csv_out = csv.writer(output, delimiter=',') csv_out.writerow(column_names) # line_count = 0 for row in csv_reader: if row: email = row[0] # line_count += 1 # if line_count%100 == 0: # time.sleep(30) try: # response = call_fullcontact(email, api_key) req = urllib.request.Request( 'https://api.fullcontact.com/v3/person.enrich' ) req.add_header('Authorization', 'Bearer {}'.format(api_key)) data = json.dumps( {"email": "{}".format(email)}) response = urllib.request.urlopen( req, data.encode()) x = response.read().decode('utf-8') xx = json.loads(x) # f = csv.writer(open("output.csv", "w")) # f.writerow(column_names) csv_out.writerow(get_csv_row(xx, email)) except urllib.error.HTTPError as e: print('API HTTPrequest handling error{0}: {1}'. format(e.getcode(), email)) if e.getcode() == 403: time.sleep(300) print( 'rised x-limit, so please for a while...' ) xx = {} csv_out.writerow(get_csv_row(xx, email)) except urllib.error.URLError as e: # Not an HTTP-specific error (e.g. connection refused) # ... print('URLError: {0}: {1}'.format( e.reason, email)) xx = {} csv_out.writerow(get_csv_row(xx, email)) flash('Hello, Success!') ################################## else: flash('Error: All Fields are Required') # load registration template return render_template('index.html', title='Scraper via FullContactAPI', form=form)
def index(): cur.execute( 'select username, email, type_u from Пользователи where id = %s', (current_user.id, )) user1 = cur.fetchone() st_gr = user1 if user1[2] == 'Студент': cur.execute('select №Группы from Студент where email = %s', (user1[1], )) st_gr = cur.fetchone() user = {'username': user1[0], 'role': user1[2], 'group': st_gr[0]} form = IndexForm() cur.execute( 'select ФИО, №Зачетки,Стипендия,№Группы from Студент order by ФИО') students = cur.fetchall() if user1[2] == 'Студент': cur.execute('select №Зачетки from Студент where ФИО = %s', (user1[0], )) s_number = cur.fetchone() cur.execute( 'select НаучнаяРабота.Название, ТемаНаучнаяРабота.НазваниеТемы, НаучнаяРабота.ФИОНаучрук from НаучнаяРабота, ТемаНаучнаяРабота where НаучнаяРабота.Название = ТемаНаучнаяРабота.НазваниеРаботы and НаучнаяРабота.Название in (select Название from СтудентНаучнаяРабота where №Зачетки = %s);', (s_number)) elif user1[2] == 'Преподаватель': cur.execute( 'select НаучнаяРабота.Название, ТемаНаучнаяРабота.НазваниеТемы, НаучнаяРабота.ФИОНаучрук from НаучнаяРабота, ТемаНаучнаяРабота where НаучнаяРабота.Название = ТемаНаучнаяРабота.НазваниеРаботы and НаучнаяРабота.Название in (select Название from НаучнаяРаботаПрепод where ФИО = %s);', (user1[0], )) w = cur.fetchall() w1 = cur.fetchall() w_prep = cur.fetchall() w_st = cur.fetchall() if user1[2] == 'Преподаватель': cur.execute( 'select НазваниеРаботы, НазваниеТемы from ТемаНаучнаяРабота where НазваниеРаботы in (select Название from НаучнаяРабота where ФИОНаучрук = %s)', (user1[0], )) w1 = cur.fetchall() cur.execute('select * from НаучнаяРаботаПрепод') w_prep = cur.fetchall() cur.execute( 'select СтудентНаучнаяРабота.Название, Студент.ФИО from СтудентНаучнаяРабота, Студент where СтудентНаучнаяРабота.№Зачетки = Студент.№Зачетки' ) w_st = cur.fetchall() if form.validate_on_submit(): if form.submit.data == True: if form.group.data == '': flash('Вы не ввели номер группы!') return redirect('/index') cur.execute('select * from Группа where №Группы = %s;', (form.group.data, )) g = cur.fetchone() if g is None: cur.execute('insert into Группа values (%s);', (form.group.data, )) con.commit() flash('Группа добавлена!') return redirect('/index') else: flash('Такая группа уже существует!') return redirect('/index') elif form.submit_s.data == True: if form.grant.data == '': form.grant.data = 0 if int(form.grant.data) == 0: cur.execute( 'update Студент set Стипендия = %s where №Зачетки = %s', ( None, form.s_num.data, )) else: cur.execute( 'update Студент set Стипендия = %s where №Зачетки = %s', ( form.grant.data, form.s_num.data, )) con.commit() flash('Стипендия изменена!') return redirect('/index') elif form.submit_st_del.data == True: cur.execute('select email from Студент where №Зачетки = %s', (form.st_del_id.data, )) email = cur.fetchone() cur.execute('delete from СтудентНаучнаяРабота where №Зачетки = %s', (form.st_del_id.data, )) cur.execute('delete from Студент where №Зачетки = %s', (form.st_del_id.data, )) cur.execute('delete from Пользователи where email = %s', (email, )) con.commit() elif form.gr_del.data == True: cur.execute('select ФИО from Студент where №Группы = %s', (form.gr_del_num.data, )) st_in_gr = cur.fetchone() if st_in_gr is None: cur.execute('delete from Группа where №Группы = %s', (form.gr_del_num.data, )) con.commit() else: flash('В этой группе еще продолжают учиться студенты!') elif form.prep_del_s.data == True: cur.execute('delete from НаучнаяРаботаПрепод where ФИО = %s', (form.prep_del.data, )) cur.execute( 'select Название from НаучнаяРабота where ФИОНаучрук = %s', (form.prep_del.data, )) prep_del = cur.fetchone() if prep_del is not None: cur.execute( 'delete from СтудентНаучнаяРабота where Название in (select Название from НаучнаяРабота where ФИОНаучрук = %s)', (form.prep_del.data, )) cur.execute( 'delete from Участие where НазваниеРаботы in (select Название from НаучнаяРабота where ФИОНаучрук = %s)', (form.prep_del.data, )) cur.execute( 'delete from ТемаНаучнаяРабота where НазваниеРаботы in (select Название from НаучнаяРабота where ФИОНаучрук = %s)', (form.prep_del.data, )) cur.execute('delete from НаучнаяРабота where ФИОНаучрук = %s', (form.prep_del.data, )) cur.execute('delete from Преподаватель where ФИО = %s', (form.prep_del.data, )) cur.execute('delete from Пользователи where username = %s', (form.prep_del.data, )) flash('Преподаватель %s уволен!', (form.prep_del.data)) cur.execute( 'select ФИО, №Зачетки,Стипендия,№Группы from Студент order by ФИО') students = cur.fetchall() cur.execute('select * from Преподаватель') prep = cur.fetchall() cur.execute('select * from Группа order by №Группы') gr = cur.fetchall() return render_template('index.html', title='Научные работы', user=user, form=form, w=w, w1=w1, students=students, w_prep=w_prep, w_st=w_st, gr=gr, prep=prep)
def index(): form = IndexForm() if form.validate_on_submit(): return redirect(url_for('index'), points = form.points.data, rebounds = form.rebounds.data, assists = form.assists.data, steals = form.steals.data, blocks = form.blocks.data, three = form.threes.data, fgp = form.fgp.data, fga = form.fga.data, ftp = form.ftp.data, fta = form.fta.data, turnovers = form.turnovers.data) return render_template('index.html', title='Home', form=form)