← Back to branch summary

~ubuntu-branches/debian/sid/pgadmin3/sid

« back to all changes in this revision

Viewing changes to xtra/pgscript/test/pgsTestOperatorNumber.cpp

  • Committer: Bazaar Package Importer
  • Author(s): Gerfried Fuchs
  • Date: 2009-07-30 12:27:16 UTC
  • mfrom: (1.1.6 upstream)
  • Revision ID: james.westby@ubuntu.com-20090730122716-fddbh42on721bbs2
Tags: 1.10.0-1
* New upstream release.
* Adjusted watch file to match release candidates.
* Updated to Standards-Version 3.8.2:
  - Moved to Section: database.
  - Add DEB_BUILD_OPTIONS support for parallel building.
  - Move from findstring to filter suggestion for DEB_BUILD_OPTIONS parsing.
* pgagent got split into its own separate source package by upstream.
* Exclude Docs.vcproj from installation.
* Move doc-base.enus from pgadmin3 to pgadmin3-data package, the files are
  in there too.

Show diffs side-by-side

added added

removed removed

Lines of Context:
xtra/pgscript/test/pgsTestOperatorNumber.cpp
 
1
//////////////////////////////////////////////////////////////////////////
 
2
//
 
3
// pgScript - PostgreSQL Tools
 
4
// RCS-ID:      $Id: pgsTestOperatorNumber.cpp 7758 2009-03-26 20:49:59Z dpage $
 
5
// Copyright (C) 2002 - 2009, The pgAdmin Development Team
 
6
// This software is released under the BSD Licence
 
7
//
 
8
//////////////////////////////////////////////////////////////////////////
 
9
 
 
10
 
 
11
#include "pgsTestSuite.h"
 
12
 
 
13
#include "pgscript/exceptions/pgsException.h"
 
14
#include "pgscript/generators/pgsIntegerGen.h"
 
15
#include "pgscript/generators/pgsStringGen.h"
 
16
#include "pgscript/objects/pgsGenerator.h"
 
17
#include "pgscript/objects/pgsNumber.h"
 
18
#include "pgscript/objects/pgsRecord.h"
 
19
#include "pgscript/objects/pgsString.h"
 
20
 
 
21
void pgsTestSuite::test_operator_number(void)
 
22
{
 
23
        // From a number with a string
 
24
        {
 
25
                // [1] Create variables
 
26
                pgsVariable * var0 = 0;
 
27
                var0 = pnew pgsNumber(wxT("100"));
 
28
                pgsVariable * var1 = 0;
 
29
                var1 = pnew pgsString(wxT("5"));
 
30
                
 
31
                // [2] Addition
 
32
                try
 
33
                {
 
34
                        (*var0 + *var1);
 
35
                        TS_ASSERT(false);
 
36
                }
 
37
                catch (const pgsException &)
 
38
                {
 
39
                        
 
40
                }
 
41
                
 
42
                // [3] Subtraction
 
43
                try
 
44
                {
 
45
                        (*var0 - *var1);
 
46
                        TS_ASSERT(false);
 
47
                }
 
48
                catch (const pgsException &)
 
49
                {
 
50
                        
 
51
                }
 
52
                
 
53
                // [4] Multiplication
 
54
                try
 
55
                {
 
56
                        (*var0 * *var1);
 
57
                        TS_ASSERT(false);
 
58
                }
 
59
                catch (const pgsException &)
 
60
                {
 
61
                        
 
62
                }
 
63
                
 
64
                // [5] Division
 
65
                try
 
66
                {
 
67
                        (*var0 / *var1);
 
68
                        TS_ASSERT(false);
 
69
                }
 
70
                catch (const pgsException &)
 
71
                {
 
72
                        
 
73
                }
 
74
                
 
75
                // [6] Modulo
 
76
                try
 
77
                {
 
78
                        (*var0 % *var1);
 
79
                        TS_ASSERT(false);
 
80
                }
 
81
                catch (const pgsException &)
 
82
                {
 
83
                        
 
84
                }
 
85
                
 
86
                // [9] Equal
 
87
                try
 
88
                {
 
89
                        (*var0 == *var1);
 
90
                        TS_ASSERT(false);
 
91
                }
 
92
                catch (const pgsException &)
 
93
                {
 
94
                        
 
95
                }
 
96
                
 
97
                // [10] Different
 
98
                try
 
99
                {
 
100
                        (*var0 != *var1);
 
101
                        TS_ASSERT(false);
 
102
                }
 
103
                catch (const pgsException &)
 
104
                {
 
105
                        
 
106
                }
 
107
                
 
108
                // [11] Lower
 
109
                try
 
110
                {
 
111
                        (*var0 < *var1);
 
112
                        TS_ASSERT(false);
 
113
                }
 
114
                catch (const pgsException &)
 
115
                {
 
116
                        
 
117
                }
 
118
                
 
119
                // [12] Greater
 
120
                try
 
121
                {
 
122
                        (*var0 > *var1);
 
123
                        TS_ASSERT(false);
 
124
                }
 
125
                catch (const pgsException &)
 
126
                {
 
127
                        
 
128
                }
 
129
                
 
130
                // [13] Lower or equal
 
131
                try
 
132
                {
 
133
                        (*var0 <= *var1);
 
134
                        TS_ASSERT(false);
 
135
                }
 
136
                catch (const pgsException &)
 
137
                {
 
138
                        
 
139
                }
 
140
                
 
141
                // [14] Greater or equal
 
142
                try
 
143
                {
 
144
                        (*var0 >= *var1);
 
145
                        TS_ASSERT(false);
 
146
                }
 
147
                catch (const pgsException &)
 
148
                {
 
149
                        
 
150
                }
 
151
                
 
152
                // [15] Not
 
153
                TS_ASSERT((!(*var0))->value() == wxT("0"));
 
154
                pgsOperand op(pnew pgsNumber(wxT("0")));
 
155
                TS_ASSERT((!(*op))->value() == wxT("1"));
 
156
                
 
157
                // [16] Almost equal
 
158
                try
 
159
                {
 
160
                        (*var0 &= *var1);
 
161
                        TS_ASSERT(false);
 
162
                }
 
163
                catch (const pgsException &)
 
164
                {
 
165
                        
 
166
                }
 
167
                
 
168
                // [17] Is true?
 
169
                TS_ASSERT(var0->pgs_is_true() == true);
 
170
                TS_ASSERT((!(*var0))->pgs_is_true() == false);
 
171
                
 
172
                // [18] Delete variables
 
173
                pdelete(var0);
 
174
                pdelete(var1);
 
175
        }
 
176
        
 
177
        // From a number (integer) with a real number
 
178
        {
 
179
                // [1] Create variables
 
180
                pgsVariable * var0 = 0;
 
181
                var0 = pnew pgsNumber(wxT("100"), pgsInt);
 
182
                pgsVariable * var1 = 0;
 
183
                var1 = pnew pgsNumber(wxT("5"), pgsReal);
 
184
                
 
185
                // [2] Addition
 
186
                TS_ASSERT((*var0 + *var1)->value() == wxT("105"));
 
187
                
 
188
                // [3] Subtraction
 
189
                TS_ASSERT((*var0 - *var1)->value() == wxT("95"));
 
190
                
 
191
                // [4] Multiplication
 
192
                TS_ASSERT((*var0 * *var1)->value() == wxT("500"));
 
193
                
 
194
                // [5] Division
 
195
                TS_ASSERT((*var0 / *var1)->value() == wxT("20"));
 
196
                
 
197
                // [6] Modulo
 
198
                TS_ASSERT((*var0 % *var1)->value() == wxT("0"));
 
199
                
 
200
                // [9] Equal
 
201
                TS_ASSERT((*var0 == *var1)->value() == wxT("0"));
 
202
                
 
203
                // [10] Different
 
204
                TS_ASSERT((*var0 != *var1)->value() == wxT("1"));
 
205
                
 
206
                // [11] Lower
 
207
                TS_ASSERT((*var0 < *var1)->value() == wxT("0"));
 
208
                
 
209
                // [12] Greater
 
210
                TS_ASSERT((*var0 > *var1)->value() == wxT("1"));
 
211
                
 
212
                // [13] Lower or equal
 
213
                TS_ASSERT((*var0 <= *var1)->value() == wxT("0"));
 
214
                
 
215
                // [14] Greater or equal
 
216
                TS_ASSERT((*var0 >= *var1)->value() == wxT("1"));
 
217
                
 
218
                // [15] Not
 
219
                TS_ASSERT((!(*var0))->value() == wxT("0"));
 
220
                
 
221
                // [16] Almost equal
 
222
                TS_ASSERT((*var0 &= *var1)->value() == wxT("0"));
 
223
                
 
224
                // [17] Is true?
 
225
                TS_ASSERT(var0->pgs_is_true() == true);
 
226
                TS_ASSERT((!(*var0))->pgs_is_true() == false);
 
227
                
 
228
                // [18] Delete variables
 
229
                pdelete(var0);
 
230
                pdelete(var1);
 
231
        }
 
232
        
 
233
        // From a number with a record
 
234
        {
 
235
                // [1] Create variables
 
236
                pgsVariable * var0 = 0;
 
237
                var0 = pnew pgsNumber(wxT("100"));
 
238
                pgsRecord * rec = 0;
 
239
                rec = pnew pgsRecord(1);
 
240
                rec->insert(0, 0, pnew pgsString(wxT("5")));
 
241
                pgsVariable * var1 = 0;
 
242
                var1 = rec;
 
243
                
 
244
                // [2] Addition
 
245
                try
 
246
                {
 
247
                        (*var0 + *var1);
 
248
                        TS_ASSERT(false);
 
249
                }
 
250
                catch (const pgsException &)
 
251
                {
 
252
                        
 
253
                }
 
254
                
 
255
                // [3] Subtraction
 
256
                try
 
257
                {
 
258
                        (*var0 - *var1);
 
259
                        TS_ASSERT(false);
 
260
                }
 
261
                catch (const pgsException &)
 
262
                {
 
263
                        
 
264
                }
 
265
                
 
266
                // [4] Multiplication
 
267
                try
 
268
                {
 
269
                        (*var0 * *var1);
 
270
                        TS_ASSERT(false);
 
271
                }
 
272
                catch (const pgsException &)
 
273
                {
 
274
                        
 
275
                }
 
276
                
 
277
                // [5] Division
 
278
                try
 
279
                {
 
280
                        (*var0 / *var1);
 
281
                        TS_ASSERT(false);
 
282
                }
 
283
                catch (const pgsException &)
 
284
                {
 
285
                        
 
286
                }
 
287
                
 
288
                // [6] Modulo
 
289
                try
 
290
                {
 
291
                        (*var0 % *var1);
 
292
                        TS_ASSERT(false);
 
293
                }
 
294
                catch (const pgsException &)
 
295
                {
 
296
                        
 
297
                }
 
298
                
 
299
                // [9] Equal
 
300
                try
 
301
                {
 
302
                        (*var0 == *var1);
 
303
                        TS_ASSERT(false);
 
304
                }
 
305
                catch (const pgsException &)
 
306
                {
 
307
                        
 
308
                }
 
309
                
 
310
                // [10] Different
 
311
                try
 
312
                {
 
313
                        (*var0 != *var1);
 
314
                        TS_ASSERT(false);
 
315
                }
 
316
                catch (const pgsException &)
 
317
                {
 
318
                        
 
319
                }
 
320
                
 
321
                // [11] Lower
 
322
                try
 
323
                {
 
324
                        (*var0 < *var1);
 
325
                        TS_ASSERT(false);
 
326
                }
 
327
                catch (const pgsException &)
 
328
                {
 
329
                        
 
330
                }
 
331
                
 
332
                // [12] Greater
 
333
                try
 
334
                {
 
335
                        (*var0 > *var1);
 
336
                        TS_ASSERT(false);
 
337
                }
 
338
                catch (const pgsException &)
 
339
                {
 
340
                        
 
341
                }
 
342
                
 
343
                // [13] Lower or equal
 
344
                try
 
345
                {
 
346
                        (*var0 <= *var1);
 
347
                        TS_ASSERT(false);
 
348
                }
 
349
                catch (const pgsException &)
 
350
                {
 
351
                        
 
352
                }
 
353
                
 
354
                // [14] Greater or equal
 
355
                try
 
356
                {
 
357
                        (*var0 >= *var1);
 
358
                        TS_ASSERT(false);
 
359
                }
 
360
                catch (const pgsException &)
 
361
                {
 
362
                        
 
363
                }
 
364
                
 
365
                // [15] Not
 
366
                TS_ASSERT((!(*var0))->value() == wxT("0"));
 
367
                
 
368
                // [16] Almost equal
 
369
                try
 
370
                {
 
371
                        (*var0 &= *var1);
 
372
                        TS_ASSERT(false);
 
373
                }
 
374
                catch (const pgsException &)
 
375
                {
 
376
                        
 
377
                }
 
378
                
 
379
                // [17] Is true?
 
380
                TS_ASSERT(var0->pgs_is_true() == true);
 
381
                TS_ASSERT((!(*var0))->pgs_is_true() == false);
 
382
                
 
383
                // [18] Delete variables
 
384
                pdelete(var0);
 
385
                pdelete(var1);
 
386
        }
 
387
        
 
388
        // From a number with a record
 
389
        {
 
390
                // [1] Create variables
 
391
                pgsVariable * var0 = 0;
 
392
                var0 = pnew pgsNumber(wxT("100"));
 
393
                pgsRecord * rec = 0;
 
394
                rec = pnew pgsRecord(1);
 
395
                rec->insert(0, 0, pnew pgsNumber(wxT("5")));
 
396
                rec->insert(1, 0, pnew pgsNumber(wxT("1")));
 
397
                pgsVariable * var1 = 0;
 
398
                var1 = rec;
 
399
                
 
400
                // [2] Addition
 
401
                try
 
402
                {
 
403
                        (*var0 + *var1);
 
404
                        TS_ASSERT(false);
 
405
                }
 
406
                catch (const pgsException &)
 
407
                {
 
408
                        
 
409
                }
 
410
                
 
411
                // [3] Subtraction
 
412
                try
 
413
                {
 
414
                        (*var0 - *var1);
 
415
                        TS_ASSERT(false);
 
416
                }
 
417
                catch (const pgsException &)
 
418
                {
 
419
                        
 
420
                }
 
421
                
 
422
                // [4] Multiplication
 
423
                try
 
424
                {
 
425
                        (*var0 * *var1);
 
426
                        TS_ASSERT(false);
 
427
                }
 
428
                catch (const pgsException &)
 
429
                {
 
430
                        
 
431
                }
 
432
                
 
433
                // [5] Division
 
434
                try
 
435
                {
 
436
                        (*var0 / *var1);
 
437
                        TS_ASSERT(false);
 
438
                }
 
439
                catch (const pgsException &)
 
440
                {
 
441
                        
 
442
                }
 
443
                
 
444
                // [6] Modulo
 
445
                try
 
446
                {
 
447
                        (*var0 % *var1);
 
448
                        TS_ASSERT(false);
 
449
                }
 
450
                catch (const pgsException &)
 
451
                {
 
452
                        
 
453
                }
 
454
                
 
455
                // [9] Equal
 
456
                try
 
457
                {
 
458
                        (*var0 == *var1);
 
459
                        TS_ASSERT(false);
 
460
                }
 
461
                catch (const pgsException &)
 
462
                {
 
463
                        
 
464
                }
 
465
                
 
466
                // [10] Different
 
467
                try
 
468
                {
 
469
                        (*var0 != *var1);
 
470
                        TS_ASSERT(false);
 
471
                }
 
472
                catch (const pgsException &)
 
473
                {
 
474
                        
 
475
                }
 
476
                
 
477
                // [11] Lower
 
478
                try
 
479
                {
 
480
                        (*var0 < *var1);
 
481
                        TS_ASSERT(false);
 
482
                }
 
483
                catch (const pgsException &)
 
484
                {
 
485
                        
 
486
                }
 
487
                
 
488
                // [12] Greater
 
489
                try
 
490
                {
 
491
                        (*var0 > *var1);
 
492
                        TS_ASSERT(false);
 
493
                }
 
494
                catch (const pgsException &)
 
495
                {
 
496
                        
 
497
                }
 
498
                
 
499
                // [13] Lower or equal
 
500
                try
 
501
                {
 
502
                        (*var0 <= *var1);
 
503
                        TS_ASSERT(false);
 
504
                }
 
505
                catch (const pgsException &)
 
506
                {
 
507
                        
 
508
                }
 
509
                
 
510
                // [14] Greater or equal
 
511
                try
 
512
                {
 
513
                        (*var0 >= *var1);
 
514
                        TS_ASSERT(false);
 
515
                }
 
516
                catch (const pgsException &)
 
517
                {
 
518
                        
 
519
                }
 
520
                
 
521
                // [18] Delete variables
 
522
                pdelete(var0);
 
523
                pdelete(var1);
 
524
        }
 
525
        
 
526
        // From a number with a string generator
 
527
        {
 
528
                // [1] Create variables
 
529
                pgsVariable * var0 = 0;
 
530
                var0 = pnew pgsNumber(wxT("100"));
 
531
                pgsStringGen * gen = 0;
 
532
                gen = pnew pgsStringGen(10, 20);
 
533
                pgsVariable * var1 = 0;
 
534
                var1 = pnew pgsGenerator(pgsVariable::pgsTString, gen);
 
535
                
 
536
                // [2] Addition
 
537
                try
 
538
                {
 
539
                        (*var0 + *var1);
 
540
                        TS_ASSERT(false);
 
541
                }
 
542
                catch (const pgsException &)
 
543
                {
 
544
                        
 
545
                }
 
546
                
 
547
                // [3] Subtraction
 
548
                try
 
549
                {
 
550
                        (*var0 - *var1);
 
551
                        TS_ASSERT(false);
 
552
                }
 
553
                catch (const pgsException &)
 
554
                {
 
555
                        
 
556
                }
 
557
                
 
558
                // [4] Multiplication
 
559
                try
 
560
                {
 
561
                        (*var0 * *var1);
 
562
                        TS_ASSERT(false);
 
563
                }
 
564
                catch (const pgsException &)
 
565
                {
 
566
                        
 
567
                }
 
568
                
 
569
                // [5] Division
 
570
                try
 
571
                {
 
572
                        (*var0 / *var1);
 
573
                        TS_ASSERT(false);
 
574
                }
 
575
                catch (const pgsException &)
 
576
                {
 
577
                        
 
578
                }
 
579
                
 
580
                // [6] Modulo
 
581
                try
 
582
                {
 
583
                        (*var0 % *var1);
 
584
                        TS_ASSERT(false);
 
585
                }
 
586
                catch (const pgsException &)
 
587
                {
 
588
                        
 
589
                }
 
590
                
 
591
                // [9] Equal
 
592
                try
 
593
                {
 
594
                        (*var0 == *var1);
 
595
                        TS_ASSERT(false);
 
596
                }
 
597
                catch (const pgsException &)
 
598
                {
 
599
                        
 
600
                }
 
601
                
 
602
                // [10] Different
 
603
                try
 
604
                {
 
605
                        (*var0 != *var1);
 
606
                        TS_ASSERT(false);
 
607
                }
 
608
                catch (const pgsException &)
 
609
                {
 
610
                        
 
611
                }
 
612
                
 
613
                // [11] Lower
 
614
                try
 
615
                {
 
616
                        (*var0 < *var1);
 
617
                        TS_ASSERT(false);
 
618
                }
 
619
                catch (const pgsException &)
 
620
                {
 
621
                        
 
622
                }
 
623
                
 
624
                // [12] Greater
 
625
                try
 
626
                {
 
627
                        (*var0 > *var1);
 
628
                        TS_ASSERT(false);
 
629
                }
 
630
                catch (const pgsException &)
 
631
                {
 
632
                        
 
633
                }
 
634
                
 
635
                // [13] Lower or equal
 
636
                try
 
637
                {
 
638
                        (*var0 <= *var1);
 
639
                        TS_ASSERT(false);
 
640
                }
 
641
                catch (const pgsException &)
 
642
                {
 
643
                        
 
644
                }
 
645
                
 
646
                // [14] Greater or equal
 
647
                try
 
648
                {
 
649
                        (*var0 >= *var1);
 
650
                        TS_ASSERT(false);
 
651
                }
 
652
                catch (const pgsException &)
 
653
                {
 
654
                        
 
655
                }
 
656
                
 
657
                // [18] Delete variables
 
658
                pdelete(var0);
 
659
                pdelete(var1);
 
660
        }
 
661
        
 
662
        // From a number with an integer generator
 
663
        {
 
664
                // [1] Create variables
 
665
                pgsVariable * var0 = 0;
 
666
                var0 = pnew pgsNumber(wxT("100"));
 
667
                pgsIntegerGen * gen = 0;
 
668
                gen = pnew pgsIntegerGen(5, 5);
 
669
                pgsVariable * var1 = 0;
 
670
                var1 = pnew pgsGenerator(pgsVariable::pgsTInt, gen);
 
671
                
 
672
                // [2] Addition
 
673
                TS_ASSERT((*var0 + *var1)->value() == wxT("105"));
 
674
                
 
675
                // [3] Subtraction
 
676
                TS_ASSERT((*var0 - *var1)->value() == wxT("95"));
 
677
                
 
678
                // [4] Multiplication
 
679
                TS_ASSERT((*var0 * *var1)->value() == wxT("500"));
 
680
                
 
681
                // [5] Division
 
682
                TS_ASSERT((*var0 / *var1)->value() == wxT("20"));
 
683
                
 
684
                // [6] Modulo
 
685
                TS_ASSERT((*var0 % *var1)->value() == wxT("0"));
 
686
                
 
687
                // [9] Equal
 
688
                TS_ASSERT((*var0 == *var1)->value() == wxT("0"));
 
689
                
 
690
                // [10] Different
 
691
                TS_ASSERT((*var0 != *var1)->value() == wxT("1"));
 
692
                
 
693
                // [11] Lower
 
694
                TS_ASSERT((*var0 < *var1)->value() == wxT("0"));
 
695
                
 
696
                // [12] Greater
 
697
                TS_ASSERT((*var0 > *var1)->value() == wxT("1"));
 
698
                
 
699
                // [13] Lower or equal
 
700
                TS_ASSERT((*var0 <= *var1)->value() == wxT("0"));
 
701
                
 
702
                // [14] Greater or equal
 
703
                TS_ASSERT((*var0 >= *var1)->value() == wxT("1"));
 
704
                
 
705
                // [15] Not
 
706
                TS_ASSERT((!(*var0))->value() == wxT("0"));
 
707
                
 
708
                // [16] Almost equal
 
709
                TS_ASSERT((*var0 &= *var1)->value() == wxT("0"));
 
710
                
 
711
                // [17] Is true?
 
712
                TS_ASSERT(var0->pgs_is_true() == true);
 
713
                TS_ASSERT((!(*var0))->pgs_is_true() == false);
 
714
                
 
715
                // [18] Delete variables
 
716
                pdelete(var0);
 
717
                pdelete(var1);
 
718
        }
 
719
}