55 lines
1.1 KiB
Python
Executable File
55 lines
1.1 KiB
Python
Executable File
#!/usr/bin/env python
|
|
|
|
import MySQLdb as mysql
|
|
import sys
|
|
|
|
def autoconf():
|
|
print "yes"
|
|
|
|
def count():
|
|
query = "select sum(value) from ttrss_counters_cache where owner_uid=1;"
|
|
mysql_user = "tinyrss"
|
|
mysql_pass = "EttLitetToken"
|
|
mysql_db = "tinyrss"
|
|
mysql_server = "localhost"
|
|
|
|
try:
|
|
connection = mysql.connect(mysql_server, mysql_user, mysql_pass, mysql_db);
|
|
cursor = connection.cursor()
|
|
cursor.execute(query)
|
|
result = cursor.fetchone()
|
|
print "ttrss.value %s" % result
|
|
except mysql.Error, e:
|
|
print "Error %d: %s" % (e.args[0], e.args[1])
|
|
sys.exit(1)
|
|
finally:
|
|
if connection:
|
|
connection.close()
|
|
|
|
|
|
def config():
|
|
print """
|
|
graph_title Tiny Tiny RSS Unread count
|
|
graph_args -l 0 --base 1000
|
|
graph_args --base 1000
|
|
graph_vlabel Unread
|
|
graph_category Apps
|
|
graph_period second
|
|
graph_info This graph shows the current number of unread RSS articles for Fredrik
|
|
ttrss.label Unread
|
|
ttrss.colour 663399
|
|
ttrss.max 10000
|
|
ttrss.min 0
|
|
ttrss.info The number of unread articles.
|
|
"""
|
|
|
|
if len(sys.argv) > 1:
|
|
if sys.argv[1] == "autoconf":
|
|
autoconf()
|
|
elif sys.argv[1] == "config":
|
|
config()
|
|
else:
|
|
count()
|
|
|
|
|