morph icon indicating copy to clipboard operation
morph copied to clipboard

PHP version of scraperwiki fails silently when using camel case columns

Open wfdd opened this issue 8 years ago • 4 comments

Camel case column names are automatically converted to snake case upon creation of the table using the RedBean API. Inserts bypass the API and fail as there is no column with the originally-provided camel case name. This failure is silent for reasons beyond my mental grasp.

wfdd avatar Mar 21 '17 22:03 wfdd

Current version of RedBean is pretty old, if you have the background with RedBean. Can you put something together and PR on the changes is highly welcome.

LoveMyData avatar Oct 04 '17 03:10 LoveMyData

Sorry, I don't use PHP with morph - I'd just been asked by an acquaintance to look into why his scraper was failing.

wfdd avatar Oct 05 '17 16:10 wfdd

@wfdd - I don't use PHP on morph either, but if I want to use a more recent version of a python package in morph, I can just specify a newer version in my scraper's requirements.txt and the more recent package will be used instead of the globally installed one. Can your friend fix his scraper by pulling in a more recent version of the library in his scraper's composer.json ?

chris48s avatar Oct 05 '17 17:10 chris48s

No, RedBeans is bundled with scraperwiki and has not received an update in 5 years. Also scraperwiki is the 'blessed' scraping lib here on morph so it ought to receive bug fixes from upstream.

wfdd avatar Oct 05 '17 17:10 wfdd