Esempio n. 1
0
        /**
         * Method declaration
         *
         *
         * @param statement
         * @param channel
         *
         * @return
         */
        public Result execute(string statement, Channel channel)
        {
            if (Trace.TRACE)
            {
                Trace.trace(statement);
            }

            Tokenizer c       = new Tokenizer(statement);
            Parser    p       = new Parser(this, c, channel);
            Result    rResult = new Result();

            try
            {
                if (lLog != null && lLog.cCache != null)
                {
                    lLog.cCache.cleanUp();
                }

                if (Trace.ASSERT)
                {
                    Trace.assert(!channel.isNestedTransaction());
                }

                Trace.check(channel != null, Trace.ACCESS_IS_DENIED);
                Trace.check(!bShutdown, Trace.DATABASE_IS_SHUTDOWN);

                while (true)
                {
                    int    begin  = c.getPosition();
                    bool   script = false;
                    string sToken = c.getstring();

                    if (sToken.Equals(""))
                    {
                        break;
                    }
                    else if (sToken.Equals("SELECT"))
                    {
                        rResult = p.processSelect();
                    }
                    else if (sToken.Equals("INSERT"))
                    {
                        rResult = p.processInsert();
                    }
                    else if (sToken.Equals("UPDATE"))
                    {
                        rResult = p.processUpdate();
                    }
                    else if (sToken.Equals("DELETE"))
                    {
                        rResult = p.processDelete();
                    }
                    else if (sToken.Equals("ALTER"))
                    {
                        rResult = p.processAlter();
                    }
                    else if (sToken.Equals("CREATE"))
                    {
                        rResult = processCreate(c, channel);
                        script  = true;
                    }
                    else if (sToken.Equals("DROP"))
                    {
                        rResult = processDrop(c, channel);
                        script  = true;
                    }
                    else if (sToken.Equals("GRANT"))
                    {
                        rResult = processGrantOrRevoke(c, channel, true);
                        script  = true;
                    }
                    else if (sToken.Equals("REVOKE"))
                    {
                        rResult = processGrantOrRevoke(c, channel, false);
                        script  = true;
                    }
                    else if (sToken.Equals("CONNECT"))
                    {
                        rResult = processConnect(c, channel);
                    }
                    else if (sToken.Equals("DISCONNECT"))
                    {
                        rResult = processDisconnect(c, channel);
                    }
                    else if (sToken.Equals("SET"))
                    {
                        rResult = processSet(c, channel);
                        script  = true;
                    }
                    else if (sToken.Equals("SCRIPT"))
                    {
                        rResult = processScript(c, channel);
                    }
                    else if (sToken.Equals("COMMIT"))
                    {
                        rResult = processCommit(c, channel);
                        script  = true;
                    }
                    else if (sToken.Equals("ROLLBACK"))
                    {
                        rResult = processRollback(c, channel);
                        script  = true;
                    }
                    else if (sToken.Equals("SHUTDOWN"))
                    {
                        rResult = processShutdown(c, channel);
                    }
                    else if (sToken.Equals("CHECKPOINT"))
                    {
                        rResult = processCheckpoint(channel);
                    }
                    else if (sToken.Equals("CALL"))
                    {
                        rResult = p.processCall();
                    }
                    else if (sToken.Equals(";"))
                    {
                        // ignore
                    }
                    else
                    {
                        throw Trace.error(Trace.UNEXPECTED_TOKEN, sToken);
                    }

                    if (script && lLog != null)
                    {
                        int end = c.getPosition();

                        lLog.write(channel, c.getPart(begin, end));
                    }
                }
            }
            catch (Exception e)
            {
                rResult = new Result(Trace.getMessage(e) + " in statement ["
                                     + statement + "]");
            }

            return(rResult);
        }