1 31 32 package org.opencms.db.maxdb; 33 34 import org.opencms.db.CmsDbContext; 35 import org.opencms.db.CmsDbSqlException; 36 import org.opencms.db.CmsDbUtil; 37 import org.opencms.db.generic.CmsSqlManager; 38 import org.opencms.file.CmsBackupProject; 39 import org.opencms.file.CmsDataAccessException; 40 import org.opencms.util.CmsUUID; 41 42 import java.sql.Connection ; 43 import java.sql.PreparedStatement ; 44 import java.sql.ResultSet ; 45 import java.sql.SQLException ; 46 import java.util.ArrayList ; 47 import java.util.List ; 48 49 61 public class CmsBackupDriver extends org.opencms.db.generic.CmsBackupDriver { 62 63 66 public org.opencms.db.generic.CmsSqlManager initSqlManager(String classname) { 67 68 return CmsSqlManager.getInstance(classname); 69 } 70 71 74 public List readBackupProjects(CmsDbContext dbc) throws CmsDataAccessException { 75 76 List projects = new ArrayList (); 77 ResultSet res = null; 78 PreparedStatement stmt = null; 79 Connection conn = null; 80 81 try { 82 conn = m_sqlManager.getConnection(dbc); 84 stmt = m_sqlManager.getPreparedStatement(conn, "C_PROJECTS_READLAST_BACKUP"); 85 stmt.setInt(1, 300); 86 res = stmt.executeQuery(); 87 while (res.next()) { 88 List resources = m_driverManager.getBackupDriver().readBackupProjectResources( 89 dbc, 90 res.getInt("PUBLISH_TAG")); 91 projects.add(new CmsBackupProject( 92 res.getInt("PUBLISH_TAG"), 93 res.getInt("PROJECT_ID"), 94 res.getString("PROJECT_NAME"), 95 res.getString("PROJECT_DESCRIPTION"), 96 res.getInt("TASK_ID"), 97 new CmsUUID(res.getString("USER_ID")), 98 new CmsUUID(res.getString("GROUP_ID")), 99 new CmsUUID(res.getString("MANAGERGROUP_ID")), 100 res.getLong("DATE_CREATED"), 101 res.getInt("PROJECT_TYPE"), 102 CmsDbUtil.getTimestamp(res, "PROJECT_PUBLISHDATE"), 103 new CmsUUID(res.getString("PROJECT_PUBLISHED_BY")), 104 res.getString("PROJECT_PUBLISHED_BY_NAME"), 105 res.getString("USER_NAME"), 106 res.getString("GROUP_NAME"), 107 res.getString("MANAGERGROUP_NAME"), 108 resources)); 109 } 110 } catch (SQLException e) { 111 throw new CmsDbSqlException(org.opencms.db.generic.Messages.get().container( 112 org.opencms.db.generic.Messages.ERR_GENERIC_SQL_1, 113 CmsDbSqlException.getErrorQuery(stmt)), e); 114 } finally { 115 m_sqlManager.closeAll(dbc, conn, stmt, res); 116 } 117 return (projects); 118 } 119 } | Popular Tags |