private boolean setupSQL() {
    if (config.getSQLValue().equalsIgnoreCase("MySQL")) {
      dataop =
          new MySQLOptions(
              config.getHostname(),
              config.getPort(),
              config.getDatabase(),
              config.getUsername(),
              config.getPassword());
    } else if (config.getSQLValue().equalsIgnoreCase("SQLite")) {
      dataop = new SQLiteOptions(new File(getDataFolder() + "/coupon_data.db"));
    } else if (!config.getSQLValue().equalsIgnoreCase("MySQL")
        && !config.getSQLValue().equalsIgnoreCase("SQLite")) {
      sendErr("The SQLType has the unknown value of: " + config.getSQLValue());
      return false;
    }

    sql = new SQL(this, dataop);

    try {
      sql.open();
      sql.createTable(
          "CREATE TABLE IF NOT EXISTS couponcodes (name VARCHAR(24), ctype VARCHAR(10), usetimes INT(10), usedplayers TEXT(1024), ids VARCHAR(255), money INT(10), groupname VARCHAR(20), timeuse INT(100), xp INT(10))");
      cm = new CouponManager(this, sql);
    } catch (SQLException e) {
      e.printStackTrace();
      return false;
    }
    return true;
  }
예제 #2
0
 @Test
 public void shouldReturnACustomConfigInstanceIfAlreadyExists() {
   Application app = new Application(database);
   Config result = app.getConfig();
   result.setHostname("custom");
   result.setPort(2030);
   result.setCheckInterval(30);
   app.update(result);
   database.getSession().flush();
   database.getSession().clear();
   result = app.getConfig();
   assertThat(result.getHostname(), is(equalTo("custom")));
   assertThat(result.getPort(), is(equalTo(2030)));
   assertThat(result.getCheckInterval(), is(equalTo(30)));
 }
예제 #3
0
 @Test
 public void shouldReturnTheBasicConfigInstanceIfNoneFound() {
   Config result = new Application(database).getConfig();
   assertThat(result.getHostname(), is(equalTo("localhost")));
   assertThat(result.getPort(), is(equalTo(9091)));
 }