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