daos

daos is a Databases & SQL skill for AI agents, published by orangehrm in the orangehrm repository on GitHub. Skillspace rates daos F (53/100) and it passed the safety scan; the rating is based on static analysis only.

Reference for writing query/persistence code in OrangeHRM — the plugin-specific `<Name>Dao` classes that extend `OrangeHRM\Core\Dao\BaseDao`, the `EntityManagerHelperTrait` and its 13 methods, the QueryBuilder patterns the codebase uses heavily (joins via relation aliases, `$q->expr()->orX/andX/like/concat/in/isNull`, conditional joins), `Paginator` for accurate counts on joined queries, `QueryBuilderWrapper` for returning a buildable QB to callers, the `FilterParams` flow from API down through `setSortingAndPaginationParams`, the `SubunitIdChainTrait` for subunit-tree filters, transaction management via `beginTransaction`/`commitTransaction`/`rollBackTransaction`, and `find` / `findOneBy` / `findBy` for simple equality lookups. Use whenever the user is writing a new DAO method, debugging a query, paginating a list, deciding whether to use `findBy` vs QueryBuilder, wrapping a multi-table write in a transaction, or asking "how do I run raw SQL" (answer: usually you don't, the codebase…

Grade

F

Quality

53 / 100

Safety

Passed

GitHub stars

1,135

Unproven: rated by static analysis only, not yet compared head-to-head.

This rating describes the version of the repository we crawled; it may have changed since, so go by its current files.

Skillspace indexes and rates this skill; it does not host or endorse it. Run third-party skills at your own risk.