Package edu.isi.karma.util

Examples of edu.isi.karma.util.AbstractJDBCUtil

66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
    @Override
    public Worksheet generateWorksheet() throws KarmaException {
        /**
         * Get the data from the database table *
         */
        AbstractJDBCUtil dbUtil = JDBCUtilFactory.getInstance(dbType);
        // TODO Limiting the number of rows to 1000 for now to avoid all data in memory
        ArrayList<ArrayList<String>> data;
    try {
      data = dbUtil.getDataForLimitedRows(dbType, hostname,
              portnumber, username, password, tableName, dBorSIDName, 100);
    } catch (SQLException | ClassNotFoundException e) {
      throw new KarmaException("Unable to get data for limited rows " + e.getLocalizedMessage());
    }
        return generateWorksheet(dbUtil, data);
View Full Code Here
82
83
84
85
86
87
88
89
90
91
92
    public Worksheet generateWorksheetForAllRows() throws SQLException, ClassNotFoundException {
        /**
         * Get the data from the database table *
         */
        AbstractJDBCUtil dbUtil = JDBCUtilFactory.getInstance(dbType);

        ArrayList<ArrayList<String>> data = dbUtil.getDataForTable(dbType, hostname,
                portnumber, username, password, tableName, dBorSIDName);
        return generateWorksheet(dbUtil, data);
    }
View Full Code Here
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
    @Override
    public Worksheet generateWorksheet() throws KarmaException {
        /**
         * Get the data from the database table *
         */
        AbstractJDBCUtil dbUtil = JDBCUtilFactory.getInstance(dbType);
        // TODO Limiting the number of rows to 1000 for now to avoid all data in memory
        ArrayList<ArrayList<String>> data;
    try {
      data = dbUtil.getSQLQueryDataForLimitedRows(dbType, hostname,
              portnumber, username, password, query, dBorSIDName, 1000);
       return generateWorksheet(dbUtil, data);
    } catch (SQLException | ClassNotFoundException e) {
      //If data could not be imported, delete the empty worksheet
      Worksheet ws = getWorksheet();
View Full Code Here
72
73
74
75
76
77
78
79
80
81
82
    public Worksheet generateWorksheetForAllRows() throws SQLException, ClassNotFoundException {
        /**
         * Get the data from the database table *
         */
        AbstractJDBCUtil dbUtil = JDBCUtilFactory.getInstance(dbType);

        ArrayList<ArrayList<String>> data = dbUtil.getDataForQuery(dbType, hostname,
                portnumber, username, password, query, dBorSIDName);
        return generateWorksheet(dbUtil, data);
    }
View Full Code Here
60
61
62
63
64
65
66
67
68
69
70
71
72
  @Override
  public void generateJson(String prefix, PrintWriter pw,
      VWorkspace vWorkspace) {
    ArrayList<String> listOfTables = null;
    try {
      AbstractJDBCUtil dbUtil = JDBCUtilFactory.getInstance(dbType);

      listOfTables = dbUtil.getListOfTables(dbType, hostname, portnumber,
          username, password, dBorSIDName);

      if (listOfTables == null) {
        // TODO Send special update
        return;
View Full Code Here
64
65
66
67
68
69
70
71
72
73
74
75
76
  @Override
  public void generateJson(String prefix, PrintWriter pw,
      VWorkspace vWorkspace) {
    try {
      AbstractJDBCUtil dbUtil = JDBCUtilFactory.getInstance(dbType);
     
      ArrayList<ArrayList<String>> data = dbUtil.getDataForLimitedRows(dbType, hostname,
          portnumber, username, password, tableName, dBorSIDName, 10);
     
      JSONStringer jsonStr = new JSONStringer();
      JSONWriter writer = jsonStr.object().key(JsonKeys.commandId.name()).value(commandId)
        .key(GenericJsonKeys.updateType.name()).value("ImportDatabaseTablePreview").key(JsonKeys.tableName.name()).value(tableName);
View Full Code Here
95
96
97
98
99
100
101
102
103
  }
 
  public void generateRDFFromTable(String tablename, List<KR2RMLRDFWriter> writers, R2RMLMappingIdentifier id, ContextIdentifier contextId, String baseURI)
      throws IOException, JSONException, KarmaException, SQLException, ClassNotFoundException {
    initializeWriter(id, contextId, writers);
    AbstractJDBCUtil dbUtil = JDBCUtilFactory.getInstance(dbType);
    String query = "Select * FROM " + dbUtil.escapeTablename(tablename);
    generateRDF(tablename, query, writers, id, baseURI);
  }
View Full Code Here
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
      if (writer instanceof BloomFilterKR2RMLRDFWriter) {
        BloomFilterKR2RMLRDFWriter t = (BloomFilterKR2RMLRDFWriter)writer;
        t.setR2RMLMappingIdentifier(id);
      }
    }
    AbstractJDBCUtil dbUtil = JDBCUtilFactory.getInstance(dbType);
    Connection conn = dbUtil.getConnection(hostname, portnumber, username, password, dBorSIDName);
    conn.setAutoCommit(false);
   
    java.sql.Statement stmt = conn.createStatement(java.sql.ResultSet.TYPE_FORWARD_ONLY,
        java.sql.ResultSet.CONCUR_READ_ONLY);
    stmt.setFetchSize(DATABASE_TABLE_FETCH_SIZE);
   
    ResultSet r = stmt.executeQuery(query);
    ResultSetMetaData meta = r.getMetaData();;
   
    // Get the column names
    List<String> columnNames = new ArrayList<>();
    for (int i = 1; i <= meta.getColumnCount(); i++) {
      columnNames.add(meta.getColumnName(i));
    }
   
    // Prepare required Karma objects
       Workspace workspace = initializeWorkspace();
  
    RepFactory factory = workspace.getFactory();
    Worksheet wk = factory.createWorksheet(wkname, workspace, encoding);
    List<String> headersList = addHeaders(wk, columnNames, factory);
   
    int counter = 0;
   
    ArrayList<String> rowValues = null;
    while ((rowValues = dbUtil.parseResultSetRow(r)) != null) {
      // Generate RDF and create a new worksheet for every DATABASE_TABLE_FETCH_SIZE rows
      if(counter%DATABASE_TABLE_FETCH_SIZE == 0 && counter != 0) {
        generateRDFFromWorksheet(wk, workspace, mapping, writers, baseURI);
        logger.debug("Done for " + counter + " rows ..." );
          removeWorkspace(workspace);
View Full Code Here
TOP

Related Classes of edu.isi.karma.util.AbstractJDBCUtil

  • edu.isi.karma.controller.update.DatabaseTablePreviewUpdate
  • edu.isi.karma.controller.update.DatabaseTablesListUpdate
  • edu.isi.karma.imp.database.DatabaseTableImport
  • edu.isi.karma.imp.database.SQLImport
  • edu.isi.karma.rdf.DatabaseTableRDFGenerator
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.