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