Java SQLLexer.splitStatements方法代码示例

import org.voltdb.parser.SQLLexer; //导入方法依赖的package包/类
private final void dispatchAdHocCommon(StoredProcedureInvocation task,
        ClientInputHandler handler, Connection ccxn, ExplainMode explainMode,
        String sql, Object[] userParams, Object[] userPartitionKey, AuthSystem.AuthUser user) {
    List<String> sqlStatements = SQLLexer.splitStatements(sql);
    String[] stmtsArray = sqlStatements.toArray(new String[sqlStatements.size()]);

    AdHocPlannerWork ahpw = new AdHocPlannerWork(
            m_siteId,
            task.clientHandle, handler.connectionId(),
            handler.isAdmin(), ccxn,
            sql, stmtsArray, userParams, null, explainMode,
            userPartitionKey == null, userPartitionKey,
            task.procName, task.type, task.originalTxnId, task.originalUniqueId,
            VoltDB.instance().getReplicationRole() == ReplicationRole.REPLICA,
            VoltDB.instance().getCatalogContext().cluster.getUseddlschema(),
            m_adhocCompletionHandler, user);
    LocalObjectMessage work = new LocalObjectMessage( ahpw );

    m_mailbox.send(m_plannerSiteId, work);
}
 

import org.voltdb.parser.SQLLexer; //导入方法依赖的package包/类
private void checkSplitter(final String strIn, final String... strsCmp) {
    final List<String> strsOut = SQLLexer.splitStatements(strIn);
    assertEquals(strsCmp.length, strsOut.size());
    for (int i = 0; i < strsCmp.length; ++i) {
        assertEquals(strsCmp[i], strsOut.get(i));
    }
}
 

import org.voltdb.parser.SQLLexer; //导入方法依赖的package包/类
ClientResponseImpl dispatchExplainProcedure(StoredProcedureInvocation task, ClientInputHandler handler, Connection ccxn, AuthUser user) {
    ParameterSet params = task.getParams();
    /*
     * TODO: We don't actually support multiple proc names in an ExplainProc call,
     * so I THINK that the string is always a single procname symbol and all this
     * splitting and iterating is a no-op.
     */
    //String procs = (String) params.toArray()[0];
    List<String> procNames = SQLLexer.splitStatements( (String)params.toArray()[0]);
    int size = procNames.size();
    VoltTable[] vt = new VoltTable[ size ];
    for( int i=0; i<size; i++ ) {
        String procName = procNames.get(i);

        // look in the catalog
        Procedure proc = m_catalogContext.get().procedures.get(procName);
        if (proc == null) {
            // check default procs and send them off to be explained using the regular
            // adhoc explain process
            proc = m_catalogContext.get().m_defaultProcs.checkForDefaultProcedure(procName);
            if (proc != null) {
                String sql = m_catalogContext.get().m_defaultProcs.sqlForDefaultProc(proc);
                dispatchAdHocCommon(task, handler, ccxn, ExplainMode.EXPLAIN_DEFAULT_PROC, sql, new Object[0], null, user);
                return null;
            }

            ClientResponseImpl errorResponse =
                    new ClientResponseImpl(
                            ClientResponseImpl.UNEXPECTED_FAILURE,
                            new VoltTable[0], "Procedure "+procName+" not in catalog",
                            task.clientHandle);
            return errorResponse;
        }

        vt[i] = new VoltTable(new VoltTable.ColumnInfo( "SQL_STATEMENT", VoltType.STRING),
                              new VoltTable.ColumnInfo( "EXECUTION_PLAN", VoltType.STRING));

        for( Statement stmt : proc.getStatements() ) {
            vt[i].addRow( stmt.getSqltext(), Encoder.hexDecodeToString( stmt.getExplainplan() ) );
        }
    }

    ClientResponseImpl response =
            new ClientResponseImpl(
                    ClientResponseImpl.SUCCESS,
                    ClientResponse.UNINITIALIZED_APP_STATUS_CODE,
                    null,
                    vt,
                    null);
    response.setClientHandle( task.clientHandle );
    ByteBuffer buf = ByteBuffer.allocate(response.getSerializedSize() + 4);
    buf.putInt(buf.capacity() - 4);
    response.flattenToBuffer(buf);
    buf.flip();
    ccxn.writeStream().enqueue(buf);
    return null;
}