Uploaded image for project: 'mod-source-record-manager'
  1. mod-source-record-manager
  2. MODSOURMAN-618

Create a script to generate fake Data Import Jobs data

    XMLWordPrintable

Details

    • 2
    • Folijet Support
    • Lotus R1 2022

    Description

      Cornell has over 20,000 records in the mod_source_record_manager*.job_executions* table which makes the landing page loads very slowly or not even load at all. 

      For testing purposes, create a script to generate fake data to populate in mod_source_record_manager*.job_executions* and 
      mod_source_record_manager*.job_execution_progress* tables so that we can simulate a dataset that has tens of thousands of records which is used to test the efficiency of loading the DI landing page (or the queries that are involved on that page). 

       

      AI: 1. Run attached script create_fake_job_executions.sql

      2. To create fake data use SELECT put_job_executions('diku',10); where 'diku' is a tenant and 10 is a number of new records.

      3. Run needed tests.

      4. To cleanup fake data, use SELECT delete_job_executions('diku'); where 'diku' is a tenant.

      TestRail: Results

        Attachments

          Issue Links

            Activity

              People

                mtraneis Martin Tran
                mtraneis Martin Tran
                Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  TestRail: Runs

                    TestRail: Cases