public static void main1() throws Exception {
Database db = DatabaseFactory.open(DatabaseType.mysql, "brooks", "brickhouse", "ml", "ml");
// Database db = DatabaseFactory.open(DatabaseType.postgresql, "brooks", "treehouse_dev",
// "treehouse_user",
// "treehouse_user");
Table table = db.getTable("test", true);
// table.insert(new HMap().put("test").put("a", "b").put("c", 314).put("id", new
// HReference())
// .put("dis", "test record 2").put("friend", new
// HReference("24223b64-d2a3-4f0d-ae7d-b4ee18fb5367")));
// System.out.println(table.readAll(HFilter.has("id")));
// System.out.println(table.readById(new
// HReference("24223b64-d2a3-4f0d-ae7d-b4ee18fb5367")));
// System.out.println(table.readById("24223b64-d2a3-4f0d-ae7d-b4ee18fb5367"));
// HMap map = table.readById("24223b64-d2a3-4f0d-ae7d-b4ee18fb5367");
// map.put("zxcv").remove("a").put("q", new HDateTime(System.currentTimeMillis()));
// table.updateById(map);
// System.out.println(table.readById("24223b64-d2a3-4f0d-ae7d-b4ee18fb5367"));
// HMap map = table.readById("85cf1f69-f4ce-4a75-9627-5100c0eb8b97");
// System.out.println(JsonWriter.writeToString(JsonUtils.ctx(), map));
// deleteById(table);
// readAll(table);
filter(table, "id==@24223b64-d2a3-4f0d-ae7d-b4ee18fb5367");
}
