examples/Delphi/dbexprt0.pas

(* ***** BEGIN LICENSE BLOCK *****
 * Version: MPL 1.1
 *
 * The contents of this file are subject to the Mozilla Public License Version
 * 1.1 (the "License"); you may not use this file except in compliance with
 * the License. You may obtain a copy of the License at
 * http://www.mozilla.org/MPL/
 *
 * Software distributed under the License is distributed on an "AS IS" basis,
 * WITHOUT WARRANTY OF ANY KIND, either express or implied. See the License
 * for the specific language governing rights and limitations under the
 * License.
 *
 * The Original Code is TurboPower SysTools
 *
 * The Initial Developer of the Original Code is
 * TurboPower Software
 *
 * Portions created by the Initial Developer are Copyright (C) 1996-2002
 * the Initial Developer. All Rights Reserved.
 *
 * Contributor(s):
 *
 * ***** END LICENSE BLOCK ***** *)

unit dbexprt0;

interface

uses
  Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs, StdCtrls,
  Db, DBTables,

  StTxtDat, StExport;

type
  TForm1 = class(TForm)
    Memo1: TMemo;
    Button2: TButton;
    Button3: TButton;
    Button4: TButton;
    OpenDialog1: TOpenDialog;
    Table1: TTable;
    SaveDialog1: TSaveDialog;
    CheckBox1: TCheckBox;
    Button1: TButton;
    Edit1: TEdit;
    Label1: TLabel;
    procedure Button1Click(Sender: TObject);
    procedure Button2Click(Sender: TObject);
    procedure Button3Click(Sender: TObject);
    procedure Button4Click(Sender: TObject);
  private
    procedure SetCaption(const FN: string);
    { Private declarations }
  public
    CurrentDb : string;
    Exporter : TStDBtoCSVExport;
    SchemaMaker : TStDbSchemaGenerator;
    { Public declarations }
  end;

var
  Form1: TForm1;

implementation

{$R *.DFM}

const
  DefaultCaption = 'Table Export Example';

procedure TForm1.SetCaption(const FN : string);
begin
  if FN = '' then
    Caption := DefaultCaption
  else
    Caption := DefaultCaption + ' - [' + FN + ']';
end;

procedure TForm1.Button2Click(Sender: TObject);
begin
  if OpenDialog1.Execute then begin
    Table1.Close;
    CurrentDb := OpenDialog1.FileName;
    Table1.TableName := CurrentDb;
    Table1.Open;
    SetCaption(CurrentDb);
  end;
end;

procedure TForm1.Button4Click(Sender: TObject);
begin
  CurrentDb := '';
  Table1.Close;
  Table1.TableName := CurrentDb;
  Memo1.Lines.Clear;
  SetCaption(CurrentDb);
end;

procedure TForm1.Button3Click(Sender: TObject);
begin
  Exporter := TStDBtoCSVExport.Create;

  try
    Exporter.DataSet := Table1;
    Exporter.IncludeHeader := CheckBox1.Checked;
    Exporter.FieldDelimiter := StDeEscape(Edit1.Text);

    SaveDialog1.FileName := ChangeFileExt(ExtractFileName(CurrentDb), '.csv');
    SaveDialog1.DefaultExt := 'csv';
    SaveDialog1.Filter := 'CSV Files (*.csv)|*.csv|All Files (*.*)|*.*';
    SaveDialog1.Title := 'Save Table Data';
    if SaveDialog1.Execute then begin
      Exporter.ExportToFile(SaveDialog1.FileName);
      Memo1.Lines.LoadFromFile(SaveDialog1.FileName);
    end;

  finally
    Exporter.Free;
  end;
end;

procedure TForm1.Button1Click(Sender: TObject);
begin
  SchemaMaker := TStDbSchemaGenerator.Create;

  try
    SchemaMaker.FieldDelimiter := StDeEscape(Edit1.Text);

    SchemaMaker.DataSet := Table1;

    SaveDialog1.FileName := ChangeFileExt(ExtractFileName(CurrentDb), '.sch');
    SaveDialog1.DefaultExt := 'sch';
    SaveDialog1.Filter := 'Schema Files (*.sch)|*.sch|All Files (*.*)|*.*';
    SaveDialog1.Title := 'Save Schema';
    if SaveDialog1.Execute then begin
      SchemaMaker.SchemaName := ChangeFileExt(ExtractFileName(SaveDialog1.FileName), '');
      SchemaMaker.ExportToFile(SaveDialog1.FileName);
      Memo1.Lines.LoadFromFile(SaveDialog1.FileName);
    end;

  finally
    SchemaMaker.Free;
  end;
end;

end.
1	torben	2671	(* *** BEGIN LICENSE BLOCK ***
2			* Version: MPL 1.1
3			*
4			* The contents of this file are subject to the Mozilla Public License Version
5			* 1.1 (the "License"); you may not use this file except in compliance with
6			* the License. You may obtain a copy of the License at
7			* http://www.mozilla.org/MPL/
8			*
9			* Software distributed under the License is distributed on an "AS IS" basis,
10			* WITHOUT WARRANTY OF ANY KIND, either express or implied. See the License
11			* for the specific language governing rights and limitations under the
12			* License.
13			*
14			* The Original Code is TurboPower SysTools
15			*
16			* The Initial Developer of the Original Code is
17			* TurboPower Software
18			*
19			* Portions created by the Initial Developer are Copyright (C) 1996-2002
20			* the Initial Developer. All Rights Reserved.
21			*
22			* Contributor(s):
23			*
24			* *** END LICENSE BLOCK *** *)
25
26			unit dbexprt0;
27
28			interface
29
30			uses
31			Windows, Messages, SysUtils, Classes, Graphics, Controls, Forms, Dialogs, StdCtrls,
32			Db, DBTables,
33
34			StTxtDat, StExport;
35
36			type
37			TForm1 = class(TForm)
38			Memo1: TMemo;
39			Button2: TButton;
40			Button3: TButton;
41			Button4: TButton;
42			OpenDialog1: TOpenDialog;
43			Table1: TTable;
44			SaveDialog1: TSaveDialog;
45			CheckBox1: TCheckBox;
46			Button1: TButton;
47			Edit1: TEdit;
48			Label1: TLabel;
49			procedure Button1Click(Sender: TObject);
50			procedure Button2Click(Sender: TObject);
51			procedure Button3Click(Sender: TObject);
52			procedure Button4Click(Sender: TObject);
53			private
54			procedure SetCaption(const FN: string);
55			{ Private declarations }
56			public
57			CurrentDb : string;
58			Exporter : TStDBtoCSVExport;
59			SchemaMaker : TStDbSchemaGenerator;
60			{ Public declarations }
61			end;
62
63			var
64			Form1: TForm1;
65
66			implementation
67
68			{$R *.DFM}
69
70			const
71			DefaultCaption = 'Table Export Example';
72
73			procedure TForm1.SetCaption(const FN : string);
74			begin
75			if FN = '' then
76			Caption := DefaultCaption
77			else
78			Caption := DefaultCaption + ' - [' + FN + ']';
79			end;
80
81			procedure TForm1.Button2Click(Sender: TObject);
82			begin
83			if OpenDialog1.Execute then begin
84			Table1.Close;
85			CurrentDb := OpenDialog1.FileName;
86			Table1.TableName := CurrentDb;
87			Table1.Open;
88			SetCaption(CurrentDb);
89			end;
90			end;
91
92			procedure TForm1.Button4Click(Sender: TObject);
93			begin
94			CurrentDb := '';
95			Table1.Close;
96			Table1.TableName := CurrentDb;
97			Memo1.Lines.Clear;
98			SetCaption(CurrentDb);
99			end;
100
101			procedure TForm1.Button3Click(Sender: TObject);
102			begin
103			Exporter := TStDBtoCSVExport.Create;
104
105			try
106			Exporter.DataSet := Table1;
107			Exporter.IncludeHeader := CheckBox1.Checked;
108			Exporter.FieldDelimiter := StDeEscape(Edit1.Text);
109
110			SaveDialog1.FileName := ChangeFileExt(ExtractFileName(CurrentDb), '.csv');
111			SaveDialog1.DefaultExt := 'csv';
112			SaveDialog1.Filter := 'CSV Files (.csv)\|.csv\|All Files (.)\|.';
113			SaveDialog1.Title := 'Save Table Data';
114			if SaveDialog1.Execute then begin
115			Exporter.ExportToFile(SaveDialog1.FileName);
116			Memo1.Lines.LoadFromFile(SaveDialog1.FileName);
117			end;
118
119			finally
120			Exporter.Free;
121			end;
122			end;
123
124			procedure TForm1.Button1Click(Sender: TObject);
125			begin
126			SchemaMaker := TStDbSchemaGenerator.Create;
127
128			try
129			SchemaMaker.FieldDelimiter := StDeEscape(Edit1.Text);
130
131			SchemaMaker.DataSet := Table1;
132
133			SaveDialog1.FileName := ChangeFileExt(ExtractFileName(CurrentDb), '.sch');
134			SaveDialog1.DefaultExt := 'sch';
135			SaveDialog1.Filter := 'Schema Files (.sch)\|.sch\|All Files (.)\|.';
136			SaveDialog1.Title := 'Save Schema';
137			if SaveDialog1.Execute then begin
138			SchemaMaker.SchemaName := ChangeFileExt(ExtractFileName(SaveDialog1.FileName), '');
139			SchemaMaker.ExportToFile(SaveDialog1.FileName);
140			Memo1.Lines.LoadFromFile(SaveDialog1.FileName);
141			end;
142
143			finally
144			SchemaMaker.Free;
145			end;
146			end;
147
148			end.