Class: ActiveRecord::ConnectionAdapters::SQLiteAdapter
Overview
Instance Method Summary
collapse
#add_limit!, #initialize, #quote, #reset_runtime, #structure_dump, #transaction
Instance Method Details
#begin_db_transaction ⇒ Object
121
|
# File 'lib/active_record/connection_adapters/sqlite_adapter.rb', line 121
def begin_db_transaction() @connection.transaction end
|
#columns(table_name, name = nil) ⇒ Object
130
131
132
133
134
|
# File 'lib/active_record/connection_adapters/sqlite_adapter.rb', line 130
def columns(table_name, name = nil)
table_structure(table_name).map { |field|
SQLiteColumn.new(field['name'], field['dflt_value'], field['type'])
}
end
|
#commit_db_transaction ⇒ Object
122
|
# File 'lib/active_record/connection_adapters/sqlite_adapter.rb', line 122
def commit_db_transaction() @connection.commit end
|
#delete(sql, name = nil) ⇒ Object
94
95
96
97
98
|
# File 'lib/active_record/connection_adapters/sqlite_adapter.rb', line 94
def delete(sql, name = nil)
sql += " WHERE 1=1" unless sql =~ /WHERE/i
execute(sql, name)
@connection.changes
end
|
#execute(sql, name = nil) ⇒ Object
85
86
87
|
# File 'lib/active_record/connection_adapters/sqlite_adapter.rb', line 85
def execute(sql, name = nil)
log(sql, name) { @connection.execute(sql) }
end
|
#insert(sql, name = nil, pk = nil, id_value = nil) ⇒ Object
100
101
102
103
|
# File 'lib/active_record/connection_adapters/sqlite_adapter.rb', line 100
def insert(sql, name = nil, pk = nil, id_value = nil)
execute(sql, name = nil)
id_value || @connection.last_insert_row_id
end
|
#quote_column_name(name) ⇒ Object
140
141
142
|
# File 'lib/active_record/connection_adapters/sqlite_adapter.rb', line 140
def quote_column_name(name)
return "'#{name}'"
end
|
#quote_string(s) ⇒ Object
136
137
138
|
# File 'lib/active_record/connection_adapters/sqlite_adapter.rb', line 136
def quote_string(s)
@connection.class.quote(s)
end
|
#rollback_db_transaction ⇒ Object
123
|
# File 'lib/active_record/connection_adapters/sqlite_adapter.rb', line 123
def rollback_db_transaction() @connection.rollback end
|
#select_all(sql, name = nil) ⇒ Object
105
106
107
108
109
110
111
112
113
|
# File 'lib/active_record/connection_adapters/sqlite_adapter.rb', line 105
def select_all(sql, name = nil)
execute(sql, name).map do |row|
record = {}
row.each_key do |key|
record[key.sub(/\w+\./, '')] = row[key] unless key.is_a?(Fixnum)
end
record
end
end
|
#select_one(sql, name = nil) ⇒ Object
115
116
117
118
|
# File 'lib/active_record/connection_adapters/sqlite_adapter.rb', line 115
def select_one(sql, name = nil)
result = select_all(sql, name)
result.nil? ? nil : result.first
end
|
126
127
128
|
# File 'lib/active_record/connection_adapters/sqlite_adapter.rb', line 126
def tables
execute('.table').map { |table| Table.new(table) }
end
|
#update(sql, name = nil) ⇒ Object
89
90
91
92
|
# File 'lib/active_record/connection_adapters/sqlite_adapter.rb', line 89
def update(sql, name = nil)
execute(sql, name)
@connection.changes
end
|