Error using python and sqlite3

Question

I have a directory (/home/usuario/Desktop/Example) with one database (MyBBDD.db) and the file (script.py) that run the command "UPDATE". If in the terminal I'm in the directory "Example", script.py work fine but if Im not in the directory "Example" and I execute script.py like this: "python /home/usuario/Desktop/Example/script.py" doesnt work fine, the error is: "no such table: name_table". Somebody know what is the problem? Thanks in advance.

Best regards.

code as of comments script.py

import urllib
import sqlite3

conn = sqlite3.connect('MyBBDD.db')
c = conn.cursor()
c.execute ("UPDATE...")
conn.commit()
c.close()
conn.close()

Please show us the code from script.py. Are you using a relative or absolute path in that file? — elethan, Commented Aug 12, 2016 at 16:17
elethan thanks for reply me so fast. script.py is like this: import urllib import sqlite3 conn = sqlite3.connect('MyBBDD.db') c = conn.cursor() c.execute ("UPDATE...") conn.commit() c.close() conn.close() — Tecnico, Commented Aug 12, 2016 at 16:24

Joe Flip · Accepted Answer · 2016-08-12 16:18:19Z

3

When you create a connection object with sqlite3 in script.py, use the absolute file path, i.e.

con = sqlite3.connect('/home/usuario/Desktop/Example/MyBBDD.db')

answered Aug 12, 2016 at 16:18

Joe Flip

1,2054 gold badges23 silver badges39 bronze badges

Yes! Wok fine!! Thanks you very much :)
– Tecnico
Commented Aug 12, 2016 at 16:32

Add a comment |

Collectives™ on Stack Overflow

Error using python and sqlite3

1 Answer 1

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Related