C# (CSharp) SqlTable.AddRowItem示例

示例#1

        public void ScriptConfigGeneratorService_Generate_from_config()
        {
            var sqlTable = new SqlTable("Table1");

            sqlTable.AddField("ID", SqlField.SqlFieldType.tnumber);
            sqlTable.AddField("Name", SqlField.SqlFieldType.tstring);

            sqlTable.AddRowItem(0, "ID", 1);
            sqlTable.AddRowItem(0, "Name", "Item1");

            sqlTable.AddRowItem(1, "ID", 2);
            sqlTable.AddRowItem(1, "Name", "Item2");

            sqlTable.AddRowItem(2, "ID", 3);
            sqlTable.AddRowItem(2, "Name", "Item3");

            var sqlHelperMoq = new Mock <ISqlHelper>();

            sqlHelperMoq.Setup(r => r.GetTable(sqlTable.Name)).Returns(sqlTable);

            var listConfigTable = new List <LMDataBaseInitialConfig.ConsoleApp.Config.ConfigTable>()
            {
                new LMDataBaseInitialConfig.ConsoleApp.Config.ConfigTable("Table1", 1, true, true, true, string.Empty)
            };

            var configHelpter = new Mock <IConfigHelpter>();

            configHelpter.Setup(r => r.GetTables()).Returns(listConfigTable);


            var fileHelper = new Mock <IFileHelper>();

            var Generator = new LMDataBaseInitialConfig.ConsoleApp.Service.ScriptConfigGeneratorService(sqlHelperMoq.Object, configHelpter.Object, fileHelper.Object);

            const string tableScriptReturn = @"INSERT INTO Table1 (ID, Name) VALUES (1, 'Item1')
INSERT INTO Table1 (ID, Name) VALUES (2, 'Item2')
INSERT INTO Table1 (ID, Name) VALUES (3, 'Item3')";



            var dic = Generator.Generate();

            Assert.True(dic.ContainsKey("Table1"), "Did Not return mock table in ConfigHelper");
            Assert.Equal(dic["Table1"], tableScriptReturn);
        }

示例#2

        public void ScriptConfigGeneratorService_Generate()
        {
            var sqlTable = new SqlTable("Table1");

            sqlTable.AddField("ID", SqlField.SqlFieldType.tnumber);
            sqlTable.AddField("Name", SqlField.SqlFieldType.tstring);

            sqlTable.AddRowItem(0, "ID", 1);
            sqlTable.AddRowItem(0, "Name", "Item1");

            sqlTable.AddRowItem(1, "ID", 2);
            sqlTable.AddRowItem(1, "Name", "Item2");

            sqlTable.AddRowItem(2, "ID", 3);
            sqlTable.AddRowItem(2, "Name", "Item3");

            var sqlHelperMoq = new Mock <ISqlHelper>();

            sqlHelperMoq.Setup(r => r.GetTable(sqlTable.Name)).Returns(sqlTable);


            var configHelpter = new Mock <IConfigHelpter>();
            var fileHelper    = new Mock <IFileHelper>();

            var Generator = new LMDataBaseInitialConfig.ConsoleApp.Service.ScriptConfigGeneratorService(sqlHelperMoq.Object, configHelpter.Object, fileHelper.Object);



            const string tableScriptReturn = @"INSERT INTO Table1 (ID, Name) VALUES (1, 'Item1')
INSERT INTO Table1 (ID, Name) VALUES (2, 'Item2')
INSERT INTO Table1 (ID, Name) VALUES (3, 'Item3')";



            var tableScript = Generator.Generate(sqlTable.Name);

            Assert.Equal(tableScript, tableScriptReturn);
        }