<?php

namespace Acme\Plugin\Database;

use BerlinDB\Database\Kern\Schema;

class WidgetSchema extends Schema {

	public $columns = array(
		array(
			'name'      => 'id',
			'type'      => 'bigint',
			'length'    => '20',
			'unsigned'  => true,
			'extra'     => 'auto_increment',
			'default'   => false,
			'cache_key' => true,
			'sortable'  => true,
		),
		array(
			'name'       => 'name',
			'type'       => 'varchar',
			'length'     => '200',
			'default'    => '',
			'searchable' => true,
			'sortable'   => true,
		),
		array(
			'name'      => 'status',
			'type'      => 'varchar',
			'length'    => '20',
			'default'   => 'active',
			'cache_key' => true,
			'in'        => true,
			'not_in'    => true,
		),
		array(
			'name'     => 'date_created',
			'type'     => 'datetime',
			'default'  => '',
			'created'  => true,
			'sortable' => true,
		),
	);

	public $indexes = array(
		array(
			'type'    => 'primary',
			'columns' => array( 'id' ),
		),
		array(
			'name'    => 'status',
			'type'    => 'key',
			'columns' => array( 'status' ),
		),
	);
}

<?php

namespace Acme\Plugin\Database;

use BerlinDB\Database\Kern\Table;

class WidgetTable extends Table {

	protected $schema = WidgetSchema::class;

	protected $name = 'acme_widgets';

	protected $version = '202605280';
}

( new WidgetTable() )->install();

<?php

namespace Acme\Plugin\Database;

use BerlinDB\Database\Kern\Row;

class Widget extends Row {

	public $id = 0;

	public $name = '';

	public $status = 'active';

	public $date_created = '';
}

<?php

namespace Acme\Plugin\Database;

use BerlinDB\Database\Kern\Query;

class WidgetQuery extends Query {

	protected $prefix = 'acme';

	protected $table_name = 'widgets';

	protected $table_alias = 'w';

	protected $table_schema = WidgetSchema::class;

	protected $item_name = 'widget';

	protected $item_name_plural = 'widgets';

	protected $item_shape = Widget::class;

	protected $cache_group = 'acme-widgets';
}

$query = new WidgetQuery();

$widget_id = $query->add_item(
	array(
		'name'   => 'Example',
		'status' => 'active',
	)
);

$widget = $query->get_item( $widget_id );

$active_widgets = $query->query(
	array(
		'status__in' => array( 'active', 'pending' ),
		'orderby'    => 'date_created',
		'order'      => 'DESC',
		'number'     => 20,
	)
);

$query->update_item(
	$widget_id,
	array(
		'status' => 'archived',
	)
);

$query->delete_item( $widget_id );