So I’m writing a program that stores info in a database file using sqlite3 and I’m adding a feature to allow me to delete the files, but once I access the files I get this error which stops me from ...
databaseanswers.net Latest Questions
I’m having trouble using the combobox in an external file. Basically the combobox is in the main file and I would like to use its selected value in the external file. If I select a certain item, it should help ...
I have the following function that runs automatically with cronjob, it makes predictions based on an anomaly detection model and it saves the results to a postgres database: def prediction_job(): """ This job will run ...
i have a project in python. my goal in the project is to compare the prices I have scraped on amazon with the prices in mysql. if the new price is lower than in mysql, I want to send a message to ...
I’ve to make a sql with aggregation from a field (date) with this format: executionDate: 2022-08-22T22:15:55.383+00:00 The value of this field always ends with "+00:00" I tried to execute the below aggregation but it’ doesn’t work: 'executionDate': { '$lte': ...
I am using Django ORM query with Extra params. when I try to print the SQL query relevant to that ORM Query,i am getting the below Error message. ORM Query: Record = SAMPLE_TABLE.objects.extra(where=["REPLACE(Message,’ ‘,”) "+whereCaseSensitive+" like %s "+query],params=[duplicateCheckMessage]).filter(~Q(iStatus=2),~Q(iAppStatus=2),iEntityID=entityId,iTemplateType=1).first() Message – FieldName , whereCaseSensitive ...
I am currently working on a new project. Trying to install the requirements using pip but getting this error. Using python version 3.6.9 This is the error message I am getting. Collecting en-core-web-sm@ https://github.com/explosion/spacy-models/releases/download/en_core_web_sm-3.4.0/en_core_web_sm-3.4.0-py3-none-any.whl Downloading https://github.com/explosion/spacy-models/releases/download/en_core_web_sm-3.4.0/en_core_web_sm-3.4.0-py3-none-any.whl (12.8 MB) ...
I’m using Python SQLAlchemy 1.4.xx to write changes to a database and last night I lost about 12 million rows across different tables, which hurts my soul. Before this morning I could access, manipulate, read, write, and other normal db ...
I’m trying to scrape data from an .idx file and import the data into the table I created in SQL. for row in content: if len(row)!= 0: ...
If in the combobox I select the element Drake, I would like to check if this element is present in the database (SQLite) in the name field. What am I doing wrong? I do not receive errors, but I print "ok" ...