package liquibase.database.core;
import liquibase.database.AbstractJdbcDatabaseTest;
import liquibase.database.Database;
import org.junit.Assert;
import static org.junit.Assert.*;
import org.junit.Test;
/**
* Tests for {@link MySQLDatabase}
*/
public class MySQLDatabaseTest extends AbstractJdbcDatabaseTest {
public MySQLDatabaseTest() throws Exception {
super(new MySQLDatabase());
}
@Override
protected String getProductNameString() {
return "MySQL";
}
@Override
@Test
public void supportsInitiallyDeferrableColumns() {
assertFalse(getDatabase().supportsInitiallyDeferrableColumns());
}
@Override
@Test
public void getCurrentDateTimeFunction() {
Assert.assertEquals("NOW()", getDatabase().getCurrentDateTimeFunction());
}
public void testGetDefaultDriver() {
Database database = new MySQLDatabase();
assertEquals("com.mysql.jdbc.Driver", database.getDefaultDriver("jdbc:mysql://localhost/liquibase"));
assertNull(database.getDefaultDriver("jdbc:db2://localhost;databaseName=liquibase"));
}
@Override
@Test
public void escapeTableName_noSchema() {
Database database = getDatabase();
assertEquals("tableName", database.escapeTableName(null, null, "tableName"));
}
@Override
@Test
public void escapeTableName_withSchema() {
Database database = getDatabase();
assertEquals("catalogName.tableName", database.escapeTableName("catalogName", "schemaName", "tableName"));
}
@Test
public void escapeStringForDatabase_withBackslashes() {
Assert.assertEquals("\\\\0", database.escapeStringForDatabase("\\0"));
}
}