Context Navigation

Back to TestDatabase

TestDatabase: BankAccount.sql

File BankAccount.sql, 27.6 KB (added by sb, 2 years ago)
SQLite dump of a test database for the BankAccount example.

Line
1	BEGIN TRANSACTION;
2	CREATE TABLE run(
3	run_id INTEGER PRIMARY KEY AUTOINCREMENT,
4	timestamp INTEGER,
5	revision INTEGER,
6	information STRING
7	);
8	INSERT INTO "run" VALUES(1,1200464352,1,'');
9	DELETE FROM sqlite_sequence;
10	INSERT INTO "sqlite_sequence" VALUES('run',1);
11	INSERT INTO "sqlite_sequence" VALUES('test',4);
12	INSERT INTO "sqlite_sequence" VALUES('code_file',2);
13	INSERT INTO "sqlite_sequence" VALUES('code_class',3);
14	INSERT INTO "sqlite_sequence" VALUES('code_method',8);
15	INSERT INTO "sqlite_sequence" VALUES('code_line',257);
16	CREATE TABLE test(
17	run_id INTEGER,
18	test_id INTEGER PRIMARY KEY AUTOINCREMENT,
19	test_name TEXT,
20	test_result INTEGER DEFAULT 0,
21	test_message TEXT DEFAULT "",
22	test_execution_time REAL DEFAULT 0,
23	code_method_id INTEGER,
24	node_root INTEGER,
25	node_left INTEGER,
26	node_right INTEGER,
27	node_is_leaf INTEGER DEFAULT 0
28	);
29	INSERT INTO "test" VALUES(1,1,'BankAccountTest',0,'',0.00549,NULL,1,1,8,0);
30	INSERT INTO "test" VALUES(1,2,'testBalanceIsInitiallyZero',0,'',0.001817,2,1,2,3,1);
31	INSERT INTO "test" VALUES(1,3,'testBalanceCannotBecomeNegative',0,'',0.001996,3,1,4,5,1);
32	INSERT INTO "test" VALUES(1,4,'testBalanceCannotBecomeNegative2',0,'',0.001677,4,1,6,7,1);
33	CREATE TABLE code_file(
34	code_file_id INTEGER PRIMARY KEY AUTOINCREMENT,
35	code_file_name TEXT,
36	code_file_md5 TEXT,
37	revision INTEGER
38	);
39	INSERT INTO "code_file" VALUES(1,'BankAccountTest.php','c04eaeb760116e7623b7d457aeafc4c6',1);
40	INSERT INTO "code_file" VALUES(2,'BankAccount.php','02e07f8b5849900c0835a5d0a3e76b4f',1);
41	CREATE TABLE code_function(
42	code_file_id INTEGER,
43	code_function_id INTEGER PRIMARY KEY AUTOINCREMENT,
44	code_function_name TEXT,
45	code_function_start_line INTEGER,
46	code_function_end_line INTEGER
47	);
48	CREATE TABLE code_class(
49	code_file_id INTEGER,
50	code_class_id INTEGER PRIMARY KEY AUTOINCREMENT,
51	code_class_parent_id INTEGER,
52	code_class_name TEXT,
53	code_class_start_line INTEGER,
54	code_class_end_line INTEGER
55	);
56	INSERT INTO "code_class" VALUES(1,1,NULL,'BankAccountTest',62,130);
57	INSERT INTO "code_class" VALUES(2,2,NULL,'BankAccountException',47,47);
58	INSERT INTO "code_class" VALUES(2,3,NULL,'BankAccount',61,125);
59	CREATE TABLE code_method(
60	code_class_id INTEGER,
61	code_method_id INTEGER PRIMARY KEY AUTOINCREMENT,
62	code_method_name TEXT,
63	code_method_start_line INTEGER,
64	code_method_end_line INTEGER
65	);
66	INSERT INTO "code_method" VALUES(1,1,'setUp',66,69);
67	INSERT INTO "code_method" VALUES(1,2,'testBalanceIsInitiallyZero',74,77);
68	INSERT INTO "code_method" VALUES(1,3,'testBalanceCannotBecomeNegative',82,95);
69	INSERT INTO "code_method" VALUES(1,4,'testBalanceCannotBecomeNegative2',100,113);
70	INSERT INTO "code_method" VALUES(3,5,'getBalance',77,80);
71	INSERT INTO "code_method" VALUES(3,6,'setBalance',89,96);
72	INSERT INTO "code_method" VALUES(3,7,'depositMoney',105,110);
73	INSERT INTO "code_method" VALUES(3,8,'withdrawMoney',119,124);
74	CREATE TABLE code_line(
75	code_file_id INTEGER,
76	code_line_id INTEGER PRIMARY KEY AUTOINCREMENT,
77	code_line_number INTEGER,
78	code_line TEXT,
79	code_line_covered INTEGER
80	);
81	INSERT INTO "code_line" VALUES(1,1,1,'<?php
82	',0);
83	INSERT INTO "code_line" VALUES(1,2,2,'/**
84	',0);
85	INSERT INTO "code_line" VALUES(1,3,3,' * PHPUnit
86	',0);
87	INSERT INTO "code_line" VALUES(1,4,4,' *
88	',0);
89	INSERT INTO "code_line" VALUES(1,5,5,' * Copyright (c) 2002-2008, Sebastian Bergmann <sb@sebastian-bergmann.de>.
90	',0);
91	INSERT INTO "code_line" VALUES(1,6,6,' * All rights reserved.
92	',0);
93	INSERT INTO "code_line" VALUES(1,7,7,' *
94	',0);
95	INSERT INTO "code_line" VALUES(1,8,8,' * Redistribution and use in source and binary forms, with or without
96	',0);
97	INSERT INTO "code_line" VALUES(1,9,9,' * modification, are permitted provided that the following conditions
98	',0);
99	INSERT INTO "code_line" VALUES(1,10,10,' * are met:
100	',0);
101	INSERT INTO "code_line" VALUES(1,11,11,' *
102	',0);
103	INSERT INTO "code_line" VALUES(1,12,12,' * * Redistributions of source code must retain the above copyright
104	',0);
105	INSERT INTO "code_line" VALUES(1,13,13,' * notice, this list of conditions and the following disclaimer.
106	',0);
107	INSERT INTO "code_line" VALUES(1,14,14,' *
108	',0);
109	INSERT INTO "code_line" VALUES(1,15,15,' * * Redistributions in binary form must reproduce the above copyright
110	',0);
111	INSERT INTO "code_line" VALUES(1,16,16,' * notice, this list of conditions and the following disclaimer in
112	',0);
113	INSERT INTO "code_line" VALUES(1,17,17,' * the documentation and/or other materials provided with the
114	',0);
115	INSERT INTO "code_line" VALUES(1,18,18,' * distribution.
116	',0);
117	INSERT INTO "code_line" VALUES(1,19,19,' *
118	',0);
119	INSERT INTO "code_line" VALUES(1,20,20,' * * Neither the name of Sebastian Bergmann nor the names of his
120	',0);
121	INSERT INTO "code_line" VALUES(1,21,21,' * contributors may be used to endorse or promote products derived
122	',0);
123	INSERT INTO "code_line" VALUES(1,22,22,' * from this software without specific prior written permission.
124	',0);
125	INSERT INTO "code_line" VALUES(1,23,23,' *
126	',0);
127	INSERT INTO "code_line" VALUES(1,24,24,' * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
128	',0);
129	INSERT INTO "code_line" VALUES(1,25,25,' * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
130	',0);
131	INSERT INTO "code_line" VALUES(1,26,26,' * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS
132	',0);
133	INSERT INTO "code_line" VALUES(1,27,27,' * FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE
134	',0);
135	INSERT INTO "code_line" VALUES(1,28,28,' * COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT,
136	',0);
137	INSERT INTO "code_line" VALUES(1,29,29,' * INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING,
138	',0);
139	INSERT INTO "code_line" VALUES(1,30,30,' * BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
140	',0);
141	INSERT INTO "code_line" VALUES(1,31,31,' * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER
142	',0);
143	INSERT INTO "code_line" VALUES(1,32,32,' * CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT
144	',0);
145	INSERT INTO "code_line" VALUES(1,33,33,' * LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN
146	',0);
147	INSERT INTO "code_line" VALUES(1,34,34,' * ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
148	',0);
149	INSERT INTO "code_line" VALUES(1,35,35,' * POSSIBILITY OF SUCH DAMAGE.
150	',0);
151	INSERT INTO "code_line" VALUES(1,36,36,' *
152	',0);
153	INSERT INTO "code_line" VALUES(1,37,37,' * @category Testing
154	',0);
155	INSERT INTO "code_line" VALUES(1,38,38,' * @package PHPUnit
156	',0);
157	INSERT INTO "code_line" VALUES(1,39,39,' * @author Sebastian Bergmann <sb@sebastian-bergmann.de>
158	',0);
159	INSERT INTO "code_line" VALUES(1,40,40,' * @copyright 2002-2008 Sebastian Bergmann <sb@sebastian-bergmann.de>
160	',0);
161	INSERT INTO "code_line" VALUES(1,41,41,' * @license http://www.opensource.org/licenses/bsd-license.php BSD License
162	',0);
163	INSERT INTO "code_line" VALUES(1,42,42,' * @version SVN: $Id: BankAccountTest.php 1984 2007-12-26 18:11:04Z sb $
164	',0);
165	INSERT INTO "code_line" VALUES(1,43,43,' * @link http://www.phpunit.de/
166	',0);
167	INSERT INTO "code_line" VALUES(1,44,44,' * @since File available since Release 2.3.0
168	',0);
169	INSERT INTO "code_line" VALUES(1,45,45,' */
170	',0);
171	INSERT INTO "code_line" VALUES(1,46,46,'
172	',0);
173	INSERT INTO "code_line" VALUES(1,47,47,'require_once ''PHPUnit/Framework/TestCase.php'';
174	',0);
175	INSERT INTO "code_line" VALUES(1,48,48,'require_once ''BankAccount.php'';
176	',0);
177	INSERT INTO "code_line" VALUES(1,49,49,'
178	',0);
179	INSERT INTO "code_line" VALUES(1,50,50,'/**
180	',0);
181	INSERT INTO "code_line" VALUES(1,51,51,' * Tests for the BankAccount class.
182	',0);
183	INSERT INTO "code_line" VALUES(1,52,52,' *
184	',0);
185	INSERT INTO "code_line" VALUES(1,53,53,' * @category Testing
186	',0);
187	INSERT INTO "code_line" VALUES(1,54,54,' * @package PHPUnit
188	',0);
189	INSERT INTO "code_line" VALUES(1,55,55,' * @author Sebastian Bergmann <sb@sebastian-bergmann.de>
190	',0);
191	INSERT INTO "code_line" VALUES(1,56,56,' * @copyright 2002-2008 Sebastian Bergmann <sb@sebastian-bergmann.de>
192	',0);
193	INSERT INTO "code_line" VALUES(1,57,57,' * @license http://www.opensource.org/licenses/bsd-license.php BSD License
194	',0);
195	INSERT INTO "code_line" VALUES(1,58,58,' * @version Release: @package_version@
196	',0);
197	INSERT INTO "code_line" VALUES(1,59,59,' * @link http://www.phpunit.de/
198	',0);
199	INSERT INTO "code_line" VALUES(1,60,60,' * @since Class available since Release 2.3.0
200	',0);
201	INSERT INTO "code_line" VALUES(1,61,61,' */
202	',0);
203	INSERT INTO "code_line" VALUES(1,62,62,'class BankAccountTest extends PHPUnit_Framework_TestCase
204	',0);
205	INSERT INTO "code_line" VALUES(1,63,63,'{
206	',0);
207	INSERT INTO "code_line" VALUES(1,64,64,' protected $ba;
208	',0);
209	INSERT INTO "code_line" VALUES(1,65,65,'
210	',0);
211	INSERT INTO "code_line" VALUES(1,66,66,' protected function setUp()
212	',0);
213	INSERT INTO "code_line" VALUES(1,67,67,' {
214	',0);
215	INSERT INTO "code_line" VALUES(1,68,68,' $this->ba = new BankAccount;
216	',1);
217	INSERT INTO "code_line" VALUES(1,69,69,' }
218	',1);
219	INSERT INTO "code_line" VALUES(1,70,70,'
220	',0);
221	INSERT INTO "code_line" VALUES(1,71,71,' /**
222	',0);
223	INSERT INTO "code_line" VALUES(1,72,72,' * @covers BankAccount::getBalance
224	',0);
225	INSERT INTO "code_line" VALUES(1,73,73,' */
226	',0);
227	INSERT INTO "code_line" VALUES(1,74,74,' public function testBalanceIsInitiallyZero()
228	',0);
229	INSERT INTO "code_line" VALUES(1,75,75,' {
230	',0);
231	INSERT INTO "code_line" VALUES(1,76,76,' $this->assertEquals(0, $this->ba->getBalance());
232	',1);
233	INSERT INTO "code_line" VALUES(1,77,77,' }
234	',1);
235	INSERT INTO "code_line" VALUES(1,78,78,'
236	',0);
237	INSERT INTO "code_line" VALUES(1,79,79,' /**
238	',0);
239	INSERT INTO "code_line" VALUES(1,80,80,' * @covers BankAccount::withdrawMoney
240	',0);
241	INSERT INTO "code_line" VALUES(1,81,81,' */
242	',0);
243	INSERT INTO "code_line" VALUES(1,82,82,' public function testBalanceCannotBecomeNegative()
244	',0);
245	INSERT INTO "code_line" VALUES(1,83,83,' {
246	',0);
247	INSERT INTO "code_line" VALUES(1,84,84,' try {
248	',0);
249	INSERT INTO "code_line" VALUES(1,85,85,' $this->ba->withdrawMoney(1);
250	',1);
251	INSERT INTO "code_line" VALUES(1,86,86,' }
252	',0);
253	INSERT INTO "code_line" VALUES(1,87,87,'
254	',0);
255	INSERT INTO "code_line" VALUES(1,88,88,' catch (BankAccountException $e) {
256	',1);
257	INSERT INTO "code_line" VALUES(1,89,89,' $this->assertEquals(0, $this->ba->getBalance());
258	',1);
259	INSERT INTO "code_line" VALUES(1,90,90,'
260	',0);
261	INSERT INTO "code_line" VALUES(1,91,91,' return;
262	',1);
263	INSERT INTO "code_line" VALUES(1,92,92,' }
264	',0);
265	INSERT INTO "code_line" VALUES(1,93,93,'
266	',0);
267	INSERT INTO "code_line" VALUES(1,94,94,' $this->fail();
268	',1);
269	INSERT INTO "code_line" VALUES(1,95,95,' }
270	',1);
271	INSERT INTO "code_line" VALUES(1,96,96,'
272	',0);
273	INSERT INTO "code_line" VALUES(1,97,97,' /**
274	',0);
275	INSERT INTO "code_line" VALUES(1,98,98,' * @covers BankAccount::depositMoney
276	',0);
277	INSERT INTO "code_line" VALUES(1,99,99,' */
278	',0);
279	INSERT INTO "code_line" VALUES(1,100,100,' public function testBalanceCannotBecomeNegative2()
280	',0);
281	INSERT INTO "code_line" VALUES(1,101,101,' {
282	',0);
283	INSERT INTO "code_line" VALUES(1,102,102,' try {
284	',0);
285	INSERT INTO "code_line" VALUES(1,103,103,' $this->ba->depositMoney(-1);
286	',1);
287	INSERT INTO "code_line" VALUES(1,104,104,' }
288	',0);
289	INSERT INTO "code_line" VALUES(1,105,105,'
290	',0);
291	INSERT INTO "code_line" VALUES(1,106,106,' catch (BankAccountException $e) {
292	',1);
293	INSERT INTO "code_line" VALUES(1,107,107,' $this->assertEquals(0, $this->ba->getBalance());
294	',1);
295	INSERT INTO "code_line" VALUES(1,108,108,'
296	',0);
297	INSERT INTO "code_line" VALUES(1,109,109,' return;
298	',1);
299	INSERT INTO "code_line" VALUES(1,110,110,' }
300	',0);
301	INSERT INTO "code_line" VALUES(1,111,111,'
302	',0);
303	INSERT INTO "code_line" VALUES(1,112,112,' $this->fail();
304	',1);
305	INSERT INTO "code_line" VALUES(1,113,113,' }
306	',1);
307	INSERT INTO "code_line" VALUES(1,114,114,'
308	',0);
309	INSERT INTO "code_line" VALUES(1,115,115,' /**
310	',0);
311	INSERT INTO "code_line" VALUES(1,116,116,' * @covers BankAccount::getBalance
312	',0);
313	INSERT INTO "code_line" VALUES(1,117,117,' * @covers BankAccount::depositMoney
314	',0);
315	INSERT INTO "code_line" VALUES(1,118,118,' * @covers BankAccount::withdrawMoney
316	',0);
317	INSERT INTO "code_line" VALUES(1,119,119,' */
318	',0);
319	INSERT INTO "code_line" VALUES(1,120,120,'/*
320	',0);
321	INSERT INTO "code_line" VALUES(1,121,121,' public function testDepositWithdrawMoney()
322	',0);
323	INSERT INTO "code_line" VALUES(1,122,122,' {
324	',0);
325	INSERT INTO "code_line" VALUES(1,123,123,' $this->assertEquals(0, $this->ba->getBalance());
326	',0);
327	INSERT INTO "code_line" VALUES(1,124,124,' $this->ba->depositMoney(1);
328	',0);
329	INSERT INTO "code_line" VALUES(1,125,125,' $this->assertEquals(1, $this->ba->getBalance());
330	',0);
331	INSERT INTO "code_line" VALUES(1,126,126,' $this->ba->withdrawMoney(1);
332	',0);
333	INSERT INTO "code_line" VALUES(1,127,127,' $this->assertEquals(0, $this->ba->getBalance());
334	',0);
335	INSERT INTO "code_line" VALUES(1,128,128,' }
336	',0);
337	INSERT INTO "code_line" VALUES(1,129,129,'*/
338	',0);
339	INSERT INTO "code_line" VALUES(1,130,130,'}
340	',0);
341	INSERT INTO "code_line" VALUES(1,131,131,'?>
342	',0);
343	INSERT INTO "code_line" VALUES(2,132,1,'<?php
344	',0);
345	INSERT INTO "code_line" VALUES(2,133,2,'/**
346	',0);
347	INSERT INTO "code_line" VALUES(2,134,3,' * PHPUnit
348	',0);
349	INSERT INTO "code_line" VALUES(2,135,4,' *
350	',0);
351	INSERT INTO "code_line" VALUES(2,136,5,' * Copyright (c) 2002-2008, Sebastian Bergmann <sb@sebastian-bergmann.de>.
352	',0);
353	INSERT INTO "code_line" VALUES(2,137,6,' * All rights reserved.
354	',0);
355	INSERT INTO "code_line" VALUES(2,138,7,' *
356	',0);
357	INSERT INTO "code_line" VALUES(2,139,8,' * Redistribution and use in source and binary forms, with or without
358	',0);
359	INSERT INTO "code_line" VALUES(2,140,9,' * modification, are permitted provided that the following conditions
360	',0);
361	INSERT INTO "code_line" VALUES(2,141,10,' * are met:
362	',0);
363	INSERT INTO "code_line" VALUES(2,142,11,' *
364	',0);
365	INSERT INTO "code_line" VALUES(2,143,12,' * * Redistributions of source code must retain the above copyright
366	',0);
367	INSERT INTO "code_line" VALUES(2,144,13,' * notice, this list of conditions and the following disclaimer.
368	',0);
369	INSERT INTO "code_line" VALUES(2,145,14,' *
370	',0);
371	INSERT INTO "code_line" VALUES(2,146,15,' * * Redistributions in binary form must reproduce the above copyright
372	',0);
373	INSERT INTO "code_line" VALUES(2,147,16,' * notice, this list of conditions and the following disclaimer in
374	',0);
375	INSERT INTO "code_line" VALUES(2,148,17,' * the documentation and/or other materials provided with the
376	',0);
377	INSERT INTO "code_line" VALUES(2,149,18,' * distribution.
378	',0);
379	INSERT INTO "code_line" VALUES(2,150,19,' *
380	',0);
381	INSERT INTO "code_line" VALUES(2,151,20,' * * Neither the name of Sebastian Bergmann nor the names of his
382	',0);
383	INSERT INTO "code_line" VALUES(2,152,21,' * contributors may be used to endorse or promote products derived
384	',0);
385	INSERT INTO "code_line" VALUES(2,153,22,' * from this software without specific prior written permission.
386	',0);
387	INSERT INTO "code_line" VALUES(2,154,23,' *
388	',0);
389	INSERT INTO "code_line" VALUES(2,155,24,' * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
390	',0);
391	INSERT INTO "code_line" VALUES(2,156,25,' * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
392	',0);
393	INSERT INTO "code_line" VALUES(2,157,26,' * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS
394	',0);
395	INSERT INTO "code_line" VALUES(2,158,27,' * FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE
396	',0);
397	INSERT INTO "code_line" VALUES(2,159,28,' * COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT,
398	',0);
399	INSERT INTO "code_line" VALUES(2,160,29,' * INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING,
400	',0);
401	INSERT INTO "code_line" VALUES(2,161,30,' * BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES;
402	',0);
403	INSERT INTO "code_line" VALUES(2,162,31,' * LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER
404	',0);
405	INSERT INTO "code_line" VALUES(2,163,32,' * CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT
406	',0);
407	INSERT INTO "code_line" VALUES(2,164,33,' * LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN
408	',0);
409	INSERT INTO "code_line" VALUES(2,165,34,' * ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
410	',0);
411	INSERT INTO "code_line" VALUES(2,166,35,' * POSSIBILITY OF SUCH DAMAGE.
412	',0);
413	INSERT INTO "code_line" VALUES(2,167,36,' *
414	',0);
415	INSERT INTO "code_line" VALUES(2,168,37,' * @category Testing
416	',0);
417	INSERT INTO "code_line" VALUES(2,169,38,' * @package PHPUnit
418	',0);
419	INSERT INTO "code_line" VALUES(2,170,39,' * @author Sebastian Bergmann <sb@sebastian-bergmann.de>
420	',0);
421	INSERT INTO "code_line" VALUES(2,171,40,' * @copyright 2002-2008 Sebastian Bergmann <sb@sebastian-bergmann.de>
422	',0);
423	INSERT INTO "code_line" VALUES(2,172,41,' * @license http://www.opensource.org/licenses/bsd-license.php BSD License
424	',0);
425	INSERT INTO "code_line" VALUES(2,173,42,' * @version SVN: $Id: BankAccount.php 1984 2007-12-26 18:11:04Z sb $
426	',0);
427	INSERT INTO "code_line" VALUES(2,174,43,' * @link http://www.phpunit.de/
428	',0);
429	INSERT INTO "code_line" VALUES(2,175,44,' * @since File available since Release 2.3.0
430	',0);
431	INSERT INTO "code_line" VALUES(2,176,45,' */
432	',0);
433	INSERT INTO "code_line" VALUES(2,177,46,'
434	',0);
435	INSERT INTO "code_line" VALUES(2,178,47,'class BankAccountException extends RuntimeException {}
436	',0);
437	INSERT INTO "code_line" VALUES(2,179,48,'
438	',0);
439	INSERT INTO "code_line" VALUES(2,180,49,'/**
440	',0);
441	INSERT INTO "code_line" VALUES(2,181,50,' * A bank account.
442	',0);
443	INSERT INTO "code_line" VALUES(2,182,51,' *
444	',0);
445	INSERT INTO "code_line" VALUES(2,183,52,' * @category Testing
446	',0);
447	INSERT INTO "code_line" VALUES(2,184,53,' * @package PHPUnit
448	',0);
449	INSERT INTO "code_line" VALUES(2,185,54,' * @author Sebastian Bergmann <sb@sebastian-bergmann.de>
450	',0);
451	INSERT INTO "code_line" VALUES(2,186,55,' * @copyright 2002-2008 Sebastian Bergmann <sb@sebastian-bergmann.de>
452	',0);
453	INSERT INTO "code_line" VALUES(2,187,56,' * @license http://www.opensource.org/licenses/bsd-license.php BSD License
454	',0);
455	INSERT INTO "code_line" VALUES(2,188,57,' * @version Release: @package_version@
456	',0);
457	INSERT INTO "code_line" VALUES(2,189,58,' * @link http://www.phpunit.de/
458	',0);
459	INSERT INTO "code_line" VALUES(2,190,59,' * @since Class available since Release 2.3.0
460	',0);
461	INSERT INTO "code_line" VALUES(2,191,60,' */
462	',0);
463	INSERT INTO "code_line" VALUES(2,192,61,'class BankAccount
464	',0);
465	INSERT INTO "code_line" VALUES(2,193,62,'{
466	',0);
467	INSERT INTO "code_line" VALUES(2,194,63,' /**
468	',0);
469	INSERT INTO "code_line" VALUES(2,195,64,' * The bank account''s balance.
470	',0);
471	INSERT INTO "code_line" VALUES(2,196,65,' *
472	',0);
473	INSERT INTO "code_line" VALUES(2,197,66,' * @var float
474	',0);
475	INSERT INTO "code_line" VALUES(2,198,67,' * @access protected
476	',0);
477	INSERT INTO "code_line" VALUES(2,199,68,' */
478	',0);
479	INSERT INTO "code_line" VALUES(2,200,69,' protected $balance = 0;
480	',0);
481	INSERT INTO "code_line" VALUES(2,201,70,'
482	',0);
483	INSERT INTO "code_line" VALUES(2,202,71,' /**
484	',0);
485	INSERT INTO "code_line" VALUES(2,203,72,' * Returns the bank account''s balance.
486	',0);
487	INSERT INTO "code_line" VALUES(2,204,73,' *
488	',0);
489	INSERT INTO "code_line" VALUES(2,205,74,' * @return float
490	',0);
491	INSERT INTO "code_line" VALUES(2,206,75,' * @access public
492	',0);
493	INSERT INTO "code_line" VALUES(2,207,76,' */
494	',0);
495	INSERT INTO "code_line" VALUES(2,208,77,' public function getBalance()
496	',0);
497	INSERT INTO "code_line" VALUES(2,209,78,' {
498	',0);
499	INSERT INTO "code_line" VALUES(2,210,79,' return $this->balance;
500	',1);
501	INSERT INTO "code_line" VALUES(2,211,80,' }
502	',1);
503	INSERT INTO "code_line" VALUES(2,212,81,'
504	',0);
505	INSERT INTO "code_line" VALUES(2,213,82,' /**
506	',0);
507	INSERT INTO "code_line" VALUES(2,214,83,' * Sets the bank account''s balance.
508	',0);
509	INSERT INTO "code_line" VALUES(2,215,84,' *
510	',0);
511	INSERT INTO "code_line" VALUES(2,216,85,' * @param float $balance
512	',0);
513	INSERT INTO "code_line" VALUES(2,217,86,' * @throws BankAccountException
514	',0);
515	INSERT INTO "code_line" VALUES(2,218,87,' * @access protected
516	',0);
517	INSERT INTO "code_line" VALUES(2,219,88,' */
518	',0);
519	INSERT INTO "code_line" VALUES(2,220,89,' protected function setBalance($balance)
520	',0);
521	INSERT INTO "code_line" VALUES(2,221,90,' {
522	',0);
523	INSERT INTO "code_line" VALUES(2,222,91,' if ($balance >= 0) {
524	',1);
525	INSERT INTO "code_line" VALUES(2,223,92,' $this->balance = $balance;
526	',1);
527	INSERT INTO "code_line" VALUES(2,224,93,' } else {
528	',1);
529	INSERT INTO "code_line" VALUES(2,225,94,' throw new BankAccountException;
530	',1);
531	INSERT INTO "code_line" VALUES(2,226,95,' }
532	',0);
533	INSERT INTO "code_line" VALUES(2,227,96,' }
534	',1);
535	INSERT INTO "code_line" VALUES(2,228,97,'
536	',0);
537	INSERT INTO "code_line" VALUES(2,229,98,' /**
538	',0);
539	INSERT INTO "code_line" VALUES(2,230,99,' * Deposits an amount of money to the bank account.
540	',0);
541	INSERT INTO "code_line" VALUES(2,231,100,' *
542	',0);
543	INSERT INTO "code_line" VALUES(2,232,101,' * @param float $balance
544	',0);
545	INSERT INTO "code_line" VALUES(2,233,102,' * @throws BankAccountException
546	',0);
547	INSERT INTO "code_line" VALUES(2,234,103,' * @access public
548	',0);
549	INSERT INTO "code_line" VALUES(2,235,104,' */
550	',0);
551	INSERT INTO "code_line" VALUES(2,236,105,' public function depositMoney($balance)
552	',0);
553	INSERT INTO "code_line" VALUES(2,237,106,' {
554	',0);
555	INSERT INTO "code_line" VALUES(2,238,107,' $this->setBalance($this->getBalance() + $balance);
556	',1);
557	INSERT INTO "code_line" VALUES(2,239,108,'
558	',0);
559	INSERT INTO "code_line" VALUES(2,240,109,' return $this->getBalance();
560	',1);
561	INSERT INTO "code_line" VALUES(2,241,110,' }
562	',1);
563	INSERT INTO "code_line" VALUES(2,242,111,'
564	',0);
565	INSERT INTO "code_line" VALUES(2,243,112,' /**
566	',0);
567	INSERT INTO "code_line" VALUES(2,244,113,' * Withdraws an amount of money from the bank account.
568	',0);
569	INSERT INTO "code_line" VALUES(2,245,114,' *
570	',0);
571	INSERT INTO "code_line" VALUES(2,246,115,' * @param float $balance
572	',0);
573	INSERT INTO "code_line" VALUES(2,247,116,' * @throws BankAccountException
574	',0);
575	INSERT INTO "code_line" VALUES(2,248,117,' * @access public
576	',0);
577	INSERT INTO "code_line" VALUES(2,249,118,' */
578	',0);
579	INSERT INTO "code_line" VALUES(2,250,119,' public function withdrawMoney($balance)
580	',0);
581	INSERT INTO "code_line" VALUES(2,251,120,' {
582	',0);
583	INSERT INTO "code_line" VALUES(2,252,121,' $this->setBalance($this->getBalance() - $balance);
584	',1);
585	INSERT INTO "code_line" VALUES(2,253,122,'
586	',0);
587	INSERT INTO "code_line" VALUES(2,254,123,' return $this->getBalance();
588	',1);
589	INSERT INTO "code_line" VALUES(2,255,124,' }
590	',1);
591	INSERT INTO "code_line" VALUES(2,256,125,'}
592	',0);
593	INSERT INTO "code_line" VALUES(2,257,126,'?>
594	',0);
595	CREATE TABLE code_coverage(
596	test_id INTEGER,
597	code_line_id INTEGER
598	);
599	INSERT INTO "code_coverage" VALUES(2,68);
600	INSERT INTO "code_coverage" VALUES(3,68);
601	INSERT INTO "code_coverage" VALUES(4,68);
602	INSERT INTO "code_coverage" VALUES(2,69);
603	INSERT INTO "code_coverage" VALUES(3,69);
604	INSERT INTO "code_coverage" VALUES(4,69);
605	INSERT INTO "code_coverage" VALUES(2,76);
606	INSERT INTO "code_coverage" VALUES(2,77);
607	INSERT INTO "code_coverage" VALUES(3,85);
608	INSERT INTO "code_coverage" VALUES(3,88);
609	INSERT INTO "code_coverage" VALUES(3,89);
610	INSERT INTO "code_coverage" VALUES(3,91);
611	INSERT INTO "code_coverage" VALUES(4,103);
612	INSERT INTO "code_coverage" VALUES(4,106);
613	INSERT INTO "code_coverage" VALUES(4,107);
614	INSERT INTO "code_coverage" VALUES(4,109);
615	INSERT INTO "code_coverage" VALUES(2,210);
616	INSERT INTO "code_coverage" VALUES(4,238);
617	INSERT INTO "code_coverage" VALUES(3,252);
618	CREATE TABLE metrics_project(
619	run_id INTEGER,
620	metrics_project_cls INTEGER,
621	metrics_project_clsa INTEGER,
622	metrics_project_clsc INTEGER,
623	metrics_project_roots INTEGER,
624	metrics_project_leafs INTEGER,
625	metrics_project_interfs INTEGER,
626	metrics_project_maxdit INTEGER
627	);
628	INSERT INTO "metrics_project" VALUES(1,3,0,3,0,3,0,2);
629	CREATE TABLE metrics_file(
630	run_id INTEGER,
631	code_file_id INTEGER,
632	metrics_file_coverage REAL,
633	metrics_file_loc INTEGER,
634	metrics_file_cloc INTEGER,
635	metrics_file_ncloc INTEGER,
636	metrics_file_loc_executable INTEGER,
637	metrics_file_loc_executed INTEGER
638	);
639	INSERT INTO "metrics_file" VALUES(1,1,100.0,131,80,51,12,12);
640	INSERT INTO "metrics_file" VALUES(1,2,37.5,126,89,37,8,3);
641	CREATE TABLE metrics_function(
642	run_id INTEGER,
643	code_function_id INTEGER,
644	metrics_function_coverage REAL,
645	metrics_function_loc INTEGER,
646	metrics_function_loc_executable INTEGER,
647	metrics_function_loc_executed INTEGER,
648	metrics_function_ccn INTEGER,
649	metrics_function_crap REAL,
650	metrics_function_npath INTEGER
651	);
652	CREATE TABLE metrics_class(
653	run_id INTEGER,
654	code_class_id INTEGER,
655	metrics_class_coverage REAL,
656	metrics_class_loc INTEGER,
657	metrics_class_loc_executable INTEGER,
658	metrics_class_loc_executed INTEGER,
659	metrics_class_aif REAL,
660	metrics_class_ahf REAL,
661	metrics_class_cis INTEGER,
662	metrics_class_csz INTEGER,
663	metrics_class_dit INTEGER,
664	metrics_class_impl INTEGER,
665	metrics_class_mif REAL,
666	metrics_class_mhf REAL,
667	metrics_class_noc INTEGER,
668	metrics_class_pf REAL,
669	metrics_class_vars INTEGER,
670	metrics_class_varsnp INTEGER,
671	metrics_class_varsi INTEGER,
672	metrics_class_wmc INTEGER,
673	metrics_class_wmcnp INTEGER,
674	metrics_class_wmci INTEGER
675	);
676	INSERT INTO "metrics_class" VALUES(1,1,100.0,69,12,12,93.333333,100.0,3,5,2,3,96.396396,17.117117,0,0.925926,1,0,15,6,5,232);
677	INSERT INTO "metrics_class" VALUES(1,2,0.0,1,0,0,100.0,100.0,0,0,2,0,100.0,11.111111,0,0.0,0,0,4,0,0,9);
678	INSERT INTO "metrics_class" VALUES(1,3,37.5,65,8,3,0.0,100.0,3,5,0,0,0.0,25.0,0,0.0,1,0,1,5,3,5);
679	CREATE TABLE metrics_method(
680	run_id INTEGER,
681	code_method_id INTEGER,
682	metrics_method_coverage REAL,
683	metrics_method_loc INTEGER,
684	metrics_method_loc_executable INTEGER,
685	metrics_method_loc_executed INTEGER,
686	metrics_method_ccn INTEGER,
687	metrics_method_crap REAL,
688	metrics_method_npath INTEGER
689	);
690	INSERT INTO "metrics_method" VALUES(1,1,100.0,4,2,2,1,1.0,1);
691	INSERT INTO "metrics_method" VALUES(1,2,100.0,4,2,2,1,1.0,1);
692	INSERT INTO "metrics_method" VALUES(1,3,100.0,14,4,4,2,2.0,2);
693	INSERT INTO "metrics_method" VALUES(1,4,100.0,14,4,4,2,2.0,2);
694	INSERT INTO "metrics_method" VALUES(1,5,100.0,4,1,1,1,1.0,1);
695	INSERT INTO "metrics_method" VALUES(1,6,0.0,8,3,0,2,6.0,2);
696	INSERT INTO "metrics_method" VALUES(1,7,50.0,6,2,1,1,1.125,1);
697	INSERT INTO "metrics_method" VALUES(1,8,50.0,6,2,1,1,1.125,1);
698	CREATE INDEX test_run_id ON test (run_id);
699	CREATE INDEX test_result ON test (test_result);
700	CREATE INDEX test_code_method_id ON test (code_method_id);
701	CREATE INDEX test_node_root ON test (node_root);
702	CREATE INDEX test_node_left ON test (node_left);
703	CREATE INDEX test_node_right ON test (node_right);
704	CREATE INDEX code_file_id ON code_function (code_file_id);
705	CREATE INDEX code_class_id ON code_method (code_class_id);
706	CREATE INDEX code_line_code_file_id ON code_line (code_file_id);
707	CREATE UNIQUE INDEX code_coverage_test_id_code_line_id ON code_coverage (test_id, code_line_id);
708	CREATE INDEX run_id ON metrics_project (run_id);
709	CREATE INDEX code_function_id ON metrics_function (code_function_id);
710	CREATE INDEX code_method_id ON metrics_method (code_method_id);
711	COMMIT;

Download in other formats:

Original Format