Esempio n. 1
0
        //-------------------------------------------------------------------------------------------
        /// <summary>
        /// TestDBI_T_mapping_Write_to_DB -- write itemlist to DB
        /// </summary>
        static void TestDBI_T_mapping_Write_to_DB()
        {
            Console.WriteLine("  --START: TestDBI_T_mapping_Write_to_DB");

            mapping_Table myTable = new mapping_Table();

            myTable.itemList = make_mapping_list_1();
            int iRowsStart = myTable.itemList.Count;

            myTable.Show();
            Util.pause();

            Console.WriteLine("  --before clear SQLServer database table");
            Util.pause();
            myTable.Clear_Database_Table();
            int iRows2 = myTable.CountRows();

            if (iRows2 != 0)
            {
                Util.pause("Error.  iRows=" + iRows2 + " should be zero after Clear_Database_Table()");
            }
            else
            {
                Util.pause("OK.  After Clear_Database_Table()");
            }


            Console.WriteLine("Write the table from RAM the SQLServer  Database table");
            myTable.WriteItemListToDatabase();
            int iRows3 = myTable.CountRows();

            if (iRows3 != iRowsStart)
            {
                Util.pause("Error.  iRows3=" + iRows3 + " should be " + iRowsStart + " after WriteItemListToDatabase");
            }
            else
            {
                Util.pause("OK.  After WriteItemListToDatabase()");
            }

            Console.WriteLine("  --after writing to the SQLServer database table.  examine the table using SSMS");
            Util.pause("visually inspect via SSMS?");

            Console.WriteLine("  --DONE: TestDBI_T_mapping_Write_to_DB");
        }//TestDBI_T_mapping_Write_to_DB
Esempio n. 2
0
        /// <summary>
        /// TestDBI_T_mapping_AutoCheck_Update - Update Item List;
        /// 1.1) Create test data: myTable1;
        /// 1.2) Clear DBTable;
        /// 1.3) Write myTable1 to DBTable;
        /// 1.4) Get DBTable.CountRows, compare (myTable1.itemList.Count == DBTable.CountRows)
        /// 1.5) Read myTable2 from DBTable
        /// 1.6) Compare tables (myTable1 == myTable2)
        /// 1.7) Create the update table (myTableUpdate)
        /// 1.8) Update TableDB
        /// 1.9) Read myTable3
        /// 1.10) Compare tables.itemLists(myTableUpdate == myTable3)
        /// </summary>
        /// <returns></returns>
        static int TestDBI_T_mapping_AutoCheck_Update()
        {
            const int OK      = 0;
            int       iResult = OK;

            Console.WriteLine("START: TestDBI_T_mapping_AutoCheck_Update()");

            // 1.1) CreateTestData1: myTable1
            mapping_Table myTable1 = new mapping_Table();

            myTable1.itemList = new List <mapping>()
            {
                //mapping(int val_mappingId, String val_mappingName, String val_mappingPath,
                //             String val_specificGoal, String val_specificPractice, String val_genericGoal, String val_genericPractice, string val_processArea, int val_projectId)
                new  mapping(1, "name_1", "path_1", "sg_1", "sp_1", "gg_1", "gp_1", "pa_1", 1),
                new  mapping(2, "name_1", "path_1", "sg_1", "sp_1", "gg_1", "gp_1", "pa_2", 2),
                new  mapping(3, "name_1", "path_1", "sg_1", "sp_1", "gg_1", "gp_1", "pa_3", 3),
                new  mapping(4, "name_1", "path_1", "sg_1", "sp_1", "gg_1", "gp_1", "pa_4", 4),
                new  mapping(5, "name_1", "path_1", "sg_1", "sp_1", "gg_1", "gp_1", "pa_5", 5)
            };
            int iRowsAtStart = myTable1.itemList.Count;

            // 1.2) ClearDBTable
            myTable1.Clear_Database_Table();
            int iRowsAfterClear = myTable1.CountRows();

            if (iRowsAfterClear != 0)
            {
                iResult = -1;
                Console.WriteLine("Error: DBTable should be empty after Clear_Database_Table.  iRowsAfterClear=" + iRowsAfterClear);
                return(iResult);
            }

            // 1.3) Write myTable1 to DBTable
            myTable1.WriteItemListToDatabase();


            // 1.4) Get DBTable.CountRows, compare (myTable1.itemList.Count == DBTable.CountRows)
            int iRowsAfterWriteItemListr = myTable1.CountRows();

            if (iRowsAfterWriteItemListr != iRowsAtStart)
            {
                iResult = -1;
                Console.WriteLine("Error: DBTable should be same as iRowsAtStart after WriteItemListToDatabase.  iRowsAfterWriteItemListr=" + iRowsAfterWriteItemListr);
                return(iResult);
            }

            /// 1.5) Read myTable2 from DBTable
            mapping_Table myTable2 = new mapping_Table();

            myTable2.ReadItemListFromDatabase();

            /// 1.6) Compare tables (myTable1 == myTable2)
            if (!TestDBI_T_mapping_CompareLists(myTable1.itemList, myTable2.itemList))
            {
                iResult = -1;
                Console.WriteLine("Error: DBTable should be same as test data");
                return(iResult);
            }

            /// 1.7) Create the update table (myTableUpdate)
            mapping_Table myTableUpdate = new mapping_Table();

            myTableUpdate.itemList = new List <mapping>()
            {
                //mapping(int val_mappingId, String val_mappingName, String val_mappingPath,
                //             String val_specificGoal, String val_specificPractice, String val_genericGoal, String val_genericPractice, string val_processArea, int val_projectId)
                new  mapping(1, "name_1", "path_1", "sg_1", "sp_1", "gg_1", "gp_1", "pa_1", 1),
                new  mapping(2, "name_1", "path_1", "sg_1", "sp_1", "gg_1", "gp_1", "pa_2-update", 2),
                new  mapping(3, "name_1", "path_1", "sg_1", "sp_1", "gg_1", "gp_1", "pa_3", 3),
                new  mapping(4, "name_1", "path_1", "sg_1", "sp_1", "gg_1", "gp_1", "pa_4-update", 4),
                new  mapping(5, "name_1", "path_1", "sg_1", "sp_1", "gg_1", "gp_1", "pa_5", 5)
            };

            //1.8) Update TableDB
            myTableUpdate.UpdateItemListToDatabase();

            //1.9) Read myTable3
            mapping_Table myTable3 = new mapping_Table();

            myTable3.ReadItemListFromDatabase();

            //1.10) Compare tables.itemLists (myTableUpdate == myTable3)
            if (!TestDBI_T_mapping_CompareLists(myTableUpdate.itemList, myTable3.itemList))
            {
                iResult = -1;
                Console.WriteLine("Error: DBTable should be same as the update table");
                return(iResult);
            }


            Console.WriteLine("DONE: TestDBI_T_mapping_AutoCheck_Update()");
            return(iResult);
        }