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
| ///////////////////////////////////////////////////////////////////////////
// //
// Copyright (c) 2015 by Charta Software B.V. //
// All rights reserved //
// //
// Version: 1.7.0.83525 //
// Web site: https://pascal.chartasoftware.com/ //
// //
// This code and information are provided "as is" without warranty of //
// any kind. Dissemination of this information or reproduction of //
// this material is strictly forbidden unless prior written permission //
// is obtained from Charta Software B.V.. //
// //
///////////////////////////////////////////////////////////////////////////
unit Sql.Database.Connector;
interface
uses
Boolean,
Exception,
Object_.Base,
Sql.Connection.Settings,
Sql.Database,
Text;
type
ESqlDatabaseConnector = class(EException);
TSqlDatabaseConnector = class(TBaseObject)
protected
function GetSettings(): TSqlConnectionSettings; virtual; abstract;
public
function ToText(): TText; override;
function OpenConnection(): TSqlDatabase; virtual; abstract;
procedure CloseConnection(Database: TSqlDatabase); virtual; abstract;
function IsFileBased(): TBoolean; virtual; abstract;
function CanConnect(): TBoolean;
property Settings: TSqlConnectionSettings read GetSettings;
public
class function CreateFor(Settings: TSqlConnectionSettings; Pooling: TBoolean = True): TSqlDatabaseConnector;
end;
function CreateSqlDatabase(Settings: TSqlConnectionSettings): TSqlDatabase;
implementation
uses
Integer._32.TextFormat,
Sql.Database.Connector.Pooling,
Sql.Database.Physical.Mysql,
Sql.Database.Physical.Mysql.Connector,
Sql.Database.Physical.Postgresql,
Sql.Database.Physical.Postgresql.Api,
Sql.Database.Physical.Postgresql.Connector,
Sql.Database.Physical.Sqlite,
Text.Collation;
function CreateSqlDatabase(Settings: TSqlConnectionSettings): TSqlDatabase;
begin
if TTextCollation.DefaultCaseInsensitive.Equal(Settings.System, 'MySQL') then
Result := TMysql.Create(Settings)
else if TTextCollation.DefaultCaseInsensitive.Equal(Settings.System, 'PostgreSQL') then
Result := TPostgresql.Create(PostgresqlDll, Settings)
else if TTextCollation.DefaultCaseInsensitive.Equal(Settings.System, 'SQLite') then
Result := TSqlite.Create(Settings)
else
raise ESqlDatabaseConnector.Create('Unknown database system: ' + Settings.System);
Result := Result.Embellish();
end;
{ TSqlDatabaseConnector }
function TSqlDatabaseConnector.CanConnect(): TBoolean;
var
Database: TSqlDatabase;
begin
try
Database := OpenConnection();
Result := Database <> nil;
if Result then
CloseConnection(Database);
except
Result := False;
end;
end;
class function TSqlDatabaseConnector.CreateFor(Settings: TSqlConnectionSettings; Pooling: TBoolean = True): TSqlDatabaseConnector;
begin
Settings.AddReference();
try
if TTextCollation.DefaultCaseInsensitive.Equal(Settings.System, 'MySQL') then
Result := TMysqlConnector.Create(Settings)
else if TTextCollation.DefaultCaseInsensitive.Equal(Settings.System, 'PostgreSQL') then
Result := TPostgresqlConnector.Create(Settings)
else if TTextCollation.DefaultCaseInsensitive.Equal(Settings.System, 'SQLite') then
Result := TSqliteConnector.Create(Settings)
else
begin
Result := nil;
raise EException.Create('Unknown database system: ' + Settings.System);
end;
if Pooling then
Result := TPoolingSqlDatabaseConnector.Create(Result);
finally
Settings.ReleaseReference();
end;
end;
function TSqlDatabaseConnector.ToText(): TText;
begin
Result := Settings.UserName + '@' + Settings.Server + ':' + Integer32ToText(Settings.Port) + '/' + Settings.DatabaseName;
end;
end.
|