Level 75
Don't use query builder, use eloquent. Eloquent has all of query builder methods as well.
1 like
Apr 27, 2022
9
Level 1
Query Builder with Model Attributes
I'm Using Query Builder, and I would like to use setters in my model, how can I do it please
This is my code :
$tenantUser = DB::connection('tenant')->table('users')->insert($request->validated());
the password method, doesn't work because i'm using query builder:
protected function password(): Attribute
{
return Attribute::make(
set: fn ($value) => Hash::make($value)
);
}
Level 1
@jlrdw How I can do that please since i have to use DB::connection
Level 55
$tenantUser = User::setConnection('tenant')->create($request->validated());
1 like
Level 1
@SilenceBringer "Non-static method Illuminate\Database\Eloquent\Model::setConnection() cannot be called statically",
Level 75
@AmineBHD I have answered this in past: https://laracasts.com/discuss/channels/laravel/dbconnection-does-not-work-as-documented
But:
For eloquent
<?php
namespace App;
use Illuminate\Database\Eloquent\Model;
class Powner extends Model
{
protected $table = 'dc_powners';
protected $primaryKey = 'ownerid';
protected $connection = 'mysqlv2'; <-----------------
protected $fillable = [
'ownerid',
'oname',
'ostreet',
'odate',
'ocheck'
];
public $timestamps = [];
}
1 like
Level 1
// $tenantUser = DB::connection('tenant')->table('users')->insert($request->validated());
$tenantUser = User::on('tenant')->create($request->validated()); // for static usage
Level 75
@AmineBHD Your answer allows:
protected function password(): Attribute
{
return Attribute::make(
set: fn ($value) => Hash::make($value)
);
}
?
Or does using eloquent allow that? It is two different questions. You asked about accessors and mutators, so I don't follow the answer you showed?
Level 1
@jlrdw Yes I can use password() like that
1 like
Level 75
@AmineBHD I am glad you solved it.
Please or to participate in this conversation.