In Canopy it seems I cant write in the BDName.sqlite sitting in the same location as run-file

Question

In Canopy v2.1.1 ( Python 3.5.2) it seems I cant write in the DataBaseName.sqlite sitting in the same location as run-file?!

I am testing for file and file is FOUND fine:

> if (os.path.isfile(db_loc_1)):

But cant execute Query

> db.execute (sql_query_str)

I get

sqlite3.OperationalError: no such table

Thanks. -PL

It seems in a way this thread answered my issue : https://stackoverflow.com/a/28126276/7613463 — Polta Lashka, Jun 01 '17 at 18:17

score 0 · Accepted Answer · answered Jun 01 '17 at 21:02

0

in a way this thread answered my issue...

Yes, and the code described there is good practice for a working program.

However if you are just playing around at the command line, an easier solution is to change the working directory to match where you are running the script. This is done from the drop-down menu at the upper right of Canopy's Python panel. See: http://docs.enthought.com/canopy/2.1/quick-start/code_editor.html#change-directory

answered Jun 01 '17 at 21:02

Jonathan March

Thanks for your valuable comment Jonathan, this would be a very hand feature going fwd. – Polta Lashka Jun 02 '17 at 01:12
Sorry, I don't understand "would be a very handy feature". This *is* a feature and it answers your question as far as I understand it. – Jonathan March Jun 02 '17 at 21:53
You got it @Jonathan – Polta Lashka Jun 07 '17 at 14:35

1 Answers1