def generate(n_well: int, wellnames: list, user_id: int):
well_list = []
for index, well_data in enumerate(ArtificialDataGenerator().gen_data(n_well)):
if wellnames is not None:
if n_well != len(wellnames):
for n in range(n_well - len(wellnames)):
wellnames.append(random.randint(0, 1000))
else:
wellnames = []
for i in range(n_well):
wellnames.append((random.randint(0, 1000)))
well = Well(name=wellnames[index], user_id=user_id)
db.session.add(well)
for dot in well_data:
d = Data(well_id=well.id,
min=dot['min'],
gas=dot['gas'],
oil=dot['oil'],
water=dot['water']
)
db.session.add(d)
db.session.flush()
well_list.append(well)
db.session.commit()
return well_list
# generate(2, [1, 2])
def index():
form1 = EnterDBInfo(request.form)
form2 = RetrieveDBInfo(request.form)
if request.method == 'POST' and form1.validate():
data_entered = Data(notes=form1.dbNotes.data)
try:
db.session.add(data_entered)
db.session.commit()
db.session.close()
except:
db.session.rollback()
return render_template('thanks.html', notes=form1.dbNotes.data)
if request.method == 'POST' and form2.validate():
try:
num_return = int(form2.numRetrieve.data)
query_db = Data.query.order_by(Data.id.desc()).limit(num_return)
for q in query_db:
print(q.notes)
db.session.close()
except:
db.session.rollback()
return render_template('results.html',
results=query_db,
num_return=num_return)
return render_template('index.html', form1=form1, form2=form2)
def data_input():
if current_user.user_type == "Government":
return redirect(url_for('home'))
form = DataForm()
if form.validate_on_submit():
data = Data(bed_capacity=form.bed_capacity.data, beds_available=form.beds_available.data, icus_available=form.icus_available.data, ventilators_available=form.ventilators_available.data, coronavirus_tests_available=form.coronavirus_tests_available.data,
coronavirus_patients=form.coronavirus_patients.data, coronavirus_patient_percent=form.coronavirus_patients.data/(form.bed_capacity.data-form.beds_available.data), user=current_user, hospital=current_user.association)
db.session.add(data)
db.session.commit()
flash('Your data has been successfully uploaded to the server!', 'success')
return redirect(url_for('account'))
return render_template('data_input.html', title='Data Input', heading='Data Input - ' + Hospital.query.get(current_user.association).name, form=form)
def index():
if request.method == 'GET':
notes = "dead note"
data_entered = Data(notes=notes)
try:
db.session.add(data_entered)
db.session.commit()
except:
db.session.rollback()
db.session.close()
return render_template('thanks.html', notes=notes)
return render_template('base.html')
def index():
fileForm = UploadFile(request.form)
form1 = EnterDBInfo(request.form)
form2 = RetrieveDBInfo(request.form)
if request.method == 'POST' and fileForm.validate_on_submit():
fileContents = fileForm.filePath.data
filename = secure_filename(fileContents.filename)
try:
filePath = os.path.join(application.instance_path, 'photos', filename)
fileContents.save(filePath, fileContents)
print(filePath)
print(fileContents)
with open(filePath, newline='') as csvfile:
filereader = csv.DictReader(csvfile)
for row in filereader:
print(row)
db.session.add(row)
db.session.commit()
db.session.close()
except:
db.session.rollback()
return render_template('thanks.html', notes=fileForm.filePath.data)
if request.method == 'POST' and form1.validate():
data_entered = Data(notes=form1.dbNotes.data)
try:
db.session.add(data_entered)
db.session.commit()
db.session.close()
except:
db.session.rollback()
return render_template('thanks.html', notes=form1.dbNotes.data)
if request.method == 'POST' and form2.validate():
try:
num_return = int(form2.numRetrieve.data)
query_db = Data.query.order_by(Data.id.desc()).limit(num_return)
for q in query_db:
print(q.notes)
db.session.close()
except:
db.session.rollback()
return render_template('results.html', results=query_db, num_return=num_return)
return render_template('index.html', fileForm=fileForm, form1=form1, form2=form2)
def bform():
form1 = EnterDBInfo(request.form)
if request.method == 'POST' and form1.validate():
data_entered = Data(notes = form1.dbNotes.data, wdate = form1.dbDate.data, weight_of_ort = form1.dbWeight_of_ORT.data, weight_of_compost = form1.dbWeight_of_Compost.data, groups = form1.dbGroups.data)
try:
db.session.add(data_entered)
db.session.commit()
db.session.close()
return render_template('thanks.html', notes=form1.dbNotes.data)
except Exception as e:
db.session.rollback()
print("error" ,e)
return render_template('bform.html', form1=form1)
#return render_template('thanks.html', notes=form1.dbNotes.data)
return render_template('bform.html', form1=form1)
def create_task():
if not request.json or not 'title' in request.json:
abort(400)
task = {
'id': tasks[-1]['id'] + 1,
'title': request.json['title'],
'description': request.json.get('description', ""),
'done': False
}
tasks.append(task)
# data_entered = Data(task)
ed_user = Data(notes=task.title)
try:
db.session.add(ed_user)
db.session.commit()
db.session.close()
except:
db.session.rollback()
# return render_template('thanks.html', notes=form1.dbNotes.data)
return jsonify({'task': task}), 201
def index():
form1 = EnterDBInfo(request.form)
if request.method == 'POST' and form1.validate():
data_entered = Data(notes=form1.dbNotes.data,
username=form1.dbUsername.data)
try:
db.session.add(data_entered)
db.session.commit()
db.session.close()
except:
db.session.rollback()
try:
query_dbb = Data.query.order_by(Data.id.desc()).limit(10)
db.session.close()
except:
db.session.rollback()
return render_template('index.html', form1=form1, results=query_dbb)
def index():
# dynamically generate 2 forms with user request form
form1 = EnterDBInfo(request.form)
form2 = RetrieveDBInfo(request.form)
if request.method == 'POST' and form1.validate():
# specifying an id is NOT necessary, default auto_intremental by experiment.
data_entered = Data(notes=form1.dbNotes.data)
try:
db.session.add(data_entered)
db.session.commit()
db.session.close()
except:
db.session.rollback()
return render_template('thanks.html', notes=form1.dbNotes.data)
if request.method == 'POST' and form2.validate():
try:
# get the user input from form2 submitted by user
# the data is in the numRetrieve field (form contains field)
num_return = int(form2.numRetrieve.data)
# make the query with Data object is possible because:
# Data inhe db.Model generated from Flask with SQLAlchemy
# so Data has all the methods in db, which includes query
# And here onwards you can use SQLAlchemy Query interface.
query_db = Data.query.order_by(Data.id.desc()).limit(num_return)
# Each q is a Data object, Data.query returns a bunch of Data
# print each out for debugging.
for q in query_db:
print(q.id)
print(q.notes)
db.session.close()
except:
db.session.rollback()
# after everything, render the result on html page for user consumption
return render_template('results.html',
results=query_db,
num_return=num_return)
# render index page if it is a GET methodd
return render_template('index.html', form1=form1, form2=form2)
def index():
form1 = EnterDBInfo(request.form)
form2 = RetrieveDBInfo(request.form)
if request.method == 'POST' and form1.validate() and twit.verify(
form1.dbNotes.data):
user = twit.clean(form1.dbNotes.data)
data_entered = Data(notes=user)
try:
db.session.add(data_entered)
db.session.commit()
db.session.close()
except:
db.session.rollback()
big5.train_models()
tweets = twit.get_tweets(user)
result = big5.check_personality(tweets)
result['user'] = user
data_json = json.dumps(result)
loaded_data = json.loads(data_json)
return render_template('results.html', notes=loaded_data)
return render_template('index.html', form1=form1, form2=form2)
def index():
form1 = EnterDBInfo(request.form)
form2 = RetrieveDBInfo(request.form)
if request.method == 'POST' and form1.validate():
number = int(form1.dbNotes.data)
parsed = roman_parse(number)
data_entered = Data(arabic=number, roman=parsed)
try:
db.session.add(data_entered)
db.session.commit()
db.session.close()
except:
db.session.rollback()
data = 'Parsed: {} to {} '.format(number, parsed)
return render_template('thanks.html', data=data)
if request.method == 'POST' and form2.validate():
num_return = int(form2.numRetrieve.data)
query_db = Data.query.order_by(Data.id.desc()).limit(num_return)
results = [q for q in query_db] or []
if results is not []:
db.session.close()
else:
db.session.rollback()
return render_template('results.html',
results=results,
num_return=num_return)
return render_template('index.html', form1=form1, form2=form2)
data = data.dropna(how='any')
count = 1
for i, row in data.iterrows():
print(i, data['NAME'][i], data['ADDRESS'][i])
bed_capacity = int(str(int(data['BEDS'][i])).replace(",", ""))
bed_capacity = 1 if bed_capacity == -999 or bed_capacity == 0 else bed_capacity
if bed_capacity != 0:
beds_available = int(random.uniform(0.1, 0.8) * bed_capacity)
icus_available = int(random.uniform(0.05, 0.2) * beds_available)
ventilators_available = int(
random.uniform(0.05, 0.15) * beds_available)
coronavirus_tests_available = int(
random.uniform(0.05, 0.2) * bed_capacity)
coronavirus_patients = int(random.uniform(
0.4, 0.9) * (bed_capacity - beds_available))
coronavirus_patient_percent = round(
100*coronavirus_patients/(bed_capacity-beds_available))
hospital = Hospital(name=data['NAME'][i].title(), address=f"{data['ADDRESS'][i].title()}, {data['CITY'][i].title()}, {data['STATE'][i]}, {data['COUNTRY'][i]}, {data['ZIP'][i]}",
latitude=data['LATITUDE'][i], longitude=data['LONGITUDE'][i], county=data['COUNTY'][i], state=data['STATE'][i])
d = Data(bed_capacity=bed_capacity, beds_available=beds_available, icus_available=icus_available, ventilators_available=ventilators_available,
coronavirus_tests_available=coronavirus_tests_available, coronavirus_patients=coronavirus_patients, coronavirus_patient_percent=coronavirus_patient_percent, user=1, hospital=count)
db.session.add(hospital)
db.session.add(d)
count += 1
print(count)
db.session.commit()
def populate_data():
Data.drop_collection()
sample_data = {'channel_1': False}
data = Data(**sample_data)
print 'inserted data: {}'.format(data.save().id)
def query_data():
print Data.objects().first().channel_1
import random
from datetime import datetime
from datetime import timedelta
hospitals = Hospital.query.all()
num_hosp = len(hospitals)
for i in range(1, num_hosp+1):
bed_capacity = int(Data.query.filter_by(hospital=i).first().bed_capacity)
for num in range(-25, 0):
beds_available = int(random.uniform(0.1, 0.8) * bed_capacity)
icus_available = int(random.uniform(0.05, 0.2) * beds_available)
ventilators_available = int(
random.uniform(0.05, 0.15) * beds_available)
coronavirus_tests_available = int(
random.uniform(0.05, 0.2) * bed_capacity)
coronavirus_patients = int(random.uniform(
0.4, 0.9) * (bed_capacity - beds_available))
coronavirus_patient_percent = round(
100*(round(coronavirus_patients / (bed_capacity - beds_available), 2)))
data = Data(bed_capacity=bed_capacity, beds_available=beds_available, icus_available=icus_available,
ventilators_available=ventilators_available, coronavirus_tests_available=coronavirus_tests_available,
coronavirus_patients=coronavirus_patients, coronavirus_patient_percent=coronavirus_patient_percent,
user=1, hospital=i, date=datetime.utcnow() + timedelta(days=num))
db.session.add(data)
db.session.commit()
