public async Task <TableCreate> CreateTable(string database, string table, Table hTable)
{
if (string.IsNullOrEmpty(database))
{
throw new Exception("database is required.");
}
if (string.IsNullOrEmpty(table))
{
throw new Exception("table is required.");
}
TableCreate tableCreate = await Put <TableCreate>(_webHcatBaseUrl, _webHCatVersion, _webHCatUserName, requestURL.CreateTable(database, table), hTable);
return(tableCreate);
}
private async void toolStripMenuItem2_Click(object sender, EventArgs e)
{
var node = (TreeNode)this.menuMenus.Tag;
if (node == null)
{
return;
}
if (node.Text.Equals("TABLES"))
{
this.TableCreate = new TableCreate(true, string.Empty);
if (TableCreate.ShowDialog() == DialogResult.OK)
{
try
{
var result = await this.controller.ExecuteConsult(TableCreate.Query);
if (result == 0)
{
this.treeViewDataConecction.Nodes.Clear();
var nodes = (await this.controller.GethTreeNodes()).ToArray();
this.treeViewDataConecction.Nodes.AddRange(nodes);
MessageBox.Show("The table was crate suscefully");
}
else
{
MessageBox.Show("Not was create the table");
}
}
catch (Exception exc)
{
MessageBox.Show("Internal error:" + exc.Message);
}
}
}
else if (node.Text.Equals("VIEWS"))
{
this.CreateView = new CreateView(true, string.Empty);
if (this.CreateView.ShowDialog() == DialogResult.OK)
{
try
{
var query = this.CreateView.Sql;
var result = await this.controller.ExecuteConsult(query);
if (result == 0)
{
this.treeViewDataConecction.Nodes.Clear();
var nodes = (await this.controller.GethTreeNodes()).ToArray();
this.treeViewDataConecction.Nodes.AddRange(nodes);
MessageBox.Show("The view was crate suscefully");
}
else
{
MessageBox.Show("Not was create the view");
}
}
catch (Exception)
{
MessageBox.Show("Internal error");
}
}
}
else if (node.Text.Equals("TRIGGERS"))
{
this.CreateTrigger = new CreateTrigger(true, string.Empty, this.controller.datab);
if (this.CreateTrigger.ShowDialog() == DialogResult.OK)
{
try
{
var query = this.CreateTrigger.Sql;
var result = await this.controller.ExecuteConsult(query);
if (result == 0)
{
this.treeViewDataConecction.Nodes.Clear();
var nodes = (await this.controller.GethTreeNodes()).ToArray();
this.treeViewDataConecction.Nodes.AddRange(nodes);
MessageBox.Show("The trigger was crate suscefully");
}
else
{
MessageBox.Show("Not was create the trigger");
}
}
catch (Exception exc)
{
MessageBox.Show("Internal error:" + exc.Message);
}
}
}
else if (node.Text.Equals("INDEXS"))
{
var nodeP = node.Parent;
if (nodeP == null)
{
return;
}
this.CreateIndex = new CreateIndex(true, "", this.controller.datab, nodeP.Text);
if (this.CreateIndex.ShowDialog() == DialogResult.OK)
{
try
{
var query = this.CreateIndex.Sql;
var result = await this.controller.ExecuteConsult(query);
if (result == 0)
{
this.treeViewDataConecction.Nodes.Clear();
var nodes = (await this.controller.GethTreeNodes()).ToArray();
this.treeViewDataConecction.Nodes.AddRange(nodes);
MessageBox.Show("The index was crate suscefully");
}
else
{
MessageBox.Show("Not was create the index");
}
}
catch (Exception esx)
{
MessageBox.Show("Internal error:" + esx.Message);
}
}
}
}
