Switch -glob and switch -regexp are also handy for this kind of code.
On 2/1/18, 3:07 PM, "sqlite-users on behalf of Peter Da Silva"
wrote:
You can do something like this, for one record per file:
Sqlite3 db file.sqlite
while {[gets stdin line] > 0} {
lappend content $
You can do something like this, for one record per file:
Sqlite3 db file.sqlite
while {[gets stdin line] > 0} {
lappend content $line
}
set content [join $content "\n"; # or otherwise manipulate the text you got
back.
db eval {INSERT INTO whatever (index, content) VALUES ($index, $content);}
2018-02-01 21:49 GMT+01:00 Peter Da Silva :
> It's pretty easy in Tcl
>
> Sqlite3 db file.sqlite
> while {[gets stdin line] > 0} {
> parse_line_into index content; # or whatever you do to extract content
> from the line
> db eval {INSERT INTO whatever (index, content) VALUES ($index,
> $co
On 1 Feb 2018, at 8:55pm, Cecil Westerhof wrote:
>> Can you use scripting commands to include it in a file which scripts the
>> SQLite command-line tool ?
>
> I am not sure what you mean.
You can ignore my suggestion. You are using Tcl and it's easier in Tcl.
Sorry, I did not notice that pa
2018-02-01 21:42 GMT+01:00 Simon Slavin :
> On 1 Feb 2018, at 8:25pm, Cecil Westerhof wrote:
>
> > At the moment I have a script where I send the output of a ffmpeg command
> > to the terminal and a file. Is it possible to send the output to a SQLite
> > table. I like to use tcl for this.
>
> Is
It's pretty easy in Tcl
Sqlite3 db file.sqlite
while {[gets stdin line] > 0} {
parse_line_into index content; # or whatever you do to extract content from
the line
db eval {INSERT INTO whatever (index, content) VALUES ($index, $content);}
}
db close
On 2/1/18, 2:25 PM, "sqlite-users on
On 1 Feb 2018, at 8:25pm, Cecil Westerhof wrote:
> At the moment I have a script where I send the output of a ffmpeg command
> to the terminal and a file. Is it possible to send the output to a SQLite
> table. I like to use tcl for this.
Is the output a string of text ?
Can you use scripting co
At the moment I have a script where I send the output of a ffmpeg command
to the terminal and a file. Is it possible to send the output to a SQLite
table. I like to use tcl for this.
--
Cecil Westerhof
___
sqlite-users mailing list
sqlite-users@mailingl
8 matches
Mail list logo