update camera - capture

need to implement sql methods