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());
}
