示例#1
0
  final FieldList getSelect1() {
    if (getSelect0().isEmpty()) {
      FieldList result = new SelectFieldList();

      // [#109] [#489]: SELECT * is only applied when at least one table
      // from the table source is "unknown", i.e. not generated from a
      // physical table. Otherwise, the fields are selected explicitly
      if (knownTableSource()) {
        for (TableLike<?> table : getFrom()) {
          for (Field<?> field : table.asTable().fields()) {
            result.add(field);
          }
        }
      }

      // The default is SELECT 1, when projections and table sources are
      // both empty
      if (getFrom().isEmpty()) {
        result.add(one());
      }

      return result;
    }

    return getSelect0();
  }
  @Override
  public List<ConnectorStatus> getChargePointConnectorStatus() {
    // Prepare for the inner select of the second join
    Field<Integer> t1Pk = CONNECTOR_STATUS.CONNECTOR_PK.as("t1_pk");
    Field<DateTime> t1Max = DSL.max(CONNECTOR_STATUS.STATUS_TIMESTAMP).as("t1_max");
    TableLike<?> t1 =
        ctx.select(t1Pk, t1Max)
            .from(CONNECTOR_STATUS)
            .groupBy(CONNECTOR_STATUS.CONNECTOR_PK)
            .asTable("t1");

    return ctx.select(
            CHARGE_BOX.CHARGE_BOX_PK,
            CONNECTOR.CHARGE_BOX_ID,
            CONNECTOR.CONNECTOR_ID,
            CONNECTOR_STATUS.STATUS_TIMESTAMP,
            CONNECTOR_STATUS.STATUS,
            CONNECTOR_STATUS.ERROR_CODE)
        .from(CONNECTOR_STATUS)
        .join(CONNECTOR)
        .onKey()
        .join(CHARGE_BOX)
        .on(CHARGE_BOX.CHARGE_BOX_ID.eq(CONNECTOR.CHARGE_BOX_ID))
        .join(t1)
        .on(CONNECTOR_STATUS.CONNECTOR_PK.equal(t1.field(t1Pk)))
        .and(CONNECTOR_STATUS.STATUS_TIMESTAMP.equal(t1.field(t1Max)))
        .orderBy(CONNECTOR_STATUS.STATUS_TIMESTAMP.desc())
        .fetch()
        .map(
            r ->
                ConnectorStatus.builder()
                    .chargeBoxPk(r.value1())
                    .chargeBoxId(r.value2())
                    .connectorId(r.value3())
                    .timeStamp(DateTimeUtils.humanize(r.value4()))
                    .status(r.value5())
                    .errorCode(r.value6())
                    .build());
  }
示例#3
0
  SelectQueryImpl(Configuration configuration, TableLike<? extends R> from, boolean distinct) {
    super(configuration);

    this.distinct = distinct;
    this.select = new SelectFieldList();
    this.from = new TableList();
    this.condition = new ConditionProviderImpl();
    this.connectBy = new ConditionProviderImpl();
    this.connectByStartWith = new ConditionProviderImpl();
    this.groupBy = new QueryPartList<GroupField>();
    this.having = new ConditionProviderImpl();
    this.orderBy = new SortFieldList();
    this.limit = new Limit();

    if (from != null) {
      this.from.add(from.asTable());
    }

    this.forUpdateOf = new FieldList();
    this.forUpdateOfTables = new TableList();
  }
示例#4
0
 @Override
 public final void addFrom(Collection<? extends TableLike<?>> f) {
   for (TableLike<?> provider : f) {
     getFrom().add(provider.asTable());
   }
 }