René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Percents de-escaping isn't handled when no parameters are used in the dbapi.","articleBody":"\r\n```python\r\n\r\n\u003e\u003e\u003e import google.cloud.bigquery.dbapi\r\n\u003e\u003e\u003e conn = google.cloud.bigquery.dbapi.connect()\r\n/home/jim/p/g/python-bigquery/google/cloud/bigquery/client.py:444: UserWarning: Cannot create BigQuery Storage client, the dependency google-cloud-bigquery-storage is not installed.\r\n  warnings.warn(\r\n\u003e\u003e\u003e cursor = conn.cursor()\r\n\u003e\u003e\u003e cursor.execute(\"select 'foo %%', %(x)s\", dict(x=1))\r\n\u003e\u003e\u003e cursor.fetchall()\r\n[Row(('foo %', 1), {'f0_': 0, 'f1_': 1})]\r\n\u003e\u003e\u003e cursor.execute(\"select 'foo %%'\", dict(x=1))\r\n\u003e\u003e\u003e cursor.fetchall()\r\n[Row(('foo %',), {'f0_': 0})]\r\n\u003e\u003e\u003e cursor.execute(\"select 'foo %%'\")\r\n\u003e\u003e\u003e cursor.fetchall()\r\n[Row(('foo %%',), {'f0_': 0})]\r\n```\r\n\r\nBonus:\r\n\r\nif people don't escape:\r\n\r\n```\r\n\u003e\u003e\u003e cursor.execute(\"select 'foo %'\")\r\n\u003e\u003e\u003e cursor.fetchall()\r\n[Row(('foo %',), {'f0_': 0})]\r\n\u003e\u003e\u003e cursor.execute(\"select 'foo %'\", dict(x=1))\r\nTraceback (most recent call last):\r\n  File \"\u003cstdin\u003e\", line 1, in \u003cmodule\u003e\r\n  File \"/home/jim/p/g/python-bigquery/google/cloud/bigquery/dbapi/_helpers.py\", line 273, in with_closed_check\r\n    return method(self, *args, **kwargs)\r\n  File \"/home/jim/p/g/python-bigquery/google/cloud/bigquery/dbapi/cursor.py\", line 172, in execute\r\n    formatted_operation = _format_operation(operation, parameters=parameters)\r\n  File \"/home/jim/p/g/python-bigquery/google/cloud/bigquery/dbapi/cursor.py\", line 460, in _format_operation\r\n    return _format_operation_dict(operation, parameters)\r\n  File \"/home/jim/p/g/python-bigquery/google/cloud/bigquery/dbapi/cursor.py\", line 434, in _format_operation_dict\r\n    return operation % formatted_params\r\nValueError: unsupported format character ''' (0x27) at index 13\r\n```\r\n\r\n","author":{"url":"https://github.com/jimfulton","@type":"Person","name":"jimfulton"},"datePublished":"2021-04-14T20:08:39.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":4},"url":"https://github.com/608/python-bigquery/issues/608"}