class ActiveRecord::Tasks::SQLiteDatabaseTasks

def charset
  connection.encoding
end

def configuration
  @configuration
end

def create
  raise DatabaseAlreadyExists if File.exist?(configuration['database'])
  establish_connection configuration
  connection
end

def drop
  require 'pathname'
  path = Pathname.new configuration['database']
  file = path.absolute? ? path.to_s : File.join(root, path)
  FileUtils.rm(file) if File.exist?(file)
end

def initialize(configuration, root = ActiveRecord::Tasks::DatabaseTasks.root)
  @configuration, @root = configuration, root
end

def purge
  drop
  create
end

def root
  @root
end

def structure_dump(filename)
  dbfile = configuration['database']
  `sqlite3 #{dbfile} .schema > #{filename}`
end

def structure_load(filename)
  dbfile = configuration['database']
  `sqlite3 #{dbfile} < "#{filename}"`
end