Page MenuHomePhabricator
Paste P3511

ack-grep wb_entity_per_page extensions/Wikibase
ActivePublic

Authored by daniel on Jul 19 2016, 2:28 PM.
extensions/Wikibase/repo/sql/AddEntityPerPage.sql
4:CREATE TABLE IF NOT EXISTS /*_*/wb_entity_per_page (
11:CREATE UNIQUE INDEX /*i*/wb_epp_entity ON /*_*/wb_entity_per_page (epp_entity_id, epp_entity_type);
12:CREATE UNIQUE INDEX /*i*/wb_epp_page ON /*_*/wb_entity_per_page (epp_page_id);
13:CREATE INDEX /*i*/epp_redirect_target ON /*_*/wb_entity_per_page (epp_redirect_target);
extensions/Wikibase/repo/sql/Wikibase.sql
68:CREATE TABLE IF NOT EXISTS /*_*/wb_entity_per_page (
75:CREATE UNIQUE INDEX /*i*/wb_epp_entity ON /*_*/wb_entity_per_page (epp_entity_id, epp_entity_type);
76:CREATE UNIQUE INDEX /*i*/wb_epp_page ON /*_*/wb_entity_per_page (epp_page_id);
77:CREATE INDEX /*i*/epp_redirect_target ON /*_*/wb_entity_per_page (epp_redirect_target);
extensions/Wikibase/repo/sql/AddEppRedirectTarget.sqlite.sql
1:-- Patch to add the epp_redirect_target to wb_entity_per_page.
6:CREATE TABLE IF NOT EXISTS /*_*/wb_entity_per_page_tmp (
13:INSERT INTO /*_*/wb_entity_per_page_tmp( epp_entity_id, epp_entity_type, epp_page_id )
15: FROM wb_entity_per_page;
17:DROP TABLE /*_*/wb_entity_per_page;
19:ALTER TABLE /*_*/wb_entity_per_page_tmp RENAME TO /*_*/wb_entity_per_page;
21:CREATE UNIQUE INDEX IF NOT EXISTS /*i*/wb_epp_entity ON /*_*/wb_entity_per_page (epp_entity_id, epp_entity_type);
22:CREATE UNIQUE INDEX IF NOT EXISTS /*i*/wb_epp_page ON /*_*/wb_entity_per_page (epp_page_id);
23:CREATE INDEX IF NOT EXISTS /*i*/epp_redirect_target ON /*_*/wb_entity_per_page (epp_redirect_target);
extensions/Wikibase/repo/sql/AddEppRedirectTarget.sql
1:-- Patch to add the epp_redirect_target to wb_entity_per_page.
4:ALTER TABLE /*_*/wb_entity_per_page
8:CREATE INDEX /*i*/epp_redirect_target ON /*_*/wb_entity_per_page (epp_redirect_target);
extensions/Wikibase/repo/tests/phpunit/includes/Store/Sql/EntityPerPageTableTest.php
37: $this->tablesUsed[] = 'wb_entity_per_page';
204: 'wb_entity_per_page',
extensions/Wikibase/repo/tests/phpunit/includes/Store/Sql/PropertyInfoTableBuilderTest.php
62: $dbw->delete( 'wb_entity_per_page', '*' );
extensions/Wikibase/repo/tests/phpunit/includes/Store/Sql/WikiPageEntityStoreTest.php
560: 'wb_entity_per_page',
extensions/Wikibase/repo/tests/phpunit/includes/Store/Sql/EntityPerPageBuilderTest.php
128: $dbw->delete( 'wb_entity_per_page', array( 'epp_page_id > ' . $pageId ) );
171: $eppRows = $dbw->selectField( 'wb_entity_per_page', 'count(*)', array(), __METHOD__ );
182: 'wb_entity_per_page',
246: 'wb_entity_per_page',
extensions/Wikibase/repo/includes/Store/Sql/EntityPerPageBuilder.php
14: * Utility class for rebuilding the wb_entity_per_page table.
121: array( 'page', 'redirect', 'wb_entity_per_page' ),
128: 'wb_entity_per_page' => array( 'LEFT JOIN', 'page_id = epp_page_id' )
extensions/Wikibase/repo/includes/Store/Sql/EntityPerPageTable.php
114: 'wb_entity_per_page',
121: 'wb_entity_per_page',
132: throw new DBError( $dbw, 'Failed to insert a row into wb_entity_per_page, the deadlock retry limit was exceeded.' );
157: // CREATE UNIQUE INDEX /*i*/wb_epp_entity ON /*_*/wb_entity_per_page (epp_entity_id, epp_entity_type);
158: // CREATE UNIQUE INDEX /*i*/wb_epp_page ON /*_*/wb_entity_per_page (epp_page_id);
189: 'wb_entity_per_page',
207: return wfGetDB( DB_MASTER )->delete( 'wb_entity_per_page', '*', __METHOD__ );
243: array( 'wb_entity_per_page', 'wb_terms' ),
299: array( 'wb_entity_per_page', 'wb_items_per_site' ),
341: // index in wikibase.sql: wb_entity_per_page (epp_entity_id, epp_entity_type);
379: 'wb_entity_per_page',
extensions/Wikibase/repo/includes/Store/Sql/DatabaseSchemaUpdater.php
280: * Applies updates to the wb_entity_per_page table.
287: if ( !$db->tableExists( 'wb_entity_per_page' ) ) {
289: 'wb_entity_per_page',
296: 'wb_entity_per_page',
extensions/Wikibase/repo/includes/Store/Sql/PropertyInfoTableBuilder.php
140: $tables = array( 'wb_entity_per_page' );
143: // Find properties in wb_entity_per_page with no corresponding
extensions/Wikibase/lib/tests/phpunit/Store/Sql/SqlEntityInfoBuilderTest.php
35: $this->tablesUsed[] = 'wb_entity_per_page';
92: 'wb_entity_per_page',
extensions/Wikibase/lib/includes/Store/Sql/SqlEntityInfoBuilder.php
144: $this->entityPerPageTable = 'wb_entity_per_page';