Recent questions tagged sqlite

1 vote

1 answer

How do I delete multiple rows from a table?

How do I delete multiple rows from a table? Hello, everyone! There are several columns in the table, one of them with the date of the species: 2020-09-27T17:00:00.000Z. I need to delete several rows with old dat ...

by isergeevich666

asked Sep 24, 2021

1 vote

1 answer

How to process Django form data?

How to process Django form data? I'm making my own project and studying Django at the same time. Project goal: Make a convenient mechanism for slicing IP-networks for the necessary masks. Keep a record ...

by 0ldn0mad

asked Sep 24, 2021

1 vote

1 answer

How to work asynchronously with sqlite3?

How to work asynchronously with sqlite3? Hello! I can't figure out the database in nodejs. On the input: the list of pages to be parsed is stored in the database The script goes to the page gets the necessar ...

by jslby

asked Sep 24, 2021

1 vote

1 answer

How do I access the last row in a sqlite table with django?

How do I access the last row in a sqlite table with django? Good afternoon, I need to access the last item in the sqlite database through django by using User.objects.values()-1.get(id), but negative indexing is not supported i ...

by Andrei1penguin1

asked Sep 24, 2021

1 vote

1 answer

Why is only the first table value updated?

Why is only the first table value updated? There is a code like: for i in cursor.execute(f"PRAGMA table_info(userResource)"): if y < 2: y+=1 else: cursor.execute(f"UPDATE userResource SET {i} = 0 WHERE I ...

by kibergile

asked Sep 22, 2021

1 vote

1 answer

How do I output a value to sqlite3?

How do I output a value to sqlite3? how do I find all the rows in the database, where user_id = msg.chat.id. Code below user_id = msg.chat.id.#тут коннект к бдcur.execute("SELECT balance FROM orders WHE ...

by srgvac

asked Sep 21, 2021

1 vote

1 answer

How do I solve the problem in telebot/sqlite3?

How do I solve the problem in telebot/sqlite3? How do I get all the people who started the bot into the database? import sqlite3import telebotbot = telebot.TeleBot('Токен')db = sqlite3.connect('TG.db', check_same_t ...

by MrSel

asked Sep 20, 2021

1 vote

1 answer

Can I use comparative operations in WHERE-sqlite?

Can I use comparative operations in WHERE-sqlite? Can I use comparative operations in WHERE? For example <=, >=, != ? If so, what is the correct use case? ...

by mlneko

asked Sep 20, 2021

1 vote

1 answer

What caused the error?

What caused the error? Hi Here is the error itself: File "C:\Users\fyodrro\AppData\Local\Programs\Python\Python38-32\lib\site-packages\telebot\util.py", line 60, in run task(args, kwargs ...

by srgvac

asked Sep 20, 2021

1 vote

1 answer

How do I compare data from a table with zero?

How do I compare data from a table with zero? Tell me how you can compare data from a table with zero There is such a code: @bot.command(aliases = 'warn')async def __warn(ctx, member: discord.Member = None, arg: ...

by delam0re

asked Sep 20, 2021

1 vote

1 answer

What is the best datatype to use for the key in SQL?

What is the best datatype to use for the key in SQL? The PRIMARY KEY column stores the IMEI. What is the best datatype to make SELECT/UPDATE with WHERE by key faster? You can essentially put INT, since there are only nu ...

by TomRiddle

asked Sep 19, 2021

1 vote

3 answers

I want to create an app to prepare for the exam on the android using java, what technology stack should I learn?

I want to create an app to prepare for the exam on the android using java, what technology stack should I learn? is the topic of my thesis, in the application should be to study materials and tests with questions and answer options, that is, the user first learns the material, then ...

by Tillthecoyote

asked Sep 19, 2021

1 vote

3 answers

How do I add information to a sqlite3 table?

How do I add information to a sqlite3 table? I'm wondering if it's possible to add text to a sqlite3 cell if the cell already has information written in it. If so, how?) ...

by swpavlov

asked Sep 18, 2021

1 vote

2 answers

Why is the SQLite3 record not deleted?

Why is the SQLite3 record not deleted? You need to delete the clan_id entry. cursor.execute("DELETE clan_id FROM clans WHERE owner_id = {}".format(ctx.author.id)) Error: sqlite3.OperationalError: near "clan_ ...

by 20two_may

asked Sep 18, 2021

1 vote

2 answers

C#: Import a large csv file into a SQLite database. How to do this?

C#: Import a large csv file into a SQLite database. How to do this? Give me a good way to migrate big data (1 million rows, 12 columns) from csv file to SQLite database (without iterating in loop, slow and inefficient). ...

by Samyrro054

asked Sep 17, 2021

1 vote

2 answers

How do I check for a specific number in a database (SQLite)?

How do I check for a specific number in a database (SQLite)? I have a sqlite database with the following columns: telegram_id, username, status How to make the database is searched for all tables where the status is 3. If = 3 the ...

by pythonnovi4ok

asked Apr 4, 2021

1 vote

6 answers

What is the best way to put a sqlite base on the network?

What is the best way to put a sqlite base on the network? You need to place the sqlite base on a resource that is connected to the network. Now I use sshfs (the choice is random) and experience frequent base crashes, which so f ...

by Insaned

asked Apr 4, 2021

1 vote

1 answer

Why doesn't the migration to SQLITE create a foreign key?

Why doesn't the migration to SQLITE create a foreign key? Listen, people, faced with this country bullshit, I want that clever people enlighten me. I have ORM Doctrine and a sqlite database in my project The essence looks like ...

by MasterCopipaster

asked Apr 1, 2021

1 vote

2 answers

Why am I getting the error "sqlite3.OperationalError: no such column: test"?

Why am I getting the error "sqlite3.OperationalError: no such column: test"? There is a table cursor_voice.execute("""CREATE TABLE IF NOT EXISTS voice_data( c_name TEXT, c_id INT, v_name TEXT, v_id INT ...

by old_stalin

asked Apr 1, 2021

1 vote

2 answers

Where does "No such column" in SQLite3 come from?

Where does "No such column" in SQLite3 come from? There is a block of code like this: import sqlite3sql.execute("""CREATE TABLE IF NOT EXISTS users ( login TEXT, password TEXT, сash INT)""")db.commit()db = sqli ...

by paralolik

asked Mar 30, 2021