Example #1
0
         } else {
             echo "migrate fail\n";
             echo $database->thisConnection()->error;
         }
     }
     break;
 case 'insert':
     $query = $database->buildInsertQuery($commandLine->getTable(), $commandLine->parseWithoutEquals(0));
     if ($database->thisConnection()->query($query)) {
         echo "Insert Succeeded.\n";
     } else {
         echo "Insert failed.  Make sure your parameters are correct and you have needed foreign keys available.\n";
     }
     break;
 case 'update':
     $query = $database->buildUpdateQuery($commandLine->getTable(), $commandLine->parseWithEquals(1), $commandLine->parseWithEquals(0, " AND "));
     if ($database->thisConnection()->query($query)) {
         echo "Update Succeeded.\n";
     } else {
         echo "Update failed.  Make sure your parameters are correct and you have needed foreign keys available.\n";
     }
     break;
 case 'delete':
     $query = $database->buildDeleteQuery($commandLine->getTable(), $commandLine->parseWithEquals(0));
     if ($database->thisConnection()->query($query)) {
         echo "Delete Succeeded.\n";
     } else {
         echo "Delete failed.  Make sure your parameters are correct and you have needed foreign keys available.\n";
     }
     break;
 case 'view':