Rakefile
# frozen_string_literal: true
require "bundler/gem_tasks"
require "rspec/core/rake_task"
RSpec::Core::RakeTask.new(:spec)
task default: :spec
desc "Initialize the ENV file for connecting to the test database"
task :setup do
if File.exist?(".env")
puts "This will overwrite your existing .env file"
end
db_name = fetch_input("Enter your database name: [active_record_extended_test] ")
db_user = fetch_input("Enter your database user: [] ")
db_password = fetch_input("Enter your database password: [] ")
db_server = fetch_input("Enter your database server: [localhost] ")
db_name = "active_record_extended_test" if db_name.empty?
db_password = ":#{db_password}" unless db_password.empty?
db_server = "localhost" if db_server.empty?
db_server = "@#{db_server}" unless db_user.empty?
env_path = File.expand_path("./.env")
File.open(env_path, "w") do |file|
file.puts "DATABASE_NAME=#{db_name}"
file.puts "DATABASE_URL=\"postgres://#{db_user}#{db_password}#{db_server}/#{db_name}\""
end
puts ".env file saved"
end
# rubocop:disable Metrics/BlockLength
namespace :db do
desc "Loads the test database ENV file"
task :load_db_settings do
require "active_record"
unless ENV["DATABASE_URL"]
require "dotenv"
Dotenv.load
end
end
desc "Drop test database"
task drop: :load_db_settings do
db_config = if ActiveRecord.version > Gem::Version.new("6.1")
ActiveRecord::Base.configurations.resolve ENV["DATABASE_URL"]
else
ActiveRecord::ConnectionAdapters::ConnectionSpecification::ConnectionUrlResolver.new(ENV["DATABASE_URL"]).to_hash
end
ActiveRecord::Tasks::PostgreSQLDatabaseTasks.new(db_config).drop
end
desc "Create test database"
task create: :load_db_settings do
db_config = if ActiveRecord.version > Gem::Version.new("6.1")
ActiveRecord::Base.configurations.resolve ENV["DATABASE_URL"]
else
ActiveRecord::ConnectionAdapters::ConnectionSpecification::ConnectionUrlResolver.new(ENV["DATABASE_URL"]).to_hash
end
ActiveRecord::Tasks::PostgreSQLDatabaseTasks.new(db_config).create
end
desc "Migrate schema to the test database"
task migrate: :load_db_settings do
ActiveRecord::Base.establish_connection(ENV["DATABASE_URL"])
ActiveRecord::Schema.define do
enable_extension "hstore"
create_table :users, force: true do |t|
t.integer "tag_ids", array: true
t.string "name"
t.string "tags", array: true
t.integer "number", default: 0
t.integer "personal_id"
t.hstore "data"
t.jsonb "jsonb_data"
t.inet "ip"
t.cidr "subnet"
t.datetime "created_at"
t.datetime "updated_at"
end
create_table :sti_records, force: true do |t|
t.string "type", default: "StiRecord"
end
create_table :namespaced_records, force: true do |t|
t.inet "ip"
t.cidr "subnet"
end
create_table :tags, force: true do |t|
t.belongs_to :user, index: true, foreign_key: true
t.integer :tag_number, default: 0
end
create_table :profile_ls, force: true do |t|
t.belongs_to :user, index: true, foreign_key: true
t.integer :likes
end
create_table :profile_rs, force: true do |t|
t.belongs_to :user, index: true, foreign_key: true
t.integer :dislikes
end
create_table :version_controls, force: true do |t|
t.references :versionable, polymorphic: true, index: true, null: false
t.jsonb :source, default: {}, null: false
end
create_table :groups, force: true
create_table :groups_users, force: true do |t|
t.belongs_to :user, index: true, foreign_key: true
t.belongs_to :group, index: true, foreign_key: true
end
end
puts "Database migrated"
end
desc "Creates and migrates the schema to the test database"
task setup: :load_db_settings do
unless ENV["DATABASE_URL"]
Rake::Task["setup"].invoke
Dotenv.load
end
Rake::Task["db:create"].invoke
Rake::Task["db:migrate"].invoke
end
end
# rubocop:enable Metrics/BlockLength
def fetch_input(message)
print message
$stdin.gets.chomp
end