All Downloads are FREE. Search and download functionalities are using the official Maven repository.
  • Log In
  • Register

    • info.archinnov.achilles.generated.dsl.EntitySensor_Select Maven / Gradle / Ivy

    package info.archinnov.achilles.generated.dsl;

import com.datastax.driver.core.querybuilder.QueryBuilder;
import com.datastax.driver.core.querybuilder.Select;
import info.archinnov.achilles.generated.meta.entity.EntitySensor_AchillesMeta;
import info.archinnov.achilles.internals.entities.EntitySensor;
import info.archinnov.achilles.internals.metamodel.AbstractEntityProperty;
import info.archinnov.achilles.internals.metamodel.functions.FunctionCall;
import info.archinnov.achilles.internals.options.Options;
import info.archinnov.achilles.internals.query.dsl.select.AbstractSelect;
import info.archinnov.achilles.internals.query.dsl.select.AbstractSelectColumns;
import info.archinnov.achilles.internals.query.dsl.select.AbstractSelectFrom;
import info.archinnov.achilles.internals.query.dsl.select.AbstractSelectWhere;
import info.archinnov.achilles.internals.query.dsl.select.AbstractSelectWherePartition;
import info.archinnov.achilles.internals.runtime.RuntimeEngine;
import info.archinnov.achilles.type.SchemaNameProvider;
import info.archinnov.achilles.validation.Validator;
import java.lang.Class;
import java.lang.Integer;
import java.lang.Long;
import java.lang.Object;
import java.lang.Override;
import java.lang.String;
import java.lang.SuppressWarnings;
import java.util.Arrays;
import java.util.List;
import java.util.stream.Collectors;
import org.apache.commons.lang3.ArrayUtils;

public final class EntitySensor_Select extends AbstractSelect {
  protected final EntitySensor_AchillesMeta meta;

  protected final Class entityClass = EntitySensor.class;

  public EntitySensor_Select(RuntimeEngine rte, EntitySensor_AchillesMeta meta) {
    super(rte);
    this.meta = meta;
  }

  /**
   * Generate a SELECT ... sensor_id ... */
  public final EntitySensor_Select.EntitySensor_SelectColumns sensorId() {
    select.column("sensor_id");
    return new EntitySensor_Select.EntitySensor_SelectColumns(select);
  }

  /**
   * Generate a SELECT ... date ... */
  public final EntitySensor_Select.EntitySensor_SelectColumns date() {
    select.column("date");
    return new EntitySensor_Select.EntitySensor_SelectColumns(select);
  }

  /**
   * Generate a SELECT ... type ... */
  public final EntitySensor_Select.EntitySensor_SelectColumns type() {
    select.column("type");
    return new EntitySensor_Select.EntitySensor_SelectColumns(select);
  }

  /**
   * Generate a SELECT ... value ... */
  public final EntitySensor_Select.EntitySensor_SelectColumns value() {
    select.column("value");
    return new EntitySensor_Select.EntitySensor_SelectColumns(select);
  }

  /**
   * Use this method to call a system or user-defined function.
    All the system functions are accessible from the {@link info.archinnov.achilles.generated.function.SystemFunctions} class
    All the user-defined functions and aggregates are accessible from the {@link info.archinnov.achilles.generated.function.FunctionsRegistry} class
    System and user-defined functions accept only appropriate type. To pass in an entity field as function argument, use the generated manager.COLUMNS class which exposes all columns with their appropriate type
    Example: 
    
   *   {@literal @}Table
   *   public class MyEntity {
   *
   *       ...
   *
   *       {@literal @}Column("value_column")
   *       private String value;
   *
   *       {@literal @}Column("list_of_string")
   *       private List strings;
   *
   *       ...
   *
   *   }
   *
   *   {@literal @}FunctionsRegistry
   *   public interface MyFunctions {
   *
   *        String convertListToJson(List strings);
   *
   *   }
   *
   *
   *   ...
   *
   *
   *   manager
   *      .dsl()
   *      .select()
   *      // This call will generate SELECT cast(writetime(value_column) as text) AS writetimeOfValueAsString, ...
   *      .function(SystemFunctions.castAsText(SystemFunctions.writetime(manager.COLUMNS.VALUE)), "writetimeOfValueAsString")
   *      ...
   *
   *   manager 
   *      .dsl()
   *      .select()
   *      // This call will generate SELECT convertlisttojson(list_of_string) AS strings_as_json, ...
   *      .function(FunctionsRegistry.convertListToJson(manager.COLUMNS.STRINGS), "strings_as_json")
   *      ...
   *
   * 
    
   * 
    
   * @param functionCall the function call object 
   * @param alias mandatory alias for this function call for easier retrieval from the ResultSet 
   * @return a built-in function call passed to the QueryBuilder object 
   */
  public final EntitySensor_Select.EntitySensor_SelectColumns function(final FunctionCall functionCall, final String alias) {
    functionCall.addToSelect(select, alias);
    return new EntitySensor_Select.EntitySensor_SelectColumns(select);
  }

  /**
   * Generate ... * FROM ... */
  public final EntitySensor_Select.EntitySensor_SelectFrom allColumns_FromBaseTable() {
    final Select.Where where = select.all().from(meta.getKeyspace().orElse("unknown_keyspace_for_" + meta.entityClass.getCanonicalName()), meta.getTableOrViewName()).where();
    return new EntitySensor_Select.EntitySensor_SelectFrom(where);
  }

  /**
   * Generate ... * FROM ... using the given SchemaNameProvider */
  public final EntitySensor_Select.EntitySensor_SelectFrom allColumns_From(final SchemaNameProvider schemaNameProvider) {
    final String currentKeyspace = lookupKeyspace(schemaNameProvider, meta.entityClass);
    final String currentTable = lookupTable(schemaNameProvider, meta.entityClass);
    final Select.Where where = select.all().from(currentKeyspace, currentTable).where();
    return new EntitySensor_Select.EntitySensor_SelectFrom(where);
  }

  public class EntitySensor_SelectColumns extends AbstractSelectColumns {
    public EntitySensor_SelectColumns(Select.Selection selection) {
      super(selection);
    }

    /**
     * Generate a SELECT ... sensor_id ... */
    public final EntitySensor_Select.EntitySensor_SelectColumns sensorId() {
      selection.column("sensor_id");
      return this;
    }

    /**
     * Generate a SELECT ... date ... */
    public final EntitySensor_Select.EntitySensor_SelectColumns date() {
      selection.column("date");
      return this;
    }

    /**
     * Generate a SELECT ... type ... */
    public final EntitySensor_Select.EntitySensor_SelectColumns type() {
      selection.column("type");
      return this;
    }

    /**
     * Generate a SELECT ... value ... */
    public final EntitySensor_Select.EntitySensor_SelectColumns value() {
      selection.column("value");
      return this;
    }

    /**
     * Use this method to call a system or user-defined function.
    All the system functions are accessible from the {@link info.archinnov.achilles.generated.function.SystemFunctions} class
    All the user-defined functions and aggregates are accessible from the {@link info.archinnov.achilles.generated.function.FunctionsRegistry} class
    System and user-defined functions accept only appropriate type. To pass in an entity field as function argument, use the generated manager.COLUMNS class which exposes all columns with their appropriate type
    Example: 
    
     *   {@literal @}Table
     *   public class MyEntity {
     *
     *       ...
     *
     *       {@literal @}Column("value_column")
     *       private String value;
     *
     *       {@literal @}Column("list_of_string")
     *       private List strings;
     *
     *       ...
     *
     *   }
     *
     *   {@literal @}FunctionsRegistry
     *   public interface MyFunctions {
     *
     *        String convertListToJson(List strings);
     *
     *   }
     *
     *
     *   ...
     *
     *
     *   manager
     *      .dsl()
     *      .select()
     *      // This call will generate SELECT cast(writetime(value_column) as text) AS writetimeOfValueAsString, ...
     *      .function(SystemFunctions.castAsText(SystemFunctions.writetime(manager.COLUMNS.VALUE)), "writetimeOfValueAsString")
     *      ...
     *
     *   manager 
     *      .dsl()
     *      .select()
     *      // This call will generate SELECT convertlisttojson(list_of_string) AS strings_as_json, ...
     *      .function(FunctionsRegistry.convertListToJson(manager.COLUMNS.STRINGS), "strings_as_json")
     *      ...
     *
     * 
    
     * 
    
     * @param functionCall the function call object 
     * @param alias mandatory alias for this function call for easier retrieval from the ResultSet 
     * @return a built-in function call passed to the QueryBuilder object 
     */
    public final EntitySensor_Select.EntitySensor_SelectColumns function(final FunctionCall functionCall, final String alias) {
      functionCall.addToSelect(selection, alias);
      return this;
    }

    /**
     * Generate a ... FROM xxx ...  */
    public final EntitySensor_Select.EntitySensor_SelectFrom fromBaseTable() {
      final Select.Where where = selection.from(meta.getKeyspace().orElse("unknown_keyspace_for_" + meta.entityClass.getCanonicalName()), meta.getTableOrViewName()).where();
      return new EntitySensor_Select.EntitySensor_SelectFrom(where);
    }

    /**
     * Generate a ... FROM xxx ... using the given SchemaNameProvider */
    public final EntitySensor_Select.EntitySensor_SelectFrom from(final SchemaNameProvider schemaNameProvider) {
      final String currentKeyspace = lookupKeyspace(schemaNameProvider, meta.entityClass);
      final String currentTable = lookupTable(schemaNameProvider, meta.entityClass);
      final Select.Where where = selection.from(currentKeyspace, currentTable).where();
      return new EntitySensor_Select.EntitySensor_SelectFrom(where);
    }
  }

  public class EntitySensor_SelectFrom extends AbstractSelectFrom {
    EntitySensor_SelectFrom(Select.Where where) {
      super(where);
    }

    /**
     * Generate a SELECT ... FROM ... WHERE ... */
    public final EntitySensor_Select.EntitySensor_SelectWhere_SensorId where() {
      return new EntitySensor_Select.EntitySensor_SelectWhere_SensorId(where);
    }

    /**
     * Generate a SELECT statement without the WHERE clause */
    public final EntitySensor_Select.EntitySensor_SelectEnd without_WHERE_Clause() {
      return new EntitySensor_Select.EntitySensor_SelectEnd(where);
    }
  }

  public final class EntitySensor_SelectWhere_SensorId extends AbstractSelectWherePartition {
    public EntitySensor_SelectWhere_SensorId(Select.Where where) {
      super(where);
    }

    /**
     * Generate a SELECT ... FROM ... WHERE ... sensor_id = ? */
    @SuppressWarnings("static-access")
    public final EntitySensor_Select.EntitySensor_SelectWhere_Date sensorId_Eq(Long sensorId) {
      where.and(QueryBuilder.eq("sensor_id", QueryBuilder.bindMarker("sensorId_Eq")));
      boundValues.add(sensorId);
      encodedValues.add(meta.sensorId.encodeFromJava(sensorId));
      return new EntitySensor_Select.EntitySensor_SelectWhere_Date(where);
    }

    /**
     * Generate a SELECT ... FROM ... WHERE ... sensor_id IN ? */
    @SuppressWarnings("static-access")
    public final EntitySensor_Select.EntitySensor_SelectWhere_Date sensorId_IN(Long... sensorId) {
      Validator.validateTrue(ArrayUtils.isNotEmpty(sensorId), "Varargs for field '%s' should not be null/empty", "sensorId");
      where.and(QueryBuilder.in("sensor_id",QueryBuilder.bindMarker("sensor_id")));
      final List varargs = Arrays.asList((Object[])sensorId);
      final List encodedVarargs = Arrays.stream((Long[])sensorId).map(x -> meta.sensorId.encodeFromJava(x)).collect(Collectors.toList());
      boundValues.add(varargs);
      encodedValues.add(encodedVarargs);
      return new EntitySensor_Select.EntitySensor_SelectWhere_Date(where);
    }
  }

  public final class EntitySensor_SelectWhere_Date extends AbstractSelectWhere {
    public EntitySensor_SelectWhere_Date(Select.Where where) {
      super(where);
    }

    @Override
    protected final EntitySensor_Select.EntitySensor_SelectWhere_Date getThis() {
      return this;
    }

    @Override
    protected final AbstractEntityProperty getMetaInternal() {
      return meta;
    }

    @Override
    protected final Class getEntityClass() {
      return entityClass;
    }

    @Override
    protected final RuntimeEngine getRte() {
      return rte;
    }

    @Override
    protected final Options getOptions() {
      return options;
    }

    @Override
    protected final List getBoundValuesInternal() {
      return boundValues;
    }

    @Override
    protected final List getEncodedValuesInternal() {
      return encodedValues;
    }

    /**
     * Generate a SELECT ... FROM ... WHERE ... LIMIT :limit */
    public final EntitySensor_Select.EntitySensor_SelectWhere_Date limit(final Integer limit) {
      where.limit(QueryBuilder.bindMarker("lim"));
      boundValues.add(limit);
      encodedValues.add(limit);
      return this;
    }

    /**
     * Generate a SELECT ... FROM ... WHERE ... date = ? */
    @SuppressWarnings("static-access")
    public final EntitySensor_Select.EntitySensor_SelectEnd date_Eq(Long date) {
      where.and(QueryBuilder.eq("date", QueryBuilder.bindMarker("date_Eq")));
      boundValues.add(date);
      encodedValues.add(meta.date.encodeFromJava(date));
      return new EntitySensor_Select.EntitySensor_SelectEnd(where);
    }

    /**
     * Generate a SELECT ... FROM ... WHERE ... date IN ? */
    @SuppressWarnings("static-access")
    public final EntitySensor_Select.EntitySensor_SelectEnd date_IN(Long... date) {
      Validator.validateTrue(ArrayUtils.isNotEmpty(date), "Varargs for field '%s' should not be null/empty", "date");
      where.and(QueryBuilder.in("date",QueryBuilder.bindMarker("date")));
      final List varargs = Arrays.asList((Object[])date);
      final List encodedVarargs = Arrays.stream((Long[])date).map(x -> meta.date.encodeFromJava(x)).collect(Collectors.toList());
      boundValues.add(varargs);
      encodedValues.add(encodedVarargs);
      return new EntitySensor_Select.EntitySensor_SelectEnd(where);
    }

    /**
     * Generate a SELECT ... FROM ... WHERE ... date > ? */
    @SuppressWarnings("static-access")
    public final EntitySensor_Select.EntitySensor_SelectEnd date_Gt(Long date) {
      where.and(QueryBuilder.gt("date", QueryBuilder.bindMarker("date_Gt")));
      boundValues.add(date);
      encodedValues.add(meta.date.encodeFromJava(date));
      return new EntitySensor_Select.EntitySensor_SelectEnd(where);
    }

    /**
     * Generate a SELECT ... FROM ... WHERE ... date >= ? */
    @SuppressWarnings("static-access")
    public final EntitySensor_Select.EntitySensor_SelectEnd date_Gte(Long date) {
      where.and(QueryBuilder.gte("date", QueryBuilder.bindMarker("date_Gte")));
      boundValues.add(date);
      encodedValues.add(meta.date.encodeFromJava(date));
      return new EntitySensor_Select.EntitySensor_SelectEnd(where);
    }

    /**
     * Generate a SELECT ... FROM ... WHERE ... date < ? */
    @SuppressWarnings("static-access")
    public final EntitySensor_Select.EntitySensor_SelectEnd date_Lt(Long date) {
      where.and(QueryBuilder.lt("date", QueryBuilder.bindMarker("date_Lt")));
      boundValues.add(date);
      encodedValues.add(meta.date.encodeFromJava(date));
      return new EntitySensor_Select.EntitySensor_SelectEnd(where);
    }

    /**
     * Generate a SELECT ... FROM ... WHERE ... date <= ? */
    @SuppressWarnings("static-access")
    public final EntitySensor_Select.EntitySensor_SelectEnd date_Lte(Long date) {
      where.and(QueryBuilder.lte("date", QueryBuilder.bindMarker("date_Lte")));
      boundValues.add(date);
      encodedValues.add(meta.date.encodeFromJava(date));
      return new EntitySensor_Select.EntitySensor_SelectEnd(where);
    }

    /**
     * Generate a SELECT ... FROM ... WHERE ... date > ? AND date < ? */
    @SuppressWarnings("static-access")
    public final EntitySensor_Select.EntitySensor_SelectEnd date_Gt_And_Lt(Long date_Gt, Long date_Lt) {
      where.and(QueryBuilder.gt("date",QueryBuilder.bindMarker("date_Lt")));
      where.and(QueryBuilder.lt("date",QueryBuilder.bindMarker("date_Lt")));
      boundValues.add(date_Gt);
      encodedValues.add(meta.date.encodeFromJava(date_Gt));
      boundValues.add(date_Lt);
      encodedValues.add(meta.date.encodeFromJava(date_Lt));
      return new EntitySensor_Select.EntitySensor_SelectEnd(where);
    }

    /**
     * Generate a SELECT ... FROM ... WHERE ... date > ? AND date <= ? */
    @SuppressWarnings("static-access")
    public final EntitySensor_Select.EntitySensor_SelectEnd date_Gt_And_Lte(Long date_Gt, Long date_Lte) {
      where.and(QueryBuilder.gt("date",QueryBuilder.bindMarker("date_Lte")));
      where.and(QueryBuilder.lte("date",QueryBuilder.bindMarker("date_Lte")));
      boundValues.add(date_Gt);
      encodedValues.add(meta.date.encodeFromJava(date_Gt));
      boundValues.add(date_Lte);
      encodedValues.add(meta.date.encodeFromJava(date_Lte));
      return new EntitySensor_Select.EntitySensor_SelectEnd(where);
    }

    /**
     * Generate a SELECT ... FROM ... WHERE ... date >= ? AND date < ? */
    @SuppressWarnings("static-access")
    public final EntitySensor_Select.EntitySensor_SelectEnd date_Gte_And_Lt(Long date_Gte, Long date_Lt) {
      where.and(QueryBuilder.gte("date",QueryBuilder.bindMarker("date_Lt")));
      where.and(QueryBuilder.lt("date",QueryBuilder.bindMarker("date_Lt")));
      boundValues.add(date_Gte);
      encodedValues.add(meta.date.encodeFromJava(date_Gte));
      boundValues.add(date_Lt);
      encodedValues.add(meta.date.encodeFromJava(date_Lt));
      return new EntitySensor_Select.EntitySensor_SelectEnd(where);
    }

    /**
     * Generate a SELECT ... FROM ... WHERE ... date >= ? AND date <= ? */
    @SuppressWarnings("static-access")
    public final EntitySensor_Select.EntitySensor_SelectEnd date_Gte_And_Lte(Long date_Gte, Long date_Lte) {
      where.and(QueryBuilder.gte("date",QueryBuilder.bindMarker("date_Lte")));
      where.and(QueryBuilder.lte("date",QueryBuilder.bindMarker("date_Lte")));
      boundValues.add(date_Gte);
      encodedValues.add(meta.date.encodeFromJava(date_Gte));
      boundValues.add(date_Lte);
      encodedValues.add(meta.date.encodeFromJava(date_Lte));
      return new EntitySensor_Select.EntitySensor_SelectEnd(where);
    }

    /**
     * Generate a SELECT ... FROM ... WHERE ... ORDER BY date ASC */
    public final EntitySensor_Select.EntitySensor_SelectWhere_Date orderByDateAscending() {
      where.orderBy(QueryBuilder.asc("date"));
      return this;
    }

    /**
     * Generate a SELECT ... FROM ... WHERE ... ORDER BY date DESC */
    public final EntitySensor_Select.EntitySensor_SelectWhere_Date orderByDateDescending() {
      where.orderBy(QueryBuilder.desc("date"));
      return this;
    }
  }

  public final class EntitySensor_SelectEnd extends AbstractSelectWhere {
    public EntitySensor_SelectEnd(Select.Where where) {
      super(where);
    }

    @Override
    protected final Class getEntityClass() {
      return entityClass;
    }

    @Override
    protected final AbstractEntityProperty getMetaInternal() {
      return meta;
    }

    @Override
    protected final RuntimeEngine getRte() {
      return rte;
    }

    @Override
    protected final Options getOptions() {
      return options;
    }

    @Override
    protected final List getBoundValuesInternal() {
      return boundValues;
    }

    @Override
    protected final List getEncodedValuesInternal() {
      return encodedValues;
    }

    /**
     * Generate a SELECT ... FROM ... WHERE ... LIMIT :limit */
    public final EntitySensor_Select.EntitySensor_SelectEnd limit(final Integer limit) {
      where.limit(QueryBuilder.bindMarker("lim"));
      boundValues.add(limit);
      encodedValues.add(limit);
      return this;
    }

    @Override
    protected final EntitySensor_Select.EntitySensor_SelectEnd getThis() {
      return this;
    }

    /**
     * Generate a SELECT ... FROM ... WHERE ... ORDER BY date ASC */
    public final EntitySensor_Select.EntitySensor_SelectEnd orderByDateAscending() {
      where.orderBy(QueryBuilder.asc("date"));
      return this;
    }

    /**
     * Generate a SELECT ... FROM ... WHERE ... ORDER BY date DESC */
    public final EntitySensor_Select.EntitySensor_SelectEnd orderByDateDescending() {
      where.orderBy(QueryBuilder.desc("date"));
      return this;
    }
  }
}
    
    
    
    

    




    
    
    © 2015 - 2025 Weber Informatics LLC | Privacy Policy