Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ruby script using dbi gem error inserting in mysql table with new index
- sql = "INSERT INTO traffic_by_pages (publication_id, subdomain, region_id, region_name, page_url, site_section, yr, mnth, dy, TrafficDate, DailyVisitors, DailyVisits, DailyPageViews, NewVisitors, ReturningVisitors, object_id, object_type) VALUES (#{publication_id}, '#{subdomain}', #{region_id}, '#{region_name}', '#{page_url}', '#{site_section}', #{yr}, #{mnth}, #{dy}, '#{trafficdate}', #{dailyvisitors}, #{dailyvisits}, #{dailypageviews}, #{newvisitors}, #{returningvisitors}, #{obj_id}, '#{objectType}');"
- ' '')'
- sql = 'INSERT INTO traffic_by_pages (publication_id, subdomain, region_id, region_name, page_url, site_section, yr, mnth, dy, TrafficDate, DailyVisitors, DailyVisits, DailyPageViews, NewVisitors, ReturningVisitors, object_id, object_type) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'
- # For each row...
- dbh.do(sql,
- publication_id,
- subdomain,
- region_id,
- region_name,
- page_url,
- site_section,
- yr,
- mnth,
- dy,
- trafficdate,
- dailyvisitors,
- dailyvisits,
- dailypageviews,
- newvisitors,
- returningvisitors,
- obj_id,
- objectType
- )
- # or
- sth = dbh.prepare(sql)
- # for each row...
- sth.execute(publication_id, subdomain, region_id, ...)
Add Comment
Please, Sign In to add comment