Commitff368ea

committed

Add some jooq helpers and bump version

1 parentfc94c20 commitff368eaCopy full SHA for ff368ea

File tree

+108

-1

lines changed

+108

-1

lines changed

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -21,7 +21,7 @@ allprojects {`
`21`	`21`
`22`	`22`	`// Using Jitpack so I need the repo name in the group to match.`
`23`	`23`	`group='com.stubbornjava.StubbornJava'`
`24`		`- version='0.1.23-SNAPSHOT'`
	`24`	`+ version='0.1.24-SNAPSHOT'`
`25`	`25`
`26`	`26`	`repositories {`
`27`	`27`	`mavenLocal()`

Lines changed: 2 additions & 0 deletions

Lines changed: 40 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,40 @@`
	`1`	`+packagecom.stubbornjava.common.db.jooq;`
	`2`	`+`
	`3`	`+importjava.util.Arrays;`
	`4`	`+importjava.util.List;`
	`5`	`+`
	`6`	`+importjavax.sql.DataSource;`
	`7`	`+`
	`8`	`+importorg.jooq.SQLDialect;`
	`9`	`+importorg.jooq.impl.DataSourceConnectionProvider;`
	`10`	`+importorg.jooq.impl.DefaultConfiguration;`
	`11`	`+importorg.jooq.util.jaxb.ForcedType;`
	`12`	`+`
	`13`	`+importcom.google.common.collect.Lists;`
	`14`	`+`
	`15`	`+publicclassJooqConfig {`
	`16`	`+`
	`17`	`+publicstaticDefaultConfigurationdefaultConfigFromDataSource(DataSourceds) {`
	`18`	`+DataSourceConnectionProviderdcp =newDataSourceConnectionProvider(ds);`
	`19`	`+DefaultConfigurationjooqConfig =newDefaultConfiguration();`
	`20`	`+jooqConfig.set(SQLDialect.MYSQL);`
	`21`	`+jooqConfig.set(dcp);`
	`22`	`+returnjooqConfig;`
	`23`	`+ }`
	`24`	`+`
	`25`	`+publicstaticList<ForcedType>defaultForcedTypes() {`
	`26`	`+returnLists.newLinkedList(Arrays.asList(newForcedType[] {`
	`27`	`+forcedType("BOOLEAN","tinyint",Boolean.class),`
	`28`	`+forcedType("LocalDate","date",LocalDateConverter.class),`
	`29`	`+forcedType("LocalDateTime","datetime",LocalDateTimeConverter.class)`
	`30`	`+ }));`
	`31`	`+ }`
	`32`	`+`
	`33`	`+privatestaticForcedTypeforcedType(Stringname,Stringtypes,Class<?>clazz) {`
	`34`	`+ForcedTypetype =newForcedType();`
	`35`	`+type.setName(name);`
	`36`	`+type.setTypes(types);`
	`37`	`+type.setConverter(clazz.getName());`
	`38`	`+returntype;`
	`39`	`+ }`
	`40`	`+}`

Lines changed: 33 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,33 @@`
	`1`	`+packagecom.stubbornjava.common.db.jooq;`
	`2`	`+`
	`3`	`+importorg.jooq.Converter;`
	`4`	`+`
	`5`	`+importjava.sql.Date;`
	`6`	`+importjava.time.Instant;`
	`7`	`+importjava.time.LocalDate;`
	`8`	`+importjava.time.LocalDateTime;`
	`9`	`+importjava.time.ZoneId;`
	`10`	`+`
	`11`	`+publicclassLocalDateConverterimplementsConverter<Date,LocalDate> {`
	`12`	`+`
	`13`	`+@Override`
	`14`	`+publicLocalDatefrom(Datedate) {`
	`15`	`+returnnull ==date ?null :LocalDateTime.ofInstant(Instant.ofEpochMilli(date.getTime()),ZoneId.systemDefault()).toLocalDate();`
	`16`	`+ }`
	`17`	`+`
	`18`	`+@Override`
	`19`	`+publicDateto(LocalDatelocalDate) {`
	`20`	`+returnnull ==localDate ?null :java.sql.Date.valueOf(localDate);`
	`21`	`+ }`
	`22`	`+`
	`23`	`+@Override`
	`24`	`+publicClass<Date>fromType() {`
	`25`	`+returnDate.class;`
	`26`	`+ }`
	`27`	`+`
	`28`	`+@Override`
	`29`	`+publicClass<LocalDate>toType() {`
	`30`	`+returnLocalDate.class;`
	`31`	`+ }`
	`32`	`+`
	`33`	`+}`

Lines changed: 32 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -0,0 +1,32 @@`
	`1`	`+packagecom.stubbornjava.common.db.jooq;`
	`2`	`+`
	`3`	`+importorg.jooq.Converter;`
	`4`	`+`
	`5`	`+importjava.sql.Timestamp;`
	`6`	`+importjava.time.Instant;`
	`7`	`+importjava.time.LocalDateTime;`
	`8`	`+importjava.time.ZoneId;`
	`9`	`+`
	`10`	`+publicclassLocalDateTimeConverterimplementsConverter<Timestamp,LocalDateTime> {`
	`11`	`+`
	`12`	`+@Override`
	`13`	`+publicLocalDateTimefrom(Timestampdate) {`
	`14`	`+returnnull ==date ?null :LocalDateTime.ofInstant(Instant.ofEpochMilli(date.getTime()),ZoneId.systemDefault());`
	`15`	`+ }`
	`16`	`+`
	`17`	`+@Override`
	`18`	`+publicTimestampto(LocalDateTimelocalDate) {`
	`19`	`+returnnull ==localDate ?null :Timestamp.from(localDate.atZone(ZoneId.systemDefault()).toInstant());`
	`20`	`+ }`
	`21`	`+`
	`22`	`+@Override`
	`23`	`+publicClass<Timestamp>fromType() {`
	`24`	`+returnTimestamp.class;`
	`25`	`+ }`
	`26`	`+`
	`27`	`+@Override`
	`28`	`+publicClass<LocalDateTime>toType() {`
	`29`	`+returnLocalDateTime.class;`
	`30`	`+ }`
	`31`	`+`
	`32`	`+}`

Comments

(0)