org.jaxdb.sqlx.PostgreSQLCompiler Maven / Gradle / Ivy

Go to download

Show more of this group Show more artifacts with this name
Show all versions of sqlx Show documentation

SQLx is a vendor-agnostic, XML-based SQL data definition standard that offers the power of XML validation for your static SQL data. The SQLx framework utilizes a strongly-typed DDLx file to generate a XML Schema document that translates DDLx constructs into the XSD language. With the SQLx XSLT, the SQLx tool leverages the power of XML Schema Validation and provides a cohesive structured model to define SQL data (that conforms to your SQL schema, defined in a DDLx file).

There is a newer version: 0.6.0

Show newest version

/* Copyright (c) 2017 JAX-DB
 *
 * Permission is hereby granted, free of charge, to any person obtaining a copy
 * of this software and associated documentation files (the "Software"), to deal
 * in the Software without restriction, including without limitation the rights
 * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell
 * copies of the Software, and to permit persons to whom the Software is
 * furnished to do so, subject to the following conditions:
 *
 * The above copyright notice and this permission notice shall be included in
 * all copies or substantial portions of the Software.
 *
 * You should have received a copy of The MIT License (MIT) along with this
 * program. If not, see .
 */

package org.jaxdb.sqlx;

import org.jaxdb.ddlx.dt;
import org.jaxdb.vendor.DBVendor;
import org.libj.util.Bytes;
import org.libj.util.Hexadecimal;

final class PostgreSQLCompiler extends Compiler {
  @Override
  protected DBVendor getVendor() {
    return DBVendor.POSTGRE_SQL;
  }

  private static String toOctalString(final Hexadecimal hex) {
    final short[] octals = Bytes.toOctal(hex.getData());
    final StringBuilder builder = new StringBuilder();
    for (final short octal : octals)
      builder.append("\\\\").append(octal);

    return "'" + builder + "'::BYTEA";
  }

  @Override
  protected String compile(final dt.BINARY value) {
    return toOctalString(new Hexadecimal(value.get()));
  }

  @Override
  protected String compile(final dt.BLOB value) {
    return toOctalString(new Hexadecimal(value.get()));
  }
}