eirb(main):115:0> User.joins(roles: :permissions).where(email: target_user_emails.map(&:downcase), roles: { active: true }, permissions: { name: 'ticket.customer', active: true }.where.not(id: 1).find_each do |user|
irb(main):116:1*
#irb(main):117:1*  puts "Customer #{user.login}/#{user.email} has #{Ticket.where(customer_id: user.id).count} tickets"



 Tirb(main):118:1>
iirb(main):119:1>
irb(main):120:1>
irb(main):121:1>  Ticket.where(customer: user).find_each do |ticket|

   irb(main):122:2*
irb(main):123:2*    puts "  Deleting ticket #{ticket.number}..."
irb(main):124:2>
irb(main):125:2>    ticket.destroy
irb(main):126:2>
irb(main):127:2>  end
 irb(main):128:1>
irb(main):129:1>
irb(main):130:1>
irb(main):131:1>  puts "  Removing references for user with E-Mail #{user.email}..."

 Actirb(main):132:1>
iviirb(main):133:1>  ActivityStream.where(created_by_id: user.id).update_all(created_by_id: 1)
irb(main):134:1>
irb(main):135:1>  History.where(created_by_id: user.id).update_all(created_by_id: 1)
irb(main):136:1>
irb(main):137:1>  Ticket::Article.where(created_by_id: user.id).update_all(created_by_id: 1)
irb(main):138:1>
irb(main):139:1>  Ticket::Article.where(updated_by_id: user.id).update_all(updated_by_id: 1)
irb(main):140:1>
irb(main):141:1>  Store.where(created_by_id: user.id).update_all(created_by_id: 1)
irb(main):142:1>
irb(main):143:1>  StatsStore.where(created_by_id: user.id).update_all(created_by_id: 1)
irb(main):144:1>
irb(main):145:1>  Tag.where(created_by_id: user.id).update_all(created_by_id: 1)
irb(main):146:1>
irb(main):147:1>  if OnlineNotification.find_by(user_id: user.id)==""
irb(main):148:2>
irb(main):149:2>   OnlineNotification.find_by(user_id: user.id).destroy!
irb(main):150:2>
irb(main):151:2>  end
irb(main):152:1>
irb(main):153:1>
irb(main):154:1>
irb(main):155:1>  puts "  Deleting user #{user.login}/#{user.email}..."

 useirb(main):156:1>
rirb(main):157:1>  user.destroy
irb(main):158:1>
endirb(main):159:1> end
Customer auto-1574873834-256835/[email protected] has 1 tickets
  Deleting ticket 46080...
Ticket::Article.find(1280) notify DESTOY 2019-11-27 11:44:07 UTC
Ticket.find(81) notify UPDATED 2019-11-29 16:03:38 UTC
User.find(366) notify TOUCH 2019-11-29 16:03:38 UTC
Ticket::Article.find(1281) notify DESTOY 2019-11-27 11:44:09 UTC
Ticket.find(81) notify TOUCH 2019-11-29 16:03:38 UTC
Ticket.find(81) notify DESTOY 2019-11-29 16:03:38 UTC
User.find(366) notify TOUCH 2019-11-29 16:03:38 UTC
  Removing references for user with E-Mail [email protected]...
  Deleting user auto-1574873834-256835/[email protected]...
Traceback (most recent call last):
        2: from (irb):115
        1: from (irb):157:in `block in irb_binding'
ActiveRecord::StatementInvalid (Mysql2::Error: Cannot delete or update a parent row: a foreign key constraint fails (`zammad`.`users`, CONSTRAINT `fk_rails_45307c95a3` FOREIGN KEY (`created_by_id`) REFERENCES `users` (`id`)): DELETE FROM `users` WHERE `users`.`id` = 366)