public void executionText() { CSQLiteConnection connection = new CSQLiteConnection(); string sqlCommand = "DROP TABLE IF EXISTS " + TABLE_TEST; Assert.IsTrue(connection.sqlExecuteStatement(sqlCommand)); sqlCommand = "CREATE TABLE " + TABLE_TEST + " (id INTEGER PRIMARY KEY, testAttr TEXT)"; Assert.IsTrue(connection.sqlExecuteStatement(sqlCommand)); sqlCommand = "INSERT INTO " + TABLE_TEST + " (id, testAttr) VALUES (1, 'asd'), (2, 'qwe'), (3, 'yxc')"; Assert.IsTrue(connection.sqlExecuteStatement(sqlCommand)); SQLiteDataReader reader; sqlCommand = "SELECT * FROM " + TABLE_TEST; Assert.IsTrue(connection.sqlRequestStatement(sqlCommand, out reader)); int count = 0; while (reader.Read() == true) { count++; } }
public void construktorTest() { CSQLiteConnection connection = new CSQLiteConnection(); }