require __DIR__ . '/Bootstrap/app.php';
use \App\Db\Database;

// Register in the database

  //Under development


// read from database

$where = 'status=1';
$order = '';
$limit = '';
$lista = (new Database('BANK_TABLE'))->select($where, $order, $limit)->fetchAll(PDO::FETCH_CLASS);
  if (!$lista) {
      echo 'There are no users in the bank';
    } else {
      foreach ($lista as $vaga) {
    }
  }


// Read in free database to mount select

$select = 'SELECT * from BANK_TABLE';
$lista = (new Database())->fullSelect($select)->fetchAll(PDO::FETCH_CLASS);
  if (!$lista) {
     echo 'does not exist';
   } else {
     foreach ($lista as $vaga) {
     }
    echo '<pre>';
    print_r($vaga);
    echo '</pre>';
   }



// Update the database

$data = [
   'nome' => 'Fabio',
   'data_nasc' => '10/07/1981',
   ];
$id = '9';
$update = (new Database('BANK_TABLE'))->update('id = ' . $id, $data);
  if ($update >= 1) {
   echo '<pre>';
   print_r($update);
   echo '</pre>';
  } else {
   echo 'error updating';
  }



// Delete from database

$id = '11';
$delete = (new Database('BANK_TABLE'))->delete('id = ' . $id);
  if ($delete >= 1) {
   echo '<pre>';
   print_r($delete);
   echo '</pre>';
  } else {
   echo 'not deleted';
  }