Guest User

Untitled

a guest
Jan 9th, 2018
99
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.69 KB | None | 0 0
  1. diff --git a/openprescribing/frontend/management/commands/measure_sql/lpomnibusview.sql b/openprescribing/frontend/manag
  2. ement/commands/measure_sql/lpomnibusview.sql
  3. index e5146c2..40f3687 100644
  4. --- a/openprescribing/frontend/management/commands/measure_sql/lpomnibusview.sql
  5. +++ b/openprescribing/frontend/management/commands/measure_sql/lpomnibusview.sql
  6. @@ -94,15 +94,6 @@ SELECT
  7. numerator,
  8. denominator
  9. FROM
  10. - {project}.{measures}.practice_data_lpomnibus
  11. -
  12. -UNION ALL
  13. -SELECT
  14. - TIMESTAMP(month) AS month,
  15. - practice_id AS practice,
  16. - numerator,
  17. - denominator
  18. -FROM
  19. {project}.{measures}.practice_data_lpoxycodone
  20.  
  21. UNION ALL
  22. diff --git a/openprescribing/gcutils/bigquery.py b/openprescribing/gcutils/bigquery.py
  23. index 710c13a..c1de002 100644
  24. --- a/openprescribing/gcutils/bigquery.py
  25. +++ b/openprescribing/gcutils/bigquery.py
  26. @@ -114,7 +114,7 @@ class Client(object):
  27. data=resource
  28. )
  29. except NotFound as e:
  30. - assert 'Not found: Dataset' in str(e)
  31. + assert 'Not found: Dataset' in str(e), "Unexpected error %s" % e
  32. self.create_dataset()
  33. self.gcbq_client._connection.api_request(
  34. method='POST',
  35. @@ -133,9 +133,12 @@ class Client(object):
  36. try:
  37. table.create()
  38. except NotFound as e:
  39. - assert 'Not found: Dataset' in str(e)
  40. + assert 'Not found: Dataset' in str(e), "Unexpected error %s" % e
  41. self.create_dataset()
  42. - table.create()
  43. + try:
  44. + table.create()
  45. + except Conflict:
  46. + pass
  47. return Table(table, self.project_name)
  48.  
  49. def query(self, sql, legacy=False, **options):
  50. ~
Add Comment
Please, Sign In to add comment