1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
|
package org.openslx.imagemaster.db;
import java.sql.Timestamp;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;
import org.openslx.imagemaster.thrift.iface.ImageData;
public class DbImage
{
public final String UUID;
public final int imageVersion;
public final String imageName;
public final String imagePath;
public final Timestamp imageCreateTime;
public final Timestamp imageUpdateTime;
public final String imageOwner;
public final String contentOperatingSystem;
public final boolean isValid;
public final boolean isDeleted;
public final String shortDescription;
public final String longDescription;
public final Timestamp timestamp;
public final String ftpUser;
public final long fileSize;
public DbImage(String UUID)
{
this.UUID = UUID;
this.imageVersion = 0;
this.imageName = null;
this.imagePath = null;
this.imageCreateTime = null;
this.imageUpdateTime = null;
this.imageOwner = null;
this.contentOperatingSystem = null;
this.isValid = false;
this.isDeleted = false;
this.shortDescription = null;
this.longDescription = null;
this.timestamp = new Timestamp( 0 );
this.ftpUser = null;
this.fileSize = 0;
}
public DbImage(String UUID, int imageVersion, String imageName, String imagePath,
Timestamp imageCreateTime, Timestamp imageUpdateTime, int imageOwner, String contentOperatingSystem,
boolean isValid, boolean isDeleted, String shortDescription, String longDescription,
Timestamp timestamp, String ftpUser, long fileSize)
{
this.UUID = UUID;
this.imageVersion = imageVersion;
this.imageName = imageName;
this.imagePath = imagePath;
this.imageCreateTime = imageCreateTime;
this.imageUpdateTime = imageUpdateTime;
this.imageOwner = DbUser.getUserNameById( imageOwner );
this.contentOperatingSystem = contentOperatingSystem;
this.isValid = isValid;
this.isDeleted = isDeleted;
this.shortDescription = shortDescription;
this.longDescription = longDescription;
this.timestamp = timestamp;
this.ftpUser = ftpUser;
this.fileSize = fileSize;
}
/**
* Check if image with imageData already exists. (Only checks the UUID.)
*
* @param imageData
* @return
*/
public static boolean exists( ImageData imageData )
{
if ( MySQL.findUniqueOrNull( DbImage.class,
"SELECT images.UUID FROM images WHERE images.UUID = ?",
imageData.uuid ) == null ) {
return false;
} else {
return true;
}
}
/**
* Insert a new image into database
* @param imageData The metadata of the image
* @param ts The timestamp of inserting
* @return Affected rows
*/
public static int insert( ImageData imageData, long ts, String ftpUser )
{
Date createTime = new Date( imageData.imageCreateTime );
Date updateTime = new Date( imageData.imageUpdateTime );
Date timestamp = new Date( ts );
SimpleDateFormat sdf = new SimpleDateFormat( "yyyy-MM-dd HH:mm:ss" );
int ownerId = DbUser.getUserIdByName( imageData.imageOwner );
return MySQL
.update(
"INSERT INTO images (UUID, image_version, image_name, image_path, image_createTime, image_updateTime, image_owner, content_operatingSystem, status_isValid, status_isDeleted, image_shortDescription, image_longDescription, timestamp, ftpUser, fileSize) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)",
imageData.uuid, imageData.imageVersion, imageData.imageName, "!uploading!",
sdf.format( createTime ), sdf.format( updateTime ), ownerId,
imageData.conentOperatingSystem, imageData.statusIsValid,
imageData.statusIsDeleted, imageData.imageShortDescription,
imageData.imageLongDescription, sdf.format( timestamp ), ftpUser, imageData.fileSize );
}
public String getUUID()
{
return this.UUID;
}
public static int update( ImageData imageData, String location )
{
return MySQL.update( "UPDATE images SET images.image_path = ? WHERE images.UUID = ?", location, imageData.uuid );
}
public static int delete( String UUID )
{
return MySQL.update( "DELETE FROM images WHERE images.UUID=?", UUID );
}
public static List<DbImage> getUploadingImages()
{
return MySQL.findAll( DbImage.class, "SELECT images.UUID, images.image_version, images.image_name, images.image_path, images.image_createTime, images.image_updateTime, images.image_owner, images.content_operatingSystem, images.status_isValid, images.status_isDeleted, images.image_shortDescription, images.image_longDescription, images.timestamp, images.ftpUser, images.fileSize FROM images WHERE image_path = ?", "!uploading!" );
}
}
|
