Physikerwelt has uploaded a new change for review.
https://gerrit.wikimedia.org/r/252672
Change subject: Fixing broken SQL commands
......................................................................
Fixing broken SQL commands
* The linebreaks were unintentionally added to the SQL statements
Change-Id: I0eb36895061aa3d8ff99b31395038d740f5d43eb
---
M maintenance/ExtractFeatures.php
1 file changed, 10 insertions(+), 10 deletions(-)
git pull ssh://gerrit.wikimedia.org:29418/mediawiki/extensions/MathSearch
refs/changes/72/252672/1
diff --git a/maintenance/ExtractFeatures.php b/maintenance/ExtractFeatures.php
index bea8dab..5f417c5 100644
--- a/maintenance/ExtractFeatures.php
+++ b/maintenance/ExtractFeatures.php
@@ -95,28 +95,28 @@
$n += self::RTI_CHUNK_SIZE;
}
$this->output( "Clear mathvarstat\n" );
- $sql = 'TRUNCATE TABLE `mathvarstat`';
+ $sql = 'DELETE FROM `mathvarstat`';
$this->dbw->query( $sql );
$this->output( "Generate mathvarstat\n" );
// @codingStandardsIgnoreStart
$sql =
- 'INSERT INTO `mathvarstat` (`varstat_featurename` ,
`varstat_featuretype`, `varstat_featurecount`)\n' .
- 'SELECT `mathobservation_featurename` ,
`mathobservation_featuretype` , count( * ) AS CNT\n' .
- 'FROM `mathobservation`\n' .
- 'JOIN mathindex ON `mathobservation_inputhash` =
mathindex_inputhash\n' .
- 'GROUP BY `mathobservation_featurename` ,
`mathobservation_featuretype`\n' .
+ 'INSERT INTO `mathvarstat` (`varstat_featurename` ,
`varstat_featuretype`, `varstat_featurecount`)' .
+ 'SELECT `mathobservation_featurename` ,
`mathobservation_featuretype` , count( * ) AS CNT ' .
+ 'FROM `mathobservation` ' .
+ 'JOIN mathindex ON `mathobservation_inputhash` =
mathindex_inputhash ' .
+ 'GROUP BY `mathobservation_featurename` ,
`mathobservation_featuretype` ' .
'ORDER BY CNT DESC';
// @codingStandardsIgnoreEnd
$this->dbw->query( $sql );
$this->output( "Clear mathrevisionstat\n" );
- $sql = 'TRUNCATE TABLE `mathrevisionstat`';
+ $sql = 'DELETE FROM `mathrevisionstat`';
$this->dbw->query( $sql );
$this->output( "Generate mathrevisionstat\n" );
// @codingStandardsIgnoreStart
$sql =
- 'INSERT INTO
`mathrevisionstat`(`revstat_featureid`,`revstat_revid`,`revstat_featurecount`)\n'
.
- 'SELECT varstat_id, mathindex_revision_id, count(*) AS
CNT FROM `mathobservation` JOIN mathindex ON `mathobservation_inputhash`
=mathindex_inputhash\n' .
- 'JOIN mathvarstat ON varstat_featurename =
`mathobservation_featurename` AND varstat_featuretype =
`mathobservation_featuretype`\n' .
+ 'INSERT INTO
`mathrevisionstat`(`revstat_featureid`,`revstat_revid`,`revstat_featurecount`)
' .
+ 'SELECT varstat_id, mathindex_revision_id, count(*) AS
CNT FROM `mathobservation` JOIN mathindex ON `mathobservation_inputhash`
=mathindex_inputhash ' .
+ 'JOIN mathvarstat ON varstat_featurename =
`mathobservation_featurename` AND varstat_featuretype =
`mathobservation_featuretype` ' .
' GROUP BY `mathobservation_featurename`,
`mathobservation_featuretype`,mathindex_revision_id ORDER BY CNT DESC';
// @codingStandardsIgnoreEnd
$this->dbw->query( $sql );
--
To view, visit https://gerrit.wikimedia.org/r/252672
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I0eb36895061aa3d8ff99b31395038d740f5d43eb
Gerrit-PatchSet: 1
Gerrit-Project: mediawiki/extensions/MathSearch
Gerrit-Branch: master
Gerrit-Owner: Physikerwelt <[email protected]>
_______________________________________________
MediaWiki-commits mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
