Contents

# rubocop:disable Metrics/AbcSize
# rubocop:disable Metrics/CyclomaticComplexity
# rubocop:disable Metrics/MethodLength
# rubocop:disable Metrics/PerceivedComplexity

# private
module Simple::SQL::Config
  extend self

  # parse a DATABASE_URL, return PG::Connection settings.
  def parse_url(url)
    require "uri"

    raise ArgumentError, "Invalid URL #{url.inspect}" unless url.is_a?(String)
    raise ArgumentError, "Invalid URL #{url.inspect}" unless url =~ /^postgres(ql)?s?:\/\//

    uri = URI.parse(url)
    raise ArgumentError, "Invalid URL #{url}" unless uri.hostname && uri.path

    config = {
      dbname: uri.path.sub(%r{^/}, ""),
      host:   uri.hostname
    }
    config[:port] = uri.port if uri.port
    config[:user] = uri.user if uri.user
    config[:password] = uri.password if uri.password
    config[:sslmode] = uri.scheme == "postgress" || uri.scheme == "postgresqls" ? "require" : "prefer"
    config
  end

  # determines the database_url from either the DATABASE_URL environment setting
  # or a config/database.yml file.
  def determine_url
    ENV["DATABASE_URL"] || database_url_from_database_yml
  end

  private

  def database_url_from_database_yml
    abc = read_database_yml
    username, password, host, port, database = abc.values_at "username", "password", "host", "port", "database"

    # raise username.inspect
    username_and_password = [username, password].compact.join(":")
    host_and_port = [host, port].compact.join(":")
    if username_and_password != ""
      "postgres://#{username_and_password}@#{host_and_port}/#{database}"
    else
      "postgres://#{host_and_port}/#{database}"
    end
  end

  def read_database_yml
    require "yaml"
    database_config = YAML.load_file "config/database.yml"
    env = ENV["RAILS_ENV"] || ENV["RACK_ENV"] || "development"

    database_config[env] ||
      database_config["defaults"] ||
      raise("Invalid or missing database configuration in config/database.yml for #{env.inspect} environment")
  end
end

Version data entries

11 entries across 11 versions & 1 rubygems

Version	Path
simple-sql-0.4.9	lib/simple/sql/config.rb
simple-sql-0.4.8	lib/simple/sql/config.rb
simple-sql-0.4.7	lib/simple/sql/config.rb
simple-sql-0.4.5	lib/simple/sql/config.rb
simple-sql-0.4.4	lib/simple/sql/config.rb
simple-sql-0.4.3	lib/simple/sql/config.rb
simple-sql-0.4.2	lib/simple/sql/config.rb
simple-sql-0.4.1	lib/simple/sql/config.rb
simple-sql-0.4.0	lib/simple/sql/config.rb
simple-sql-0.3.7	lib/simple/sql/config.rb
simple-sql-0.3.6	lib/simple/sql/config.rb