|
1
5 package com.tdsecurities.itracker.converter;
6
7 import java.sql.PreparedStatement  ;
8 import java.sql.ResultSet ;
9 import java.sql.Timestamp ;
10 import java.util.Date ;
11
12 import org.apache.log4j.Logger;
13
14 import com.tdsecurities.itracker.common.DataSourceManager;
15
16
20 public class VersionConverter extends BasicConverter
21 {
22 private static final String SOURCE_SQL = "select distinct group_id from groups order by group_id";
23 private static final String TARGET_SQL = "INSERT INTO versionbean (id,major,minor,version_number,description,status,create_date,last_modified,project_id) values (?, 1, 0, '1.0', '1.0', 1, ?, ?, ?)";
24 private static final String LAST_ID_SQL = "select max(id) from versionbean";
25
26 private Logger log = Logger.getLogger(VersionConverter.class);
27
28 protected String getSourceQuery()
29 {
30 return SOURCE_SQL;
31 }
32
33 protected String getTargetQuery()
34 {
35 return TARGET_SQL;
36 }
37
38 protected String getIdStoreName()
39 {
40 return "version";
41 }
42
43 protected String getLastIdQuery()
44 {
45 return LAST_ID_SQL;
46 }
47
48 protected int prepareTargetStatement(PreparedStatement targetStmt, ResultSet rs) throws Exception
49 {
50 long now = (new Date ()).getTime();
51 int col = 1;
52 targetStmt.setInt(col++, rs.getInt("group_id"));
53 targetStmt.setTimestamp(col++, new Timestamp (now));
54 targetStmt.setTimestamp(col++, new Timestamp (now));
55 targetStmt.setInt(col++, rs.getInt("group_id"));
56 return BasicConverter.OK;
57 }
58
59 protected void preConversionProcessing()
60 {
61 log.info("Creating versions");
62 executeUpdate(DataSourceManager.ITRACKER, "delete from versionbean");
63 }
64
65 protected void postConversionProcessing()
66 {
67 log.info("Created versions");
68 }
69 }
70 |
Popular Tags |
Java API By Example, From Geeks To Geeks.