Examples of com.j256.ormlite.db.MysqlDatabaseType

com.j256.ormlite.stmt.query.OrderBy
MySQL database type information used to create the tables, etc..
NOTE: By default the tables are created with the ENGINE=InnoDB suffix (see {@link #DEFAULT_CREATE_TABLE_SUFFIX}. Use {@link #setCreateTableSuffix} to change that to "" to use the defaultMyISAM storage engine, to choose another engine, or set other settings. For more information about engines, see the 'SHOW ENGINES;' results from the MySQL command line tool.
@author graywatson


  /**
   * Add a 'IS NULL' clause so the column must be null. '=' NULL does not work.
   */
  public Where<T, ID> isNull(String columnName) throws SQLException {
    addClause(new IsNull(columnName, findColumnFieldType(columnName)));
    return this;
  }

View Full Code Here


  /**
   * AND operation which takes the previous clause and the next clause and AND's them together.
   */
  public Where<T, ID> and() {
    addNeedsFuture(new ManyClause(pop("AND"), ManyClause.AND_OPERATION));
    return this;
  }

View Full Code Here

   */
  public Where<T, ID> and(Where<T, ID> first, Where<T, ID> second, Where<T, ID>... others) {
    Clause[] clauses = buildClauseArray(others, "AND");
    Clause secondClause = pop("AND");
    Clause firstClause = pop("AND");
    addClause(new ManyClause(firstClause, secondClause, clauses, ManyClause.AND_OPERATION));
    return this;
  }

View Full Code Here

    }
    Clause[] clauses = new Clause[numClauses];
    for (int i = numClauses - 1; i >= 0; i--) {
      clauses[i] = pop("AND");
    }
    addClause(new ManyClause(clauses, ManyClause.AND_OPERATION));
    return this;
  }

View Full Code Here


  /**
   * OR operation which takes the previous clause and the next clause and OR's them together.
   */
  public Where<T, ID> or() {
    addNeedsFuture(new ManyClause(pop("OR"), ManyClause.OR_OPERATION));
    return this;
  }

View Full Code Here

   */
  public Where<T, ID> or(Where<T, ID> left, Where<T, ID> right, Where<T, ID>... others) {
    Clause[] clauses = buildClauseArray(others, "OR");
    Clause secondClause = pop("OR");
    Clause firstClause = pop("OR");
    addClause(new ManyClause(firstClause, secondClause, clauses, ManyClause.OR_OPERATION));
    return this;
  }

View Full Code Here

    }
    Clause[] clauses = new Clause[numClauses];
    for (int i = numClauses - 1; i >= 0; i--) {
      clauses[i] = pop("OR");
    }
    addClause(new ManyClause(clauses, ManyClause.OR_OPERATION));
    return this;
  }

View Full Code Here


  /**
   * Used to NOT the next clause specified.
   */
  public Where<T, ID> not() {
    addNeedsFuture(new Not());
    return this;
  }

View Full Code Here


  /**
   * Used to NOT the argument clause specified.
   */
  public Where<T, ID> not(Where<T, ID> comparison) {
    addClause(new Not(pop("NOT")));
    return this;
  }

View Full Code Here

      throw new IllegalArgumentException("Can't orderBy foreign colletion field: " + columnName);
    }
    if (orderByList == null) {
      orderByList = new ArrayList<OrderBy>();
    }
    orderByList.add(new OrderBy(columnName, ascending));
    return this;
  }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of com.j256.ormlite.db.MysqlDatabaseType

android.database.sqlite.SQLiteStatement

com.j256.ormlite.android.AndroidDatabaseConnection

com.j256.ormlite.android.apptools.OrmLiteSqliteOpenHelper

com.j256.ormlite.dao.BaseDaoImpl

com.j256.ormlite.dao.BaseDaoImplTest

com.j256.ormlite.dao.Dao.CreateOrUpdateStatus

com.j256.ormlite.dao.DaoManager

com.j256.ormlite.dao.DaoManagerTest

com.j256.ormlite.dao.DoubleDbOpenTest

com.j256.ormlite.dao.RuntimeExceptionDaoTest

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.