/** Test of openDb method, of class Database. */
@Test
public void test1OpenDb() {
System.out.println("openDb");
Database instance = new Database();
instance.setDbName(databaseFilePath);
Connection result = instance.openDb();
assertNotNull(result);
}
/** Test of sqlStatementConstructor method, of class Database. */
@Test
public void testSqlStatementConstructor() {
System.out.println("sqlStatementConstructor");
String expResult = "SELECT date,time FROM sysstats";
Database.setSqlStatementOperation("SELECT");
Database.setSqlStatementTable(tableName);
List columns = new ArrayList<>();
columns.add("date");
columns.add("time");
Database.setSqlStatementColumns(columns);
String result = Database.sqlStatementConstructor();
assertEquals(expResult, result);
}
/**
* Test of insertStat method, of class Database.
*
* @throws java.sql.SQLException
*/
@Test
public void test3InsertStat() throws SQLException {
System.out.println("insertStat");
List<String> message = new ArrayList<>(Arrays.asList("12345", "6789.123"));
Database instance = new Database();
instance.setDbName(databaseFilePath);
Connection conn = instance.openDb();
instance.setTableName(tableName);
instance.setDbConnection(conn);
instance.setStatMessage(message);
Boolean result = instance.insertStat();
assertTrue(result);
// Test reinsertion of duplicates
result = instance.insertStat();
assertFalse(result);
}
/** Test of crateTable method, of class Database. */
@Test
public void test2CrateTable() {
System.out.println("crateTable");
Database instance = new Database();
instance.setDbName(databaseFilePath);
Connection conn = instance.openDb();
instance.setTableName(tableName);
instance.setTableColumns(tableColumns);
instance.setDbConnection(conn);
Boolean result = instance.crateTable();
assertTrue(result);
}
/**
* Test of selectStat method, of class Database.
*
* @throws java.lang.Exception
*/
@Test
public void test4SelectStat() throws Exception {
System.out.println("selectStat");
List<String> stats = new ArrayList<>(Arrays.asList("12345", "6789.123"));
List<String> columns = new ArrayList<>(Arrays.asList("date", "time"));
List<List<String>> expResult = new ArrayList<>();
expResult.add(stats);
Database instance = new Database();
instance.setDbName(databaseFilePath);
Connection conn = instance.openDb();
instance.setDbConnection(conn);
instance.setTableName(tableName);
instance.setColumnNames(columns);
List<List<String>> result = instance.selectStats();
assertEquals(expResult, result);
}
