Ensures `a` is quoted properly for use in a SQL query. >>> 'WHERE x = ' + sqlquote(True) + ' AND y = ' + sqlquote(3) >>> 'WHERE x = ' + sqlquote(True) + ' AND y IN ' + sqlquote([2, 3])
(a)
| 445 | |
| 446 | |
| 447 | def sqlquote(a): |
| 448 | """ |
| 449 | Ensures `a` is quoted properly for use in a SQL query. |
| 450 | |
| 451 | >>> 'WHERE x = ' + sqlquote(True) + ' AND y = ' + sqlquote(3) |
| 452 | <sql: "WHERE x = 't' AND y = 3"> |
| 453 | >>> 'WHERE x = ' + sqlquote(True) + ' AND y IN ' + sqlquote([2, 3]) |
| 454 | <sql: "WHERE x = 't' AND y IN (2, 3)"> |
| 455 | >>> 'WHERE x = ' + sqlquote(True) + ' AND y IN ' + sqlquote(set([3, 2, 3, 4])) |
| 456 | <sql: "WHERE x = 't' AND y IN (2, 3, 4)"> |
| 457 | >>> 'WHERE x = ' + sqlquote(True) + ' AND y IN ' + sqlquote((3, 2, 3, 4)) |
| 458 | <sql: "WHERE x = 't' AND y IN (2, 3, 4)"> |
| 459 | """ |
| 460 | if isinstance(a, (list, tuple, set)): |
| 461 | return _sqllist(a) |
| 462 | else: |
| 463 | return sqlparam(a).sqlquery() |
| 464 | |
| 465 | |
| 466 | class BaseResultSet: |
no test coverage detected