public void TestSelectCellCanReturnLongDataType() { var xQuery = new XQuerySqlite(SetUp.SqliteConnectionString); var result = xQuery.SelectCellAs <long>("select 100;"); Assert.AreEqual(100L, result); }
public void TestSelectCellCanReturnDoubleDataType() { var xQuery = new XQuerySqlite(SetUp.SqliteConnectionString); var result = xQuery.SelectCellAs <double>("select 1.1;"); Assert.AreEqual(1.1d, result); }
public void TestSelectCellCanReturnStringDataType() { var xQuery = new XQuerySqlite(SetUp.SqliteConnectionString); var result = xQuery.SelectCellAs <string>("select 'asd';"); Assert.AreEqual("asd", result); }
public void TestSelectCellReturnsDefaultValueOnError() { const string defValue = "default"; var xQuery = new XQuerySqlite(SetUp.SqliteConnectionString); var result = xQuery.SelectCellAs("select 1.1;", defValue); Assert.AreEqual(defValue, result); }
public void TestSelectCellReturnsValueIfNoErrors() { const string defValue = "default"; const string nonDefValue = "non default"; var xQuery = new XQuerySqlite(SetUp.SqliteConnectionString); var result = xQuery.SelectCellAs($"select '{nonDefValue}';", defValue); Assert.AreEqual(nonDefValue, result); }
public void TestSelectCellThrowsDataExceptionOnEmptyResult() { const string sqlSelect = "select;"; var xQuery = new XQuerySqlite(SetUp.SqliteConnectionString); Assert.Throws(Is.TypeOf <DataException>(), delegate { xQuery.SelectCellAs <long>(sqlSelect); }); }
public void TestSelectCellThrowsFormatException() { const string sqlSelect = "select 1;"; var xQuery = new XQuerySqlite(SetUp.SqliteConnectionString); Assert.Throws(Is.TypeOf <FormatException>(), delegate { xQuery.SelectCellAs <string>(sqlSelect); }); }
public void TestConnectionIsOpenAfterSelect() { const string sqlSelect = "select 123;"; var xQuery = new XQuerySqlite() { ConnectionString = SetUp.SqliteConnectionString, KeepConnectionOpen = true }; xQuery.SelectCellAs <long>(sqlSelect); Assert.IsTrue(xQuery.IsConnectionActive); }
public void TestConnectionIsBeingClosedByChangingKeepConnectionOpen() { const string select = "select 123;"; var xQuery = new XQuerySqlite() { ConnectionString = SetUp.SqliteConnectionString, KeepConnectionOpen = true }; xQuery.SelectCellAs <long>(select); xQuery.KeepConnectionOpen = false; Assert.IsFalse(xQuery.IsConnectionActive); }
public void TestSelectBinaryDataFromCell() { const string sqlCreateTable = "create table test (bin blob);"; const string sqlInsertBin = "insert into test (bin) values (@bin);"; var binData = new byte[] { 1, 0, 1, 1, 0, 1, 1, 0 }; var xQuery = new XQuerySqlite(SetUp.SqliteConnectionString); xQuery.BeginTransaction(); xQuery.Create(sqlCreateTable); xQuery.InsertBinaryIntoCell(binData, sqlInsertBin, "@bin"); var result = xQuery.SelectCellAs <byte[]>("select bin from test"); Assert.AreEqual(binData, result); }
public void TestErrorIsLogged() { const string sqlSelect = "select 1, 2, 3;"; var xQuery = new XQuerySqlite(SetUp.SqliteConnectionString); xQuery.OnError += XQuery_OnError; try { xQuery.SelectCellAs <long>(sqlSelect); } catch (Exception) { // ignored } Assert.IsNotEmpty(xQuery.LastErrorMessage); }
public void TestArithmeticOperationWithSelectCell() { var xQuery = new XQuerySqlite(SetUp.SqliteConnectionString); Assert.AreEqual(30, xQuery.SelectCellAs <long>("select 10+20;")); }