CODEWITHSUNDEEP
rubypostgresqlsequel
Roland
Roland

Reputation: 9691

how do I create a database with sequel

I've read all sequel's docs, but I could not find a way to create a database, assuming that I can do that.

I'm running a rake task as such:

require 'rubygems'
require 'bundler/setup'

require 'pg'
require 'sequel'

require 'yaml'
require 'erb'


namespace :db do

  task :connect do

  end


  task :create => :connect do

    puts db_config

    Sequel.connect(db_config['production']){ |db|

      db.create_table :user do
        primary_key :id

        String :name
        String :email

      end

      user = db[:user]


      user.insert(:name => 'Roland', :email => '[email protected]')
    }

  end

  task :drop => :connect do

  end

end

def db_config
  YAML.load(ERB.new(File.read('config/database.yml')).result)
end

But obviously that will not create the database if it does not exist, so I am a bit unsure what I can do about it. When I run the task I get:

PG::ConnectionBad: FATAL:  database "pulsr" does not exist

And the database.yml file:

production: &production
  adapter: postgres
  host: localhost
  encoding: unicode
  database: pulsr
  username:
  password:

development:
  <<: *production

Does anyone know what I can do to create the database? Will that be a manual process as starting the postgresql server?

Upvotes: 10

Views: 7879

Answers (4)

Steve
Steve

Reputation: 7098

You can do this with Sequel without having to resort to command line tools, which may not be available to you on every system on which your script is used.

Typically you will specify the 'postgres' database in order to fulfill the 'database' parameter requirement.

production = db_config['production']

Sequel.connect(production.merge('database' => 'postgres')) do |db|
  db.execute "DROP DATABASE IF EXISTS #{production['database']}"
  db.execute "CREATE DATABASE #{production['database']}"
end

Sequel.connect(production) do |db|
  # ...
end

This is how ActiveRecord does it, too.

Upvotes: 14

Amit Tiwari
Amit Tiwari

Reputation: 1

echo "create database REMOTE_TESTS" | mysql -u root

Upvotes: -4

harmic
harmic

Reputation: 30577

You can create a database with the CREATE DATABASE command.

When using postgresql, to create a database you first connect to the template1 database as a user with correct priveliges then issue the CREATE DATABASE command.

If you have shell access you can use the handy createdb shell command instead.

Upvotes: 6

Patrick Oscity
Patrick Oscity

Reputation: 54674

Yes, this is a manual process. The database is part of the configuration where sequel should connect to, so it has to be there before sequel starts.

Upvotes: 4

Related Questions