public void MoveToNextRow() { using (var cursor = DatabaseWrapper.ExecuteSingleResultQuery($"SELECT boolNullable FROM {TableName} WHERE boolNullable IS NOT NULL;")) { Assert.IsFalse(cursor.IsEmpty); Assert.IsTrue(cursor.IsFirstRow()); Assert.IsFalse(cursor.MoveToNextRow()); } using (var cursor = DatabaseWrapper.ExecuteQuery($"SELECT boolNullable FROM {TableName} WHERE boolNullable IS NOT NULL;")) { Assert.IsFalse(cursor.IsEmpty); Assert.IsTrue(cursor.IsFirstRow()); var lastRowPosition = cursor.GetRowPosition(); while (cursor.MoveToNextRow()) { var currentRowPosition = cursor.GetRowPosition(); Assert.AreEqual(lastRowPosition + 1, currentRowPosition); lastRowPosition = currentRowPosition; } cursor.MoveToNextRow(); Assert.AreEqual(lastRowPosition, cursor.GetRowPosition()); } }
public void GetByteBufferLengthTest() { using (var cursor = DatabaseWrapper.ExecuteQuery($"SELECT boolTrue FROM {TableName};")) { Assert.IsTrue(cursor.GetByteBufferLength() == 1024); } }
public void GetColumnNameTest() { using (var cursor = DatabaseWrapper.ExecuteQuery($"SELECT boolFalse FROM {TableName};")) { Assert.IsTrue(cursor.GetColumnName(0) == "boolFalse"); } }
public void GetBooleanTrueTest() { using (var cursor = DatabaseWrapper.ExecuteQuery($"SELECT boolTrue FROM {TableName};")) { Assert.IsFalse(cursor.IsEmpty); Assert.IsTrue(cursor.GetBoolean(cursor.GetFirstFieldIndex())); Assert.IsTrue(cursor.MoveToNextRow()); Assert.IsTrue(cursor.GetBoolean(cursor.GetFirstFieldIndex())); } }
public void ExecuteQueryTest() { var tableName = "testingTable" + HelperObjectFactory.GetRandomInt(0); DatabaseWrapper.ExecuteSql($"CREATE TABLE {tableName}(a,b);"); DatabaseWrapper.ExecuteSql($"INSERT INTO {tableName}(a,b) VALUES ('test0', 'test1');"); using (var cursor = DatabaseWrapper.ExecuteQuery($"SELECT * FROM {tableName};")) { Assert.IsNotNull(cursor); Assert.IsNotNull(cursor.GetString(cursor.GetColumnIndex("a"))); Assert.IsNotNull(cursor.GetString(cursor.GetColumnIndex("b"))); } DatabaseWrapper.ExecuteSql($"DROP TABLE {tableName};"); }