CODEWITHSUNDEEP
laraveleloquent
Vishal Sharma
Vishal Sharma

Reputation: 2610

How to create models for dynamically generated tables (on the fly)?

I stumbled upon this problem today. My project has a few tables, for which I have created their dedicated Models. However, my project allows user to create dynamic tables.

How do I create relationships or models for/between these dynamically generated tables?

Upvotes: 1

Views: 1563

Answers (1)

Rubens Mariuzzo
Rubens Mariuzzo

Reputation: 29231

I would not recommend to create Eloquent Models on dynamically generated tables, because Eloquent Models are here to help developers with already created database tables (features like relationships, scopes, attributes casting are usually defined for existing database tables).

What would be my recommendation? Use the Query Builder instead. You will have almost the same functionalities of Eloquent Models, except without model.

Instead of having something like:

DynTable::where('foo', 123)
        ->where('bar', 456)
        ->first();

You will have the following:

DB::table('dyn_table')
  ->where('foo', 123)
  ->where('bar', 456)
  ->first();

Basically, the same. But, with the benefit that you can specify any table name to the Query Builder, but you can't change the table name to an Eloquent Model (in a running script).

Upvotes: 1

Related Questions