org.waarp.gateway.ftp.database.model

Class DbModelMysqlFtp

java.lang.Object

org.waarp.common.database.model.DbModelAbstract

org.waarp.common.database.model.DbModelCommonMariadbMySql

org.waarp.common.database.model.DbModelMysql

org.waarp.gateway.ftp.database.model.DbModelMysqlFtp

All Implemented Interfaces:

DbModel

public class DbModelMysqlFtp
extends DbModelMysql

MySQL Database Model implementation

Nested Class Summary

Nested classes/interfaces inherited from class org.waarp.common.database.model.DbModelMysql

DbModelMysql.DbTypeResolverMySQL

Nested classes/interfaces inherited from class org.waarp.common.database.model.DbModelCommonMariadbMySql

DbModelCommonMariadbMySql.DBType

Nested classes/interfaces inherited from class org.waarp.common.database.model.DbModelAbstract

DbModelAbstract.DbTypeResolver

Field Summary

Fields inherited from class org.waarp.common.database.model.DbModelMysql

MYSQL_DRIVER_JRE6, MYSQL_DRIVER_JRE8, mysqlConnectionPoolDataSource, pool

Fields inherited from class org.waarp.common.database.model.DbModelAbstract

dbTypeResolver, MAX_BINARY, MAX_KEY_VARCHAR, MAX_LONGVARCHAR, MAX_VARCHAR

Constructor Summary

Constructors

Constructor and Description
DbModelMysqlFtp(String dbserver, String dbuser, String dbpasswd) Create the object and initialize if necessary the driver

Method Summary

Modifier and Type	Method and Description
void	createTables(DbSession session) Create all necessary tables into the database
boolean	needUpgradeDb(DbSession session, String version, boolean tryFix) Check if Database is ok from version
long	nextSequence(DbSession dbSession)
void	resetSequence(DbSession session, long newvalue) Reset the sequence (example)
boolean	upgradeDb(DbSession session, String version) Upgrade Database from version

Methods inherited from class org.waarp.common.database.model.DbModelMysql

currentNumberOfPooledConnections, getDbConnection, getDbType, releaseResources

Methods inherited from class org.waarp.common.database.model.DbModelCommonMariadbMySql

limitRequest, validConnectionString

Methods inherited from class org.waarp.common.database.model.DbModelAbstract

closeInternalConnection, getDbTypeResolver, validConnection, validConnectionSelect

Methods inherited from class java.lang.Object

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

Constructor Detail

DbModelMysqlFtp

public DbModelMysqlFtp(String dbserver,
                       String dbuser,
                       String dbpasswd)
                throws WaarpDatabaseNoConnectionException

Create the object and initialize if necessary the driver

Parameters:

dbserver -

dbuser -

dbpasswd -

Throws:

WaarpDatabaseNoConnectionException

Method Detail

createTables

public final void createTables(DbSession session)
                        throws WaarpDatabaseNoConnectionException

Description copied from interface: DbModel

Create all necessary tables into the database

Parameters:

session - SQL session

Throws:

WaarpDatabaseNoConnectionException

resetSequence

public final void resetSequence(DbSession session,
                                long newvalue)

Description copied from interface: DbModel

Reset the sequence (example)

Specified by:

resetSequence in interface DbModel

Overrides:

resetSequence in class DbModelCommonMariadbMySql

Parameters:

session - SQL session

nextSequence

public long nextSequence(DbSession dbSession)

Specified by:

nextSequence in interface DbModel

Overrides:

nextSequence in class DbModelCommonMariadbMySql

Returns:

The next unique specialId

upgradeDb

public final boolean upgradeDb(DbSession session,
                               String version)

Description copied from interface: DbModel

Upgrade Database from version

Returns:

True if the Database is upgraded

needUpgradeDb

public final boolean needUpgradeDb(DbSession session,
                                   String version,
                                   boolean tryFix)

Description copied from interface: DbModel

Check if Database is ok from version

tryFix - True will imply a try to fix if possible

Returns:

True if the Database needs an upgrade