Laravel Eloquent - Existing Database with Mix of snake_case and camelCase Columns

Question

I have a large existing database that I would like to access with Laravel/Eloquent.

I'm using Laravel 5.2,
I have generated models using the "user11001/eloquent-model-generator" package
I have generated autocompletion using the command php artisan ide-helper:models

However my database contains a mix of snake_case and camelCase columns, and whenever I try to access the camelCase column "seoAlias", with code like the following:

$x = AdvertiserModel::whereSeoAlias('someValue')->get();

I get the following error:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'seo_alias' in 'where clause'

Does anyone have a solution for accessing a database with a mix of snake_case and camelCase columns using Laravel?

Thanks,

Sebastien · Accepted Answer · 2017-03-25 14:05:02Z

1

You could use the following if your column name is seoAlias:

$x = AdvertiserModel::where('seoAlias','=','someValue')->get();

This way you will be able to access the database with eloquent without having to rename the columns.

answered Mar 25, 2017 at 14:05

Sebastien

62510 silver badges15 bronze badges

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

1 Comment

mils Over a year ago

It's not as type-safe as I would like it, but it definitely works. So I guess it will have to do

Fabien Sa · Accepted Answer · 2018-09-27 05:04:46Z

It's a bit tricky but you can remove the Str::snake from the QueryBuilder. For that you need to extends the base model and override newBaseQueryBuilder() to use our own QueryBuilder.

<?php

use Illuminate\Database\Query\Builder as QueryBuilder;

abstract class Model extends \Illuminate\Database\Eloquent\Model
{
    protected function newBaseQueryBuilder()
    {
        $connection = $this->getConnection();

        return new class(
            $connection,
            $connection->getQueryGrammar(),
            $connection->getPostProcessor()
        ) extends QueryBuilder {
            protected function addDynamic($segment, $connector, $parameters, $index)
            {
                $bool = strtolower($connector);

                // here we remove the Str::snake (in illuminate/database/Query/Builder.php)
                $this->where($segment, '=', $parameters[$index], $bool);
            }
        };
    }
}

Now extends this model and it should works.

Anup Patil · Accepted Answer · 2017-03-24 06:13:14Z

-1

I think it's fine how it is. Eloquent required camel_case in L3, and I don't think it's super practical to have people convert their entire databases to camelCase for L4. Remembering when to use what is pretty easy:

Class names are study case and methods are camel case (PSR-1).
Eloquent attributes can be accessed using either snake or camel case, but database tables and columns are snake case.
Configuration options, language lines, and view names are snake case and use "dot" syntax.
Global functions are snake case per PHP convention.
Input can be whatever you want.

That's really all there is to it.

answered Mar 24, 2017 at 6:13

Anup Patil

14 bronze badges

1 Comment

mils Over a year ago

I don't think it's practical to rename half the columns of a large existing database in order to make it work with Laravel

Collectives™ on Stack Overflow

Laravel Eloquent - Existing Database with Mix of snake_case and camelCase Columns

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related