Skip to content

Instantly share code, notes, and snippets.

@rsinger

rsinger/table.rb

Created May 26, 2011 19:46
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save rsinger/993906 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save rsinger/993906 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
table.rb
DB.create_table :journals do
primary_key :id
string :title, :size=>1024, :index=>true
string :issn, :size=>8, :index=>true
string :e_issn, :size=>8, :index=>true
text :journal_url
text :publisher
text :abbreviation
text :cjdb_note
text :local_note
end
@rsinger
Copy link
Author

rsinger commented May 26, 2011

I, [2011-05-26T15:58:41.112082 #35894] INFO -- : (0.000132s) PRAGMA foreign_keys = 1
I, [2011-05-26T15:58:41.112291 #35894] INFO -- : (0.000072s) PRAGMA table_info('journals')
E, [2011-05-26T15:58:41.112647 #35894] ERROR -- : SQLite3::SQLException: no such table: journals: SELECT * FROM journals LIMIT 1
I, [2011-05-26T15:58:41.113574 #35894] INFO -- : (0.000039s) PRAGMA table_info('coverages')
E, [2011-05-26T15:58:41.113848 #35894] ERROR -- : SQLite3::SQLException: no such table: coverages: SELECT * FROM coverages LIMIT 1
=> true

setup_database
I, [2011-05-26T15:58:56.008205 #35894] INFO -- : (0.000643s) CREATE TABLE journals (id integer PRIMARY KEY AUTOINCREMENT, title varchar(1024), issn string(8), e_issn string(8), journal_url varchar(255), publisher varchar(255), abbreviation varchar(255), cjdb_note varchar(255), local_note varchar(255))
I, [2011-05-26T15:58:56.008702 #35894] INFO -- : (0.000200s) CREATE INDEX journals_title_index ON journals (title)
I, [2011-05-26T15:58:56.009064 #35894] INFO -- : (0.000179s) CREATE INDEX journals_issn_index ON journals (issn)
I, [2011-05-26T15:58:56.009416 #35894] INFO -- : (0.000172s) CREATE INDEX journals_e_issn_index ON journals (e_issn)

@rsinger
Copy link
Author

rsinger commented May 26, 2011

CREATE TABLE journals (id integer PRIMARY KEY AUTOINCREMENT, title varchar(1024), issn string(8), e_issn string(8), journal_url varchar(255), publisher varchar(255), abbreviation varchar(255), cjdb_note varchar(255), local_note varchar(255));

INSERT INTO journals (id, issn) VALUES (2, "00005678");

select * from journals; 2||5678||||||

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment