class Sequel::Amalgalite::Database

  1. lib/sequel/adapters/amalgalite.rb
Superclass: Sequel::Database

Public Instance methods

connect(server)

Connect to the database. Since SQLite is a file based database, the only options available are :database (to specify the database name), and :timeout, to specify how long to wait for the database to be available if it is locked, given in milliseconds (default is 5000).

[show source] 
   # File lib/sequel/adapters/amalgalite.rb
89 def connect(server)
90   opts = server_opts(server)
91   opts[:database] = ':memory:' if blank_object?(opts[:database])
92   db = ::Amalgalite::Database.new(opts[:database])
93   db.busy_handler(::Amalgalite::BusyTimeout.new(opts.fetch(:timeout, 5000)/50, 50))
94   db.type_map = SequelTypeMap.new(self)
95   connection_pragmas.each{|s| log_connection_yield(s, db){db.execute_batch(s)}}
96   db
97 end
database_type()
[show source] 
    # File lib/sequel/adapters/amalgalite.rb
 99 def database_type
100   :sqlite
101 end
execute(sql, opts=OPTS)
[show source] 
    # File lib/sequel/adapters/amalgalite.rb
116 def execute(sql, opts=OPTS)
117   _execute(sql, opts) do |conn|
118     begin
119       yield(stmt = log_connection_yield(sql, conn){conn.prepare(sql)})
120     ensure
121       stmt.close if stmt
122     end
123   end
124 end
execute_ddl(sql, opts=OPTS)
[show source] 
    # File lib/sequel/adapters/amalgalite.rb
103 def execute_ddl(sql, opts=OPTS)
104   _execute(sql, opts){|conn| log_connection_yield(sql, conn){conn.execute_batch(sql)}}
105   nil
106 end
execute_dui(sql, opts=OPTS)
[show source] 
    # File lib/sequel/adapters/amalgalite.rb
108 def execute_dui(sql, opts=OPTS)
109   _execute(sql, opts){|conn| log_connection_yield(sql, conn){conn.execute_batch(sql)}; conn.row_changes}
110 end
execute_insert(sql, opts=OPTS)
[show source] 
    # File lib/sequel/adapters/amalgalite.rb
112 def execute_insert(sql, opts=OPTS)
113   _execute(sql, opts){|conn| log_connection_yield(sql, conn){conn.execute_batch(sql)}; conn.last_insert_rowid}
114 end
single_value(sql, opts=OPTS)

Run the given SQL with the given arguments and return the first value of the first row.

[show source] 
    # File lib/sequel/adapters/amalgalite.rb
127 def single_value(sql, opts=OPTS)
128   _execute(sql, opts){|conn| log_connection_yield(sql, conn){conn.first_value_from(sql)}}
129 end