ILIAS  release_5-4 Revision v5.4.26-12-gabc799a52e6
Public Member Functions
ilDatabaseCommonTestMockData Class Reference

Class ilDatabaseCommonTestMockData. More...

+ Inheritance diagram for ilDatabaseCommonTestMockData:
+ Collaboration diagram for ilDatabaseCommonTestMockData:

Public Member Functions

 getNow ()
 
 getLike ()
 
 getLocate ()
 
 getConcat ($allow_null=true)
 
 getDBFields ()
 
 getInputArray ($update_mob_id=false, $blob_null=true, $with_clob=true)
 
 getInputArrayForTransaction ()
 
 getInsertQuery ($table_name)
 
 getTableCreateSQL ($tablename, $engine)
 
 getTableCreateSQLAfterRename ($tablename, $engine, $supports_fulltext)
 
 getTableCreateSQLAfterAlter ($tablename, $engine, $supports_fulltext)
 

Detailed Description

Class ilDatabaseCommonTestMockData.

Author
Fabian Schmid fs@st.nosp@m.uder.nosp@m.-raim.nosp@m.ann..nosp@m.ch

Definition at line 8 of file class.ilDatabaseCommonTestMockData.php.

Member Function Documentation

◆ getConcat()

ilDatabaseCommonTestMockData::getConcat (   $allow_null = true)
Returns
string

Definition at line 41 of file class.ilDatabaseCommonTestMockData.php.

42  {
43  if ($allow_null) {
44  return " CONCAT(COALESCE(o,''),COALESCE(t,''),COALESCE(t,'')) ";
45  } else {
46  return " CONCAT(o,t,t) ";
47  }
48  }

◆ getDBFields()

ilDatabaseCommonTestMockData::getDBFields ( )
Returns
array

Definition at line 54 of file class.ilDatabaseCommonTestMockData.php.

55  {
56  $fields = array(
57  'id' => array(
58  'type' => 'integer',
59  'length' => 4,
60  'notnull' => true,
61  ),
62  'is_online' => array(
63  'type' => 'integer',
64  'length' => 1,
65  'notnull' => false,
66  ),
67  'is_default' => array(
68  'type' => 'integer',
69  'length' => 1,
70  'notnull' => false,
71  'default' => 1,
72  ),
73  'latitude' => array(
74  'type' => 'float',
75  ),
76  'longitude' => array(
77  'type' => 'float',
78  ),
79  'elevation' => array(
80  'type' => 'float',
81  ),
82  'address' => array(
83  'type' => 'text',
84  'length' => 256,
85  'notnull' => false,
86  ),
87  'init_mob_id' => array(
88  'type' => 'integer',
89  'length' => 4,
90  'notnull' => false,
91  ),
92  'comment_mob_id' => array(
93  'type' => 'integer',
94  'length' => 4,
95  ),
96  'container_id' => array(
97  'type' => 'integer',
98  'length' => 4,
99  ),
100  'big_data' => array(
101  'type' => 'clob',
102  ),
103  );
104 
105  return $fields;
106  }

◆ getInputArray()

ilDatabaseCommonTestMockData::getInputArray (   $update_mob_id = false,
  $blob_null = true,
  $with_clob = true 
)
Parameters
bool$update_mob_id
bool$blob_null
Returns
array

Definition at line 114 of file class.ilDatabaseCommonTestMockData.php.

115  {
116  $fields = array(
117  'id' => array(
118  'integer',
119  56,
120  ),
121  'is_online' => array(
122  'integer',
123  true,
124  ),
125  'is_default' => array(
126  'integer',
127  false,
128  ),
129  'latitude' => array(
130  'float',
131  47.059830,
132  ),
133  'longitude' => array(
134  'float',
135  7.624028,
136  ),
137  'elevation' => array(
138  'float',
139  2.56,
140  ),
141  'address' => array(
142  'text',
143  'Farbweg 9, 3400 Burgdorf',
144  ),
145  'init_mob_id' => array(
146  'integer',
147  $update_mob_id ? $update_mob_id : 78,
148  ),
149  'comment_mob_id' => array(
150  'integer',
151  69,
152  ),
153  'container_id' => array(
154  'integer',
155  456,
156  ),
157  );
158  if ($with_clob) {
159  $fields['big_data'] = array(
160  'clob',
161  $blob_null ? null : 'Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet. Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut labore et dolore magna aliquyam erat, sed diam voluptua. At vero eos et accusam et justo duo dolores et ea rebum. Stet clita kasd gubergren, no sea takimata sanctus est Lorem ipsum dolor sit amet.',
162  );
163  }
164 
165  return $fields;
166  }

◆ getInputArrayForTransaction()

ilDatabaseCommonTestMockData::getInputArrayForTransaction ( )
Returns
array

Definition at line 172 of file class.ilDatabaseCommonTestMockData.php.

References getInsertQuery().

173  {
174  $fields = array(
175  'id' => array(
176  'integer',
177  123456,
178  ),
179  'is_online' => array(
180  'integer',
181  true,
182  ),
183  'is_default' => array(
184  'integer',
185  false,
186  ),
187  );
188 
189  return $fields;
190  }
+ Here is the call graph for this function:

◆ getInsertQuery()

ilDatabaseCommonTestMockData::getInsertQuery (   $table_name)
abstract
Parameters
$table_name
Returns
string

Referenced by getInputArrayForTransaction().

+ Here is the caller graph for this function:

◆ getLike()

ilDatabaseCommonTestMockData::getLike ( )
Returns
string

Definition at line 23 of file class.ilDatabaseCommonTestMockData.php.

24  {
25  return " UPPER(column) LIKE(UPPER('22'))";
26  }

◆ getLocate()

ilDatabaseCommonTestMockData::getLocate ( )
Returns
string

Definition at line 32 of file class.ilDatabaseCommonTestMockData.php.

33  {
34  return " LOCATE( needle,mystring,5) ";
35  }

◆ getNow()

ilDatabaseCommonTestMockData::getNow ( )
Returns
string

Definition at line 14 of file class.ilDatabaseCommonTestMockData.php.

15  {
16  return "NOW()";
17  }

◆ getTableCreateSQL()

ilDatabaseCommonTestMockData::getTableCreateSQL (   $tablename,
  $engine 
)
Returns
mixed

Definition at line 203 of file class.ilDatabaseCommonTestMockData.php.

204  {
205  return "CREATE TABLE `" . $tablename . "` (
206  `id` int(11) NOT NULL,
207  `is_online` tinyint(4) DEFAULT NULL,
208  `is_default` tinyint(4) DEFAULT '1',
209  `latitude` double DEFAULT NULL,
210  `longitude` double DEFAULT NULL,
211  `elevation` double DEFAULT NULL,
212  `address` varchar(256) DEFAULT NULL,
213  `init_mob_id` int(11) DEFAULT NULL,
214  `comment_mob_id` int(11) DEFAULT NULL,
215  `container_id` int(11) DEFAULT NULL,
216  `big_data` longtext,
217  PRIMARY KEY (`id`)) ENGINE=$engine DEFAULT CHARSET=utf8";
218  }

◆ getTableCreateSQLAfterAlter()

ilDatabaseCommonTestMockData::getTableCreateSQLAfterAlter (   $tablename,
  $engine,
  $supports_fulltext 
)
Returns
mixed

Definition at line 250 of file class.ilDatabaseCommonTestMockData.php.

251  {
252  $add_idex = '';
253  if ($supports_fulltext) {
254  $add_idex = ", FULLTEXT KEY `i2_idx` (`address`)";
255  }
256 
257  return "CREATE TABLE `" . $tablename . "` (
258  `id` int(11) NOT NULL,
259  `is_online` tinyint(4) DEFAULT NULL,
260  `is_default` tinyint(4) DEFAULT '1',
261  `latitude` double DEFAULT NULL,
262  `longitude` double DEFAULT NULL,
263  `elevation` double DEFAULT NULL,
264  `address` varchar(256) DEFAULT NULL,
265  `init_mob_id` int(11) DEFAULT NULL,
266  `comment_mob_id_altered` varchar(250) DEFAULT NULL,
267  `container_id` int(11) DEFAULT NULL,
268  `big_data` longtext,
269  PRIMARY KEY (`id`), KEY `i1_idx` (`init_mob_id`)$add_idex) ENGINE=$engine DEFAULT CHARSET=utf8";
270  }

◆ getTableCreateSQLAfterRename()

ilDatabaseCommonTestMockData::getTableCreateSQLAfterRename (   $tablename,
  $engine,
  $supports_fulltext 
)
Returns
mixed

Definition at line 224 of file class.ilDatabaseCommonTestMockData.php.

225  {
226  $add_idex = '';
227  if ($supports_fulltext) {
228  $add_idex = ", FULLTEXT KEY `i2_idx` (`address`)";
229  }
230 
231  return "CREATE TABLE `" . $tablename . "` (
232  `id` int(11) NOT NULL,
233  `is_online` tinyint(4) DEFAULT NULL,
234  `is_default` tinyint(4) DEFAULT '1',
235  `latitude` double DEFAULT NULL,
236  `longitude` double DEFAULT NULL,
237  `elevation` double DEFAULT NULL,
238  `address` varchar(256) DEFAULT NULL,
239  `init_mob_id` int(11) DEFAULT NULL,
240  `comment_mob_id_altered` int(11) DEFAULT NULL,
241  `container_id` int(11) DEFAULT NULL,
242  `big_data` longtext,
243  PRIMARY KEY (`id`), KEY `i1_idx` (`init_mob_id`)$add_idex) ENGINE=$engine DEFAULT CHARSET=utf8";
244  }
The documentation for this class was generated from the following file: