Laravel Interface to multiple models

Question

I'm writing a system around an existing database structure using Laravel 4.1. The current system is based around two websites which use their own table, a and b, both of which are identical. This is an unavoidable problem until we rewrite the other system.

I need to be able to query both tables at the same time using Eloquents Query Builder, so I may need to get a list of rows from both tables, or INSERT or UPDATE from either at any time.

Currently we have a model for both tables, but no way to link between them and implement the missing methods such as all or find.

Our thought is to have an Interface which will bind these results together, however we're not sure how to go about this at all.

<?php

    interface HotelInterface {
        public function all();
        public function find();
    }

    use Illuminate\Database\Model;

    class Hotel implements HotelInterface {

    }

?>

Is all we have so far.

@DavidBarker yes they are, but they're in a different database to what the main models are. This isn't the problem though. — James
– James, Commented Feb 11, 2014 at 8:41
Sorry, I wasn't trying to point out a problem... I needed to know if there were on the same server to propose a potential solution. — David Barker
– David Barker, Commented Feb 11, 2014 at 14:06

James · Accepted Answer · 2014-02-13 12:13:04Z

I asked on the Laravel forums and got the answer I was looking for! I'm reposting here incase.

What we're actually after is a Repository which would look like this:

<?php
    class HotelRepository {
        public $A;
        public $B;

        public function __construct(A $A, B $B) {
            $this->A = $A;
            $this->B  = $B;
        }

        public function find($iso = NULL, $hotelid = NULL) {
            $A = $B = NULL;

            if($iso !== NULL) {
                $A = $this->A->where('country', $iso);
                $B  = $this->B->where('country', $iso);

                if($hotelid !== NULL) {
                    $A = $A->where('id', $hotelid);
                    $B = $B->where('id', $hotelid);
                }
            }

            if($hotelid !== NULL) {
                if($A->first()) {
                    return $A->first();
                }
                if($B->first()) {
                    return $B->first();
                }
            }else{
                return $A->get()->merge($B->get());
            }
        }

        public function all() {
            $aCollection = $this->A->all();
            $bCollection  = $this->B->all();
            return $aCollection->merge($bCollection);
        }
    }

Now in the controller where I want to call this, I just add:

<?php
    class HomeController extends BaseController {
        public function __construct(HotelRepository $hotels) {
            $this->hotels = $hotels;
        }
    }

And I can now use $this->hotels to access the find and all method that I created.

beech · Accepted Answer · 2014-02-11 14:22:36Z

1

If the tables are identical you should only need one model, the connection is the only thing that needs to change. Have a read here: http://fideloper.com/laravel-multiple-database-connections.

There's a Eloquent method on() for specifying the connection, here's an example:

The Eloquent example looks like what you need:

$results = Model::on('mysql')->find(1);

Add both connections to your database config and then change the on() part depending on which DB you need to query.

Update: misunderstood the question

If you only need to change the table and not the database, you can use setTable()

$model = new Model
$model->setTable('b');
$model->find(1);

Although that may get confusing.

Instead, you could also define a base model and then extend it with the only difference being the table protected $table = 'b';

edited Feb 11, 2014 at 14:22

answered Feb 11, 2014 at 13:39

beech

1,0648 silver badges13 bronze badges

5 Comments

James Over a year ago

Thanks, but I'm not using a different database.

beech Over a year ago

Ah, sorry. You just want setTable then.

David Barker Over a year ago

@James I'm confused.... are these or aren't these on different databases? Now you're saying they're just different tables within the same DB?

James Over a year ago

These two tables are on one database, but the rest of the system is in a different one.

beech Over a year ago

If only these tables are on different databases then use protected $connection = 'mysql2'; in the model too

Dennis Braga · Accepted Answer · 2014-02-11 12:55:07Z

0

You can always change the default database for the one you need. I use this Config::set('database.default', 'chronos');, where chronos is one of my databases. When I need to change to the "other", I just change de database name. You can call it wherever you want. I think that what you're looking for is just switch between the databases.

You need to have two different models, one for each table on each database, though.

Let me know if I got it wrong.

edited Feb 11, 2014 at 12:55

answered Feb 10, 2014 at 16:38

Dennis Braga

1,4883 gold badges21 silver badges40 bronze badges

Collectives™ on Stack Overflow

Laravel Interface to multiple models

3 Answers 3

Comments

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related