Introducing the Omah-plugin-sqlite gem

To test the Omah-plugin-sqlite gem I used dummy_omah. If it works with the dummy_omah gem then it will work with the Omah gem.

require 'dummy_omah'
require 'omah-plugin-sqlite'

a = [
      ['001', 'info@twitter.com', 'somebody@jamesrobertson.eu',\
      'test 200','2015-may-26 08:55','just a quick test',\
      '<p>just a quick test</p>',[]]
    ]

plugins = {
  sqlite: {active: true, dbfile: '/tmp/headers.db'}
}
dummy = DummyOmah.new(filepath: '/tmp', plugins: plugins)
dummy.fetch_email a

In the above example it creates a file in the /tmp directory called headers.db.

From the command-line, the command sqlite3 headers.db "select * from headers" returned the following:

1|info@twitter.com|somebody@jamesrobertson.eu|test 200|2015-may-26 08:55

Resources