PHPackages                             buyplaytix/databean - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. buyplaytix/databean

ActiveLibrary[Database & ORM](/categories/database)

buyplaytix/databean
===================

DataBean is a simple and testable database access layer for PHP.

0.7.2(6y ago)01.0kApache-2.0PHPPHP >=5.3.2CI failing

Since Nov 4Pushed 6y ago1 watchersCompare

[ Source](https://github.com/tthomas48/databean)[ Packagist](https://packagist.org/packages/buyplaytix/databean)[ RSS](/packages/buyplaytix-databean/feed)WikiDiscussions master Synced 1mo ago

READMEChangelog (10)Dependencies (3)Versions (25)Used By (0)

DataBean
========

[](#databean)

DataBean is a simple and testable database access layer for PHP. It is easy to write tests and create simple beans for accessing and updating the database.

Setup
-----

[](#setup)

Setup is simple

```
\BuyPlayTix\DataBean\DB::init(array(
    "user" => $database_username,
    "pass" => $database_password,
    "name" => $database_name,
    "host" => $database_host,
));
// (optional) pass in a logger that implements IDBLogger
\BuyPlayTix\DataBean\DB::setLogger($logger);

```

Creating a Bean
---------------

[](#creating-a-bean)

A bean maps directly to a table. Setting up a bean is simple:

```
class Message extends \BuyPlayTix\DataBean\DataBean
{
  protected $table = 'MESSAGES';
  protected $pk = 'UID';
}

```

Interacting with a Bean
-----------------------

[](#interacting-with-a-bean)

### Loading a bean

[](#loading-a-bean)

```
// create a new bean
$message = new Message();

// load a bean by primary key
$message = new Message($uid);

// load a bean by a unique key
$message = new Message(array("SUBJECT", $subject));

```

### Loading multiple beans

[](#loading-multiple-beans)

```
// load by a key
$messages = Message::getObjects("OWNER_UID", $owner_uid);

// load by a key with values
$messages = Message::getObjects("OWNER_UID", array($owner_uid1, $owner_uid2, $owner_uid3));

// load by a key with ordering
$messages = Message::getObjects("OWNER_UID", $owner_uid, " ORDER BY INSERT_TIMESTAMP ");

```

### Updating

[](#updating)

```
$message->OWNER_UID = $new_owner_uid;
$message->update();

```

### Deleting

[](#deleting)

```
$message->delete();

```

### Arbitrary SQL

[](#arbitrary-sql)

Why would you want to do this rather than directly running against the database? One word - "testing".

```
// select
$messages = raw_select("MESSAGES", array("UID", "SUBJECT", "BODY"), array("OWNER_UID" => $owner_uid));

// update
raw_update("MESSAGES", array("OWNER_UID" => $new_owner_uid), array("OWNER_UID => $old_owner_uid));

// delete
raw_delete("MESSAGES", array("OWNER_UID => $owner_uid));

// complex query
$results = named_query("MESSAGES_BY_HOUR", "select date_format(INSERT_TIMESTAMP, '%H'), count(*) from MESSAGES group by date_format(INSERT_TIMESTAMP, '%H')");

```

Testing
-------

[](#testing)

### Setting up a Test

[](#setting-up-a-test)

```
\BuyPlayTix\DataBean\DB::setInstance(\BuyPlayTix\DataBean\NullDB::getInstance());
\BuyPlayTix\DataBean\DataBean::setAdapter(new \BuyPlayTix\DataBean\ObjectAdapter());

```

### A Simple Test

[](#a-simple-test)

```
$message = new Message();
$message->SUBJECT = "A Test Message";
$message->update();

assertEquals(1, Message::getObjects("SUBJECT", array("A Test Message"));

```

### A More Complex Test

[](#a-more-complex-test)

Let's say that we want to test the method get\_queries\_by\_hour defined like this on our message databean:

```
function get_queries_by_hour() {
  return named_query("MESSAGES_BY_HOUR", "select date_format(INSERT_TIMESTAMP, '%H'), count(*) from MESSAGES group by date_format(INSERT_TIMESTAMP, '%H')");
}

$adapter = \BuyPlayTix\DataBean\DataBean::getAdapter();
$adapter->set_named_query_value("MESSAGES_BY_HOUR", array(array("1", 200), array("2", 300));
$results = $message->get_queries_by_hour();
assertEquals(2, count($results));

```

###  Health Score

28

—

LowBetter than 54% of packages

Maintenance20

Infrequent updates — may be unmaintained

Popularity14

Limited adoption so far

Community7

Small or concentrated contributor base

Maturity58

Maturing project, gaining track record

 Bus Factor1

Top contributor holds 100% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

###  Release Activity

Cadence

Every ~77 days

Recently: every ~45 days

Total

24

Last Release

2426d ago

### Community

Maintainers

![](https://www.gravatar.com/avatar/8dee2c564064cdce376650c7a5ce4e1fbd3a760e796002144c425de06ad44234?d=identicon)[tthomas48](/maintainers/tthomas48)

---

Top Contributors

[![tthomas48](https://avatars.githubusercontent.com/u/168526?v=4)](https://github.com/tthomas48 "tthomas48 (76 commits)")

###  Code Quality

TestsPHPUnit

### Embed Badge

![Health badge](/badges/buyplaytix-databean/health.svg)

```
[![Health](https://phpackages.com/badges/buyplaytix-databean/health.svg)](https://phpackages.com/packages/buyplaytix-databean)
```

###  Alternatives

[bavix/laravel-wallet

It's easy to work with a virtual wallet.

1.3k1.1M11](/packages/bavix-laravel-wallet)[dyrynda/laravel-model-uuid

This package allows you to easily work with UUIDs in your Laravel models.

4802.8M8](/packages/dyrynda-laravel-model-uuid)[google/cloud-bigquery

BigQuery Client for PHP

8817.2M41](/packages/google-cloud-bigquery)[formal/orm

324.0k1](/packages/formal-orm)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)