public void TestInsertWithoutFieldsOrValues() { DataBase.dataBaseConnect(); DataBase.FieldAndValue field = new DataBase.FieldAndValue(); List <DataBase.FieldAndValue> fields = new List <DataBase.FieldAndValue>(); DataBase.DataToQueryInsert data = new DataBase.DataToQueryInsert(); field.filedName = null; field.value = null; fields.Add(field); data.tableName = "roulettes"; data.fields = fields; var insertResult = DataBase.dataBaseInsert(data); DataBase.dataBaseDesconnect(); Assert.IsFalse(insertResult); }
public void TestInsert_Ok() { DataBase.dataBaseConnect(); DataBase.FieldAndValue field = new DataBase.FieldAndValue(); List <DataBase.FieldAndValue> fields = new List <DataBase.FieldAndValue>(); DataBase.DataToQueryInsert data = new DataBase.DataToQueryInsert(); field.filedName = "last_number"; field.value = "35"; fields.Add(field); field.filedName = "state_id"; field.value = "2"; fields.Add(field); data.tableName = "roulettes"; data.fields = fields; var insertResult = DataBase.dataBaseInsert(data); DataBase.dataBaseDesconnect(); Assert.IsTrue(insertResult); }
public void TestUpdateWithoutTable() { DataBase.dataBaseConnect(); DataBase.FieldAndValue field = new DataBase.FieldAndValue(); List <DataBase.FieldAndValue> fields = new List <DataBase.FieldAndValue>(); DataBase.DataToQueryUpdate data = new DataBase.DataToQueryUpdate(); field.filedName = "last_number"; field.value = "36"; fields.Add(field); field.filedName = "state_id"; field.value = "2"; fields.Add(field); data.tableName = ""; data.id = 1; data.fields = fields; var updateResult = DataBase.dataBaseUpdate(data); DataBase.dataBaseDesconnect(); Assert.IsFalse(updateResult); }