[Summary view] [Print] [Text view]

   1  <?php
   2  
   3  $table = new LegalpadDocumentSignature();
   4  $conn_w = $table->establishConnection('w');
   5  foreach (new LiskMigrationIterator($table) as $signature) {
   6    echo pht("Updating Legalpad signature %d...\n", $signature->getID());
   7  
   8    $data = $signature->getSignatureData();
   9  
  10    queryfx(
  11      $conn_w,
  12      'UPDATE %T SET signerName = %s, signerEmail = %s WHERE id = %d',
  13      $table->getTableName(),
  14      (string)idx($data, 'name'),
  15      (string)idx($data, 'email'),
  16      $signature->getID());
  17  }