Class AbstractDBUtilities

  • Direct Known Subclasses:
    ClientDBUtilities

    public abstract class AbstractDBUtilities
    extends java.lang.Object
    • Constructor Detail

      • AbstractDBUtilities

        public AbstractDBUtilities()
    • Method Detail

      • dateFormat

        public static java.lang.String dateFormat​(java.util.Date date,
                                                  java.lang.String pattern)
      • getDatasource

        protected static java.lang.String getDatasource​(PyArgumentMap args)
        Returns the datasource defined by the "database" parameter, or the default set on the ScriptContext, if available.
      • toPyDataSet

        @Deprecated
        public static DatasetUtilities.PyDataSet toPyDataSet​(Dataset dataset)
        Deprecated.
        Use DatasetUtilities.toPyDataSet()
        For backwards compatibility. @see DatasetUtilities
      • toDataSet

        @Deprecated
        public static Dataset toDataSet​(DatasetUtilities.PyDataSet pds)
        Deprecated.
        use DatasetUtilities.toDataSet()
        For backwards compatibility. @see DatasetUtilities
      • toDataSet

        @Deprecated
        public static Dataset toDataSet​(org.python.core.PySequence headers,
                                        org.python.core.PySequence pyData)
        Deprecated.
        Use DatasetUtilities.toDataSet()
        For backwards compatibility. @see DatasetUtilities
      • dataSetToCSV

        @Deprecated
        public static java.lang.String dataSetToCSV​(boolean headerRow,
                                                    Dataset ds)
        Deprecated.
        Use DatasetUtilities.toCSVJava()
        For backwards compatibility. @see DatasetUtilities
      • runUpdateQuery

        public java.lang.Integer runUpdateQuery​(org.python.core.PyObject[] pyArgs,
                                                java.lang.String[] keywords)
      • runUpdateQueryGetKey

        @Deprecated
        public java.lang.Integer runUpdateQueryGetKey​(java.lang.String q)
        Deprecated.
      • runUpdateQueryGetKey

        @Deprecated
        public java.lang.Integer runUpdateQueryGetKey​(java.lang.String q,
                                                      java.lang.String datasource)
        Deprecated.
      • _runUpdateQuery

        protected abstract java.lang.Integer _runUpdateQuery​(java.lang.String s,
                                                             java.lang.String datasource,
                                                             java.lang.String txId,
                                                             boolean getIds,
                                                             boolean skipAudit)
                                                      throws java.lang.Exception
        Throws:
        java.lang.Exception
      • runPrepStmt

        @Deprecated
        public java.lang.Integer runPrepStmt​(java.lang.String query,
                                             java.lang.Object[] args)
        Deprecated.
      • runPrepStmt

        @Deprecated
        public java.lang.Integer runPrepStmt​(java.lang.String query,
                                             java.lang.String datasource,
                                             java.lang.Object[] args)
        Deprecated.
      • runPrepStmtGetKey

        @Deprecated
        public java.lang.Integer runPrepStmtGetKey​(java.lang.String query,
                                                   java.lang.Object[] args)
        Deprecated.
      • runPrepStmtGetKey

        @Deprecated
        public java.lang.Integer runPrepStmtGetKey​(java.lang.String query,
                                                   java.lang.String datasource,
                                                   java.lang.Object[] args)
        Deprecated.
      • runPrepUpdate

        public java.lang.Integer runPrepUpdate​(org.python.core.PyObject[] pyArgs,
                                               java.lang.String[] keywords)
      • _runPrepStmt

        protected abstract java.lang.Integer _runPrepStmt​(java.lang.String query,
                                                          java.lang.String datasource,
                                                          java.lang.String txId,
                                                          boolean getIds,
                                                          boolean skipAudit,
                                                          java.lang.Object[] args)
                                                   throws java.lang.Exception
        Throws:
        java.lang.Exception
      • runPrepQuery

        public DatasetUtilities.PyDataSet runPrepQuery​(org.python.core.PyObject[] pyArgs,
                                                       java.lang.String[] keywords)
      • _runPrepQuery

        protected abstract Dataset _runPrepQuery​(java.lang.String query,
                                                 java.lang.String datasource,
                                                 java.lang.String txId,
                                                 java.lang.Object[] args)
                                          throws java.lang.Exception
        Throws:
        java.lang.Exception
      • runScalarPrepQuery

        public java.lang.Object runScalarPrepQuery​(org.python.core.PyObject[] pyArgs,
                                                   java.lang.String[] keywords)
      • runScalarQuery

        public java.lang.Object runScalarQuery​(org.python.core.PyObject[] pyArgs,
                                               java.lang.String[] keywords)
      • error

        protected org.python.core.PyException error​(java.lang.String function,
                                                    java.lang.Exception cause,
                                                    java.lang.String... args)
      • getConnections

        public Dataset getConnections()
      • getConnectionInfo

        public Dataset getConnectionInfo​(java.lang.String name)
      • _runQuery

        protected abstract Dataset _runQuery​(java.lang.String query,
                                             java.lang.String datasource,
                                             java.lang.String txId)
                                      throws java.lang.Exception
        Throws:
        java.lang.Exception
      • _findDatasources

        protected abstract java.util.List<? extends DatasourceMeta> _findDatasources()
      • beginTransaction

        public java.lang.String beginTransaction​(org.python.core.PyObject[] pyArgs,
                                                 java.lang.String[] keywords)
                                          throws java.sql.SQLException
        Throws:
        java.sql.SQLException
      • commitTransaction

        public void commitTransaction​(java.lang.String txId)
                               throws java.sql.SQLException
        Throws:
        java.sql.SQLException
      • rollbackTransaction

        public void rollbackTransaction​(java.lang.String txId)
                                 throws java.sql.SQLException
        Throws:
        java.sql.SQLException
      • closeTransaction

        public void closeTransaction​(java.lang.String txId)
                              throws java.sql.SQLException
        Throws:
        java.sql.SQLException
      • _beginTransaction

        protected abstract java.lang.String _beginTransaction​(java.lang.String datasource,
                                                              int isolationLevel,
                                                              long timeout)
                                                       throws java.lang.Exception
        Throws:
        java.lang.Exception
      • _commitTransaction

        protected abstract void _commitTransaction​(java.lang.String txId)
                                            throws java.lang.Exception
        Throws:
        java.lang.Exception
      • _rollbackTransaction

        protected abstract void _rollbackTransaction​(java.lang.String txId)
                                              throws java.lang.Exception
        Throws:
        java.lang.Exception
      • _closeTransaction

        protected abstract void _closeTransaction​(java.lang.String txId)
                                           throws java.lang.Exception
        Throws:
        java.lang.Exception
      • createSProcCall

        public SProcCall createSProcCall​(org.python.core.PyObject[] pyArgs,
                                         java.lang.String[] keywords)
      • execSProcCall

        public void execSProcCall​(SProcCall callContext)
      • _call

        protected abstract void _call​(SProcCall callContext)
                               throws java.lang.Exception
        Throws:
        java.lang.Exception