My programm is being ran daily and at the end data will be inserted to MySQL DBMS. Usually it took just one and a half minute to complete. Today I have to run again for over 150 days. When programm has gone a half of its journey, this error was raised . I don’t know ..
I have a website for which data is being displayed in real-time. To enter data into the database, currently, I am using selenium to extract the data from other sites and then putting those data into forms and save. This includes various steps and hence delays the process. My question: Is there any process to ..
I have created the data frame "kpssfirmdate" . Then I used sql procedure to deal with two data frames including "kpssfirmdate", but I get an error that kpssfirmdate does not exist. I searched and found some solutions which seem complicated to me. Idk how to handle with that. Any suggestions? How can I connect my ..
I have a simple Flask app like this : simple_app/lib/oracle.py: import cx_Oracle from flask import current_app def create_pool(): # Create session pool pool = cx_Oracle.SessionPool(user=current_app.config[‘USER’], password=current_app.config[‘PASSWD’], dsn=current_app.config[‘DSN’], min=4, max=10, increment=1, threaded=True, getmode=cx_Oracle.SPOOL_ATTRVAL_WAIT) return pool simple_app/routes/init.py: from .hello import hello_bp from .oracle_pdb_backup import oracle_pdb_backup_bp def init_app(app): app.register_blueprint(hello_bp) app.register_blueprint(oracle_pdb_backup_bp) simple_app/routes/hello.py: from flask import Blueprint, jsonify hello_bp = ..
I’m using Django + Postgres on Windows 10 WSL Ubuntu 18.04.5 LTS. Saving data to postgres seems to work, yet when I access the table using psql on the command line, the data isn’t there. Refreshing the webpage (reloading Django) also shows the old data previous to the save. There are no errors in the ..
I’m dealing with a postgresQL connection that was made using as base a singleton meta-class, so, there is no need to reconnect database every time a message is send via websocket. However, if for some reason the connection is lost, I am not able to reconnect anymore. I need a way to make a safe ..
I need to connect to Teradata using Python. The problem I am facing is the long time to connect to database. I am trying with teradata, teradatasql and pyodbc packages in Python. The code I am using is something like: import teradata import teradatasql import pyodbc import time udaExec = teradata.UdaExec (appName="HelloWorld", version="1.0", logConsole=False) try: ..
In my Django project, I use pyodbc==4.0.30 to connect to MSSQL Database. In Database, I’ve created a table valued function that returns data with 19 columns and about 1500 rows. So in SQL Manager that function executes in 4-5 seconds, but in my project it takes 10-15 minutes or even more. So I want to ..
We have a system consisting of two c++ applications (running as exes) and a plotly dash dashboard in python. It is an offline system (dash running on local host), using an sqlite database (in WAL mode) to store data and to interact between the different components. Every C++ component has an open database connection that ..
I want to export the output of my python file to microsoft access, I tried several ways but couldn’t figure out yet. Source: Python..