How to use php8 enum types in Laravel where conditions?

Question

I have a php8 enum type

enum OperationTypes: string
{
    case PointsAdd = 'points-add';
}

I need to be sure how to properly use it in Laravel database querybuilder. For example:

Model::where('type', OperationTypes::PointsAdd)
or 
Model::where('type', OperationTypes::PointAdd->value)

Model::whereIn('type', [OperationTypes::PointAdd])
or
Model::whereIn('type', [OperationTypes::PointAdd->value])

What is correct way?

Unless you dont explicitly define casts, you should put in the 2nd argument whatever is written in the database for column type? — Alex
– Alex, Commented Mar 21, 2024 at 10:46

Tony · Accepted Answer · 2024-04-09 16:00:55Z

0

Model::where('type', OperationTypes::PointsAdd) passes an object of type OperationTypes to the where clause, which is not going to work.

Model::where('type', OperationTypes::PointAdd->value) passes a string to the where clause, and is the correct way to use enums in queries.

It would be nice if PHP enums supported the toString magic method to automatically cast themselves, but unfortunately they don't.

answered Apr 9, 2024 at 16:00

Tony

10.4k3 gold badges51 silver badges78 bronze badges

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

Collectives™ on Stack Overflow

How to use php8 enum types in Laravel where conditions?

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related