Examples of SqlFactory

cn.org.rapid_framework.generator.provider.db.sql.SqlFactory
根据SQL语句生成Sql对象,用于代码生成器的生成
示例使用：
```
 Sql sql = new SqlFactory().parseSql("select * from user_info where username=#username# and password=#password#"); 
```
@author badqiu
org.apache.ws.jaxme.sqls.SQLFactory

A factory for generating SQL statements.
@author Jochen Wiedmann

Examples of cn.org.rapid_framework.generator.provider.db.sql.SqlFactory

    GeneratorModel gm = newFromQuery(selectSql);
    g.generateBy(gm.templateModel, gm.filePathModel);
  }


  public void test_update_sql() throws Exception {
    Sql selectSql  = new SqlFactory().parseSql("update user_info set username = :username where password = :password and age=:age and sex=:sex");
    GeneratorModel gm = newFromQuery(selectSql);
    g.generateBy(gm.templateModel, gm.filePathModel);
  }

View Full Code Here

Examples of cn.org.rapid_framework.generator.provider.db.sql.SqlFactory

    g.generateBy(gm.templateModel, gm.filePathModel);
  }


  public void test_insert_sql() throws Exception {
      try {
    Sql selectSql  = new SqlFactory().parseSql("insert into user_info values(:username,:password,:age,:sex,:userid,:blog)");
    GeneratorModel gm = newFromQuery(selectSql);
    g.generateBy(gm.templateModel, gm.filePathModel);
    fail("数据类型应该匹配不正确");
      }catch(Exception e) {
          e.printStackTrace();

View Full Code Here

Examples of cn.org.rapid_framework.generator.provider.db.sql.SqlFactory

          e.printStackTrace();
      }
  }


    public void test_insert_sql_with_right_name() throws Exception {
        Sql selectSql  = new SqlFactory().parseSql("insert into user_info values(:user_id,:username,:password,:birth_date,:sex,:age)");
        GeneratorModel gm = newFromQuery(selectSql);
        g.generateBy(gm.templateModel, gm.filePathModel);
    }

View Full Code Here

Examples of cn.org.rapid_framework.generator.provider.db.sql.SqlFactory

        g.generateBy(gm.templateModel, gm.filePathModel);
    }
     
  public void test_insert_into() {
    try {
    Sql selectSql  = new SqlFactory().parseSql("insert into user_info (username,password,age) values(?,?,?)");
    fail("非空的userId不能为空,应该不能执行至这里");
    }catch(Exception e) {
    }
  }

View Full Code Here

Examples of cn.org.rapid_framework.generator.provider.db.sql.SqlFactory

    }
  }
  
  public void test_sql_error() throws Exception {
    try {
      Sql selectSql  = new SqlFactory().parseSql("update user_info1 set username = :username where password = :password and age=:age and sex=:sex");
      fail();
    }catch(Exception e){
      assertTrue(true);
    }
    
    try {
      Sql selectSql  = new SqlFactory().parseSql("insert into user_info (username,password) values(?,?,?)");
      fail();
    }catch(Exception e){
      assertTrue(true);
    }
    
    try {
      Sql selectSql  = new SqlFactory().parseSql("delete from user_info where 123username1javaeye = :username and password123 = :password and age=:age and sex=:sex");
      fail("列错误");
    }catch(Exception e){
      e.printStackTrace();
      assertTrue(true);
    }
    
    try {
      Sql selectSql  = new SqlFactory().parseSql("select * from user_info where username = :username and password =:password and age=1:age ");
      fail();
    }catch(Exception e){
      assertTrue(true);
    }
    
    try {
      Sql selectSql  = new SqlFactory().parseSql("insert into userinfo2 values(:username,:password,:age,:sex)");
      fail();
    }catch(Exception e){
      assertTrue(true);
    }
  }

View Full Code Here

Examples of cn.org.rapid_framework.generator.provider.db.sql.SqlFactory

    generatorFacade.setGenerator(g);
  }
  
  public void test_generate_by_sql() throws Exception {
    generatorFacade.getGenerator().addTemplateRootDir(new File("for_test_select_sql"));
    Sql sql = new SqlFactory().parseSql("select * from user_info where username=#username# and password=#password#");
    sql.setMultiplicity("many");  //many or one
    sql.setOperation("findByUsernameAndPassword");
    sql.setRemarks("根据用户名及密码进行查询");
    generatorFacade.generateBySql(sql);

View Full Code Here

Examples of cn.org.rapid_framework.generator.provider.db.sql.SqlFactory

        }catch(SQLException e) {
            e.printStackTrace();
            System.err.println("ErrorCode:"+e.getErrorCode()+" SQLState:"+e.getSQLState());
            assertTrue(translator.isDataIntegrityViolation(e));
        }
        new SqlFactory().parseSql("insert into role_permission(permissoin_id,role_id) values (123,123)");
        new SqlFactory().parseSql("insert into user_info(user_id,username,password) values (123,'123',123)");
    }

View Full Code Here

Examples of cn.org.rapid_framework.generator.provider.db.sql.SqlFactory

          try {
                IbatisSqlMapConfigParser ibatisSqlMapConfigParser = new IbatisSqlMapConfigParser();
        String sqlString = ibatisSqlMapConfigParser.parse(op.getSql(),toMap(table.includeSqls));
                String namedSql = SqlParseHelper.convert2NamedParametersSql(sqlString,":",""); // TODO 确认要删除本行?,因为与SqlFactory里面的代码重复
                
                Sql sql = new SqlFactory().parseSql(namedSql);
                sql.setSqlSegments(ibatisSqlMapConfigParser.getSqlSegments());
                
                LinkedHashSet<SqlParameter> finalParameters = addExtraParams2SqlParams(op.getExtraparams(), sql);
                sql.setParams(finalParameters);
                sql.setColumns(processWithCustomColumns(getCustomColumns(table),sql.getColumns()));

View Full Code Here

Examples of org.apache.ws.jaxme.sqls.SQLFactory

      if (getVerColumn() == null) {
        throw new NullPointerException("Missing 'verColumn' attribute");
      }
      Column.Name columnName = new ColumnImpl.NameImpl(getVerColumn());


      SQLFactory factory = new SQLFactoryImpl();
      Schema sch = factory.getSchema(getConnection(), getSchema());


      VersionGenerator versionGenerator = new VersionGenerator();
      versionGenerator.setGeneratingLogging(isGeneratingLogging());
      boolean isFirstTable = true;

View Full Code Here

Examples of org.apache.ws.jaxme.sqls.SQLFactory

      if (getVerColumn() == null) {
        throw new NullPointerException("Missing 'verColumn' attribute");
      }
      Column.Name columnName = new ColumnImpl.NameImpl(getVerColumn());


      SQLFactory factory = new SQLFactoryImpl();
      Schema sch = factory.getSchema(getConnection(), getSchema());


      VersionGenerator versionGenerator = new VersionGenerator();
      versionGenerator.setGeneratingLogging(isGeneratingLogging());
      boolean isFirstTable = true;

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.