Python sqlite3 error- the database is encrypted

Question

I'm trying to query a data base in the form of an SQL file I have downloaded on my computer to use the data in a machine learning project. I've looked at the database source code, and there is no password setting statement, so I'm very confused at the error I keep getting, which is 'DatabaseError: file is encrypted or is not a database.'

import sqlite3 as lite

con  = None
con = lite.connect('haiku1aip1.sql')
cur =  con.cursor()
cur.execute('SELECT * FROM haiku1aip1')
rows = cur.fetchall()
poems = []
for row in rows:
    poems.append(row)
print(poems)

Is haiku1aip1.sql a sqlite database or something else (like a text file full of SQL statements)? — Shawn
– Shawn, Commented Dec 12, 2018 at 17:58

avojak · Accepted Answer · 2018-12-12 18:02:46Z

1

con = lite.connect('haiku1aip1.sql')

This line is trying to connect to a database named "haiku1aip1.sql", but .sql is not the correct file extension for a database file. Your database file would end in .db.

.sql files contain SQL queries, inserts, and other statements (similar to your "SELECT * FROM haiku1aip1" query).

answered Dec 12, 2018 at 18:02

avojak

2,3503 gold badges30 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

anonymous_duck Over a year ago

So would the solution be to create the data base from the file of sql commands I have, and then to access it with this code, with the exception of changing the file extension like you mentioned?

avojak Over a year ago

@anonymous_duck It depends on what statements are inside the SQL file. Is it queries (eg. SELECT ...)? Or does it also create tables or insert data (eg. CREATE ..., INSERT ...)?

Collectives™ on Stack Overflow

Python sqlite3 error- the database is encrypted

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related