public void CreateQuery_GetTableExist_Test() { // arrange var component = new DatabaseQueryCreator(); // act var query = component.GetTableExist <MyTestData>(); // assert Assert.AreEqual("SELECT * FROM sqlite_master WHERE type='table' AND name='MyTestData'", query); }
public void CreateQuery_GetDataSelectById_Test() { // arrange var component = new DatabaseQueryCreator(); // act var query = component.GetDataSelectById <MyTestData>(123); // assert Assert.AreEqual("SELECT Id,MyText FROM MyTestData WHERE Id='123'", query); }
public void CreateQuery_GetDataDelete_Test() { // arrange var component = new DatabaseQueryCreator(); // act var query = component.GetDataDelete <MyTestData>(123L); // assert Assert.AreEqual("DELETE FROM MyTestData WHERE Id='123'", query); }
public void CreateQuery_CreateTable_Test() { // arrange var component = new DatabaseQueryCreator(); // act var query = component.GetCreateTableByDataObjectString <MyTestData>(out string[] extendArrayDataToTableQueries); // assert Assert.AreEqual("CREATE TABLE MyTestData(Id INTEGER PRIMARY KEY AUTOINCREMENT,MyText NVARCHAR NOT NULL)", query); }
public void CreateQuery_CreateTable_SubTable_Test() { // arrange var component = new DatabaseQueryCreator(); // act var mainQuery = component.GetCreateTableByDataObjectString <MyTestDataSubData>(out string[] query); // assert Assert.AreEqual("CREATE TABLE MyTestDataSubData(Id INTEGER PRIMARY KEY AUTOINCREMENT,CollectionOfIntegerId INTEGER NOT NULL)", mainQuery); Assert.AreEqual("CREATE TABLE MyTestDataSubData_CollectionOfInteger(MyTestDataSubData_id, CollectionOfInteger_item INTEGER NOT NULL)", query.First()); }
public void CreateQuery_GetDataInsert_Test() { // arrange var component = new DatabaseQueryCreator(); var testData = new MyTestData { MyText = "Hello" }; // act var query = component.GetDataInsert(testData, out _); // assert Assert.AreEqual("INSERT INTO MyTestData (MyText) VALUES ('Hello')", query); }
public void CreateQuery_GetDataDelete_ByData_Test() { // arrange var component = new DatabaseQueryCreator(); var data = new MyTestData { Id = 123L, MyText = "For delete" }; // act var query = component.GetDataDelete(data); // assert Assert.AreEqual("DELETE FROM MyTestData WHERE Id='123'", query); }
public void CreateQuery_GetDataUpdate_Test() { // arrange var component = new DatabaseQueryCreator(); var data = new MyTestData { Id = 123, MyText = "Change text" }; // act var query = component.CreateQueryUpdateData(data); // assert Assert.AreEqual("UPDATE MyTestData SET Id='123',MyText='Change text' WHERE Id='123';", query); }
public void CreateQuery_GetDataInsert_SubTable_Test() { // arrange var component = new DatabaseQueryCreator(); var testData = new MyTestDataSubData() { CollectionOfInteger = new [] { 12 } }; // act var query = component.GetDataInsert(testData, out var subTableInserts); // assert // TODO: eigentlich muss da kein Wert gesetzt werden. Assert.AreEqual("INSERT INTO MyTestDataSubData () VALUES ()", query); Assert.AreEqual("INSERT INTO MyTestDataSubData_CollectionOfInteger(MyTestDataSubData_id) VALUES (@MyTestDataSubData_id@, 12)", subTableInserts.First()); }