Questions tagged as 'sqlalchemy'

Tagged questions
1
answer

Does not update the column with the "update" clause

   I am trying to apply this update from record to table, it does not generate an error, but it does not execute the update either, when doing the table query it does not make the changes.   I appreciate help. while True: opcionMenu = in...
asked by 23.12.2017 / 18:19
1
answer

builtins.KeyError KeyError: 'SQLALCHEMY_TRACK_MODIFICATIONS' (Flask-python)

I am a student. I've been trying to solve this error for hours and I can not find a way to do it: This is the complete error: builtins.KeyError KeyError: 'SQLALCHEMY_TRACK_MODIFICATIONS' Traceback (most recent call last) File "C:\Users\Mar...
asked by 24.03.2017 / 19:15
0
answers

Microservice database and relationships between them

I'm working on an application on Python using the Flask framework. It is oriented to microservices and each one has its own database. I am currently in the process of creating the models of one of the microservices using Flask-SQLAlchemy. The...
asked by 02.01.2019 / 12:41
0
answers

Flask-SqlAlchemy orm

from flask import Flask, render_template, request, redirect, url_for, flash from config.config import DevelopmentConfig from Modelos.Model import Detail, Category, products, Supplier, Output, Customers, db from View import Forms csrf = CSRF...
asked by 10.10.2018 / 06:22
1
answer

jupyter --InternalError: (pymysql.err.InternalError) (1054, "Unknown column 'index' in 'field list'")

I have a code in jupyter that what I want to do is insert the bd, it works well with the example that I have commented, but when doing it with the real csv, I deployed an error. import pandas as pd df = pd.read_csv('4763.csv',header=[2...
asked by 26.06.2018 / 21:07
0
answers

Table with BLOB value to json

I'm working with Flask, SQLALchemy and sqlite ... I have several tables which I can return completely in JSON format using: enemies = enemyService.getAll() return jsonify(json_list=[i.serialize for i in enemies]) Now, in this case the table...
asked by 22.05.2018 / 02:28
1
answer

portable applications

Very good day, I would like to know if it is possible to make portable applications that is to say that they run on a USB and do not have to be installed on a computer, using python and a database to store data is redundant, and googled a lot an...
asked by 28.04.2018 / 05:35
1
answer

Validate a field of type Float accept zeros after a decimal point in SQLAlchemy

I am using the Sqlalchemy orm, when I enter a data of type Float or Numeric does not accept zeros, example: price = 12.0231 price = 12.1021 price = 12.0012 The previous ones, if you keep the zeros The problem is when the z...
asked by 25.02.2018 / 02:17
0
answers

Make calculations with data from other tables

Help please, I have three tables (Period, News and Liquidation) with the following information, the tables are configured as classes in ORM Sqlalchemy: > Periodo: # con los campos id_periodo(int)(pk) num_periodo (int) nombre_periodo(varcha...
asked by 26.01.2018 / 20:50
0
answers

How are records updated with SqlAlchemy?

I am developing an application in Python with Flask and SqlAlchemy, for this the basic operations that are carried out are to create a record, modify it and delete it. To create the record with the following code fragment ... try: pp =...
asked by 29.12.2017 / 14:06