Laravel model - return null if the DB table doesn't exist

Question

When I create a model, I want to check if the table exists in the DB. If it doesn't then I want to return a null. This is to prevent a record insert if the table doesn't exist yet.

In my model I have tried this. The Schema call returns false, but I'm still getting a model returned and not a null.

class SomeDataTable extends Model
{
  public function __construct($id)
  {
    $this->setTable($id);
    if (Schema::connection($this->connection)->hasTable($this->table) === false) {
      return null;
    }else{
      parent::__construct();
    }
  }

  public function setTable($id)
  {
    $this->table = $id.'_some_data_table';
  }
}

This is not a correct way to do this. You have to have table for model. — Ramūnas Pabrėža
– Ramūnas Pabrėža, Commented Mar 10, 2020 at 13:53
Right, that's why I'm trying to check if the table exists before I create a model. — Sports Racer
– Sports Racer, Commented Mar 10, 2020 at 14:06
if you are creating Model class you have to have table for it. i`m trying to thing tha reason why model may not have table — Ramūnas Pabrėža
– Ramūnas Pabrėža, Commented Mar 10, 2020 at 14:13
you cannot return null in constructor, constructor is used to initialize the object and its properties by assigning. When you want a object to become nullable. that means you want to destroying the object or clean up resources. — TsaiKoga
– TsaiKoga, Commented Mar 10, 2020 at 15:04
"This is to prevent a record insert if the table doesn't exist yet." Record definitely can't be inserted if table doesn't exist. — Tpojka
– Tpojka, Commented Mar 11, 2020 at 5:54

Hamish Gibson · Accepted Answer · 2020-03-10 14:50:54Z

1

I'm not sure if you're looking for an ubiquitous solution. But what I'd do is do php aritsan migrate -m in the terminal to run migrations of all models. That way, all model tables are created by default.

answered Mar 10, 2020 at 14:50

Hamish Gibson

2565 silver badges19 bronze badges

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

Collectives™ on Stack Overflow

Laravel model - return null if the DB table doesn't exist

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related