예제 #1
0
        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);
        }
예제 #2
0
        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);
        }