コード例 #1
0
  @Test
  public void QueryTableHasCorrectColumns() throws IOException {
    try {
      DataSource queryDataSource = Config.userDatabaseDataSource();

      String getColumns = "DESCRIBE " + QueryDaoImpl.QUERY_TABLE;

      JdbcTemplate queryDatabase = new JdbcTemplate(queryDataSource);
      List<MySQLColumn> columns = queryDatabase.query(getColumns, new ParseMySQLColumns());

      ListAssert.assertContains(
          columns,
          new MySQLColumn(
              QueryDaoImpl.QUERY_ID,
              MySQLColumn.INT_UNSIGNED(10),
              MySQLColumn.NEVER_NULL,
              MySQLColumn.PRIMARY_KEY));
      ListAssert.assertContains(
          columns,
          new MySQLColumn(
              QueryDaoImpl.METADATA_ID,
              MySQLColumn.INT_UNSIGNED(10),
              MySQLColumn.CAN_NULL,
              MySQLColumn.NOT_KEY));
      ListAssert.assertContains(
          columns,
          new MySQLColumn(
              QueryDaoImpl.EXPERIMENT,
              MySQLColumn.VARCHAR(255),
              MySQLColumn.CAN_NULL,
              MySQLColumn.NOT_KEY));
      ListAssert.assertContains(
          columns,
          new MySQLColumn(
              QueryDaoImpl.BARCODE,
              MySQLColumn.VARCHAR(255),
              MySQLColumn.CAN_NULL,
              MySQLColumn.NOT_KEY));
      ListAssert.assertContains(
          columns,
          new MySQLColumn(
              QueryDaoImpl.MEASUREMENT,
              MySQLColumn.VARCHAR(255),
              MySQLColumn.CAN_NULL,
              MySQLColumn.NOT_KEY));
      ListAssert.assertContains(
          columns,
          new MySQLColumn(
              QueryDaoImpl.START_TIME,
              MySQLColumn.DATETIME,
              MySQLColumn.CAN_NULL,
              MySQLColumn.NOT_KEY));
      ListAssert.assertContains(
          columns,
          new MySQLColumn(
              QueryDaoImpl.END_TIME,
              MySQLColumn.DATETIME,
              MySQLColumn.CAN_NULL,
              MySQLColumn.NOT_KEY));
      ListAssert.assertContains(
          columns,
          new MySQLColumn(
              QueryDaoImpl.WATERING,
              MySQLColumn.TINYINT(1),
              MySQLColumn.NEVER_NULL,
              MySQLColumn.NOT_KEY));
      ListAssert.assertContains(
          columns,
          new MySQLColumn(
              QueryDaoImpl.VISIBLE,
              MySQLColumn.TINYINT(1),
              MySQLColumn.NEVER_NULL,
              MySQLColumn.NOT_KEY));
      ListAssert.assertContains(
          columns,
          new MySQLColumn(
              QueryDaoImpl.FLUORESCENT,
              MySQLColumn.TINYINT(1),
              MySQLColumn.NEVER_NULL,
              MySQLColumn.NOT_KEY));
      ListAssert.assertContains(
          columns,
          new MySQLColumn(
              QueryDaoImpl.INFRARED,
              MySQLColumn.TINYINT(1),
              MySQLColumn.NEVER_NULL,
              MySQLColumn.NOT_KEY));
    } catch (MalformedConfigException e) {
      fail("Configuration file missing fields.");
    }
  }
コード例 #2
0
  @Test
  public void QueryMetadataTableHasCorrectColumns() throws IOException {
    try {
      DataSource queryDataSource = Config.userDatabaseDataSource();

      String getColumns = "DESCRIBE " + QueryDaoImpl.METADATA_TABLE;

      JdbcTemplate queryDatabase = new JdbcTemplate(queryDataSource);
      List<MySQLColumn> columns = queryDatabase.query(getColumns, new ParseMySQLColumns());

      ListAssert.assertContains(
          columns,
          new MySQLColumn(
              QueryDaoImpl.METADATA_ID,
              MySQLColumn.INT_UNSIGNED(10),
              MySQLColumn.NEVER_NULL,
              MySQLColumn.PRIMARY_KEY));
      ListAssert.assertContains(
          columns,
          new MySQLColumn(
              QueryDaoImpl.QUERY_ID,
              MySQLColumn.INT_UNSIGNED(10),
              MySQLColumn.NEVER_NULL,
              MySQLColumn.MULTIPLE_KEY));
      ListAssert.assertContains(
          columns,
          new MySQLColumn(
              QueryDaoImpl.USER_ID,
              MySQLColumn.INT_UNSIGNED(10),
              MySQLColumn.CAN_NULL,
              MySQLColumn.MULTIPLE_KEY));
      ListAssert.assertContains(
          columns,
          new MySQLColumn(
              QueryDaoImpl.COMMENT,
              MySQLColumn.TEXT,
              MySQLColumn.CAN_NULL,
              MySQLColumn.MULTIPLE_KEY));
      ListAssert.assertContains(
          columns,
          new MySQLColumn(
              QueryDaoImpl.DATE_MADE,
              MySQLColumn.DATETIME,
              MySQLColumn.CAN_NULL,
              MySQLColumn.NOT_KEY));
      ListAssert.assertContains(
          columns,
          new MySQLColumn(
              QueryDaoImpl.DOWNLOAD_BEGIN,
              MySQLColumn.DATETIME,
              MySQLColumn.CAN_NULL,
              MySQLColumn.NOT_KEY));
      ListAssert.assertContains(
          columns,
          new MySQLColumn(
              QueryDaoImpl.DOWNLOAD_END,
              MySQLColumn.DATETIME,
              MySQLColumn.CAN_NULL,
              MySQLColumn.NOT_KEY));
      ListAssert.assertContains(
          columns,
          new MySQLColumn(
              QueryDaoImpl.INTERRUPTED,
              MySQLColumn.TINYINT(1),
              MySQLColumn.CAN_NULL,
              MySQLColumn.NOT_KEY));
      ListAssert.assertContains(
          columns,
          new MySQLColumn(
              QueryDaoImpl.MISSED_SNAPSHOTS,
              MySQLColumn.TEXT,
              MySQLColumn.CAN_NULL,
              MySQLColumn.NOT_KEY));
      ListAssert.assertContains(
          columns,
          new MySQLColumn(
              QueryDaoImpl.SIZE,
              MySQLColumn.BIGINT(20),
              MySQLColumn.CAN_NULL,
              MySQLColumn.NOT_KEY));
      ListAssert.assertContains(
          columns,
          new MySQLColumn(
              QueryDaoImpl.NUM_SNAPSHOTS,
              MySQLColumn.INT(11),
              MySQLColumn.CAN_NULL,
              MySQLColumn.NOT_KEY));
      ListAssert.assertContains(
          columns,
          new MySQLColumn(
              QueryDaoImpl.NUM_TILES,
              MySQLColumn.INT(11),
              MySQLColumn.CAN_NULL,
              MySQLColumn.NOT_KEY));
    } catch (MalformedConfigException e) {
      fail("Configuration file missing fields.");
    }
  }