easysql/easysql

Work more optimally with SQL for Performance, Security and Readability

v0.0.3 2018-05-15 19:47 UTC

This package is auto-updated.

Last update: 2024-04-26 11:46:03 UTC


README

Work more effectively with SQL for Performance, Security and Code Readability:

  • Exposes Simple API - Takes care of PDO and Prepared Statement management so you don't have to
  • Strongly-Typed returns on SELECT operations, returning instances of Entity Beans
  • Strongly-Typed INSERT operations allowing easy insertion of collections of Entity Beans
  • First-Class support for Master and Slave connections, with transparent dispatching of queries to appropriate connection
  • Optimal management of PDO Connections and Prepared Statements across an execution context
    • Reusable connections are managed via a shared "Execution Context", allowing you to use and reuse as many "Model" Class instances as convenient without constantly opening-up and tearing-down connections.
    • Each connection keeps track of "Prepared Statements" tied to each new "Query String" it sees. Should the same query be invoked via another method or class later within an Execution Context, the previously-generated Prepared Statement tied to that query will be reused.

Test Coverage Scrutinizer Code Quality Code Climate Build Status

Compliance & Standards

More Precisely

  • This is not an ORM library. It assumes you'll be writing your own SQL queries.
  • By leveraging "Entity Beans" for INSERT and SELECT operations, spend less time juggling untyped associative arrays.
  • EasySQLConfig allows you to:

Composer Installation:

https://packagist.org/packages/easysql/easysql

{
    "require": {
        "easysql/easysql": "dev-master"
    }
}

Sample Usage:

Purpose