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)
