c9s

```php schema() { $this->collection('confirmedUsers', function($query) { return $query->equal('confirmed', true); }); } ``` ```php $users = User::repo()->fetchConfirmedUsers(); ```

``` php $this->hasMany('CategorySchema')->by('book_id')->as('categories'); $this->hasMany('categories','CategorySchema') ->by('book_id') ->where()->....; ->orderBy( .... ); $this->hasMany('recent_news','NewsSchema') ->by('category_id') ->where()->....; ->orderBy('created_on', 'DESC'); $this->belongsTo('category', 'CategorySchema') ->by('category_id'); ```

``` php $collection = OrderItemCollection::loadByIds([ 1,2,3,4,5 ]); ```

This is required for partitioning the tables.

## Shard Operations - [x] Allocate Shard - [x] Remove Shard - [x] CloneShard (use mysqldbcopy) - [x] Convert DSN into command string mysqldbcopy --source=user:pass@host:port:socket --destination=user:pass@host:port:socket orig_db:new_db mysqldbcopy --source=root@localhost:/opt/local/var/run/mysql56/mysqld.sock \...

This will be used for calling UUID function in MySQL. - [ ] Remove queryUUID method defined in ShardCollection