View Javadoc
1   package org.kuali.ole.select.gokb.service;
2   
3   import org.kuali.ole.select.gokb.*;
4   
5   import java.sql.Timestamp;
6   import java.util.List;
7   
8   /**
9    * Created by premkumarv on 12/18/14.
10   */
11  public interface GokbRdbmsService {
12      public static String INSERT_PACKAGE_PREPARED_STMT = "INSERT INTO OLE_GOKB_PKG_T (GOKB_PKG_ID, PKG_NAME, VARIANT_NAME, PKG_STATUS, PKG_SCOPE, BREAKABLE, FXD, AVLBLE, DATE_CREATED, DATE_UPDATED)" +
13              " VALUES(?,?,?,?,?,?,?,?,?,?)";
14  
15      public static String INSERT_TIPP_PREPARED_STMT = "INSERT INTO OLE_GOKB_TIPP_T (GOKB_TIPP_ID, GOKB_PKG_ID, GOKB_TITLE_ID, GOKB_PLTFRM_ID, TIPP_STATUS, STATUS_REASON, STRT_DT, STRT_VOL, STRT_ISSUE, END_DT, END_VOL, END_ISSUE, EMBARGO, PLTFRM_HOST_URL, DATE_CREATED, DATE_UPDATED)" +
16              " VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
17  
18      public static String INSERT_TITLE_PREPARED_STMT = "INSERT INTO OLE_GOKB_TITLE_T (GOKB_TITLE_ID, TITLE_NAME, VARIANT_NAME, MEDIUM, PURE_QA, TI_ISSN_ONLINE, TI_ISSN_PRNT, TI_ISSN_L, OCLC_NUM, TI_DOI, TI_PROPRIETARY_ID, TI_SUNCAT, TI_LCCN, PUBLSHR_ID, IMPRINT, DATE_CREATED, DATE_UPDATED)" +
19              " VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
20  
21      public static String INSERT_PLATFORM_PREPARED_STMT = "INSERT INTO OLE_GOKB_PLTFRM_T (GOKB_PLTFRM_ID, PLTFRM_NAME, PLTFRM_STATUS, PLTFRM_PRVDR_ID, AUTH, SOFTWARE_PLTFRM, DATE_CREATED, DATE_UPDATED)" +
22              " VALUES(?,?,?,?,?,?,?,?)";
23  
24      public static String INSERT_ORG_PREPARED_STMT = "INSERT INTO OLE_GOKB_ORG_T (GOKB_ORG_ID, ORG_NAME, VARIANT_NAME, DATE_CREATED, DATE_UPDATED)" +
25              " VALUES(?,?,?,?,?)";
26  
27  
28      public static String INSERT_ORG_ROLE_PREPARED_STMT = "INSERT INTO OLE_GOKB_ORG_ROLE_T (GOKB_ORG_ROLE_ID, GOKB_ORG_ID, ROLE)" +
29              " VALUES(?,?,?)";
30  
31  //    public static String INSERT_GOKB_UPDATE_LOG_STMT =  "INSERT INTO OLE_GOKB_UPDATE_LOG_S values ()";
32  
33  
34  
35      public static String UPDATE_PACKAGE_PREPARED_STMT = "UPDATE OLE_GOKB_PKG_T SET PKG_NAME=?, VARIANT_NAME=?, PKG_STATUS=?, PKG_SCOPE=?, BREAKABLE=?, FXD=?, AVLBLE=?, DATE_CREATED=?, DATE_UPDATED=? WHERE GOKB_PKG_ID=?";
36  
37      public static String UPDATE_TIPP_PREPARED_STMT = "UPDATE OLE_GOKB_TIPP_T SET GOKB_PKG_ID=?, GOKB_TITLE_ID=?, GOKB_PLTFRM_ID=?, TIPP_STATUS=?, STATUS_REASON=?, STRT_DT=?, STRT_VOL=?, STRT_ISSUE=?, END_DT=?, END_VOL=?, END_ISSUE=?, EMBARGO=?, PLTFRM_HOST_URL=?, DATE_CREATED=?, DATE_UPDATED=? WHERE GOKB_TIPP_ID=?";
38  
39      public static String UPDATE_TITLE_PREPARED_STMT = "UPDATE OLE_GOKB_TITLE_T SET TITLE_NAME=?, VARIANT_NAME=?, MEDIUM=?, PURE_QA=?, TI_ISSN_ONLINE=?, TI_ISSN_PRNT=?, TI_ISSN_L=?, OCLC_NUM=?, TI_DOI=?, TI_PROPRIETARY_ID=?, TI_SUNCAT=?, TI_LCCN=?, PUBLSHR_ID=?, IMPRINT=?, DATE_CREATED=?, DATE_UPDATED=? WHERE GOKB_TITLE_ID=?";
40  
41      public static String UPDATE_PLATFORM_PREPARED_STMT = "UPDATE OLE_GOKB_PLTFRM_T SET PLTFRM_NAME=?, PLTFRM_STATUS=?, PLTFRM_PRVDR_ID=?, AUTH=?, SOFTWARE_PLTFRM=?, DATE_CREATED=?, DATE_UPDATED=? WHERE GOKB_PLTFRM_ID=?";
42  
43      public static String UPDATE_ORG_PREPARED_STMT = "UPDATE OLE_GOKB_ORG_T SET ORG_NAME=?, VARIANT_NAME=?, DATE_CREATED=?, DATE_UPDATED=? WHERE GOKB_ORG_ID=?";
44  
45      public static String UPDATE_ORG_ROLE_PREPARED_STMT = "UPDATE OLE_GOKB_ORG_ROLE_T GOKB_ORG_ID=?, SET ROLE=? WHERE GOKB_ORG_ROLE_ID=?";
46  
47      public void insertOrUpdatePackages(List<OleGokbPackage> oleGokbPackages);
48  
49      public void insertOrUpdateTipps(List<OleGokbTipp> oleGokbTipps);
50  
51      public void insertOrUpdateTitles(List<OleGokbTitle> oleGokbTitles);
52  
53      public void insertOrUpdatePlatforms(List<OleGokbPlatform> oleGokbPlatforms);
54  
55      public void insertOrUpdateOrganizations(List<OleGokbOrganization> oleGokbOrganizations);
56  
57      public void insertOrUpdateOrganizationRoles(List<OleGokbOrganizationRole> oleGokbOrganizationRoles);
58  
59      public void insertPackages(List<OleGokbPackage> oleGokbPackages);
60  
61      public void insertTipps(List<OleGokbTipp> oleGokbTipps);
62  
63      public void insertTitles(List<OleGokbTitle> oleGokbTitles);
64  
65      public void insertPlatforms(List<OleGokbPlatform> oleGokbPlatforms);
66  
67      public void insertOrganizations(List<OleGokbOrganization> oleGokbOrganizations);
68  
69      public void insertOrganizationRoles(List<OleGokbOrganizationRole> oleGokbOrganizationRoles);
70  
71      public void truncateTables();
72  
73      public Timestamp getUpdatedDate();
74  
75      public void updateStatus(int id, String columnValue);
76  
77      public int insertStatus();
78  
79      public void insertLogEndTime(int updatedId);
80  
81  
82  }