private void btnScanOpen_Click(object sender, EventArgs e) { try { List <string> checkedcolumns = new List <string>(); foreach (TreeNode cnode in this.tvScanColumns.Nodes[0].Nodes) { if (cnode.Checked) { checkedcolumns.Add(cnode.Text.Substring(0, cnode.Text.Length - 1)); } else { foreach (TreeNode qnode in cnode.Nodes) { if (qnode.Checked) { checkedcolumns.Add(string.Concat(cnode.Text, qnode.Text)); } } } } if (checkedcolumns.Count != 0) { if (this.cboScanMode.SelectedIndex == 0) { _scanID = SetThriftServerForm.GetHBaseThriftClient().GetScan(this.TableName, new byte[0], checkedcolumns); } else if (this.cboScanMode.SelectedIndex == 1) { _scanID = SetThriftServerForm.GetHBaseThriftClient().GetScanWithPrefix(this.TableName, this.txtScanValue1.Text.Trim().GetUTF8Bytes(), checkedcolumns); } else if (this.cboScanMode.SelectedIndex == 2) { _scanID = SetThriftServerForm.GetHBaseThriftClient().GetScanWithStop(this.TableName, this.txtScanValue1.Text.Trim().GetUTF8Bytes(), this.txtScanValue2.Text.Trim().GetUTF8Bytes(), checkedcolumns); } ChangeScanStatus(true); } else { MessageBoxOperator.ShowInfo("Please Check one Column at least"); } } catch (Exception ex) { MessageBoxOperator.ShowError(ex.Message); LogOperator.Get().Error(ex.ToString()); } }
private void tsmiEnableTable_Click(object sender, EventArgs e) { try { HBaseThriftClient client = SetThriftServerForm.GetHBaseThriftClient(); client.EnableTable(this.tvMain.SelectedNode.Text); this.btnRefresh_Click(null, null); } catch (Exception ex) { LogOperator.Get().Error(ex.ToString()); MessageBoxOperator.ShowError(ex.Message); } }
private void btnRefresh_Click(object sender, EventArgs e) { this.Enabled = false; try { HBaseThriftClient client = SetThriftServerForm.GetHBaseThriftClient(); var tables = client.GetAllTableDefinition(); this.tvMain.Nodes[0].Nodes[0].Nodes.Clear(); foreach (var table in tables) { var tn = this.tvMain.Nodes[0].Nodes[0].Nodes.Add(table.Key); tn.SetImageIndex(table.Value.Item2 ? 2 : 3); tn.Tag = table.Value.Item1; var schema = TableSchemaManager.GetInstance().Get(table.Key); if (schema != null) { var ktn = tn.Nodes.Add("Row", string.Concat("Row", "(", schema.RowKeyType, ")")); ktn.SetImageIndex(6); } foreach (var column in table.Value.Item1) { var stn = tn.Nodes.Add(column.StringName, string.Concat(column.StringName, "(", column.Compression, ")", "[", column.MaxVersions, "]")); stn.SetImageIndex(4); stn.Tag = column; if (schema != null && schema.ColumnQualifierTypeAndFormats.ContainsKey(column.StringName)) { foreach (var qualifier in schema.ColumnQualifierTypeAndFormats[column.StringName]) { var qtn = stn.Nodes.Add(qualifier.Key, string.Concat(qualifier.Key, "(", qualifier.Value, ")")); qtn.SetImageIndex(5); } } } } this.tvMain.ExpandAll(); } catch (Exception ex) { LogOperator.Get().Error(ex.ToString()); MessageBoxOperator.ShowError(ex.Message); } finally { this.Enabled = true; } }
private void btnScanClose_Click(object sender, EventArgs e) { try { HBaseThriftClient.CloseScan(_scanID); } catch (Exception ex) { MessageBoxOperator.ShowError(ex.Message); LogOperator.Get().Error(ex.ToString()); } finally { ChangeScanStatus(false); } }
private void btnScanNext_Click(object sender, EventArgs e) { try { this.ClearScanQuery(); var result = HBaseThriftClient.DoScan(_scanID, (int)_maxScanCount.Value); if (result != null) { this.txtScanResult.Text = TableSchemaManager.GetInstance().ProcessTRowResultToString(this.TableName, result); this.txtScanRowCount.Text = result.Count.ToString(); } } catch (Exception ex) { MessageBoxOperator.ShowError(ex.Message); LogOperator.Get().Error(ex.ToString()); } }
private void btnCreateTable_Click(object sender, EventArgs e) { NewTableForm form = new NewTableForm(); if (form.ShowDialog() == System.Windows.Forms.DialogResult.OK) { try { HBaseThriftClient client = SetThriftServerForm.GetHBaseThriftClient(); client.CreateTable(form.TableName, null, form.Columns); this.btnRefresh_Click(null, null); } catch (Exception ex) { LogOperator.Get().Error(ex.ToString()); MessageBoxOperator.ShowError(ex.Message); } } }
private void btnSingleQuery_Click(object sender, EventArgs e) { if (!string.IsNullOrWhiteSpace(this.txtSingleQueryRowKey.Text)) { this.Enabled = false; try { this.ClearSingleQuery(); var schema = TableSchemaManager.GetInstance().Get(this.TableName); Type t = TableSchemaManager.ColumnDataTypes[schema.RowKeyType]; object v = Convert.ChangeType(this.txtSingleQueryRowKey.Text, t); byte[] rowkey = Extension.GetBytes(v, schema.RowKeyType, schema.RowKeyFormat); List <string> checkedcolumns = new List <string>(); foreach (TreeNode cnode in this.tvQueryColumn.Nodes[0].Nodes) { if (cnode.Checked) { checkedcolumns.Add(cnode.Text.Substring(0, cnode.Text.Length - 1)); } else { foreach (TreeNode qnode in cnode.Nodes) { if (qnode.Checked) { checkedcolumns.Add(string.Concat(cnode.Text, qnode.Text)); } } } } if (checkedcolumns.Count != 0) { List <TRowResult> result = null; long timestamp = 0; if (_enableSingleQueryTS.Checked) { timestamp = _singleQueryTS.Value.GetHBaseTimestamp(); } result = SetThriftServerForm.GetHBaseThriftClient().SingleQuery(this.TableName, rowkey, checkedcolumns, timestamp); if (result != null) { this.txtSingleQueryResult.Text = TableSchemaManager.GetInstance().ProcessTRowResultToString(this.TableName, result); this.txtSingleQueryRowCount.Text = result.Count.ToString(); } } else { MessageBoxOperator.ShowInfo("Please Check one Column at least"); } } catch (Exception ex) { MessageBoxOperator.ShowError(ex.Message); LogOperator.Get().Error(ex.ToString()); } finally { this.Enabled = true; } } }