Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #64133

Re: Process datafeed in one MySql table and output to another MySql table

Show all headers | View raw

[Multipart message — attachments visible in raw view] - view raw

>
> I have a datafeed which is constantly sent to a MySql table. The table
> grows constantly as the data feeds in. I would like to write a python
> script which process the data in this table and output the processed data
> to another table in another MySql database in real-time.
>
> Which are the python libraries which are suitable for this purpose? Are
> there any useful sample code or project on the web that I can use as
> reference? Thank you.
>

Is there a reason you do not want to move these rows with a mysql command?
drop table if exists temp;
insert into temp select * from source where ...;
insert into target select * from temp;
delete from source where id in (select id from temp);

Back to comp.lang.python | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

Process datafeed in one MySql table and output to another MySql table Sam <lightaiyee@gmail.com> - 2014-01-16 17:03 -0800
  Re: Process datafeed in one MySql table and output to another MySql table Denis McMahon <denismfmcmahon@gmail.com> - 2014-01-17 02:07 +0000
    Re: Process datafeed in one MySql table and output to another MySql table Sam <lightaiyee@gmail.com> - 2014-01-17 00:53 -0800
      Re: Process datafeed in one MySql table and output to another MySql table Mark Lawrence <breamoreboy@yahoo.co.uk> - 2014-01-17 09:23 +0000
  Re: Process datafeed in one MySql table and output to another MySql table Jason Friedman <jsf80238@gmail.com> - 2014-01-16 19:23 -0700

csiph-web