Questions tagged as 'sqlite3'

Tagged questions
1
answer

How can I create a dynamic database in pyhton [closed]

Can anyone help me with how to create a dynamic database, where can I add and remove items? In the Python language, if possible with Sqlite     
asked by 10.05.2018 / 22:01
1
answer

error in path to connection to bank [duplicate]

I'm trying to add this path to the connection to the database, and it gives me this error: File "C:/Users/gabri/PycharmProjects/allbd_s/conc.py", line 4 path='C:\Usuario\gabri\SQLite\conx' ^ SyntaxError: (unicode error) 'unicodee...
asked by 06.09.2018 / 03:05
1
answer

Is there any way to change a column of an existing table to "auto increment"?

I created a table in Sqlite3, however I forgot to add AUTO INCREMENT to column id . I tried to use ALTER TABLE to solve the problem, but I still could not. In SQLITE, is it allowed to define a column as auto increment...
asked by 04.01.2017 / 12:06
1
answer

What are the main programming languages that integrate SQLite? [closed]

What are the main programming languages that integrate SQLite as a DBMS in your code?     
asked by 05.11.2015 / 05:03
1
answer

Python does not insert data into sqlite3

I have the following code: #!/usr/bin/python3 import sqlite3 app = '/backup/app/' bd = app + 'bd/' contato_banco = bd + 'contato.db' contato_tab = (('nome' , 'TEXT'), ('email' , 'TEXT'), ('whatsapp' , 'INT'), ('mensagem' , 'TEXT')) c = 'Enio...
asked by 23.08.2018 / 19:38
1
answer

How to delete a table row in sqlite3?

I am trying to make a crud in sqlite3 with a GUI through tkinter my table was created in DB Browser for sqlite. I have developed a little but it is not working: from tkinter import * from tkinter import ttk import sqlite3 #db_name = 'bancoda...
asked by 31.08.2018 / 01:58
1
answer

2 calls to the same table in SQLite (output different than expected)

Given the following 2 tables: CREATE TABLE IF NOT EXISTS sugestoes ( id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, texto VARCHAR(250), autor VARCHAR(250), itens VARCHAR(250), pontos INTEGER ); CREATE TABLE IF NOT...
asked by 02.06.2018 / 10:07
2
answers

Format year in SQLite

I need to format a timestamp in the following format: DDMMYYHHMMSS I was able to use strftime , for example: select strftime("%d%m%Y%H%M%S", current_timestamp) from stream; But this way it shows 4 digits for the year and I only need...
asked by 30.03.2018 / 21:00
2
answers

How to create relationship tables 1: N?

I have already studied database and understand how the diagramming of this type of relationship works, but now that I am trying to implement this database using sqlite3 and python I have seen some problems. I have the following database Theprob...
asked by 23.03.2017 / 18:22
2
answers

PHP Fatal error: Uncaught Error: Class 'SQLite3' not found in / var / www / html /

I have the supposedly simple code below. The intuit is to create a table include values and soon after show the information, but in log apache is showing the following: [:error] [pid 17622] [client 10.1.21.1:42895] PHP Fatal error: Uncaugh...
asked by 14.03.2017 / 16:47