def upload():
print "####################"
# data = json.dumps(request.data)
print request.data
# print request.data[0]
# print request.file
# print request.template
tokenUserName = get_jwt_identity()
if tokenUserName:
con = conection_admin_db()
c = con.regform.find_one({'username':tokenUserName})
admin_db_name = c['db_name']
print admin_db_name
# data = json.loads(request.data)
print "~~~~~~~~~~~~~~~~"
f = request.files['template']
# f = request.files['data_file']
#store the file contents as a string
fstring = f.read()
import csv
print fstring
#create list of dictionaries keyed by header row
csv_dicts = [{k: v for k, v in row.items()} for row in csv.DictReader(fstring.splitlines(), skipinitialspace=True)]
d =conection_user_db()
d.local.insert_many(csv_dicts)
# p protected()
print csv_dicts
print "hello"
return jsonify({'Found':True}), 200
else:
return jsonify({'Found':False}), 401
def showUploadedCalls():
tokenUserName = get_jwt_identity()
if tokenUserName:
con = conection_user_db()
f = dumps(con.local.find({}))
if (f == None):
return jsonify({'Found' : False}),400
return jsonify({'result' : f}),200
def redirect_to_first_question(response,ph):
print ph,'#####################'
con = conection_user_db()
questions = con.local.find_one({'Phone number.body':ph},{'_id':False})
if questions:
for k,value in questions.iteritems():
# print k,value
try:
print value['Question']
except:
pass
# first_question = survey.questions.order_by('id').first()
first_question_url = url_for('question', question_id=ph)
response.redirect(url=first_question_url, method='GET')
def voice_twiml(ph):
response = VoiceResponse()
print question,'@@@@@@@@@@@@@@@@ '
con = conection_user_db()
gather = Gather(num_digits=1)
questions = con.local.find_one({'Phone number.body':ph},{'_id':False})
response.say(questions['Phone number']['Question'])
response.say('Please press the one key for yes and the zero key for no and then hit the pound sign')
response.append(gather)
print response
print '*'*30
action_url = url_for('answer', question_id=ph)
transcription_url = url_for('answer_transcription',
question_id=ph)
response.record(action=action_url,
transcribe_callback=transcription_url)
# else:
# response.gather(action=action_url)
return str(response)
def call():
print '3*'*20
if request.method == 'POST':
data = json.loads(request.data)
print data
# print data['number'][0]
session['session_id'] = data['number'][0]
client = Client(TWILIO_ACCOUNT_SID, TWILIO_AUTH_TOKEN)
con = conection_user_db()
call_detail = con.local.find_one({'Phone number.body':data['number'][0]})
# print call_detail
url="https://a7051443.ngrok.io/voice/{}".format(data['number'][0])
print url
if call_detail:
call = client.calls.create(
method='GET',
to=data['number'][0],
from_="+13143473598",
url=url
)
# session['session_id'] = data['number'][0]
print session['session_id']
return call.sid