Re: pysqlite

From: Peter Otten (__peter___at_web.de)
Date: 03/28/04

  • Next message: Cameron Laird: "Re: os module question"
    Date: Sun, 28 Mar 2004 15:05:22 +0200
    
    

    Dave Harrison wrote:

    > I need to be able to flash a database with the sql def'ns I have, and it
    > works if I pipe my file into sqlite, but when I execute the same data as
    > a giant string I get no error, but the database isn't flashed.
    >
    > anyone have any ideas ? Ive tried stripping out newlines, all whitespace
    > reduced to single spaces etc etc ...

    Did you commit() before closing the connection?

    Peter


  • Next message: Cameron Laird: "Re: os module question"

    Relevant Pages

    • Re: pysqlite
      ... > have, and it works if I pipe my file into sqlite, but when I ... > execute the same data as a giant string I get no error, ...
      (comp.lang.python)
    • Re: foreign key ado syntax
      ... incorporate your sqlite wrapper. ... Sub ToDatabase ... execute for each record(instead of doing a batch...which i've never done ... 'new sqlite command object type implemetation... ...
      (microsoft.public.vb.database.ado)
    • Re: Optimax
      ... Instead of calling 'system' to execute ... pipe and executes them. ... # Send the command to the background and wait for it to complete. ... # execution of the optimars under different os's. ...
      (rec.games.corewar)
    • Re: [MSH] Requires an executable on the RHS of a pipe?
      ... Monad Program Management ... If I attempt to pipe to a WSH script without specifying the script ... MSH C:\> get-content Test.js ... Program 'Test.js' failed to execute: The specified executable is not a ...
      (microsoft.public.windows.server.scripting)
    • Re: Question about pipes and terminals
      ... the user should be able to use the shell normally. ... > that the child has finished directly it all worked well. ... > process through a pipe. ... Now when i execute a shell, ...
      (comp.os.linux.development.system)