public void http_client_adv() { var j = new JsonParser(); string url = "https://openbookmobile.etoro.com/api/login"; string header = @"Content-Type::application/x-www-form-urlencoded; charset=utf-8,, User-Agent::OpenBook/2.1 (iPad Simulator; iOS 7.1; Scale/2.00)"; string mode = "POST"; string postdata = @"username=socialalert15&Password=123456m&appName=iOS&ver=2.1"; string str = "m=" + mode + " h=" + header + " u=" + url + " p=" + postdata; //string dbapiResult = HttpRequestExtensions.GetHTTPrequest(url); j.AddKeyToMemory(Constants.Memory, HttpRequestExtensions.GetHTTPrequestPost(str)); string line = @"$$Token j= Token"; j.VariableFunctions(line); str = j.replaceVariable("$$Token"); line = "https://openbookmobile.etoro.com/api/market?username=socialalert15&symbol=GOOG&appName=iOS&ver=2.1&period=180&code=en-gb&token=$$Token"; j.AddKeyToMemory(Constants.Memory, HttpRequestExtensions.GetHTTPrequest(line)); line = @"$$MarketValue j= MarketValue"; j.VariableFunctions(line); str = j.replaceVariable("$$MarketValue"); line = @"$$StockSummary j= StockSummary"; j.VariableFunctions(line); str = j.replaceVariable("$$StockSummary"); }
public void http_client() { var j = new JsonParser(); //string url = "https://fapi-real.etoro.com/instruments.json"; string url = "https://fapi-real.etoro.com/instruments/1"; //string dbapiResult = HttpRequestExtensions.GetHTTPrequest(url); j.AddKeyToMemory(Constants.Memory, HttpRequestExtensions.GetHTTPrequest(url)); string line = @"$$instrumentData j= InstrumentName"; j.VariableFunctions(line); string str = j.replaceVariable("$$instrumentData"); j.VariableFunctions("$$DataSource = " + str); str = j.replaceVariable("$$memory"); line = @"$$instrumentData j= InstrumentName ==> $$DataSource"; j.VariableFunctions(line); str = j.replaceVariable("$$instrumentData"); }
public void ReplaceVariable() { var j = new JsonParser(); Boolean res = j.AddConfigToMemory(""); string a = @"aaaaaaaaaaaaaaaaaaaaa $$AppiumServerHost ~ $$app-package\ ~ bbbbbbbbbbbbb"; a = j.replaceVariable(a); Console.Write(a); }
/// <summary> /// VSH execute command line sql command /// </summary> /// <param name="query"></param> /// <returns></returns> public string ExecuteCMDQuery(string line) { //c=$$DataSource1 t=$$InitialDataTable cmd=select $$col from $$table $$db_serch string command = ""; string connection = ""; string init_table = ""; string mode = "select"; string returnval = string.Empty; Regex rem = new Regex(@"(,|;)?\s*$"); Regex nl = new Regex(@"\n\n"); var jp = new JsonParser(); line = jp.replaceVariable(line); //s= -- server //t= -- table //c= -- command Match match = Regex.Match(line, @"c=\s*((\w+).*?)(\s+s=|\s+t=|\s*$)", RegexOptions.IgnoreCase); if (match.Success) { command = match.Groups[1].Value; command = rem.Replace(command, ""); mode = match.Groups[2].Value; mode = mode.ToLower(); } else { return("ERROR: DB command not found"); } match = Regex.Match(line, @"s=\s*(.*?)(\s+c=|\s+t=|\s*$)", RegexOptions.IgnoreCase); if (match.Success) { connection = match.Groups[1].Value; connection = rem.Replace(connection, ""); } else { return("ERROR: DB connection string not found"); } match = Regex.Match(line, @"t=\s*(.*?)(\s+c=|\s+s=|\s*$)", RegexOptions.IgnoreCase); if (match.Success) { init_table = match.Groups[1].Value; init_table = rem.Replace(init_table, ""); } //add init table to connection string (if table exists) if (init_table != string.Empty) { connection = connection + ";" + init_table; } var con = new SqlConnection(connection); try { using (SqlCommand cmd = new SqlCommand(command, con)) { con.Open(); if (mode == "select") { using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { string row_line = ""; for (int i = 0; i < reader.FieldCount; i++) { row_line += reader.GetValue(i) + ", "; } row_line = rem.Replace(row_line, "\n"); returnval += row_line; } returnval = nl.Replace(returnval, "\n"); } } else { object data = cmd.ExecuteScalar(); if (data != null) { returnval = data.ToString().Trim(); returnval = mode + " action : OK"; } } } } catch (SqlException ex) { returnval = ex.ToString(); } return(returnval); }