Objective-CでParseに色んなQueryを投げる

BaaS の Parse を使った iPhone アプリ開発をする上で
必要な Query 発行を 公式ドキュメント を参考にまとめる。

select * from xxx where playerName = "Dan Stemkoski";

[query whereKey:@"playerName" equalTo:@"Dan Stemkoski"];

select * from xxx where playerName <> "Michael Yabuti";

[query whereKey:@"playerName" notEqualTo:@"Michael Yabuti"];

select * from xxx LIMIT 10;

query.limit = 10;

select * from xxx ORDER BY score;

[query orderByAscending:@"score"];

select * from xxx ORDER BY score DESC;

[query orderByDescending:@"score"];

select * from xxx wins < 50;

[query whereKey:@"wins" lessThan:[NSNumber numberWithInt:50]];

select * from xxx wins <= 50;

[query whereKey:@"wins" lessThanOrEqualTo:[NSNumber numberWithInt:50]]; 

select * from xxx wins > 50;

[query whereKey:@"wins" greaterThan:[NSNumber numberWithInt:50]];

select * from xxx wins >= 50;

[query whereKey:@"wins" greaterThanOrEqualTo:[NSNumber numberWithInt:50]];

select * from xxx playerName IN ('Jonathan Walsh', 'Dario Wunsch', 'Shawn Simon');

NSArray *names = [NSArray arrayWithObjects:@"Jonathan Walsh", @"Dario Wunsch", @"Shawn Simon", nil];
[query whereKey:@"playerName" containedIn:names];

select * from xxx playerName NOT IN ('Jonathan Walsh', 'Dario Wunsch', 'Shawn Simon');

NSArray *names = [NSArray arrayWithObjects:@"Jonathan Walsh", @"Dario Wunsch", @"Shawn Simon", nil];
[query whereKey:@"playerName" notContainedIn:names];

select * from xxx name LIKE "%Big Daddy's%";

[query whereKey:@"name" hasPrefix:@"Big Daddy's"];