/**
* Sets up the property tables.
*
* @since 1.8
* @param array $dbtypes
* @param DatabaseBase|Database $db
* @param SMWSQLStore3SetupHandlers|null $reportTo
*/
protected function setupPropertyTables(array $dbtypes, $db, SMWSQLStore3SetupHandlers $reportTo = null)
{
$addedCustomTypeSignatures = false;
foreach ($this->store->getPropertyTables() as $proptable) {
// Only extensions that aren't setup correctly can force an exception
// and to avoid a failure during setup, ensure that standard tables
// are correctly initialized otherwise SMW can't recover
try {
$diHandler = $this->store->getDataItemHandlerForDIType($proptable->getDiType());
} catch (\Exception $e) {
continue;
}
// Prepare indexes. By default, property-value tables
// have the following indexes:
//
// sp: getPropertyValues(), getSemanticData(), getProperties()
// po: ask, getPropertySubjects()
//
// The "p" component is omitted for tables with fixed property.
$indexes = array();
if ($proptable->usesIdSubject()) {
$fieldarray = array('s_id' => $dbtypes['p'] . ' NOT NULL');
$indexes['sp'] = 's_id';
} else {
$fieldarray = array('s_title' => $dbtypes['t'] . ' NOT NULL', 's_namespace' => $dbtypes['n'] . ' NOT NULL');
$indexes['sp'] = 's_title,s_namespace';
}
$indexes['po'] = $diHandler->getIndexField();
if (!$proptable->isFixedPropertyTable()) {
$fieldarray['p_id'] = $dbtypes['p'] . ' NOT NULL';
$indexes['po'] = 'p_id,' . $indexes['po'];
$indexes['sp'] = $indexes['sp'] . ',p_id';
}
// TODO Special handling; concepts should be handled differently
// in the future. See comments in SMW_DIHandler_Concept.php.
if ($proptable->getDiType() == SMWDataItem::TYPE_CONCEPT) {
unset($indexes['po']);
}
$indexes = array_merge($indexes, $diHandler->getTableIndexes());
$indexes = array_unique($indexes);
foreach ($diHandler->getTableFields() as $fieldname => $typeid) {
// If the type signature is not recognized and the custom signatures have not been added, add them.
if (!$addedCustomTypeSignatures && !array_key_exists($typeid, $dbtypes)) {
wfRunHooks('SMWCustomSQLStoreFieldType', array(&$dbtypes));
$addedCustomTypeSignatures = true;
}
// Only add the type when the signature was recognized, otherwise ignore it silently.
if (array_key_exists($typeid, $dbtypes)) {
$fieldarray[$fieldname] = $dbtypes[$typeid];
}
}
SMWSQLHelpers::setupTable($proptable->getName(), $fieldarray, $db, $reportTo);
SMWSQLHelpers::setupIndex($proptable->getName(), $indexes, $db, $reportTo);
}
}
/**
* Sets up the property tables.
*
* @param array $dbtypes
* @param $db
* @param $reportTo SMWSQLStore2 or null
*/
protected function setupPropertyTables(array $dbtypes, $db, $reportTo)
{
$addedCustomTypeSignatures = false;
foreach (self::getPropertyTables() as $proptable) {
if ($proptable->idsubject) {
$fieldarray = array('s_id' => $dbtypes['p'] . ' NOT NULL');
$indexes = array('s_id');
} else {
$fieldarray = array('s_title' => $dbtypes['t'] . ' NOT NULL', 's_namespace' => $dbtypes['n'] . ' NOT NULL');
$indexes = array('s_title,s_namespace');
}
if (!$proptable->fixedproperty) {
$fieldarray['p_id'] = $dbtypes['p'] . ' NOT NULL';
$indexes[] = 'p_id';
}
foreach ($proptable->objectfields as $fieldname => $typeid) {
// If the type signature is not recognized and the custom signatures have not been added, add them.
if (!$addedCustomTypeSignatures && !array_key_exists($typeid, $dbtypes)) {
wfRunHooks('SMWCustomSQLStoreFieldType', array(&$dbtypes));
$addedCustomTypeSignatures = true;
}
// Only add the type when the signature was recognized, otherwise ignore it silently.
if (array_key_exists($typeid, $dbtypes)) {
$fieldarray[$fieldname] = $dbtypes[$typeid];
}
}
$indexes = array_merge($indexes, $proptable->indexes);
SMWSQLHelpers::setupTable($proptable->name, $fieldarray, $db, $reportTo);
SMWSQLHelpers::setupIndex($proptable->name, $indexes, $db);
}
}
/**
* Create required SQL tables. This function also performs upgrades of table contents
* when required.
*/
protected function setupTables($verbose, $db)
{
$reportTo = $verbose ? $this : null;
// Use $this to report back from static SMWSQLHelpers.
SMWSQLHelpers::setupTable('smwsimple_data', array('pageid' => SMWSQLHelpers::getStandardDBType('id') . ' NOT NULL', 'propname' => SMWSQLHelpers::getStandardDBType('title') . ' NOT NULL', 'value' => SMWSQLHelpers::getStandardDBType('blob') . ' NOT NULL'), $db, $reportTo);
SMWSQLHelpers::setupIndex('smwsimple_data', array('pageid', 'propname', 'propname,value(256)'), $db);
SMWSQLHelpers::setupTable('smwsimple_special', array('pageid' => SMWSQLHelpers::getStandardDBType('id') . ' NOT NULL', 'propname' => SMWSQLHelpers::getStandardDBType('title') . ' NOT NULL', 'value' => SMWSQLHelpers::getStandardDBType('title') . ' NOT NULL'), $db, $reportTo);
SMWSQLHelpers::setupIndex('smwsimple_special', array('pageid', 'pageid,propname', 'propname', 'propname,value'), $db);
$this->reportProgress("Database initialised successfully.\n\n", $verbose);
}