module Motor::Queries::Persistance

Constants

NameAlreadyExists

Public Instance Methods

archive_with_existing_name(query) click to toggle source
# File lib/motor/queries/persistance.rb, line 59
def archive_with_existing_name(query)
  Motor::Query.where(['name = ? AND id != ?', query.name, query.id])
              .update_all(deleted_at: Time.current)
end
assign_attributes(query, params) click to toggle source
# File lib/motor/queries/persistance.rb, line 52
def assign_attributes(query, params)
  query.assign_attributes(params.slice(:name, :description, :sql_body, :preferences))
  query.updated_at = [params[:updated_at], Time.current].min if params[:updated_at].present?

  Motor::Tags.assign_tags(query, params[:tags])
end
build_from_params(params, current_user = nil) click to toggle source
# File lib/motor/queries/persistance.rb, line 10
def build_from_params(params, current_user = nil)
  query = assign_attributes(Query.new, params)

  query.author = current_user

  query
end
create_from_params!(params, current_user = nil) click to toggle source
# File lib/motor/queries/persistance.rb, line 18
def create_from_params!(params, current_user = nil)
  raise NameAlreadyExists if Query.exists?(name: params[:name])

  query = build_from_params(params, current_user)

  ApplicationRecord.transaction do
    query.save!
  end

  query
rescue ActiveRecord::RecordNotUnique
  retry
end
name_already_exists?(query) click to toggle source
# File lib/motor/queries/persistance.rb, line 64
def name_already_exists?(query)
  if query.new_record?
    Query.exists?(name: query.name)
  else
    Query.exists?(['name = ? AND id != ?', query.name, query.id])
  end
end
update_from_params!(query, params, force_replace: false) click to toggle source
# File lib/motor/queries/persistance.rb, line 32
def update_from_params!(query, params, force_replace: false)
  tag_ids = query.tags.ids

  query = assign_attributes(query, params)

  raise NameAlreadyExists if !force_replace && name_already_exists?(query)

  ApplicationRecord.transaction do
    archive_with_existing_name(query) if force_replace

    query.save!
  end

  query.touch if tag_ids.sort != query.tags.reload.ids.sort && params[:updated_at].blank?

  query
rescue ActiveRecord::RecordNotUnique
  retry
end