Compoud Index

[mcube27]

Hi,

Has anyone used CompoundIndex ?

I tried but I can't find a way to search for the value afterward.

My index is created like this:

$encryptedRow
            ->addField('first_name')
            ->addField('last_name')
            ->addCompoundIndex(new CompoundIndex('name', ['first_name', 'last_name']));

then if I want to search for a result in the index, I don't know how to put my two columns, as the whereBlind() function only allows for one:

$search = Certificate::whereBlind('first_name', 'name', 'Firstname')->first();

Any idea ?

[mcube27]

Modifying the code of UsesCipherSweet like this:

public function scopeWhereBlind(
        Builder $query,
        string $indexName,
        array $value
    ): Builder {
        return $query->whereExists(fn (Builder $query): Builder => $this->buildBlindQuery($query, $indexName, $value));
    }

    public function scopeOrWhereBlind(
        Builder $query,
        string $indexName,
        array $value
    ): Builder {
        return $query->orWhereExists(fn (Builder $query): Builder => $this->buildBlindQuery($query, $column, $indexName, $value));
    }

    private function buildBlindQuery(
        Builder $query,
        string $indexName,
        array $value
    ): Builder {
        return $query->select(DB::raw(1))
            ->from('blind_indexes')
            ->where('indexable_type', $this->getMorphClass())
            ->where('indexable_id', DB::raw($this->getTable() . '.' . $this->getKeyName()))
            ->where('name', $indexName)
            ->where('value', static::$cipherSweetEncryptedRow->getBlindIndex($indexName, $value));
    }

Allows for the compound index to work