Skip to content
Advertisement

Tag: sqlite

on_guild_join data doesn’t save on my database

I test-ran my code using on_guild_join to fetch data from a server it joined and save it in a specific db file, but when I checked that, it was empty, no data was saved in it. I checked that on_guild_join part was working, and gave all intents. Here’s the code: class for command ‘execute’, ‘multiexec’: Answer In Sqlite3 you need

Good way to “wrap” the opening and closing of a database around functions in Python?

I’ve looked at a few related questions on StackOverflow and at some documentation/guides regarding wrappers, all of which tells me “no,” but this doesn’t seem right. That said, I’m very new to programming, so 🤷‍♂️ Problem: Opening and closing a database (using python/sqlite3) requires a tedious amount of repeated code (as I understand it): So, I tried to write a

TypeError occurs when trying to close Tkinter window in Python

I am currently working on a coursework project for school and it is a database system with a user interface using Tkinter, Python and SQLite3.I made this function to close the window, however the following error is being displayed. I have attached a snippet of the code and a photo of the form. Exception in Tkinter callback Traceback (most recent

How to initialize table for storing different answers on a form with 100 questions (SQLite3 and Python)

So I have just started learning SQLite (never been working with databases before) and I have a table “users”, the table consists of “user_id”, “email”, “age”, “sex”, “password”. I want to ‘link’ (join..?) the “user_id” INT to a user specific (different) table which will contain the users answer to 100 different questions. I want to store the answer for every

Storing images in sqlite – Django

I’m new to Django and databases. Django used the sqlite database as it’s default database. Is it possible to store images in the sqlite database and display it on my webpage? I can’t find any documentation on the official Django website for it. Answer Django’s ImageField and FileField are both just links to the location where the file is actually

How can I get the value of a row in a column in SQLite 3 table with Tkinter Listbox widget?

I have Python program connected to SQLite 3 database with Tkinter on the frontend. My database table (subjectlist) consists of three columns: [id (unique interger), subject (text), serial (unique integer)]. Here is my program: Currently at runtime when I click item on listbox (witch basically shows all subject column values) and then press Tkinter button I get the subject I

How Can My sqllite3 interaction be fixed?

I’m trying to get an admin account to edit a ‘rank’ (basically access level) for one of the profiles in my data-base. The error is: The code that seems to be the problem is: Originally, it was all on one line and it didn’t work, and now I’ve tried it on multiple lines and it still doesn’t work. So I

Peewee – Recursive CTEs – problem with the documentation example – OperationalError no such column: base.id

I have a problem with Peewee-3 and one of the tutorials in documentation: http://docs.peewee-orm.com/en/latest/peewee/querying.html#recursive-ctes When I’m trying to run this code (nearly exact copy from doc) it’s rising an error: Exception has occurred: OperationalError no such column: base.id Here is my code (there is commented part with some testing categories): What am I doing wrong and how can I fix

Advertisement