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()));
}
}