Intend base query

[ShaungBhone]

I'm looking for intent-based Eloquent queries that route to read/write connections

User::read()->where('active', 1)->get();      // uses read connection
User::write()->whereKey($id)->update([...]);  // uses write connection

[shaedrich]

But isn't that redundant? I mean, get() could automatically choose read and update() could automatically choose write:

User::withSeparateReadWriteConnection()->where('active', 1)->get();      // uses read connection
User::withSeparateReadWriteConnection()->whereKey($id)->update([...]);  // uses write connection

or

User::withSeparateReadWriteConnection(fn (Builder $query) => $query->where('active', 1)->get());      // uses read connection
User::withSeparateReadWriteConnection(fn (Builder $query) => $query->whereKey($id)->update([...]));  // uses write connection

or

class User extends Model
{
    protected bool $withSeparateReadWriteConnection = true;
}
User::query()->where('active', 1)->get();      // uses read connection
User::query()->whereKey($id)->update([...]);  // uses write connection

I know, the method/property name is a mouthful, but it's just for demonstration purposes 😉

[shaedrich]

Technically, you could overwrite the model's getConnectionName() to achieve this

class User extends Model
    /**
     * Get the current connection name for the model.
     *
     * @return string|null
     */
    public function getConnectionName()
    {
        return $this->connectionType === 'read'
            ? 'mysql.read'
            : 'postgresql.write';
    }
}

[ShaungBhone]

Thanks

[shaedrich]

You're welcome

[shaedrich]

You can already do this today fairly effortless btw:

User::setConnection('mysql.read')->where('active', 1)->get();      // uses read connection
User::setConnection('postgresql.write')->whereKey($id)->update([...]);  // uses write connection

Edit: Use #58449 (comment)

[macropay-solutions]

Model::query()->useWritePdo()->...