diff options
Diffstat (limited to 'src/main/java/org/openslx/satellitedaemon')
-rw-r--r-- | src/main/java/org/openslx/satellitedaemon/db/DbImage.java | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/src/main/java/org/openslx/satellitedaemon/db/DbImage.java b/src/main/java/org/openslx/satellitedaemon/db/DbImage.java index be968b9..db90116 100644 --- a/src/main/java/org/openslx/satellitedaemon/db/DbImage.java +++ b/src/main/java/org/openslx/satellitedaemon/db/DbImage.java @@ -45,21 +45,21 @@ public class DbImage public static List<DbImage> getAllMarkedForUpload() { return MySQL.findAll( DbImage.class, "SELECT image.GUID_imageID, image.image_name, image.imageVersion, image.image_path," + - " Concat(user.loginName, @, institution.name) AS userID, image.image_filesize" + + " Concat(user.loginName, '@', institution.name) AS userID, image.image_filesize" + " FROM m_VLData_imageInfo image" + " INNER JOIN m_user user ON (image.image_owner = user.userID)" + " INNER JOIN m_institution institution ON (institution.institutionID = user.institution)" + - " WHERE image_syncMode = to_be_published" ); + " WHERE image_syncMode = 'to_be_published'" ); } public static List<DbImage> getAllMarkedForDownload() { return MySQL.findAll( DbImage.class, "SELECT image.GUID_imageID, image.image_name, image.imageVersion, image.image_path," + - " Concat(user.loginName, @, institution.name) AS userID, image.image_filesize" + + " Concat(user.loginName, '@', institution.name) AS userID, image.image_filesize" + " FROM m_VLData_imageInfo image" + " INNER JOIN m_user user ON (image.image_owner = user.userID)" + " INNER JOIN m_institution institution ON (institution.institutionID = user.institution)" + - " WHERE image_syncMode = to_be_decentralized" ); + " WHERE image_syncMode = 'to_be_decentralized'" ); } public static void updateStatus( String uuid, Status status ) |