protected function loadPage() { $table = new LegalpadDocumentSignature(); $conn_r = $table->establishConnection('r'); $data = queryfx_all($conn_r, 'SELECT * FROM %T %Q %Q %Q', $table->getTableName(), $this->buildWhereClause($conn_r), $this->buildOrderClause($conn_r), $this->buildLimitClause($conn_r)); $signatures = $table->loadAllFromArray($data); return $signatures; }
<?php $table = new LegalpadDocumentSignature(); $conn_w = $table->establishConnection('w'); foreach (new LiskMigrationIterator($table) as $signature) { echo pht("Updating Legalpad signature %d...\n", $signature->getID()); $data = $signature->getSignatureData(); queryfx($conn_w, 'UPDATE %T SET signerName = %s, signerEmail = %s WHERE id = %d', $table->getTableName(), (string) idx($data, 'name'), (string) idx($data, 'email'), $signature->getID()); }
<?php echo "Adding secretkeys to legalpad document signatures.\n"; $table = new LegalpadDocumentSignature(); $conn_w = $table->establishConnection('w'); $iterator = new LiskMigrationIterator($table); foreach ($iterator as $sig) { $id = $sig->getID(); echo "Populating signature {$id}...\n"; if (!$sig->getSecretKey()) { queryfx($conn_w, 'UPDATE %T SET secretKey = %s WHERE id = %d', $table->getTableName(), Filesystem::readRandomCharacters(20), $id); } } echo "Done.\n";