SET MySQL data type should convert to Python's built-in set

[Geert JM Vanderkelen]

Right now a SET MySQL data type is returned as Python list. To keep compatibility with other drivers it would be better to return it as a set instead.

    c.execute("""CREATE TABLE myconnpy_sets (
        id int unsigned auto_increment key,
        c1 SET('foo','bar','foobar')
    )""")

    c.execute("INSERT INTO myconnpy_sets (c1) VALUES ('foo')")

returns:

[(1L, ['foo'])]

should be:

[(1L, set(['foo']))]

[Geert JM Vanderkelen (geertjmvdk)]

revno: 183
committer: Geert Vanderkelen <email address hidden>
branch nick: myconnpy-Alchemy
timestamp: Wed 2010-01-20 14:37:04 +0100
message:
  Change in convesion of SET data type to Python set

  * MySQL SET data type is now converted to a Python set built-in type.
  * Updated test cases to reflect change.