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);
}
}
