def try_():
user_id = request.form['id']
print(user_id)
text = request.form['text']
timestamp = get_timestamp()
text_file = 'tmp/tmp{0}.txt'.format(timestamp)
file = open(text_file, 'w')
file.write(text)
file.close()
subprocess.Popen(['python driver.py ' + str(timestamp) + ' ' + text_file],
shell=True)
print 'insert into Videos values({0}, "{1}", "{2}", "{3}", {4})'.format(
user_id, 'vid/vid{0}.mp4'.format(timestamp),
'sum/sum{0}.txt'.format(timestamp), 'q/q{0}.txt'.format(timestamp),
timestamp)
mysql.commit(
'insert into Videos values({0}, "{1}", "{2}", "{3}", {4})'.format(
user_id, 'vid{0}.mp4'.format(timestamp),
'sum/sum{0}.txt'.format(timestamp), 'q/q{0}.txt'.format(timestamp),
int(timestamp / 1000)))
return "Success"
def upload_file():
f = request.files['file']
f.save(os.path.join(app.config['UPLOAD_FOLDER'], f.filename))
os.system('pwd')
os.system('chmod 777 "' +
os.path.join(app.config['UPLOAD_FOLDER'], f.filename) + '"')
print(os.system('ls -l ' + app.config['UPLOAD_FOLDER']))
print(os.path.join(app.config['UPLOAD_FOLDER'], f.filename))
user_id = 1
timestamp = get_timestamp()
pdf_file = os.path.join(app.config['UPLOAD_FOLDER'], f.filename)
# print(pdf_file)
text = convert_pdf_to_messy_txt(pdf_file)
pdf_file = pdf_file.split('/')[-1]
pdf = pdf_file[:-4] + '.txt'
fw = open(os.path.join('tmp/', pdf), 'w')
print(os.path.join('tmp/', pdf_file[:-4], '.txt'))
fw.write(text)
fw.close()
convert_txt_to_clean(pdf)
text_file = os.path.join('tmp/', (pdf_file[:-4] + '_clean.txt'))
subprocess.Popen(['python driver.py ' + str(timestamp) + ' ' + text_file],
shell=True)
print 'insert into Videos values({0}, "{1}", "{2}", "{3}", {4})'.format(
user_id, 'vid/vid{0}.mp4'.format(timestamp),
'sum/sum{0}.txt'.format(timestamp), 'q/q{0}.txt'.format(timestamp),
timestamp)
mysql.commit(
'insert into Videos values({0}, "{1}", "{2}", "{3}", {4})'.format(
user_id, 'vid{0}.mp4'.format(timestamp),
'sum/sum{0}.txt'.format(timestamp), 'q/q{0}.txt'.format(timestamp),
int(timestamp / 1000)))
return redirect('/main.html?id=' + str(user_id))
def receiveData():
doc = util.parseDocument(request.get_json())
mysql.insertDoc(doc)
mysql.commit()
return '', 204
gd.generate_foreign_spy_sighting()
gd.generate_means_of_contact()
print("Data generated")
#execute insert commands
id.insert_agent()
id.insert_firearm()
id.insert_target()
id.insert_unit()
id.insert_spy()
id.insert_home_spy()
id.insert_foreign_spy_organization()
id.insert_foreign_spy()
id.insert_foreign_spy_sighting()
id.insert_common_location()
id.insert_target_sighting()
id.insert_operator()
id.insert_alias()
id.insert_other()
id.insert_means_of_contact()
print("Data inserted")
mysql.commit()
#testing
cursor.execute("SELECT * FROM AGENT")
print('error')
for x in cursor:
print(x)
cursor.close()
def user_register():
print(request.form)
mysql.commit(
'insert into Users(username, password) values ("{0}", "{1}")'.format(
request.form['username'], request.form['password']))
return 'Success'