Changeset View
Changeset View
Standalone View
Standalone View
resources/sql/patches/20130820.file-mailkey-populate.php
| Show All 16 Lines | foreach (new LiskRawMigrationIterator($conn_w, 'file') as $row) { | ||||
| $sql[] = qsprintf( | $sql[] = qsprintf( | ||||
| $conn_w, | $conn_w, | ||||
| '(%d, %s, 0, 0, 0, 0, 0, 0, 0, 0)', | '(%d, %s, 0, 0, 0, 0, 0, 0, 0, 0)', | ||||
| $row['id'], | $row['id'], | ||||
| Filesystem::readRandomCharacters(20)); | Filesystem::readRandomCharacters(20)); | ||||
| } | } | ||||
| if ($sql) { | if ($sql) { | ||||
| foreach (PhabricatorLiskDAO::chunkSQL($sql, ', ') as $chunk) { | foreach (PhabricatorLiskDAO::chunkSQL($sql) as $chunk) { | ||||
| queryfx( | queryfx( | ||||
| $conn_w, | $conn_w, | ||||
| 'INSERT INTO %T | 'INSERT INTO %T | ||||
| (id, mailKey, phid, byteSize, storageEngine, storageFormat, | (id, mailKey, phid, byteSize, storageEngine, storageFormat, | ||||
| storageHandle, dateCreated, dateModified, metadata) VALUES %Q '. | storageHandle, dateCreated, dateModified, metadata) VALUES %LQ '. | ||||
| 'ON DUPLICATE KEY UPDATE mailKey = VALUES(mailKey)', | 'ON DUPLICATE KEY UPDATE mailKey = VALUES(mailKey)', | ||||
| $table_name, | $table_name, | ||||
| $chunk); | $chunk); | ||||
| } | } | ||||
| } | } | ||||
| $table->saveTransaction(); | $table->saveTransaction(); | ||||
| echo pht('Done.')."\n"; | echo pht('Done.')."\n"; | ||||