DB.md

DB

Introduction

Methods

• fetchOne( $query, $data )

  Selects a single row from the database.

  $row = DB::fetchOne( "SELECT * FROM person WHERE id=?", array( 10 ) );
  $row = DB::fetchOne( "SELECT * FROM person WHERE id=:id AND name=:name", array( "id" => 10, "name" => "John" ) );

  Returns NULL or an object with the properties

• ensureOne( $query, $data )

  Just like fetchOne but does not allow null as return.

  // throws if no rows are found
  $row = DB::ensureOne( "SELECT * FROM person WHERE id=?", array( 10 ) );

  Returns object with the properties

• fetchAll( $query, $data )

  Selects all row from the database that matches the query.

  $rows = DB::fetchAll( "SELECT * FROM person" );
  $rows = DB::fetchAll( "SELECT * FROM person WHERE name=:name", array( "name" => "John" ) );

  Returns An ArrayIterator with the result set

• insertInto( $table, $data )

  Insert the data on the given table

  $id = DB::insertInto( "person", array(
    "name" => "John",
    "age"  => 15,
  ));

  Returns The ID of the inserted element, if applicable

• updateOne( $table, $id, $data = null );

  Ensure only one row is updated

  // Throws if no rows or more than one rows are updated
  DB::updateOne( "TABLE", array("id" =>$id), array( "field" => $value ) );

  Returns nothing

• execute( $query, $data = null )

  Execute a query, normally used for UPDATEs or complex INSERTs

  $result = DB::execute("UPDATE person SET name=:name WHERE id=:id", array( "id" => $id, "name" => $name ) );
  $result->id    // Insert ID
  $result->count // Rows affected

  Returns An object containing id (the id of the insert) and count number of affected rows.

• transaction( callback $callback )

  Start transaction

  $result = DB::transaction ( function () use ($id, $name){
    DB::execute("UPDATE person SET name=:name WHERE id=:id", array( "id" => $id, "name" => $name ) );
    return ...;
  });

  When an exception is thrown, the transaction will rollback. Otherwise, it will autocommit.

  Returns The value returned inside the transaction

• enableDebug()

  Starts a transaction that is never commited. Allows for the script to mock some insertions and rollbacks at the end.