1 ! Copyright (C) 2008 Doug Coleman.
2 ! See https://factorcode.org/license.txt for BSD license.
3 USING: accessors arrays byte-arrays classes classes.tuple
4 combinators continuations db db.errors db.tuples
5 db.tuples.private db.types destructors kernel lexer make math
6 math.bitwise math.intervals math.parser namespaces nmake
7 peg.search random sequences strings strings.parser ;
10 GENERIC: where ( specs obj -- )
13 : <likeexp> ( string -- <likeexp> )
16 : parse-like ( accum -- accum )
17 lexer get skip-blank parse-string <likeexp> suffix! ;
19 SYNTAX: LIKE" parse-like ; ! "
22 : make-retryable ( obj -- obj' )
24 [ make-retryable ] map
30 : maybe-make-retryable ( statement -- statement )
31 dup in-params>> [ generator-bind? ] any?
32 [ make-retryable ] when ;
34 : regenerate-params ( statement -- statement )
36 [ bind-params>> ] [ in-params>> ] bi
39 generator-singleton>> eval-generator >>value
43 ] 2map >>bind-params ;
45 M: retryable execute-statement*
46 drop [ retries>> <iota> ] [
49 [ query-results dispose t ]
51 [ regenerate-params bind-statement* f ] cleanup
53 ] bi attempt-all drop ;
55 : sql-props ( class -- columns table )
56 [ db-columns ] [ db-table-name ] bi ;
58 : query-make ( ..a class quot: ( ..a columns table -- ..b ) -- ..b statements )
59 ! query, input, outputs, secondary queries
61 '[ 0 sql-counter [ dup "table-name" set @ ] with-variable ]
62 { "" { } { } { } } nmake
63 [ <simple-statement> maybe-make-retryable ] dip
64 [ [ 1array ] dip append ] unless-empty ; inline
66 : where-primary-key% ( specs -- )
71 dup column-name>> 0% " = " 0% bind%
74 M: db-connection <update-tuple-statement>
79 [ ", " 0% ] [ dup column-name>> 0% " = " 0% bind% ] interleave
83 M: random-id-generator eval-generator
85 system-random-generator get [
86 63 [ random-bits ] keep 1 - set-bit
89 : interval-comparison ( ? str -- str )
90 "from" = " >" " <" ? swap [ "= " append ] when ;
92 : (infinite-interval?) ( interval -- ?1 ?2 )
93 [ from>> ] [ to>> ] bi
94 [ first fp-infinity? ] bi@ ;
96 : double-infinite-interval? ( obj -- ? )
97 dup interval? [ (infinite-interval?) and ] [ drop f ] if ;
99 : infinite-interval? ( obj -- ? )
100 dup interval? [ (infinite-interval?) or ] [ drop f ] if ;
102 : where-interval ( spec obj from/to -- )
103 over first fp-infinity? [
106 pick column-name>> 0%
107 [ first2 ] dip interval-comparison 0%
111 : in-parens ( quot -- )
112 "(" 0% call ")" 0% ; inline
116 [ from>> "from" where-interval ] [
117 nip infinite-interval? [ " and " 0% ] unless
118 ] [ to>> "to" where-interval ] 2tri
123 [ " or " 0% ] [ dupd where ] interleave drop
127 over column-name>> 0% " = " 0% bind# ;
130 drop column-name>> 0% " is NULL" 0% ;
132 : object-where ( spec obj -- )
133 over column-name>> 0% " = " 0% bind# ;
135 M: object where object-where ;
137 M: integer where object-where ;
139 M: string where object-where ;
141 : like-where ( spec obj -- )
142 text>> over column-name>> 0% " LIKE " 0% bind# ;
144 M: likeexp where like-where ;
146 : filter-slots ( tuple specs -- specs' )
148 slot-name>> swap get-slot-named
149 dup double-infinite-interval? [ drop f ] when
152 : many-where ( tuple seq -- )
156 2dup slot-name>> swap get-slot-named where
159 : where-clause ( tuple specs -- )
160 dupd filter-slots [ drop ] [ many-where ] if-empty ;
162 M: db-connection <delete-tuples-statement>
168 ERROR: all-slots-ignored class ;
170 M: db-connection <select-by-slots-statement>
173 [ dupd filter-ignores ] dip
174 over empty? [ all-slots-ignored ] when
177 [ dup column-name>> 0% 2, ] interleave
182 : do-group ( tuple groups -- )
183 dup string? [ 1array ] when
184 [ ", " join " group by " glue ] curry change-sql drop ;
186 : do-order ( tuple order -- )
187 dup string? [ 1array ] when
188 [ ", " join " order by " glue ] curry change-sql drop ;
190 : do-offset ( tuple n -- )
191 [ number>string " offset " glue ] curry change-sql drop ;
193 : do-limit ( tuple n -- )
194 [ number>string " limit " glue ] curry change-sql drop ;
196 : make-query* ( tuple query -- tuple' )
199 [ group>> [ drop ] [ do-group ] if-empty ]
200 [ order>> [ drop ] [ do-order ] if-empty ]
201 [ limit>> [ do-limit ] [ drop ] if* ]
202 [ offset>> [ do-offset ] [ drop ] if* ]
205 M: db-connection query>statement
206 [ tuple>> dup class-of ] keep
207 [ <select-by-slots-statement> ] dip make-query* ;
209 ! select ID, NAME, SCORE from EXAM limit 1 offset 3
211 M: db-connection <count-statement>
212 [ tuple>> dup class-of ] keep
213 [ [ "select count(*) from " 0% 0% where-clause ] query-make ]
216 : create-index ( index-name table-name columns -- )
218 [ [ "create index " % % ] dip " on " % % ] dip "(" %
220 ] "" make sql-command ;
222 : ensure-index ( index-name table-name columns -- )
223 '[ _ _ _ create-index ] ignore-index-exists ;
225 : drop-index ( index-name -- )
226 [ "drop index " % % ] "" make sql-command ;
228 : create-database ( string -- )
229 "create database " ";" surround sql-command ;
231 : ensure-database ( string -- )
232 '[ _ create-database ] ignore-database-exists ;