The documentation says scraperwiki.sql.select() and scraperwiki.sql.execute() take an

Works for me! <div class="snippet-clipboard-content notranslate position-relative

sql.select and sql.execute functions don't take "?" arguments as documented about scraperwiki-python HOT 1 CLOSED

zarino commented on July 3, 2024

sql.select and sql.execute functions don't take "?" arguments as documented

from scraperwiki-python.

Comments (1)

frabcus commented on July 3, 2024

Works for me!

bat:~/fiddle/s$ ls
bat:~/fiddle/s$ python
Python 2.7.1 (r271:86832, Jun 16 2011, 16:59:05) 
[GCC 4.2.1 (Based on Apple Inc. build 5658) (LLVM build 2335.15.00)] on darwin
Type "help", "copyright", "credits" or "license" for more information.
>>> import scraperwiki
>>> scraperwiki.sql.execute("select ?", 10)
{u'keys': [u'?'], u'data': [[10]]}
>>>

Your CREATE TABLE example doesn't work though :)

Upon inspection, that's because you can't use parameter expansion for table names in SQLite: http://stackoverflow.com/questions/2646705/syntax-error-in-sqlite-net-when-passing-column-name-as-parameter

from scraperwiki-python.

Related Issues (20)

Error on `atexit` event when using only pdftoxml util function HOT 3
Fix test failure in Python 3.5 and up
`unique_keys` doesn't work for buffered data
scraperwiki does not support python version 3.10.7
pdftoxml() docs inconsistent with code HOT 4
pdftoxml in utils.py is not portable to Windows. HOT 3
utils.py uses both urllib2 and requests to make requests HOT 3
cannot `import scraperwiki` on read only directory HOT 3
doubleflush bug HOT 11
No new release since July HOT 2
INSERT OR REPLACE INTO is sqlite-specific HOT 10
Cannot change the columns after the first save. HOT 5
Can't save lxml strings. HOT 6
mysterious "no such table" crash HOT 4
SQLAlchemy error storing empty strings HOT 2
Not Python 3 compatible HOT 6
Unicode column names fail the second time you use them.
sqlalchemy.exc.OperationalError on writing to a table `details` HOT 5
Dependency on pdftohtml HOT 2
sql.save has weird functionality with existing data

sql.select and sql.execute functions don't take "?" arguments as documented about scraperwiki-python HOT 1 CLOSED

Comments (1)

Related Issues (20)

Recommend Projects

React

Vue.js

Typescript

TensorFlow

Django

Laravel

D3

Recommend Topics

javascript

web

server

Machine learning

Visualization

Game

Recommend Org

Facebook

Microsoft

Google

Alibaba

D3

Tencent