improve bad queries #222

	# This workflow uses actions that are not certified by GitHub. They are
	# provided by a third-party and are governed by separate terms of service,
	# privacy policy, and support documentation.
	#
	# This workflow will install a prebuilt Ruby version, install dependencies, and
	# run tests and linters.
	name: "Ruby on Rails CI"
	on:
	push:
	branches: ["main"]
	pull_request:
	branches: ["main"]
	jobs:
	test:
	runs-on: ubuntu-latest
	services:
	postgres:
	image: pgvector/pgvector:pg16
	ports:
	- "5432:5432"
	env:
	POSTGRES_DB: rails_test
	POSTGRES_USER: rails
	POSTGRES_PASSWORD: password
	env:
	RAILS_ENV: test
	DATABASE_URL: "postgres://rails:password@localhost:5432/rails_test"
	steps:
	- name: Checkout code
	uses: actions/checkout@v4
	# Add or replace dependency steps here
	- name: Install Ruby and gems
	uses: ruby/setup-ruby@v1 # v1.146.0
	with:
	bundler-cache: true

	- name: Set up database schema
	run: bin/rails db:schema:load
	- name: Setup Tailwind
	run: bundle exec rake assets:precompile
	- name: Run tests
	run: bundle exec rspec

	lint:
	runs-on: ubuntu-latest
	steps:
	- name: Checkout code
	uses: actions/checkout@v4
	- name: Install Ruby and gems
	uses: ruby/setup-ruby@v1
	with:
	ruby-version: '3.2.2'
	bundler-cache: true
	# Add or replace any other lints here
	- name: Security audit dependencies
	run: bundle exec bundler-audit --update
	- name: Security audit application code
	run: bundle exec brakeman -q -w2
	#- name: Lint Ruby files
	# run: bundle exec rubocop --parallel

Provide feedback