Category "sqlite"

Name from other page included in other page is not displayed

In my application, I would like to include the name, entered by the user, at page one, to the second page. But when I paste the jinja print "{{ data }}" to the

How to synchronize a windows folder in python flask app with a sqlite database table?

I am looking for a solution to compare filenames inside sqlite database with filenames in a windows directory (app.config['UPLOAD_FOLDER']). I have a sqlite da

LateInitializationError: Field '_children@51042623' has not been initialized

[![LateInitializationError: Field '_children@51042623' has not been initialized][1]] I'm having this problem when i add items to a List from page 2 to page 1 [1

“Unable to load DLL 'SQLite.Interop.dll' or one of its dependencies” running an application in Docker, but locally it works fine

Introduction There seems to be frequent issues with the SQLite.Interop.dll library. Just look at these other StackOverflow questions: Unable to load DLL 'SQLite

SQLite find a UUID and change value in row (Minecraft plugin)

I have a question about SQLite in bukkit encoding. I'm trying to figure out how to find a player in the database using a UUID and change values ​​(s

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