* tiOPF: Created a new Pick Database form for the demos.

* tiOPF: Created a new Demo 04 - CreateDatabase.

5 files changed, 654 insertions, 2 deletions

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