Category "sqlite"

How to link deletion in room data

I have two data base or two tables ex:one for matches and one for chat jn event section in match note that the all messages is inserted in one table mean that e

SQLite3 clear changes() for transaction

I am looking to clear the amount of changes() at the start/end of every transaction. ## self.t = True if MySQL, False if SQLite ## self.cur = (pymysql/sqlite).c

ERRor:%android.database.CursorIndexOutOfBoundsException: Index 10 requested, with a size of 10%

Here is the complete code.. So the problem is that if there are 9 records in the table and by clicking on the ButtonNext , the application does not crash and di

my kivy app is all right on my computer, but don't show its content on my phone

My kivy project can run correctly on my computer, but if I use package logging to log, the project will not start application main loop on my phone. The followi

Best way to work with a small db in swift ios app from a performance point of view?

I'm using an sqlite db to populate an ios app with data about irregular verbs -- it's a language learning app. The db has 3 tables, verb categories, verbs, and

Recursive query which aggregates child items in sqlite3

I have a table of parent-child relationships: CREATE TABLE item_parent(item_hash, parent_hash); CREATE UNIQUE INDEX item_parent_unique ON item_parent(item_hash,

Dynamic table name in Ruby sqlite query based on class name

I have a parent class that looks like this: class Record attr_accessor :id, :url, :votes, :title, :first_name, :last_name, :selfdb def initialize(args

Django 4: Product.objects.get(id=1) returns an error "DoesNotExist" but I already have 7 products listed

I already have 7 products listed in my DB and I can check them by Product.objects.all() but when I do Product.objects.get(id=1) or pass any id as a parameter it

Error trying to create a database: sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file

I'm trying to create a database using Flask and Sqlite3, I am not sure this error is about the file path, as you can see in my code I have tried out different w

How to change the database local to be in a cloud (Django)

I wrote a project in django framework and I use the local DataBase SQLite, and I now want to upload it to the cloud so other people who work with me can access

Merging CSVs into one sees exponentially bigger size

I have 600 CSV files of size ~1Mo for a total of roughly 600Mo. I want to put all of them into a sqlite3 db. So my first step would be to merge them into one bi

Flask-Login: Redirect to page after login

**The problem was in this code lgin enter image description here You only needed to delete 1 line (<form metod="POST" action="/singup") to make everything wo

Field value not persisted after import

Model.py class Order(models.Model): customerID = models.CharField(max_length=300, blank=True, null=True) osm_bol = models.CharField(max_length=300, bla

How to upload into and download from SQLite database doc file in C# .NET?

I have decided to develop desktop program with usage of SQLite datatbase and with help of C# programming language. One of the necessary functions that must be p

How can I solve error gypgyp ERR!ERR! find VSfind VS msvs_version not set from command line or npm config?

I want to run this project : https://github.com/adonis-china/adonis-adminify When I run npm install, there exist error : > [email protected] install C:\larag

searching in range between columns using sqlite3 in pandas

I have found solution to my problem in one question Merge pandas dataframes where one value is between two others I tried to modify it for my situation but it d

SQL convert output from integer to float

The numbers in my results are of type integer, but I want to convert them to float. import sqlite3 connection = sqlite3.connect("mydatabase.db") my_cursor = con

SQL query to get what percentage of product categories have never been sold

I have the below 4 tables with relationship # sales # products +------------------+---------+ +------------------

Invalid Class name driver JDBC SQLite

I have this error "Unable to get connection, DataSource invalid: "java.sql.SQLException: No suitable driver found for /Users/testdb.db" when trying to select q

How to get rid of sqlalchemy.exc.NoReferencedTableError?

Here's some code related to the problem: db_session.py import sqlalchemy as sa import sqlalchemy.orm as orm import sqlalchemy.ext.declarative as dec SqlAlchemy