Package railo.runtime.db

Examples of railo.runtime.db.SQLItemImpl

76
77
78
79
80
81
82
83
84
85
86
87
88
    public void log(int level, String application, String message) {
      DatasourceConnection dc=null;
      try {
      dc = pool.getDatasourceConnection(ThreadLocalPageContext.get(),datasource, username, password);
      SQLImpl sql = new SQLImpl(INSERT);
      sql.addItems(new SQLItemImpl(application,CFTypes.VARCHAR));
      sql.addItems(new SQLItemImpl(message,CFTypes.VARCHAR));
      sql.addItems(new SQLItemImpl(new DateTimeImpl(),CFTypes.DATE));
      new QueryImpl(ThreadLocalPageContext.get(),dc,sql,-1,-1,-1,"query");
    }
      catch (PageException e) {
      console.log(level, application, message);
    }
View Full Code Here
207
208
209
210
211
212
213
  public static Struct toStruct(Object obj, Struct defaultValue) {
    return caster().toStruct(obj,defaultValue);
  }

  public static SQLItem toSQLItem(Object value, int type) {
    return new SQLItemImpl(value,type);
  }
View Full Code Here
40
41
42
43
44
45
46
47
48
49
50
51
52
  public Query select(Config config,String cfid,String applicationName,DatasourceConnection dc, int type,Log log, boolean createTableIfNotExist) throws PageException {
    String strType = VariableInterpreter.scopeInt2String(type);
    Query query=null;
      SQL sqlSelect=new SQLImpl("select data from "+PREFIX+"_"+strType+"_data where cfid=? and name=? and expires > ?"
        ,new SQLItem[]{
       new SQLItemImpl(cfid,Types.VARCHAR),
      new SQLItemImpl(applicationName,Types.VARCHAR),
      new SQLItemImpl(now(config),Types.VARCHAR)
    });
     
      PageContext pc = ThreadLocalPageContext.get();
   
    try {
View Full Code Here
94
95
96
97
98
99
100
101
102
103
104
105
106
107
 
  private static int _update(Config config,Connection conn,String cfid, String applicationName, String strSQL,Struct data, long timeSpan, Log log, TimeZone tz) throws SQLException, PageException {
    //String appName = pc.getApplicationContext().getName();
    try{
      SQLImpl sql = new SQLImpl(strSQL,new SQLItem[]{
        new SQLItemImpl(createExpires(config,timeSpan),Types.VARCHAR),
        new SQLItemImpl(new ScriptConverter().serializeStruct(data,ignoreSet),Types.VARCHAR),
        new SQLItemImpl(cfid,Types.VARCHAR),
        new SQLItemImpl(applicationName,Types.VARCHAR)
      });
      ScopeContext.info(log,sql.toString());
     
      return execute(conn, sql,tz);
    }
View Full Code Here
113
114
115
116
117
118
119
120
121
122
123
124
  @Override
  public void delete(Config config, String cfid, String applicationName, DatasourceConnection dc, int type, Log log) throws PageException, SQLException {
    String strType = VariableInterpreter.scopeInt2String(type);
    String strSQL="delete from "+PREFIX+"_"+strType+"_data where cfid=? and name=?";
    SQLImpl sql = new SQLImpl(strSQL,new SQLItem[]{
        new SQLItemImpl(cfid,Types.VARCHAR),
        new SQLItemImpl(applicationName,Types.VARCHAR)
      });
    execute(dc.getConnection(), sql,ThreadLocalPageContext.getTimeZone());
    ScopeContext.info(log,sql.toString());
   
  }
View Full Code Here
128
129
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
  public void clean(Config config, DatasourceConnection dc, int type,StorageScopeEngine engine,DatasourceStorageScopeCleaner cleaner,StorageScopeListener listener, Log log) throws PageException {
    String strType = VariableInterpreter.scopeInt2String(type);
    // 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
445
446
447
448
449
450
451
452
453
454
455
      ProcParamBean param;
      int index=1;
        while(it.hasNext()) {
          param= it.next();
          param.setIndex(index);
          _sql.addItems(new SQLItemImpl(param.getValue()));
          if(param.getDirection()!=ProcParamBean.DIRECTION_OUT) {
            SQLCaster.setValue(pageContext.getTimeZone(),callStat, index, param);
          }
          if(param.getDirection()!=ProcParamBean.DIRECTION_IN) {
            registerOutParameter(callStat,param);
View Full Code Here
45
46
47
48
49
50
51
  @Override
  public void release()  {
      separator=",";
      list=false;
      maxlength=-1;
      item=new SQLItemImpl();
  }
View Full Code Here
245
246
247
248
249
250
251
252
253
254
255
256
                    values.append(',');
                }
                names.append(field);
                values.append('?');
                ColumnInfo ci=(ColumnInfo) meta.get(field,null);
                if(ci!=null)items.add(new SQLItemImpl(form.get(field,null),ci.getType()));
                else items.add(new SQLItemImpl(form.get(field,null)));
            }
        }
        if(items.size()==0) return null;
       
        StringBuffer sql=new StringBuffer();
View Full Code Here
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
                  if(set.length()==0) set.append(" set ");
                  else set.append(",");
                  set.append(field);
                  set.append("=?");
                  ColumnInfo ci=(ColumnInfo) meta.get(field);
                  if(ci!=null)setItems.add(new SQLItemImpl(form.get(field,null),ci.getType()));
                  else setItems.add(new SQLItemImpl(form.get(field,null)));
                }
                else {
                  if(where.length()==0) where.append(" where ");
                  else where.append(" and ");
                  where.append(field);
                  where.append("=?");
                  whereItems.add(new SQLItemImpl(form.get(field,null)));
                }
            }
        }
        if((setItems.size()+whereItems.size())==0) return null;
       
View Full Code Here
TOP

Related Classes of railo.runtime.db.SQLItemImpl

  • railo.commons.io.log.LogDataSource
  • railo.runtime.orm.hibernate.CommonUtil
  • railo.runtime.tag.Insert
  • railo.runtime.tag.QueryParam
  • railo.runtime.tag.StoredProc
  • railo.runtime.tag.Update
  • railo.runtime.tag.util.QueryParamConverter
  • railo.runtime.type.scope.storage.db.Ansi92
    • 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.