Examples with Column me.staartvin.statz.database.datatype.Column used on opensource projects

Example 1 with Column

use of me.staartvin.statz.database.datatype.Column in project Statz by Staartvin.

the class MySQLConnector method loadTables.

@Override
public void loadTables() {
    // UUID table to look up uuid of players
    MySQLTable newTable = new MySQLTable("players");
    Column id = new Column("id", true, SQLDataType.INT, true);
    id.setAutoIncrement(true);
    Column uuid = new Column("uuid", false, SQLDataType.TEXT, true, true);
    // Populate table
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    // Name of
    newTable.addColumn("playerName", false, SQLDataType.TEXT);
    // player
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How many times did a player join this server?
    newTable = new MySQLTable(PlayerStat.JOINS.getTableName());
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    // How many times
    newTable.addColumn("value", false, SQLDataType.INT);
    // did the player
    // join.
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How many times did a player die?
    newTable = new MySQLTable(PlayerStat.DEATHS.getTableName());
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    // How many times did the player die.
    newTable.addColumn("value", false, SQLDataType.INT);
    // What world did the player die.
    newTable.addColumn("world", false, SQLDataType.TEXT);
    newTable.addUniqueMatched("uuid");
    newTable.addUniqueMatched("world");
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How many times did a player catch an item and what type?
    newTable = new MySQLTable(PlayerStat.ITEMS_CAUGHT.getTableName());
    newTable.addColumn(id);
    Column caught = new Column("caught", false, SQLDataType.TEXT, true);
    Column world = new Column("world", false, SQLDataType.TEXT, true);
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT);
    newTable.addColumn(caught);
    newTable.addColumn(world);
    newTable.addUniqueMatched("uuid");
    newTable.addUniqueMatched("world");
    newTable.addUniqueMatched("caught");
    this.addTable(newTable);
    // ----------------------------------------------------------
    // What block did a player place and how many times?
    newTable = new MySQLTable(PlayerStat.BLOCKS_PLACED.getTableName());
    newTable.addColumn(id);
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    Column typeID = new Column("typeid", false, SQLDataType.INT, true);
    Column dataValue = new Column("datavalue", false, SQLDataType.INT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT);
    newTable.addColumn(world);
    newTable.addColumn(typeID);
    newTable.addColumn(dataValue);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(typeID);
    newTable.addUniqueMatched(dataValue);
    newTable.addUniqueMatched(world);
    this.addTable(newTable);
    // ----------------------------------------------------------
    // What block did a player break and how many times?
    newTable = new MySQLTable(PlayerStat.BLOCKS_BROKEN.getTableName());
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    typeID = new Column("typeid", false, SQLDataType.INT, true);
    dataValue = new Column("datavalue", false, SQLDataType.INT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT);
    newTable.addColumn(world);
    newTable.addColumn(typeID);
    newTable.addColumn(dataValue);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(typeID);
    newTable.addUniqueMatched(dataValue);
    newTable.addUniqueMatched(world);
    this.addTable(newTable);
    // ----------------------------------------------------------
    // What mobs did a player kill?
    newTable = new MySQLTable(PlayerStat.KILLS_MOBS.getTableName());
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    typeID = new Column("mob", false, SQLDataType.TEXT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    Column weapon = new Column("weapon", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT);
    newTable.addColumn(world);
    newTable.addColumn(typeID);
    newTable.addColumn(weapon);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(typeID);
    newTable.addUniqueMatched(world);
    newTable.addUniqueMatched(weapon);
    this.addTable(newTable);
    // ----------------------------------------------------------
    // What players did a player kill?
    newTable = new MySQLTable(PlayerStat.KILLS_PLAYERS.getTableName());
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    typeID = new Column("playerKilled", false, SQLDataType.TEXT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT);
    newTable.addColumn(world);
    newTable.addColumn(typeID);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(typeID);
    newTable.addUniqueMatched(world);
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How long did a player play (in minutes)?
    newTable = new MySQLTable(PlayerStat.TIME_PLAYED.getTableName());
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT);
    newTable.addColumn(world);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(world);
    this.addTable(newTable);
    // ----------------------------------------------------------
    // What food did a player eat?
    newTable = new MySQLTable(PlayerStat.FOOD_EATEN.getTableName());
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    typeID = new Column("foodEaten", false, SQLDataType.TEXT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT);
    newTable.addColumn(world);
    newTable.addColumn(typeID);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(typeID);
    newTable.addUniqueMatched(world);
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How much damage has a player taken?
    newTable = new MySQLTable(PlayerStat.DAMAGE_TAKEN.getTableName());
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    typeID = new Column("cause", false, SQLDataType.TEXT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT);
    newTable.addColumn(world);
    newTable.addColumn(typeID);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(typeID);
    newTable.addUniqueMatched(world);
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How many sheep did a player shear?
    newTable = new MySQLTable(PlayerStat.TIMES_SHORN.getTableName());
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT);
    newTable.addColumn(world);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(world);
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How far and in what way has a player travelled?
    newTable = new MySQLTable(PlayerStat.DISTANCE_TRAVELLED.getTableName());
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    typeID = new Column("moveType", false, SQLDataType.TEXT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.DOUBLE);
    newTable.addColumn(world);
    newTable.addColumn(typeID);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(typeID);
    newTable.addUniqueMatched(world);
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How far and in what way has a player travelled?
    newTable = new MySQLTable(PlayerStat.ITEMS_CRAFTED.getTableName());
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    typeID = new Column("item", false, SQLDataType.TEXT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT);
    newTable.addColumn(world);
    newTable.addColumn(typeID);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(typeID);
    newTable.addUniqueMatched(world);
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How much XP did a player gain?
    newTable = new MySQLTable(PlayerStat.XP_GAINED.getTableName());
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT);
    newTable.addColumn(world);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(world);
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How many times did a player vote for this server?
    newTable = new MySQLTable(PlayerStat.VOTES.getTableName());
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    // How many times
    newTable.addColumn("value", false, SQLDataType.INT);
    // did the player
    // vote.
    newTable.addUniqueMatched(uuid);
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How many arrows did a player shoot?
    newTable = new MySQLTable(PlayerStat.ARROWS_SHOT.getTableName());
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    typeID = new Column("forceShot", false, SQLDataType.DOUBLE, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT, true);
    newTable.addColumn(world);
    newTable.addColumn(typeID);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(world);
    newTable.addUniqueMatched(typeID);
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How many times did a player enter a bed?
    newTable = new MySQLTable(PlayerStat.ENTERED_BEDS.getTableName());
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT, true);
    newTable.addColumn(world);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(world);
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How many times did a player perform a command?
    newTable = new MySQLTable(PlayerStat.COMMANDS_PERFORMED.getTableName());
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT, true);
    newTable.addColumn(world);
    newTable.addColumn("command", false, SQLDataType.TEXT, true);
    newTable.addColumn("arguments", false, SQLDataType.TEXT, true);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(world);
    newTable.addUniqueMatched("command");
    newTable.addUniqueMatched("arguments");
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How many times did a player get kicked?
    newTable = new MySQLTable(PlayerStat.TIMES_KICKED.getTableName());
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT, true);
    newTable.addColumn(world);
    newTable.addColumn("reason", false, SQLDataType.TEXT, true);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(world);
    newTable.addUniqueMatched("reason");
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How many tools did a player break?
    newTable = new MySQLTable(PlayerStat.TOOLS_BROKEN.getTableName());
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT, true);
    newTable.addColumn(world);
    newTable.addColumn("item", false, SQLDataType.TEXT, true);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(world);
    newTable.addUniqueMatched("item");
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How many eggs did a player throw?
    newTable = new MySQLTable(PlayerStat.EGGS_THROWN.getTableName());
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT, true);
    newTable.addColumn(world);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(world);
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How many times did a player switch worlds?
    newTable = new MySQLTable(PlayerStat.WORLDS_CHANGED.getTableName());
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT, true);
    newTable.addColumn(world);
    newTable.addColumn("destWorld", false, SQLDataType.TEXT, true);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(world);
    newTable.addUniqueMatched("destWorld");
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How many times did a player fill a bucket?
    newTable = new MySQLTable(PlayerStat.BUCKETS_FILLED.getTableName());
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT, true);
    newTable.addColumn(world);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(world);
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How many times did a player empty a bucket?
    newTable = new MySQLTable(PlayerStat.BUCKETS_EMPTIED.getTableName());
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT, true);
    newTable.addColumn(world);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(world);
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How many items did a player drop?
    newTable = new MySQLTable(PlayerStat.ITEMS_DROPPED.getTableName());
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    typeID = new Column("item", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT, true);
    newTable.addColumn(world);
    newTable.addColumn(typeID);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(world);
    newTable.addUniqueMatched(typeID);
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How many items did a player pick up?
    newTable = new MySQLTable(PlayerStat.ITEMS_PICKED_UP.getTableName());
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    typeID = new Column("item", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT, true);
    newTable.addColumn(world);
    newTable.addColumn(typeID);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(world);
    newTable.addUniqueMatched(typeID);
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How many times did a player teleport?
    newTable = new MySQLTable(PlayerStat.TELEPORTS.getTableName());
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT, true);
    newTable.addColumn(world);
    newTable.addColumn("destWorld", false, SQLDataType.TEXT, true);
    newTable.addColumn("cause", false, SQLDataType.TEXT, true);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(world);
    newTable.addUniqueMatched("destWorld");
    newTable.addUniqueMatched("cause");
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How many times did a player trade with villagers?
    newTable = new MySQLTable(PlayerStat.VILLAGER_TRADES.getTableName());
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT, true);
    newTable.addColumn(world);
    newTable.addColumn("trade", false, SQLDataType.TEXT, true);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(world);
    newTable.addUniqueMatched("trade");
    this.addTable(newTable);
}

Example 2 with Column

use of me.staartvin.statz.database.datatype.Column in project Statz by Staartvin.

the class SQLiteConnector method loadTables.

@Override
public void loadTables() {
    // UUID table to look up uuid of players
    SQLiteTable newTable = new SQLiteTable("players");
    Column id = new Column("id", true, SQLDataType.INT, true);
    // Populate table
    // UUID of the player
    newTable.addColumn("uuid", true, SQLDataType.TEXT);
    // Name of player
    newTable.addColumn("playerName", false, SQLDataType.TEXT);
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How many times did a player join this server?
    newTable = new SQLiteTable(PlayerStat.JOINS.getTableName());
    // UUID of the player
    newTable.addColumn("uuid", true, SQLDataType.TEXT);
    // How many times did the player join.
    newTable.addColumn("value", false, SQLDataType.INT);
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How many times did a player die?
    newTable = new SQLiteTable(PlayerStat.DEATHS.getTableName());
    id = new Column("id", true, SQLDataType.INT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn("uuid", false, SQLDataType.TEXT);
    // How many times did the player die.
    newTable.addColumn("value", false, SQLDataType.INT);
    // What world did the player die.
    newTable.addColumn("world", false, SQLDataType.TEXT);
    newTable.addUniqueMatched("uuid");
    newTable.addUniqueMatched("world");
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How many times did a player catch an item and what type?
    newTable = new SQLiteTable(PlayerStat.ITEMS_CAUGHT.getTableName());
    id = new Column("id", true, SQLDataType.INT, true);
    newTable.addColumn(id);
    Column uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    Column caught = new Column("caught", false, SQLDataType.TEXT, true);
    Column world = new Column("world", false, SQLDataType.TEXT, true);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT);
    newTable.addColumn(caught);
    newTable.addColumn(world);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(caught);
    newTable.addUniqueMatched(world);
    this.addTable(newTable);
    // ----------------------------------------------------------
    // What block did a player place and how many times?
    newTable = new SQLiteTable(PlayerStat.BLOCKS_PLACED.getTableName());
    id = new Column("id", true, SQLDataType.INT, true);
    newTable.addColumn(id);
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    Column typeID = new Column("typeid", false, SQLDataType.INT, true);
    Column dataValue = new Column("datavalue", false, SQLDataType.INT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT);
    newTable.addColumn(world);
    newTable.addColumn(typeID);
    newTable.addColumn(dataValue);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(typeID);
    newTable.addUniqueMatched(dataValue);
    newTable.addUniqueMatched(world);
    this.addTable(newTable);
    // ----------------------------------------------------------
    // What block did a player break and how many times?
    newTable = new SQLiteTable(PlayerStat.BLOCKS_BROKEN.getTableName());
    id = new Column("id", true, SQLDataType.INT, true);
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    typeID = new Column("typeid", false, SQLDataType.INT, true);
    dataValue = new Column("datavalue", false, SQLDataType.INT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT);
    newTable.addColumn(world);
    newTable.addColumn(typeID);
    newTable.addColumn(dataValue);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(typeID);
    newTable.addUniqueMatched(dataValue);
    newTable.addUniqueMatched(world);
    this.addTable(newTable);
    // ----------------------------------------------------------
    // What mobs did a player kill?
    newTable = new SQLiteTable(PlayerStat.KILLS_MOBS.getTableName());
    id = new Column("id", true, SQLDataType.INT, true);
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    typeID = new Column("mob", false, SQLDataType.TEXT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    Column weapon = new Column("weapon", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT);
    newTable.addColumn(world);
    newTable.addColumn(typeID);
    newTable.addColumn(weapon);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(typeID);
    newTable.addUniqueMatched(world);
    newTable.addUniqueMatched(weapon);
    this.addTable(newTable);
    // ----------------------------------------------------------
    // What players did a player kill?
    newTable = new SQLiteTable(PlayerStat.KILLS_PLAYERS.getTableName());
    id = new Column("id", true, SQLDataType.INT, true);
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    typeID = new Column("playerKilled", false, SQLDataType.TEXT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT);
    newTable.addColumn(world);
    newTable.addColumn(typeID);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(typeID);
    newTable.addUniqueMatched(world);
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How long did a player play (in minutes)?
    newTable = new SQLiteTable(PlayerStat.TIME_PLAYED.getTableName());
    id = new Column("id", true, SQLDataType.INT, true);
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT);
    newTable.addColumn(world);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(world);
    this.addTable(newTable);
    // ----------------------------------------------------------
    // What food did a player eat?
    newTable = new SQLiteTable(PlayerStat.FOOD_EATEN.getTableName());
    id = new Column("id", true, SQLDataType.INT, true);
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    typeID = new Column("foodEaten", false, SQLDataType.TEXT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT);
    newTable.addColumn(world);
    newTable.addColumn(typeID);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(typeID);
    newTable.addUniqueMatched(world);
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How much damage has a player taken?
    newTable = new SQLiteTable(PlayerStat.DAMAGE_TAKEN.getTableName());
    id = new Column("id", true, SQLDataType.INT, true);
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    typeID = new Column("cause", false, SQLDataType.TEXT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT);
    newTable.addColumn(world);
    newTable.addColumn(typeID);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(typeID);
    newTable.addUniqueMatched(world);
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How many sheep did a player shear?
    newTable = new SQLiteTable(PlayerStat.TIMES_SHORN.getTableName());
    id = new Column("id", true, SQLDataType.INT, true);
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT);
    newTable.addColumn(world);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(world);
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How far and in what way has a player travelled?
    newTable = new SQLiteTable(PlayerStat.DISTANCE_TRAVELLED.getTableName());
    id = new Column("id", true, SQLDataType.INT, true);
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    typeID = new Column("moveType", false, SQLDataType.TEXT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT);
    newTable.addColumn(world);
    newTable.addColumn(typeID);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(typeID);
    newTable.addUniqueMatched(world);
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How far and in what way has a player travelled?
    newTable = new SQLiteTable(PlayerStat.ITEMS_CRAFTED.getTableName());
    id = new Column("id", true, SQLDataType.INT, true);
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    typeID = new Column("item", false, SQLDataType.TEXT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT);
    newTable.addColumn(world);
    newTable.addColumn(typeID);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(typeID);
    newTable.addUniqueMatched(world);
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How much XP did a player gain?
    newTable = new SQLiteTable(PlayerStat.XP_GAINED.getTableName());
    id = new Column("id", true, SQLDataType.INT, true);
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT);
    newTable.addColumn(world);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(world);
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How many times did a player vote for this server?
    newTable = new SQLiteTable(PlayerStat.VOTES.getTableName());
    // UUID of the player
    newTable.addColumn("uuid", true, SQLDataType.TEXT);
    // How many times did the player vote.
    newTable.addColumn("value", false, SQLDataType.INT);
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How many arrows did a player shoot?
    newTable = new SQLiteTable(PlayerStat.ARROWS_SHOT.getTableName());
    id = new Column("id", true, SQLDataType.INT, true);
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    typeID = new Column("forceShot", false, SQLDataType.DOUBLE, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT, true);
    newTable.addColumn(world);
    newTable.addColumn(typeID);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(world);
    newTable.addUniqueMatched(typeID);
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How many times did a player enter a bed?
    newTable = new SQLiteTable(PlayerStat.ENTERED_BEDS.getTableName());
    id = new Column("id", true, SQLDataType.INT, true);
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT, true);
    newTable.addColumn(world);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(world);
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How many times did a player perform a command?
    newTable = new SQLiteTable(PlayerStat.COMMANDS_PERFORMED.getTableName());
    id = new Column("id", true, SQLDataType.INT, true);
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT, true);
    newTable.addColumn(world);
    newTable.addColumn("command", false, SQLDataType.TEXT, true);
    newTable.addColumn("arguments", false, SQLDataType.TEXT, true);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(world);
    newTable.addUniqueMatched("command");
    newTable.addUniqueMatched("arguments");
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How many times did a player get kicked?
    newTable = new SQLiteTable(PlayerStat.TIMES_KICKED.getTableName());
    id = new Column("id", true, SQLDataType.INT, true);
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT, true);
    newTable.addColumn(world);
    newTable.addColumn("reason", false, SQLDataType.TEXT, true);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(world);
    newTable.addUniqueMatched("reason");
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How many tools did a player break?
    newTable = new SQLiteTable(PlayerStat.TOOLS_BROKEN.getTableName());
    id = new Column("id", true, SQLDataType.INT, true);
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT, true);
    newTable.addColumn(world);
    newTable.addColumn("item", false, SQLDataType.TEXT, true);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(world);
    newTable.addUniqueMatched("item");
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How many eggs did a player throw?
    newTable = new SQLiteTable(PlayerStat.EGGS_THROWN.getTableName());
    id = new Column("id", true, SQLDataType.INT, true);
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT, true);
    newTable.addColumn(world);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(world);
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How many times did a player switch worlds?
    newTable = new SQLiteTable(PlayerStat.WORLDS_CHANGED.getTableName());
    id = new Column("id", true, SQLDataType.INT, true);
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT, true);
    newTable.addColumn(world);
    newTable.addColumn("destWorld", false, SQLDataType.TEXT, true);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(world);
    newTable.addUniqueMatched("destWorld");
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How many times did a player fill a bucket?
    newTable = new SQLiteTable(PlayerStat.BUCKETS_FILLED.getTableName());
    id = new Column("id", true, SQLDataType.INT, true);
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT, true);
    newTable.addColumn(world);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(world);
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How many times did a player fill a bucket?
    newTable = new SQLiteTable(PlayerStat.BUCKETS_EMPTIED.getTableName());
    id = new Column("id", true, SQLDataType.INT, true);
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT, true);
    newTable.addColumn(world);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(world);
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How many items did a player drop?
    newTable = new SQLiteTable(PlayerStat.ITEMS_DROPPED.getTableName());
    id = new Column("id", true, SQLDataType.INT, true);
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    typeID = new Column("item", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT, true);
    newTable.addColumn(world);
    newTable.addColumn(typeID);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(world);
    newTable.addUniqueMatched(typeID);
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How many items did a player pick up?
    newTable = new SQLiteTable(PlayerStat.ITEMS_PICKED_UP.getTableName());
    id = new Column("id", true, SQLDataType.INT, true);
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    typeID = new Column("item", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT, true);
    newTable.addColumn(world);
    newTable.addColumn(typeID);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(world);
    newTable.addUniqueMatched(typeID);
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How many times did a player teleport?
    newTable = new SQLiteTable(PlayerStat.TELEPORTS.getTableName());
    id = new Column("id", true, SQLDataType.INT, true);
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT, true);
    newTable.addColumn(world);
    newTable.addColumn("destWorld", false, SQLDataType.TEXT, true);
    newTable.addColumn("cause", false, SQLDataType.TEXT, true);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(world);
    newTable.addUniqueMatched("destWorld");
    newTable.addUniqueMatched("cause");
    this.addTable(newTable);
    // ----------------------------------------------------------
    // How many times did a player trade with villagers?
    newTable = new SQLiteTable(PlayerStat.VILLAGER_TRADES.getTableName());
    id = new Column("id", true, SQLDataType.INT, true);
    uuid = new Column("uuid", false, SQLDataType.TEXT, true);
    world = new Column("world", false, SQLDataType.TEXT, true);
    newTable.addColumn(id);
    // UUID of the player
    newTable.addColumn(uuid);
    newTable.addColumn("value", false, SQLDataType.INT, true);
    newTable.addColumn(world);
    newTable.addColumn("trade", false, SQLDataType.TEXT, true);
    newTable.addUniqueMatched(uuid);
    newTable.addUniqueMatched(world);
    newTable.addUniqueMatched("trade");
    this.addTable(newTable);
}

Example 3 with Column

use of me.staartvin.statz.database.datatype.Column in project Statz by Staartvin.

the class SQLiteConnector method createTablesStatement.

/**
 * This function creates multiple strings in 'SQL style' to create the
 * proper tables.
 * <br>
 * It looks at the tables that are loaded in memory and dynamically creates
 * proper SQL statements.
 *
 * @return SQL statements that will create the necessary tables when run.
 */
public List<String> createTablesStatement() {
    // Returns a list of statements that need to be run to create the tables.
    final List<String> statements = new ArrayList<String>();
    for (final Table table : this.getTables()) {
        StringBuilder statement = new StringBuilder("CREATE TABLE IF NOT EXISTS " + table.getTableName() + " (");
        // For each column in the table, add it to the table.
        for (final Column column : table.getColumns()) {
            if (column.getDataType().equals(SQLDataType.INT)) {
                statement.append("'" + column.getColumnName() + "' INTEGER");
            } else {
                statement.append("'" + column.getColumnName() + "' " + column.getDataType().toString());
            }
            if (column.isPrimaryKey()) {
                statement.append(" PRIMARY KEY");
            }
            if (column.isAutoIncrement()) {
                statement.append(" AUTOINCREMENT");
            }
            if (column.isNotNull()) {
                statement.append(" NOT NULL");
            }
            if (column.isUnique()) {
                statement.append(" UNIQUE");
            }
            statement.append(",");
        }
        if (!table.getUniqueMatched().isEmpty()) {
            statement.append("UNIQUE (");
            for (Column matched : table.getUniqueMatched()) {
                statement.append(matched.getColumnName() + ",");
            }
            // Remove last comma
            statement = new StringBuilder(statement.substring(0, statement.lastIndexOf(",")) + ")");
        } else {
            statement = new StringBuilder(statement.substring(0, statement.lastIndexOf(",")));
        }
        statement.append(");");
        statements.add(statement.toString());
        plugin.debugMessage(ChatColor.BLUE + "Loaded table '" + table.getTableName() + "'");
    }
    return statements;
}

Example 4 with Column

use of me.staartvin.statz.database.datatype.Column in project Statz by Staartvin.

the class MySQLConnector method createTablesStatement.

/**
 * This function creates multiple strings in 'SQL style' to create the
 * proper tables. <br>
 * It looks at the tables that are loaded in memory and dynamically creates
 * proper SQL statements.
 *
 * @return SQL statements that will create the necessary tables when run.
 */
public List<String> createTablesStatement() {
    // Returns a list of statements that need to be run to create the
    // tables.
    final List<String> statements = new ArrayList<String>();
    for (final Table table : this.getTables()) {
        StringBuilder statement = new StringBuilder("CREATE TABLE IF NOT EXISTS " + table.getTableName() + " (");
        // For each column in the table, add it to the table.
        for (final Column column : table.getColumns()) {
            if (column.getDataType().equals(SQLDataType.INT)) {
                statement.append("" + column.getColumnName() + " BIGINT");
            } else if (column.getDataType().equals(SQLDataType.TEXT)) {
                statement.append("" + column.getColumnName() + " VARCHAR(100)");
            } else if (column.getDataType().equals(SQLDataType.DOUBLE)) {
                statement.append("" + column.getColumnName() + " DECIMAL(20,10)");
            } else {
                statement.append("" + column.getColumnName() + " " + column.getDataType().toString());
            }
            if (column.isPrimaryKey()) {
                statement.append(" PRIMARY KEY");
            }
            if (column.isAutoIncrement()) {
                statement.append(" AUTO_INCREMENT");
            }
            if (column.isNotNull()) {
                statement.append(" NOT NULL");
            }
            if (column.isUnique()) {
                statement.append(" UNIQUE");
            }
            statement.append(",");
        }
        if (!table.getUniqueMatched().isEmpty()) {
            statement.append("UNIQUE (");
            for (Column matched : table.getUniqueMatched()) {
                statement.append(matched.getColumnName() + ",");
            }
            // Remove last comma
            statement = new StringBuilder(statement.substring(0, statement.lastIndexOf(",")) + ")");
        } else {
            statement = new StringBuilder(statement.substring(0, statement.lastIndexOf(",")));
        }
        statement.append(");");
        statements.add(statement.toString());
        plugin.debugMessage(ChatColor.BLUE + "Loaded table '" + table.getTableName() + "'");
    }
    return statements;
}