Module: Sequel::Plugins::ColumnEncryption::DatasetMethods

Defined in:
lib/sequel/plugins/column_encryption.rb

Instance Method Summary collapse

Instance Method Details

#needing_reencryption ⇒ Object

Filter the dataset to exclude rows where all encrypted columns are already encrypted with the current key and format.



738
739
740
741
742
743
744
745
 
# File 'lib/sequel/plugins/column_encryption.rb', line 738

def needing_reencryption
  incorrect_column_prefixes = model.send(:column_encryption_metadata).map do |column, metadata|
    prefix = metadata.key_searcher.call
    (Sequel[column] < prefix) | (Sequel[column] > prefix + 'B')
  end

  where(Sequel.|(*incorrect_column_prefixes))
end

#with_encrypted_value(column, value) ⇒ Object

Filter the dataset to only match rows where the column contains an encrypted version of value. Only works on searchable encrypted columns.



725
726
727
728
729
730
731
732
733
734
 
# File 'lib/sequel/plugins/column_encryption.rb', line 725

def with_encrypted_value(column, value)
  metadata = model.send(:column_encryption_metadata)[column]
  
  unless metadata && metadata.data_searcher
    raise Error, "lookup for encrypted column #{column.inspect} is not supported"
  end

  prefixes = metadata.data_searcher.call(value)
  where(Sequel.|(*prefixes.map{|v| Sequel.like(column, "#{escape_like(v)}%")}))
end