gistfile1.txt

$users = new Collection('users', 'Users', [
  new TextField('name', 'Name'),
  new PasswordField('password', 'Password'),
  new CheckboxField('role', 'Role', ['guest'=>'Guest', 'admin'=>'Admin']),
], ['admin']);

$tags = new Collection('tags', 'Tags', [
  new TextField('label', 'Label'),
  new EntryField('author', 'Author'),
]);

$blogPosts = new Collection('blog-posts', 'Blog Posts', [
  new TextField('title', 'Title'),
  new ImageField('image', 'Image'),
  new RichTextField('content', 'Content'),
  new EntryField('author', 'Author', $users),
  new CollectionField('tags', 'Tags', $tags),
]);

$database = new MysqlDatabase($connectionString);

$collectionBuilder = new CollectionBuilder($database);
$collectionBuilder->applyCollection($users);
$collectionBuilder->applyCollection($tags);
$collectionBuilder->applyCollection($blogPosts);

// dont like
$entryFinder = new EntryFinder($database);
$blogEntriesByAdamSendler = $entryFinder->collection($blogPosts)->find([
  'author' => new DatabaseEq('name', 'Adam Sendler'),
])->all();

// dont like
$blogEntriesByAdamSendlerOrAndyNilson = $entryFinder->collection($blogPosts)->find([
  'author' => new DatabaseOr([DatabaseEq('name', 'Adam Sendler'), DatabaseEq('name', 'Andy Nilson')]),
])->all();

// dont like
$blogEntriesWithTagsStoryAndFilm = $entryFinder->collection($blogPosts)->find([
  'author' => new DatabaseAnd([DatabaseEq('tags.label', 'Story'), DatabaseEq('tags.label', 'Film')]),
])->all();