I try to update my sqlite database using flask webhook. It seems commands line work fine if I type manually in the python console but my flask webhook didn’t update my SQLite database. It seems the apps fail at the “cursor.execute()” line. here is my webhook code: Can you please tell me what…
Tag: sqlite
Sqlite table reverting to old data after about a hour inactivity
I made my own counting bot on discord to practice coding. The bot will work fine if messages are sent within about an hour of the last message. After a hour sometimes my bot will work, sometimes won’t and the data on my sqlite table will be reverted to previous data. This causes the bot to think that th…
Limiting number of unique dates selected in SQLite3 SELECT Query
So basically, this is a SQLite3 table that I have: Click Here for Image As you can see in the image, there are 8 distinct dates, going from 29/07/2021 to 05/08/2021. I want to run a SQLite3 Query that returns only the latest 7 out of these 8 dates (i.e. 30/07/2021 to 05/08/2021) BUT it returns all the rows fo…
Sqlite3 Programming Error -> SQLite objects created in a thread can only be used in that same thread
Im programming for my friend a website like youtube. But I always get this error when i go to http://localhost:2389/watch.v=f4efc9de771d4aba85ee0a88bbce08b9 This is the server code: and this is the database helper: And this is the error: I hope someone can help me. Answer I found the problem. I have to do thi…
KeyError when there exists a key
Using Tweepy, I was trying to live stream the Tweets and save it into database sqlite but as soon as I load the JSON file and store into database the error keeps on occurring saying KeyError : created_at but there already exists a key created_at. I tried with others too, but still the error persists. Here is …
How to correctly set the SQLITE_MAX_VARIABLE_NUMBER from a connection?
I’m using Peewee and obtain my connection from an URL like this: How can I correctly increase the SQLITE_MAX_VARIABLE_NUMBER? I am stuck in an older 2.x SQLite version and can’t upgrade unfortunately … corporate policies. I am aware that the latest versions of SQLite have increased the defau…
Any way to censor Treeview Data Display?
I am able to use SQLite3 as the database (DB) and get Treeview to display data from the DB. However, I was wondering whether Treeview has any functionality to censor the first few characters in a certain column for all entries? Here is the lean code: I can get variables from the Entry Widget (with Tkinter) to…
SQLite fetch until
I have a question about SQL. I have the following sample table called Records: record_id subject start_timestamp end_timestamp interval 2 Start Product 2 2021-04-21T16:22:39 2021-04-21T16:23:40 0.97 3 error 1 2021-04-21T16:25:44 2021-04-21T16:25:54 10.0 4 End Product 2 2021-04-21T16:30:13 2021-04-21T16:30:14 …
django.db.utils.OperationalError: no such function: JSON_VALID
I literally don’t know how to deal with it and how it is happening I am getting this error when I run python manage.py migrate, migrations were without an error. Mycode models.py views.py full command line error If you are able to solve the issue then answer and along with it also tell me any issue in m…
How to create a JSON file from SQL query?
I am creating a JSON file from a SQL query. But I could not create truly. The problem is there is a “items” object and it has products. But mine create products directly not in “items” objects. The Code. yields the following JSON object as a result while the desired one should be as fo…