Skip to content
Snippets Groups Projects

fill new thing_parser table

Open David Schäfer requested to merge multi-parser into main
1 unresolved thread

Part of a multi MR change to setup the config db for multiple, time restricted thing parsers. See also:

Edited by David Schäfer

Merge request reports

Loading
Loading

Activity

Filter activity
  • Approvals
  • Assignees & reviewers
  • Comments (from bots)
  • Comments (from users)
  • Commits & branches
  • Edits
  • Labels
  • Lock status
  • Mentions
  • Merge request status
  • Tracking
  • Bert Palm
  • Bert Palm
  • Bert Palm
  • 32 LEFT JOIN config_db.project p ON t.project_id = p.id
    33 LEFT JOIN config_db.s3_store s3s ON t.s3_store_id = s3s.id
    34 LEFT JOIN config_db.file_parser fp ON s3s.file_parser_id = fp.id
    35 LEFT JOIN config_db.mqtt m ON t.mqtt_id = m.id
    36 LEFT JOIN config_db.ext_api ea ON t.ext_api_id = ea.id
    37 WHERE t.uuid = %s
    30 tp.file_parser_id, fp.file_parser_type_id, t.mqtt_id, m.mqtt_device_type_id,
    31 t.ext_sftp_id, t.ext_api_id, ea.api_type_id
    32 FROM config_db.thing t
    33 LEFT JOIN config_db.project p ON t.project_id = p.id
    34 LEFT JOIN config_db.thing_parser tp ON t.id = tp.thing_id
    35 LEFT JOIN config_db.s3_store s3s ON t.s3_store_id = s3s.id
    36 LEFT JOIN config_db.file_parser fp ON tp.file_parser_id = fp.id
    37 LEFT JOIN config_db.mqtt m ON t.mqtt_id = m.id
    38 LEFT JOIN config_db.ext_api ea ON t.ext_api_id = ea.id
    39 WHERE tp.valid_to is NULL AND t.uuid = %s;
    • Comment on lines 29 to +39
      Suggested change
      Applied
      29 SELECT t.id as thing_id, t.project_id, p.database_id, t.ingest_type_id, t.s3_store_id,
      30 tp.file_parser_id, fp.file_parser_type_id, t.mqtt_id, m.mqtt_device_type_id,
      31 t.ext_sftp_id, t.ext_api_id, ea.api_type_id
      32 FROM config_db.thing t
      33 LEFT JOIN config_db.project p ON t.project_id = p.id
      34 LEFT JOIN config_db.thing_parser tp ON t.id = tp.thing_id
      35 LEFT JOIN config_db.s3_store s3s ON t.s3_store_id = s3s.id
      36 LEFT JOIN config_db.file_parser fp ON tp.file_parser_id = fp.id
      37 LEFT JOIN config_db.mqtt m ON t.mqtt_id = m.id
      38 LEFT JOIN config_db.ext_api ea ON t.ext_api_id = ea.id
      39 WHERE tp.valid_to is NULL AND t.uuid = %s;
      29 SELECT t.id as thing_id, t.project_id, p.database_id, t.ingest_type_id, t.s3_store_id,
      30 tp.file_parser_id, fp.file_parser_type_id, t.mqtt_id, m.mqtt_device_type_id,
      31 t.ext_sftp_id, t.ext_api_id, ea.api_type_id
      32 FROM config_db.thing t
      33 LEFT JOIN config_db.project p ON t.project_id = p.id
      34 LEFT JOIN config_db.thing_parser tp ON t.id = tp.thing_id
      35 LEFT JOIN config_db.s3_store s3s ON t.s3_store_id = s3s.id
      36 LEFT JOIN config_db.file_parser fp ON tp.file_parser_id = fp.id
      37 LEFT JOIN config_db.mqtt m ON t.mqtt_id = m.id
      38 LEFT JOIN config_db.ext_api ea ON t.ext_api_id = ea.id
      39 WHERE tp.valid_to is null
      40 AND t.uuid = %s;
      Edited by Bert Palm
    • David Schäfer changed this line in version 6 of the diff

      changed this line in version 6 of the diff

    • You don't seem to like indented queries...Why?

    • Please register or sign in to reply
  • first review part, i will do a second part in terms of content and some testing

  • David Schäfer mentioned in merge request tsm-dispatcher!140

    mentioned in merge request tsm-dispatcher!140

  • David Schäfer changed the description

    changed the description

  • David Schäfer added 1 commit

    added 1 commit

    • 29cf665a - Apply 1 suggestion(s) to 1 file(s)

    Compare with previous version

  • David Schäfer added 1 commit

    added 1 commit

    • b48d3e52 - Apply 1 suggestion(s) to 1 file(s)

    Compare with previous version

  • David Schäfer added 1 commit

    added 1 commit

    • 71c20360 - Apply 1 suggestion(s) to 1 file(s)

    Compare with previous version

  • David Schäfer added 1 commit

    added 1 commit

    • 0accaa80 - Apply 1 suggestion(s) to 1 file(s)

    Compare with previous version

  • David Schäfer resolved all threads

    resolved all threads

  • David Schäfer added 1 commit

    added 1 commit

    • aff0b7ff - Apply 1 suggestion(s) to 1 file(s)

    Compare with previous version

  • David Schäfer requested review from @bert.palm

    requested review from @bert.palm

  • David Schäfer added 1 commit

    added 1 commit

    Compare with previous version

  • Please register or sign in to reply
    Loading