mirror of
https://gh.wpcy.net/https://github.com/discourse/discourse.git
synced 2026-05-27 13:45:29 +08:00
1ba9b34b03
This has no functional impact yet, but it is the first step in adding more granular scopes to UserApiKeys
46 lines
1.2 KiB
Ruby
Vendored
46 lines
1.2 KiB
Ruby
Vendored
# frozen_string_literal: true
|
|
|
|
class AddUserApiKeyScopes < ActiveRecord::Migration[6.0]
|
|
def change
|
|
create_table :user_api_key_scopes do |t|
|
|
t.integer :user_api_key_id, null: false
|
|
t.string :name, null: false
|
|
t.timestamps
|
|
end
|
|
|
|
add_index :user_api_key_scopes, :user_api_key_id
|
|
|
|
reversible do |dir|
|
|
dir.up do
|
|
execute <<~SQL
|
|
INSERT INTO user_api_key_scopes
|
|
(
|
|
user_api_key_id,
|
|
name,
|
|
created_at,
|
|
updated_at
|
|
)
|
|
SELECT
|
|
user_api_keys.id,
|
|
unnest(user_api_keys.scopes),
|
|
created_at,
|
|
updated_at
|
|
FROM user_api_keys
|
|
SQL
|
|
|
|
Migration::SafeMigrate.disable!
|
|
change_column_null :user_api_keys, :scopes, true
|
|
change_column_default :user_api_keys, :scopes, nil
|
|
Migration::SafeMigrate.enable!
|
|
|
|
Migration::ColumnDropper.mark_readonly(:user_api_keys, :scopes)
|
|
end
|
|
|
|
dir.down do
|
|
change_column_null :user_api_keys, :scopes, false
|
|
change_column_default :user_api_keys, :scopes, []
|
|
Migration::ColumnDropper.drop_readonly(:user_api_keys, :scopes)
|
|
end
|
|
end
|
|
end
|
|
end
|
