Guest User

Untitled

a guest
Aug 17th, 2018
117
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.27 KB | None | 0 0
  1. ruby script using dbi gem error inserting in mysql table with new index
  2. 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}');"
  3.  
  4. ' '')'
  5.  
  6. 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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'
  7. # For each row...
  8. dbh.do(sql,
  9. publication_id,
  10. subdomain,
  11. region_id,
  12. region_name,
  13. page_url,
  14. site_section,
  15. yr,
  16. mnth,
  17. dy,
  18. trafficdate,
  19. dailyvisitors,
  20. dailyvisits,
  21. dailypageviews,
  22. newvisitors,
  23. returningvisitors,
  24. obj_id,
  25. objectType
  26. )
  27.  
  28. # or
  29. sth = dbh.prepare(sql)
  30. # for each row...
  31. sth.execute(publication_id, subdomain, region_id, ...)
Add Comment
Please, Sign In to add comment