NOSQL_endsemproject/get_info.java at main · vamsikrishna1007/NOSQL_endsemproject · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
import com.mongodb.client.AggregateIterable;
import com.mongodb.client.MongoClient;
import com.mongodb.client.MongoClients;
import com.mongodb.client.MongoCollection;
import com.mongodb.client.MongoDatabase;
import org.bson.Document;
import java.util.Arrays;
import java.util.List;
public class get_info {
    public static int innings_played(String name,MongoCollection<Document>  collection)
    {
        int count=0;
        List<Document> pipeline = Arrays.asList(
            new Document("$match", new Document("$or", Arrays.asList(
                    new Document("bowler", name),
                    new Document("batter", name)
                ))),
                new Document("$group", new Document("_id", "$ID")
                .append("count", new Document("$sum", 1)))
        );
        AggregateIterable<Document> result = collection.aggregate(pipeline);

        for (Document doc : result) {
    //System.out.println(doc);
            count++;
        }
        return count;
    }

    public static int total_runs(String name,MongoCollection<Document>  collection)
    {
        List<Document> pipeline = Arrays.asList(
            new Document("$match", new Document("batter", name)),
            new Document("$group", new Document("_id", "$batter")
                    .append("total_runs", new Document("$sum", "$batsman_run")))
        );
        AggregateIterable<Document> result = collection.aggregate(pipeline);
        Document next2 = result.iterator().next();
        int count=0;
        for (Document doc : result) {
            //System.out.println(doc);
                    count++;
                }
        if(count==0)
        {
            return 0;
        }
        return (int)next2.get("total_runs");
    }

    public static int centuries(String name,MongoCollection<Document>  collection)
    {
        List<Document> pipeline = Arrays.asList(
            new Document("$match", new Document("batter", name)),
            new Document("$group", new Document("_id", "$ID")
                    .append("total_runs", new Document("$sum", "$batsman_run"))),
            new Document("$match", new Document("total_runs", new Document("$gte", 100)))
        );
        AggregateIterable<Document> result = collection.aggregate(pipeline);
        int count=0;
        for (Document doc : result) {
            //System.out.println(doc);
                    count++;
        }
        return count;
    }

    public static int half_centuries(String name,MongoCollection<Document>  collection)
    {
        List<Document> pipeline = Arrays.asList(
            new Document("$match", new Document("batter", name)),
            new Document("$group", new Document("_id", "$ID")
                    .append("total_runs", new Document("$sum", "$batsman_run"))),
            new Document("$match", new Document("total_runs", new Document("$gte", 50)))
        );
        AggregateIterable<Document> result = collection.aggregate(pipeline);
        int count=0;
        for (Document doc : result) {
            //System.out.println(doc);
                    count++;
        }
        return count;
    }
    public static double strike_rate(String name,MongoCollection<Document>  collection)
    {
        List<Document> pipeline = Arrays.asList(
            new Document("$match", new Document("batter", name)),
            new Document("$group", new Document("_id", null)
                    .append("total_runs", new Document("$sum", "$batsman_run"))
                    .append("total_balls", new Document("$sum", 1))),
            new Document("$project", new Document("_id", 0)
                    .append("total_runs", 1)
                    .append("total_balls", 1)
                    .append("average", new Document("$divide", Arrays.asList("$total_runs", "$total_balls")))));
        AggregateIterable<Document> result = collection.aggregate(pipeline);
        Document next2 = result.iterator().next();
        for (Document doc : result) {
            //System.out.println(doc);
        }

        return  100*(double)next2.get("average");
    }
    public static int high_score(String name,MongoCollection<Document>  collection)
    {
        List<Document> pipeline = Arrays.asList(
            new Document("$match", new Document("batter", name)),
            new Document("$group", new Document("_id", "$ID")
                    .append("total_runs", new Document("$sum", "$batsman_run"))),
            new Document("$match", new Document("total_runs", new Document("$gte", 50)))
        );
        AggregateIterable<Document> result = collection.aggregate(pipeline);
        int ans=0;
        for (Document doc : result) {
            int a = (int)doc.get("total_runs");
            if(a>ans)
            {
                ans=a;
            }
        }

        return  ans;
    }
    public static int total_fours(String name,MongoCollection<Document>  collection,int val)
    {
        List<Document> pipeline = Arrays.asList(
            new Document("$match", new Document("batter", name)
            .append("batsman_run", val)
            .append("non_boundary", 0)),
            new Document("$group", new Document("_id", null)
            .append("count", new Document("$sum", 1)))
        );
        AggregateIterable<Document> result = collection.aggregate(pipeline);
        Document next2 = result.iterator().next();
        return (int)next2.get("count");
    }
    public static int total_wickets(String name,MongoCollection<Document>  collection)
    {
        List<Document> pipeline = Arrays.asList(
            new Document("$match", new Document("bowler", name)
            .append("isWicketDelivery", 1)
            .append("kind", new Document("$ne", "NA"))),
            new Document("$group", new Document("_id", "$bowler")
            .append("count", new Document("$sum", 1)))
        );
        AggregateIterable<Document> result = collection.aggregate(pipeline);
        //Document next2 = result.iterator().next();
        System.out.println(result.iterator().next());
        //return (int)next2.get("count");
        return 0;
    }

    public static void main(String[] args) {
        MongoClient mongoClient = MongoClients.create("mongodb://localhost:27017");
        MongoDatabase database = mongoClient.getDatabase("cricket");
        MongoCollection<Document> collection = database.getCollection("ipl");
        String name ="DA Warner";
        int innings_=innings_played(name,collection);
        int total_runs_=total_runs(name,collection);
        System.out.println("innings: "+innings_);
        System.out.println("total_runs:  "+total_runs_);
        System.out.println("average:  "+total_runs_/innings_);
        System.out.println("total_centuries:  "+centuries(name,collection));
        System.out.println("half_centuries:  "+half_centuries(name,collection));
        System.out.println("high_score:  "+high_score(name,collection));
        System.out.println("Strike_rate:  "+strike_rate(name,collection));
        System.out.println("fours: "+total_fours(name,collection,4));
        System.out.println("sixes: "+total_fours(name,collection,6));
        System.out.println("wickets: "+total_wickets(name,collection));
    }
}