From 3704653c7acaebca6dabe2d8d85f621d4fcebb48 Mon Sep 17 00:00:00 2001 From: Jean-Philippe Lang Date: Fri, 8 May 2009 08:05:45 +0000 Subject: [PATCH] Removes hardcoded table names in Repository#clear_changesets. git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@2715 e93f8b46-1217-0410-a6f0-8f06a7374b81 --- app/models/repository.rb | 7 ++++--- 1 file changed, 4 insertions(+), 3 deletions(-) diff --git a/app/models/repository.rb b/app/models/repository.rb index a205af5b4..bf181bfad 100644 --- a/app/models/repository.rb +++ b/app/models/repository.rb @@ -173,8 +173,9 @@ class Repository < ActiveRecord::Base end def clear_changesets - connection.delete("DELETE FROM changes WHERE changes.changeset_id IN (SELECT changesets.id FROM changesets WHERE changesets.repository_id = #{id})") - connection.delete("DELETE FROM changesets_issues WHERE changesets_issues.changeset_id IN (SELECT changesets.id FROM changesets WHERE changesets.repository_id = #{id})") - connection.delete("DELETE FROM changesets WHERE changesets.repository_id = #{id}") + cs, ch, ci = Changeset.table_name, Change.table_name, "#{table_name_prefix}changesets_issues#{table_name_suffix}" + connection.delete("DELETE FROM #{ch} WHERE #{ch}.changeset_id IN (SELECT #{cs}.id FROM #{cs} WHERE #{cs}.repository_id = #{id})") + connection.delete("DELETE FROM #{ci} WHERE #{ci}.changeset_id IN (SELECT #{cs}.id FROM #{cs} WHERE #{cs}.repository_id = #{id})") + connection.delete("DELETE FROM #{cs} WHERE #{cs}.repository_id = #{id}") end end -- 2.39.5