Function test_binary_prefix

tests/test_cursor.py:227–245

()

def test_binary_prefix():
    # https://github.com/PyMySQL/mysqlclient/issues/494
    conn = connect(binary_prefix=True)
    cursor = conn.cursor()

    cursor.execute("DROP TABLE IF EXISTS test_binary_prefix")
    cursor.execute(
        """\
CREATE TABLE test_binary_prefix (
	id INTEGER NOT NULL AUTO_INCREMENT,
	json JSON NOT NULL,
	PRIMARY KEY (id)
) CHARSET=utf8mb4"""
    )

    cursor.executemany(
        "INSERT INTO test_binary_prefix (id, json) VALUES (%(id)s, %(json)s)",
        ({"id": 1, "json": "{}"}, {"id": 2, "json": "{}"}),
    )