row = result_set.fetch_row(how=2) # {'virtual_view.id': '102', 'virtual_view.created_on': '2010-10-29 11:53:31','virtual_view.description': '', 'virtual_view.day_range_default': '0', 'virtual_view.subscribed': '0', 'virtual_view.options': '', 'virtual_view.enabled': '1', 'virtual_view.user_id': '1', 'virtual_view.name': 'STC User Growth'} if row: row=row[0] print row db.query(r''' insert into `virtual_view` (`user_id`,`name`,`day_range_default`,`description`,`enabled`,`subscribed`,`options`) select `user_id`,%s as `name`,`day_range_default`,%s as `description`,`enabled`,`subscribed`,`options` from `virtual_view` where `id`='%s' ''' %(db.string_literal(row['virtual_view.name'].replace('STC','Viva_BH')) ,db.string_literal(row['virtual_view.description'].replace('STC','Viva_BH')) ,str(view_id))) new_id=db.insert_id() print new_id if new_id>0: db.query(r''' insert into `virtual_view_chart` (`view_id`,`name`,`description`,`tab_order`,`columns`,`column_value_tune`,`options`) select '%s' as `view_id`
name=row['view.name'].replace('Umniah','Globe') sql=row['view.sql'].replace('Umniah','Globe').replace('umniah','globe') max_view_id=helper_mysql.get_one_value_int(r''' select max(`id`) from `view` ''') description=row['view.description'].replace(str(row['view.id']),str(max_view_id+1)) print 'view_name:'+name print 'sql:'+sql print '\n' db.query(r'insert into view (`name`,`description`,`day_range_default`,`sql`,`conn_string`) values (%s,%s,%s,%s,%s)' \ %(db.string_literal(name),db.string_literal(description), \ db.string_literal(row['view.day_range_default']),db.string_literal(sql),db.string_literal(row['view.conn_string']))) view_id=row['view.id'] new_id=db.insert_id() print 'inserted view:'+str(new_id) """ if new_id: db.query(r'select * from chart where view_id='+str(view_id)+' order by id asc') result_set_chart = db.store_result() chart_ids=[] while 1: row_chart = result_set_chart.fetch_row(how=2) if not row_chart: break #print str(row_chart)