public CGIResponseData GetData(string[] commandline) { if (commandline == null || commandline.Length != 2) { return(new CGIResponseData("Error in command line. " + UsageText)); } try { InitThreadContext(); var commandtype = commandline[0].ToLowerInvariant(); var commandtext = commandline[1]; using (var connection = new PqlDataConnection()) { connection.ConnectionString = ConnectionString; connection.Open(); var cmd = connection.CreateCommand(); cmd.CommandText = commandtext; if (commandtype == "prepare") { cmd.Prepare(); return(new CGIResponseData("Prepared.")); } if (commandtype == "u") { var raff = cmd.ExecuteNonQuery(); return(new CGIResponseData("Update complete. Affected records: " + raff)); } if (commandtype == "q") { using (var reader = cmd.ExecuteReader()) { return(new CGIResponseData(reader)); } } return(new CGIResponseData("Invalid command type: " + commandtype + ". " + UsageText)); } } catch (Exception e) { return(new CGIResponseData(e.Message)); } }
private PqlDataConnection GetTestConnection() { SetThreadContext(-1); var conn = new PqlDataConnection(); conn.ConnectionString = string.Format( "Server={0}/{1};Database={2}", TestServiceContainer.TestHostBaseAddressTcp, TestServiceContainer == null ? "default" : TestServiceContainer.ServiceInstanceName, ConfigurationManager.AppSettings["PqlProcessorTestScopeId"]); conn.Open(); return(conn); }
public CGIResponseData GetData(string[] commandline) { if (commandline == null || commandline.Length != 2) { return new CGIResponseData("Error in command line. " + UsageText); } try { InitThreadContext(); var commandtype = commandline[0].ToLowerInvariant(); var commandtext = commandline[1]; using (var connection = new PqlDataConnection()) { connection.ConnectionString = ConnectionString; connection.Open(); var cmd = connection.CreateCommand(); cmd.CommandText = commandtext; if (commandtype == "prepare") { cmd.Prepare(); return new CGIResponseData("Prepared."); } if (commandtype == "u") { var raff = cmd.ExecuteNonQuery(); return new CGIResponseData("Update complete. Affected records: " + raff); } if (commandtype == "q") { using (var reader = cmd.ExecuteReader()) { return new CGIResponseData(reader); } } return new CGIResponseData("Invalid command type: " + commandtype + ". " + UsageText); } } catch (Exception e) { return new CGIResponseData(e.Message); } }