Download the PHP package dovstone/mosql without Composer
On this page you can find all versions of the php package dovstone/mosql. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download dovstone/mosql
More information about dovstone/mosql
Files in dovstone/mosql
Package mosql
Short Description MoSQL - A lightweight NoSQL database with SQL backend (MySQL/PostgreSQL/SQLite)
License MIT
Homepage https://github.com/dovstone0911/mynosql
Informations about the package mosql
README.md complet avec Table des Matières pour MoSQL
bash composer require dovstone/mosql json { "collection": "users", "conditions": [...], "projection": [""], "order_by": [], "limit": 10, "offset": 0, "sql": "SELECT FROM users WHERE status = :pstatus... LIMIT 10", "params": {"pstatus...": "active"}, "execution_time_ms": 12.34, "executed_at": "2024-01-01 12:00:00" }
Dovstone\MoSQL ├── MoSQL.php # Point d'entrée principal ├── Query/ │ └── QueryBuilder.php # Constructeur de requêtes ├── Schema/ │ └── SchemaManager.php # Gestion du schéma ├── Document/ │ └── DocumentManager.php # Gestion des documents ├── Cache/ │ ├── ArrayCache.php │ ├── CacheManager.php │ └── SqlFileCacheManager.php ├── Uid/ │ └── UidGenerator.php # Générateur d'UID └── Exception/ ├── DatabaseException.php ├── DocumentNotFoundException.php ├── DuplicateException.php └── InvalidArgumentException.php
📋 Résumé de la Table des Matières
| Section | Contenu |
|---|---|
| Installation | Installation via Composer |
| Démarrage Rapide | Configuration, CRUD, Requêtes |
| Conditions de Base | WHERE, OR, AND, IN, LIKE, BETWEEN, NULL |
| Conditions JSON | JSON_CONTAINS, ANY, ALL, Path |
| Conditions Date/Temps | DATE, MONTH, YEAR, DAY, HOUR, MINUTE |
| Conditions Avancées | Raw SQL, Subqueries, Soft Delete |
| Projection et Tri | SELECT, ORDER BY, GROUP BY, HAVING, Pagination |
| Jointures | JOIN, LEFT JOIN, Complex Join |
| Agrégations | SUM, AVG, MIN, MAX, COUNT |
| Transactions | Manuel et Automatique |
| Cache | Activation, Invalidation |
| Méthodes Utilitaires | UID↔ID, Exists, Pluck, Pairs, Distinct |
| Méthodes Magiques | findBy, findOneBy |
| Apply Criteria | 4 formats de critères |
| Cache des Requêtes | Logs SQL au format JSON |
| Architecture | Structure des classes |
| Exemples Complets | Auth, Reports, API REST |
| Contribution | Comment contribuer |
| Support | Où trouver de l'aide |