ExpandableListAdapter und SQLite

1public class CategoriesAdapter extends BaseExpandableListAdapter {
2 private Context mContext;
3
4 private ShoppingListDatabaseHelper mDbHelper;
5 private SQLiteDatabase mDb;
6
7 private Cursor mCategoriesCursor;
8 private Cursor mItemsCursor;
9
10 public CategoriesAdapter(Context context, SQLiteDatabase db, Cursor categoriesCursor) {
11 mContext = context;
12 mDb = db;
13 mCategoriesCursor = categoriesCursor;
14 }
15
16 @Override
17 public int getGroupCount() {
18 return mCategoriesCursor.getCount();
19 }
20
21 @Override
22 public int getChildrenCount(int groupPosition) {
23 Cursor itemsCursor = Item.findAllByCategoryId(mDb, getGroupId(groupPosition));
24 int count = itemsCursor.getCount();
25 itemsCursor.close();
26 return count;
27 }
28
29 @Override
30 public Object getGroup(int groupPosition) {
31 mCategoriesCursor.moveToPosition(groupPosition);
32 if (mCategoriesCursor.getCount() > 0){
33 return mCategoriesCursor;
34 }
35 return null;
36 }
37
38 @Override
39 public Object getChild(int groupPosition, int childPosition) {
40 mItemsCursor = Item.findAllByCategoryId(mDb, getGroupId(groupPosition));
41 mItemsCursor.moveToPosition(childPosition);
42 if (mItemsCursor.getCount() > 0){
43 return mItemsCursor;
44 }
45 return null;
46 }
47
48 @Override
49 public long getGroupId(int groupPosition) {
50 Cursor categoriesCursor = (Cursor) getGroup(groupPosition);
51 if (categoriesCursor != null && !categoriesCursor.isNull(groupPosition)) {
52 return categoriesCursor.getInt(categoriesCursor.getColumnIndexOrThrow(Category.ID));
53
54 }
55 return -1;
56 }
57
58 @Override
59 public long getChildId(int groupPosition, int childPosition) {
60 Cursor itemsCursor = (Cursor) getChild(groupPosition, childPosition);
61 Log.v("CategoriesCursor", new Integer(itemsCursor.getCount()).toString());
62 if (itemsCursor.getCount() > 0){
63 int id = itemsCursor.getInt(itemsCursor.getColumnIndexOrThrow(Item.ID));
64 itemsCursor.close();
65 return id;
66 }
67 return 0;
68 }
69
70 @Override
71 public boolean hasStableIds() {
72 return true;
73 }
74
75 @Override
76 public View getGroupView(int groupPosition, boolean isExpanded, View convertView, ViewGroup parent) {
77
78 Cursor categoriesCursor = (Cursor) getGroup(groupPosition);
79 if (convertView == null && categoriesCursor != null){
80 LayoutInflater inflater = LayoutInflater.from(mContext);
81 convertView = inflater.inflate(R.layout.group_row, null);
82
83 if (categoriesCursor != null) {
84 TextView groupTv = (TextView) convertView.findViewById(R.id.group_text);
85 groupTv.setText(categoriesCursor.getString(mCategoriesCursor.getColumnIndexOrThrow(Category.NAME)));
86 }
87 }
88 return convertView;
89 }
90
91 @Override
92 public View getChildView(int groupPosition, int childPosition, boolean isLastChild, View convertView, ViewGroup parent) {
93 Cursor itemsCursor = (Cursor) getChild(groupPosition, childPosition);
94 if (convertView == null) {
95 LayoutInflater inflater = LayoutInflater.from(mContext);
96 convertView = inflater.inflate(R.layout.child_row, null);
97 if (itemsCursor != null) {
98 TextView childTv = (TextView) convertView.findViewById(R.id.child_text);
99 TextView amountView = (TextView) convertView.findViewById(R.id.child_amount);
100 childTv.setText(itemsCursor.getString(itemsCursor.getColumnIndexOrThrow(Item.NAME)));
101 amountView.setText(itemsCursor.getString(itemsCursor.getColumnIndexOrThrow(Item.AMOUNT)));
102 }
103 }
104 itemsCursor.close();
105 return convertView;
106 }
107
108 @Override
109 public boolean isChildSelectable(int groupPosition, int childPosition) {
110 return true;
111 }
112
113}