File: DbTest.pas

package info (click to toggle)
lazarus 2.0.0%2Bdfsg-2
  • links: PTS, VCS
  • area: main
  • in suites: buster
  • size: 214,460 kB
  • sloc: pascal: 1,862,622; xml: 265,709; cpp: 56,595; sh: 3,008; java: 609; makefile: 535; perl: 297; sql: 222; ansic: 137
file content (94 lines) | stat: -rw-r--r-- 1,880 bytes parent folder | download | duplicates (10)
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
{
 *****************************************************************************
  See the file COPYING.modifiedLGPL.txt, included in this distribution,
  for details about the license.
 *****************************************************************************

  Authors: Alexander Klenin

}

unit DbTest;

{$mode objfpc}{$H+}

interface

uses
  Classes, DB, MemDS, FPCUnit, TestRegistry, TADbSource;

type

  TDbSourceTest = class(TTestCase)
  strict private
    FMem: TMemDataset;
    FDS: TDataSource;
    FSource: TDbChartSource;

    procedure AddRecord(AId: Integer; AX, AY: Double; AText: String);
  protected
    procedure SetUp; override;
    procedure TearDown; override;
  published
    procedure Basic;
    procedure Fields;
  end;

implementation

uses
  SysUtils;

{ TDbSourceTest }

procedure TDbSourceTest.AddRecord(AId: Integer; AX, AY: Double; AText: String);
begin
  FMem.AppendRecord([AId, AX, AY, AText]);
end;

procedure TDbSourceTest.Basic;
begin
  AddRecord(1, 1.0, 2.0, 'test');
  AssertEquals(1, FSource.Count);
  AssertEquals(2.0, FSource.Item[0]^.Y);
end;

procedure TDbSourceTest.Fields;
begin
  FSource.FieldY := 'X,a b';
  AssertEquals(2, FSource.YCount);
  FSource.FieldY := 'Y';
  AssertEquals(1, FSource.YCount);
end;

procedure TDbSourceTest.SetUp;
begin
  inherited SetUp;
  FMem := TMemDataset.Create(nil);
  FMem.FieldDefs.Add('id', ftInteger);
  FMem.FieldDefs.Add('x', ftFloat);
  FMem.FieldDefs.Add('y', ftFloat);
  FMem.FieldDefs.Add('text', ftString);
  FDS := TDataSource.Create(nil);
  FDs.DataSet := FMem;
  FSource := TDbChartSource.Create(nil);
  FSource.DataSource := FDS;
  FSource.FieldX := 'X';
  FSource.FieldY := 'Y';
  FMem.Open;
end;

procedure TDbSourceTest.TearDown;
begin
  FreeAndNil(FSource);
  FreeAndNil(FDS);
  FreeAndNil(FMem);
  inherited TearDown;
end;

initialization

  RegisterTest(TDbSourceTest);

end.