Changeset View
Changeset View
Standalone View
Standalone View
resources/sql/patches/20130507.releephrqmailkeypop.php
| <?php | <?php | ||||
| echo "Populating Releeph requests with mail keys...\n"; | echo pht('Populating Releeph requests with mail keys...')."\n"; | ||||
| $table = new ReleephRequest(); | $table = new ReleephRequest(); | ||||
| $table->openTransaction(); | $table->openTransaction(); | ||||
| // From ponder-mailkey-populate.php... | // From ponder-mailkey-populate.php... | ||||
| foreach (new LiskMigrationIterator($table) as $rq) { | foreach (new LiskMigrationIterator($table) as $rq) { | ||||
| $id = $rq->getID(); | $id = $rq->getID(); | ||||
| echo "RQ{$id}: "; | echo "RQ{$id}: "; | ||||
| if (!$rq->getMailKey()) { | if (!$rq->getMailKey()) { | ||||
| queryfx( | queryfx( | ||||
| $rq->establishConnection('w'), | $rq->establishConnection('w'), | ||||
| 'UPDATE %T SET mailKey = %s WHERE id = %d', | 'UPDATE %T SET mailKey = %s WHERE id = %d', | ||||
| $rq->getTableName(), | $rq->getTableName(), | ||||
| Filesystem::readRandomCharacters(20), | Filesystem::readRandomCharacters(20), | ||||
| $id); | $id); | ||||
| echo "Generated Key\n"; | echo pht('Generated Key')."\n"; | ||||
| } else { | } else { | ||||
| echo "-\n"; | echo "-\n"; | ||||
| } | } | ||||
| } | } | ||||
| $table->saveTransaction(); | $table->saveTransaction(); | ||||
| echo "Done.\n"; | echo pht('Done.')."\n"; | ||||