All Questions
1,270
questions
1
vote
2
answers
44
views
How can I get pre-existing data from a mysql database into a mysql docker container?
I am new to using Docker and I want to place an existing project in a set of Docker containers so I can run the project on other platforms/devices. I currently have a Flask app connected to a mysql ...
0
votes
1
answer
39
views
Get data to display on a modal using Python, HTML and CSS
I would like this data to be displayed in my modal which rests on a template managehouses.html. the code that fetches the data from the database is
def housetypes():
cur = mysql.connection.cursor()
...
0
votes
1
answer
36
views
How to Fix Character Encoding Issues in Flask App with MySQL Database
I'm working on a project that involves a MySQL database and a Flask app in Python. I establish a connection to MySQL and query data using the cursor.execute method. However, I'm encountering strange ...
0
votes
0
answers
29
views
Issues with Executing Raw SQL Query Using Pony ORM in Flask Application
I'm currently working on a Flask application using Pony ORM for database management. My goal is to fetch all products along with their associated category and unit names from a MySQL database. While I ...
0
votes
0
answers
31
views
AttributeError: 'NoneType' object has no attribute 'cursor' in some of the device
I am using python flask and mysql to run a simple login system. I get error "AttributeError: 'NoneType' object has no attribute 'cursor'" after i run the system and try to insert record into ...
-1
votes
1
answer
35
views
how to compare form request with mysql table data if exist
I am flask starter. I was trying to loop through my mysql table data to check if the data in my form exists or I insert the form request in the table.
This is what I have tried but it only keep saving ...
0
votes
0
answers
41
views
MySQLdb.OperationalError: (1045, "Access denied for user 'root'@'localhost' (using password: NO)") Flask CRUD app on Ubuntu with nginx gunicorn
Inside an Ubuntu server, I have my codebase for my flask CRUD app as well as a MySQL database
Here's the code I am running to integrate the database to my flask app:
from flask_mysqldb import MySQL
...
1
vote
0
answers
24
views
python flask and mysql database
please how can i retrieve an image from mysql database and display it in my html website
these are what I have tried:
app.py
@app.route('/customerDetails', methods=['GET', 'POST'])
def customerDetails(...
1
vote
0
answers
39
views
i can't establish connection between db container and my backend, i am using flask with poney orm
i think that everything should be working just as expected but 'the Database object is not bound with a provider yet' rises i don't know where the issue is coming from i attached the full error ...
0
votes
0
answers
33
views
I am making a web app with Flask/ Python, trying to show QR-code in a table, but it is not showing,
I am learning Flask/ Python, i got a problem i cannot resolve myself, i have also tried chatgpt but it says everything is correct (but its not working)
I make a webapp where you can type in your name, ...
0
votes
1
answer
42
views
Using flask to link to mysql
My teacher gave me a task to link a form that takes name and email address made with flask and html. He said to link it to a database in mysql. This data base will store the information received from ...
0
votes
0
answers
32
views
Conversion of hour format in python flask
I want to change the hour format from 24 to 12. This is an attendance project and the following python code linked with HTML to show up the attendance from the database. And this is the code
from ...
0
votes
1
answer
39
views
I want to update a data in mysql table using python , flask , rest api but it doesn't work when I use postman
I created a table in flask_sqlalchemy
class Cafe(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(250), unique=True, nullable=False)
map_url = db.Column(...
1
vote
1
answer
348
views
"Can't connect to MySQL server on 'mysql' ([Errno 111] Connection refused)", but can be started manually
I'm trying to run Docker + Flask + MySQL, and here is my docker-compose.yaml:
services:
dockerflaskexample:
image: dockerflaskexample
build:
context: .
dockerfile: ./Dockerfile
...
0
votes
1
answer
85
views
immediately throw sqlalchemy.exc.OperationalError: (pymysql.err.OperationalError) (2013, 'Lost connection to MySQL server during query')
I encountered a very strange issue where I consistently receive the following exception at a fixed point in my test data when using the db.session.execute('insert into table_a select * from table_b ...