# Copyright (c) 2010 Flowerfire, Inc.  All Rights Reserved.
microsoft_sqlprofiler = {

  plugin_version = "1.1"

  # 25/May/2006 - 1.1 - GMF - Cleaned up; fixed parsing filters to accept - in dates

  # The name of the log format
  log.format.format_label = "Microsoft SQL Profiler Export"
  log.miscellaneous.log_data_type = "other"
  log.miscellaneous.log_format_type = "application"

  log.format.allow_newlines_inside_quotes = "true"

  # The log is in this format if any of the first ten lines match this regular expression
  log.format.autodetect_regular_expression = "^[0-9]*,[0-9]*,[^,]*,[^,]*,[^,]*,[^,]*,[^,]*,[^,]*,[^,]*,[^ ]* [^,]*,[^,]*,[^,]*,[^,]*$"

  # All log field parsing will be done using the parsing filters
#  log.format.parse_only_with_filters = "true"

  # The format of dates and times in this log
#  log.format.date_format = "m/d/yy"
#  log.format.time_format = "h:mm"
  log.format.date_format = "auto"
  log.format.time_format = "auto"

  log.format.field_separator = ","

  # Log fields
  log.fields = {

    type.index = 2
    operation.index = 3
    source.index = 6
    user.index = 7
    timestamp.index = 10
    date = ""
    time = ""

  } # log.fields

  log.parsing_filters.parse = `
# Extract date and time from timestamp
if (matches_regular_expression(timestamp, '^([0-9/-]+) ([0-9:]+)')) then (
  date = $1;
  time = $2;
);
`

  # Database fields
  database.fields = {

    date_time = ""
    day_of_week = ""
    hour_of_day = ""
    user = ""
    source = ""
    type = ""
    operation = ""

  } # database.fields

  database.numerical_fields = {

    events = {
      default = true
      requires_log_field = false
      entries_field = true
    } # events

  } # database.numerical_fields


  log.filters = {

    mark_entry = {
      label = '$lang_admin.log_filters.mark_entry_label'
      comment = '$lang_admin.log_filters.mark_entry_comment'
      value = 'events = 1;'
    } # mark_entry

  } # log.filters

  create_profile_wizard_options = {

    # How the reports should be grouped in the report menu
    report_groups = {
      date_time_group = ""
    } # report_groups

  } # create_profile_wizard_options

} # microsoft_sqlprofiler