PHPackages esports/database - 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. esports/database ActiveLibrary[Database & ORM](/categories/database) esports/database ================ Nette Database Component v2.3.4(10y ago)45841[1 issues](https://github.com/simara-esports/database/issues)BSD-3-ClausePHPPHP >=5.3.1 Since Apr 2Pushed 8y ago4 watchersCompare [ Source](https://github.com/simara-esports/database)[ Packagist](https://packagist.org/packages/esports/database)[ Docs](http://nette.org)[ RSS](/packages/esports-database/feed)WikiDiscussions master Synced 2mo ago READMEChangelogDependencies (5)Versions (18)Used By (0) Nette/Esports Database ====================== [](#netteesports-database) @see [nette/database](https://github.com/nette/database) Rozšíření API Podmínka v LEFT JOIN -------------------- [](#podmínka-v-left-join) Podmínka je připojena k LEFT JOIN klauzuli `...->left()` ``` $selection = $context->table('book') ->left(':product_price.active', 1) ->select('book.*, :product_price.value'); ``` ``` SELECT book.*, product_price.value FROM book LEFT JOIN product_price ON book.id = product_price.book_id AND (product_price.active = 1) ``` --- ``` $selection = $context->table('book') ->left(':product_price.active', 1) ->where(':book_tag.tag.name LIKE', 'PHP') ->left(':product_price.value > ?', 0) ->left(':book_tag.tag_id IS NOT NULL') ->select('book.*, :product_price.value'); ``` ``` SELECT book.*, product_price.value FROM book LEFT JOIN book_tag ON book.id = book_tag.book_id AND (book_tag.tag_id IS NOT NULL) LEFT JOIN tag ON book_tag.tag_id = tag.id LEFT JOIN product_price ON book.id = product_price.book_id AND (product_price.active = 1 AND product_price.value > 0) WHERE (tag.name LIKE "PHP") ``` --- Podmínky lze libovolně míchat, jenom je třeba mít na paměti, že bude podmínka připojena k LEFT JOIN klauzuli podle prvního sloupečku v podmínce (obvykle je uveden jenom jeden, takže netřeba řešit). ``` $selection = $context->table('book') ->left(':product_price.active', 1) ->left(':book_tag.tag_id IS NOT NULL OR :product_price.active IS NOT NULL') // bude pripojeno k book_tag ->select('book.*, :product_price.value'); ``` ``` SELECT book.*, product_price.value FROM book LEFT JOIN product_price ON book.id = product_price.book_id AND (product_price.active = 1) LEFT JOIN book_tag ON book.id = book_tag.book_id AND (book_tag.tag_id IS NOT NULL OR product_price.active IS NOT NULL) ``` Aliasování ---------- [](#aliasování) `...->alias()` ``` $selection = $context ->table('book') ->alias(':product_price', 'pp') ->left('pp.active', 1) ->select('book.*, pp.value'); ``` ``` SELECT book.*, pp.value FROM book LEFT JOIN product_price AS pp ON book.id = pp.book_id AND (pp.active = 1) ``` --- ``` $selection = $context->table('book') ->alias(':product_price', 'pp') ->left('pp.active', 1) ->alias(':book_tag.tag', 't') ->where('t.name LIKE', 'PHP') ->left('pp.value > ?', 0) ->left(':book_tag.tag_id IS NOT NULL') ->select('book.*, pp.value'); ``` ``` SELECT book.*, pp.value FROM book LEFT JOIN book_tag ON book.id = book_tag.book_id AND (book_tag.tag_id IS NOT NULL) LEFT JOIN tag AS t ON book_tag.tag_id = t.id LEFT JOIN product_price AS pp ON book.id = pp.book_id AND (pp.active = 1 AND pp.value > 0) WHERE (t.name LIKE "PHP") ``` --- LEFT JOIN s aliasem, ale vybira se z ne-aliasovane ``` $selection = $context ->table('book') ->alias(':product_price', 'pp') ->left('pp.active', 1) ->select('book.*, :product_price.value');//tricky ``` ``` SELECT book.*, product_price.value FROM book LEFT JOIN product_price AS pp ON book.id = pp.book_id AND (pp.active = 1) LEFT JOIN product_price ON book.id = product_price.book_id ``` Vyřazení řetězce z vyhledávání ------------------------------ [](#vyřazení-řetězce-z-vyhledávání) Stává se, že v subselectu je třeba použít alias tabulky, a s ním pracovat. Klasická Selection se snaží tento alias dohledat, což končí chybou: ``` ...->where('author.id = (SELECT b.author_id FROM book AS b LIMIT 1)'); ``` Řešením je použití vykřičníku před `!b.author_id`, celé to vypadá: ``` $selection = $context->table('author') ->where('author.id = (SELECT !b.author_id FROM book AS b LIMIT 1)'); ``` ``` SELECT * FROM author WHERE (author.id = (SELECT b.author_id FROM book AS b LIMIT 1)) ``` Force index ----------- [](#force-index) Stejně jako v SQL: Zajistí použití požadovaného indexu. `...->forceIndex()` ``` $selection = $context->table('book') ->forceIndex('use_this_index') ->select('book.*'); ``` ``` SELECT book.* FROM book FORCE INDEX (`use_this_index`) ``` ### Health Score 33 — LowBetter than 75% of packages Maintenance15 Infrequent updates — may be unmaintained Popularity18 Limited adoption so far Community23 Small or concentrated contributor base Maturity67 Established project with proven stability Bus Factor2 2 contributors hold 50%+ of commits 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 ~51 days Recently: every ~58 days Total 12 Last Release 3861d ago ### Community Maintainers ![](https://www.gravatar.com/avatar/d9b6ccf28b08e595ce916836e269131f3d0bf17d091a0df722733c897f73b3e5?d=identicon)[Svaťa Šimara](/maintainers/Sva%C5%A5a%20%C5%A0imara) --- Top Contributors [![dg](https://avatars.githubusercontent.com/u/194960?v=4)](https://github.com/dg "dg (389 commits)")[![hrach](https://avatars.githubusercontent.com/u/284263?v=4)](https://github.com/hrach "hrach (270 commits)")[![simara-esports](https://avatars.githubusercontent.com/u/2042493?v=4)](https://github.com/simara-esports "simara-esports (37 commits)")[![milo](https://avatars.githubusercontent.com/u/439140?v=4)](https://github.com/milo "milo (35 commits)")[![pt24](https://avatars.githubusercontent.com/u/6972192?v=4)](https://github.com/pt24 "pt24 (11 commits)")[![insekticid](https://avatars.githubusercontent.com/u/177340?v=4)](https://github.com/insekticid "insekticid (8 commits)")[![norbe](https://avatars.githubusercontent.com/u/194486?v=4)](https://github.com/norbe "norbe (7 commits)")[![vrana](https://avatars.githubusercontent.com/u/117453?v=4)](https://github.com/vrana "vrana (7 commits)")[![enumag](https://avatars.githubusercontent.com/u/539462?v=4)](https://github.com/enumag "enumag (6 commits)")[![mishak87](https://avatars.githubusercontent.com/u/276500?v=4)](https://github.com/mishak87 "mishak87 (4 commits)")[![fabik](https://avatars.githubusercontent.com/u/816866?v=4)](https://github.com/fabik "fabik (4 commits)")[![matej21](https://avatars.githubusercontent.com/u/1276059?v=4)](https://github.com/matej21 "matej21 (3 commits)")[![paranoiq](https://avatars.githubusercontent.com/u/146912?v=4)](https://github.com/paranoiq "paranoiq (3 commits)")[![juzna](https://avatars.githubusercontent.com/u/227416?v=4)](https://github.com/juzna "juzna (3 commits)")[![hranicka](https://avatars.githubusercontent.com/u/3034538?v=4)](https://github.com/hranicka "hranicka (2 commits)")[![fprochazka](https://avatars.githubusercontent.com/u/158625?v=4)](https://github.com/fprochazka "fprochazka (2 commits)")[![detrandix](https://avatars.githubusercontent.com/u/659848?v=4)](https://github.com/detrandix "detrandix (2 commits)")[![tomaswindsor](https://avatars.githubusercontent.com/u/614249?v=4)](https://github.com/tomaswindsor "tomaswindsor (2 commits)")[![xpavp03](https://avatars.githubusercontent.com/u/853656?v=4)](https://github.com/xpavp03 "xpavp03 (1 commits)")[![dimkalinux](https://avatars.githubusercontent.com/u/30550?v=4)](https://github.com/dimkalinux "dimkalinux (1 commits)") ### Embed Badge ![Health badge](/badges/esports-database/health.svg) ``` [![Health](https://phpackages.com/badges/esports-database/health.svg)](https://phpackages.com/packages/esports-database) ``` ### Alternatives [nette/caching ⏱ Nette Caching: library with easy-to-use API and many cache backends. 43518.6M368](/packages/nette-caching)[nette/database 💾 Nette Database: layer with a familiar PDO-like API but much more powerful. Building queries, advanced joins, drivers for MySQL, PostgreSQL, SQLite, MS SQL Server and Oracle. 5656.7M234](/packages/nette-database)[ssch/typo3-rector Instant fixes for your TYPO3 PHP code by using Rector. 2592.8M263](/packages/ssch-typo3-rector)[nextras/orm Nextras Orm framework 3141.2M42](/packages/nextras-orm)[rector/rector-src Instant Upgrade and Automated Refactoring of any PHP code 134391.5k12](/packages/rector-rector-src)[kdyby/doctrine-cache Doctrine Cache bridge for Nette Framework 101.3M19](/packages/kdyby-doctrine-cache) PHPackages © 2026 [Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)