fill new thing_parser table

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

• tsm-orchestration!237
• tsm-dispatcher!140

src/configdb.py

@@ -26,17 +26,18 @@ if get_envvar_as_bool("DEBUG_SQL"):
 
 _IDS_BY_UUID_QUERY = sql.SQL(
     """\
-SELECT t.id as thing_id, t.project_id, p.database_id, t.ingest_type_id, t.s3_store_id,
-       tp.file_parser_id, fp.file_parser_type_id, t.mqtt_id, m.mqtt_device_type_id,
-       t.ext_sftp_id, t.ext_api_id, ea.api_type_id
-  FROM config_db.thing t
-       LEFT JOIN config_db.project p ON t.project_id = p.id
-       LEFT JOIN config_db.thing_parser tp ON t.id = tp.thing_id
-       LEFT JOIN config_db.s3_store s3s ON t.s3_store_id = s3s.id
-       LEFT JOIN config_db.file_parser fp ON tp.file_parser_id = fp.id
-       LEFT JOIN config_db.mqtt m ON t.mqtt_id = m.id
-       LEFT JOIN config_db.ext_api ea ON t.ext_api_id = ea.id
- WHERE tp.valid_to is NULL AND t.uuid = %s;
+SELECT t.id as thing_id, t.project_id, p.database_id, t.ingest_type_id, t.s3_store_id, 
+tp.file_parser_id, fp.file_parser_type_id, t.mqtt_id, m.mqtt_device_type_id, 
+t.ext_sftp_id, t.ext_api_id, ea.api_type_id 
+FROM config_db.thing t 
+LEFT JOIN config_db.project p ON t.project_id = p.id 
+LEFT JOIN config_db.thing_parser tp ON t.id = tp.thing_id 
+LEFT JOIN config_db.s3_store s3s ON t.s3_store_id = s3s.id 
+LEFT JOIN config_db.file_parser fp ON tp.file_parser_id = fp.id 
+LEFT JOIN config_db.mqtt m ON t.mqtt_id = m.id 
+LEFT JOIN config_db.ext_api ea ON t.ext_api_id = ea.id 
+WHERE tp.valid_to is null 
+AND t.uuid = %s;
 """
 )
 _no_ids = {