55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
|
@") VALUES (\n"
@" $device_id, $next_batch\n"
@")"] retain];
_nextBatchGetStatement = [[_conn prepareStatement:
@"SELECT next_batch FROM next_batch\n"
@"WHERE device_id=$device_id"] retain];
_joinedRoomsAddStatement = [[_conn prepareStatement:
@"INSERT INTO joined_rooms (\n"
@" user_id, room_id\n"
@") VALUES (\n"
@" $user_id, $room_id\n"
@")"] retain];
_joinedRoomsRemoveStatement = [[_conn prepareStatement:
@"DELETE FROM joined_rooms\n"
@"WHERE user_id=$user_id AND room_id=$room_id"] retain];
|
|
|
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
|
@") VALUES (\n"
@" $device_id, $next_batch\n"
@")"] retain];
_nextBatchGetStatement = [[_conn prepareStatement:
@"SELECT next_batch FROM next_batch\n"
@"WHERE device_id=$device_id"] retain];
_joinedRoomsAddStatement = [[_conn prepareStatement:
@"INSERT OR REPLACE INTO joined_rooms (\n"
@" user_id, room_id\n"
@") VALUES (\n"
@" $user_id, $room_id\n"
@")"] retain];
_joinedRoomsRemoveStatement = [[_conn prepareStatement:
@"DELETE FROM joined_rooms\n"
@"WHERE user_id=$user_id AND room_id=$room_id"] retain];
|