Sqlite3.register_converter('GUID', lambda b: uuid.UUID(bytes_le=b)) To use these, you need to pass an argument for the detect_types parameter of connect().
register_adapter(): convert Python types to SQLite types.register_converter(): convert SQLite types to Python types.One can essentially add support for GUID datatypes to sqlite3 in Python.
#SQLITE UUID GENERATOR CODE#
So what is the "correct" way to store GUIDs in SQLite, specifically using Python? Later, I will have C# code interacting with this as well, and want to make sure I'm going things the "right" way. Looking at the data on disk, you can see that the GUID is stored in binary, after SQLite Expert touches it:Īfter - the previous data is garbage, and a binary version of the GUID exists: It seems that it changes the datatype! My SELECT from before yields None, and if I SELECT *, I see that it is no longer a simple unicode string: C:\Users\Jonathon>opendb.py test.db It appears that SQLite Expert is happy with my GUID datatype declaration: My doubts arise from using SQLite Expert.
Using the default Python _str_ representation of the UUID works well. Yes, I know GUID isn't a real SQLite datatype.Ĭ.execute('CREATE TABLE test (guid GUID PRIMARY KEY, name text)')Ĭ.execute('INSERT INTO test VALUES (?,?)', t)Ĭ.execute('SELECT * FROM test WHERE guid = "c1332103-6031-4ff7-b610-f8f3b940fa66"') I'm looking to store GUIDs in my SQLite database, using C# and python clients.Ĭreating a database, and inserting a row, storing the GUID as a string: conn = nnect(filename)
0 kommentar(er)
