search

cycle / database

Database Abstraction Layer, Schema Introspection, Schema Generation, Query Builders
MIT License
53 stars 22 forks source link

Adding support JSON columns in orderBy statement #184

Closed msmakouz closed 3 months ago

msmakouz commented 3 months ago

What's was changed

Adding support JSON columns in orderBy statement. For example:

$records = $this->database
    ->select()
    ->from('app_logs')
    ->orderBy('record->created_at', 'DESC')
    ->fetchAll();

Closes: #166

codecov[bot] commented 3 months ago

Codecov Report

All modified and coverable lines are covered by tests :white_check_mark:

Project coverage is 95.29%. Comparing base (18bce1d) to head (ec3d1ed).

Additional details and impacted files ```diff @@ Coverage Diff @@ ## 2.x #184 +/- ## ============================================ + Coverage 95.28% 95.29% +0.01% - Complexity 1843 1851 +8 ============================================ Files 130 130 Lines 5085 5099 +14 ============================================ + Hits 4845 4859 +14 Misses 240 240 ```

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.