File: AdminStartupVariablesOptionFile.pas

package info (click to toggle)
mysql-gui-tools 5.0r12-1
  • links: PTS
  • area: main
  • in suites: lenny
  • size: 105,540 kB
  • ctags: 50,897
  • sloc: sql: 348,439; pascal: 285,780; cpp: 94,578; ansic: 90,768; objc: 33,761; sh: 25,629; xml: 10,924; yacc: 10,755; java: 9,986; php: 2,806; python: 2,068; makefile: 1,945; perl: 3
file content (163 lines) | stat: -rw-r--r-- 4,636 bytes parent folder | download | duplicates (3)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
unit AdminStartupVariablesOptionFile;

interface

uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, TntControls,
  Forms, TntForms, Dialogs,
  TntDialogs, TntStdCtrls, TntExtCtrls, PNGImage, AuxFuncs,
  myx_admin_public_interface, myx_public_interface, myx_util_public_interface, Controls, StdCtrls,
  ExtCtrls;

type
  TAdminStartupVariablesOptionFileForm = class(TTntForm)
    ServiceSettingsHeaderImg: TTntImage;
    SheetHeaderLbl: TTntLabel;
    Label1: TTntLabel;
    GroupBox1: TTntGroupBox;
    Label2: TTntLabel;
    ParamConfigFileEd: TTntEdit;
    ChooseCnfFile: TTntButton;
    Label3: TTntLabel;
    ParamSectionNameCBox: TTntComboBox;
    Label4: TTntLabel;
    Label5: TTntLabel;
    CancelBtn: TTntButton;
    Button2: TTntButton;
    CreateNewSectionBtn: TTntButton;
    procedure FormCreate(Sender: TObject);
    procedure FormDestroy(Sender: TObject);
    procedure FormClose(Sender: TObject; var Action: TCloseAction);
    procedure SetConfigfFile(filename: WideString; section: WideString);
    procedure ChooseCnfFileClick(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure CreateNewSectionBtnClick(Sender: TObject);
  private
    { Private declarations }
    ServerParameterPNGImg: TPNGObject;
  public
    { Public declarations }
  end;

implementation

{$R *.dfm}

uses
  PNGTools;
  
procedure TAdminStartupVariablesOptionFileForm.FormCreate(Sender: TObject);

begin
  InitForm(self);

  ServerParameterPNGImg:=LoadPNGImageFromResource('server_parameter', ServiceSettingsHeaderImg);
end;

procedure TAdminStartupVariablesOptionFileForm.FormDestroy(
  Sender: TObject);
begin
  //
end;

procedure TAdminStartupVariablesOptionFileForm.FormClose(
  Sender: TObject; var Action: TCloseAction);
begin
  //
end;

procedure TAdminStartupVariablesOptionFileForm.SetConfigfFile(
  filename: WideString; section: WideString);
var stringlist: TMYX_STRINGLIST;
  pstringlist: PMYX_STRINGLIST;
  error: MYX_ADMIN_LIB_ERROR;
begin
  ParamConfigFileEd.Text:=filename;

  ParamSectionNameCBox.Items.Clear;

  //Get config file sections
  if(FileExists(filename))then
  begin
    pstringlist:=myx_get_all_cnf_sections(filename,@error);
    try
      stringlist:=TMYX_STRINGLIST.create(pstringlist);
      try
        ParamSectionNameCBox.Items.Assign(stringlist.strings)
      finally
        stringlist.Free;
      end;
    finally
      myx_free_lib_stringlist(pstringlist);
    end;
  end;

  if(ParamSectionNameCBox.Items.Count>0)then
  begin
    if(section='')then
      section:='mysqld';

    if(ParamSectionNameCBox.Items.IndexOf(section)<>-1)then
      ParamSectionNameCBox.ItemIndex:=ParamSectionNameCBox.Items.IndexOf(section)
    else
      ParamSectionNameCBox.ItemIndex:=0;
  end
  else
  begin
    ParamSectionNameCBox.Items.Add('mysqld');
    ParamSectionNameCBox.ItemIndex:=0;
  end;
end;

procedure TAdminStartupVariablesOptionFileForm.ChooseCnfFileClick(
  Sender: TObject);
var OpenDialog: TTntOpenDialog;
begin
  OpenDialog:=TTntOpenDialog.Create(self);
  try
    OpenDialog.InitialDir:=ExtractFilePath(ParamConfigFileEd.Text);
    OpenDialog.FileName:=ExtractFileName(ParamConfigFileEd.Text);
    OpenDialog.Filter:='All files|*.*|MySQL Configuration File (*.cnf)|*.cnf|'+
      'MySQL Configuration File (*.ini)|*.ini';
    OpenDialog.Options:=[ofPathMustExist, ofNoChangeDir, ofNoReadOnlyReturn,
      ofNoNetworkButton, ofEnableSizing, ofForceShowHidden];

    if(OpenDialog.Execute)then
      SetConfigfFile(OpenDialog.FileName, '');
  finally
    OpenDialog.Free;
  end;
end;

procedure TAdminStartupVariablesOptionFileForm.Button2Click(
  Sender: TObject);
begin
  if(DirectoryExists(ExtractFilePath(ParamConfigFileEd.Text)))then
    ModalResult:=mrOK
  else
    ShowModalDialog('Directory does not exist',
      'The directory where the configuration file should be located '+
      'must exists.',
      myx_mtError,
      'OK');
end;

procedure TAdminStartupVariablesOptionFileForm.CreateNewSectionBtnClick(
  Sender: TObject);
var section: WideString;
begin
  section:='mysqld';

  if(ShowModalEditDialog('Create new Section',
    'Please enter a name for the new section, e.g. mysqld, server...',
    myx_mtEdit, 'OK'#13#10'Cancel',
    True, 'Section Name:', section)=1)then
  begin
    if(ParamSectionNameCBox.Items.IndexOf(section)=-1)then
      ParamSectionNameCBox.Items.Add(section);

    ParamSectionNameCBox.ItemIndex:=ParamSectionNameCBox.Items.IndexOf(section);
  end;
end;

end.