Contents

require "sqlite3"

namespace :db do
  desc "Create a database for photo data"
  task :initialise do
    puts "This task is deprecated; run sequel -m db/migrations sqlite://photo_data.db instead."
    # # If a DB already exists, do nothing.
    # if File.exist?(Piccle::Database::PHOTO_DATABASE_FILENAME)
    #   puts "Database #{Piccle::Database::PHOTO_DATABASE_FILENAME} already exists; exiting."
    # else
    #   puts "Creating an empty DB..."
    #   db = SQLite3::Database.new(Piccle::Database::PHOTO_DATABASE_FILENAME)
    #   puts "    ... and writing a schema to it..."
    #   db.execute <<-SQL
    #     CREATE TABLE photos(
    #       id INTEGER PRIMARY KEY,
    #       file_name text NOT NULL,
    #       path text NOT NULL,
    #       md5 varchar(128) NOT NULL,
    #       width integer NOT NULL,
    #       height integer NOT NULL,
    #       camera_name text,
    #       taken_at datetime,
    #       created_at datetime
    #     );
    #     SQL
    #   puts "    ... Done."
    # end
  end

  desc "Drop the database"
  task :drop do
    File.delete("photo_data.db")
  end

  desc "Recreate the database"
  task recreate: [:drop, :initialise]
end

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
piccle-0.1.1.pre	lib/tasks/development.rake
piccle-0.1.0.rc1	lib/tasks/development.rake