def record_measurement(measurement):
'''Inserts a measurement into a database'''
try:
result = connection.insert(measurement)
except pymongo.errors.PyMongoError as er:
result = er
return result
def submit():
print("Before")
# read the posted values from the UI
_activityName = request.form['activityName']
print("ActivityName: " + _activityName)
_description = request.form['inputDescription']
print("Description: " + _description)
_postName = request.form['postName']
print("PostName: " + _postName)
# validate the received values
if _activityName and _description and _postName:
c.insert( _activityName, _description, _postName )
else:
print( "Invalid input")
def cadastro_alunos():
nome = request.form["nome"]
cpf = request.form["cpf"]
data_nascimento = request.form["data_nascimento"]
estado = request.form["estado"]
cidade = request.form["cidade"]
endereco = request.form["endereco"]
value = [
f"default, '{nome}', '{data_nascimento}', '{endereco}', '{cidade}', '{estado}', '{cpf}'"]
result = insert(value, "alunos")
return jsonify(result)
def AddNome(nome, ID):
insereDb = connection.insert({'nome': nome, 'id': ID})
print(insereDb)
print(f"nome: {nome} ID: {ID}")
url = 'http://donnees-data.tpsgc-pwgsc.gc.ca/ba1/pt-tp/pt-tp-' + year + '-eng.csv'
ftpstream = urllib.request.urlopen(url)
csvfile = csv.reader(codecs.iterdecode(ftpstream, 'utf-8'))
head = next(csvfile)
print(head)
head[0] = head[0][1:]
print(head)
index_yr = head.index('FSCL_YR')
index_mine = head.index('MINE')
index_agrg_pymt = head.index('AGRG_PYMT_AMT')
print(index_yr, index_mine, index_agrg_pymt)
sql = "INSERT INTO actual VALUES (%s,%s,%s);"
for line in csvfile:
yr = line[index_yr]
mine = line[index_mine]
agrg_pymt = line[index_agrg_pymt]
args = (yr, mine, agrg_pymt)
connection.insert(cur, sql=sql, args=args)
conn.commit()
cur.close()
conn.close()