blazer.yml

# see https://github.com/ankane/blazer for more info

data_sources:
  main:
    url: <%= ENV["BLAZER_DATABASE_URL"] %>

    # statement timeout, in seconds
    # applies to PostgreSQL only
    # none by default
    # timeout: 15

    # time to cache results, in minutes
    # can greatly improve speed
    # none by default
    cache: 60

    # wrap queries in a transaction for safety
    # not necessary if you use a read-only user
    # true by default
    # use_transaction: false

    smart_variables:
      # zone_id: "SELECT id, name FROM zones ORDER BY name ASC"
        team_id: "SELECT id, team_code FROM teams ORDER BY team_code ASC"
        user_id: "SELECT id, first_name, last_name FROM users"
        attendance_id: "SELECT id, created_at FROM attendaces ORDER BY created_at ASC"
        attendance_sheet_id: "SELECT id, date FROM attendance_sheets ORDER BY date ASC"

    linked_columns:
        user_id: "/users/{user_id}"


    smart_columns:
      user_id: "SELECT id, name FROM users WHERE id IN {value}"

# create audits
audit: true