how do I populate the database? source foo.sql ?

rubyonrails-talk
1

I've tried several techniques to importing data, no success.

I don't have much SQL, do I need to do something like "load infile" through SQL to import data? Or, can I do something through rails with the "source foo.sql" command, which looks promising but I, for one, can't figure out the syntax :frowning:

thufir@arrakis ~/goodfellow-tool/db $ thufir@arrakis ~/goodfellow-tool/db $ sqlite3 development.sqlite3 < data.sql SQL error near line 1: near "/": syntax error thufir@arrakis ~/goodfellow-tool/db $ thufir@arrakis ~/goodfellow-tool/db $ cat data.sql insert into db/development.sqlite3.calls (name) values ("goodfellow");

thufir@arrakis ~/goodfellow-tool/db $ thufir@arrakis ~/goodfellow-tool/db $ source data.sql bash: data.sql: line 1: syntax error near unexpected token `(' bash: data.sql: line 1: `insert into db/development.sqlite3.calls (name) values ("goodfellow");' thufir@arrakis ~/goodfellow-tool/db $ thufir@arrakis ~/goodfellow-tool/db $ thufir@arrakis ~/goodfellow-tool/db $ sqlite3 development.sqlite3 SQLite version 3.4.1 Enter ".help" for instructions

.schema

CREATE TABLE calls ("id" INTEGER PRIMARY KEY NOT NULL, "start" integer DEFAULT NULL, "end" integer DEFAULT NULL, "name" varchar(255) DEFAULT NULL, "avaya_login" integer DEFAULT NULL); CREATE TABLE schema_info (version integer);

.quit

thufir@arrakis ~/goodfellow-tool/db $

thanks,

Thufir