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
|
<?php
$link = mysql_connect('localhost', 'root', 'lsfks-openslx');
if (!$link) {
die('keine Verbindung möglich: ' . mysql_error());
}
echo 'Verbindung erfolgreich'."\n";
mysql_select_db('pbs');
class unittest{
function insertPerson($i){
$anz = mysql_num_rows(mysql_query("SELECT * FROM pbs_person"))+1;
for($n=$anz;$n<=$anz+$i;$n++){
mysql_query("INSERT INTO pbs_person (name,firstname,registerdate,email,login,password) VALUES ('test$n','test$n',$n,'mail@mail.com','test$n','test$n');");
}
}
function insertGroup($i){
$anz = mysql_num_rows(mysql_query("SELECT * FROM pbs_group"))+1;
for($n=$anz;$n<=$anz+$i;$n++){
mysql_query("INSERT INTO pbs_group (title) VALUES ('testgruppe$n');");
}
}
function linkGroups(){
$r = mysql_query("SELECT * FROM pbs_group");
$anz = mysql_num_rows($r);
while ($d = mysq_fetch_array($r,MYSQL_BOTH)){
$data[] = $d;
}
$startParent = 1;
$startChild = 2
while(count($data)){
mysql_query("INSERT INTO pbs_groupgroups (parentID,groupID) VALUES ($startParent,
}
function startAll(){
$this->clearAll();
$this->insertGroup(5);
$this->linkGroups();
$this->insertPerson(4);
}
function clearAll()
{
mysql_query(" TRUNCATE `pbs_bootiso`;
TRUNCATE `pbs_bootmenu`;
TRUNCATE `pbs_bootmenuentries`;
TRUNCATE `pbs_bootos`;
TRUNCATE `pbs_client`;
TRUNCATE `pbs_config`;
TRUNCATE `pbs_filter`;
TRUNCATE `pbs_filterentries`;
TRUNCATE `pbs_filtertype`;
TRUNCATE `pbs_group`;
TRUNCATE `pbs_groupgroups`;
TRUNCATE `pbs_grouprequest`;
TRUNCATE `pbs_membership`;
TRUNCATE `pbs_membershipfilters`;
TRUNCATE `pbs_person`;
TRUNCATE `pbs_pool`;
TRUNCATE `pbs_poolentries`;
TRUNCATE `pbs_poolfilters`;
TRUNCATE `pbs_right`;
TRUNCATE `pbs_rightroles`;
TRUNCATE `pbs_role`;
TRUNCATE `pbs_session`;");
}
}
$u = new unittest();
$u->startAll();
mysql_close($link);
|