I’ve been working with Tkinter and I’m trying to get different columns from different tables in my Treeview, I’m using SQLite as database, in my first table called registers i got different columns idcard, name, surname, cellphone, address, email, etc in my second table named attendance I us…
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’, &…
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) req…
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 Tk…
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…
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 …
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 subjec…
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 stil…
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 He…
Convert from Prodigy’s JSONL format for labeled NER to spaCy’s training format?
I am new to Prodigy and spaCy as well as CLI coding. I’d like to use Prodigy to label my data for an NER model, and then use spaCy in python to create models. Prodigy outputs in SQLite format. SpaCy takes in this other kind of format, not sure what to call it: How can I convert from one to