package Ġcom . an sh ul vy as . cache . db Ċ Ċ object ĠProject Constants Ġ{ ĊĊĠĠĠ Ġconst Ġval ĠTABLE _ NAME Ġ= Ġ" projects " ĊĊĠĠĠ Ġconst Ġval ĠCOLUMN _ PROJECT _ ID Ġ= Ġ" projects _ id " ĊĊĠĠĠ Ġconst Ġval ĠCOLUMN _ IS _ BOOK MARK ED Ġ= Ġ" is _ book marked " ĊĊĠĠĠ Ġconst Ġval ĠQUERY _ PROJECT S Ġ= Ġ" SELECT Ġ* ĠFROM Ġ$ TABLE _ NAME " ĊĊĠĠĠ Ġconst Ġval ĠDELETE _ PROJECT S Ġ= Ġ" DELETE Ġ* ĠFROM Ġ$ TABLE _ NAME " ĊĊĠĠĠ Ġconst Ġval ĠQUERY _ BOOK MARK ED _ PROJECT S Ġ= Ġ" SELECT Ġ* ĠFROM Ġ$ TABLE _ NAME Ġ" Ġ+ ĊĠĠĠĠĠĠĠĠĠĠĠ Ġ" WHERE Ġ$ COLUMN _ IS _ BOOK MARK ED Ġ= Ġ 1 " ĊĊĠĠĠ Ġconst Ġval ĠQUERY _ UPDATE _ BOOK MARK _ STATUS Ġ= Ġ" UPDATE Ġ$ TABLE _ NAME Ġ" Ġ+ ĊĠĠĠĠĠĠĠĠĠĠĠ Ġ" SET Ġ$ COLUMN _ IS _ BOOK MARK ED Ġ= Ġ: is Book marked ĠWHERE Ġ" Ġ+ ĊĠĠĠĠĠĠĠĠĠĠĠ Ġ"$ COLUMN _ PROJECT _ ID Ġ= Ġ: project _ id " Ċ }