@Test public void fail_when_table_is_null() { expectedException.expect(NullPointerException.class); new DropTableBuilder(new PostgreSql(), null); } }
@Override public void init(DatabaseMetaData metaData) throws SQLException { checkState(!initialized, "onInit() must be called once"); Version version = checkDbVersion(metaData, MIN_SUPPORTED_VERSION); supportsUpsert = version.compareTo(MIN_UPSERT_VERSION) >= 0; if (!supportsUpsert) { Loggers.get(getClass()).warn("Upgrading PostgreSQL to {} or greater is recommended for better performances", MIN_UPSERT_VERSION); } initialized = true; } }
@Test public void should_set_connection_properties() { assertThat(underTest.getConnectionInitStatements()).isEqualTo(PostgreSql.INIT_STATEMENTS); }
@Test public void should_configure() { assertThat(underTest.getId()).isEqualTo("postgresql"); assertThat(underTest.getDefaultDriverClassName()).isEqualTo("org.postgresql.Driver"); assertThat(underTest.getValidationQuery()).isEqualTo("SELECT 1"); }
@Test public void testBooleanSqlValues() { assertThat(underTest.getTrueSqlValue()).isEqualTo("true"); assertThat(underTest.getFalseSqlValue()).isEqualTo("false"); }
@Test public void testFetchSizeForScrolling() { assertThat(underTest.getScrollDefaultFetchSize()).isEqualTo(200); }
@Test public void getSqlFromDual() { assertThat(underTest.getSqlFromDual()).isEqualTo(""); }
@Test public void generateSqlType_for_PostgreSql() { assertThat(underTest.generateSqlType(new PostgreSql())).isEqualTo("BYTEA"); }
@Override public void init(DatabaseMetaData metaData) throws SQLException { checkState(!initialized, "onInit() must be called once"); Version version = checkDbVersion(metaData, MIN_SUPPORTED_VERSION); supportsUpsert = version.compareTo(MIN_UPSERT_VERSION) >= 0; if (!supportsUpsert) { Loggers.get(getClass()).warn("Upgrading PostgreSQL to {} or greater is recommended for better performances", MIN_UPSERT_VERSION); } initialized = true; } }
@Test public void generate_sql_type_on_postgre() { assertThat(underTest.generateSqlType(new PostgreSql())).isEqualTo("TEXT"); }
@Test public void generateSqlType_for_PostgreSql() { assertThat(underTest.generateSqlType(new PostgreSql())).isEqualTo("INTEGER"); }
@Test public void verify_generated_sql_on_postgresql() throws SQLException { when(database.getDialect()).thenReturn(new PostgreSql()); DdlChange.Context context = mock(DdlChange.Context.class); underTest.execute(context); verify(context).execute(singletonList("ALTER TABLE ce_activity DROP COLUMN snapshot_id")); }
@Test public void drop_tables_on_postgresql() { assertThat(new DropTableBuilder(new PostgreSql(), "issues") .build()).containsOnly("drop table if exists issues"); }
@Test public void drop_columns_on_postgresql() { assertThat(new DropColumnsBuilder(new PostgreSql(), "issues", "date_in_ms", "name").build()) .containsOnly("ALTER TABLE issues DROP COLUMN date_in_ms, DROP COLUMN name"); }
@Test public void verify_generated_sql_on_postgresql() throws SQLException { when(database.getDialect()).thenReturn(new PostgreSql()); DdlChange.Context context = mock(DdlChange.Context.class); underTest.execute(context); verify(context).execute(singletonList("ALTER TABLE project_measures DROP COLUMN snapshot_id")); }
@Test public void verify_generated_sql_on_postgresql() throws SQLException { when(database.getDialect()).thenReturn(new PostgreSql()); DdlChange.Context context = mock(DdlChange.Context.class); underTest.execute(context); verify(context).execute(singletonList("ALTER TABLE project_measures DROP COLUMN project_id")); }
@Test public void verify_generated_sql_on_postgresql() throws SQLException { when(database.getDialect()).thenReturn(new PostgreSql()); DdlChange.Context context = mock(DdlChange.Context.class); underTest.execute(context); verify(context).execute( singletonList("ALTER TABLE projects DROP COLUMN root_id, DROP COLUMN copy_resource_id, DROP COLUMN person_id")); }
@Test public void verify_generated_sql_on_postgresql() throws SQLException { when(database.getDialect()).thenReturn(new PostgreSql()); DdlChange.Context context = mock(DdlChange.Context.class); underTest.execute(context); verify(context).execute( singletonList( "ALTER TABLE snapshots DROP COLUMN parent_snapshot_id, DROP COLUMN scope, DROP COLUMN qualifier, DROP COLUMN root_snapshot_id, DROP COLUMN path, DROP COLUMN depth, DROP COLUMN root_component_uuid")); }
@Test public void verify_generated_sql_on_postgresql() throws SQLException { when(database.getDialect()).thenReturn(new PostgreSql()); DdlChange.Context context = mock(DdlChange.Context.class); underTest.execute(context); verify(context).execute( singletonList("ALTER TABLE dashboards DROP COLUMN is_global")); } }
@Test public void verify_generated_sql_on_postgresql() throws SQLException { when(database.getDialect()).thenReturn(new PostgreSql()); DdlChange.Context context = mock(DdlChange.Context.class); underTest.execute(context); verify(context).execute(singletonList("ALTER TABLE events DROP COLUMN snapshot_id")); }