Package com.coachconnect.config

Class DatabaseManager

java.lang.Object

com.coachconnect.config.DatabaseManager

public class DatabaseManager
extends Object

SENG3150: Coach Connect Database Manager - Database connection and schema management.

Handles SQLite database connections, schema initialisation, and connection pooling. Manages database lifecycle including table creation, migrations, and connection cleanup with proper resource management.

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
static interface	DatabaseManager.ConnectionProvider

Constructor Summary

Constructors

Constructor	Description
DatabaseManager()
DatabaseManager(DatabaseManager.ConnectionProvider connectionProvider)

Method Summary

Modifier and Type	Method	Description
Connection	getConnection()
static void	initDatabase()	Initialize the database schema if it doesn't exist.
static void	initDatabase(DatabaseManager databaseManager)	Initialize the database schema with a specific DatabaseManager instance.
static void	resetInitialization()	Reset the initialization flag - for testing purposes only.

Methods inherited from class java.lang.Object

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

Constructor Details

DatabaseManager

public DatabaseManager()

DatabaseManager

public DatabaseManager(DatabaseManager.ConnectionProvider connectionProvider)

Method Details

getConnection

public Connection getConnection()
                         throws SQLException

Throws:

SQLException

initDatabase

public static void initDatabase()

Initialize the database schema if it doesn't exist. Creates all required tables.

initDatabase

public static void initDatabase(DatabaseManager databaseManager)

Initialize the database schema with a specific DatabaseManager instance. This overload allows for dependency injection in tests.

resetInitialization

public static void resetInitialization()

Reset the initialization flag - for testing purposes only.