Ted, They are probably 10 of other variations of this code but I do not think there is any best way, the data needs to be converted to hex for the SQL.
I'm sot sure if the "decode(E'...')" part is required, based on pg doc, byte constant can be written as "E'\\xDEADBEEF'" so "E'\\x" + UUIDUtilities.generateAsNSData()._hexString() + "'" should also works. Samuel > Le 28 juin 2016 à 06:09, Theodore Petrosky <[email protected]> a écrit : > > I am starting a new little project and I want to use the UUIDs. My migrations > usually start up by inserting a few entities by executing some SQL. > > The id column is not a ‘real’ postgresql UUID, it is a 128 bit bytea column. > I figured out a way to use UUIDUtilities.generateAsNSData use that value to > insert my entity. > > String theSQL = "INSERT INTO person (active, firstname, creationdate, id) > VALUES " + > "(true, 'Ted', now(), decode(E'" + > UUIDUtilities.generateAsNSData()._hexString() + "', 'hex'))"; > > ERXJDBCUtilities.executeUpdate(database.adaptorChannel(), theSQL); > > It works, but is there a better way or more correct way to create the bytea > attribute to insert. > > > > Ted > > > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list ([email protected]) > Help/Unsubscribe/Update your Subscription: > https://lists.apple.com/mailman/options/webobjects-dev/samuel%40samkar.com > > This email sent to [email protected]
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
