public void test_0() throws Exception {

    Assert.assertEquals("SELECT *\nFROM device", engine.explainToSelectSQL("select *"));
    Assert.assertEquals(
        "SELECT serviceTag, ip\nFROM device\nWHERE ip = '127.0.0.1'",
        engine.explainToSelectSQL("select 编号, IP地址 WHERE IP地址 = '127.0.0.1'"));
    Assert.assertEquals(
        "SELECT *\nFROM device\nWHERE ip = '127.0.0.1'",
        engine.explainToSelectSQL("WHERE IP地址 = '127.0.0.1'"));
  }
  protected void setUp() throws Exception {
    Entity entity = new Entity();
    entity.setName("设备");
    entity.setDescription("Device");
    entity.setTableName("device");

    entity.addProperty(new Property("编号", "", "serviceTag"));
    entity.addProperty(new Property("IP地址", "", "ip"));

    engine.addEntity(entity);
  }
  public void test_1() throws Exception {
    engine.setMaxLimit(10);

    Assert.assertEquals("SELECT *\nFROM device\nLIMIT 10", engine.explainToSelectSQL("select *"));
    Assert.assertEquals(
        "SELECT serviceTag, ip\nFROM device\nWHERE ip = '127.0.0.1'\nLIMIT 10",
        engine.explainToSelectSQL("select 编号, IP地址 WHERE IP地址 = '127.0.0.1'"));
    Assert.assertEquals(
        "SELECT serviceTag, ip\nFROM device\nWHERE ip = '127.0.0.1'\nLIMIT 3",
        engine.explainToSelectSQL("select 编号, IP地址 WHERE IP地址 = '127.0.0.1' limit 3"));
    Assert.assertEquals(
        0, engine.exportParameters(engine.explainToSelectSQLObject("select 1")).size());
    Assert.assertEquals(
        0,
        engine
            .exportParameters(engine.explainToSelectSQLObject("select 编号, IP地址 where 1 = 0"))
            .size());
    Assert.assertEquals(
        1,
        engine
            .exportParameters(
                engine.explainToSelectSQLObject(
                    "select 编号, IP地址 where 1 = 0 and IP地址 = '127.0.0.1'"))
            .size());
    Assert.assertEquals(
        "127.0.0.1",
        engine
            .exportParameters(
                engine.explainToSelectSQLObject(
                    "select 编号, IP地址 where 1 = 0 and IP地址 = '127.0.0.1'"))
            .get(0));

    engine.setMaxLimit(null);
  }
 public void test_insert() throws Exception {
   Assert.assertEquals(
       "INSERT INTO device (serviceTag, ip)\nVALUES (?, ?)",
       engine.explainToInsertSQL("(编号, IP地址) VALUES (?, ?)"));
 }
 public void test_update() throws Exception {
   Assert.assertEquals(
       "UPDATE device\nSET serviceTag = ?\nWHERE ip = '127.0.0.1'",
       engine.explainToUpdateSQL("SET 编号 = ? WHERE IP地址 = '127.0.0.1'"));
 }
 public void test_delete() throws Exception {
   Assert.assertEquals(
       "DELETE FROM device\nWHERE ip = '127.0.0.1'",
       engine.explainToDeleteSQL("WHERE IP地址 = '127.0.0.1'"));
 }
 public static void setDataSource(MappingEngine engine, SQLInsertStatement stmt) {
   if (stmt.getTableSource() == null) {
     Entity entity = engine.getFirstEntity();
     stmt.setTableSource(new SQLIdentifierExpr(entity.getName()));
   }
 }