blob: b1b682d2c932b697d7dc799b4ecca6b7558c6e3e (
plain) (
blame)
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
|
unit TestSQLLite;
{$mode objfpc}{$H+}
interface
uses
Classes, SysUtils, fpcunit, testutils, testregistry, SQLiteTable3, unix;
type
TTest_SqlLite= class(TTestCase)
private
fSQLLite : TSQLiteDatabase;
fFileName : string;
protected
procedure SetUp; override;
procedure TearDown; override;
published
procedure Test_Random_TableExists;
procedure Test_Delete_NonExistant_Table;
procedure Test_TableExists_On_0Length_File;
end;
implementation
procedure TTest_SqlLite.Test_Random_TableExists;
begin
deletefile( fFileName );
fSQLLite := TSQLiteDatabase.Create( fFileName );
// Test if some random table exists
check( not fSQLLite.TableExists( 'testTable'+floattostr(now()) ) , 'Randomly Named Table Should NOT Exists (In an empty database file)' );
end;
procedure TTest_SqlLite.Test_Delete_NonExistant_Table;
var
lSQL : String;
begin
deletefile( fFileName );
fSQLLite := TSQLiteDatabase.Create( fFileName );
try
lSQL := 'DROP TABLE testtable';
fSQLLite.execsql( lSQL );
except
exit;
end;
Fail('SQLLite did not except when trying to delete a non existant table' );
end;
procedure TTest_SqlLite.Test_TableExists_On_0Length_File;
var
lSQL : String;
begin
deletefile( fFileName );
shell('cat /dev/null > '+fFileName);
if not fileexists( fFileName ) then
Fail('0 Length file was not created... oops' );
fSQLLite := TSQLiteDatabase.Create( fFileName );
check( not fSQLLite.TableExists( 'testTable' ) , 'Randomly Named Table Should NOT Exists' );
end;
procedure TTest_SqlLite.SetUp;
begin
fFileName := 'test.db';
// fSQLLite := TSQLiteDatabase.Create( fFileName );
end;
procedure TTest_SqlLite.TearDown;
begin
freeandnil( fSQLLite );
end;
initialization
RegisterTest(TTest_SqlLite);
end.
|
