[go: up one dir, main page]
Menu ▾ ▴

#61 Information about exported rows

Next_Release_(example)
pending
nobody
None
5
2019-01-14
2019-01-08
Dennis Nowak
No

After export of data set, the logs contain information about the number of rows that were exported per table. There ist no information which rows were exported.
I would like to get information (e.g. the primary key) of exported rows. As I am using jailer via Subsetter API, the information might be returned by execute() method.

Discussion

  • Ralf Wisser

    Ralf Wisser - 2019-01-10
    • status: open --> pending
     

  • Ralf Wisser

    Ralf Wisser - 2019-01-10

    realized in release 8.2.5

     

  • Dennis Nowak

    Dennis Nowak - 2019-01-10

    This really already helps me. Can the information be enhanced so that I can retrieve the primary keys of the row that were actually exported?
    The where clause does not necessarily list directly determine which rows will be exported. It would be nice to see those rows without having to parse the exported script and prior to loading the data into a database. In my use case it would be sufficient to get the primary keys of the subject table.

     

    • Ralf Wisser

      Ralf Wisser - 2019-01-14

      Why is the "where clause" in your case not enough?

      This is difficult to realize for the general case, especially if import filters are defined on the primary keys, because then the new values are not defined until the import.

      An idea:
      You could define an additional column "importId" (or so) for the subject table and assign it via filter per export with a unique ID (see screenshot in the appendix). Define the ID during export:

      String importId = java.util.UUID.randomUUID.toString();
subsetter.setParameter("importId", importId);
subsetter.execute();

      and after the import use this ID to find the new subjects.

       

      Last edit: Ralf Wisser 2019-01-14
      Thumbnail
      ImportIdFilter.PNG

      • Dennis Nowak

        Dennis Nowak - 2019-01-14

        The intention was getting the set of rows as seen in the transaction that exports the data set.
        I was not sure if it would be easy to realize my requirments.
        As solving this general issue is not that easy I will look for a solution to my specific use case.
        Thanks for your efforts.

         

Anonymous
Anonymous

Add attachments
Cancel