![]() If you really need to make your own SQL, please read the documentation for tableName() and addQuotes(). They can take care of things like table prefixes and escaping for you under some circumstances. We provide a query() function for raw SQL, but the wrapper functions like select() and insert() must be used instead. In these examples, $pageRow is an row object as in the foreach example above, $pageIds is an array of page IDs, and $pageId is a single page ID. Equivalent of: // $rows = fetchResultSet() // $row = $rows $pageRow = $dbr -> newSelectQueryBuilder () -> select ( ) -> from ( 'page' ) -> orderBy ( 'page_touched', SelectQueryBuilder :: SORT_DESC ) -> caller ( _METHOD_ ) -> fetchRow () // Equivalent of: // $rows = fetchResultSet() // $ids = array_map( fn( $row ) => $row->page_id, $rows ) $pageIds = $dbr -> newSelectQueryBuilder () -> select ( 'page_id' ) -> from ( 'page' ) -> where ( ) -> caller ( _METHOD_ ) -> fetchFieldValues () // Equivalent of: // $rows = fetchResultSet() // $id = $row->page_id $pageId = $dbr -> newSelectQueryBuilder () -> select ( 'page_id' ) -> from ( 'page' ) -> where ( ) -> caller ( _METHOD_ ) -> fetchField () See the Wrapper functions section below for how to interact with IDatabase objects. The distinction between primary and replica is important in a multi-database environment, such as Wikimedia. The function wfGetDB() is being phased out and should not be used in new code.įor getting database connections you can call either getReplicaDatabase() for read queries or getPrimaryDatabase() for write queries and write-informing read queries. Developers must not directly call low-level database functions, such as mysql_query.Įach connection is represented by Wikimedia\Rdbms\IDatabase from which queries can be performed.Ĭonnections can be acquired by calling getPrimaryDatabase() or getReplicaDatabase() (depending on the usecase) on an IConnectionProvider instance, preferably dependency-injected, or obtained from MediaWikiServices via DBLoadBalancerFactory service. MediaWiki uses the Rdbms library as its database abstraction layer. ![]() You will then be prompted for your password $wgDBpassword after which you will see the mysql> prompt. Replacing $wgDBuser and $wgDBname with their LocalSettings.php values. Mysql -u $wgDBuser -p -database = $wgDBname
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |