Examples of hirondelle.web4j.database.TxSimple

hirondelle.web4j.database.TxSimple

Perform the simplest kinds of transactions.

Executes a number of SQL statements, in the same order as passed to the constructor. Each SQL statement is executed once and only once, without any iteration. Each SQL statement must perform an INSERT, DELETE, or UPDATE operation. No SELECTs are allowed.

It is likely that a significant fraction (perhaps as high as 50%) of all transactions can be implemented with this class.

Example use case:

 Object[] sqlIds = {ADD_THIS, DELETE_THAT}; Object[] params = {blah.getX(), blah.getY(), blah.getZ(), blah.getQ()};  Tx doStuff = new TxSimple(sqlIds, params); int numRecordsAffected = doStuff.executeTx();

In this example, blah will usually represent a Model Object. The data in params is divided up among the various sqlIds. (This division is performed internally by this class.)

This class uses strong ordering conventions. The order of items in each array passed to the constructor is very important (see {@link #TxSimple(SqlId[],Object[])}).

   Move the given unknown to the <tt>BaseText</tt> table.
  */
  boolean move(BaseText aUnknownBaseText) throws DAOException {
    SqlId[] sqlIds = {BaseTextAction.BASE_TEXT_ADD, UnknownBaseTextEdit.DELETE};
    Object[] params = {aUnknownBaseText.getBaseText(), aUnknownBaseText.getIsCoderKey(), aUnknownBaseText.getBaseText()};
    Tx move = new TxSimple(sqlIds, params);
    return Util.isSuccess(move.executeTx());
  }

   <P>(This method uses a transaction.)
  */
  void delete(SafeText aUserName) throws DAOException {
    SqlId[] sqlIds = {ROLES_DELETE, USER_DELETE};
    Object[] params = {aUserName, aUserName};
    Tx deleteUserAndRoles = new TxSimple(sqlIds, params);
    deleteUserAndRoles.executeTx();
  }

      /*params for user: */
      aRegister.getLoginName(), aRegister.getScreenName(), Id.from(hashedPassword), aRegister.getEmail(),
      /*params for role: */
      aRegister.getLoginName()
    };
    TxSimple tx = new TxSimple(sqls, params);
    int numRecords = tx.executeTx();
    if ( numRecords != 2 ){
      String msg = "Should have added 2 records (user and single role), but added this many: " + numRecords;
      throw new AssertionError(msg);
    }
  }

Examples of hirondelle.web4j.database.TxSimple

Related Classes of hirondelle.web4j.database.TxSimple