public static Builder builder() { return new Builder() { @Override protected SQLTemplates build(char escape, boolean quote) { return new MySQLTemplates(escape, quote); } }; }
@Override protected SQLTemplates build(char escape, boolean quote) { return new MySQLTemplates(escape, quote); } };
public MySQLQueryFactory(Provider<Connection> connection) { this(new Configuration(new MySQLTemplates()), connection); }
public MySQLQuery(Connection conn) { this(conn, new Configuration(new MySQLTemplates()), new DefaultQueryMetadata()); }
@Test public void Path_Column2() { PathBuilder<Entity> entity = new PathBuilder<Entity>(Entity.class,"entity"); Configuration conf = new Configuration(new MySQLTemplates()); NativeSQLSerializer serializer = new NativeSQLSerializer(conf, true); serializer.handle(entity.get("firstName")); assertEquals("entity.first_name", serializer.toString()); }
@Test public void Path_Column() { PathBuilder<Entity> entity = new PathBuilder<Entity>(Entity.class,"entity"); Configuration conf = new Configuration(new MySQLTemplates()); NativeSQLSerializer serializer = new NativeSQLSerializer(conf, true); serializer.handle(entity.get("name")); assertEquals("entity.name", serializer.toString()); }
public static SQLTemplates getSQLTemplates() { switch (target.get()) { case CUBRID:return new CUBRIDTemplates(); case DERBY: return new DerbyTemplates(); case H2: return new H2Templates(); case HSQLDB:return new HSQLDBTemplates(); case SQLSERVER: return new SQLServerTemplates(); case MYSQL: return new MySQLTemplates(); case ORACLE:return new OracleTemplates(); case POSTGRES: return new PostgresTemplates(); case SQLITE:return new SQLiteTemplates(); case TERADATA: return new TeradataTemplates(); } throw new IllegalStateException("Unknown mode " + mode); }
@Test public void In() { Configuration conf = new Configuration(new MySQLTemplates()); NativeSQLSerializer serializer = new NativeSQLSerializer(conf, true); DefaultQueryMetadata md = new DefaultQueryMetadata(); SAnimal cat = SAnimal.animal_; md.addJoin(JoinType.DEFAULT, cat); md.addWhere(cat.name.in("X", "Y")); md.addProjection(cat.id); serializer.serialize(md, false); assertEquals("select animal_.id\n" + "from animal_ animal_\n" + "where animal_.name in (?1, ?2)", serializer.toString()); }