OneHourGameJam-irc-bot/log-browser.py at master · OneHourGameJam/OneHourGameJam-irc-bot · 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
#!/usr/bin python3
# -*- coding: utf-8 -*-

import sqlite3 as sql
import time
from datetime import datetime

logs = 'logs.db'
file = 'logs.txt'
db = sql.connect(logs)

with db:
	db.row_factory = sql.Row
	cur = db.cursor()

def gen_logs(file):
	logsFile = open(file, 'w')
	with db:
		try:
			cur.execute("SELECT * FROM Logs")
			print("Grabbed logs")
			logs = cur.fetchall()
			toWrite = []
			for log in logs:
				toWrite.append("[%s] <%s> %s" % (
					datetime.fromtimestamp(log["time"]),
					log["user"],
					log["message"]
				))
				print("[%s] <%s> %s" % (
					datetime.fromtimestamp(log["time"]),
					log["user"],
					log["message"]
				))
			logsFile.write("\n".join(toWrite))
			logsFile.close()
			toWrite = None
		except: pass

def get_logs_by(file, user):
	logsFile = open(file, 'w')
	with db:
		cur.execute("SELECT * FROM Logs WHERE `user` = '%s'" % user)
		print("Grabbed logs")
		logs = cur.fetchall()
		toWrite = []
		for log in logs:
			toWrite.append("[%s] <%s> %s" % (
				datetime.fromtimestamp(log["time"]),
				log["user"],
				log["message"]
			))
			print("[%s] <%s> %s" % (
				datetime.fromtimestamp(log["time"]),
				log["user"],
				log["message"]
			))
		logsFile.write("\n".join(toWrite))
		logsFile.close()
		toWrite = None


gen_logs("logs.txt")