jonasmerlin / german_ov_from_google

Last run failed with status code 1.

Console output of last run

Injecting configuration and compiling... [1G [1G-----> Python app detected [1G-----> Installing python-2.7.9 [1G $ pip install -r requirements.txt [1G Obtaining scraperwiki from git+http://github.com/openaustralia/scraperwiki-python.git@morph_defaults#egg=scraperwiki (from -r requirements.txt (line 6)) [1G Cloning http://github.com/openaustralia/scraperwiki-python.git (to morph_defaults) to ./.heroku/src/scraperwiki [1G Collecting lxml==3.4.4 (from -r requirements.txt (line 8)) [1G Downloading lxml-3.4.4.tar.gz (3.5MB) [1G Collecting cssselect==0.9.1 (from -r requirements.txt (line 9)) [1G Downloading cssselect-0.9.1.tar.gz [1G Collecting beautifulsoup4 (from -r requirements.txt (line 10)) [1G Downloading beautifulsoup4-4.5.1-py2-none-any.whl (83kB) [1G Collecting dumptruck>=0.1.2 (from scraperwiki->-r requirements.txt (line 6)) [1G Downloading dumptruck-0.1.6.tar.gz [1G Collecting requests (from scraperwiki->-r requirements.txt (line 6)) [1G Downloading requests-2.12.1-py2.py3-none-any.whl (574kB) [1G Installing collected packages: dumptruck, requests, scraperwiki, lxml, cssselect, beautifulsoup4 [1G Running setup.py install for dumptruck: started [1G Running setup.py install for dumptruck: finished with status 'done' [1G Running setup.py develop for scraperwiki [1G Running setup.py install for lxml: started [1G Running setup.py install for lxml: still running... [1G Running setup.py install for lxml: finished with status 'done' [1G Running setup.py install for cssselect: started [1G Running setup.py install for cssselect: finished with status 'done' [1G Successfully installed beautifulsoup4-4.5.1 cssselect-0.9.1 dumptruck-0.1.6 lxml-3.4.4 requests-2.12.1 scraperwiki [1G [1G [1G-----> Discovering process types [1G Procfile declares types -> scraper Injecting scraper and running... Traceback (most recent call last): File "scraper.py", line 44, in <module> scraperwiki.sqlite.execute("DELETE * FROM data"); File "/app/.heroku/src/scraperwiki/scraperwiki/sqlite.py", line 19, in execute result = dt.execute(sqlquery, data, commit=False) File "/app/.heroku/python/lib/python2.7/site-packages/dumptruck/dumptruck.py", line 136, in execute self.cursor.execute(sql, *args) sqlite3.OperationalError: near "*": syntax error

Data

Downloaded 3 times by jonasmerlin

To download data sign in with GitHub

Download table (as CSV) Download SQLite database (10.4 MB) Use the API

rows 10 / 57284

tag zeiten stadt film kino typ
2016-10-15
14:00,17:00,20:15,23:10
Berlin
Inferno (OV)
CineStar Berlin - Original.
2016-10-15
14:00,15:00,17:40,20:30,23:10
Berlin
Findet Dorie (OV)
CineStar Berlin - Original.
2016-10-15
13:50,16:45,19:50,23:15
Berlin
Die Insel der besonderen Kinder (OV)
CineStar Berlin - Original.
2016-10-15
14:10,16:30,19:30,23:00
Berlin
Snowden (OV)
CineStar Berlin - Original.
2016-10-15
17:15,20:20
Berlin
Sausage Party - Es geht um die Wurst (OV)
CineStar Berlin - Original.
2016-10-15
20:00,22:30
Berlin
Swiss Army Man (OV)
CineStar Berlin - Original.
2016-10-15
16:30,19:30
Berlin
American Honey (OV)
CineStar Berlin - Original.
2016-10-15
22:30
Berlin
War Dogs (OV)
CineStar Berlin - Original.
2016-10-15
14:00,17:10,19:40
Berlin
Bad Moms (OV)
CineStar Berlin - Original.
2016-10-15
22:45
Berlin
Die glorreichen Sieben (OV)
CineStar Berlin - Original.

Statistics

Average successful run time: about 1 hour

Total run time: 1 day

Total cpu time used: about 2 hours

Total disk space used: 10.5 MB

History

  • Auto ran revision 24172b17 and failed .
    nothing changed in the database
  • Auto ran revision 24172b17 and failed .
    nothing changed in the database
  • Auto ran revision 24172b17 and failed .
    nothing changed in the database
  • Auto ran revision 24172b17 and failed .
    nothing changed in the database
  • Auto ran revision 24172b17 and failed .
    nothing changed in the database
  • ...
  • Created on morph.io

Show complete history