/* Ċ Ġ* ĠThis Ġis Ġfree Ġand Ġun enc umber ed Ġsoftware Ġreleased Ġinto Ġthe Ġpublic Ġdomain , Ġfollowing Ġ< https :// un license . org > Ċ Ġ*/ Ċ Ċ package Ġorg . u fo ss . kot ys a . spring . jdbc . postgresql Ċ Ċ import Ġorg . assertj . core . api . Assertions . assertThat Ċ import Ġorg . junit . jupiter . api . Before All Ċ import Ġorg . junit . jupiter . api . Test Ċ import Ġorg . springframework . jdbc . core . Jdbc Operations Ċ import Ġorg . u fo ss . kot ys a . spring . jdbc . sql Client Ċ import Ġorg . u fo ss . kot ys a . test .* Ċ import Ġorg . u fo ss . kot ys a . test . hooks . Test Containers Closeable Resource Ċ import Ġjava . time . LocalDateTime ĊĊ Ċ class ĠSpring Jdbc Select LocalDateTime Postgres ql Test Ġ: ĠAbstract Spring Jdbc Postgres ql Test < LocalDateTime Repository Postgres ql Select >() Ġ{ ĊĊĠĠĠ Ġ@ Before All ĊĠĠĠ Ġfun Ġbefore All ( resource : ĠTest Containers Closeable Resource ) Ġ{ ĊĠĠĠĠĠĠĠ Ġcontext Ġ= Ġstart Context < LocalDateTime Repository Postgres ql Select >( resource ) ĊĠĠĠ Ġ} ĊĊĠĠĠ Ġoverride Ġval Ġrepository : ĠLocalDateTime Repository Postgres ql Select Ġby Ġlazy Ġ{ ĊĠĠĠĠĠĠĠ ĠgetContext Repository () ĊĠĠĠ Ġ} ĊĊĠĠĠ Ġ@ Test ĊĠĠĠ Ġfun Ġ` Verify Ġselect All By LocalDateTime NotNull Ġfinds Ġlocal DateTime As Timestamp With Nullable `() Ġ{ ĊĠĠĠĠĠĠĠ ĠassertThat ( repository . selectAll By LocalDateTime NotNull ( LocalDateTime . of ( 2 0 1 9 , Ġ 1 1 , Ġ 4 , Ġ 0 , Ġ 0 ))) ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ. has Size ( 1 ) ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ. contains Exactly In Any Order ( local DateTime As Timestamp With Nullable ) ĊĠĠĠ Ġ} ĊĊĠĠĠ Ġ@ Test ĊĠĠĠ Ġfun Ġ` Verify Ġselect All By LocalDateTime NotNull Not Eq Ġfinds Ġlocal DateTime As Timestamp Without Nullable `() Ġ{ ĊĠĠĠĠĠĠĠ ĠassertThat ( repository . selectAll By LocalDateTime NotNull Not Eq ( LocalDateTime . of ( 2 0 1 9 , Ġ 1 1 , Ġ 4 , Ġ 0 , Ġ 0 ))) ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ. has Size ( 1 ) ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ. contains Exactly In Any Order ( local DateTime As Timestamp Without Nullable ) ĊĠĠĠ Ġ} ĊĊĠĠĠ Ġ@ Test ĊĠĠĠ Ġfun Ġ` Verify Ġselect All By LocalDateTime NotNull In Ġfinds Ġboth `() Ġ{ ĊĠĠĠĠĠĠĠ Ġval Ġseq Ġ= Ġsequence Of ( ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġlocal DateTime With Nullable . local DateTime NotNull , ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġlocal DateTime Without Nullable . local DateTime NotNull ) ĊĠĠĠĠĠĠĠ ĠassertThat ( repository . selectAll By LocalDateTime NotNull In ( seq )) ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ. has Size ( 2 ) ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ. contains Exactly In Any Order ( local DateTime As Timestamp With Nullable , Ġlocal DateTime As Timestamp Without Nullable ) ĊĠĠĠ Ġ} ĊĊĠĠĠ Ġ@ Test ĊĠĠĠ Ġfun Ġ` Verify Ġselect All By LocalDateTime NotNull Before Ġfinds Ġlocal DateTime As Timestamp With Nullable `() Ġ{ ĊĠĠĠĠĠĠĠ ĠassertThat ( repository . selectAll By LocalDateTime NotNull Before ( LocalDateTime . of ( 2 0 1 9 , Ġ 1 1 , Ġ 4 , Ġ 1 2 , Ġ 0 ))) ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ. has Size ( 1 ) ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ. contains Exactly In Any Order ( local DateTime As Timestamp With Nullable ) ĊĠĠĠ Ġ} ĊĊĠĠĠ Ġ@ Test ĊĠĠĠ Ġfun Ġ` Verify Ġselect All By LocalDateTime NotNull Before Ġfinds Ġno Ġresults Ġwhen Ġequals `() Ġ{ ĊĠĠĠĠĠĠĠ ĠassertThat ( repository . selectAll By LocalDateTime NotNull Before ( LocalDateTime . of ( 2 0 1 9 , Ġ 1 1 , Ġ 4 , Ġ 0 , Ġ 0 ))) ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ. isEmpty () ĊĠĠĠ Ġ} ĊĊĠĠĠ Ġ@ Test ĊĠĠĠ Ġfun Ġ` Verify Ġselect All By LocalDateTime NotNull Before Or Eq Ġfinds Ġlocal DateTime As Timestamp With Nullable `() Ġ{ ĊĠĠĠĠĠĠĠ ĠassertThat ( repository . selectAll By LocalDateTime NotNull Before Or Eq ( LocalDateTime . of ( 2 0 1 9 , Ġ 1 1 , Ġ 4 , Ġ 1 2 , Ġ 0 ))) ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ. has Size ( 1 ) ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ. contains Exactly In Any Order ( local DateTime As Timestamp With Nullable ) ĊĠĠĠ Ġ} ĊĊĠĠĠ Ġ@ Test ĊĠĠĠ Ġfun Ġ` Verify Ġselect All By LocalDateTime NotNull Before Or Eq Ġfinds Ġlocal DateTime As Timestamp With Nullable Ġwhen Ġequals `() Ġ{ ĊĠĠĠĠĠĠĠ ĠassertThat ( repository . selectAll By LocalDateTime NotNull Before Or Eq ( LocalDateTime . of ( 2 0 1 9 , Ġ 1 1 , Ġ 4 , Ġ 0 , Ġ 0 ))) ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ. has Size ( 1 ) ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ. contains Exactly In Any Order ( local DateTime As Timestamp With Nullable ) ĊĠĠĠ Ġ} ĊĊĠĠĠ Ġ@ Test ĊĠĠĠ Ġfun Ġ` Verify Ġselect All By LocalDateTime NotNull After Ġfinds Ġlocal DateTime As Timestamp Without Nullable `() Ġ{ ĊĠĠĠĠĠĠĠ ĠassertThat ( repository . selectAll By LocalDateTime NotNull After ( LocalDateTime . of ( 2 0 1 9 , Ġ 1 1 , Ġ 5 , Ġ 1 2 , Ġ 0 ))) ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ. has Size ( 1 ) ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ. contains Exactly In Any Order ( local DateTime As Timestamp Without Nullable ) ĊĠĠĠ Ġ} ĊĊĠĠĠ Ġ@ Test ĊĠĠĠ Ġfun Ġ` Verify Ġselect All By LocalDateTime NotNull After Ġfinds Ġno Ġresults Ġwhen Ġequals `() Ġ{ ĊĠĠĠĠĠĠĠ ĠassertThat ( repository . selectAll By LocalDateTime NotNull After ( LocalDateTime . of ( 2 0 1 9 , Ġ 1 1 , Ġ 6 , Ġ 0 , Ġ 0 ))) ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ. isEmpty () ĊĠĠĠ Ġ} ĊĊĠĠĠ Ġ@ Test ĊĠĠĠ Ġfun Ġ` Verify Ġselect All By LocalDateTime NotNull After Or Eq Ġfinds Ġlocal DateTime As Timestamp Without Nullable `() Ġ{ ĊĠĠĠĠĠĠĠ ĠassertThat ( repository . selectAll By LocalDateTime NotNull After Or Eq ( LocalDateTime . of ( 2 0 1 9 , Ġ 1 1 , Ġ 5 , Ġ 1 2 , Ġ 0 ))) ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ. has Size ( 1 ) ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ. contains Exactly In Any Order ( local DateTime As Timestamp Without Nullable ) ĊĠĠĠ Ġ} ĊĊĠĠĠ Ġ@ Test ĊĠĠĠ Ġfun Ġ` Verify Ġselect All By LocalDateTime NotNull After Or Eq Ġfinds Ġlocal DateTime As Timestamp Without Nullable Ġwhen Ġequals `() Ġ{ ĊĠĠĠĠĠĠĠ ĠassertThat ( repository . selectAll By LocalDateTime NotNull After Or Eq ( LocalDateTime . of ( 2 0 1 9 , Ġ 1 1 , Ġ 6 , Ġ 0 , Ġ 0 ))) ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ. has Size ( 1 ) ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ. contains Exactly In Any Order ( local DateTime As Timestamp Without Nullable ) ĊĠĠĠ Ġ} ĊĊĠĠĠ Ġ@ Test ĊĠĠĠ Ġfun Ġ` Verify Ġselect All By LocalDateTime Nullable Ġfinds Ġlocal DateTime As Timestamp With Nullable `() Ġ{ ĊĠĠĠĠĠĠĠ ĠassertThat ( repository . selectAll By LocalDateTime Nullable ( LocalDateTime . of ( 2 0 1 8 , Ġ 1 1 , Ġ 4 , Ġ 0 , Ġ 0 ))) ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ. has Size ( 1 ) ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ. contains Exactly In Any Order ( local DateTime As Timestamp With Nullable ) ĊĠĠĠ Ġ} ĊĊĠĠĠ Ġ@ Test ĊĠĠĠ Ġfun Ġ` Verify Ġselect All By LocalDateTime Nullable Ġfinds Ġlocal DateTime As Timestamp Without Nullable `() Ġ{ ĊĠĠĠĠĠĠĠ ĠassertThat ( repository . selectAll By LocalDateTime Nullable ( null )) ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ. has Size ( 1 ) ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ. contains Exactly In Any Order ( local DateTime As Timestamp Without Nullable ) ĊĠĠĠ Ġ} ĊĊĠĠĠ Ġ@ Test ĊĠĠĠ Ġfun Ġ` Verify Ġselect All By LocalDateTime Nullable Not Eq Ġfinds Ġlocal DateTime As Timestamp With Nullable `() Ġ{ ĊĠĠĠĠĠĠĠ ĠassertThat ( repository . selectAll By LocalDateTime Nullable Not Eq ( LocalDateTime . of ( 2 0 1 8 , Ġ 1 1 , Ġ 4 , Ġ 0 , Ġ 0 ))) ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ. isEmpty () ĊĠĠĠ Ġ} ĊĊĠĠĠ Ġ@ Test ĊĠĠĠ Ġfun Ġ` Verify Ġselect All By LocalDateTime Nullable Not Eq Ġfinds Ġno Ġresults `() Ġ{ ĊĠĠĠĠĠĠĠ ĠassertThat ( repository . selectAll By LocalDateTime Nullable Not Eq ( null )) ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ. has Size ( 1 ) ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ. contains Exactly In Any Order ( local DateTime As Timestamp With Nullable ) ĊĠĠĠ Ġ} ĊĊĠĠĠ Ġ@ Test ĊĠĠĠ Ġfun Ġ` Verify Ġselect All By LocalDateTime Nullable Before Ġfinds Ġlocal DateTime As Timestamp With Nullable `() Ġ{ ĊĠĠĠĠĠĠĠ ĠassertThat ( repository . selectAll By LocalDateTime Nullable Before ( LocalDateTime . of ( 2 0 1 8 , Ġ 1 1 , Ġ 4 , Ġ 1 2 , Ġ 0 ))) ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ. has Size ( 1 ) ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ. contains Exactly In Any Order ( local DateTime As Timestamp With Nullable ) ĊĠĠĠ Ġ} ĊĊĠĠĠ Ġ@ Test ĊĠĠĠ Ġfun Ġ` Verify Ġselect All By LocalDateTime Nullable Before Ġfinds Ġno Ġresults Ġwhen Ġequals `() Ġ{ ĊĠĠĠĠĠĠĠ ĠassertThat ( repository . selectAll By LocalDateTime Nullable Before ( LocalDateTime . of ( 2 0 1 8 , Ġ 1 1 , Ġ 4 , Ġ 0 , Ġ 0 ))) ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ. isEmpty () ĊĠĠĠ Ġ} ĊĊĠĠĠ Ġ@ Test ĊĠĠĠ Ġfun Ġ` Verify Ġselect All By LocalDateTime Nullable Before Or Eq Ġfinds Ġlocal DateTime As Timestamp With Nullable `() Ġ{ ĊĠĠĠĠĠĠĠ ĠassertThat ( repository . selectAll By LocalDateTime Nullable Before Or Eq ( LocalDateTime . of ( 2 0 1 8 , Ġ 1 1 , Ġ 5 , Ġ 1 2 , Ġ 0 ))) ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ. has Size ( 1 ) ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ. contains Exactly In Any Order ( local DateTime As Timestamp With Nullable ) ĊĠĠĠ Ġ} ĊĊĠĠĠ Ġ@ Test ĊĠĠĠ Ġfun Ġ` Verify Ġselect All By LocalDateTime Nullable Before Or Eq Ġfinds Ġlocal DateTime As Timestamp With Nullable Ġwhen Ġequals `() Ġ{ ĊĠĠĠĠĠĠĠ ĠassertThat ( repository . selectAll By LocalDateTime Nullable Before Or Eq ( LocalDateTime . of ( 2 0 1 8 , Ġ 1 1 , Ġ 4 , Ġ 0 , Ġ 0 ))) ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ. has Size ( 1 ) ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ. contains Exactly In Any Order ( local DateTime As Timestamp With Nullable ) ĊĠĠĠ Ġ} ĊĊĠĠĠ Ġ@ Test ĊĠĠĠ Ġfun Ġ` Verify Ġselect All By LocalDateTime Nullable After Ġfinds Ġlocal DateTime As Timestamp Without Nullable `() Ġ{ ĊĠĠĠĠĠĠĠ ĠassertThat ( repository . selectAll By LocalDateTime Nullable After ( LocalDateTime . of ( 2 0 1 8 , Ġ 1 1 , Ġ 3 , Ġ 1 2 , Ġ 0 ))) ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ. has Size ( 1 ) ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ. contains Exactly In Any Order ( local DateTime As Timestamp With Nullable ) ĊĠĠĠ Ġ} ĊĊĠĠĠ Ġ@ Test ĊĠĠĠ Ġfun Ġ` Verify Ġselect All By LocalDateTime Nullable After Ġfinds Ġno Ġresults Ġwhen Ġequals `() Ġ{ ĊĠĠĠĠĠĠĠ ĠassertThat ( repository . selectAll By LocalDateTime Nullable After ( LocalDateTime . of ( 2 0 1 8 , Ġ 1 1 , Ġ 4 , Ġ 0 , Ġ 0 ))) ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ. isEmpty () ĊĠĠĠ Ġ} ĊĊĠĠĠ Ġ@ Test ĊĠĠĠ Ġfun Ġ` Verify Ġselect All By LocalDateTime Nullable After Or Eq Ġfinds Ġlocal DateTime As Timestamp Without Nullable `() Ġ{ ĊĠĠĠĠĠĠĠ ĠassertThat ( repository . selectAll By LocalDateTime Nullable After Or Eq ( LocalDateTime . of ( 2 0 1 8 , Ġ 1 1 , Ġ 3 , Ġ 1 2 , Ġ 0 ))) ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ. has Size ( 1 ) ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ. contains Exactly In Any Order ( local DateTime As Timestamp With Nullable ) ĊĠĠĠ Ġ} ĊĊĠĠĠ Ġ@ Test ĊĠĠĠ Ġfun Ġ` Verify Ġselect All By LocalDateTime Nullable After Or Eq Ġfinds Ġlocal DateTime As Timestamp Without Nullable Ġwhen Ġequals `() Ġ{ ĊĠĠĠĠĠĠĠ ĠassertThat ( repository . selectAll By LocalDateTime Nullable After Or Eq ( LocalDateTime . of ( 2 0 1 8 , Ġ 1 1 , Ġ 4 , Ġ 0 , Ġ 0 ))) ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ. has Size ( 1 ) ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ. contains Exactly In Any Order ( local DateTime As Timestamp With Nullable ) ĊĠĠĠ Ġ} Ċ } ĊĊ Ċ class ĠLocalDateTime Repository Postgres ql Select ( client : ĠJdbc Operations ) Ġ: ĠRepository Ġ{ ĊĊĠĠĠ Ġprivate Ġval Ġsql Client Ġ= Ġclient . sql Client ( postgresql Tables ) ĊĊĠĠĠ Ġoverride Ġfun Ġinit () Ġ{ ĊĠĠĠĠĠĠĠ Ġcreate Tables () ĊĠĠĠĠĠĠĠ Ġinsert LocalDateTime s () ĊĠĠĠ Ġ} ĊĊĠĠĠ Ġoverride Ġfun Ġdelete () Ġ{ ĊĠĠĠĠĠĠĠ Ġdelete All () ĊĠĠĠ Ġ} ĊĊĠĠĠ Ġprivate Ġfun Ġcreate Tables () Ġ{ ĊĠĠĠĠĠĠĠ Ġsql Client Ġcreate Table ĠPOST GRE SQL _ LOCAL _ DATE _ TIME ĊĠĠĠ Ġ} ĊĊĠĠĠ Ġprivate Ġfun Ġinsert LocalDateTime s () Ġ{ ĊĠĠĠĠĠĠĠ Ġsql Client . insert ( local DateTime As Timestamp With Nullable , Ġlocal DateTime As Timestamp Without Nullable ) ĊĠĠĠ Ġ} ĊĊĠĠĠ Ġprivate Ġfun Ġdelete All () Ġ= Ġsql Client Ġdelete All From ĠPOST GRE SQL _ LOCAL _ DATE _ TIME ĊĊĠĠĠ Ġfun Ġselect All By LocalDateTime NotNull ( local DateTime : ĠLocalDateTime ) Ġ= ĊĠĠĠĠĠĠĠĠĠĠĠ Ġ( sql Client Ġselect From ĠPOST GRE SQL _ LOCAL _ DATE _ TIME ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġwhere ĠPOST GRE SQL _ LOCAL _ DATE _ TIME . local DateTime NotNull Ġeq Ġlocal DateTime ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ). fetch All () ĊĊĠĠĠ Ġfun Ġselect All By LocalDateTime NotNull Not Eq ( local DateTime : ĠLocalDateTime ) Ġ= ĊĠĠĠĠĠĠĠĠĠĠĠ Ġ( sql Client Ġselect From ĠPOST GRE SQL _ LOCAL _ DATE _ TIME ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġwhere ĠPOST GRE SQL _ LOCAL _ DATE _ TIME . local DateTime NotNull Ġnot Eq Ġlocal DateTime ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ). fetch All () ĊĊĠĠĠ Ġfun Ġselect All By LocalDateTime NotNull In ( values : ĠSequence < LocalDateTime >) Ġ= ĊĠĠĠĠĠĠĠĠĠĠĠ Ġ( sql Client Ġselect From ĠPOST GRE SQL _ LOCAL _ DATE _ TIME ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġwhere ĠPOST GRE SQL _ LOCAL _ DATE _ TIME . local DateTime NotNull Ġ` in ` Ġvalues ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ). fetch All () ĊĊĠĠĠ Ġfun Ġselect All By LocalDateTime NotNull Before ( local DateTime : ĠLocalDateTime ) Ġ= ĊĠĠĠĠĠĠĠĠĠĠĠ Ġ( sql Client Ġselect From ĠPOST GRE SQL _ LOCAL _ DATE _ TIME ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġwhere ĠPOST GRE SQL _ LOCAL _ DATE _ TIME . local DateTime NotNull Ġbefore Ġlocal DateTime ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ). fetch All () ĊĊĠĠĠ Ġfun Ġselect All By LocalDateTime NotNull Before Or Eq ( local DateTime : ĠLocalDateTime ) Ġ= ĊĠĠĠĠĠĠĠĠĠĠĠ Ġ( sql Client Ġselect From ĠPOST GRE SQL _ LOCAL _ DATE _ TIME ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġwhere ĠPOST GRE SQL _ LOCAL _ DATE _ TIME . local DateTime NotNull Ġbefore Or Eq Ġlocal DateTime ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ). fetch All () ĊĊĠĠĠ Ġfun Ġselect All By LocalDateTime NotNull After ( local DateTime : ĠLocalDateTime ) Ġ= ĊĠĠĠĠĠĠĠĠĠĠĠ Ġ( sql Client Ġselect From ĠPOST GRE SQL _ LOCAL _ DATE _ TIME ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġwhere ĠPOST GRE SQL _ LOCAL _ DATE _ TIME . local DateTime NotNull Ġafter Ġlocal DateTime ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ). fetch All () ĊĊĠĠĠ Ġfun Ġselect All By LocalDateTime NotNull After Or Eq ( local DateTime : ĠLocalDateTime ) Ġ= ĊĠĠĠĠĠĠĠĠĠĠĠ Ġ( sql Client Ġselect From ĠPOST GRE SQL _ LOCAL _ DATE _ TIME ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġwhere ĠPOST GRE SQL _ LOCAL _ DATE _ TIME . local DateTime NotNull Ġafter Or Eq Ġlocal DateTime ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ). fetch All () ĊĊĠĠĠ Ġfun Ġselect All By LocalDateTime Nullable ( local DateTime : ĠLocalDateTime ?) Ġ= ĊĠĠĠĠĠĠĠĠĠĠĠ Ġ( sql Client Ġselect From ĠPOST GRE SQL _ LOCAL _ DATE _ TIME ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġwhere ĠPOST GRE SQL _ LOCAL _ DATE _ TIME . local DateTime Nullable Ġeq Ġlocal DateTime ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ). fetch All () ĊĊĠĠĠ Ġfun Ġselect All By LocalDateTime Nullable Not Eq ( local DateTime : ĠLocalDateTime ?) Ġ= ĊĠĠĠĠĠĠĠĠĠĠĠ Ġ( sql Client Ġselect From ĠPOST GRE SQL _ LOCAL _ DATE _ TIME ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġwhere ĠPOST GRE SQL _ LOCAL _ DATE _ TIME . local DateTime Nullable Ġnot Eq Ġlocal DateTime ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ). fetch All () ĊĊĠĠĠ Ġfun Ġselect All By LocalDateTime Nullable Before ( local DateTime : ĠLocalDateTime ) Ġ= ĊĠĠĠĠĠĠĠĠĠĠĠ Ġ( sql Client Ġselect From ĠPOST GRE SQL _ LOCAL _ DATE _ TIME ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġwhere ĠPOST GRE SQL _ LOCAL _ DATE _ TIME . local DateTime Nullable Ġbefore Ġlocal DateTime ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ). fetch All () ĊĊĠĠĠ Ġfun Ġselect All By LocalDateTime Nullable Before Or Eq ( local DateTime : ĠLocalDateTime ) Ġ= ĊĠĠĠĠĠĠĠĠĠĠĠ Ġ( sql Client Ġselect From ĠPOST GRE SQL _ LOCAL _ DATE _ TIME ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġwhere ĠPOST GRE SQL _ LOCAL _ DATE _ TIME . local DateTime Nullable Ġbefore Or Eq Ġlocal DateTime ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ). fetch All () ĊĊĠĠĠ Ġfun Ġselect All By LocalDateTime Nullable After ( local DateTime : ĠLocalDateTime ) Ġ= ĊĠĠĠĠĠĠĠĠĠĠĠ Ġ( sql Client Ġselect From ĠPOST GRE SQL _ LOCAL _ DATE _ TIME ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġwhere ĠPOST GRE SQL _ LOCAL _ DATE _ TIME . local DateTime Nullable Ġafter Ġlocal DateTime ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ). fetch All () ĊĊĠĠĠ Ġfun Ġselect All By LocalDateTime Nullable After Or Eq ( local DateTime : ĠLocalDateTime ) Ġ= ĊĠĠĠĠĠĠĠĠĠĠĠ Ġ( sql Client Ġselect From ĠPOST GRE SQL _ LOCAL _ DATE _ TIME ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġwhere ĠPOST GRE SQL _ LOCAL _ DATE _ TIME . local DateTime Nullable Ġafter Or Eq Ġlocal DateTime ĊĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠĠ Ġ). fetch All () Ċ } Ċ