public MircString quotesToday() { quotes = ReadLog.load(file); LocalDate date = LocalDate.now(); Long output = Statistics.dailyQuotes(quotes, date); System.out.println("quotecache output: " + output); String inputString = "Total quotes for today: " + output.toString(); MircString string = MircString.of(inputString); return string; }
public MircString lanCountdown() { LocalDateTime lan = LocalDateTime.of(2016, 4, 29, 18, 0, 0); LocalDateTime now = LocalDateTime.now(); Long seconds = now.until(lan, ChronoUnit.SECONDS); int totalSeconds = (60 * 60 * 24 * 365 * 1000); BigDecimal bigSeconds = new BigDecimal(totalSeconds); BigDecimal secondsLeft = new BigDecimal(seconds); BigDecimal millennia = secondsLeft.divide(bigSeconds, 50, RoundingMode.HALF_UP); String inputString = "There are " + seconds.toString() + " seconds to LAN - you'd better be prepared for it, mofos. Or, if you're Ragnar, there are " + millennia + " millennia left."; if (seconds < 0) { seconds = Math.abs(seconds); inputString = "LAN has been running for " + seconds.toString() + " seconds! Kick ass!"; } MircString mircString = MircString.of(inputString.toString()); return mircString; }
public static Result privateTweets(long last_id, String sort, int limit) { String result = ""; List<Maopao> maopaos = null; Maopao maopao; MaopaoList maopaoList = new MaopaoList(); String uid = session("id"); if (uid == null || uid.length() == 0) { maopaoList.setCode(1000); return ok(Json.toJson(maopaoList)); } String orderBy = "id"; if ("hot".equals(sort)) { orderBy = "comment_count"; } if (limit <= 0) { limit = 30; } Connection connection = null; Statement maopaoStatement = null; Statement commentStatement = null; Statement likeUserStatement = null; Statement ownerStatement = null; ResultSet maopaoResultSet = null; ResultSet commentResultSet = null; ResultSet likeUsersResultSet = null; ResultSet ownerResultSet = null; long tweetId; long maxTweetId; String where = " owner_id = " + uid + " "; String tableComment = "t_comment"; String tableMaopao = "t_private_tweet"; try { connection = DB.getConnection(); maopaoStatement = connection.createStatement(); commentStatement = connection.createStatement(); likeUserStatement = connection.createStatement(); ownerStatement = connection.createStatement(); maxTweetId = DBUtil.queryMaxId(maopaoStatement, tableMaopao); if (last_id > maxTweetId) { maopaoResultSet = DBUtil.queryLastRecord(maopaoStatement, tableMaopao, where, orderBy, limit); } else { maopaoResultSet = DBUtil.queryLessLastRecord( maopaoStatement, tableMaopao, where, orderBy, "" + last_id, limit); } maopaos = new ArrayList<Maopao>(); while (maopaoResultSet.next()) { maopao = new Maopao(maopaoResultSet); tweetId = Long.parseLong(maopao.id); String userSql = "SELECT * FROM t_user WHERE id = " + maopao.owner_id; ownerResultSet = ownerStatement.executeQuery(userSql); ownerResultSet.next(); maopao.owner = new UserObject(ownerResultSet); if (maopao.likes > 0) { maopao.like_users = new ArrayList<UserObject>(); String sql = "SELECT * FROM t_user WHERE id IN (SELECT owner_id FROM t_like_tweet WHERE tweet_id = '%s')"; sql = String.format(sql, tweetId); likeUsersResultSet = likeUserStatement.executeQuery(sql); UserObject userObject; while (likeUsersResultSet.next()) { userObject = new UserObject(likeUsersResultSet); maopao.like_users.add(userObject); if (userObject.id.equals(session("id"))) { maopao.liked = true; } } } if (maopao.comments > 0) { maopao.comment_list = new ArrayList<BaseComment>(); String sql = "SELECT t_user.id, t_user.name, t_user.head_url, t_comment.id, t_comment.content, t_comment.create_at, t_user.created_at " + "FROM t_user INNER JOIN t_comment ON t_user.id = t_comment.owner_id WHERE tweet_id = %s"; sql = String.format(sql, tweetId); BaseComment comment; commentResultSet = commentStatement.executeQuery(sql); while (commentResultSet.next()) { // BaseComment(String id, String owner_id, String tweet_id, String content, String // created_at) comment = new BaseComment( commentResultSet.getString(4), commentResultSet.getString(1), tweetId + "", commentResultSet.getString(5), commentResultSet.getTimestamp(6).getTime()); // UserObject(long id, String name, String headImgUrl, long created_at){ comment.owner = new UserObject( commentResultSet.getLong(1), commentResultSet.getString(2), commentResultSet.getString(3), commentResultSet.getLong(7)); maopao.comment_list.add(comment); } } maopaos.add(maopao); } maopaoList.setCode(0); maopaoList.setData(maopaos); } catch (SQLException e) { e.printStackTrace(); maopaoList.setCode(-1); maopaoList.setData(null); } finally { try { if (maopaoResultSet != null) { maopaoResultSet.close(); } if (commentResultSet != null) { commentResultSet.close(); } if (maopaoStatement != null) { maopaoStatement.close(); } if (commentStatement != null) { commentStatement.close(); } if (likeUsersResultSet != null) { likeUsersResultSet.close(); } if (likeUserStatement != null) { likeUserStatement.close(); } if (connection != null) { connection.close(); } } catch (SQLException e) { } } return ok(Json.toJson(maopaoList)); }