FilesExpand file tree

main

/

library_database_relation.rb

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

18 lines (15 loc) · 678 Bytes

main

/

library_database_relation.rb

Copy path

Top

File metadata and controls

• Code
• Blame

18 lines (15 loc) · 678 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

# frozen_string_literal: true

# This relation is responsible for providing an API for reading data

# from the library_database_records database table

class LibraryDatabaseRelation < ROM::Relation[:sql]

schema :library_database_records, infer: true do

attribute :searchable, Types::String

end

# this method uses placeholders so is not vulnerable

# bearer:disable ruby_rails_sql_injection

def query(search_term)

where(Sequel.lit("searchable @@ websearch_to_tsquery('unaccented_dict', unaccent(?))", search_term))

.reverse(Sequel.lit("ts_rank(searchable, websearch_to_tsquery('unaccented_dict', unaccent(?)))", search_term))

end

auto_struct true

end