my program code:
engine = create_engine(connect_str, echo=True)Session = sessionmaker(bind=engine)for bar in default_session.query(BarLog)[:3]: conf = ManagerConfig(indicator_config='', timeframe=bar.timeframe, paper_no=1) default_session.add(conf) default_session.commit() log: 2013-08-29 22:52:58,640 INFO sqlalchemy.engine.base.Engine BEGIN (implicit) 2013-08-29 22:52:58,642 INFO sqlalchemy.engine.base.Engine SELECT bar_log.id AS bar_log_id, bar_log.max AS bar_log_max, bar_log.min AS bar_log_min, bar_log.open AS bar_log_open, bar_log.close AS bar_log_close, bar_log.volume AS bar_log_volume, bar_log.time_start AS bar_log_time_start, bar_log.date AS bar_log_date, bar_log.timeframe AS bar_log_timeframe, bar_log.paper_no AS bar_log_paper_no FROM bar_log LIMIT %(param_1)s 2013-08-29 22:52:58,642 INFO sqlalchemy.engine.base.Engine {'param_1': 3} 2013-08-29 22:52:58,646 INFO sqlalchemy.engine.base.Engine INSERT INTO manager_config (paper_no, timeframe, indicator_config) VALUES (%(paper_no)s, %(timeframe)s, %(indicator_config)s) RETURNING manager_config.id 2013-08-29 22:52:58,646 INFO sqlalchemy.engine.base.Engine {'indicator_config': ‘', ’paper_no': 1, ‘timeframe’: 1} 2013-08-29 22:52:58,647 INFO sqlalchemy.engine.base.Engine COMMIT 2013-08-29 22:52:58,662 INFO sqlalchemy.engine.base.Engine BEGIN (implicit) 2013-08-29 22:52:58,664 INFO sqlalchemy.engine.base.Engine SELECT bar_log.id AS bar_log_id, bar_log.max AS bar_log_max, bar_log.min AS bar_log_min, bar_log.open AS bar_log_open, bar_log.close AS bar_log_close, bar_log.volume AS bar_log_volume, bar_log.time_start AS bar_log_time_start, bar_log.date AS bar_log_date, bar_log.timeframe AS bar_log_timeframe, bar_log.paper_no AS bar_log_paper_no FROM bar_log WHERE bar_log.id = %(param_1)s 2013-08-29 22:52:58,664 INFO sqlalchemy.engine.base.Engine {'param_1': 2} 2013-08-29 22:52:58,667 INFO sqlalchemy.engine.base.Engine INSERT INTO manager_config (paper_no, timeframe, indicator_config) VALUES (%(paper_no)s, %(timeframe)s, %(indicator_config)s) RETURNING manager_config.id 2013-08-29 22:52:58,668 INFO sqlalchemy.engine.base.Engine {'indicator_config': ‘', ’paper_no': 1, ‘timeframe’: 1} 2013-08-29 22:52:58,670 INFO sqlalchemy.engine.base.Engine COMMIT 2013-08-29 22:52:58,679 INFO sqlalchemy.engine.base.Engine BEGIN (implicit) 2013-08-29 22:52:58,681 INFO sqlalchemy.engine.base.Engine SELECT bar_log.id AS bar_log_id, bar_log.max AS bar_log_max, bar_log.min AS bar_log_min, bar_log.open AS bar_log_open, bar_log.close AS bar_log_close, bar_log.volume AS bar_log_volume, bar_log.time_start AS bar_log_time_start, bar_log.date AS bar_log_date, bar_log.timeframe AS bar_log_timeframe, bar_log.paper_no AS bar_log_paper_no FROM bar_log WHERE bar_log.id = %(param_1)s 2013-08-29 22:52:58,681 INFO sqlalchemy.engine.base.Engine {'param_1': 3} 2013-08-29 22:52:58,685 INFO sqlalchemy.engine.base.Engine INSERT INTO manager_config (paper_no, timeframe, indicator_config) VALUES (%(paper_no)s, %(timeframe)s, %(indicator_config)s) RETURNING manager_config.id 2013-08-29 22:52:58,685 INFO sqlalchemy.engine.base.Engine {'indicator_config': ‘', ’paper_no': 1, ‘timeframe’: 1} 2013-08-29 22:52:58,688 INFO sqlalchemy.engine.base.Engine COMMIT how to use one select query and many insert queries? -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/groups/opt_out.