<?phpuseDevTheorem\Phaster\{Entities, Prop, QueryOptions}; class Users extends Entities{// Return the table to insert/update/delete/select from.// If not implemented, the class name will be used as the table name.protectedfunctiongetTableName(): string{return'users'} // Return an array which maps properties to writable column names. Returns an// empty array by default, so no properties will be writable if not implemented.protectedfunctiongetMap(): array{return [ 'username' => 'uname', 'firstName' => 'fname', 'lastName' => 'lname', 'isDisabled' => 'disabled', 'role' => [ 'id' => 'role_id', ], ]} // Return a list of `Prop` objects, which map properties to readable columns and/or values,// and enable setting a type to cast the column value to, or defining a virtual property// which depends on other columns. See the Prop constructor for the full list of parameters// that can be set. Returns an empty array by default.protectedfunctiongetSelectProps(): array{return [ newProp('id', col: 'u.user_id'), newProp('username', col: 'u.uname'), newProp('firstName', col: 'u.fname'), newProp('lastName', col: 'u.lname'), newProp('isDisabled', col: 'u.disabled', type: 'bool'), newProp('role.id', col: 'u.role_id'), newProp('role.name', col: 'r.role_name'), ]} // Return a SELECT SQL query (without a WHERE clause) in order to join other tables when// selecting data. If not implemented, mapped columns will be selected from the table// returned by getTableName().protectedfunctiongetBaseQuery(QueryOptions$options): string{return"SELECT {$options->getColumns()} FROM users u INNER JOIN roles r ON r.role_id = u.role_id"} // Set the default column/direction for sorting selected results. If not implemented,// results will be sorted by the id property in ascending order by default.protectedfunctiongetDefaultSort(): array{return ['username' => 'asc']} }

useDevTheorem\PeachySQL\QueryBuilder\SqlParams; // ...protectedfunctiongetBaseSelect(QueryOptions$options): SqlParams{$sql = "WITH num_orders AS ( SELECT user_id, COUNT(*) as orders FROM Orders WHERE category_id = ? GROUP BY user_id ) SELECT {$options->getColumns()} FROM Users u INNER JOIN num_orders n ON n.user_id = u.user_id"; returnnewSqlParams($sql, [321])} // ...

<?phpuseMy\DatabaseFactory; useDevTheorem\Phaster\{Entities, EntitiesFactory}; class MyEntitiesFactory implements EntitiesFactory{publicfunctioncreateEntities($class): Entities{returnnew$class(DatabaseFactory::getDb())} }

<?phpuseDevTheorem\Phaster\RouteHandler; $phaster = newRouteHandler(newMyEntitiesFactory()); $app->get('/users', $phaster->search(Users::class)); $app->get('/users/{id}', $phaster->getById(Users::class)); $app->post('/users', $phaster->insert(Users::class)); $app->put('/users/{id}', $phaster->update(Users::class)); $app->patch('/users/{id}', $phaster->patch(Users::class)); $app->delete('/users/{id}', $phaster->delete(Users::class));