import mariadb

import uuid

conn = mariadb.connect(

    user="scott", password="tiger", host="mariadb111", database="test"

)

cursor = conn.cursor()

cursor.execute(

    """

    CREATE TABLE IF NOT EXISTS uuid_test (data UUID NOT NULL)

"""

)

def test_uuid_select():

    the_uuid = uuid.uuid4()

    cursor.execute("INSERT INTO uuid_test (data) VALUES (%s)", (the_uuid.hex,))

    cursor.execute("SELECT data FROM uuid_test WHERE data=%s", (the_uuid.hex,))

    assert cursor.description[0][1] == mariadb.STRING

    assert cursor.description[0][1] != mariadb.BINARY

    print(

        f"SELECT: the datatype given in cursor.description "

        f"{cursor.description[0][1]} and this is STRING, and is not a BINARY"

    )

    result_value = cursor.fetchone()[0]

    assert isinstance(result_value, str)

    assert result_value == str(the_uuid)

def test_uuid_returning():

    the_uuid = uuid.uuid4()

    cursor.execute(

        "INSERT INTO uuid_test (data) VALUES (%s) RETURNING data",

        (the_uuid.hex,),

    )

    assert cursor.description[0][1] == mariadb.STRING

    assert cursor.description[0][1] != mariadb.BINARY

    print(

        f"RETURNING: the datatype in cursor.description "

        f"is {cursor.description[0][1]} and this is STRING, "

        "and is not a BINARY"

    )

    result_value = cursor.fetchone()[0]

    assert isinstance(

        result_value, str

    ), f"yet for RETURNING, we are getting back a binary: {result_value!r}"

    assert result_value == str(the_uuid)

test_uuid_select()

test_uuid_returning()

SELECT: the datatype given in cursor.description 254 and this is STRING, and is not a BINARY

RETURNING: the datatype in cursor.description is 254 and this is STRING, and is not a BINARY

Traceback (most recent call last):

  File "/mnt/photon_home/classic/dev/sqlalchemy/test3.py", line 59, in <module>

    test_uuid_returning()

  File "/mnt/photon_home/classic/dev/sqlalchemy/test3.py", line 52, in test_uuid_returning

    assert isinstance(

AssertionError: yet for RETURNING, we are getting back a binary: b'4482d57d-8233-4686-9afc-67882eaa6500'