24 lines
541 B
Ruby
24 lines
541 B
Ruby
# frozen_string_literal: true
|
|
|
|
class AddToolNameToAiTools < ActiveRecord::Migration[7.1]
|
|
def up
|
|
add_column :ai_tools,
|
|
:tool_name,
|
|
:string,
|
|
null: false,
|
|
limit: 100,
|
|
default: "",
|
|
if_not_exists: true
|
|
|
|
# Migrate existing name to tool_name
|
|
execute <<~SQL
|
|
UPDATE ai_tools
|
|
SET tool_name = regexp_replace(LOWER(name),'[^a-z0-9_]','', 'g');
|
|
SQL
|
|
end
|
|
|
|
def down
|
|
remove_column :ai_tools, :tool_name, if_exists: true
|
|
end
|
|
end
|