public static void ExecuteQuery(string query) { using (MySqlCommand cmd = new MySqlCommand(query, GetDBConnection())) { cmd.CommandTimeout = Int32.Parse(BuilderJson.ReturnParameterAppSettings("DB_CONNECTION_TIMEOUT")); cmd.Connection.Open(); cmd.ExecuteNonQuery(); cmd.Connection.Close(); } }
public static void AddTestInfo(int methodLevel, string text) { if (BuilderJson.ReturnParameterAppSettings("GET_SCREENSHOT_FOR_EACH_STEP").ToString() == "true") { TEST.Log(Status.Pass, GeneralHelpers.GetMethodNameByLevel(methodLevel) + " || " + text, GetScreenShotMedia()); } else { TEST.Log(Status.Pass, GeneralHelpers.GetMethodNameByLevel(methodLevel) + " || " + text); } }
private static MySqlConnection GetDBConnection() { string connectionString = "Server=" + BuilderJson.ReturnParameterAppSettings("DB_URL") + "," + BuilderJson.ReturnParameterAppSettings("DB_PORT") + ";" + "Database=" + BuilderJson.ReturnParameterAppSettings("DB_NAME") + ";" + "UID=" + BuilderJson.ReturnParameterAppSettings("DB_USER") + "; " + "Password="******"DB_PASSWORD") + ";" + "Allow User Variables=True" + ";" + "SslMode=" + BuilderJson.ReturnParameterAppSettings("DB_SSLMODE"); MySqlConnection connection = new MySqlConnection(connectionString); return(connection); }
public static List <string> ObtemDados(String query, String[,] arrayDeParam = null) { DataSet ds = new DataSet(); List <string> lista = new List <string>(); using (MySqlCommand cmd = new MySqlCommand(query, GetDBConnection())) { cmd.CommandTimeout = Int32.Parse(BuilderJson.ReturnParameterAppSettings("DB_CONNECTION_TIMEOUT")); cmd.Connection.Open(); if (arrayDeParam != null) { int i = 0; while (i < arrayDeParam.GetLength(0)) { cmd.Parameters.AddWithValue(arrayDeParam[i, 0], arrayDeParam[i, 1]); i++; } } DataTable table = new DataTable(); table.Load(cmd.ExecuteReader()); ds.Tables.Add(table); cmd.Connection.Close(); } if (ds.Tables[0].Columns.Count == 0) { return(null); } try { for (int i = 0; i < ds.Tables[0].Columns.Count; i++) { lista.Add(ds.Tables[0].Rows[0][i].ToString()); } } catch (Exception) { return(null); } return(lista); }
public static void CreateInstance() { string browser = BuilderJson.ReturnParameterAppSettings("BROWSER"); string execution = BuilderJson.ReturnParameterAppSettings("EXECUTION"); bool headless = bool.Parse(BuilderJson.ReturnParameterAppSettings("HEADLESS")); if (INSTANCE == null) { switch (browser) { case "chrome": if (execution.Equals("local")) { INSTANCE = headless ? Browsers.GetLocalChromeHeadless() : Browsers.GetLocalChrome(); } if (execution.Equals("remota")) { INSTANCE = headless ? Browsers.GetRemoteChromeHeadless() : Browsers.GetRemoteChrome(); } break; case "ie": if (execution.Equals("local")) { INSTANCE = Browsers.GetLocalInternetExplorer(); } if (execution.Equals("remota")) { INSTANCE = Browsers.GetRemoteInternetExplorer(); } break; case "firefox": if (execution.Equals("local")) { INSTANCE = Browsers.GetLocalFirefox(); } if (execution.Equals("remota")) { INSTANCE = Browsers.GetRemoteFirefox(); } break; case "edge": if (execution.Equals("local")) { INSTANCE = Browsers.GetLocalEdge(); } if (execution.Equals("remota")) { INSTANCE = Browsers.GetRemoteEdge(); } break; default: throw new Exception("O browser informado não existe ou não é suportado pela automação"); } } }