[edited on 2014-09-22] scraperwiki.sql.save() can't s

I found one! <div class="snippet-clipboard-content notranslate position-relative o

So.. what's the failure? That looks an awful lot like the phrase <code class="notransl

This worked before <a class="commit-link" data-hovercard-type="commit" data-hovercard-

dumptruck extends the typemap if lxml is available: <a href="https://github.com/scrape

Fixed by <a class="issue-link js-issue-link" data-error-text="Failed to load title" da

Can't save lxml strings. about scraperwiki-python HOT 6 CLOSED

sensiblecodeio commented on July 22, 2024

Can't save lxml strings.

from scraperwiki-python.

Comments (6)

drj11 commented on July 22, 2024

I found one!

q = lxml.html.parse('http://lxml.de/lxmlhtml.html').xpath('//td')[0].text_content()

from scraperwiki-python.

pwaller commented on July 22, 2024

So.. what's the failure? That looks an awful lot like the phrase "Ian Bicking" to me.

from scraperwiki-python.

drj11 commented on July 22, 2024

I just dropped that comment in before I caught the train, so at least I wouldn't forget it. It's not actually a string:

>>> scraperwiki.sql.save([], dict(t=q))
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
  File "scraperwiki/sql.py", line 187, in save
    fit_row(connection, row, unique_keys)
  File "scraperwiki/sql.py", line 314, in fit_row
    get_column_type(column_value))
  File "scraperwiki/sql.py", line 353, in get_column_type
    return PYTHON_SQLITE_TYPE_MAP[type(column_value)]
KeyError: <class 'lxml.etree._ElementStringResult'>

from scraperwiki-python.

drj11 commented on July 22, 2024

This worked before dcef2af

from scraperwiki-python.

drj11 commented on July 22, 2024

dumptruck extends the typemap if lxml is available: https://github.com/scraperwiki/dumptruck/blob/master/dumptruck/dumptruck.py#L49

from scraperwiki-python.

drj11 commented on July 22, 2024

Fixed by #67

from scraperwiki-python.

Recommend Projects