summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
Diffstat
-rw-r--r--extras/lazarus_ide/regfpguitestrunner.pas2
-rw-r--r--extras/tiopf/demos/Common/frm_pickdatabase.pas363
-rw-r--r--extras/tiopf/demos/Demo_04_CreateDatabase/demo_04.lpi71
-rw-r--r--extras/tiopf/demos/Demo_04_CreateDatabase/demo_04.lpr39
-rw-r--r--extras/tiopf/demos/Demo_04_CreateDatabase/frm_main.pas179
-rw-r--r--extras/tiopf/tiOPFfpGUI.lpk4
6 files changed, 655 insertions, 3 deletions
diff --git a/extras/lazarus_ide/regfpguitestrunner.pas b/extras/lazarus_ide/regfpguitestrunner.pas
index 3a6fd791..6c5806f2 100644
--- a/extras/lazarus_ide/regfpguitestrunner.pas
+++ b/extras/lazarus_ide/regfpguitestrunner.pas
@@ -5,7 +5,7 @@ unit regfpguitestrunner;
interface
uses
- Classes, SysUtils,LazIDEIntf, ProjectIntf, Controls, Forms;
+ Classes, SysUtils, lazideintf, ProjectIntf, Controls, Forms;
Type
diff --git a/extras/tiopf/demos/Common/frm_pickdatabase.pas b/extras/tiopf/demos/Common/frm_pickdatabase.pas
new file mode 100644
index 00000000..de215829
--- /dev/null
+++ b/extras/tiopf/demos/Common/frm_pickdatabase.pas
@@ -0,0 +1,363 @@
+unit frm_pickdatabase;
+
+{$mode objfpc}{$H+}
+
+interface
+
+uses
+ SysUtils
+ ,Classes
+ ,contnrs
+ // fpGUI
+ ,fpg_base
+ ,fpg_main
+ ,fpg_form
+ ,fpg_button
+ ,fpg_edit
+ ,fpg_combobox
+ ,fpg_tab
+ ,fpg_label
+ // tiOPF
+ ,tiPersistenceLayers
+ ;
+
+
+const
+ cINIIdentLastPerLayer = 'LastPerLayer';
+
+type
+
+ TPickDatabaseForm = class(TfpgForm)
+ private
+ {@VFD_HEAD_BEGIN: PickDatabaseForm}
+ PageControl1: TfpgPageControl;
+ tsDatabase: TfpgTabSheet;
+ btnReset: TfpgButton;
+ Label1: TfpgLabel;
+ cbPersistenceLayer: TfpgComboBox;
+ Label2: TfpgLabel;
+ edtDatabaseName: TfpgEdit;
+ Label3: TfpgLabel;
+ edtUsername: TfpgEdit;
+ Label4: TfpgLabel;
+ edtPassword: TfpgEdit;
+ btnDone: TfpgButton;
+ {@VFD_HEAD_END: PickDatabaseForm}
+ FSingleUserPersistenceLayers: TObjectList;
+ function GetDatabaseName: string;
+ function GetPassword: string;
+ function GetPersistenceLayerName: string;
+ function GetUserName: string;
+ procedure SetPersistenceLayer(const APersistenceLayerName: string);
+ procedure RegisterPersistenceLayersAsTests;
+ procedure RegisterPersistenceLayerAsTest(const APersistenceLayer: TtiPersistenceLayer);
+ procedure FormShow(Sender: TObject);
+ procedure PersistenceLayerChanged(Sender: TObject);
+ procedure DefaultToPresetValuesClick(Sender: TObject);
+ protected
+ function GetDataDir: string; virtual;
+ public
+ constructor Create(AOwner: TComponent); override;
+ procedure AfterCreate; override;
+ property SingleUserPersistenceLayers: TObjectList read FSingleUserPersistenceLayers;
+ property PersistenceLayerName: string read GetPersistenceLayerName;
+ property DatabaseName : string read GetDatabaseName;
+ property UserName : string read GetUserName;
+ property Password : string read GetPassword;
+ end;
+
+{@VFD_NEWFORM_DECL}
+
+implementation
+
+uses
+ tiConstants
+ ,tiUtils
+ ,tiOPFManager
+ ,tiINI
+ ;
+
+{@VFD_NEWFORM_IMPL}
+
+function TPickDatabaseForm.GetDatabaseName: string;
+begin
+ Result := edtDatabaseName.Text;
+end;
+
+function TPickDatabaseForm.GetPassword: string;
+begin
+ Result := edtPassword.Text;
+end;
+
+function TPickDatabaseForm.GetPersistenceLayerName: string;
+begin
+ Result := cbPersistenceLayer.Text;
+end;
+
+function TPickDatabaseForm.GetUserName: string;
+begin
+ Result := edtUsername.Text;
+end;
+
+procedure TPickDatabaseForm.SetPersistenceLayer(const APersistenceLayerName: string);
+var
+ LPL: TtiPersistenceLayer;
+ LDefaults: TtiPersistenceLayerDefaults;
+begin
+ LPL:= GTIOPFManager.PersistenceLayers.FindByPersistenceLayerName(APersistenceLayerName);
+ if LPL<>nil then
+ begin
+ LDefaults:= TtiPersistenceLayerDefaults.Create;
+ try
+ LPL.AssignPersistenceLayerDefaults(LDefaults);
+ cbPersistenceLayer.Text := LDefaults.PersistenceLayerName;
+ edtDatabaseName.Text := ExpandFileName(GetDataDir + LDefaults.DatabaseName);
+ edtUserName.Text := LDefaults.UserName;
+ edtPassword.Text := LDefaults.Password;
+ gINI.WriteString(Name, cINIIdentLastPerLayer, LDefaults.PersistenceLayerName);
+ finally
+ LDefaults.Free;
+ end;
+ end else
+ begin
+ cbPersistenceLayer.FocusItem := -1;
+ edtDatabaseName.Text := '';
+ edtUserName.Text := '';
+ edtPassword.Text := '';
+ end;
+end;
+
+procedure TPickDatabaseForm.RegisterPersistenceLayersAsTests;
+var
+ i: integer;
+begin
+ for i := 0 to GTIOPFManager.PersistenceLayers.Count - 1 do
+ RegisterPersistenceLayerAsTest(GTIOPFManager.PersistenceLayers.Items[i]);
+end;
+
+procedure TPickDatabaseForm.RegisterPersistenceLayerAsTest(const APersistenceLayer: TtiPersistenceLayer);
+var
+ LDefaults: TtiPersistenceLayerDefaults;
+begin
+ Assert(APersistenceLayer.TestValid, CTIErrorInvalidObject);
+ LDefaults:= TtiPersistenceLayerDefaults.Create;
+ try
+ APersistenceLayer.AssignPersistenceLayerDefaults(LDefaults);
+ cbPersistenceLayer.Items.Add(LDefaults.PersistenceLayerName);
+ finally
+ LDefaults.Free;
+ end;
+end;
+
+procedure TPickDatabaseForm.FormShow(Sender: TObject);
+var
+ lLastPerLayer: string;
+begin
+ PageControl1.ActivePageIndex := 0;
+ RegisterPersistenceLayersAsTests;
+ lLastPerLayer := gINI.ReadString(Name, 'LastPerLayer', '');
+ SetPersistenceLayer(lLastPerLayer);
+end;
+
+procedure TPickDatabaseForm.PersistenceLayerChanged(Sender: TObject);
+begin
+ SetPersistenceLayer(cbPersistenceLayer.Text);
+end;
+
+procedure TPickDatabaseForm.DefaultToPresetValuesClick(Sender: TObject);
+begin
+ SetPersistenceLayer(cbPersistenceLayer.Text);
+end;
+
+function TPickDatabaseForm.GetDataDir: string;
+var
+ dir: string;
+begin
+ dir := tiAddTrailingSlash(tiGetAppDataDirPrivate) + '_Data\';
+ result := ExpandFileName(tiFixPathDelim(dir));
+end;
+
+constructor TPickDatabaseForm.Create(AOwner: TComponent);
+begin
+ inherited Create(AOwner);
+ OnShow := @FormShow;
+ FSingleUserPersistenceLayers := TObjectList.Create(False);
+end;
+
+procedure TPickDatabaseForm.AfterCreate;
+begin
+ {@VFD_BODY_BEGIN: PickDatabaseForm}
+ Name := 'PickDatabaseForm';
+ SetPosition(301, 186, 464, 248);
+ WindowTitle := 'Pick Database';
+
+ PageControl1 := TfpgPageControl.Create(self);
+ with PageControl1 do
+ begin
+ Name := 'PageControl1';
+ SetPosition(8, 12, 446, 224);
+ Anchors := [anLeft,anRight,anTop,anBottom];
+ ActivePageIndex := 0;
+ ParentShowHint := True;
+ TabOrder := 0;
+ end;
+
+ tsDatabase := TfpgTabSheet.Create(PageControl1);
+ with tsDatabase do
+ begin
+ Name := 'tsDatabase';
+ SetPosition(3, 24, 440, 197);
+ Text := 'Database';
+ end;
+
+ btnReset := TfpgButton.Create(tsDatabase);
+ with btnReset do
+ begin
+ Name := 'btnReset';
+ SetPosition(296, 24, 132, 24);
+ Text := 'Reset to Defaults';
+ AllowAllUp := False;
+ Embedded := False;
+ Flat := False;
+ FontDesc := '#Label1';
+ GroupIndex := 0;
+ Hint := '';
+ ImageLayout := ilImageLeft;
+ ImageMargin := 3;
+ ImageName := '';
+ ImageSpacing := -1;
+ ModalResult := 0;
+ ParentShowHint := True;
+ ShowImage := True;
+ TabOrder := 0;
+ OnClick := @DefaultToPresetValuesClick;
+ end;
+
+ Label1 := TfpgLabel.Create(tsDatabase);
+ with Label1 do
+ begin
+ Name := 'Label1';
+ SetPosition(8, 4, 220, 18);
+ Alignment := taLeftJustify;
+ FontDesc := '#Label1';
+ Hint := '';
+ Layout := tlTop;
+ ParentShowHint := True;
+ Text := 'Persistence Layer';
+ WrapText := False;
+ end;
+
+ cbPersistenceLayer := TfpgComboBox.Create(tsDatabase);
+ with cbPersistenceLayer do
+ begin
+ Name := 'cbPersistenceLayer';
+ SetPosition(8, 24, 268, 24);
+ FontDesc := '#List';
+ ParentShowHint := True;
+ TabOrder := 2;
+ OnChange :=@PersistenceLayerChanged;
+ end;
+
+ Label2 := TfpgLabel.Create(tsDatabase);
+ with Label2 do
+ begin
+ Name := 'Label2';
+ SetPosition(8, 50, 232, 18);
+ Alignment := taLeftJustify;
+ FontDesc := '#Label1';
+ Hint := '';
+ Layout := tlTop;
+ ParentShowHint := True;
+ Text := 'Database Name';
+ WrapText := False;
+ end;
+
+ edtDatabaseName := TfpgEdit.Create(tsDatabase);
+ with edtDatabaseName do
+ begin
+ Name := 'edtDatabaseName';
+ SetPosition(8, 68, 268, 24);
+ TabOrder := 4;
+ Text := '';
+ FontDesc := '#Edit1';
+ ParentShowHint := True;
+ end;
+
+ Label3 := TfpgLabel.Create(tsDatabase);
+ with Label3 do
+ begin
+ Name := 'Label3';
+ SetPosition(8, 94, 232, 18);
+ Alignment := taLeftJustify;
+ FontDesc := '#Label1';
+ Hint := '';
+ Layout := tlTop;
+ ParentShowHint := True;
+ Text := 'Username';
+ WrapText := False;
+ end;
+
+ edtUsername := TfpgEdit.Create(tsDatabase);
+ with edtUsername do
+ begin
+ Name := 'edtUsername';
+ SetPosition(8, 112, 268, 24);
+ TabOrder := 6;
+ Text := '';
+ FontDesc := '#Edit1';
+ ParentShowHint := True;
+ end;
+
+ Label4 := TfpgLabel.Create(tsDatabase);
+ with Label4 do
+ begin
+ Name := 'Label4';
+ SetPosition(8, 138, 232, 18);
+ Alignment := taLeftJustify;
+ FontDesc := '#Label1';
+ Hint := '';
+ Layout := tlTop;
+ ParentShowHint := True;
+ Text := 'Password';
+ WrapText := False;
+ end;
+
+ edtPassword := TfpgEdit.Create(tsDatabase);
+ with edtPassword do
+ begin
+ Name := 'edtPassword';
+ SetPosition(8, 156, 268, 24);
+ TabOrder := 8;
+ Text := '';
+ FontDesc := '#Edit1';
+ ParentShowHint := True;
+ end;
+
+ btnDone := TfpgButton.Create(tsDatabase);
+ with btnDone do
+ begin
+ Name := 'btnDone';
+ SetPosition(296, 156, 132, 24);
+ Text := 'DONE';
+ AllowAllUp := False;
+ Embedded := False;
+ Flat := False;
+ FontDesc := '#Label1';
+ GroupIndex := 0;
+ Hint := '';
+ ImageLayout := ilImageLeft;
+ ImageMargin := 3;
+ ImageName := '';
+ ImageSpacing := -1;
+ ModalResult := 0;
+ ParentShowHint := True;
+ ShowImage := True;
+ TabOrder := 11;
+ ModalResult := mrOK;
+ end;
+
+ {@VFD_BODY_END: PickDatabaseForm}
+end;
+
+
+end.
diff --git a/extras/tiopf/demos/Demo_04_CreateDatabase/demo_04.lpi b/extras/tiopf/demos/Demo_04_CreateDatabase/demo_04.lpi
new file mode 100644
index 00000000..d2059b58
--- /dev/null
+++ b/extras/tiopf/demos/Demo_04_CreateDatabase/demo_04.lpi
@@ -0,0 +1,71 @@
+<?xml version="1.0"?>
+<CONFIG>
+ <ProjectOptions>
+ <PathDelim Value="/"/>
+ <Version Value="6"/>
+ <General>
+ <Flags>
+ <SaveOnlyProjectUnits Value="True"/>
+ </Flags>
+ <SessionStorage Value="InProjectDir"/>
+ <MainUnit Value="0"/>
+ <TargetFileExt Value=""/>
+ </General>
+ <VersionInfo>
+ <ProjectVersion Value=""/>
+ </VersionInfo>
+ <PublishOptions>
+ <Version Value="2"/>
+ <IgnoreBinaries Value="False"/>
+ <IncludeFileFilter Value="*.(pas|pp|inc|lfm|lpr|lrs|lpi|lpk|sh|xml)"/>
+ <ExcludeFileFilter Value="*.(bak|ppu|ppw|o|so);*~;backup"/>
+ </PublishOptions>
+ <RunParams>
+ <local>
+ <FormatVersion Value="1"/>
+ <LaunchingApplication PathPlusParams="/usr/X11R6/bin/xterm -T 'Lazarus Run Output' -e $(LazarusDir)/tools/runwait.sh $(TargetCmdLine)"/>
+ </local>
+ </RunParams>
+ <RequiredPackages Count="2">
+ <Item1>
+ <PackageName Value="tiOPFfpGUI"/>
+ </Item1>
+ <Item2>
+ <PackageName Value="fpgui_toolkit"/>
+ </Item2>
+ </RequiredPackages>
+ <Units Count="3">
+ <Unit0>
+ <Filename Value="demo_04.lpr"/>
+ <IsPartOfProject Value="True"/>
+ <UnitName Value="demo_04"/>
+ </Unit0>
+ <Unit1>
+ <Filename Value="../Common/frm_pickdatabase.pas"/>
+ <IsPartOfProject Value="True"/>
+ <UnitName Value="frm_pickdatabase"/>
+ </Unit1>
+ <Unit2>
+ <Filename Value="frm_main.pas"/>
+ <IsPartOfProject Value="True"/>
+ <UnitName Value="frm_main"/>
+ </Unit2>
+ </Units>
+ </ProjectOptions>
+ <CompilerOptions>
+ <Version Value="8"/>
+ <SearchPaths>
+ <OtherUnitFiles Value="../Common/"/>
+ </SearchPaths>
+ <Parsing>
+ <SyntaxOptions>
+ <CStyleOperator Value="False"/>
+ </SyntaxOptions>
+ </Parsing>
+ <Other>
+ <CustomOptions Value="-FUunits
+"/>
+ <CompilerPath Value="$(CompPath)"/>
+ </Other>
+ </CompilerOptions>
+</CONFIG>
diff --git a/extras/tiopf/demos/Demo_04_CreateDatabase/demo_04.lpr b/extras/tiopf/demos/Demo_04_CreateDatabase/demo_04.lpr
new file mode 100644
index 00000000..d7ff4605
--- /dev/null
+++ b/extras/tiopf/demos/Demo_04_CreateDatabase/demo_04.lpr
@@ -0,0 +1,39 @@
+program demo_04;
+
+{$mode objfpc}{$H+}
+
+uses
+ {$IFDEF UNIX}{$IFDEF UseCThreads}
+ cthreads,
+ {$ENDIF}{$ENDIF}
+ Classes
+ ,SysUtils
+ ,fpg_main
+ ,tiOPFManager
+ ,tiConstants
+ ,frm_main
+ ;
+
+
+
+procedure MainProc;
+var
+ frm: TMainForm;
+begin
+ fpgApplication.Initialize;
+ frm := TMainForm.Create(nil);
+ try
+ frm.Show;
+ fpgApplication.Run;
+ finally
+ frm.Free;
+ gTIOPFManager.Terminate;
+ end;
+end;
+
+begin
+ MainProc;
+end.
+
+
+
diff --git a/extras/tiopf/demos/Demo_04_CreateDatabase/frm_main.pas b/extras/tiopf/demos/Demo_04_CreateDatabase/frm_main.pas
new file mode 100644
index 00000000..4bd0c9ab
--- /dev/null
+++ b/extras/tiopf/demos/Demo_04_CreateDatabase/frm_main.pas
@@ -0,0 +1,179 @@
+unit frm_main;
+
+{$mode objfpc}{$H+}
+
+interface
+
+uses
+ SysUtils, Classes, fpg_base, fpg_main, fpg_form, fpg_button, fpg_panel;
+
+type
+
+ TMainForm = class(TfpgForm)
+ private
+ {@VFD_HEAD_BEGIN: MainForm}
+ btnPickDB: TfpgButton;
+ btnCreateDB: TfpgButton;
+ btnDBExists: TfpgButton;
+ pnlDBName: TfpgPanel;
+ {@VFD_HEAD_END: MainForm}
+ FPersistenceLayerName: string;
+ FDatabaseName: string;
+ FUsername: string;
+ FPassword: string;
+ procedure PickDBClicked(Sender: TObject);
+ procedure DatabaseExistsClicked(Sender: TObject);
+ procedure CreateDatabaseClicked(Sender: TObject);
+ public
+ procedure AfterCreate; override;
+ end;
+
+{@VFD_NEWFORM_DECL}
+
+implementation
+
+uses
+ frm_pickdatabase
+ ,fpg_dialogs
+ ,tiOPFManager
+ ,tiPersistenceLayers
+ ,tiDialogs
+ ;
+
+{@VFD_NEWFORM_IMPL}
+
+procedure TMainForm.PickDBClicked(Sender: TObject);
+var
+ frm: TPickDatabaseForm;
+begin
+ frm := TPickDatabaseForm.Create(nil);
+ try
+ if frm.ShowModal = mrOK then
+ begin
+ FPersistenceLayerName := frm.PersistenceLayerName;
+ FDatabaseName := frm.DatabaseName;
+ FUsername := frm.UserName;
+ FPassword := frm.Password;
+ pnlDBName.Text := frm.DatabaseName;
+ end;
+ finally
+ frm.Free;
+ end;
+end;
+
+procedure TMainForm.DatabaseExistsClicked(Sender: TObject);
+var
+ LPerLayer: TtiPersistenceLayer;
+begin
+ LPerLayer:= GTIOPFManager.PersistenceLayers.FindByPersistenceLayerName(FPersistenceLayerName);
+ Assert(LPerLayer<>nil, '"' + FPersistenceLayerName + '" not registered');
+ if LPerLayer.DatabaseExists(FDatabaseName, FUserName, FPassword)
+ then
+ tiAppMessage('Database <' + FDatabaseName + '> exists.')
+ else
+ tiAppWarning('Database <' + FDatabaseName + '> does not exist.');
+end;
+
+procedure TMainForm.CreateDatabaseClicked(Sender: TObject);
+var
+ LPerLayer: TtiPersistenceLayer;
+begin
+ LPerLayer:= GTIOPFManager.PersistenceLayers.FindByPersistenceLayerName(FPersistenceLayerName);
+ Assert(LPerLayer<>nil, '"' + FPersistenceLayerName + '" not registered');
+ LPerLayer.CreateDatabase(FDatabaseName, FUserName, FPassword);
+ tiAppMessage('Database "' + FDatabaseName + '" has been created.');
+end;
+
+procedure TMainForm.AfterCreate;
+begin
+ {@VFD_BODY_BEGIN: MainForm}
+ Name := 'MainForm';
+ SetPosition(312, 189, 359, 182);
+ WindowTitle := 'Demo 04 - Create Database';
+ WindowPosition := wpScreenCenter;
+
+ btnPickDB := TfpgButton.Create(self);
+ with btnPickDB do
+ begin
+ Name := 'btnPickDB';
+ SetPosition(108, 20, 144, 24);
+ Text := 'Pick Database';
+ AllowAllUp := False;
+ Embedded := False;
+ Flat := False;
+ FontDesc := '#Label1';
+ GroupIndex := 0;
+ Hint := '';
+ ImageLayout := ilImageLeft;
+ ImageMargin := 3;
+ ImageName := '';
+ ImageSpacing := -1;
+ ModalResult := 0;
+ ParentShowHint := True;
+ ShowImage := True;
+ TabOrder := 0;
+ OnClick := @PickDBClicked;
+ end;
+
+ btnCreateDB := TfpgButton.Create(self);
+ with btnCreateDB do
+ begin
+ Name := 'btnCreateDB';
+ SetPosition(108, 96, 136, 24);
+ Text := 'Create Database';
+ AllowAllUp := False;
+ Embedded := False;
+ Flat := False;
+ FontDesc := '#Label1';
+ GroupIndex := 0;
+ Hint := '';
+ ImageLayout := ilImageLeft;
+ ImageMargin := 3;
+ ImageName := '';
+ ImageSpacing := -1;
+ ModalResult := 0;
+ ParentShowHint := True;
+ ShowImage := True;
+ TabOrder := 1;
+ OnClick := @CreateDatabaseClicked;
+ end;
+
+ btnDBExists := TfpgButton.Create(self);
+ with btnDBExists do
+ begin
+ Name := 'btnDBExists';
+ SetPosition(108, 128, 136, 24);
+ Text := 'Database Exists';
+ AllowAllUp := False;
+ Embedded := False;
+ Flat := False;
+ FontDesc := '#Label1';
+ GroupIndex := 0;
+ Hint := '';
+ ImageLayout := ilImageLeft;
+ ImageMargin := 3;
+ ImageName := '';
+ ImageSpacing := -1;
+ ModalResult := 0;
+ ParentShowHint := True;
+ ShowImage := True;
+ TabOrder := 2;
+ OnClick := @DatabaseExistsClicked;
+ end;
+
+ pnlDBName := TfpgPanel.Create(self);
+ with pnlDBName do
+ begin
+ Name := 'pnlDBName';
+ SetPosition(12, 56, 336, 32);
+ Anchors := [anLeft,anRight,anTop];
+ ParentShowHint := True;
+ Style := bsLowered;
+ Text := '---';
+ end;
+
+ {@VFD_BODY_END: MainForm}
+end;
+
+
+end.
diff --git a/extras/tiopf/tiOPFfpGUI.lpk b/extras/tiopf/tiOPFfpGUI.lpk
index 074f3a39..1ed2634c 100644
--- a/extras/tiopf/tiOPFfpGUI.lpk
+++ b/extras/tiopf/tiOPFfpGUI.lpk
@@ -16,8 +16,8 @@
</SyntaxOptions>
</Parsing>
<Other>
- <CustomOptions Value="-dLINK_CSVx
--dLINK_TABx
+ <CustomOptions Value="-dLINK_CSV
+-dLINK_TAB
-dLINK_FBLx
-dLINK_SQLDB_IB
-dLINK_SQLDB_PQx
generated by cgit v1.2.3-70-g09d2 (git 2.47.1) at 2024-12-29 10:47:23 +0000