Android Open Source - spades Related List

• Back to Database/lightweight  ↑

From Project

Back to project page spades.

License

The source code is released under:

Apache License

Java Source Code

package cat.picas.spades;
/*  ww  w .  ja  v a 2  s  . c  o  m*/
import java.util.ArrayList;
import java.util.Collection;
import java.util.List;

import android.database.Cursor;
import android.database.sqlite.SQLiteDatabase;
import cat.picas.spades.query.Query;

public class RelatedList<T extends Entity> {

  private Entity mParent;
  private Column mChildColumn;
  private Table mChildTable;
  private EntityMapper<T> mChildMapper;
  private String mExtraWhere;

  private boolean mFetched;
  private List<T> mChilds = new ArrayList<T>();

  public RelatedList(Entity parent, Column childColumn, EntityMapper<T> childMapper) {
    mParent = parent;
    mChildColumn = childColumn;
    mChildTable = mChildColumn.getTable();
    mChildMapper = childMapper;
  }

  public RelatedList(Entity parent, Column childColumn, EntityMapper<T> childMapper, String extraWhere) {
    this(parent, childColumn, childMapper);
    mExtraWhere = extraWhere;
  }

  public boolean isFetched() {
    return mFetched;
  }

  public void reset() {
    mChilds.clear();
    mFetched = false;
  }

  public List<T> fetch(SQLiteDatabase db) {
    if (!mFetched && mParent.getEntityId() != null) {
      Query query = createFetchQuery();
      Cursor cursor = query.execute(db);

      mChilds.clear();
      mFetched = true;

      cursor.moveToPosition(-1);
      CursorInfo cursorInfo = query.getCursorInfo();
      while (cursor.moveToNext()) {
        T entity = mChildMapper.createFromCursor(cursor, cursorInfo);
        if (entity != null) {
          mChilds.add(entity);
        }
      }
      cursor.close();
    }

    return mChilds;
  }

  public List<T> fetch(SQLiteDatabase db, Query query) {
    Cursor cursor = query.execute(db);
    try {
      return fetch(cursor, query.getCursorInfo());
    } finally {
      cursor.close();
    }
  }

  public List<T> fetch(Cursor cursor, CursorInfo cursorInfo) {
    if (!mFetched) {
      // Check if the cursor contains data for child entity.
      if (!cursorInfo.hasTable(mChildTable)) {
        return null;
      }

      mChilds.clear();
      mFetched = true;

      Long parentId = mParent.getEntityId();
      int childColIndex = cursorInfo.getColumnIndex(mChildColumn);

      int oldPosition = cursor.getPosition();
      cursor.moveToPosition(-1);
      while (cursor.moveToNext()) {
        // If we have enough information check if the child entity ID is
        // equal to the parent ID, if they are different then we discard
        // this row.
        if (childColIndex != CursorInfo.INVALID_INDEX && !cursor.isNull(childColIndex)
            && parentId != null && !parentId.equals(cursor.getLong(childColIndex))) {
          continue;
        }

        T entity = mChildMapper.createFromCursor(cursor, cursorInfo);
        if (entity != null) {
          mChilds.add(entity);
        }
      }
      cursor.moveToPosition(oldPosition);
    }

    return mChilds;
  }

  public void fetchAndAddOne(Cursor cursor, CursorInfo cursorInfo) {
    // Check if the cursor contains data for this entity.
    if (!cursorInfo.hasTable(mChildTable)) {
      return;
    }

    // We only add the children that can be validated as a related entity of this parent.
    int childColIndex = cursorInfo.getColumnIndex(mChildColumn);
    if (childColIndex == CursorInfo.INVALID_INDEX
        || cursor.isNull(childColIndex) || mParent.getEntityId() == null
        || !mParent.getEntityId().equals(cursor.getLong(childColIndex))) {
      return;
    }

    T child = mChildMapper.createFromCursor(cursor, cursorInfo);
    if (child != null) {
      mChilds.add(child);
    }
    mFetched = true;
  }

  public List<T> getList() {
    return mChilds;
  }

  public void add(T entity) {
    mChilds.add(entity);
    mFetched = true;
  }

  public void add(Collection<? extends T> entities) {
    mChilds.addAll(entities);
    mFetched = true;
  }

  protected Query createFetchQuery() {
    Query query;
    if (mParent.getEntityId() != null) {
      query = new Query(mChildTable).where(mChildColumn, "=" + mParent.getEntityId());
    } else {
      query = new Query(mChildTable).where(mChildColumn, "ISNULL");
    }

    if (mExtraWhere != null) {
      query.where(mExtraWhere);
    }

    return query;
  }

}

Java Source Code List

• Back to Database/lightweight  ↑