بازیابی اشیاء - Backtory.Query

var GameScore = Backtory.Object.extend("GameScore");
var query = new Backtory.Query(GameScore);
query.equalTo("playerName", "Dan Stemkoski");
query.find({
    success: function(results) {
        context.log("Successfully retrieved " + results.length + " scores.");
        // Do something with the returned Backtory.Object values
        for (var i = 0; i < results.length; i++) {
            var object = results[i];
            context.log(object.get("_id") + ' - ' + object.get('playerName'));
        }
    },
    error: function(error) {
        context.log("Error: " + error);
    }
});

query.notEqualTo("playerName", "Michael Yabuti");

query.notEqualTo("playerName", "Michael Yabuti");
query.greaterThan("playerAge", 18);

query.sample(3);    // returns 3 random records

query.limit(10); // limit to at most 10 results

query.skip(10); // skip the first 10 results

// Sorts the results in ascending order by the score field
query.ascending("score");

// Sorts the results in descending order by the score field
query.descending("score");

// Restricts to wins < 50
query.lessThan("wins", 50);

// Restricts to wins <= 50
query.lessThanOrEqualTo("wins", 50);

// Restricts to wins > 50
query.greaterThan("wins", 50);

// Restricts to wins >= 50
query.greaterThanOrEqualTo("wins", 50);

// Finds scores from any of Jonathan, Dario, or Shawn
query.containedIn("playerName", ["Jonathan Walsh", "Dario Wunsch", "Shawn Simon"]);

// Finds scores from anyone who is neither Jonathan, Dario, nor Shawn
query.notContainedIn("playerName", ["Jonathan Walsh", "Dario Wunsch", "Shawn Simon"]);

// Finds objects that have the score set
query.exists("score");

// Finds objects that don't have the score set
query.doesNotExist("score");

var Player = Backtory.Object.extend("Player");
var Team = Backtory.Object.extend("Team");
var teamQuery = new Backtory.Query(Team);
teamQuery.greaterThan("winPct", 0.5);
var userQuery = new Backtory.Query(Player);
userQuery.matchesKeyInQuery("hometown", "city", teamQuery);
userQuery.find({
    success: function(results) {
        // results has the list of users with a hometown team with a winning record
    },
    error: function(error) {
        // There was an error.
    }
});

var Player = Backtory.Object.extend("Player");
var losingUserQuery = new Backtory.Query(Player);
losingUserQuery.doesNotMatchKeyInQuery("hometown", "city", teamQuery);
losingUserQuery.find({
    success: function(results) {
        // results has the list of users with a hometown team with a losing record
    },
    error: function(error) {
        // There was an error.
    }
});

var GameScore = Backtory.Object.extend("GameScore");
var query = new Backtory.Query(GameScore);
query.select("score", "playerName");
query.find({
    success: function(results) {
        // each of results will only have the selected fields available.
    },
    error: function(error) {
        // There was an error.
    }
});

// Find objects where the array in arrayKey contains 2.
query.equalTo("arrayKey", 2);

// Find objects where the array in arrayKey contains all of the elements 2, 3, and 4.
query.containsAll("arrayKey", [2, 3, 4]);

// Finds players that their name start with "Rob".
var query = new Backtory.Query(Player);
query.startsWith("name", "Rob");

// Finds players that their name contains "bob".
var query = new Backtory.Query(Player);
query.contains("name", "bob");

// Assume Backtory.Object myPost was previously created.
var query = new Backtory.Query(Comment);
query.equalTo("post", myPost);
query.find({
    success: function(comments) {
        // comments now contains the comments for myPost
    },
    error: function(error) {
        // There was an error.
    }
});

var Post = Backtory.Object.extend("Post");
var Comment = Backtory.Object.extend("Comment");
var innerQuery = new Backtory.Query(Post);
innerQuery.exists("image");
var query = new Backtory.Query(Comment);
query.matchesQuery("post", innerQuery);
query.find({
    success: function(comments) {
        // comments now contains the comments for posts with images.
    },
    error: function(error) {
        // There was an error.
    }
});

var Post = Backtory.Object.extend("Post");
var Comment = Backtory.Object.extend("Comment");
var innerQuery = new Backtory.Query(Post);
innerQuery.exists("image");
var query = new Backtory.Query(Comment);
query.doesNotMatchQuery("post", innerQuery);
query.find({
    success: function(comments) {
        // comments now contains the comments for posts without images.
    },
    error: function(error) {
        // There was an error.
    }
});

var post = new Post();
post.id = "1zEcyElZ80";
query.equalTo("post", post);

var query = new Backtory.Query(Comment);

// Retrieve the most recent ones
query.descending("createdAt");

// Only retrieve the last ten
query.limit(10);

// Include the post data with each comment
query.include("post");

query.find({
    success: function(comments) {
        // Comments now contains the last ten comments, and the "post" field
        // has been populated. For example:
        for (var i = 0; i < comments.length; i++) {
            // This does not require a network access.
            var post = comments[i].get("post");
        }
    },
    error: function(error) {
        // There was an error.
    }
});

var GameScore = Backtory.Object.extend("GameScore");
var query = new Backtory.Query(GameScore);
query.equalTo("playerName", "Sean Plott");
query.count({
    success: function(count) {
        // The count request succeeded. Show the count
        context.log("Sean has played " + count + " games");
    },
    error: function(error) {
        // The request failed
    }
});

var lotsOfWins = new Backtory.Query("Player");
lotsOfWins.greaterThan("wins", 150);

var fewWins = new Backtory.Query("Player");
fewWins.lessThan("wins", 5);

var mainQuery = Backtory.Query.or(lotsOfWins, fewWins);
mainQuery.limit(3);
mainQuery.find({
    success: function(results) {
        // results contains a list of players that either have won a lot of games or won only a few games.
    },
    error: function(error) {
        // There was an error.
    }
});