(hsql/call :case
      [:and [:= nil first-name] [:= nil last-name]]
      email
      [:or [:= nil first-name] [:= nil last-name]]
      (hx/concat (hsql/call :coalesce first-name "") (hsql/call :coalesce last-name ""))
      :else
      (hx/concat (hsql/call :coalesce first-name "") (hx/literal " ") (hsql/call :coalesce last-name "")))))

(def datetime-unit-str->base-type

(ns metabase-enterprise.audit-app.pages.common.cards
  (:require [metabase-enterprise.audit-app.pages.common :as common]
            [metabase.db.connection :as mdb.connection]
            [metabase.util.honeysql-extensions :as hx]))

(def avg-exec-time
  "HoneySQL for a CTE to include the average execution time for each Card."
  [:avg_exec_time {:select   [:card_id
                              [:%avg.running_time :avg_running_time_ms]]

  (:require [honeysql.core :as hsql]
            [honeysql.helpers :as hh]
            [metabase-enterprise.audit-app.pages.common :as common]
            [metabase.util.honeysql-extensions :as hx]
            [metabase.util.urls :as urls]))

(defn table
  "Dashboard table!"
  [query-string & [where-clause]]

               :channel.schedule_type
               :channel.schedule_hour
               :channel.schedule_day
               :channel.schedule_frame
               [:creator.id :creator_id]
               [(hx/concat :creator.first_name (hx/literal " ") :creator.last_name) :creator_name]
               [:channel.created_at :created_at]
               [:pulse.parameters :pulse_parameters]]
   :from      [[:pulse_channel :channel]]

                                                  [:= :u.is_superuser true]
                                                  (hx/literal "Admin")
                                                  :else
                                                  (hx/literal "User"))
                                                :role]
                                               :id

(deftest add-45-days-clause-test
  (testing "add 45 days clause"
    (is (=
          {:where
           [:>
            (hx/with-type-info
              (hsql/call :cast :bob.dobbs #honeysql.types.SqlRaw{:s "date"})
              {::hx/database-type "date"})
            nil]}
          (assoc-in (#'common/add-45-days-clause {} :bob.dobbs) [:where 2] nil)))))

(deftest add-search-clause-test

            [metabase.models.dashboard :refer [Dashboard]]
            [metabase.models.interface :as mi]
            [metabase.models.revision :as revision]
            [metabase.util.honeysql-extensions :as hx]
            [metabase.util.schema :as su]
            [schema.core :as s]))

(def ^:private ModelName
  (s/enum "card" "dashboard"))

;; SELECT {{group-fn(timestamp}} AS "date", count(*) AS views
;; FROM view_log

            [metabase.models.application-permissions-revision :as a-perm-revision]
            [metabase.models.permissions :as perms]
            [metabase.util.honeysql-extensions :as hx]
            [metabase.util.schema :as su]
            [schema.core :as s]
            [toucan.db :as db]))

;;; ---------------------------------------------------- Schemas -----------------------------------------------------

   :results  (common/reducible-query
              {:select   [[(hx/cast :date :started_at) :day]
                          [:%count.* :views]
                          [:%avg.running_time :avg_running_time]]
               :from     [:query_execution]
               :group-by [(hx/cast :date :started_at)]
               :order-by [[(hx/cast :date :started_at) :asc]]})})

^K:5^Hw.-Rq^CX \\0\\0\\0942515122h^BU\\n^G--^X^G^^$\\n^NӅRq^DX \\0\\0\\0760857294h^BU\\n^G-- ^F8+ ---Rq^EX \\0\\0\\0207000491h^BU\\n^G--^X^E^_^L^F-$-Rq^FX \\0\\0\\0281067699h^BU\\n^G--^B^O^C-^A<13>Rq^GX \\0\\0\\0941678014h^BU\\n^G--^\\^W^N^W^F-$-Rq^HX \\0\\0\\0840070155h^BU\\n^G--^\\^L\\n6^D*ʅRq X \\0\\0\\0468440035h^BU\\n^G--^V^W*^N^Bp^K-Rq\\nU 169240315h^BU\\n^G--^W^U^W1^D-m-Rq^KX \\0\\0\\0199411251h^BU\\n^G--^V^W%^^^A---Rq^LU 210660648h^BU\\n^G--^\\^W^Y-^F\\Zd-Rq\\rU 262672217h^BU\\n^G--\\Z^V2:^O^U--Rq^NX...