Hey mark I guess that you are using ClojureQL, can you post your
function call?
Ronen
On Nov 25, 6:39 pm, Mark Stang <markjst...@gmail.com> wrote:
> Hi,
> I am working on reading a pipe delimited file into a SQL database.
>
> I can read the lines using
> (doseq [line (read-lines "myfile.csv")]
>
> and format the lines using
>
> (map #(format "\"%s\"" %) (re-split #"\|" line))
>
> This results in list for each line.
>
> I have created a table that has one column for each value in the list.
> The values are like ("mark" "stang" "employee").
>
> What I can figure out is how to "convert" the list into something that
> can be passed to insert-rows.
>
> The error I get is that "insert into mytable values ()" I have tried
> converting the row into a vector
>
> (vec (map #(format "\"%s\"" %) (re-split #"\|" line)))
>
> Which when I print it, it looks like ["mark" "stang" "employee"] but the
> insert-rows function isn't seeing it. I have tried doing a let for each
> line and passing the name, but no such luck.
>
> It seems that I could get it to work with insert-values, but that seems
> like a lot of overhead.
>
> I would think I should be able to call insert-rows with the results of
> reading the entire file.
>
> Thoughts?
>
> Thanks,
>
> Mark
--
You received this message because you are subscribed to the Google
Groups "Clojure" group.
To post to this group, send email to clojure@googlegroups.com
Note that posts from new members are moderated - please be patient with your
first post.
To unsubscribe from this group, send email to
clojure+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/clojure?hl=en
