Class: SqliteMagic::Connection

Class

SqliteMagic::Connection

In:

lib/sqlite_magic.rb

Parent:

Object

Methods

add_columns close commit create_table execute insert_or_update new save_data verbose?

Attributes

database [R]

Public Class methods

new(db_loc='sqlite.db', options={})

Public Instance methods

add_columns(tbl_name, col_names)

create_table(tbl_name, col_names, unique_keys=nil)

execute(query,data=nil)

insert_or_update(uniq_keys, values_hash, tbl_name='main_table', opts={})

This is an (expensive) convenience method to insert a row (for given unique keys), or if the row already exists

save_data(uniq_keys, values_array, tbl_name)

save data into the database

Convenience method that returns true if VERBOSE environmental variable set (at the moment whatever it is set to)