@Override protected void createTableHead(final StringBuilder createTableSql, final RepositoryDefinition repositoryDefinition) { /* IF NOT EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[tablename]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1) CREATE TABLE [dbo].[tablename] ( columns specification ); */ createTableSql.append("IF NOT EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[dbo].[").append( repositoryDefinition.getName()).append("]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1) "); }
@Override protected void createTableHead(final StringBuilder createTableSql, final RepositoryDefinition repositoryDefinition) { createTableSql.append("CREATE TABLE IF NOT EXISTS ").append(repositoryDefinition.getName()).append("("); }
@Override protected void createTableHead(final StringBuilder createTableSql, final RepositoryDefinition repositoryDefinition) { createTableSql.append("CREATE TABLE ").append(repositoryDefinition.getName()).append("("); }
@Override protected void createTableHead(final StringBuilder createTableSql, final RepositoryDefinition repositoryDefinition) { createTableSql.append("CREATE TABLE IF NOT EXISTS ").append(repositoryDefinition.getName()).append("("); }
/** * Gets keys of the repository specified by the given repository name. * * @param repositoryName the given repository name * @return keys */ public static List<FieldDefinition> getKeys(final String repositoryName) { final List<RepositoryDefinition> repositoryDefs = getRepositoryDefinitions(); for (final RepositoryDefinition repositoryDefinition : repositoryDefs) { if (StringUtils.equals(repositoryName, repositoryDefinition.getName())) { return repositoryDefinition.getKeys(); } } return null; }
/** * Initializes all tables from repository.json. * * @return List<CreateTableResult> */ public static List<CreateTableResult> initAllTables() { final List<CreateTableResult> ret = new ArrayList<>(); final List<RepositoryDefinition> repositoryDefs = getRepositoryDefinitions(); boolean isSuccess = false; for (final RepositoryDefinition repositoryDef : repositoryDefs) { try { isSuccess = JdbcFactory.createJdbcFactory().createTable(repositoryDef); } catch (final SQLException e) { LOGGER.log(Level.ERROR, "Creates table [" + repositoryDef.getName() + "] error", e); } ret.add(new CreateTableResult(repositoryDef.getName(), isSuccess)); } return ret; }
/** * Gets keys of the repository specified by the given repository name. * * @param repositoryName the given repository name * @return keys */ public static List<FieldDefinition> getKeys(final String repositoryName) { final List<RepositoryDefinition> repositoryDefs = getRepositoryDefinitions(); for (final RepositoryDefinition repositoryDefinition : repositoryDefs) { if (StringUtils.equals(repositoryName, repositoryDefinition.getName())) { return repositoryDefinition.getKeys(); } } return null; }
/** * Initializes all tables from repository.json. * * @return List<CreateTableResult> */ public static List<CreateTableResult> initAllTables() { final List<CreateTableResult> ret = new ArrayList<>(); final List<RepositoryDefinition> repositoryDefs = getRepositoryDefinitions(); boolean isSuccess = false; for (final RepositoryDefinition repositoryDef : repositoryDefs) { try { isSuccess = JdbcFactory.createJdbcFactory().createTable(repositoryDef); } catch (final SQLException e) { LOGGER.log(Level.ERROR, "Creates table [" + repositoryDef.getName() + "] error", e); } ret.add(new CreateTableResult(repositoryDef.getName(), isSuccess)); } return ret; }