>Are you the developer / maintainer of the SQLite shell?
THE developer is D Richard Hipp. He is the decisionmaker and principal
developer of the SQLite releases originated from sqlite.org. For all
practical purposes, that is the official release.
On the other hand, because of the open license, anybody can make changes
their copy of the SQLite which best traverse the critical paths of their
own project(s). There are also extension interfaces which enable writing
native target code that is forward compatible with later releases of
SQLite. Wrapping your own native code in those extension interfaces is the
best way to implement special features for a project/product.
Speaking of critical paths, it seems that my question uncovered some
critical paths you weren't aware of. To assume your application will run
everywhere without a supporting technology (or your own code) which tests
such a guarantee is a mistake. SQLite shell makes no such guarantee.
My advice would be to figure out all of your project's critical paths
before plunging into development - except for the narrowest possible
development required to figure out a critical path.
Peter
On Mon, Jan 15, 2018 at 2:08 AM, Shane Dev <devshan...@gmail.com> wrote:
> Hi Peter,
>
> Ideally, I would like to execute a series of "test cases" from within the
> SQLite shell without dependency on an external scripting language. These
> would not normally be executed by the application end user. Initially, I
> planned to implement this with triggers but I see now that the results of
> executing a given statement from within a trigger can be different from
> executing the same statement via the SQLite shell (which I assume is
> calling sqlite3_step or sqlite3_exec)
>
> For conditional logic, case expressions are currently sufficient for my
> needs. So far, I have not needed to execute a script periodically but it
> might useful in the future.
>
> Are you the developer / maintainer of the SQLite shell?
>
> On 15 January 2018 at 01:30, petern <peter.nichvolo...@gmail.com> wrote:
>
> > Shane. That's very interesting considering the effort to make the one
> > thing happen exactly once without external software dependency.
> > Does the capability to write specially named local files but not have a
> > periodic loop nor network capability somehow get your application off the
> > ground?
> > Based on your problem statement, the user would have to initiate your
> > script and know when/if it is required to be run...
> >
> > I had in mind adding periodic and conditional dot commands to SQLite
> shell
> > - to simulate continuous operation of application code. If you've
> figured
> > out a way around needing such things to make a useful standalone SQLite
> > application, I would be very interested to understand how that works.
> >
> > Peter
> >
> >
> >
> >
> >
> > On Sun, Jan 14, 2018 at 2:33 PM, Shane Dev <devshan...@gmail.com> wrote:
> >
> > > Hi Simon,
> > >
> > > I have found a way achieve this purely in the SQLite shell. The trick
> is
> > to
> > > make all rows in tcout1 SQL statements and then execute them.
> > >
> > > sqlite> CREATE TABLE tcout1(sql text);
> > > sqlite> CREATE TABLE tcout2(sql text);
> > > sqlite> insert into tcout1(sql) select "insert into tcout2(sql) select
> > > '.headers off';";
> > > sqlite> insert into tcout1(sql) select "insert into tcout2(sql) select
> > > '.once tc'||strftime('%s','now');";
> > > sqlite> insert into tcout1(sql) select "insert into tcout2(sql) select
> > > 'select * from tc;';";
> > > sqlite> .once tcout1.sql
> > > sqlite> select * from tcout1;
> > > sqlite> .read tcout1.sql
> > > sqlite> select * from tcout2;
> > > .headers off
> > > .once tc1515968593
> > > select * from tc;
> > >
> > >
> > > On 13 January 2018 at 19:57, Simon Slavin <slav...@bigfraud.org>
> wrote:
> > >
> > > > On 13 Jan 2018, at 6:48pm, Shane Dev <devshan...@gmail.com> wrote:
> > > >
> > > > > Is there a way to execute the contents of certain rows (the second
> > row
> > > in
> > > > > this example) and replace it with its own result to create second
> > > table /
> > > > > view which could interpreted by the sqlite shell?
> > > >
> > > > Not inside the SQLite shell.
> > > >
> > > > Looks like you need to learn programming. Or at least how to script
> > your
> > > > OS shell. Which OS are you using ? And if it’s Linux/Unix, which
> > shell
> > > > are you using ?
> > > >
> > > > Simon.
> > > > _______________________________________________
> > > > sqlite-users mailing list
> > > > sqlite-users@mailinglists.sqlite.org
> > > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> > > >
> > > _______________________________________________
> > > sqlite-users mailing list
> > > sqlite-users@mailinglists.sqlite.org
> > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> > >
> > _______________________________________________
> > sqlite-users mailing list
> > sqlite-users@mailinglists.sqlite.org
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> >
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
