Thank you very much for documenting this here. That's greatly appreciated!
2017-01-20 11:05 GMT+01:00 <[email protected]>:
> I had the same scenario for the CIDR field rather than INET (the same can
> be done for it with a differnet field such as INETAddress)
>
> In my case i binding the cidr data type to SubnetUtils.SubnetInfo from
> apache-commons-net
>
>
> package my.package;
>
>
> import org.apache.commons.net.util.SubnetUtils;
> import org.jooq.Binding;
> import org.jooq.BindingGetResultSetContext;
> import org.jooq.BindingGetSQLInputContext;
> import org.jooq.BindingGetStatementContext;
> import org.jooq.BindingRegisterContext;
> import org.jooq.BindingSQLContext;
> import org.jooq.BindingSetSQLOutputContext;
> import org.jooq.BindingSetStatementContext;
> import org.jooq.Converter;
> import org.jooq.impl.DSL;
>
>
> import java.sql.SQLException;
> import java.sql.SQLFeatureNotSupportedException;
> import java.sql.Types;
> import java.util.Objects;
>
>
> /**
> * We're binding <T> = Object (unknown JDBC type), and <U> =
> SubnetUtils.SubnetInfo (user type)
> * @author aaron.axisa
> */
> public class PostgresCIDRSubnetInfoBinding implements Binding<Object,
> SubnetUtils.SubnetInfo> {
>
>
> @Override
> public Converter<Object, SubnetUtils.SubnetInfo> converter() {
> return CidrConverter.getInstance();
> }
>
>
> /**
> * The converter does all the conversion
> */
> private static class CidrConverter implements Converter<Object,
> SubnetUtils.SubnetInfo> {
>
>
> private static CidrConverter INSTANCE = new CidrConverter();
>
>
> private CidrConverter() {
> // we want spring to override the static INSTANCE when it
> launches
> INSTANCE = this;
> }
>
>
> /**
> * @return The singleton instance for {@link CidrConverter}
> */
> public static CidrConverter getInstance() {
> return INSTANCE;
> }
>
>
> @Override
> public SubnetUtils.SubnetInfo from(final Object t) {
> // convert the Postgres data type to json
> return t == null ? null : new SubnetUtils(t.toString()).getI
> nfo();
> }
>
>
> @Override
> public Object to(final SubnetUtils.SubnetInfo u) {
> // convert the json to the Postgres data type
> return u == null ? null : u.getAddress()+u.getCidrSignature(); //
> TODO
> }
>
>
> @Override
> public Class<Object> fromType() {
> return Object.class;
> }
>
>
> @Override
> public Class<SubnetUtils.SubnetInfo> toType() {
> return SubnetUtils.SubnetInfo.class;
> }
>
>
> }
>
>
> // Rending a bind variable for the binding context's value and
> casting it to the cidr type
> @Override
> public void sql(BindingSQLContext<SubnetUtils.SubnetInfo> ctx) throws
> SQLException {
> ctx.render().visit(DSL.val(ctx.convert(converter()).value())).sql(
> "::cidr");
> }
>
>
> // Registering VARCHAR types for JDBC CallableStatement OUT parameters
> @Override
> public void register(BindingRegisterContext<SubnetUtils.SubnetInfo>
> ctx) throws SQLException {
> ctx.statement().registerOutParameter(ctx.index(), Types.VARCHAR);
> }
>
>
> // Converting the SubnetInfo to a String value and setting that on a
> JDBC PreparedStatement
> @Override
> public void set(BindingSetStatementContext<SubnetUtils.SubnetInfo> ctx
> ) throws SQLException {
> ctx.statement().setString(ctx.index(), Objects.toString(ctx.
> convert(converter()).value(), null));
> }
>
>
> // Getting a String value from a JDBC ResultSet and converting that
> to a SubnetInfo
> @Override
> public void get(BindingGetResultSetContext<SubnetUtils.SubnetInfo> ctx
> ) throws SQLException {
> ctx.convert(converter()).value(ctx.resultSet().getString(ctx.index
> ()));
> }
>
>
> // Getting a String value from a JDBC CallableStatement and
> converting that to a JsonElement
> @Override
> public void get(BindingGetStatementContext<SubnetUtils.SubnetInfo> ctx
> ) throws SQLException {
> ctx.convert(converter()).value(ctx.statement().getString(ctx.index
> ()));
> }
>
>
> // Setting a value on a JDBC SQLOutput (useful for Oracle OBJECT
> types)
> @Override
> public void set(BindingSetSQLOutputContext<SubnetUtils.SubnetInfo> ctx
> ) throws SQLException {
> throw new SQLFeatureNotSupportedException();
> }
>
>
> // Getting a value from a JDBC SQLInput (useful for Oracle OBJECT
> types)
> @Override
> public void get(BindingGetSQLInputContext<SubnetUtils.SubnetInfo> ctx)
> throws SQLException {
> throw new SQLFeatureNotSupportedException();
> }
> }
>
>
> And then in your pom file for the generation plugin add the following:
>
> <customTypes>
> <customType>
> <name>SubnetInfo</name>
> <type>org.apache.commons.net.util.SubnetUtils.SubnetInfo</type>
> <binding>my.package.PostgresCIDRSubnetInfoBinding</binding>
> </customType>
> </customTypes>
>
>
> <forcedTypes>
> <forcedType>
> <name>SubnetInfo</name>
> <types>CIDR</types>
> </forcedType>
> </forcedTypes>
>
> --
> You received this message because you are subscribed to the Google Groups
> "jOOQ User Group" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> For more options, visit https://groups.google.com/d/optout.
>
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
