/// <summary>
/// test 8
/// testing the execution of the query
/// </summary>
/// <returns></returns>
private string Test8()
{
Message m8 = new Message();
m8.TestID = 8;
m_clientapi = new ClientAPI();
m_clientapi.SetRootServer(RootServerUrl);
m_clientapi.SetAuthHostAddress(AuthServerUrl);
m_clientapi.ConfigClient();
m_QueryObj = m_clientapi.ExecuteQuery("CREATE DB first_db", m_temptoken);
if ((m_QueryObj.GetId() == 0) && (m_QueryObj.GetMessage() == "Database is not created"))
{
m8.Passed = false;
m8.Msg = "m_clientapi.ExecuteQuery fails";
}
else
{
m8.Passed = true;
m8.Msg = "m_clientapi.ExecuteQuery succeeds";
}
return m8.ToString();
}
public static void Main(string[] args)
{
DependencyInjection di = DependencyInjection.GetInstance();
di.SetConfig("config.xml");
Console.WriteLine("test begins");
ClientAPI m_TestObject = new ClientAPI();
m_TestObject.SetRootServer("http://localhost:8080/root");
m_TestObject.SetAuthHostAddress("http://localhost:8080/IComm");
m_TestObject.ConfigClient();
m_TestObject.ExecuteQuery("SELECT * FROM first_db.test_table", "mocktoken");
if (m_TestObject.CheckIfRowsReturned())
{
List<string> string1 = m_TestObject.IterateDataSet();
List<string> ColNames = m_TestObject.GetAllColumnNames();
List<System.Type> ColTypes = m_TestObject.GetAllColumnTypes();
if (string1 == null) Console.WriteLine("the end");
Console.WriteLine(string1[1]);
string1 = m_TestObject.IterateDataSet();
if (string1 == null) Console.WriteLine("the end");
Console.WriteLine(string1[1]);
string1 = m_TestObject.IterateDataSet();
if (string1 == null) Console.WriteLine("the end");
Console.WriteLine(string1[1]);
string1 = m_TestObject.IterateDataSet();
if (string1 == null) Console.WriteLine("the end");
Console.WriteLine(string1[1]);
string1 = m_TestObject.IterateDataSet();
if (string1 == null) Console.WriteLine("the end");
Console.WriteLine(string1[1]);
string1 = m_TestObject.IterateDataSet();
if (string1 == null) Console.WriteLine("the end");
Console.WriteLine(string1[1]);
string1 = m_TestObject.IterateDataSet();
if (string1 == null) Console.WriteLine("the end");
Console.WriteLine(string1[1]);
string1 = m_TestObject.IterateDataSet();
if (string1 == null) Console.WriteLine("the end");
Console.WriteLine(string1[1]);
string1 = m_TestObject.IterateDataSet();
if (string1 == null) Console.WriteLine("the end");
Console.WriteLine(string1[1]);
string1 = m_TestObject.IterateDataSet();
if (string1 == null) Console.WriteLine("the end");
Console.WriteLine(string1[1]);
string1 = m_TestObject.IterateDataSet();
if (string1 == null) Console.WriteLine("the end");
}
else
{
Console.WriteLine(" no row returned");
}
}
/// <summary>
/// To execute the select statements , when the table name is selected in the tree view
/// </summary>
/// <param name="m_TableName"></param>
private void ExecuteSelectQuery(string m_TableName)
{
try
{
m_clientapi = new ClientAPI();
m_clientapi.SetRootServer(RootServerUrl);
m_clientapi.SetAuthHostAddress(AuthServerUrl);
m_clientapi.ConfigClient();
m_DgContentOfTables.ItemsSource = null;
string m_Query = "SELECT * FROM " + this.GetKeyForValue(m_DBTableInfos, m_TableName) + "." + m_TableName;
m_clientapi.ExecuteQuery(m_Query, LoginToken);
if (m_clientapi.CheckIfRowsReturned())
{
DataTable DataGridDataTable = this.GenerateColumnNameAndTypes(m_clientapi);
m_DgContentOfTables.ItemsSource = DataGridDataTable.DefaultView;
}
else
{
MessageBox.Show("No rows of Data Returned");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}