i have a problem with the importation of sql

Question

import sqlite3
connection = sqlite3.connect('database.db')
with open('crea_posts.sql') as f:
    connection.executescript(f.read())
connection.commit()
connection.close()

debug

Traceback (most recent call last):
  File "C:\Users\Tamarrino\Desktop\flask app\init_db.py", line 4, in <module>
    connection.executescript(f.read())
sqlite3.OperationalError: 1 values for 2 columns

this is the crea_post.sql

DROP TABLE IF EXISTS posts;

CREATE TABLE posts (
    titolo TEXT,
    info TEXT
);

INSERT INTO posts (titolo, info) VALUES (
    'Lava la macchina',
    'Lava accuratamente la carrozzeria e gli interni'
);
INSERT INTO posts (titolo, info) VALUES (
    'Lava il frigo'
);
INSERT INTO posts (titolo, info) VALUES (
    'Porta la macchina dal meccanico'
    'Guasto al motore'
);

can you share the sql query also? have you tried running the query inside `crea_posts.sql` manually? Does it run successfully? — RMT, May 09 '23 at 22:09
to me this is arabic. Can you give me step by step instructions? — Antonio Trirocco, May 09 '23 at 22:17

score 0 · Accepted Answer · answered May 09 '23 at 22:27

0

I think you are missing a comma in the last values of the insert. It should be

INSERT INTO posts (titolo, info) VALUES ( 'Porta la macchina dal meccanico', 'Guasto al motore' );

answered May 09 '23 at 22:27

RMT

105
8

this is the debug Import "flask" could not be resolved – Antonio Trirocco May 09 '23 at 22:33
try adding `import flask` at the top of your script. If you still get an error, check if flask is installed or not. You can run `pip install flask` in the command prompt window. – RMT May 09 '23 at 22:35
ok thanks, it works you are my hero – Antonio Trirocco May 09 '23 at 22:38

i have a problem with the importation of sql

1 Answers1