Package cn.org.rapid_framework.generator.provider.db.table.model

Examples of cn.org.rapid_framework.generator.provider.db.table.model.Column$EnumMetaDada

160
161
162
163
164
165
166
167
168
169
170
   
    private LinkedHashSet<Column> convert2Columns(Sql sql,ResultSetMetaData metadata) throws SQLException, Exception {
      if(metadata == null) return new LinkedHashSet();
      LinkedHashSet<Column> columns = new LinkedHashSet();
          for(int i = 1; i <= metadata.getColumnCount(); i++) {
            Column c = convert2Column(sql,metadata, i);
            if(c == null) throw new IllegalStateException("column must be not null");
        columns.add(c);
          }
      return columns;
    }
View Full Code Here
175
176
177
178
179
180
181
182
183
184
185
186
        //FIXME 如果表有别名,将会找不到表,如 inner join user_info t1, tableName将为t1,应该转换为user_info
        Table table = foundTableByTableNameOrTableAlias(sql, m.getTableName());
        if(table == null) {
          return newColumn(null,m);
        }
          Column column = table.getColumnBySqlName(m.getColumnLabelOrName());
          if(column == null || column.getSqlType() != m.getColumnType()) {
              //可以再尝试解析sql得到 column以解决 password as pwd找不到column问题
              column = newColumn(table,m);
              GLogger.trace("not found column:"+m.getColumnLabelOrName()+" on table:"+table.getSqlName()+" "+BeanHelper.describe(column));
              //isInSameTable以此种判断为错误
          }else {
View Full Code Here
192
193
194
195
196
197
198
199
200
      }
    }

    private Column newColumn(Table table,ResultSetMetaDataHolder m) {
      //Table table, int sqlType, String sqlTypeName,String sqlName, int size, int decimalDigits, boolean isPk,boolean isNullable, boolean isIndexed, boolean isUnique,String defaultValue,String remarks
      Column column = new Column(null,m.getColumnType(),m.getColumnTypeName(),m.getColumnLabelOrName(),m.getColumnDisplaySize(),m.getScale(),false,false,false,false,null,null);
      GLogger.trace("not found on table by table emtpty:"+BeanHelper.describe(column));
      return column;
    }
View Full Code Here
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
   
    private void execute(ParsedSql parsedSql,Sql sql) throws Exception {
      long start = System.currentTimeMillis();
      for(int i = 0; i < parsedSql.getParameterNames().size(); i++) {
        String paramName = parsedSql.getParameterNames().get(i);
        Column column = findColumnByParamName(parsedSql, sql, paramName);
        if(column == null) {
          column = specialParametersMapping.get(paramName);
          if(column == null) {
            //FIXME 不能猜测的column类型
            column = new Column(null,JdbcType.UNDEFINED.TYPE_CODE,"UNDEFINED",paramName,0,0,false,false,false,false,null,null);
          }
        }
        SqlParameter param = new SqlParameter(column);
       
        param.setParamName(paramName);
View Full Code Here
272
273
274
275
276
277
278
279
280
281
282
          || sql.matches("(?s).*[#$]"+paramName+"\\[]\\.?\\w*[#$].*") //match #user[]# $user[]$ #user[].age# for ibatis
         || sql.matches("(?s).*[#$]\\{"+paramName+"\\[[$\\{\\}\\w]+]\\}*.*"); //match #{user[index]}# ${user[${index}]}  for mybatis
    }
 
    private Column findColumnByParamName(ParsedSql parsedSql,Sql sql, String paramName) throws Exception {
      Column column = sql.getColumnByName(paramName);
      if(column == null) {
        //FIXME 还未处理 t.username = :username的t前缀问题,应该直接根据 t.确定属于那一张表,不需要再猜测
        String leftColumn = SqlParseHelper.getColumnNameByRightCondition(parsedSql.toString(), paramName);
        if(leftColumn != null) {
          column = findColumnByParseSql(parsedSql, leftColumn );
View Full Code Here
293
294
295
296
297
298
299
300
301
302
303
      try {
          Collection<NameWithAlias> tableNames = SqlParseHelper.getTableNamesByQuery(sql.toString());
          for(NameWithAlias tableName : tableNames) {
            Table t = getTableFromCache(tableName.getName());
            if(t != null) {
              Column column = t.getColumnByName(paramName);
              if(column != null) {
                return column;
              }
            }
          }
View Full Code Here
80
81
82
83
84
85
86
87
88
89
90
    if(tableNames.size() > 1) {
        return false;
    }
        Table t = SqlFactory.getTableFromCache(tableNames.iterator().next().getName());
        for(Column c : columns) {
            Column fromTableColumn = new ColumnSet(t.getColumns()).getBySqlName(c.getSqlName());
            if(fromTableColumn == null) {
                return false;
            }
        }
       
View Full Code Here
424
425
426
427
428
429
430
431
432
433
434
    private String joinColumnsSqlName() {
        // TODO 未解决 a.*,b.*问题
    StringBuffer sb = new StringBuffer();
    for(Iterator<Column> it = columns.iterator();it.hasNext();) {
      Column c = it.next();
      sb.append(c.getSqlName());
      if(it.hasNext()) sb.append(",");
    }
    return sb.toString();
  }
View Full Code Here
550
551
552
553
554
555
556
557
558
559
560
    }
    return null;
  }
 
  public Column getColumnByName(String name) {
      Column c = getColumnBySqlName(name);
      if(c == null) {
        c = getColumnBySqlName(StringHelper.toUnderscoreName(name));
      }
      return c;
  }
View Full Code Here
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
      if(!table.getSqlName().equalsIgnoreCase(getSqlName())) {
        throw new RuntimeException("cannot custom table properties,sqlName not equals. tableConfig.sqlName:"+getSqlName()+" table.sqlName:"+table.getSqlName());
      }
        if(columns != null) {
            for(ColumnConfig c : columns) {
                Column tableColumn = table.getColumnByName(c.getName());
                if(tableColumn != null) {
                    tableColumn.setJavaType(c.getJavatype()); //FIXME 只能自定义javaType
                }
            }
        }
        if(StringHelper.isNotBlank(getDummyPk())) {
            Column c = table.getColumnBySqlName(getDummyPk());
            if(c != null) {
                c.setPk(true);
            }
        }
        table.setClassName(getClassName());
        if(StringHelper.isNotBlank(remarks)) {
            table.setTableAlias(remarks);
View Full Code Here
TOP

Related Classes of cn.org.rapid_framework.generator.provider.db.table.model.Column$EnumMetaDada

  • cn.org.rapid_framework.generator.ext.tableconfig.model.TableConfig
  • cn.org.rapid_framework.generator.ext.tableconfig.model.TableConfig$Convert2SqlsProecssor
  • cn.org.rapid_framework.generator.provider.db.model.ColumnTest
  • cn.org.rapid_framework.generator.provider.db.model.util.ColumnHelperTest
  • cn.org.rapid_framework.generator.provider.db.sql.model.Sql
  • cn.org.rapid_framework.generator.provider.db.sql.SqlFactory$SelectColumnsParser
  • cn.org.rapid_framework.generator.provider.db.sql.SqlFactory$SqlParametersParser
  • cn.org.rapid_framework.generator.provider.db.table.TableFactory
  • cn.org.rapid_framework.generator.provider.db.table.TableFactory$TableCreateProcessor
  • cn.org.rapid_framework.generator.util.TestDataGenerator
    • 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.