org.javalite.db_migrator

Class DbUtils

java.lang.Object

org.javalite.db_migrator.DbUtils

public class DbUtils
extends Object

Constructor Summary

Constructors

Constructor and Description
DbUtils()

Method Summary

Modifier and Type	Method and Description
static void	attach(Connection connection)
static boolean	blank(String str)
static void	closeConnection()
static void	closeQuietly(Object toClose)
static Connection	connection()
static int	countMigrations()
static int	countRows(String table)
static DatabaseType	databaseType(String url)
static void	detach()
static String	driverClass(String url) Given a jdbc url, this tries to determine the target database and returns the driver class name as a string.
static int	exec(String query)
static String	extractDatabaseName(String url) Given a JDBC connection URL, extract only the database name.
static String	extractServerUrl(String url) Given a JDBC connection URL, generate a new connection URL to connect directly to the database server itself (ie: no database specified).
static void	openConnection(String driver, String url, String username, String password)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

DbUtils

public DbUtils()

Method Detail

driverClass

public static String driverClass(String url)

Given a jdbc url, this tries to determine the target database and returns the driver class name as a string.

Parameters:

url - jdbc url

Returns:

jdbc driver class name

databaseType

public static DatabaseType databaseType(String url)

extractDatabaseName

public static String extractDatabaseName(String url)

Given a JDBC connection URL, extract only the database name.

Parameters:

url - a JDBC connection URL

Returns:

the database name

extractServerUrl

public static String extractServerUrl(String url)

Given a JDBC connection URL, generate a new connection URL to connect directly to the database server itself (ie: no database specified).

Parameters:

url - a JDBC connection URL

Returns:

a new JDBC connection URL to connect directly to the database server

connection

public static Connection connection()

exec

public static int exec(String query)

closeQuietly

public static void closeQuietly(Object toClose)

openConnection

public static void openConnection(String driver,
                                  String url,
                                  String username,
                                  String password)

attach

public static void attach(Connection connection)

detach

public static void detach()

closeConnection

public static void closeConnection()

blank

public static boolean blank(String str)

countMigrations

public static int countMigrations()

countRows

public static int countRows(String table)