J=      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~NoneY      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[None%&09:;<=?CDRd%(Internal) Class that implements the JOIN  magic (see -).+(Internal) Class that implements the tuple  magic (see -).Class that enables one to use }: to convert an entity's key on a query into another (cf. }).Phantom class of data types that are treated as strings by the RDBMS. It has no methods because it's only used to avoid type errors such as trying to concatenate integers."If you have a custom data type or newtype2, feel free to make it an instance of this class. Since: 2.4.00Different kinds of locking clauses supported by ?.iNote that each RDBMS has different locking support. The constructors of this datatype specify only the syntax$ of the locking mechanism, not its  semantics?. For example, even though both MySQL and PostgreSQL support :, there are no guarantees that they will behave the same. Since: 2.2.7 FOR UPDATE5 syntax. Supported by MySQL, Oracle and PostgreSQL. Since: 2.2.7 FOR SHARE" syntax. Supported by PostgreSQL. Since: 2.2.7 LOCK IN SHARE MODE syntax. Supported by MySQL. Since: 2.2.7 Phantom type used by  insertSelect. Phantom type for a SET0 operation on an entity of the given type (see t and '(=.)'). Phantom type used by : and ;. Phantom type used by 4, 5 and 6.((Internal) Phantom type used to process  (see -).Exception thrown whenever 2 is used to create an ON clause but no matching JOIN is found.E(Internal) Functions that operate on types (that should be) of kind . (Internal)  smartJoin a b is a JOIN of the correct kind.(Internal) Reify a JoinKind from a JOIN . This function is non-strict.(Internal) A kind of JOIN.  INNER JOIN  CROSS JOIN LEFT OUTER JOIN RIGHT OUTER JOIN FULL OUTER JOINData type that represents a FULL OUTER JOIN (see  for an example).Data type that represents a RIGHT OUTER JOIN (see  for an example).Data type that represents a LEFT OUTER JOIN. For example,  select $  $ \(person `` pet) -> ... is translated into /SELECT ... FROM Person LEFT OUTER JOIN Pet ...  See also: . Data type that represents a  CROSS JOIN (see  for an example)."Data type that represents an  INNER JOIN (see  for an example).$uA class of things that can be converted into a list of SomeValue. It has instances for tuples and is the reason why 3 can take tuples, like 3 (foo B FooId, foo B FooName, foo B FooType).&A wrapper type for for any expr (Value a) for all a.(hA list of single values. There's a limited set of functions able to work with this data type (such as l, n, p and r).*=A single value (as opposed to a whole entity). You may use (B) or (C) to get a * from an .,"Finally tagless representation of  esqueleto's EDSL.-(Internal) Start a  query with an entity.  does two kinds of magic using -, / and 0: >The simple but tedious magic of allowing tuples to be used.$The more advanced magic of creating JOIN s. The JOINB is processed from right to left. The rightmost entity of the JOIN is created with - . Each JOIN( step is then translated into a call to /. In the end, 0! is called to materialize the JOIN..(Internal) Same as -, but entity may be missing./(Internal) Do a JOIN.0(Internal) Finish a JOIN.1WHERE% clause: restrict the query's result.2ON clause: restrict the a JOIN's result. The ON clause will be applied to the last JOIN that does not have an ON clause yet. If there are no JOIN s without ON+ clauses (either because you didn't do any JOIN, or because all JOINs already have their own ON clauses), a runtime exception  is thrown. ON! clauses are optional when doing JOINs.%On the simple case of doing just one JOIN , for example  select $  $ \(foo `"` bar) -> do 2 (foo B FooId M bar B BarFooId) ... Pthere's no ambiguity and the rules above just mean that you're allowed to call 2; only once (as in SQL). If you have many joins, then the 2s are applied on the reverse order that the JOINs appear. For example:  select $  $ \(foo `"` bar `"` baz) -> do 2 (baz B BazId M bar B BarBazId) 2 (foo B FooId M bar B BarFooId) ...  The order is reversed; in order to improve composability. For example, consider query1 and query2 below: let query1 =  $ \(foo `"` bar) -> do 2 (foo B FooId M bar B BarFooId) query2 =  $ \(mbaz `#` quux) -> do return (mbaz Cf BazName, quux) test1 = (,) <$> query1 <*> query2 test2 = flip (,) <$> query2 <*> query1 If the order was not reversed, then test2 would be broken: query1's 2 would refer to query2's .3GROUP BY6 clause. You can enclose multiple columns in a tuple.  select $  \(foo `"` bar) -> do 2 (foo B FooBarId M bar B BarId) 3 (bar B BarId, bar B BarName) return (bar B BarId, bar B BarName, countRows) DWith groupBy you can sort by aggregate functions, like so (we used let to restrict the more general I to SqlExpr (Value Int)) to avoid ambiguity---the second use of I has its type restricted by the :: Int below): r <- select $  \(foo `"` bar) -> do 2 (foo B FooBarId M bar B BarId) 3 $ bar B BarName let countRows' = I 4 [5 countRows'] return (bar B" BarName, countRows') forM_ r $ \(* name, *2 count) -> do print name print (count :: Int) 4ORDER BY clause. See also 5 and 6.Multiple calls to 41 get concatenated on the final query, including <.5,Ascending order of this field or expression.6-Descending order of this field or expression.7LIMIT%. Limit the number of returned rows.8OFFSET. Usually used with 7.9DISTINCT. Change the current SELECT into SELECT DISTINCT. For example: select $ distinct $  \foo -> do ... (Note that this also has the same effect:  select $ ) \foo -> do distinct (return ()) ...  Since: 2.2.4: DISTINCT ON. Change the current SELECT into  SELECT DISTINCT ON (expressions). For example:  select $  \foo -> : [; (foo ^. FooName), ; (foo ^. FooState)] $ do ... &You can also chain different calls to :. The above is equivalent to:  select $  \foo -> : [; (foo ^. FooName)] $ : [; (foo ^. FooState)] $ do ...  Each call to :# adds more expressions. Calls to : override any calls to 9.1Note that PostgreSQL requires the expressions on  DISTINCT ON% to be the first ones to appear on a ORDER BYi. This is not managed automatically by esqueleto, keeping its spirit of trying to be close to raw SQL.Supported by PostgreSQL only. Since: 2.2.4;@Erase an expression's type so that it's suitable to be used by :. Since: 2.2.4<'A convenience function that calls both : and 4. In other words, <+ [asc foo, desc bar, desc quux] $ do ... is the same as: :' [don foo, don bar, don quux] $ do 4' [asc foo, desc bar, desc quux] ...  Since: 2.2.4=ORDER BY random() clause. Since: 1.3.10>HAVING. Since: 1.2.2?1Add a locking clause to the query. Please read % documentation and your RDBMS manual.If multiple calls to ?3 are made on the same query, the last one is used. Since: 2.2.7@Execute a subquery SELECTL in an expression. Returns a simple value so should be used only when the SELECT- query is guaranteed to return just one row.ASame as @ but using SELECT DISTINCT.BProject a field of an entity.C.Project a field of an entity that may be null.D5Lift a constant value from Haskell-land to the query.EIS NULL comparison.F Analogous to \, promotes a value of type typ into one of type  Maybe typ. It should hold that D . Just === just . D.GNULL value.H Join nested ]s in a *O into one. This is useful when calling aggregate functions on nullable fields.ICOUNT(*) value.JCOUNT.KCOUNT(DISTINCT x). Since: 2.4.1aAllow a number of one type to be used as one of another type via an implicit cast. An explicit cast is not made, this function changes only the types on the Haskell side.Caveat: Trying to use castNum from Double to IntZ will not result in an integer, the original fractional number will still be used! Use Z, [ or \ instead.Safety+: This operation is mostly safe due to the ^ constraint between the types and the fact that RDBMSs usually allow numbers of different types to be used interchangeably. However, there may still be issues with the query not being accepted by the RDBMS or  persistent not being able to parse it. Since: 2.2.9bSame as a, but for nullable values. Since: 2.2.9cCOALESCE function. Evaluates the arguments in order and returns the value of the first non-NULL expression, or NULL (Nothing) otherwise. Some RDBMSs (such as SQLite) require at least two arguments; please refer to the appropriate documentation. Since: 1.4.3dLike coalesceu, but takes a non-nullable expression placed at the end of the expression list, which guarantees a non-NULL result. Since: 1.4.3eLOWER function.fLIKE operator.gILIKE operator (case-insensitive LIKE).Supported by PostgreSQL only. Since: 2.2.3h The string h. May be useful while using f and concatenation (i or ja, depending on your database). Note that you always have to type the parenthesis, for example: name `f ` (%) ++. D "John" ++. (%) iThe CONCATT function with a variable number of parameters. Supported by MySQL and PostgreSQL.jThe ||7 string concatenation operator (named after Haskell's _% in order to avoid naming clash with T'). Supported by SQLite and PostgreSQL.kCast a string type into Text4. This function is very useful if you want to use newtype.s, or if you want to apply functions such as f to strings of different types.Safety:[ This is a slightly unsafe function, especially if you have defined your own instances of . Also, since ] is an instance of k, it's possible to turn a nullable value into a non-nullable one. Avoid using this function if possible.lExecute a subquery SELECT. in an expression. Returns a list of values.mSame as sublist_select but using SELECT DISTINCT.n=Lift a list of constant value from Haskell-land to the query.oSame as F but for (D. Most of the time you won't need it, though, because you can use F from inside l or \ from inside n. Since: 2.2.12pIN1 operator. For example if you want to select all Persons by a list of IDs: ,SELECT * FROM Person WHERE Person.id IN (?) In  esqueleto', we may write the same query above as:  select $  $ \person -> do 1 $ person B PersonId `p` n personIds return person Where  personIds is of type  [Key Person].qNOT IN operator.rEXISTS operator. For example:  select $  $ \person -> do 1 $ r $  $ \post -> do 1 (post B BlogPostAuthorId M person B PersonId) return person s NOT EXISTS operator.tSET clause used on UPDATEEs. Note that while it's not a type error to use this function on a SELECT4, it will most certainly result in a runtime error.zApply a  constructor to  expr Value arguments.{ Apply extra  expr Value arguments to a  constructor|CASE statement. For example: select $ return $ | [ ~ (r $  $ \p -> do 1 (p B PersonName M D "Mike"))  (@ $ , $ \v -> do let sub =  $ \c -> do 1 (c B PersonName M D" "Mike") return (c B PersonFavNum) 1 (v B PersonFavNum >. @ sub) return $ J (v B PersonName) +. D (1 :: Int)) ] ( $ D (-1)) LThis query is a bit complicated, but basically it checks if a person named "Mike"x exists, and if that person does, run the subquery to find out how many people have a ranking (by Fav Num) higher than "Mike".NOTE:9 There are a few things to be aware about this statement.fThis only implements the full CASE statement, it does not implement the "simple" CASE statement. At least one ~ and 4 is mandatory otherwise it will emit an error.The C is also mandatory, unlike the SQL statement in which if the ELSE is omitted it will return a NULL#. You can reproduce this via G. Since: 2.1.2}.Convert an entity's key into another entity's.8This function is to be used when you change an entity's Id- to be that of another entity. For example: -Bar barNum Int Foo Id BarId fooNum Int For this example, declare: Pinstance ToBaseId Foo where type BaseEnt Foo = Bar toBaseIdWitness = FooKey )Now you're able to write queries such as: select $  $ (bar `" ` foo) -> do 2 (} (foo B FooId) M bar B BarId) return (bar, foo) ^Note: this function may be unsafe to use in conditions not like the one of the example above. Since: 2.4.3~Syntax sugar for |. Since: 2.1.2Syntax sugar for |. Since: 2.1.2Syntax sugar for |. Since: 2.1.2 Unwrap a *. Since: 1.4.1FROM# clause: bring entities into scope.This function internally uses two type classes in order to provide some flexibility of how you may call it. Internally we refer to these type classes as the two different magics.&The innermost magic allows you to use from with the following types:expr (Entity val),, which brings a single entity into scope.expr (Maybe (Entity val))-, which brings a single entity that may be NULL into scope. Used for  OUTER JOINs.A JOINB of any other two types allowed by the innermost magic, where a JOIN may be an ", a  , a , a , or a . The JOINs have left fixity.&The outermost magic allows you to use fromn on any tuples of types supported by innermost magic (and also tuples of tuples, and so on), up to 8-tuples.Note that using fromz for the same entity twice does work and corresponds to a self-join. You don't even need to use two different calls to from, you may use a JOIN or a tuple.,The following are valid examples of uses of fromH (the types of the arguments of the lambda are inside square brackets):  $ \person -> ...  $ \(person, blogPost) -> ...  $ \(p ` ` mb) -> ...  $ \(p1 `"` f `" ` p2) -> ...  $ \((p1 `"` f) `" ` p2) -> ... CThe types of the arguments to the lambdas above are, respectively: person :: ( Esqueleto query expr backend , PersistEntity Person , PersistEntityBackend Person ~ backend ) => expr (Entity Person) (person, blogPost) :: (...) => (expr (Entity Person), expr (Entity BlogPost)) (p `[` mb) :: (...) => InnerJoin (expr (Entity Person)) (expr (Maybe (Entity BlogPost))) (p1 `"` f `"` p2) :: (...) => InnerJoin (InnerJoin (expr (Entity Person)) (expr (Entity Follow))) (expr (Entity Person)) (p1 `"` (f `"` p2)) :: :: (...) => InnerJoin (expr (Entity Person)) (InnerJoin (expr (Entity Follow)) (expr (Entity Person))) 5Note that some backends may not support all kinds of JOINs. Since: 2.4.0 Since: 2.3.0 Since: 2.3.0 Since: 2.3.0 Since: 2.3.0 Since: 2.3.0 Since: 1.4.4`a  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~  !"#$%&'()*+,zJ8tEh23DuvwxyMRQPONT714=569:;<>?@ABCFGHIKLSUVWXYZ[\^_]`abcdefgijklmnopqrs|}{-./0~,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}*+()&'$%"# !  ~A`a  !"#$%&'()*+,Q-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~222222 2!2"2#2B9 M4N4O4P4Q4R4S3T2U6V6W7X7f2g2j5u3v3w3x3y3None%&*-9:;<=?COT<1(Internal) Class for mapping results coming from  into actual results.This looks very similar to RawSqle, and it is! However, there are some crucial differences and ultimately they're different classes.!Creates the variable part of the SELECT query and returns the list of ,s that will be given to %.(Number of columns that will be consumed.1Transform a row of the result into the data type.Create  INSERT INTO clause instead.,(Internal) Mode of query being converted by .bPhantom type used to mark a  INSERT INTO query.!An expression on the SQL backend.There are many comments describing the constructors of this data type. However, Haddock doesn't like GADTs, so you'll have to read them by hitting "Source".1Information needed to escape and use identifiers.HList of identifiers already in use and supply of temporary identifiers.c Identifier used for table names.dA locking clause.eA LIMIT clause.fA ORDER BY clause.gA HAVING cause.hA GROUP BY clause.i A complete WHERE clause.j A part of a SET clause.k A part of a FROM clause.lThe DISTINCT "clause".mThe default, everything.nOnly DISTINCT, SQL standard.o DISTINCT ON, PostgreSQL extension.pSide data written by .Constraint synonym for  persistent entities whose backend is <.SQL backend for  esqueleto using <.qCollect rs on s!s. Returns the first unmatched r*s data on error. Returns a list without  OnClauses on success.tCreate a fresh c. If possible, use the given .uUse an identifier.#(Internal) Create a case statement. Since: 2.1.11(Internal) Create a custom binary operator. You should not use this function directly since its type is very general, you should always use it with an explicit type signature. For example: e(==.) :: SqlExpr (Value a) -> SqlExpr (Value a) -> SqlExpr (Value Bool) (==.) = unsafeSqlBinOp " = " zIn the example above, we constraint the arguments to be of the same type and constraint the result to be a boolean value. Similar to , but may also be applied to composite keys. Uses the operator given as the second argument whenever applied to composite keys.Usage example: v(==.) :: SqlExpr (Value a) -> SqlExpr (Value a) -> SqlExpr (Value Bool) (==.) = unsafeSqlBinOpComposite " = " " AND " <Persistent has a hack for implementing composite keys (see vU doc for more details), so we're forced to use a hack here as well. We deconstruct w values based on two rules:HIf it is a single placeholder, then it's assumed to be coming from a 7Y and thus its components are separated so that they may be applied to a composite key.If it is not a single placeholder, then it's assumed to be a foreign (composite or not) key, so we enforce that it has no placeholders and split it on the commas.4(Internal) A raw SQL value. The same warning from " applies to this function as well.C(Internal) A raw SQL function. Once again, the same warning from " applies to this function as well.c(Internal) An unsafe SQL function to extract a subfield from a compound field, e.g. datetime. See  for warnings. Since: 1.3.6.xL(Internal) A raw SQL function. Preserves parentheses around arguments. See  for warnings._(Internal) Coerce a value's type from 'SqlExpr (Value a)' to 'SqlExpr (Value b)'. You should not6 use this function unless you know what you're doing!w(Internal) Coerce a value's type from 'SqlExpr (ValueList a)' to 'SqlExpr (Value a)'. Does not work with empty lists.(Internal) Execute an  esqueleto SELECT  inside  persistent's < monad. Execute an  esqueleto SELECT query inside  persistent's < monad and return a y of rows. Execute an  esqueleto SELECT query inside  persistent's <! monad and return a list of rows.We've seen that M has some magic about which kinds of things you may bring into scope. This f function also has some magic for which kinds of things you may bring back to Haskell-land by using SqlQuery's return:You may return a  SqlExpr ( v) for an entity v (i.e., like the *; in SQL), which is then returned to Haskell-land as just Entity v.You may return a SqlExpr (Maybe (Entity v)) for an entity v that may be NULL., which is then returned to Haskell-land as Maybe (Entity v) . Used for  OUTER JOINs.You may return a  SqlExpr (* t) for a value t" (i.e., a single column), where t is any instance of ., which is then returned to Haskell-land as Value t. You may use Value to return projections of an Entity (see (B) and (C)@) or to return any other value calculated on the query (e.g., I or @).The  SqlSelect a rR class has functional dependencies that allow type information to flow both from a to r] and vice-versa. This means that you'll almost never have to give any type signatures for  esqueleto# queries. For example, the query  $ from $ \p -> return p+ alone is ambiguous, but in the context of  do ps <-  $ T $ \p -> return p liftIO $ mapM_ (putStrLn . personName . entityVal) ps &we are able to infer from that single personName . entityVal function composition that the p inside the query is of type SqlExpr (Entity Person). Execute an  esqueleto SELECT DISTINCT query inside  persistent's < monad and return a y of rows. Execute an  esqueleto SELECT DISTINCT query inside  persistent's <! monad and return a list of rows.(Internal) Run a y of rows.(Internal) Execute an  esqueleto statement inside  persistent's < monad. Execute an  esqueleto DELETE query inside  persistent's <b monad. Note that currently there are no type checks for statements that should not appear on a DELETE query.Example of usage:  $  $ \appointment -> 1 (appointment B AppointmentDate Q D now) Unlike !, there is a useful way of using Q that will lead to type ambiguities. If you want to delete all rows (i.e., no 1. clause), you'll have to use a type signature:  $  $ \(appointment ::  ( Appointment)) -> return () Same as *, but returns the number of rows affected. Execute an  esqueleto UPDATE query inside  persistent's <b monad. Note that currently there are no type checks for statements that should not appear on a UPDATE query.Example of usage:  $ \p -> do t p [ PersonAge u F (D thisYear) -. p B PersonBorn ] 1 $ isNothing (p B PersonAge) Same as *, but returns the number of rows affected.(Internal) Pretty prints a  into a SQL query.@Note: if you're curious about the SQL query being generated by  esqueletos, instead of manually using this function (which is possible but tedious), you may just turn on query logging of  persistent.zMaterialize a SqlExpr (Value a). Insert a  for every selected value. Since: 2.4.2 Insert a 5 for every selected value, return the count afterward Insert a ! for every unique selected value.EYou may return tuples (up to 16-tuples) and tuples of tuples from a  query.?You may return any single value (i.e. a single column) from a  query.You may return a possibly-NULL  from a  query.You may return an  from a  query.Not useful for , but used for  and . INSERT INTO hack.{|}~bwvcdefghijksrlmnopqtuxz(({|}~b wvcdefghijksrlmnop qtuxzNone( array_agg&) Concatenate input values, including NULLs, into an array. Since: 2.2.8( string_agg5) Concatenate input values separated by a delimiter. Since: 2.2.8(chrs) Translate the given integer to a character. (Note the result will depend on the character set of your database.) Since: 2.2.11 Input values. Delimiter.Concatenation.None%&9:; valkey i = D .   ( 2https://github.com/prowdsponsor/esqueleto/issues/9).valJ is like val% but for something that is already a Value0. The use case it was written for was, given a Value lift the Key for that Valueu into the query expression in a type safe way. However, the implementation is more generic than that so we call it valJ.Its important to note that the input entity and the output entity are constrained to be the same by the type signature on the function ( 1https://github.com/prowdsponsor/esqueleto/pull/69). Since: 1.4.2 Synonym for  that does not clash with  esqueleto's .      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[  !"#()*+,{z1234=56789:;<>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\^_]`abcdefghijklmnopqrstuvwxy|}~,123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~*+()  "# !z{      !!""##$$%%&'(())**+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~      !"#$%$&$'$($)$*+,+-+.+/+0+12345467879797:7;7<7=7>7?7@7A7B7C7D7E7F7G7H7I7J7K7K7LMNMOMPMQMRMSMTMUMVMVMWMXMYMZM[M[M\M]M^M_M`MaMbMcMdMeMfMgMhMiMjMkMlMmMnMoMpMqMrMsMtuvuwxyxz{|{}{~{{{{      !!"#$%&'()*+,-./0123456789:;<=>? @ABCDEFGHIJKLMNOPQRSTUVVWXYZ[\]^_]^`]ab]^cdefghijklmnopqrstuvwxyz{|}~ns&esqueleto-2.5.2-6F9zrJnTkHQIIQ0dKx9tha$Database.Esqueleto.Internal.LanguageDatabase.Esqueleto.Internal.SqlDatabase.Esqueleto.PostgreSQLDatabase.Esqueleto,Database.Esqueleto.Internal.PersistentImportDatabase.Persist.StoredeleteFromPreprocessFromToBaseIdBaseEnttoBaseIdWitness SqlString LockingKind ForUpdateForShareLockInShareMode InsertionUpdate DistinctOnOrderByPreprocessedFrom$OnClauseWithoutMatchingJoinException IsJoinKind smartJoin reifyJoinKindJoinKind InnerJoinKind CrossJoinKindLeftOuterJoinKindRightOuterJoinKindFullOuterJoinKind FullOuterJoinRightOuterJoin LeftOuterJoin CrossJoin InnerJoin ToSomeValues toSomeValues SomeValue ValueListValue Esqueleto fromStartfromStartMaybefromJoin fromFinishwhere_ongroupByorderByascdesclimitoffsetdistinct distinctOndondistinctOnOrderByrandhavinglocking sub_selectsub_selectDistinct^.?.val isNothingjustnothingjoinV countRowscount countDistinctnot_==.>=.>.<=.<.!=.&&.||.+.-./.*.random_round_ceiling_floor_sum_min_max_avg_castNumcastNumMcoalescecoalesceDefaultlower_likeilike%concat_++. castStringsubList_selectsubList_selectDistinctvalListjustListin_notInexists notExistsset=.+=.-=.*=./=.<#<&>case_toBaseIdwhen_then_else_unValuefrom$$fFromPreprocessqueryexprbackendjoin$$fFromPreprocessqueryexprbackendexpr%$fFromPreprocessqueryexprbackendexpr0$fFromqueryexprbackend(,,,,,,,)$fFromqueryexprbackend(,,,,,,)$fFromqueryexprbackend(,,,,,)$fFromqueryexprbackend(,,,,)$fFromqueryexprbackend(,,,)$fFromqueryexprbackend(,,)$fFromqueryexprbackend(,)#$fFromqueryexprbackendFullOuterJoin$$fFromqueryexprbackendRightOuterJoin#$fFromqueryexprbackendLeftOuterJoin$fFromqueryexprbackendCrossJoin$fFromqueryexprbackendInnerJoin$fFromqueryexprbackendexpr$fFromqueryexprbackendexpr0$fSqlStringMaybe$fSqlStringMarkupM$fSqlStringByteString$fSqlStringText$fSqlStringText0 $fSqlString[]/$fExceptionOnClauseWithoutMatchingJoinException$fIsJoinKindFullOuterJoin$fIsJoinKindRightOuterJoin$fIsJoinKindLeftOuterJoin$fIsJoinKindCrossJoin$fIsJoinKindInnerJoin$fToSomeValuesexpr(,,,,,,,)$fToSomeValuesexpr(,,,,,,)$fToSomeValuesexpr(,,,,,)$fToSomeValuesexpr(,,,,)$fToSomeValuesexpr(,,,)$fToSomeValuesexpr(,,)$fToSomeValuesexpr(,)$fFunctorValue $fEqValue $fOrdValue $fShowValue $fEqValueList$fOrdValueList$fShowValueList $fEqJoinKind($fEqOnClauseWithoutMatchingJoinException)$fOrdOnClauseWithoutMatchingJoinException*$fShowOnClauseWithoutMatchingJoinException SqlSelect sqlSelectColssqlSelectColCountsqlSelectProcessRow sqlInsertIntoModeSELECTDELETEUPDATE INSERT_INTOUnsafeSqlFunctionArgumentSqlExpr IdentInfo IdentState SqlEntitySqlQueryinitialIdentState unsafeSqlCaseunsafeSqlBinOpunsafeSqlBinOpCompositeunsafeSqlValueunsafeSqlFunctionunsafeSqlExtractSubFieldveryUnsafeCoerceSqlExprValue veryUnsafeCoerceSqlExprValueListrawSelectSource selectSourceselectselectDistinctSourceselectDistinct runSource rawEsqueleto deleteCountupdate updateCounttoRawSql insertSelectinsertSelectCountinsertSelectDistinct-$fSqlSelect(,,,,,,,,,,,,,,,)(,,,,,,,,,,,,,,,)+$fSqlSelect(,,,,,,,,,,,,,,)(,,,,,,,,,,,,,,))$fSqlSelect(,,,,,,,,,,,,,)(,,,,,,,,,,,,,)'$fSqlSelect(,,,,,,,,,,,,)(,,,,,,,,,,,,)%$fSqlSelect(,,,,,,,,,,,)(,,,,,,,,,,,)#$fSqlSelect(,,,,,,,,,,)(,,,,,,,,,,)!$fSqlSelect(,,,,,,,,,)(,,,,,,,,,)$fSqlSelect(,,,,,,,,)(,,,,,,,,)$fSqlSelect(,,,,,,,)(,,,,,,,)$fSqlSelect(,,,,,,)(,,,,,,)$fSqlSelect(,,,,,)(,,,,,)$fSqlSelect(,,,,)(,,,,)$fSqlSelect(,,,)(,,,)$fSqlSelect(,,)(,,)$fSqlSelect(,)(,)$fSqlSelectSqlExprValue$fSqlSelectSqlExprMaybe$fSqlSelectSqlExprEntity$fSqlSelect()()$fSqlSelectSqlExprInsertFinal $fUnsafeSqlFunctionArgument(,,,)$fUnsafeSqlFunctionArgument(,,)$fUnsafeSqlFunctionArgument(,)$fUnsafeSqlFunctionArgument[]"$fUnsafeSqlFunctionArgumentSqlExpr$fToSomeValuesSqlExprSqlExpr$$fEsqueletoSqlQuerySqlExprSqlBackend$fMonoidLimitClause$fMonoidGroupByClause$fMonoidWhereClause$fMonoidDistinctClause$fMonoidSideData$fApplicativeSqlQuery$fMonadSqlQuery$fFunctorSqlQueryarrayAgg stringAggchrvalkeyvalJ deleteKey'persistent-2.7.0-1Zxz2tUvugfKmfDTJzN764Database.Persist.SqltransactionUndotransactionSave(Database.Persist.Sql.Orphan.PersistQuerydecorateSQLWithLimitOffset(Database.Persist.Sql.Orphan.PersistStore fieldDBName getFieldName tableDBName getTableName fromSqlKeytoSqlKey withRawQueryDatabase.Persist.Sql.Runclose' withSqlConn askLogFunc createSqlPool withSqlPoolliftSqlPersistMPoolrunSqlPersistMPoolrunSqlPersistM runSqlConn runSqlPoolDatabase.Persist.Sql.MigrationmigraterunMigrationUnsaferunMigrationSilent runMigration getMigration showMigrationprintMigrationparseMigration'parseMigrationDatabase.Persist.Sql.RawrawSql getStmtConnrawExecuteCount rawExecute rawQueryResrawQueryDatabase.Persist.Sql.ClassRawSql rawSqlColsrawSqlColCountReasonrawSqlProcessRowPersistFieldSqlsqlTypeDatabase.Persist toJsonTextDatabase.Persist.Sql.Internal mkColumnsdefaultAttributeDatabase.Persist.Sql.Types ConnectionColumncNamecNullcSqlTypecDefaultcDefaultConstraintNamecMaxLen cReferencePersistentSqlExceptionStatementAlreadyFinalizedCouldn'tGetSQLConnection SqlPersistT SqlPersist SqlPersistMSqlCautiousMigration MigrationConnectionPoolSingleunSingle#Database.Persist.Sql.Types.Internal readToUnknown readToWritewriteToUnknownLogFuncInsertSqlResult ISRSingle ISRInsertGet ISRManyKeys Statement stmtFinalize stmtReset stmtExecute stmtQuery SqlBackend connPrepare connInsertSqlconnInsertManySql connUpsertSql connStmtMap connCloseconnMigrateSql connBegin connCommit connRollbackconnEscapeName connNoLimit connRDBMSconnLimitOffset connLogFunc connMaxParamsSqlReadBackendunSqlReadBackendSqlWriteBackendunSqlWriteBackendSqlBackendCanReadSqlBackendCanWriteSqlReadT SqlWriteT IsSqlBackendDatabase.Persist.Class PersistUnique PersistStore$Database.Persist.Class.DeleteCascade DeleteCascade deleteCascade$Database.Persist.Class.PersistConfig PersistConfigPersistConfigBackendPersistConfigPool loadConfigapplyEnvcreatePoolConfigrunPool$Database.Persist.Class.PersistUnique checkUnique replaceUnique getByValue onlyUniqueinsertByPersistUniqueReadgetByPersistUniqueWritedeleteBy insertUniqueupsertupsertBy#Database.Persist.Class.PersistQuery selectKeysPersistQueryReadselectSourceRes selectFirst selectKeysResPersistQueryWrite updateWhere deleteWhere#Database.Persist.Class.PersistStore insertRecord getEntity insertEntity belongsToJust belongsTo getJustEntitygetJust liftPersistHasPersistBackend BaseBackendpersistBackendIsPersistBackendPersistRecordBackend ToBackendKey toBackendKeyfromBackendKeySqlWriteBackendKeySqlReadBackendKey SqlBackendKeyunSqlWriteBackendKeyunSqlReadBackendKeyunSqlBackendKey PersistCore BackendKeyPersistStoreReadgetPersistStoreWriteinsertinsert_ insertMany insertMany_insertEntityMany insertKeyrepsertreplace updateGet$Database.Persist.Class.PersistEntityfromPersistValueJSONtoPersistValueJSONentityIdFromJSONentityIdToJSONkeyValueEntityFromJSONkeyValueEntityToJSON entityValues PersistEntityUniqueKeyPersistEntityBackend EntityField keyToValues keyFromValuespersistIdField entityDefpersistFieldDeftoPersistFieldsfromPersistValuespersistUniqueKeyspersistUniqueToFieldNamespersistUniqueToValues fieldLensBackendSpecificUpdateEntity entityKey entityVal#Database.Persist.Class.PersistField PersistFieldtoPersistValuefromPersistValueSomePersistFieldDatabase.Persist.Types.BasefromPersistValueTexttoEmbedEntityDefkeyAndEntityFieldsentityKeyFields entityPrimary CheckmarkActiveInactive IsNullableNullable NotNullable WhyNullable ByMaybeAttrByNullableAttr EntityDef entityHaskellentityDBentityId entityAttrs entityFields entityUniquesentityForeigns entityDerives entityExtra entitySum ExtraLine HaskellName unHaskellNameDBNameunDBNameAttr FieldType FTTypeConFTAppFTListFieldDef fieldHaskellfieldDB fieldType fieldSqlType fieldAttrs fieldStrictfieldReference ReferenceDef NoReference ForeignRefEmbedRef CompositeRef SelfReferenceEmbedEntityDefembeddedHaskellembeddedFields EmbedFieldDef emFieldDB emFieldEmbed emFieldCycle UniqueDef uniqueHaskell uniqueDBName uniqueFields uniqueAttrs CompositeDefcompositeFieldscompositeAttrsForeignFieldDef ForeignDefforeignRefTableHaskellforeignRefTableDBNameforeignConstraintNameHaskellforeignConstraintNameDBName foreignFields foreignAttrsforeignNullablePersistException PersistErrorPersistMarshalErrorPersistInvalidFieldPersistForeignConstraintUnmetPersistMongoDBErrorPersistMongoDBUnsupported PersistValue PersistTextPersistByteString PersistInt64 PersistDoublePersistRational PersistBool PersistDayPersistTimeOfDayPersistUTCTime PersistNull PersistList PersistMapPersistObjectIdPersistDbSpecificSqlTypeSqlInt32SqlInt64SqlReal SqlNumericSqlBoolSqlDaySqlTime SqlDayTimeSqlBlobSqlOther PersistFilterEqNeGtLtGeLeInNotInUpdateException KeyNotFound UpsertErrorOnlyUniqueException PersistUpdateAssignAddSubtractMultiplyDividebaseGHC.BaseJustMaybeGHC.NumNum++fromPreprocessfrom_ InsertFinalIdent LockingClause LimitClause OrderByClause HavingClause GroupByClause WhereClause SetClause FromClauseDistinctClause DistinctAllDistinctStandardSideDatacollectOnClausesOnClauseFromJoin newIdentForuseIdent ECompositeKeyERawunsafeSqlFunctionParens%conduit-1.2.10-10hxedihSO1AWyrWQ67vYjData.Conduit.Internal.ConduitSourcematerializeExpr toArgList OrderByTypeASCDESC NeedParensParensNeverEEntityEMaybeEList EEmptyListEOrderBy EOrderRandom EDistinctOnESetEPreprocessedFromEInsert EInsertFinalinUseILimitGroupByWhereNoWhere FromStartsdDistinctClause sdFromClause sdSetClause sdWhereClausesdGroupByClausesdHavingClausesdOrderByClause sdLimitClausesdLockingClauseQunQparensM fieldNamesetAuxsub fromDBName existsHelperifNotEmptyList countHelper builderToTextuncommas intersperseB uncommas'makeInsertInto makeSelectmakeFromunexpectedCompositeKeyErrormakeSet makeWhere makeGroupBy makeHaving makeOrderBy makeLimit makeLockingparens getEntityValfrom3Pfrom3to3from4Pfrom4to4from5Pto5from6Pto6from7Pto7from8Pto8from9Pto9from10Pto10from11Pto11from12Pto12from13Pto13from14Pto14from15Pto15from16Pto16