Insert binary ID to MySQL

1

New to the forum and relatively new to EZMorph.

The MySQL databases in my organization love binary ID’s. When importing to EZMorph, it’s not terribly bad to HEX() them so you can match identifiers when necessary. However, it’s not uncommon for us to import data where we need that referential integrity. Because binary isn’t a supported data type, we’re required to basically:

  1. Generate UID’s.
  2. Calculate a column representing the INSERT values, using UNHEX() statements.
  3. Construct a JSON array to combine those column results.
  4. Prepend the values with the INSERT columns to create a full INSERT statement.
  5. Iterate through the query using a dynamic query module.
  6. Reference this same ID downstream in other INSERT or UPDATE statements, repeating the process.

It’s both time consuming and inefficient. Is there any better method than we’ve been using and/or is there any near-term plan to extend the Export to Database action to support this? Thanks!

2

Hello @alexstepp, and welcome to Community!

We've discussed this internally and decided to add an option to the "Export to database" action to insert values from certain columns as-is. The user will be responsible for formatting, wrapping, and escaping values in those columns.

Will this be enough for your case? Or you would like us to add a similar option to other DB-related actions?