Page MenuHomePhabricator
Paste P3511

ack-grep wb_entity_per_page extensions/Wikibase
ActivePublic
Actions

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';
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL · Credits