walinchus / Chapter_15

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 /tmp/build/requirements.txt (line 6)) [1G Cloning http://github.com/openaustralia/scraperwiki-python.git (to morph_defaults) to /app/.heroku/src/scraperwiki [1G Collecting lxml==3.4.4 (from -r /tmp/build/requirements.txt (line 8)) [1G Downloading lxml-3.4.4.tar.gz (3.5MB) [1G Collecting cssselect==0.9.1 (from -r /tmp/build/requirements.txt (line 9)) [1G Downloading cssselect-0.9.1.tar.gz [1G Collecting dumptruck>=0.1.2 (from scraperwiki->-r /tmp/build/requirements.txt (line 6)) [1G Downloading dumptruck-0.1.6.tar.gz [1G Collecting requests (from scraperwiki->-r /tmp/build/requirements.txt (line 6)) [1G Downloading requests-2.13.0-py2.py3-none-any.whl (584kB) [1G Installing collected packages: dumptruck, requests, scraperwiki, lxml, cssselect [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 cssselect-0.9.1 dumptruck-0.1.6 lxml-3.4.4 requests-2.13.0 scraperwiki [1G [1G [1G-----> Discovering process types [1G Procfile declares types -> scraper Injecting scraper and running... Date Hospital Region Trolley Total Ward Total Total 26/04/2017 Beaumont Hospital Eastern 13 0 13 26/04/2017 Connolly Hospital, Blanchardstown Eastern 3 4 7 26/04/2017 Mater Misericordiae University Hospital Eastern 42 0 42 26/04/2017 Naas General Hospital Eastern 10 4 14 26/04/2017 St James' Hospital Eastern 11 0 11 26/04/2017 St Vincent's University Hospital Eastern 16 0 16 26/04/2017 Tallaght Hospital Eastern 13 7 20 26/04/2017 Bantry General Hospital Country 0 4 4 26/04/2017 Cavan General Hospital Country 4 0 4 26/04/2017 Cork University Hospital Country 32 8 40 26/04/2017 Letterkenny General Hospital Country 19 9 28 26/04/2017 Mayo General Hospital Country 2 2 4 26/04/2017 Mercy University Hospital, Cork Country 14 0 14 26/04/2017 Mid Western Regional Hospital, Ennis Country 0 4 4 26/04/2017 Midland Regional Hospital, Mullingar Country 4 10 14 26/04/2017 Midland Regional Hospital, Portlaoise Country 19 0 19 26/04/2017 Midland Regional Hospital, Tullamore Country 5 2 7 26/04/2017 Nenagh General Hospital Country Country 0 2 2 26/04/2017 Our Lady of Lourdes Hospital, Drogheda Country 20 4 24 26/04/2017 Our Lady's Hospital, Navan Country 2 11 13 26/04/2017 Portiuncula Hospital Country 6 0 6 26/04/2017 Sligo Regional Hospital Country 5 0 5 26/04/2017 South Tipperary General Hospital Country 13 22 35 26/04/2017 St Lukes Hospital, Kilkenny Country 7 14 21 26/04/2017 University College Hospital Galway Country 19 6 25 26/04/2017 University Hospital Kerry Country 2 0 2 26/04/2017 University Hospital Waterford Country 20 5 25 26/04/2017 University Hospital, Limerick Country 30 19 49 26/04/2017 Wexford General Hospital Country 14 0 14 Eastern 108 15 123 Country 237 122 359 Total 345 137 482 Date Hospital Region Trolley Total Ward Total Total 26/04/2017 Beaumont Hospital Eastern 13 0 13 26/04/2017 Connolly Hospital, Blanchardstown Eastern 3 4 7 26/04/2017 Mater Misericordiae University Hospital Eastern 42 0 42 26/04/2017 Naas General Hospital Eastern 10 4 14 26/04/2017 St James' Hospital Eastern 11 0 11 26/04/2017 St Vincent's University Hospital Eastern 16 0 16 26/04/2017 Tallaght Hospital Eastern 13 7 20 26/04/2017 Bantry General Hospital Country 0 4 4 26/04/2017 Cavan General Hospital Country 4 0 4 26/04/2017 Cork University Hospital Country 32 8 40 26/04/2017 Letterkenny General Hospital Country 19 9 28 26/04/2017 Mayo General Hospital Country 2 2 4 26/04/2017 Mercy University Hospital, Cork Country 14 0 14 26/04/2017 Mid Western Regional Hospital, Ennis Country 0 4 4 26/04/2017 Midland Regional Hospital, Mullingar Country 4 10 14 26/04/2017 Midland Regional Hospital, Portlaoise Country 19 0 19 26/04/2017 Midland Regional Hospital, Tullamore Country 5 2 7 26/04/2017 Nenagh General Hospital Country Country 0 2 2 26/04/2017 Our Lady of Lourdes Hospital, Drogheda Country 20 4 24 26/04/2017 Our Lady's Hospital, Navan Country 2 11 13 26/04/2017 Portiuncula Hospital Country 6 0 6 26/04/2017 Sligo Regional Hospital Country 5 0 5 26/04/2017 South Tipperary General Hospital Country 13 22 35 26/04/2017 St Lukes Hospital, Kilkenny Country 7 14 21 26/04/2017 University College Hospital Galway Country 19 6 25 26/04/2017 University Hospital Kerry Country 2 0 2 26/04/2017 University Hospital Waterford Country 20 5 25 26/04/2017 University Hospital, Limerick Country 30 19 49 26/04/2017 Wexford General Hospital Country 14 0 14 Eastern 108 15 123 Country 237 122 359 Total 345 137 482 td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td td Traceback (most recent call last): File "scraper.py", line 18, in <module> scraperwiki.sqlite.save(["td"], record) # save the records one by one File "/app/.heroku/src/scraperwiki/scraperwiki/sqlite.py", line 31, in save dt.create_table(data, table_name = table_name, error_if_exists = False) File "/app/.heroku/python/lib/python2.7/site-packages/dumptruck/dumptruck.py", line 204, in create_table raise ValueError(u'You passed no sample values, or all the values you passed were null.') ValueError: You passed no sample values, or all the values you passed were null.