Detailed explanation of the steps to set up sub-tables for relationships between Laravel models

This time I will bring you a detailed explanation of the steps to set up a sub-table for the relationship between Laravel models. What are the precautions for setting up a sub-table for the relationship between Laravel models? The following is a practical case, let's take a look.

What is Eloquent

Eloquent is an ORM, the full name is Object Relational Mapping, translated as "object relational mapping" (if you only refer to it If it is regarded as the Database Abstraction Layer array library abstraction layer, it would be too underestimated). The so-called "object" is what this article calls "Model"; object relationship mapping is the relationship between models. Chinese document: http://laravel-china.org/docs/eloquent#relationships

citation

is often used in actual development For example, if the user table is divided into 100 tables, you need to set up separate tables to query the data. For example, Laravel's Model class provides the setTable method:

/**
 * Set the table associated with the model.
 *
 * @param string $table
 * @return $this
 */
public function setTable($table)
{
 $this->table = $table;
 return $this;
}

Then you need to first add, delete, and modify the data table. new a model instance, and then set the table name. For example:

(new Circle())->setTable("t_group_" . hashID($userid, 20))
->newQuery()
->where('group_id', $request->group_id)
->update($attributes);

This is very simple, so how to set up sub-tables when the relationship between models such as HasOne, HasMany, etc. uses this method?

I haven’t found a good solution after searching for a long time. Taking HasOne as an example, I looked at the implementation method of the HasOne function of the Model class. There is no place to set the table name, so I have to copy the HasOne method and modify it. For example, change it to myHasOne, add the $table parameter to set the table name, and call setTable after the object is instantiated, and it will work as expected.

The code is as follows:

public function detail()
{
 return $this->myHasOne(Circle::class, 'group_id', 'group_id', 't_group_' . hashID($this->userid, 20));
}
public function myHasOne($related, $foreignKey = null, $localKey = null, $table)
{
 $foreignKey = $foreignKey ?: $this->getForeignKey();
 
 $instance = (new $related)->setTable($table);
 
 $localKey = $localKey ?: $this->getKeyName();
 
 return new HasOne($instance->newQuery(), $this, $instance->getTable() . '.' . $foreignKey, $localKey);
}

I don’t know if you have a more elegant way.

I believe you have mastered the method after reading the case in this article. For more exciting information, please pay attention to other related articles on the php Chinese website!

Recommended reading:

Detailed explanation of PHP operation Redis steps

Detailed explanation of PHP singleton mode use cases

The above is the detailed content of Detailed explanation of the steps to set up sub-tables for relationships between Laravel models. For more information, please follow other related articles on the PHP Chinese website!