fill new thing_parser table
1 unresolved thread
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
Activity
requested review from @bert.palm
assigned to @david.schaefer
mentioned in merge request tsm-orchestration!237
- Resolved by David Schäfer
- Resolved by David Schäfer
- Resolved by David Schäfer
- Resolved by David Schäfer
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
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 changed this line in version 6 of the diff
mentioned in merge request tsm-dispatcher!140
requested review from @bert.palm
Please register or sign in to reply