com.jpattern.orm.crud.OrmCRUDQueryGenerator java code examples

Add the Codota plugin to your IDE and get smart completions

private void myMethod () {
 Connection c =DataSource dataSource;dataSource.getConnection()
String url;DriverManager.getConnection(url)
IdentityDatabaseUtil.getDBConnection()
Smart code suggestions by Codota
}

private String generateSaveQuery(boolean ignoreGenerators) {
  final StringBuilder builder = new StringBuilder("INSERT INTO ");
  builder.append(classMapper.getTableMap().getTableNameWithSchema());
  builder.append(" (");
  builder.append( columnToCommaSepareted( getColumnNames(classMapper , "", classMapper.getAllColumnJavaNames()), ignoreGenerators ));
  builder.append(") VALUES (");
  builder.append( questionCommaSepareted( classMapper, getColumnNames(classMapper , "", classMapper.getAllColumnJavaNames()), ignoreGenerators ));
  builder.append(")");
  final String query = builder.toString();
  logger.info("generateSaveQuery", "Generated INSERT query (with generators? " + !ignoreGenerators + ") for table [" + classMapper.getTableMap().getTableNameWithSchema() + "]:\n" + query );
  return query;
}

private String generateUpdateQuery() {
  final StringBuilder builder = new StringBuilder("UPDATE ");
  builder.append(classMapper.getTableMap().getTableNameWithSchema());
  builder.append(" SET ");
  if ( classMapper.getNotPrimaryKeyColumnJavaNames().length>0 ) {
    builder.append( columnToSetClause( getColumnNames(classMapper, "", classMapper.getNotPrimaryKeyColumnJavaNames()) ));
  }
  if ( classMapper.getPrimaryKeyColumnJavaNames().length>0 ) {
    builder.append(" WHERE ");
    builder.append( columnToWhereClause( getColumnNames(classMapper, "", classMapper.getPrimaryKeyColumnJavaNames()) ));
  }
  final String query = builder.toString();
  logger.info("generateUpdateQuery", "Generated UPDATE query for table [" + classMapper.getTableMap().getTableNameWithSchema() + "]:\n" + query );
  return query;
}

@Override
public IOrmCRUDQuery generate() {
  final OrmCRUDQuery crud = new OrmCRUDQuery();
  crud.setDeleteQuery( generateDeleteQuery() );
  crud.setLoadQuery(  generateLoadQuery() );
  crud.setSaveQuery(  generateSaveQuery(false) );
  crud.setSaveQueryWithoutGenerators( generateSaveQuery(true) );
  crud.setUpdateQuery(  generateUpdateQuery() );
  crud.setBaseSelectClause(  generateBaseSelectClause() );
  crud.setBaseFromClause(  generateBaseFromClause() );
  crud.setBeanVersionQuery( generateBeanVersionQuery() );
  return crud;
}

private String generateBaseSelectClause() {
  return columnToCommaSepareted( getColumnNames(classMapper , ICrudConstants.ROW_NAME_PREFIX_PLACEHOLDER, classMapper.getAllColumnJavaNames()), true );
}

public void ormCrudWithSchema(final SessionProvider sessionProvider) throws Exception {
  final IClassMap<Zoo_People> classMapper = new ClassMapBuilder<Zoo_People>(Zoo_People.class).generate();
  assertNotNull(classMapper);
  final OrmCRUDQueryGenerator<Zoo_People> ormGenerator = new OrmCRUDQueryGenerator<Zoo_People>(new DefaultDialect(), classMapper);
  final CRUDQuery ormCrudQuery = ormGenerator.generate();
  assertNotNull(ormCrudQuery);
  System.out.println(ormCrudQuery.getLoadQuery());
  System.out.println(ormCrudQuery.getUpdateQuery());
  System.out.println(ormCrudQuery.getDeleteQuery());
  System.out.println(ormCrudQuery.getSaveQuery());
}

public void ormCrudWithSequence(SessionProvider sessionProvider) throws Exception {
  final Class<People> clazz = People.class;
  final TableMap<People> tableMap = new TableMap<People>();
  new ClassTableMapBuilder<People>(clazz, tableMap).updateTableMap();
  final IClassMapperBuilder<People> classMapperGenerator = new ClassMapperBuilder<People>(clazz, tableMap);
  final IClassMapper<People> classMapper = classMapperGenerator.generate();
  assertNotNull(classMapper);
  final IOrmCRUDQueryGenerator<People> ormGenerator = new OrmCRUDQueryGenerator<People>(new DefaultDialect(), classMapper);
  final IOrmCRUDQuery ormCrudQuery = ormGenerator.generate();
  assertNotNull(ormCrudQuery);
  System.out.println(ormCrudQuery.getLoadQuery());
  System.out.println(ormCrudQuery.getUpdateQuery());
  System.out.println(ormCrudQuery.getDeleteQuery());
  System.out.println(ormCrudQuery.getSaveQuery());
}

private String generateLoadQuery() {
  final StringBuilder builder = new StringBuilder("SELECT * FROM ");
  builder.append(classMapper.getTableMap().getTableNameWithSchema());
  if ( classMapper.getPrimaryKeyColumnJavaNames().length>0 ) {
    builder.append(" WHERE ");
    builder.append( columnToWhereClause( getColumnNames(classMapper, "", classMapper.getPrimaryKeyColumnJavaNames()) ));
  }
  final String query = builder.toString();
  logger.info("generateLoadQuery", "Generated SELECT query for table [" + classMapper.getTableMap().getTableNameWithSchema() + "]:\n" + query );
  return query;
}

public void ormCrud(final SessionProvider sessionProvider) throws Exception {
  final IClassMap<Employee> classMapper = new ClassMapBuilder<Employee>(Employee.class).generate();
  assertNotNull(classMapper);
  final OrmCRUDQueryGenerator<Employee> ormGenerator = new OrmCRUDQueryGenerator<Employee>(new DefaultDialect(), classMapper);
  final CRUDQuery ormCrudQuery = ormGenerator.generate();
  assertNotNull(ormCrudQuery);
  System.out.println(ormCrudQuery.getLoadQuery());
  System.out.println(ormCrudQuery.getUpdateQuery());
  System.out.println(ormCrudQuery.getDeleteQuery());
  System.out.println(ormCrudQuery.getSaveQuery());
}

public void ormCrudWithSchema(SessionProvider sessionProvider) throws Exception {
  final Class<Zoo_People> clazz = Zoo_People.class;
  final TableMap<Zoo_People> tableMap = new TableMap<Zoo_People>();
  new ClassTableMapBuilder<Zoo_People>(clazz, tableMap).updateTableMap();
  final IClassMapperBuilder<Zoo_People> classMapperGenerator = new ClassMapperBuilder<Zoo_People>(clazz, tableMap);
  final IClassMapper<Zoo_People> classMapper = classMapperGenerator.generate();
  assertNotNull(classMapper);
  final IOrmCRUDQueryGenerator<Zoo_People> ormGenerator = new OrmCRUDQueryGenerator<Zoo_People>(new DefaultDialect(), classMapper);
  final IOrmCRUDQuery ormCrudQuery = ormGenerator.generate();
  assertNotNull(ormCrudQuery);
  System.out.println(ormCrudQuery.getLoadQuery());
  System.out.println(ormCrudQuery.getUpdateQuery());
  System.out.println(ormCrudQuery.getDeleteQuery());
  System.out.println(ormCrudQuery.getSaveQuery());
}

private String generateDeleteQuery() {
  final StringBuilder builder = new StringBuilder("DELETE FROM ");
  builder.append(classMapper.getTableMap().getTableNameWithSchema());
  if ( classMapper.getPrimaryKeyColumnJavaNames().length>0 ) {
    builder.append(" WHERE ");
    builder.append( columnToWhereClause( getColumnNames(classMapper, "", classMapper.getPrimaryKeyColumnJavaNames()) ));
  }
  final String query = builder.toString();
  logger.info("generateDeleteQuery", "Generated DELETE query for table [" + classMapper.getTableMap().getTableNameWithSchema() + "]:\n" + query );
  return query;
}

public void ormCrudWithSequence(final SessionProvider sessionProvider) throws Exception {
  final IClassMap<People> classMapper = new ClassMapBuilder<People>(People.class).generate();
  assertNotNull(classMapper);
  final OrmCRUDQueryGenerator<People> ormGenerator = new OrmCRUDQueryGenerator<People>(new DefaultDialect(), classMapper);
  final CRUDQuery ormCrudQuery = ormGenerator.generate();
  assertNotNull(ormCrudQuery);
  System.out.println(ormCrudQuery.getLoadQuery());
  System.out.println(ormCrudQuery.getUpdateQuery());
  System.out.println(ormCrudQuery.getDeleteQuery());
  System.out.println(ormCrudQuery.getSaveQuery());
}

public void ormCrud(SessionProvider sessionProvider) throws Exception {
  final Class<Employee> clazz = Employee.class;
  final TableMap<Employee> tableMap = new TableMap<Employee>();
  new ClassTableMapBuilder<Employee>(clazz, tableMap).updateTableMap();
  final IClassMapperBuilder<Employee> classMapperGenerator = new ClassMapperBuilder<Employee>(clazz, tableMap);
  final IClassMapper<Employee> classMapper = classMapperGenerator.generate();
  assertNotNull(classMapper);
  final IOrmCRUDQueryGenerator<Employee> ormGenerator = new OrmCRUDQueryGenerator<Employee>(new DefaultDialect(), classMapper);
  final IOrmCRUDQuery ormCrudQuery = ormGenerator.generate();
  assertNotNull(ormCrudQuery);
  System.out.println(ormCrudQuery.getLoadQuery());
  System.out.println(ormCrudQuery.getUpdateQuery());
  System.out.println(ormCrudQuery.getDeleteQuery());
  System.out.println(ormCrudQuery.getSaveQuery());
}

private String generateBeanVersionQuery() {
  String query = "";
  final ITableMap<T> tableMap = classMapper.getTableMap();
  if (tableMap.isVersionable()) {
    final StringBuilder builder = new StringBuilder("SELECT count(*) FROM ");
    builder.append(classMapper.getTableMap().getTableNameWithSchema());
    if ( classMapper.getPrimaryKeyColumnJavaNames().length>0 ) {
      builder.append(" WHERE ");
      final String[] pk = classMapper.getPrimaryKeyColumnJavaNames();
      final String[] pkAndVersion = new String[ pk.length + 1 ];
      for (int i=0 ; i<(pk.length); i++) {
        pkAndVersion[i] = pk[i];
      }
      pkAndVersion[pkAndVersion.length-1] = tableMap.getVersionJavaFieldName() ;
      builder.append( columnToWhereClause( getColumnNames(classMapper, "", pkAndVersion ) ));
    }
    builder.append( tableMap.getVersionLoadLockMode().getLockMode() );
    query = builder.toString();
  }
  logger.info("generateBeanVersionQuery", "Generated query to load the version of a record for table [" + classMapper.getTableMap().getTableNameWithSchema() + "]:\n" + query );
  return query;
}

@Override
public <T> void register(final Class<T> clazz) throws OrmConfigurationException {
  logger.info("register", "register new class: " + clazz.getName());
  try {
    final TableMap<T> tableMap = new TableMap<T>();
    new ClassTableMapBuilder<T>(clazz, tableMap).updateTableMap();
    final IClassMapper<T> classMapper = new ClassMapperBuilder<T>(clazz, tableMap).generate();
    final IOrmPersistor<T> ormPersistor = generatorStrategy.getGenerator(classMapper, "" + instanceCount, resultSetMethodHelper).generate();
    final IOrmCRUDQuery ormCRUDQuery = new OrmCRUDQueryGenerator<T>(dialect, classMapper).generate();
    final IOrmClassTool<T> ormClassTool = new OrmClassTool<T>(classMapper, ormPersistor, ormCRUDQuery);
    ormClassToolMap.put(clazz, ormClassTool);
  } catch (final Exception e) {
    throw new OrmConfigurationException(e);
  }
}

  public void ormCrudSelectFromClause(SessionProvider sessionProvider) throws Exception {
    final Class<Zoo_People> clazz = Zoo_People.class;
    final TableMap<Zoo_People> tableMap = new TableMap<Zoo_People>();
    new ClassTableMapBuilder<Zoo_People>(clazz, tableMap).updateTableMap();
    final IClassMapperBuilder<Zoo_People> classMapperGenerator = new ClassMapperBuilder<Zoo_People>(clazz, tableMap);
    final IClassMapper<Zoo_People> classMapper = classMapperGenerator.generate();
    assertNotNull(classMapper);

    final IOrmCRUDQueryGenerator<Zoo_People> ormGenerator = new OrmCRUDQueryGenerator<Zoo_People>(new DefaultDialect(), classMapper);
    final IOrmCRUDQuery ormCrudQuery = ormGenerator.generate();
    assertNotNull(ormCrudQuery);

    System.out.println(ormCrudQuery.getBaseSelectClause());
    System.out.println(ormCrudQuery.getBaseSelectClause("alias."));
    System.out.println(ormCrudQuery.getBaseFromClause());

    assertEquals("ZOO.PEOPLE.FIRSTCLOB, ZOO.PEOPLE.ID, ZOO.PEOPLE.SECONDBLOB, ZOO.PEOPLE.BIRTHDATE, ZOO.PEOPLE.LASTNAME, ZOO.PEOPLE.FIRSTNAME, ZOO.PEOPLE.FIRSTBLOB, ZOO.PEOPLE.DEATHDATE", ormCrudQuery.getBaseSelectClause());
    assertEquals("alias.FIRSTCLOB, alias.ID, alias.SECONDBLOB, alias.BIRTHDATE, alias.LASTNAME, alias.FIRSTNAME, alias.FIRSTBLOB, alias.DEATHDATE", ormCrudQuery.getBaseSelectClause("alias."));
    assertEquals("ZOO.PEOPLE", ormCrudQuery.getBaseFromClause());

  }
}

  public void ormCrudSelectFromClause(final SessionProvider sessionProvider) throws Exception {
    final IClassMap<Zoo_People> classMapper = new ClassMapBuilder<Zoo_People>(Zoo_People.class).generate();
    assertNotNull(classMapper);

    final OrmCRUDQueryGenerator<Zoo_People> ormGenerator = new OrmCRUDQueryGenerator<Zoo_People>(new DefaultDialect(), classMapper);
    final CRUDQuery ormCrudQuery = ormGenerator.generate();
    assertNotNull(ormCrudQuery);

    System.out.println(ormCrudQuery.getBaseSelectClause());
    System.out.println(ormCrudQuery.getBaseSelectClause("alias."));
    System.out.println(ormCrudQuery.getBaseFromClause());

    assertEquals("ZOO.PEOPLE.FIRSTCLOB, ZOO.PEOPLE.ID, ZOO.PEOPLE.SECONDBLOB, ZOO.PEOPLE.BIRTHDATE, ZOO.PEOPLE.LASTNAME, ZOO.PEOPLE.FIRSTNAME, ZOO.PEOPLE.FIRSTBLOB, ZOO.PEOPLE.DEATHDATE", ormCrudQuery.getBaseSelectClause());
    assertEquals("alias.FIRSTCLOB, alias.ID, alias.SECONDBLOB, alias.BIRTHDATE, alias.LASTNAME, alias.FIRSTNAME, alias.FIRSTBLOB, alias.DEATHDATE", ormCrudQuery.getBaseSelectClause("alias."));
    assertEquals("ZOO.PEOPLE", ormCrudQuery.getBaseFromClause());

  }
}

Most used methods

Popular in Java

Making http requests using okhttp
getApplicationContext (Context)
scheduleAtFixedRate (Timer)
Schedules the specified task for repeated fixed-rate execution, beginning after the specified delay.
getResourceAsStream (ClassLoader)
Returns a stream for the resource with the specified name. See #getResource(String) for a descriptio
FileOutputStream (java.io)
A file output stream is an output stream for writing data to aFile or to a FileDescriptor. Whether
Runnable (java.lang)
Represents a command that can be executed. Often used to run code in a different Thread.
TimeUnit (java.util.concurrent)
A TimeUnit represents time durations at a given unit of granularity and provides utility methods to
SSLHandshakeException (javax.net.ssl)
The exception that is thrown when a handshake could not be completed successfully.
Filter (javax.servlet)
A filter is an object that performs filtering tasks on either the request to a resource (a servlet o
JList (javax.swing)

How to useOrmCRUDQueryGenerator in com.jpattern.orm.crud

Best Java code snippets using com.jpattern.orm.crud.OrmCRUDQueryGenerator (Showing top 16 results out of 315)

How to use
OrmCRUDQueryGenerator
in
com.jpattern.orm.crud