Exemple #1
0
        public static void SetMasterScriptWriteStatus(string testSuiteId)
        {
            string userName  = WinComponent.loginUser;
            string buildDate = GlobalFunction.ExecutionTime();

            MySQLConnector.RunQuery("UPDATE testsuites SET WRITE_STATUS=1, BUILD_DATE='" + buildDate + "', BUILDER='" + userName + "' WHERE TS_ID=" + testSuiteId);
        }
Exemple #2
0
        public static void SetScriptCommit(string testSuiteId, string testCaseId, string commitMessage)
        {
            string commitDate = GlobalFunction.ExecutionTime();

            MySQLConnector.RunQuery("UPDATE testsuites SET LAST_COMMIT_DATE='" + commitDate + "', LAST_COMMIT_MESSAGE='" + commitMessage + "' WHERE ts_id=" + testSuiteId);
            if (testCaseId != "XXX")
            {
                MySQLConnector.RunQuery("UPDATE testcases SET LAST_COMMIT_DATE='" + commitDate + "', LAST_COMMIT_MESSAGE='" + commitMessage + "' WHERE ts_id=" + testSuiteId + " AND tc_id=" + testCaseId);
            }
        }
Exemple #3
0
        public static void SetScriptWriteStatus(string testSuiteId, string testCaseId)
        {
            string ranorexVersion = Ranorex.Host.Local.RanorexVersion;

            ranorexVersion = ranorexVersion.Remove(ranorexVersion.Length - 2);
            string executionTime = GlobalFunction.ExecutionTime();
            string userName      = WinComponent.loginUser;

            MySQLConnector.RunQuery("UPDATE testcases SET WRITE_STATUS=1, RX_VERSION='" + ranorexVersion + "', BUILD_DATE='" + executionTime + "', BUILDER='" + userName + "' WHERE TS_ID=" + testSuiteId + " AND TC_ID=" + testCaseId);
        }
Exemple #4
0
 public static void SetUserStatus(string userName, bool logout)
 {
     if (WinComponent.isDbOk)
     {
         if (logout)
         {
             MySQLConnector.RunQuery("UPDATE designers SET ACCESS_POINT=REPLACE(ACCESS_POINT, 'Main|','') WHERE USERNAME='******' AND ACCESS_POINT LIKE '%Web%'");
             MySQLConnector.RunQuery("UPDATE designers SET STATUS=0, ACCESS_POINT=NULL WHERE USERNAME='******' AND ACCESS_POINT='Main|'");
         }
         else
         {
             MySQLConnector.RunQuery("UPDATE designers SET STATUS=1, ACCESS_POINT=CONCAT(ACCESS_POINT, 'Main|') WHERE USERNAME='******' AND ACCESS_POINT NOT LIKE '%Main%'");
             MySQLConnector.RunQuery("UPDATE designers SET STATUS=1, ACCESS_POINT='Main|' WHERE USERNAME='******' AND ACCESS_POINT IS NULL");
         }
     }
 }
Exemple #5
0
        public static bool CheckScriptsExist(string testsuite_id)
        {
            string        test_suite_title = MySQLConnector.GetTestSuiteInfo(testsuite_id, 2);
            string        scriptFolder     = (GlobalFunction.GetConfigSettings("ScriptsDir")).Replace("%DBName%", "v" + WinComponent.sxDBVersion);  //GlobalFunction.GetConfigSettings("ScriptsDir");
            string        script_path      = scriptFolder + @"\TS_" + testsuite_id + "_" + test_suite_title.Replace(' ', '_').Replace('-', '_') + "\\";
            List <string> test_cases       = MySQLConnector.GetTestCaseList(testsuite_id);
            bool          result           = true;

            if (test_cases.Count == 0)
            {
                result = false;
            }
            foreach (string test_case in test_cases)
            {
                string test_case_title = "TC_" + test_case + "_" + MySQLConnector.GetTestCaseInfo(testsuite_id, test_case, 3).Replace(' ', '_').Replace('-', '_');
                if (!File.Exists(script_path + test_case_title + "\\" + test_case_title + ".exe"))
                {
                    result = false;
                    break;
                }
            }
            return(result);
        }