Java Version类代码示例

import org.cubeengine.libcube.util.Version; //导入依赖的package包/类
@Override
public void update(Connection connection, Version dbVersion) throws SQLException
{
    if (new Version(1).equals(dbVersion)) // Update to Version 2
    {
        // Remove mask;
        Statement stmt = connection.createStatement();
        stmt.execute("ALTER TABLE `"+ getName()+ "` ADD"
                + "( HIDDEN BOOLEAN, INVITE BOOLEAN, IS_UUID BOOLEAN)");
        stmt.execute("UPDATE TABLE `" + getName() + "` SET "
                        + "HIDDEN = MASK & 1 = 1,"
                        + "INVITE = MASK & 2 = 2,"
                        + "IS_UUID = MASK & 4 = 4");
        stmt.execute("ALTER TABLE `" + getName() +"` DROP COLUMN MASK");
    }
}
 

import org.cubeengine.libcube.util.Version; //导入依赖的package包/类
public TableBalance()
{
    super(BalanceModel.class, "conomy_balance", new Version(1));
    this.setPrimaryKey(ACCOUNT_ID, CURRENCY, CONTEXT);
    this.addFields(ACCOUNT_ID, CURRENCY, CONTEXT, BALANCE);
    this.addForeignKey(TABLE_ACCOUNT.getPrimaryKey(), ACCOUNT_ID);
    TABLE_BALANCE = this;
}
 

import org.cubeengine.libcube.util.Version; //导入依赖的package包/类
public TableAccount()
{
    super(AccountModel.class, "conomy_account", new Version(2));
    this.setPrimaryKey(ID);
    this.addUniqueKey(ID);
    this.addFields(ID, NAME, HIDDEN, INVITE, IS_UUID);
    TABLE_ACCOUNT = this;
}
 

import org.cubeengine.libcube.util.Version; //导入依赖的package包/类
public TableMail()
{
    super(Mail.class, "mail", new Version(1));
    this.setPrimaryKey(ID);
    this.addFields(ID, MESSAGE, USERID, SENDERID);
    TABLE_MAIL = this;
}
 

import org.cubeengine.libcube.util.Version; //导入依赖的package包/类
private boolean updateTableStructure(TableUpdateCreator updater)
{
    Record1<String> result = getDSL().select(TABLE_VERSION.VERSION).from(TABLE_VERSION).where(TABLE_VERSION.NAME.eq(updater.getName())).fetchOne();
    if (result != null)
    {
        try
        {
            Version dbVersion = Version.fromString(result.value1());
            Version version = updater.getTableVersion();
            if (dbVersion.isNewerThan(version))
            {
                logger.info("table-version is newer than expected! {}: {} expected version: {}", updater.getName(),
                        dbVersion.toString(), version.toString());
            }
            else if (dbVersion.isOlderThan(updater.getTableVersion()))
            {
                logger.info("table-version is too old! Updating {} from {} to {}", updater.getName(),
                        dbVersion.toString(), version.toString());
                try (Connection connection = this.getConnection())
                {
                    updater.update(connection, dbVersion);
                }
                getDSL().mergeInto(TABLE_VERSION).values(updater.getName(), version.toString());
                logger.info("{} got updated to {}", updater.getName(), version.toString());
            }
            return true;
        }
        catch (SQLException e)
        {
            logger.warn(e, "Could not execute structure update for the table {}", updater.getName());
        }
    }
    return false;
}
 

import org.cubeengine.libcube.util.Version; //导入依赖的package包/类
public TableLockLocations()
{
    super(LockLocationModel.class, "locker_locations", new Version(1));
    this.setPrimaryKey(ID);
    this.addIndex(CHUNKX, CHUNKZ);
    this.addUniqueKey(WORLD_ID, X, Y, Z);
    this.addForeignKey(TABLE_LOCKS.getPrimaryKey(), LOCK_ID);
    this.addFields(ID, WORLD_ID, X, Y, Z, CHUNKX, CHUNKZ, LOCK_ID);
    TABLE_LOCK_LOCATIONS = this;
}
 

import org.cubeengine.libcube.util.Version; //导入依赖的package包/类
public TableLocks()
{
    super(LockModel.class, "locker_locks", new Version(1));
    this.setPrimaryKey(ID);
    this.addUniqueKey(ENTITY_UUID);
    this.addFields(ID, OWNER_ID, FLAGS, PROTECTED_TYPE, LOCK_TYPE, PASSWORD, ENTITY_UUID, LAST_ACCESS, CREATED);
    TABLE_LOCKS = this;
}
 

import org.cubeengine.libcube.util.Version; //导入依赖的package包/类
public TableAccessList()
{
    super(AccessListModel.class, "locker_accesslist", new Version(1));
    this.setPrimaryKey(ID);
    this.addUniqueKey(USER_ID, LOCK_ID);
    this.addUniqueKey(USER_ID, OWNER_ID);
    this.addForeignKey(TABLE_LOCKS.getPrimaryKey(), LOCK_ID);
    this.addFields(ID, USER_ID, LOCK_ID, LEVEL, OWNER_ID);
    TABLE_ACCESSLIST = this;
}
 

import org.cubeengine.libcube.util.Version; //导入依赖的package包/类
public TableIgnorelist()
{
    super(IgnoreList.class, "chat_ignores", new Version(1));
    this.setPrimaryKey(ID, IGNORE);
    this.addFields(ID, IGNORE);
    TABLE_IGNORE_LIST = this;
}
 

import org.cubeengine.libcube.util.Version; //导入依赖的package包/类
public TableMuted()
{
    super(Muted.class, "mute", new Version(1));
    setPrimaryKey(ID);
    addFields(ID, MUTED);
    TABLE_MUTED = this;
}
 

import org.cubeengine.libcube.util.Version; //导入依赖的package包/类
public TableVote()
{
    super(VoteModel.class, "votecount", new Version(1));
    this.setPrimaryKey(ID);
    this.addFields(ID, LASTVOTE, VOTEAMOUNT);
    TABLE_VOTE = this;
}
 

import org.cubeengine.libcube.util.Version; //导入依赖的package包/类
public TableAuth()
{
    super(Auth.class, "auth", new Version(1));
    setPrimaryKey(ID);
    addFields(ID, PASSWD);
    TABLE_AUTH = this;
}
 

import org.cubeengine.libcube.util.Version; //导入依赖的package包/类
public TableRepairBlock()
{
    super(RepairBlockModel.class, "itemrepair_blocks", new Version(1));
    this.setPrimaryKey(ID);
    this.addUniqueKey(WORLD, X, Y, Z);
    this.addFields(ID, WORLD, X, Y, Z, TYPE);
    TABLE_REPAIR_BLOCK = this;
}
 

import org.cubeengine.libcube.util.Version; //导入依赖的package包/类
public Table(Class<R> model, String name, Version version)
{
    super(name);
    this.model = model;
    this.version = version;
}
 

import org.cubeengine.libcube.util.Version; //导入依赖的package包/类
@Override
public final Version getTableVersion()
{
    return version;
}