fix bug in db statement
diff --git a/data.go b/data.go index 366e010..ae7875b 100644 --- a/data.go +++ b/data.go
@@ -136,10 +136,8 @@ return } -// TODO there's a bug in the db statement func (dbc *dbManager) getReadyDeployments() ([]DataDeployment, error) { - rows, err := dbc.getDb().Query(` SELECT a.id, a.organization_id, @@ -153,31 +151,28 @@ a.created_at, a.created_by, a.updated_at, - a.updated_by, - b.local_fs_location + a.updated_by FROM metadata_runtime_entity_metadata as a - INNER JOIN edgex_blob_available as b - ON (a.bean_blob_id = b.id) WHERE a.id IN ( SELECT a.id FROM metadata_runtime_entity_metadata as a - INNER JOIN edgex_blob_available as b + INNER JOIN apid_blob_available as b ON a.resource_blob_id = b.id WHERE a.resource_blob_id != "" INTERSECT SELECT a.id FROM metadata_runtime_entity_metadata as a - INNER JOIN edgex_blob_available as b - ON a.resource_blob_id = b.id + INNER JOIN apid_blob_available as b + ON a.bean_blob_id = b.id WHERE a.resource_blob_id != "" UNION SELECT a.id FROM metadata_runtime_entity_metadata as a - INNER JOIN edgex_blob_available as b + INNER JOIN apid_blob_available as b ON a.bean_blob_id = b.id WHERE a.resource_blob_id = "" )