Embed Notice

HTML Code

<blockquote style="position: relative; padding-left: 55px;"><section><a href="https://mstdn.in.th/users/veer66/statuses/112583221536089274">veer66 (veer66@mstdn.in.th)'s status on Monday, 10-Jun-2024 04:43:44 JST</a><a href="https://mstdn.in.th/@veer66" title="veer66@mstdn.in.th"><img src="https://gnusocial.jp/avatar/174073-48-20250827193701.webp" width="48" height="48" alt="veer66" style="position: absolute; left: 0; top: 0;">veer66</a></section><article><p>Prepare to generate SQL in <a href="https://mstdn.in.th/tags/Clojure" rel="tag">#Clojure</a> and <a href="https://mstdn.in.th/tags/Golang" rel="tag">#Golang</a> </p><p>Go's main advantage lies in its familiarity for programmers from various languages like Pascal, Java, JavaScript, Python, and C.</p><p>Clojure Spec fits in data validation and generate an explanation as Exception's message.</p><p>Moreover, instead of using the mutable builder pattern like a data mapper for Go, Clojure with HoneySQL uses plain data structure, so writing a unit test is simple.</p></article><footer><a rel="bookmark" href="https://gnusocial.jp/conversation/3216789#notice-6352827">In conversation</a><time datetime="2024-06-10T04:43:44+09:00" title="Monday, 10-Jun-2024 04:43:44 JST">Monday, 10-Jun-2024 04:43:44 JST</time> <span>from <span><a href="https://mstdn.in.th/@veer66/112583221536089274" rel="external" title="Sent from mstdn.in.th via ActivityPub">mstdn.in.th</a></span></span><a href="https://mstdn.in.th/@veer66/112583221536089274">permalink</a><h4>Attachments</h4><ol><li><label><a rel="external" href="https://gnusocial.jp/attachment/2760374">LEFT
(s/def :db1/orders (s/coll-of (s/tuple #{:title :created :status} #{:+ :-})))
(defn orders-&gt;map [orders] 
  (when-not (s/valid? :db1/orders orders)
    (throw (ex-info (s/explain-data :db1/orders orders))))
  (-&gt;&gt; orders
       (mapv #(let [[field order-dir] %] 
                [field (case order-dir
                         :+ :asc
                         :- :desc)]))
       (array-map :order-by)))
(deftest generate-orders-maps
  (is (= {:order-by []}
         (orders-&gt;map [])))
  (is (= {:order-by [[:title :desc]]}
         (orders-&gt;map [[:title :-]])))
  (is (= {:order-by [[:status :asc]]}
         (orders-&gt;map [[:status :+]]))))RIGHT
func buildOrders(builder *squirrel.SelectBuilder, orders []entity.Order) error {
    for _, order := range orders {
        var fieldName string
        switch order.Field {
        case entity.Title:
            fieldName = "title"
        case entity.Date:
            fieldName = "created"
        case entity.Status:
            fieldName = "status"
        default:
            return fmt.Errorf("invalid field: %d", order.Field)
        }
        var sortOrder string
        switch order.SortingOrder {
        case entity.ASC:
            sortOrder = "ASC"
        case entity.DESC:
            sortOrder = "DESC"
        default:
            return fmt.Errorf("invalid sorting order: %d", order.SortingOrder)
        }
        orderExpr := fieldName + " " + sortOrder
        *builder = builder.OrderBy(orderExpr)
    }
    return nil
}</a></label><br><a href="https://storage.mstdn.in.th/media_attachments/files/112/583/203/414/255/902/original/c571add5bfaaf23a.png" rel="external">https://storage.mstdn.in.th/media_attachments/files/112/583/203/414/255/902/original/c571add5bfaaf23a.png</a></li></ol></footer></blockquote>

Corresponding Notice

Embed this notice
veer66 (veer66@mstdn.in.th)'s status on Monday, 10-Jun-2024 04:43:44 JST veer66
Prepare to generate SQL in #Clojure and #Golang
Go's main advantage lies in its familiarity for programmers from various languages like Pascal, Java, JavaScript, Python, and C.
Clojure Spec fits in data validation and generate an explanation as Exception's message.
Moreover, instead of using the mutable builder pattern like a data mapper for Go, Clojure with HoneySQL uses plain data structure, so writing a unit test is simple.
In conversationMonday, 10-Jun-2024 04:43:44 JST from mstdn.in.thpermalink
Attachments
1. LEFT (s/def :db1/orders (s/coll-of (s/tuple #{:title :created :status} #{:+ :-}))) (defn orders->map [orders] (when-not (s/valid? :db1/orders orders) (throw (ex-info (s/explain-data :db1/orders orders)))) (->> orders (mapv #(let [[field order-dir] %] [field (case order-dir :+ :asc :- :desc)])) (array-map :order-by))) (deftest generate-orders-maps (is (= {:order-by []} (orders->map []))) (is (= {:order-by [[:title :desc]]} (orders->map [[:title :-]]))) (is (= {:order-by [[:status :asc]]} (orders->map [[:status :+]])))) RIGHT func buildOrders(builder *squirrel.SelectBuilder, orders []entity.Order) error { for _, order := range orders { var fieldName string switch order.Field { case entity.Title: fieldName = "title" case entity.Date: fieldName = "created" case entity.Status: fieldName = "status" default: return fmt.Errorf("invalid field: %d", order.Field) } var sortOrder string switch order.SortingOrder { case entity.ASC: sortOrder = "ASC" case entity.DESC: sortOrder = "DESC" default: return fmt.Errorf("invalid sorting order: %d", order.SortingOrder) } orderExpr := fieldName + " " + sortOrder *builder = builder.OrderBy(orderExpr) } return nil }
  https://storage.mstdn.in.th/media_attachments/files/112/583/203/414/255/902/original/c571add5bfaaf23a.png

Public

Embed Notice

HTML Code

Corresponding Notice