sqlite getAssignments written, not tested