Uploaded image for project: 'Data Management'
  1. Data Management
  2. DM-1974

Fix enclose, escape, and line termination characters in qserv-data-loader

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Done
    • Resolution: Done
    • Fix Version/s: None
    • Component/s: Qserv
    • Labels:
      None
    • Story Points:
      2
    • Sprint:
      DB_W15_02
    • Team:
      Data Access and Database

      Description

      Add this string to mysql loader 'LOAD DATA INFILE' command: 

       q += "ENCLOSED BY '%s' ESCAPED BY '%s' LINES TERMINATED BY '%s'" % (enclose, escape, newline)

      and add params in cfg file.

        Attachments

          Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. DM-1976 Fix SQL using join and "select alias.fieldname"

          • Invalid

            Activity

            Ascending order - Click to sort in descending order
            Hide
            Permalink
            jammes Fabrice Jammes added a comment -

            A quick fix to load SUI data, that I've exported from Serge mysqldump.

            Show
            jammes Fabrice Jammes added a comment - A quick fix to load SUI data, that I've exported from Serge mysqldump.
            Hide
            Permalink
            jammes Fabrice Jammes added a comment - - edited

            Hi Andy Salnikov,

            Sorry for the previous code, I had tested a wrong version. This one works, fyi I used the repr() function to format delimiters/special chars, it seems it does the job.

            Cheers,

            Fabrice

            Show
            jammes Fabrice Jammes added a comment - - edited Hi Andy Salnikov , Sorry for the previous code, I had tested a wrong version. This one works, fyi I used the repr() function to format delimiters/special chars, it seems it does the job. Cheers, Fabrice
            Hide
            Permalink
            jammes Fabrice Jammes added a comment -

            Hi Andy Salnikov,

            Hope you'll be better soon.
            Feel free to review this ticket when possible. It's not blocking.

            Regards,

            Fabrice

            Show
            jammes Fabrice Jammes added a comment - Hi Andy Salnikov , Hope you'll be better soon. Feel free to review this ticket when possible. It's not blocking. Regards, Fabrice
            Hide
            Permalink
            salnikov Andy Salnikov added a comment -

            Few minor comments added on PR, otherwise looks fine

            Show
            salnikov Andy Salnikov added a comment - Few minor comments added on PR, otherwise looks fine
            Hide
            Permalink
            jammes Fabrice Jammes added a comment -

            Ok thanks!

            Show
            jammes Fabrice Jammes added a comment - Ok thanks!

              People

              Assignee:
              jammes Fabrice Jammes
              Reporter:
              jammes Fabrice Jammes
              Reviewers:
              Andy Salnikov
              Watchers:
              Andy Salnikov, Fabrice Jammes, Jacek Becla, Tatiana Goldina
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Jenkins

                  No builds found.