I want to extract the name from a create Table statement for example this: “CREATE OR REPLACE TEMPORARY TABLE IF NOT EXISTS author (” the name here is author. If you look into the official mariaDB documentation you will notice, that OR REPLACE, TEMPORARY and IF NOT EXISTS are optional parameters. …
Tag: mariadb
Packet sequence number wrong – got 1 expected 0
Getting the below error in MariaDb and its causing timeout issue : Debugged it with removing skip-name-resolve, granting privileges to user@localhost, and in pyton create_engine used pool_pre_ping = True and pool_recycle=3600 but nothing seems to solve the issue. MariaDb version is 10.4.20 and Python is 3.9.I…
Flask-SQLAlchemy: ‘Table’ object has no attribute ‘query_by’
I’m developing an API with Flask and I cannot retrieve queries from a MySQL database I’ve connected with flask-sqlalchemy (not sqlalchemy alone). This is a pre-existing database downloaded from my client’s PHPMyAdmin, so I haven’t ran db.create_all(): I simply created the connection st…
How to use flask variable in calling SELECT query in MariaDB
What is the correct syntax for calling a SELECT query in MariaDB from a Registration Form. Specifically, in the WHERE clause. I’ve been looking all over the net to debug this and it does not seem to work (semantically). Here is the code in my python flask. “”The visEmail is the variable that…
Python – Store cryptography keys in SQL database
Working on a “Password Saver” and will be using the module “cryptography” to encrypt the passwords. I need to save the key you generate from cryptography in the database as well, but I am not sure how you actually do this. Done some google searches myself and it seems to be called a &#…
How to parse a LUA Table and push to SQL Database using Python?
I play a game called DCS (Digital Combat Simulator) and was looking to export in game statistics to a database and later recall with PHP on a webpage. The game saves code to a LUA Table and sample data is shown below… Categories show the aircraft type, time in air, planes killed, type of plane, total pl…