old_contents: """
  sentry.search.django.constants
  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  
  :copyright: (c) 2010-2014 by the Sentry Team, see AUTHORS for more details.
  :license: BSD, see LICENSE for more details.
  """
  
  from __future__ import absolute_import
  
  
  SORT_CLAUSES = {
      'priority': 'sentry_groupedmessage.score',
      'date': 'EXTRACT(EPOCH FROM sentry_groupedmessage.last_seen)::int',
      'new': 'EXTRACT(EPOCH FROM sentry_groupedmessage.first_seen)::int',
      'freq': 'sentry_groupedmessage.times_seen',
      'tottime': 'sentry_groupedmessage.time_spent_total',
      'avgtime': '(sentry_groupedmessage.time_spent_total / sentry_groupedmessage.time_spent_count)::int',
  }
  
  SQLITE_SORT_CLAUSES = SORT_CLAUSES.copy()
  SQLITE_SORT_CLAUSES.update({
      'date': "cast((julianday(sentry_groupedmessage.last_seen) - 2440587.5) * 86400.0 as INTEGER)",
      'new': "cast((julianday(sentry_groupedmessage.first_seen) - 2440587.5) * 86400.0 as INTEGER)",
  })
  
  MYSQL_SORT_CLAUSES = SORT_CLAUSES.copy()
  MYSQL_SORT_CLAUSES.update({
      'date': 'UNIX_TIMESTAMP(sentry_groupedmessage.last_seen)',
      'new': 'UNIX_TIMESTAMP(sentry_groupedmessage.first_seen)',
  })
  
  ORACLE_SORT_CLAUSES = SORT_CLAUSES.copy()
  ORACLE_SORT_CLAUSES.update({
      'date': "(cast(sentry_groupedmessage.last_seen as date)-TO_DATE('01/01/1970 00:00:00', 'MM-DD-YYYY HH24:MI:SS')) * 24 * 60 * 60",
      'new': "(cast(sentry_groupedmessage.first_seen as date)-TO_DATE('01/01/1970 00:00:00', 'MM-DD-YYYY HH24:MI:SS')) * 24 * 60 * 60",
  })
  
  MSSQL_SORT_CLAUSES = SORT_CLAUSES.copy()
  MSSQL_SORT_CLAUSES.update({
      'date': "DATEDIFF(s, '1970-01-01T00:00:00', sentry_groupedmessage.last_seen)",
      'new': "DATEDIFF(s, '1970-01-01T00:00:00', sentry_groupedmessage.first_seen)",
  })
  MSSQL_ENGINES = set(['django_pytds', 'sqlserver_ado', 'sql_server.pyodbc'])
  
new_contents: """
  sentry.search.django.constants
  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
  
  :copyright: (c) 2010-2014 by the Sentry Team, see AUTHORS for more details.
  :license: BSD, see LICENSE for more details.
  """
  
  from __future__ import absolute_import
  
  
  SORT_CLAUSES = {
      'priority': 'sentry_groupedmessage.score',
      'date': 'EXTRACT(EPOCH FROM sentry_groupedmessage.last_seen)::int',
      'new': 'EXTRACT(EPOCH FROM sentry_groupedmessage.first_seen)::int',
      'freq': 'sentry_groupedmessage.times_seen',
      'tottime': 'sentry_groupedmessage.time_spent_total',
      'avgtime': '(sentry_groupedmessage.time_spent_total / sentry_groupedmessage.time_spent_count)::int',
  }
  
  SQLITE_SORT_CLAUSES = SORT_CLAUSES.copy()
  SQLITE_SORT_CLAUSES.update({
      'date': "cast((julianday(sentry_groupedmessage.last_seen) - 2440587.5) * 86400.0 as INTEGER)",
      'new': "cast((julianday(sentry_groupedmessage.first_seen) - 2440587.5) * 86400.0 as INTEGER)",
  })
  
  MYSQL_SORT_CLAUSES = SORT_CLAUSES.copy()
  MYSQL_SORT_CLAUSES.update({
      'date': 'UNIX_TIMESTAMP(sentry_groupedmessage.last_seen)',
      'new': 'UNIX_TIMESTAMP(sentry_groupedmessage.first_seen)',
      'avgtime': 'CAST((sentry_groupedmessage.time_spent_total / sentry_groupedmessage.time_spent_count) as INTEGER)',
  })
  
  ORACLE_SORT_CLAUSES = SORT_CLAUSES.copy()
  ORACLE_SORT_CLAUSES.update({
      'date': "(cast(sentry_groupedmessage.last_seen as date)-TO_DATE('01/01/1970 00:00:00', 'MM-DD-YYYY HH24:MI:SS')) * 24 * 60 * 60",
      'new': "(cast(sentry_groupedmessage.first_seen as date)-TO_DATE('01/01/1970 00:00:00', 'MM-DD-YYYY HH24:MI:SS')) * 24 * 60 * 60",
  })
  
  MSSQL_SORT_CLAUSES = SORT_CLAUSES.copy()
  MSSQL_SORT_CLAUSES.update({
      'date': "DATEDIFF(s, '1970-01-01T00:00:00', sentry_groupedmessage.last_seen)",
      'new': "DATEDIFF(s, '1970-01-01T00:00:00', sentry_groupedmessage.first_seen)",
  })
  MSSQL_ENGINES = set(['django_pytds', 'sqlserver_ado', 'sql_server.pyodbc'])
  
subject: Fix avgtime sort in MySQL (fixes GH-1381)