Examples of SqlRequest

io.crate.action.sql.SQLRequest
Request class for regular/single SQL statements.
net.virtuemart.www.VM_SQLQueries.SQLRequest
org.springmodules.lucene.index.document.handler.database.SqlRequest
Class which contains every informations about a sql request and its parameters.
This is used with the DatabaseIndexer to specify the request to execute. So these requests are associated with a SqlDocumentHandler to specify how to index the data contained by the returned ResultSet. @author Thierry Templier @see org.springmodules.lucene.index.object.database.DatabaseIndexer @see org.springmodules.lucene.index.support.database.SqlDocumentHandler
org.springmodules.lucene.index.support.database.SqlRequest
Class which contains every informations about a sql request and its parameters.
This is used with the DatabaseIndexer to specify the request to execute. So these requests are associated with a SqlDocumentHandler to specify how to index the datas contained by the returned ResultSet. @author Thierry Templier @see org.springmodules.lucene.index.object.database.DatabaseIndexer @see org.springmodules.lucene.index.support.database.SqlDocumentHandler

Examples of net.virtuemart.www.VM_SQLQueries.SQLRequest

       SQLResult[] results;
        if (dateReturn!=null) {
            dateR = df.format(dateReturn);
            String query =  " INSERT INTO #__{vm}_order_history ( order_id , order_status_code , date_added , customer_notified , comments ) "
                        +" VALUES ( '"+orderID+"', 'D', '"+dateR+"', '0', 'Date return'); ";
            SQLRequest sqlr = new SQLRequest(wsLogin,query);


            try {
               results = queriesProxy.executeSQLQuery(sqlr);
            
            } catch (IOException ioe) {
                ioe.printStackTrace();
                returnvalue = false;
            }


        }




        String query2 = " UPDATE #__{vm}_order_history SET date_added = '"+dateC+"' WHERE order_status_code = 'P' AND order_status_history_id ="+orderID+"; ";
        String query3 = " UPDATE #__{vm}_orders SET cdate=UNIX_TIMESTAMP('"+dateC+"') WHERE order_id = "+orderID+";";


        SQLRequest sqlr2 = new SQLRequest(wsLogin,query2);
        SQLRequest sqlr3 = new SQLRequest(wsLogin,query3);


        try {


           results = queriesProxy.executeSQLQuery(sqlr2);
           results = queriesProxy.executeSQLQuery(sqlr3);

View Full Code Here

Examples of net.virtuemart.www.VM_SQLQueries.SQLRequest


    }


    public int getOrderID (String note) throws RemoteException {
        String query = "SELECT order_id FROM #__{vm}_orders ";
        SQLRequest sqlr = new SQLRequest(wsLogin, query);


        try {
//            queriesProxy.executeSQLUpdateQuery(sqlr);
            SQLResult[] results = queriesProxy.executeSQLQuery(sqlr);
            if (results.length == 1) {

View Full Code Here

Examples of net.virtuemart.www.VM_SQLQueries.SQLRequest

        String query =  " INSERT INTO #__{vm}_order_history ( order_id , order_status_code , date_added , customer_notified , comments ) "
                        +" VALUES ( '"+orderID+"', 'C', '"+dateR+"', '0', ''); ";
        String query3 = " UPDATE #__{vm}_orders SET order_status = 'C' WHERE order_id = "+orderID+";";




        SQLRequest sqlr = new SQLRequest(wsLogin,query);
        SQLRequest sqlr3 = new SQLRequest(wsLogin,query3);


        try {
           SQLResult[] results = queriesProxy.executeSQLQuery(sqlr);
           results = queriesProxy.executeSQLQuery(sqlr3);

View Full Code Here

Examples of net.virtuemart.www.VM_SQLQueries.SQLRequest

        String query =  " INSERT INTO #__{vm}_order_history ( order_id , order_status_code , date_added , customer_notified , comments ) "
                        +" VALUES ( '"+orderID+"', 'S', '"+dateR+"', '0', ''); ";
        String query3 = " UPDATE #__{vm}_orders SET order_status = 'S' WHERE order_id = "+orderID+" AND order_status = 'C';";




        SQLRequest sqlr = new SQLRequest(wsLogin,query);
        SQLRequest sqlr3 = new SQLRequest(wsLogin,query3);


        try {
           SQLResult[] results = queriesProxy.executeSQLQuery(sqlr);
           results = queriesProxy.executeSQLQuery(sqlr3);

View Full Code Here

Examples of net.virtuemart.www.VM_SQLQueries.SQLRequest

       SQLResult[] results;
        if (dateReturn!=null) {
            dateR = df.format(dateReturn);
            String query =  " INSERT INTO #__{vm}_order_history ( order_id , order_status_code , date_added , customer_notified , comments ) "
                        +" VALUES ( '"+orderID+"', 'D', '"+dateR+"', '0', 'Date return'); ";
            SQLRequest sqlr = new SQLRequest(wsLogin,query);


            try {
               results = queriesProxy.executeSQLQuery(sqlr);
            
            } catch (IOException ioe) {
                ioe.printStackTrace();
                returnvalue = false;
            }


        }




        String query2 = " UPDATE #__{vm}_order_history SET date_added = '"+dateC+"' WHERE order_status_code = 'P' AND order_status_history_id ="+orderID+"; ";
        String query3 = " UPDATE #__{vm}_orders SET cdate=UNIX_TIMESTAMP('"+dateC+"') WHERE order_id = "+orderID+";";


        SQLRequest sqlr2 = new SQLRequest(wsLogin,query2);
        SQLRequest sqlr3 = new SQLRequest(wsLogin,query3);


        try {


           results = queriesProxy.executeSQLQuery(sqlr2);
           results = queriesProxy.executeSQLQuery(sqlr3);

View Full Code Here

Examples of org.springmodules.lucene.index.document.handler.database.SqlRequest

    
    //Indexer
    DefaultDatabaseIndexer indexer = new DefaultDatabaseIndexer(indexFactory);


    //Register a document handler
    SqlRequest request = new SqlRequest("select * from test");
    assertNull(indexer.getDocumentHandler(request));


    indexer.registerDocumentHandler(request,new SqlDocumentHandler() {
      public Document getDocument(SqlRequest request, ResultSet rs) throws SQLException {
        return null;

View Full Code Here

Examples of org.springmodules.lucene.index.document.handler.database.SqlRequest

    
    //Indexer
    DefaultDatabaseIndexer indexer = new DefaultDatabaseIndexer(indexFactory);


    //Register a document handler
    SqlRequest request = new SqlRequest("select * from test");
    indexer.registerDocumentHandler(request, new SqlDocumentHandler() {
      public Document getDocument(SqlRequest request, ResultSet rs) throws SQLException {
        return null;
      }
    });

View Full Code Here

Examples of org.springmodules.lucene.index.document.handler.database.SqlRequest

    LuceneIndexWriter indexWriter = (LuceneIndexWriter)indexWriterControl.getMock();
    MockControl listenerControl = MockControl.createControl(DatabaseIndexingListener.class);
    DatabaseIndexingListener listener = (DatabaseIndexingListener)listenerControl.getMock();


    //requests
    SqlRequest request1 = new SqlRequest("select * from test");
    SqlRequest request2 = new SqlRequest("select * from test");


    //documents
    final Document document1 = new Document();
    document1.add(new Field("contents", "test_name", Field.Store.NO, Field.Index.TOKENIZED));
    final Document document2 = new Document();

View Full Code Here

Examples of org.springmodules.lucene.index.document.handler.database.SqlRequest

    LuceneIndexWriter indexWriter = (LuceneIndexWriter)indexWriterControl.getMock();
    MockControl listenerControl = MockControl.createControl(DatabaseIndexingListener.class);
    DatabaseIndexingListener listener = (DatabaseIndexingListener)listenerControl.getMock();
    
    //requests
    SqlRequest request1 = new SqlRequest("select * from test1");


    //documents
    final Document document1 = new Document();
    document1.add(new Field("contents", "test_name", Field.Store.NO, Field.Index.TOKENIZED));

View Full Code Here

Examples of org.springmodules.lucene.index.document.handler.database.SqlRequest

    LuceneIndexWriter indexWriter = (LuceneIndexWriter)indexWriterControl.getMock();
    MockControl listenerControl = MockControl.createControl(DatabaseIndexingListener.class);
    DatabaseIndexingListener listener = (DatabaseIndexingListener)listenerControl.getMock();


    //requests
    SqlRequest request1 = new SqlRequest("select * from test");
    SqlRequest request2 = new SqlRequest("select * from test");


    //documents
    final Document document1 = new Document();
    document1.add(new Field("contents", "test_name", Field.Store.NO, Field.Index.TOKENIZED));
    final Document document2 = new Document();

View Full Code Here

0 1 2 3

TOP

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.