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