Ability to specify autoincrement start values

Ability to specify autoincrement start values

in Liquibase Users • 4 months ago

Hello,

I found a feature request on "Ability to specify autoincrement start values" in jira http://liquibase.jira.com/browse/CORE-40.

And it's marked as fixed in 2.0.2 version. But I couldn't find any documentation about it. How to use that new feature?

Replies(3)

mikemil27..

Re: Ability to specify autoincrement start values

4 months ago

Here's the commit history in GitHub for that update. You can see the code updates and maybe that will help.

Here's a test case from the CreateTableGeneratorTest.java class, look at line 10 and maybe that will help!

@Test
public void testAutoIncrementStartWithIncrementByMySQLDatabase() throws Exception {
for (Database database : TestContext.getInstance().getAllDatabases()) {
if (database instanceof MySQLDatabase) {
CreateTableStatement statement = new CreateTableStatement(SCHEMA_NAME, TABLE_NAME);
statement.addColumn(
COLUMN_NAME1,
TypeConverterFactory.getInstance().findTypeConverter(database).getDataType("BIGINT", true),
new AutoIncrementConstraint(COLUMN_NAME1, BigInteger.valueOf(2), BigInteger.TEN)
);
Sql[] generatedSql = this.generatorUnderTest.generateSql(statement, database, null);
// increment by not supported by MySQL
assertEquals("CREATE TABLE `SCHEMA_NAME`.`TABLE_NAME` (`COLUMN1_NAME` BIGINT AUTO_INCREMENT=2)", generatedSql[0].toSql());
}
}
}

Comment

Guest

Re: Ability to specify autoincrement start values

4 months ago

Thanks for the reply!

I spent some time looking at liquibase source code. Seems described feature is available not for all databases. Well, for my case I use HSQL for unit tests and postgreSQL for production. And I need to add startWith attribute to the ID column in some table.

Then for my changeset

<createTable tableName="some_table">
<column name="id" autoIncrement="true" type="int" startWith="100">
<constraints primaryKey="true" nullable="false" />
</column>
<column name="name" type="text">
<constraints nullable="false" />
</column>
</createTable>

liquibase produces for HSQL

CREATE TABLE some_table (id INT GENERATED BY DEFAULT AS IDENTITY (START WITH 100) NOT NULL, name LONGVARCHAR NOT NULL, CONSTRAINT PK_SOME_TABLE PRIMARY KEY (id))

and for postgreSQL