2require_once(
'./Services/Database/classes/class.ilDBWrapperFactory.php');
3require_once(
'./Services/Database/classes/class.ilDBConstants.php');
55 if (empty(self::$instances[
$client->getId()])) {
59 return self::$instances[
$client->getId()];
82 require_once(
'./setup/classes/class.ilClient.php');
83 require_once(
'./Services/Init/classes/class.ilIniFile.php');
84 require_once(
'./setup/classes/class.ilDBConnections.php');
88 $ilClient->setDbHost($host);
89 $ilClient->setDbName($dbname);
90 $ilClient->setDbUser($username);
92 $ilClient->setDbType(
$type);
93 $ilClient->writeIni();
113 $clientIniFile = $this->client->ini;
133 if (
$DIC->offsetExists(
'ilDB')) {
134 $DIC->offsetUnset(
'ilDB');
146 $this->client->db =
null;
160 if ($tmp == $delim) {
180 $line = trim($this->
getline($fp,
"\n"));
182 if ($line !=
"" && substr($line, 0, 1) !=
"#" && substr($line, 0, 1) !=
"-") {
183 if (substr($line, -1) ==
";") {
185 $q .=
" " . substr($line, 0, -1);
212 $lines = explode(
';', $sql);
213 foreach ($lines as $line) {
214 if (strlen($line) > 0) {
260 include_once(
"./setup/sql/ilDBTemplate.php");
261 setupILIASDatabase();
297 }
catch (PDOException $e) {
298 $connect = ($e->getCode() == 1049);
302 if ($keep_connection && $connect) {
307 $this->client->setError(
'Database can\'t be reached. Please check the credentials and if database exists');
336 $target = array(
'usr_data',
'object_data',
'object_reference' );
350 return ($connectable && !$installed);
An exception for terminatinating execution or to throw for unit testing.
Administrates DB connections in setup.
const TYPE_PDO_MYSQL_MYISAM
const TYPE_PDO_MYSQL_INNODB
Class ilDatabaseException.
static getInstanceForClient(\ilClient $client)
setIlDBInterface($ilDBInterface)
static getInstanceForNewClient($client_name, $dbname, $host='localhost', $username='root', $password='', $type=ilDBConstants::TYPE_PDO_MYSQL_INNODB)
__construct(\ilClient $client)
ilDbSetup constructor.
createDatabase($a_collation)
readDump()
@description legacy version of readdump
static getNewInstanceForClient(\ilClient $client)
isConnectable($keep_connection=false)
setSqlDumpFile($sql_dump_file)
readDumpSmall()
@description legacy version of readdump
execute($stmt, $data=array())
initFromIniFile($tmpClientIniFile=null)
createDatabase($a_name, $a_charset="utf8", $a_collation="")
query($query)
Run a (read-only) Query on the database.
prepareManip($a_query, $a_types=null)
manipulate($query)
Run a (write) Query on the database.
connect($return_false_on_error=false)
$GLOBALS['JPEG_Segment_Names']
Global Variable: XMP_tag_captions.
if(empty($password)) $table