Package railo.runtime.type

Examples of railo.runtime.type.QueryImpl

130
131
132
133
134
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
    // select
      SQL sqlSelect=new SQLImpl("select cfid,name from "+PREFIX+"_"+strType+"_data where expires<=?"
            ,new SQLItem[]{
           new SQLItemImpl(System.currentTimeMillis(),Types.VARCHAR)
        });
      QueryImpl query;
      try{
        query = new QueryImpl(ThreadLocalPageContext.get(),dc,sqlSelect,-1,-1,-1,"query");
    }
    catch(Throwable t){
      // possible that the table not exist, if not there is nothing to clean
      return;
    }
   
    int recordcount=query.getRecordcount();
   
    String cfid,name;
    for(int row=1;row<=recordcount;row++){
      cfid=Caster.toString(query.getAt(KeyConstants._cfid, row, null),null);
      name=Caster.toString(query.getAt(KeyConstants._name, row, null),null);
     
      if(listener!=null)listener.doEnd(engine, cleaner,name, cfid);
     
     
      ScopeContext.info(log,"remove "+strType+"/"+name+"/"+cfid+" from datasource "+dc.getDatasource().getName());
      engine.remove(type,name,cfid);
      SQLImpl sql = new SQLImpl("delete from "+StorageScopeDatasource.PREFIX+"_"+strType+"_data where cfid=? and name=?",new SQLItem[]{
          new SQLItemImpl(cfid,Types.VARCHAR),
          new SQLItemImpl(name,Types.VARCHAR)
          });
      new QueryImpl(ThreadLocalPageContext.get(),dc,sql,-1,-1,-1,"query");
     
     
     
    }
  }
View Full Code Here
271
272
273
274
275
276
277
278
279
280
281
      }
     
      // Resultset
      if(o instanceof ResultSet) {
        try {
          DumpData dd = new QueryImpl((ResultSet)o,"query",pageContext.getTimeZone()).toDumpData(pageContext,maxlevel,props);
          if(dd instanceof DumpTable)
            ((DumpTable)dd).setTitle(Caster.toClassName(o));
          return setId(id,dd);
        }
        catch (PageException e) {
View Full Code Here
1003
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
      railo.commons.net.http.Header[] headers = rsp.getAllHeaders();
      StringBuffer raw=new StringBuffer(rsp.getStatusLine()+" ");
      Struct responseHeader = new StructImpl();
      Struct cookie;
      Array setCookie = new ArrayImpl();
      Query cookies=new QueryImpl(new String[]{"name","value","path","domain","expires","secure","httpOnly"},0,"cookies");
     
          for(int i=0;i<headers.length;i++) {
            railo.commons.net.http.Header header=headers[i];
            //print.ln(header);
           
View Full Code Here
485
486
487
488
489
490
491
492
493
494
495
496
              ResultSet rs=callStat.getResultSet();
              if(rs!=null) {
              try{
                result=(ProcResultBean) results.get(index++,null);
                if(result!=null) {
                  railo.runtime.type.Query q = new QueryImpl(rs,result.getMaxrows(),result.getName(),pageContext.getTimeZone()); 
                  count+=q.getRecordcount();
                  setVariable(result.getName(), q);
                  if(hasCached)cache.set(KeyImpl.getInstance(result.getName()), q);
                }
              }
              finally{
View Full Code Here
108
109
110
111
112
113
114
        return new StructImpl(type);
    }

    @Override
    public Query createQuery(String[] columns, int rows, String name) {
        return new QueryImpl(columns,rows,name);
    }
View Full Code Here
113
114
115
116
117
118
119
        return new QueryImpl(columns,rows,name);
    }

    @Override
    public Query createQuery(Collection.Key[] columns, int rows, String name) throws DatabaseException {
        return new QueryImpl(columns,rows,name);
    }
View Full Code Here
118
119
120
121
122
123
124
        return new QueryImpl(columns,rows,name);
    }
   
    @Override
    public Query createQuery(DatasourceConnection dc, SQL sql, int maxrow, String name) throws PageException {
    return new QueryImpl(ThreadLocalPageContext.get(),dc,sql,maxrow,-1,-1,name);
  }
View Full Code Here
122
123
124
125
126
127
128
    public Query createQuery(DatasourceConnection dc, SQL sql, int maxrow, String name) throws PageException {
    return new QueryImpl(ThreadLocalPageContext.get(),dc,sql,maxrow,-1,-1,name);
  }
   
    public Query createQuery(DatasourceConnection dc, SQL sql, int maxrow, int fetchsize, int timeout, String name) throws PageException {
    return new QueryImpl(ThreadLocalPageContext.get(),dc,sql,maxrow,fetchsize,timeout,name);
  }
View Full Code Here
264
265
266
267
268
269
270
271
272
273
274
  }
 
  private Query createQuery() throws DatabaseException {
    String v="VARCHAR";
    String d="DATE";
    railo.runtime.type.Query qry=new QueryImpl(
        new String[]{"type","name","detail","id","lastExecution","nextExecution","closed","tries","exceptions","triesmax"},
        new String[]{v,v,"object",v,d,d,"boolean","int","object","int"},
        0,"query");
    return qry;
  }
View Full Code Here
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
        }
       
       
        SQL sql=createSQL(meta);
      if(sql!=null) {
        railo.runtime.type.Query query = new QueryImpl(pageContext,dc,sql,-1,-1,-1,"query");
       
        if(pageContext.getConfig().debug()) {
          String dsn=ds instanceof DataSource?((DataSource)ds).getName():Caster.toString(ds);
          boolean logdb=((ConfigImpl)pageContext.getConfig()).hasDebugOptions(ConfigImpl.DEBUG_DATABASE);
          if(logdb) {
            boolean debugUsage=DebuggerUtil.debugQueryUsage(pageContext,query);
            ((DebuggerPro)pageContext.getDebugger()).addQuery(debugUsage?query:null,dsn,"",sql,query.getRecordcount(),pageContext.getCurrentPageSource(),query.getExecutionTime());
          }
        }
      }
      return EVAL_PAGE;
      }
View Full Code Here
TOP

Related Classes of railo.runtime.type.QueryImpl

  • railo.aprint
  • railo.commons.io.log.LogDataSource
  • railo.commons.io.SystemUtil
  • railo.runtime.config.ConfigWebAdmin
  • railo.runtime.converter.ScriptConverter
  • railo.runtime.converter.WDDXConverter
  • railo.runtime.converter.XMLConverter
  • railo.runtime.db.DatasourceConnectionImpl
  • railo.runtime.db.Executer
  • railo.runtime.db.HSQLDBHandler
    • 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.