Current situation : I have one GUI program(written by python) which using sqlite data stored on my computer. Wishlist: I would like to have one server computer to locate sqlite data (DATA A1) (CRUD operation needed) and ten more client computer using GUI program(written by python) which connect with the sqlit…
Tag: sqlite
How do I select and count records less than 1 year old?
I’m using sqflite in my Flutter application. In this example, date is the actual date(10.06.2021) and DATUM is the datafield in the DB. I keep getting this syntax error: E/SQLiteLog(30657): (1) near “.2021”: syntax error in “SELECT COUNT (*) FROM Shisha_table WHERE (YEAR(10.06.2021) &#…
SQLite Insert Distinct from 2 variables
I have a SQLite DB with a table with the following kind of data: What I need to do is take columns B and C, create a single unduplicated list and autoincrement the primary key for the unique values. It needs to check to make sure an entry is not already existing – so the second table would be: I
Query an AND in a many-to-many table
I know that this is a relatively simple question, I just can’t figure it out. I have three tables: people, presentations, and people_presentations. people and presentations both have ID columns, and people_presentations that has foreign keys to each of people and presentations. For example: people: pres…
Select rows where the title contains any term from a list
I have a datset that has product_id, product_url, email, product_title, etc. I want to pull rows where product_title contains certain adjectives (Fabulous, Stunning, Rare, Amazing, Unique, etc etc. ) from a list of 400+ words. How do I do this without doing a separate select function for each word? I am using…
How to retrieve the properties stored in SQL with multiple inheritance
I’m storing the records in SQL that represent a multiple inheritance relationship similar to the one in C++. Like that: CREATE TABLE Classes ( id INTEGER PRIMARY KEY, name TEXT NOT NULL ); …
Maintain order when using SQLite WHERE-clause and IN operator
Consider the following tbl: For reference, tbl looks like this: When issuing the following statement, the result will be ordered according to ID. However, I need the ordering to adhere to the order of the passed list of values. Here’s what I am looking for: Answer You can create a CTE that returns 2 col…
Insert into with Cursor.executemany and a Python list
Can someone please explain to me what is wrong with this code? I get the “parameters are of unsupported type” error. Is it not possible to feed a list into cursor.executemany? The type of the column is float not null. Answer The values for cursor.executemany must be a sequence of tuples: This is a…
How can I filter records in an SQLite database against a DateTime value that was not supplied?
I have an SQLite database of TimeRecords. When a new record is created, no EndTime is provided. I want to retrieve the first record where the EndTime was not supplied and assign it to a new TimeRecord EndTime is stored as a DateTime variable. My Current Query Calling the Query I have done some research and di…
How do I select rows that are not matched on specific column (sqlite)
Ok hopefully my table works, I’ve never posted here before, but I’m trying to find who has received doses of more than one type of vaccine from this table (all details are dummy data, not real people or id numbers etc) NHI_id fname lname vaccine_name vac_date 16120428 Clayton Marsh Comirnaty 2021-…