public Table_ColumnView(UserManager user)
{
this.user = user;
edited = false;
InitializeComponent();
Editbox.Lexer = Lexer.Sql;
Editbox.Margins[0].Width = 20;
Editbox.Styles[ScintillaNET.Style.Sql.Number].ForeColor = Color.DarkOrange;
Editbox.Styles[ScintillaNET.Style.Sql.String].ForeColor = Color.SaddleBrown;
Editbox.Styles[ScintillaNET.Style.Sql.Character].ForeColor = Color.LimeGreen;
Editbox.Styles[ScintillaNET.Style.Sql.Word].ForeColor = Color.Blue;
Editbox.Styles[ScintillaNET.Style.Sql.Word2].ForeColor = Color.Blue;
Editbox.SetKeywords(0, Words.Reserved1);
Editbox.SetKeywords(1, Words.Reserved2);
}
public NewView(ToolManager tool, UserManager usermanager)
{
Tool = tool;
User = usermanager;
InitializeComponent();
Editbox.Lexer = Lexer.Sql;
Editbox.Margins[0].Width = 20;
Editbox.Styles[Style.Sql.Number].ForeColor = Color.DarkOrange;
Editbox.Styles[Style.Sql.String].ForeColor = Color.SaddleBrown;
Editbox.Styles[Style.Sql.Character].ForeColor = Color.LimeGreen;
Editbox.Styles[Style.Sql.Word].ForeColor = Color.Blue;
Editbox.Styles[Style.Sql.Word2].ForeColor = Color.Blue;
Editbox.SetKeywords(0, Words.Reserved1);
Editbox.SetKeywords(1, Words.Reserved2);
this.Editbox.Text = "CREATE VIEW 'new_view' AS" + "\n";
}
public NewTable(ToolManager tool, UserManager usermanager)
{
Tool = tool;
User = usermanager;
InitializeComponent();
Editbox.Lexer = Lexer.Sql;
Editbox.Margins[0].Width = 20;
Editbox.Styles[Style.Sql.Number].ForeColor = Color.DarkOrange;
Editbox.Styles[Style.Sql.String].ForeColor = Color.SaddleBrown;
Editbox.Styles[Style.Sql.Character].ForeColor = Color.LimeGreen;
Editbox.Styles[Style.Sql.Word].ForeColor = Color.Blue;
Editbox.Styles[Style.Sql.Word2].ForeColor = Color.Blue;
Editbox.SetKeywords(0, Words.Reserved1);
Editbox.SetKeywords(1, Words.Reserved2);
this.Editbox.Text = "CREATE TABLE 'TableName' ('Column Name' 'ColumnType' 'NOT NULL' 'AUTO_INCREMENT',Repeat" +
",PRIMARY KEY ('columnName'))";
}
public DDLView(UserManager user, string text)
{
this.user = user;
InitializeComponent();
Editbox.Lexer = Lexer.Sql;
Editbox.Margins[0].Width = 20;
Editbox.Styles[Style.Sql.Number].ForeColor = Color.DarkOrange;
Editbox.Styles[Style.Sql.String].ForeColor = Color.SaddleBrown;
Editbox.Styles[Style.Sql.Character].ForeColor = Color.LimeGreen;
Editbox.Styles[Style.Sql.Word].ForeColor = Color.Blue;
Editbox.Styles[Style.Sql.Word2].ForeColor = Color.Blue;
Editbox.SetKeywords(0, Words.Reserved1);
Editbox.SetKeywords(1, Words.Reserved2);
Editbox.Text = text;
current = text;
button1.Show();
button2.Show();
}
public Form1()
{
InitializeComponent();
Usermanager = new UserManager(new ConnectionManager(connect));
Console.WriteLine(Usermanager.Connection.ConnectionStatus().message);
Editbox.Lexer = Lexer.Sql;
Editbox.Margins[0].Width = 20;
Editbox.Styles[Style.Sql.Number].ForeColor = Color.DarkOrange;
Editbox.Styles[Style.Sql.String].ForeColor = Color.SaddleBrown;
Editbox.Styles[Style.Sql.Character].ForeColor = Color.LimeGreen;
Editbox.Styles[Style.Sql.Word].ForeColor = Color.Blue;
Editbox.Styles[Style.Sql.Word2].ForeColor = Color.Blue;
Editbox.SetKeywords(0, Words.Reserved1);
Editbox.SetKeywords(1, Words.Reserved2);
LoadtreeDB();
}
public NewIndex(ToolManager tool, UserManager usermanager)
{
Tool = tool;
User = usermanager;
InitializeComponent();
Editbox.Lexer = Lexer.Sql;
Editbox.Margins[0].Width = 20;
Editbox.Styles[Style.Sql.Number].ForeColor = Color.DarkOrange;
Editbox.Styles[Style.Sql.String].ForeColor = Color.SaddleBrown;
Editbox.Styles[Style.Sql.Character].ForeColor = Color.LimeGreen;
Editbox.Styles[Style.Sql.Word].ForeColor = Color.Blue;
Editbox.Styles[Style.Sql.Word2].ForeColor = Color.Blue;
Editbox.SetKeywords(0, Words.Reserved1);
Editbox.SetKeywords(1, Words.Reserved2);
this.Editbox.Text = "CREATE INDEX 'your_index_name' " + "\n" +
"ON 'your_table_name'('your_column_name')" + "\n" + "USING BTREE;";
this.RBNonUnique.Checked = true;
}
public NewTrigger(ToolManager tool, UserManager usermanager)
{
Tool = tool;
User = usermanager;
InitializeComponent();
Editbox.Lexer = Lexer.Sql;
Editbox.Margins[0].Width = 20;
Editbox.Styles[Style.Sql.Number].ForeColor = Color.DarkOrange;
Editbox.Styles[Style.Sql.String].ForeColor = Color.SaddleBrown;
Editbox.Styles[Style.Sql.Character].ForeColor = Color.LimeGreen;
Editbox.Styles[Style.Sql.Word].ForeColor = Color.Blue;
Editbox.Styles[Style.Sql.Word2].ForeColor = Color.Blue;
Editbox.SetKeywords(0, Words.Reserved1);
Editbox.SetKeywords(1, Words.Reserved2);
this.RBBefore.Checked = true;
this.comboBox1.Text = comboBox1.Items[0].ToString();
this.Editbox.Text = "CREATE TRIGGER 'trigger_name' 'trigger_time'" + "\n" + "'trigger_event' ON table_name FOR EACH ROW" +
"\n" +
"BEGIN" + "\n" + "END";
}