#!/usr/bin/env ruby require 'sqlite3' def main db = SQLite3::Database.new ARGV[0] db.execute <<-SQL create table power( id INTEGER PRIMARY KEY, timestamp DATETIME, device_name TEXT, device_location_primary TEXT, device_location_secondary TEXT, total FLOAT, total_start_time DATETIME ); SQL db.close end main