Examples with Database com.djrapitops.plan.storage.database.Database used on opensource projects

Example 61 with Database

use of com.djrapitops.plan.storage.database.Database in project Plan by plan-player-analytics.

the class GraphJSONCreator method uniqueAndNewGraphJSON.

public String uniqueAndNewGraphJSON() {
    Database db = dbSystem.getDatabase();
    LineGraphFactory lineGraphs = graphs.line();
    long now = System.currentTimeMillis();
    long halfYearAgo = now - TimeUnit.DAYS.toMillis(180L);
    int timeZoneOffset = config.getTimeZone().getOffset(now);
    NavigableMap<Long, Integer> uniquePerDay = db.query(PlayerCountQueries.uniquePlayerCounts(halfYearAgo, now, timeZoneOffset));
    NavigableMap<Long, Integer> newPerDay = db.query(PlayerCountQueries.newPlayerCounts(halfYearAgo, now, timeZoneOffset));
    return createUniqueAndNewJSON(lineGraphs, uniquePerDay, newPerDay, TimeUnit.DAYS.toMillis(1L));
}

Example 62 with Database

use of com.djrapitops.plan.storage.database.Database in project Plan by plan-player-analytics.

the class OnlineActivityOverviewJSONCreator method createInsightsMap.

private Map<String, Object> createInsightsMap(ServerUUID serverUUID) {
    Database db = dbSystem.getDatabase();
    long now = System.currentTimeMillis();
    long halfMonthAgo = now - TimeUnit.DAYS.toMillis(15L);
    long monthAgo = now - TimeUnit.DAYS.toMillis(30L);
    Map<String, Object> insights = new HashMap<>();
    SessionsMutator sessions = new SessionsMutator(db.query(SessionQueries.fetchServerSessionsWithoutKillOrWorldData(monthAgo, now, serverUUID)));
    List<TPS> tpsData = db.query(TPSQueries.fetchTPSDataOfServer(monthAgo, now, serverUUID));
    Map<UUID, Long> registerDates = db.query(UserInfoQueries.fetchRegisterDates(monthAgo, now, serverUUID));
    PlayersOnlineResolver playersOnlineResolver = new PlayersOnlineResolver(new TPSMutator(tpsData));
    SessionsMutator firstSessions = sessions.filterBy(session -> {
        long registered = registerDates.getOrDefault(session.getPlayerUUID(), -501L);
        long start = session.getDate();
        return Math.abs(registered - start) < 500L;
    });
    SessionsMutator firstSessionsBefore = firstSessions.filterSessionsBetween(monthAgo, halfMonthAgo);
    SessionsMutator firstSessionsAfter = firstSessions.filterSessionsBetween(halfMonthAgo, now);
    long avgFirstSessionLength = firstSessions.toAverageSessionLength();
    long avgFirstSessionLengthBefore = firstSessionsBefore.toAverageSessionLength();
    long avgFirstSessionLengthAfter = firstSessionsAfter.toAverageSessionLength();
    insights.put("first_session_length_avg", timeAmountFormatter.apply(avgFirstSessionLength));
    insights.put("first_session_length_trend", new Trend(avgFirstSessionLengthBefore, avgFirstSessionLengthAfter, false, timeAmountFormatter));
    long medianFirstSessionLength = firstSessions.toMedianSessionLength();
    long medianFirstSessionLengthBefore = firstSessionsBefore.toMedianSessionLength();
    long medianFirstSessionLengthAfter = firstSessionsAfter.toMedianSessionLength();
    insights.put("first_session_length_median", timeAmountFormatter.apply(medianFirstSessionLength));
    insights.put("first_session_length_median_trend", new Trend(medianFirstSessionLengthBefore, medianFirstSessionLengthAfter, false, timeAmountFormatter));
    int lonelyJoins = playersOnlineResolver.findLonelyJoins(sessions.toSessionStarts());
    int loneJoinsBefore = playersOnlineResolver.findLonelyJoins(sessions.filterSessionsBetween(monthAgo, halfMonthAgo).toSessionStarts());
    int loneJoinsAfter = playersOnlineResolver.findLonelyJoins(sessions.filterSessionsBetween(halfMonthAgo, now).toSessionStarts());
    insights.put("lone_joins", lonelyJoins);
    insights.put("lone_joins_trend", new Trend(loneJoinsBefore, loneJoinsAfter, true));
    int newLonelyJoins = playersOnlineResolver.findLonelyJoins(firstSessions.toSessionStarts());
    int newLoneJoinsBefore = playersOnlineResolver.findLonelyJoins(firstSessionsBefore.toSessionStarts());
    int newLoneJoinsAfter = playersOnlineResolver.findLonelyJoins(firstSessionsAfter.toSessionStarts());
    insights.put("lone_new_joins", newLonelyJoins);
    insights.put("lone_new_joins_trend", new Trend(newLoneJoinsBefore, newLoneJoinsAfter, true));
    double playersOnlineOnRegister = firstSessions.toAveragePlayersOnline(playersOnlineResolver);
    double playersOnlineOnRegisterBefore = firstSessionsBefore.toAveragePlayersOnline(playersOnlineResolver);
    double playersOnlineOnRegisterAfter = firstSessionsAfter.toAveragePlayersOnline(playersOnlineResolver);
    insights.put("players_first_join_avg", decimalFormatter.apply(playersOnlineOnRegister));
    insights.put("players_first_join_trend", new Trend(playersOnlineOnRegisterBefore, playersOnlineOnRegisterAfter, false, decimalFormatter));
    return insights;
}

Example 63 with Database

use of com.djrapitops.plan.storage.database.Database in project Plan by plan-player-analytics.

the class PlayerBaseOverviewJSONCreator method createInsightsMap.

private Map<String, Object> createInsightsMap(ServerUUID serverUUID) {
    Database db = dbSystem.getDatabase();
    long now = System.currentTimeMillis();
    long halfMonthAgo = now - TimeUnit.DAYS.toMillis(15L);
    long monthAgo = now - TimeUnit.DAYS.toMillis(30L);
    Long playThreshold = config.get(TimeSettings.ACTIVE_PLAY_THRESHOLD);
    Map<String, Object> insights = new HashMap<>();
    int newToRegular = db.query(ActivityIndexQueries.countNewPlayersTurnedRegular(monthAgo, now, serverUUID, playThreshold));
    Integer newToRegularBefore = db.query(ActivityIndexQueries.countNewPlayersTurnedRegular(monthAgo, halfMonthAgo, serverUUID, playThreshold));
    Integer newToRegularAfter = db.query(ActivityIndexQueries.countNewPlayersTurnedRegular(halfMonthAgo, now, serverUUID, playThreshold));
    insights.put("new_to_regular", newToRegular);
    insights.put("new_to_regular_trend", new Trend(newToRegularBefore, newToRegularAfter, false));
    Integer regularToInactive = db.query(ActivityIndexQueries.countRegularPlayersTurnedInactive(monthAgo, now, serverUUID, playThreshold));
    Integer regularToInactiveBefore = db.query(ActivityIndexQueries.countRegularPlayersTurnedInactive(monthAgo, halfMonthAgo, serverUUID, playThreshold));
    Integer regularToInactiveAfter = db.query(ActivityIndexQueries.countRegularPlayersTurnedInactive(halfMonthAgo, now, serverUUID, playThreshold));
    insights.put("regular_to_inactive", regularToInactive);
    insights.put("regular_to_inactive_trend", new Trend(regularToInactiveBefore, regularToInactiveAfter, Trend.REVERSED));
    return insights;
}

Example 64 with Database

use of com.djrapitops.plan.storage.database.Database in project Plan by plan-player-analytics.

the class DataValueGatherer method storeTable.

private void storeTable(Parameters parameters, Conditions conditions, TableDataValue data) {
    ProviderInformation information = data.getInformation();
    Table value = getValue(conditions, data, information);
    if (value == null)
        return;
    Database db = dbSystem.getDatabase();
    for (Icon icon : value.getIcons()) {
        if (icon != null)
            db.executeTransaction(new StoreIconTransaction(icon));
    }
    db.executeTransaction(new StoreTableProviderTransaction(information, parameters, value));
    db.executeTransaction(new StoreServerTableResultTransaction(information, parameters, value));
}

Example 65 with Database

use of com.djrapitops.plan.storage.database.Database in project Plan by plan-player-analytics.

the class DataValueGatherer method storeDouble.

private void storeDouble(Parameters parameters, Conditions conditions, DoubleDataValue data) {
    ProviderInformation information = data.getInformation();
    Double value = getValue(conditions, data, information);
    if (value == null)
        return;
    Database db = dbSystem.getDatabase();
    db.executeTransaction(new StoreIconTransaction(information.getIcon()));
    db.executeTransaction(new StoreProviderTransaction(information, parameters));
    db.executeTransaction(new StoreServerDoubleResultTransaction(information, parameters, value));
}