Category "sqlite"

How to write SQL sub-query in SQL?

Here is sample data I am looking for total buying trade value and total selling trades value based on country. Here are two tables, country, and trades Table [c

findAll() returns empty with WHERE option

First question on StackOverflow, long time reader first time poster or whatever people say. I'm developing a Discord bot in my free time using Discord.js, and I

.NET Core Entity Framework how to map nested class into one sql table

I'm still new to .NET Core. I have this character that I want to store in SQLite using an entity. But by default, Character, CharacterData and CharacterLine are

Sequelize. SQLite Type checking

I started using Sequelize with SQLite. When I try to insert or update a value, it doesn't check for type-errors. For example I can use string values in a column

SQLite: Selecting all fields with a similar foreign key

I'm new to SQL and the SQLite library and was wondering how to select all fields in a table with a similar foreign key def retrieveOriginalQes(category): co

sqlite cannot connect to database error: java.lang.UnsatisfiedLinkError: org.sqlite.core.NativeDB._open_utf8([BI)V

I get the following error: I have this code I have tried several things going before I posted this, I determined that this was the source error it did not conne

SQLite3 database is Locked in Azure

I have a Flask server Running on Azure provided by Azure App services with sqlite3 as a database. I am unable to update sqlite3 as it is showing that database i

What could cause a sqlite application to slow down over time with high load?

I'll definitely need to update this based on feedback so I apologize in advance. The problem I'm trying to solve is roughly this. The graph shows Disk utilizat

Can't call / pass data from django database onto website using built in auth model and a model I created, which is the one I cant query

Any help would be appreciated, basically I am a beginner and I'm struggling to pull data from my database. I used the built in auth method from django, which s

SQLAlchemy: delete rows from associate table from many-to-many relationship

I noticed that when deleting one entry, the corresponding rows from the secondary table are not deleted. here my models: cashflows_tags_table = Table( "cash

On delete cascade on foreign key not working [duplicate]

I am doing a TODO list app and I'm trying to delete a list and every task which has the referencing listID.The problem is that on delete casca

How to Import a SQL file to Python

I'm attempting to import an sq file that already has tables into python. However, it doesn't seem to import what I had hoped. The only things I've seen so far a

Python 3.x Tortoise-orm Delete all values inside the database SQLite

So I've recently starting learning about tortoise-orm. But I have a question: How would I get all the data inside the SQLite database and delete all of them? E

Unfindable SQLite Syntax Error

I'm trying out statements for creating a database, and after 10 entities without any issues I ran into this error Error: Near line 83: near "Transaction":

SQL query returns result multiple times

I'm pretty new to SQL and am trying to join some tables in SQL. I'm using SQLite3 and Pandas and have the following table structure: User | Measuremen

SQL query returns result multiple times

I'm pretty new to SQL and am trying to join some tables in SQL. I'm using SQLite3 and Pandas and have the following table structure: User | Measuremen

row with max value per group - SQLite

Given a table with columns(name, lat, lon, population, type) where there are many rows for each name, I'd like to select the rows grouped by name where populati

django.db.utils.IntegrityError: NOT NULL constraint failed after reseting migrations

I need to save an object that contains a file and some other data. Although the file is stored on the /media folder, the entity is not saved in the database sin

Unable to find source of: ERROR [root] Error: Can't locate revision identified by '..'

I am trying to run migrations from command line and keep getting error: ERROR [root] Error: Can't locate revision identified by 'faf3ebfbe667' As suggested in

Pre-packaged database has an invalid schema error

I'm building an Android application based on an old Android project. In my new application I'm using Room. I have to use the same database that is used in the

Other Categories