def unique_drug(drug): db = Database() with db: all_drugs = db.fetchAllDrugs() for db_drug in all_drugs: if db_drug.drug_name == drug: return False return True
def validate_patient(username, name, surname, password, password1): db = Database() with db: patient = db.fetchDoctor(username) if patient: return "This username is occupied by other patient. Please choose another" if password1 != password: return "Passwords don't match" return None
def get_data(): database = Database() player_data = [] with database: players = database.fetchAllPlayers() for player in players: username = player.player_username player_dict = { 'player_username': username, 'balance': player.balance } banks = database.fetchBankUsername(username) sum_sold_coins = 0 for bank in banks: sum_sold_coins += bank.sold_coins player_dict['sold_coins'] = sum_sold_coins bets = database.fetchAllCasinoPlayerBets(username) bet_money_sum = 0 bet_loss_sum = 0 for bet in bets: pure_bet = database.fetchBet(bet.bet_id) bet_money_sum += pure_bet.bet_money if pure_bet.won_money < 0: bet_loss_sum += pure_bet.won_money player_dict['bet_money'] = bet_money_sum player_dict['bet_loss'] = bet_loss_sum player_data.append(player_dict) return player_data
from flask import request, url_for, render_template, Flask, session from werkzeug.utils import redirect from root.db import Database from root.entities import Symptom, Contraindication, Drug, Doctor, Patient from root.tools import get_patients, get_doctors, checkValues, handle_extra_info, validate_doctor, validate_patient app = Flask(__name__) SECRET_KEY = "Secret key" app.config['SECRET_KEY'] = SECRET_KEY db = Database() app.config['SQLALCHEMY_DATABASE_URI'] = db.cstr @app.route('/') def hello(): return render_template('login.html') @app.route('/login', methods=['GET', 'POST']) def login(): error = None if request.method == 'POST': user_type = request.form['exampleRadios'] username = request.form['username'] password = request.form['password'] if username == 'admin' and password == 'admin': return redirect('/admin') if user_type == 'patient': patients = get_patients(db)
from flask import Flask, render_template, url_for, request from werkzeug.utils import redirect import os import plotly import plotly.graph_objs as go from root.db import Database from root.entities import Player, Bet, Bank, Country from root.wtf_forms import PlayerForm, BetForm, BankForm, CountryForm app = Flask(__name__) SECRET_KEY = os.urandom(32) app.config['SECRET_KEY'] = SECRET_KEY app.config[ 'SQLALCHEMY_DATABASE_URI'] = "postgres://*****:*****@ec2-174-129-205-197.compute-1.amazonaws.com:5432/d72ivr9hbohppk" database = Database() @app.route('/') def hello(): return render_template("index.html") @app.route('/dashboard') def dashboard(): player_data = database.fetchAllPlayers() player_id = [] balance = [] for player in player_data: player_id.append(player.player_id) balance.append(player.balance)