<?php
// Drupal schema for example objects.
$schema['sdbo_example_objects'] = array(
  'description' => 'SDB Example objects table.',
  'fields' => array(
    'id' => array(
      'description' => 'Object id',
      'type' => 'serial',
      'not null' => TRUE,
      'unsigned' => TRUE),
    'created' => array(
      'description' => 'Timestamp when the object was created',
      'type' => 'int',
      'not null' => TRUE,
      'default' => 0),
    'title' => array(
      'description' => 'Object title',
      'type' => 'varchar',
      'length' => 124,
      'not null' => TRUE,
      'default' => ''),
    'body' => array(
      'description' => 'Object body',
      'type' => 'text',
      'not null' => FALSE),
    ),
  'primary key' => array('id'),
);
/**
 * Example SDBObject.
 */
class SDBExampleObject extends SDBObject {
  // Persisted attributes as defined in the schema.
  // Note that you do not need care about id attribute.
  public $created;
  public $title;
  public $body;
  const TABLE = 'sdbo_example_objects';
  function getTable() {
    return self::TABLE;
  }
}
?>

<?php
$object = SDBFactory::initInstanceOf('SDBExampleChild', $form_state['values']);
$object->save();
?>

<?php
// Load from db.
$object = SDBFactory::loadInstanceOf('SDBExampleChild',
  array('id' => $form_state['values']['id']));
// Set new value for title attribute.
$object->title = $form_state['values']['title'];
// Call save operation - the internal logic will handle updates/inserts.
$object->save();
?>

<?php
// Init object. Make sure $form_state['values'] contains primary key of the
// object that will be updated.
$object = SDBFactory::initInstanceOf('SDBExampleChild', $form_state['values'],
  NULL, TRUE);
// Call save operation - by setting 4th parameter of initInstanceOf to TRUE you
// explicitly tell the object is persisted and therefore SDBO will go for
// update.
$object->save();
?>

<?php
// Load from db.
$object = SDBFactory::loadInstanceOf('SDBExampleChild',
  array('id' => $form_state['values']['id']));
// Call delete operation. This will query database with delete query as well as
// will remove the object from internal cache registry, so the object is no more
// available in the SDBFactory registry.
$object->delete();
?>