Thanks for the answer, but it does not work. It keeps displaying the same set of records. I did not realize but my entry is a duplicate with http://groups.google.com/group/sqlelixir/browse_thread/thread/f53ca10a9787635e?hl=en Let's go on with the discussion there.
On Dec 29, 3:45 pm, yoav glazner <[email protected]> wrote: > On Tue, Dec 29, 2009 at 1:24 PM, fboule <[email protected]> wrote: > > Hello, > > > I am trying to write a tool (with Python/Elixir) that connects to a > > MySQL database and performs some actions for each new insert. > > > I can get all records of a table T and display them. Then I wait for > > keytroke (raw_input) before trying again. On the other hand, I insert > > a new record in the table using the MySQL command-line client and > > press return to make my python script try again. > > > Unfortunately the python script keeps displaying the same recordset > > over and over, without the newly inserted records. > > > I succeeded to refresh it in a strange way: I reassign the database > > connection binding by executing elixir.metadata.bind = 'mysql:// > > localhost/testdb' > > > Any help, clue, hint, comment would be very much appreciated... > > > Fabien. > > It appears you might need an expire_all() call -- You received this message because you are subscribed to the Google Groups "SQLElixir" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sqlelixir?hl=en.
