Simple typo.
*con = lite.connect('weewx.sdb')*
-tk
On Mon, Feb 6, 2017 at 3:10 AM, Janez Kranjski <[email protected]> wrote:
> Noob question - I copied weewx.sdb file to temp folder on my Linux (so it
> is not opened or accessible).
> Then I tried simple Python program:
>
> *#!/usr/bin/python*
>
> *import sqlite3 as lite*
> *import sys*
>
> *con = lite.connect('weeex.sdb')*
>
> *with con:*
> * cur = con.cursor()*
> * cur.execute("SELECT * FROM archive;")*
>
> * print(cur.fetchall())*
> *....*
>
> But unfortunately I get an error:
> *Traceback (most recent call last):*
> * File "preberi.py", line 10, in <module>*
> * cur.execute("SELECT * FROM archive;")*
> *sqlite3.OperationalError: no such table: archive *
>
> I can open the same file with SQLiteDatabaseBrowser and I can see records
> and tables (also table "archive").
>
> Any idea what is wrong?
>
> --
> You received this message because you are subscribed to the Google Groups
> "weewx-user" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> For more options, visit https://groups.google.com/d/optout.
>
--
You received this message because you are subscribed to the Google Groups
"weewx-user" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
