[sqlite] Using sqlite3.exe as a subprocess

2016-01-18 Thread Hick Gunter
-Urspr?ngliche Nachricht- Von: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-bounces at mailinglists.sqlite.org] Im Auftrag von Roger Binns Gesendet: Samstag, 16. J?nner 2016 19:36 An: SQLite mailing list Betreff: Re: [sqlite] Using sqlite3.exe as a subprocess

[sqlite] Using sqlite3.exe as a subprocess

2016-01-16 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 15/01/16 13:16, Matthew Allen wrote: > Yeah in hindsight it wasn't the best. I was trying to do: > > while still running: p.communicate etc > > Poll is not the right method to call. It especially is the wrong method in your scenario since you

[sqlite] Using sqlite3.exe as a subprocess

2016-01-16 Thread Matthew Allen
On 16 January 2016 at 07:16, Roger Binns wrote: > > > while p.poll() == None: resp = p.communicate() print len(resp[0]), > > resp[0] > > That code doesn't make sense. communicate waits until the process > terminates. The SQLite shell won't terminate unless it gets a quit > command, or EOF on

[sqlite] Using sqlite3.exe as a subprocess

2016-01-15 Thread Matthew Allen
It seems that sqlite3.exe (console) doesn't work as a subprocess with pipes. I've tried it with both C++ code calling the CreateProcessW win32 API and with python and both resulted in the same behaviour. Which is the sub-process doesn't return anything when I try and read it's output (just

[sqlite] Using sqlite3.exe as a subprocess

2016-01-15 Thread Dominique Devienne
On Fri, Jan 15, 2016 at 4:53 AM, Matthew Allen wrote: > It seems that sqlite3.exe (console) doesn't work as a subprocess with > pipes. > [...] I expect there is something funny going on with sqlite3.exe's > stdout/stdin. Sorry to highjack your thread Matthew, but I have what I consider a

[sqlite] Using sqlite3.exe as a subprocess

2016-01-15 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 14/01/16 19:53, Matthew Allen wrote: > It seems that sqlite3.exe (console) doesn't work as a subprocess > with pipes. There is a bit of a problem with using apps via pipes. Generally when stdout is a terminal, output will be line buffered (ie you

[sqlite] Using sqlite3.exe as a subprocess

2016-01-15 Thread Warren Young
On Jan 14, 2016, at 8:53 PM, Matthew Allen wrote: > >p = subprocess.Popen(["sqlite3.exe", "Database.sqlite"], > stdout=subprocess.PIPE) It looks like you?re trying to use both stdin and stdout, but you really only need stdout here, since sqlite3.exe will accept SQL or sqlite3 shell

[sqlite] Using sqlite3.exe as a subprocess

2016-01-15 Thread Richard Hipp
On 1/14/16, Matthew Allen wrote: > It seems that sqlite3.exe (console) doesn't work as a subprocess with > pipes. > Yeah it does. The test suite does this, in the shellN.test test scripts (N=1..5, ex: https://www.sqlite.org/src/artifact/ce5e744870387164) Those these are written in TCL, not in

[sqlite] Using sqlite3.exe as a subprocess

2016-01-15 Thread Adam Devita
Good day, Assuming you don't want to alter the code of the shell tool to take a named pipe (this isn't that difficult to do, unfortunately due to the business logic I can't go into, it was not allowed): Have you tried to create a command prompt shell, begin the sqlite shell tool in that and