fiddlerwoaroof/dotfiles - Change WT4JFKWS6AXYN5CS2NJF7FAJGQQZB7ZV5LEURBSWPCE74LKMFBZAC

feat(file=indexer): consistent timestamp

Created by Ed L on June 19, 2024

WT4JFKWS6AXYN5CS2NJF7FAJGQQZB7ZV5LEURBSWPCE74LKMFBZAC

Dependencies

In channels

main

Change contents

File deletion: dependencies, dependencies
BFD:BFD[3.1] → [4.129:152]
BFD:BFD[3.1] → [4.129:152]
BFD:BFD[4.152] → [4.128:128]

Replacement in tools/file-indexer.lisp at line 13 [5.86]

B:BD[5.369] → [5.369:427]

(ql:quickload '(:net.didierverna.clon :ironclad :sqlite))

[5.369]

[5.427]

(ql:quickload '(:net.didierverna.clon :ironclad :sqlite :local-time))

Insertion in tools/file-indexer.lisp at line 19 [5.86]

[5.520]


(defparameter +my-format+
  '((:YEAR 4) #\- (:MONTH 2) #\- (:DAY 2) #\Space
    (:HOUR 2) #\: (:MIN 2) #\: (:SEC 2)))
(defun now-time ()
  (local-time:format-timestring nil 
                                (local-time:now)
                                :format +my-format+))

Insertion in tools/file-indexer.lisp at line 31 [5.86]
[5.618]
[5.618]
```
    (stropt :long-name "ts" :env-var "FWOAR_TX_TS")
```
Deletion in tools/file-indexer.lisp at line 34 [5.86]
∅:D[6.87] → [5.665:666]
B:BD[5.665] → [5.665:666]

Replacement in tools/file-indexer.lisp at line 36 [5.86]

B:BD[5.757] → [7.86:137]

         (net.didierverna.clon:*context* context))

[5.757]

[5.837]

         (net.didierverna.clon:*context* context)
         (ts (or (net.didierverna.clon:getopt :context context
                                              :long-name "ts")
                 (now-time))))
    (format *error-output* "Got ts: ~a~%" ts)

Replacement in tools/file-indexer.lisp at line 72 [5.86]

B:BD[6.770] → [8.444:621]

                                                     "insert into files_shasums (file,shasum,size,count)
                                                      values (?,?,?, 1)

[6.770]

[8.621]

                                                     "insert into files_shasums (file,shasum,size,count,ts)
                                                      values (?,?,?, 1,?)

Replacement in tools/file-indexer.lisp at line 75 [5.86]

B:BD[8.722] → [8.722:826]

                                                                                ts = current_timestamp"

[8.722]

[9.86]

                                                                                ts = excluded.ts"

Replacement in tools/file-indexer.lisp at line 78 [5.86]

B:BD[6.1155] → [8.827:898]

                                                     length)))))))))))

[6.1155]

[5.3759]

                                                     length
                                                     ts)))))))))))