search

pudo / dataset

Easy-to-use data handling for SQL data stores with support for implicit table creation, bulk loading, and transactions.
https://dataset.readthedocs.org/
MIT License
4.76k stars 297 forks source link

add function escaping_value #324

Closed byronwanbl closed 3 years ago

byronwanbl commented 4 years ago

add two clauses which are 'istartswith' and 'iendswith' repair some bugs which are in table.Table._generate_clause

pudo commented 4 years ago

Hm, I don't want to add thousands of operators here. I'll do you a trade: add these two if you write documentation for all of the operators. I think the whole system still isn't mentioned in the manual (docs/) :)

Regarding the escaping function: maybe there is something inside SQLAlchemy? We really cannot end up writing escaping code ourselves, it won't cover all databases. If you're trying to handle user input, look at SQLAlchemy's text() function.