How to add an sql function to a laravel eloquent model

Question

I'm wanting to create a laravel model with a computed column. I've seen how to do this once the data is downloaded however the computation I wish to do is expensive but accessible as a function in my sql. Essentially I'd like to append one more column to the query builder but I'm unsure how to go about it.

The query needs to be something like:

select *, my_function(ID) as my_value from my_table;

and I need to get an instance of the model in return (not a raw recordset).

I'm also hoping to avoid multiple queries.

Thanks.

you can store query results in redis and define a scheduled job to update cached results check link below stackoverflow.com/questions/31527161/… — Anar Bayramov
– Anar Bayramov, Commented Jun 30, 2017 at 8:24

musicvicious · Accepted Answer · 2017-06-30 13:22:41Z

5

Your query can be something like this:

User::select([
   'users.*',
   \DB::raw('YEAR(created_at) as year')
])->get()

Replace YEAR function with whatever function you want. should append to the results that column as well.

answered Jun 30, 2017 at 13:22

musicvicious

1,09316 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

FloatingKiwi Over a year ago

Thanks. That's exactly what I'm after

FloatingKiwi · Accepted Answer · 2017-07-01 04:29:57Z

0

Building on the answer from musicvicious I ended up going with:

class User extends Model
{
...

    public function newQuery()
    {
        return parent::newQuery()->select('users.*', \DB::raw('YEAR(created_at) as year'));
    }

}

Now I can just fetch the models as normal.

User::all();

answered Jul 1, 2017 at 4:29

FloatingKiwi

4,5161 gold badge20 silver badges46 bronze badges

Collectives™ on Stack Overflow

How to add an sql function to a laravel eloquent model

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related