Gecko [ fernandoquevedodop.com ]

Name	Size	Permission
memcached	[ DIR ]	drwxr-xr-x
mongo	[ DIR ]	drwxr-xr-x
activerecord.rb	4.47 KB	-rw-r--r--
cassandra.rb	3.37 KB	-rw-r--r--
client.rb	2.05 KB	-rw-r--r--
cookie.rb	967 B	-rw-r--r--
couch.rb	3.85 KB	-rw-r--r--
datamapper.rb	2.34 KB	-rw-r--r--
daybreak.rb	1.17 KB	-rw-r--r--
dbm.rb	615 B	-rw-r--r--
file.rb	3.18 KB	-rw-r--r--
fog.rb	1.54 KB	-rw-r--r--
gdbm.rb	606 B	-rw-r--r--
hbase.rb	3.06 KB	-rw-r--r--
leveldb.rb	929 B	-rw-r--r--
lmdb.rb	2.17 KB	-rw-r--r--
localmemcache.rb	766 B	-rw-r--r--
lruhash.rb	2.69 KB	-rw-r--r--
memcached.rb	385 B	-rw-r--r--
memory.rb	450 B	-rw-r--r--
mongo.rb	225 B	-rw-r--r--
null.rb	668 B	-rw-r--r--
pstore.rb	1.97 KB	-rw-r--r--
redis.rb	2.35 KB	-rw-r--r--
restclient.rb	1.31 KB	-rw-r--r--
riak.rb	1.69 KB	-rw-r--r--
sdbm.rb	606 B	-rw-r--r--
sequel.rb	3.74 KB	-rw-r--r--
sqlite.rb	2.68 KB	-rw-r--r--
tdb.rb	609 B	-rw-r--r--
tokyocabinet.rb	1.38 KB	-rw-r--r--
tokyotyrant.rb	3.24 KB	-rw-r--r--
yaml.rb	238 B	-rw-r--r--

Code Editor : sqlite.rb

require 'sqlite3'

module Moneta
  module Adapters
    # Sqlite3 backend
    # @api public
    class Sqlite
      include Defaults
      include IncrementSupport

supports :create
      attr_reader :backend

# @param [Hash] options
      # @option options [String] :file Database file
      # @option options [String] :table ('moneta') Table name
      # @option options [Fixnum] :busy_timeout (1000) Sqlite timeout if database is busy
      # @option options [::Sqlite3::Database] :backend Use existing backend instance
      def initialize(options = {})
        table = options[:table] || 'moneta'
        @backend = options[:backend] ||
          begin
            raise ArgumentError, 'Option :file is required' unless options[:file]
            ::SQLite3::Database.new(options[:file])
          end
        @backend.busy_timeout(options[:busy_timeout] || 1000)
        @backend.execute("create table if not exists #{table} (k blob not null primary key, v blob)")
        @stmts =
          [@exists  = @backend.prepare("select exists(select 1 from #{table} where k = ?)"),
           @select  = @backend.prepare("select v from #{table} where k = ?"),
           @replace = @backend.prepare("replace into #{table} values (?, ?)"),
           @delete  = @backend.prepare("delete from #{table} where k = ?"),
           @clear   = @backend.prepare("delete from #{table}"),
           @create  = @backend.prepare("insert into #{table} values (?, ?)")]
      end

# (see Proxy#key?)
      def key?(key, options = {})
        @exists.execute!(key).first.first.to_i == 1
      end

# (see Proxy#load)
      def load(key, options = {})
        rows = @select.execute!(key)
        rows.empty? ? nil : rows.first.first
      end

# (see Proxy#store)
      def store(key, value, options = {})
        @replace.execute!(key, value)
        value
      end

# (see Proxy#delete)
      def delete(key, options = {})
        value = load(key, options)
        @delete.execute!(key)
        value
      end

# (see Proxy#increment)
      def increment(key, amount = 1, options = {})
        @backend.transaction(:exclusive) { return super }
      end

# (see Proxy#clear)
      def clear(options = {})
        @clear.execute!
        self
      end

# (see Default#create)
      def create(key, value, options = {})
        @create.execute!(key,value)
        true
      rescue SQLite3::ConstraintException
        # If you know a better way to detect whether an insert-ignore
        # suceeded, please tell me.
        @create.reset!
        false
      end

# (see Proxy#close)
      def close
        @stmts.each {|s| s.close }
        @backend.close
        nil
      end
    end
  end
end

${this.title}

Code Editor : sqlite.rb