Home

Wye

A library that makes unit testing database-driven code in PHP a breeze. Mock the native PDO class, define query results, and inspect executed statements.

"[In firefighting a] hose appliance used for splitting one line into two discharges. Often a gated wye is used to allow and disallow water flow through the two separate discharges." - https://en.wikipedia.org/wiki/Glossary_of_firefighting_equipment#Wye

Contents

1. Introduction

   • Installation
   • Basic Usage
     • 1. Replace Native PDO
     • 2. Define Query Results
     • 3. Execute Your Queries
     • 4. Inspect Executed Queries
     • 5. Reset Wye

2. Defining Results

   • Creating A Result
   • Attaching A Result
   • Adding Rows To Result
     • As Associative Array
       • Add Single Row
       • Add Multiple Rows
     • As Indexed Array with Defined Columns
       • Add Single Row
       • Add Multiple Rows
   • Set Last-Insert-ID
   • Overrive Row Count

3. Inspecting Execution Info

   • Get Number Of Queries Executed
   • Get All Executed Queries
   • Get Single Executed Query
   • Inspect An Executed Query
     • Get The SQL Statement
     • Get Parameter Bindings

4. Inspecting Bindings

   • BindingCollection Object
     • Array Behavior
     • Has-Parameter
     • Has-Value
     • Has-Value-Like
     • Has-Data-Type
     • Filter-By-Parameter
     • Filter-By-Value
     • Filter-By-Value-Like
     • Filter-By-Data-Type
   • Binding Object
     • Get-Parameter
     • Get-Value
     • Get-Data-Type
     • Is-Data-Type

5. Todo & Roadmap