I got a job to do on database. The problem is I have 3 queries that need to one after another to get the result as below sequence.

  1. UPDATE db_swim_dev.ios_upgrade_css_site_selection SET
    pre_check='PROCESSING' WHERE id='Dynamic Value need to fetch
    from CSV';
  2. INSERT INTO db_swim_dev.tbl_ios_css_checks (id, hostname,
    r0_state, r1_state, device_type, version, issu_ready,
    licence_advancedmetroipaccess, licence_status, device_model,
    software_state, cust_special, power_state, fan_state,
    output, ios_image_update, job_id, site_master_id, rcount,
    mmcblk0) VALUES ('', 'dynamic value need to fetch from CSV', '',
    '', '920o', 'V156_2_SP_SR680887239_8', '0', '0', '', '0', '0', '0',
    '0', '0',
    'a:3:{s:11:"device_type";s:4:"920o";s:14:"licence_status";i:1;s:7:"mmcblk0";i:0;}',
    '0', '246', '19442', '0', '0');
  3. UPDATE db_swim_dev.ios_upgrade_css_site_selection SET
    pre_check='FAILED' WHERE id='Dynamic value need to fetch from
    CSV';

I am not sure how to do that. I tried to run all the queries together getting an error. If anyone has encountered the same scenario please let me know how to make this work.



Source link https://sqa.stackexchange.com/questions/32104/how-to-run-more-than-1--through--to-do-load-testing

LEAVE A REPLY

Please enter your comment!
Please enter your name here