Skip to content

Instantly share code, notes, and snippets.

@MichaelXavier

MichaelXavier/gist:445383

Created June 19, 2010 23:00
Show Gist options
  • Save MichaelXavier/445383 to your computer and use it in GitHub Desktop.
Save MichaelXavier/445383 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.builder
require 'dbi'
@dbh = DBI.connect("DBI:SQLite3:files.db")
@dbh.do("CREATE TABLE IF NOT EXISTS files (filename VARCHAR PRIMARY KEY, x INTEGER, y INTEGER, mtime INTEGER)")
@dbh.do("CREATE TABLE IF NOT EXISTS dir (id INTEGER PRIMARY KEY AUTOINCREMENT, mtime INTEGER)")
@dbh.disconnect
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment