sensiblecodeio / scraperwiki-python

ScraperWiki Python library for scraping and saving data
https://scraperwiki.com
BSD 2-Clause "Simplified" License
159 stars 69 forks source link

[Inconsistency in scraperwiki.sqlite.get_var before save_var. #7

Closed tlevine closed 12 years ago

tlevine commented 12 years ago

@scraperdragon posted this to the dummy repository issue tracker, so I copy it here.

On Scraperwiki Classic:

import scraperwiki
print scraperwiki.sqlite.get_var('kitten')
returns None.
On boxes:
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "/usr/local/lib/python2.7/dist-packages/src/scraperwiki-local/scraperwiki/sqlite.py", line 66, in get_var
return dt.get_var(name)
File "/usr/local/lib/python2.7/dist-packages/src/dumptruck/dumptruck/dumptruck.py", line 273, in get_var
data = self.execute(u'SELECT * FROM %s WHEREname= ?' % vt, [key], commit = False)
File "/usr/local/lib/python2.7/dist-packages/src/dumptruck/dumptruck/dumptruck.py", line 107, in execute
self.cursor.execute(sql, *args)
sqlite3.OperationalError: no such table: swvariables
tlevine commented 12 years ago

Fixed! 680bcf5334e995d0b47e05401ccfcaba20fcf99d