def post(self):
try:
db = self.settings['db']
username = self.get_argument("u", "")
password = self.get_argument("p", "")
Logmgr.PYLOG("LoginHandler", {
"username": username,
"password": password
})
if username == '' or password == '':
self.write(
JsonHelper.failWithMessage("Empty username or password"))
return
res = yield db.accounts.find_one({"username": username})
if not res or not ("password"
in res) or res['password'] != password:
self.write(
JsonHelper.failWithMessage("Wrong username or password"))
return
new_token = str(uuid.uuid1())
result = yield db.accounts.update({"username": username},
{'$set': {
'token': new_token
}})
if result['ok'] == 1:
respond_data = {"oid": str(res['_id']), "token": new_token}
Logmgr.PYLOG("LoginHandler", JsonHelper.success(respond_data))
self.write(JsonHelper.success(respond_data))
except Exception, e:
if DEBUG:
print Exception, ":", e
traceback.print_exc()
self.write(JsonHelper.failWithMessage("Internal error."))
def main():
# list of rrd files that contain the toner levels
toner_file_list = [
"dfw-bizhub_c458_snmp_black4_61.rrd",
"dfw-bizhub_c458_snmp_cyan1_62.rrd",
"dfw-bizhub_c458_snmp_magenta2_63.rrd",
"dfw-bizhub_c458_snmp_yellow3_64.rrd",
"dfw-m521dn-checkprinter_snmp_black1_79.rrd",
"frtx-hp570dn_snmp_black1_49.rrd",
"frtx-hp570dn_snmp_cyan2_50.rrd",
"frtx-hp570dn_snmp_magenta3_51.rrd",
"frtx-hp570dn_snmp_yellow4_52.rrd",
"hotx-hp570dn_snmp_black1_86.rrd",
"hotx-hp570dn_snmp_cyan2_87.rrd",
"hotx-hp570dn_snmp_magenta3_88.rrd",
"hotx-hp570dn_snmp_yellow4_89.rrd",
"orl-m570dn_snmp_black1_53.rrd",
"orl-m570dn_snmp_cyan2_54.rrd",
"orl-m570dn_snmp_magenta3_55.rrd",
"orl-m570dn_snmp_yellow4_56.rrd",
"sauk-m570dn_snmp_black1_57.rrd",
"sauk-m570dn_snmp_cyan2_58.rrd",
"sauk-m570dn_snmp_magenta3_59.rrd",
"sauk-m570dn_snmp_yellow4_60.rrd",
]
# the directory with the .rrd files
file_directory = ("/var/www/cacti-1.1.38/rra")
data = DataHelpers.grab_data(file_directory, toner_file_list)
JsonHelper.toner_history(data)
logging.info("TonerLevels.py script has ended.")
def post(self):
try:
db = self.settings['db']
username = self.get_argument("u", "")
password = self.get_argument("p", "")
# print self.request.body
Logmgr.PYLOG("RegistHandler", {
"username": username,
"password": password
})
if username == '' or password == '':
self.write(
JsonHelper.failWithMessage("Empty username or password"))
return
res = yield db.accounts.find_one({"username": username})
# TODO handle db failure
if res:
self.write(
JsonHelper.failWithMessage("Username already exists"))
return
new_token = str(uuid.uuid1())
oid = bson.ObjectId()
result = yield db.accounts.insert({
"_id": oid,
"username": username,
"password": password,
'token': new_token
})
if result == oid:
respond_data = {"oid": str(oid), "token": new_token}
Logmgr.PYLOG("RegistHandler", JsonHelper.success(respond_data))
self.write(JsonHelper.success(respond_data))
except Exception, e:
if DEBUG:
print Exception, ":", e
traceback.print_exc()
self.write(JsonHelper.failWithMessage("Internal error."))
PlayerList = []
userByCountry = {}
userByFriends = {}
userByLevel = {}
userByVACBan = {}
userByCommunityBan = {}
userBySteamID = {}
userByGames = {}
userByLastlogoff = {}
userByTimecreated = {}
userByRecentlyplayed = {}
usedPlayers = []
t = datetime.datetime(1970,1,1)
userBySteamID = JsonHelper.loadJson(userBySteamID, 'PlayerList.txt')
#'''
userByCountry = JsonHelper.loadJson(userByCountry, 'SortCountry50000.txt')
userByFriends = JsonHelper.loadJson(userByFriends, 'SortFriend50000.txt')
userByLevel = JsonHelper.loadJson(userByLevel, 'SortLevel50000.txt')
userByVACBan = JsonHelper.loadJson(userByVACBan, 'SortVACBan50000.txt')
userByCommunityBan = JsonHelper.loadJson(userByCommunityBan, 'SortCommunityBan50000.txt')
userByGames = JsonHelper.loadJson(userByGames, 'SortGames50000.txt')
userByLastlogoff = JsonHelper.loadJson(userByLastlogoff, 'SortLastlogoff50000.txt')
userByTimecreated = JsonHelper.loadJson(userByTimecreated, 'SortTimecreated50000.txt')
userByRecentlyplayed = JsonHelper.loadJson(userByRecentlyplayed, 'SortRecentlyplayed50000.txt')
#'''
try:
PlayerList = userBySteamID['players']
end = time.time()
print(counter)
print(end - start)
pos = nx.spring_layout(G)
temp = []
for x in listToDo:
temp.append(x.steamid)
nx.draw_networkx_nodes(G, pos, nodelist=temp, node_color='b')
nx.draw_networkx_edges(G, pos)
#nx.draw_networkx_nodes(G, pos, nodelist=listDone, node_color='r')
for x in usersByCountry:
colors = (random(), random(), random())
print usersByCountry[x]
nx.draw_networkx_nodes(G,
pos,
nodelist=usersByCountry[x],
node_color=colors)
#nx.draw_networkx_nodes(G, pos, nodelist=[me.steamid], node_color='g')
nx.draw_networkx_labels(G, pos, labels)
plt.show()
JsonHelper.printJson(usersByCountry, 'SortCountry.txt')
JsonHelper.printJson(userByFriends, 'SortFriend.txt')
JsonHelper.printJson(userByLevel, 'SortLevel.txt')
counter = counter + 1
print counter
me = steamapi.user.SteamUser(userid=x)
if me.privacy == 3:
setinDictionary(userByCountry, me.country_code, me.steamid)
setinDictionary(userByLevel, me.level, me.steamid)
setinDictionary(userByVACBan, me.is_vac_banned, me.steamid)
setinDictionary(userByCommunityBan, me.is_community_banned,
me.steamid)
for y in me.games:
setinDictionary(userByGames, y.name, me.steamid)
'''
for y in me.friends:
setinDictionary(userByFriends, me.steamid, y.steamid)
'''
temp = {}
temp = JsonHelper.loadJson(temp, 'PlayerList.txt')
try:
goThroughList(temp['players'])
except:
print "irgendeinen scheiss"
JsonHelper.printJson(userByCountry, 'SortCountryBig.txt')
JsonHelper.printJson(userByFriends, 'SortFriendBig.txt')
JsonHelper.printJson(userByLevel, 'SortLevelBig.txt')
JsonHelper.printJson(userByVACBan, 'SortVACBanBig.txt')
JsonHelper.printJson(userByCommunityBan, 'SortCommunityBanBig.txt')
JsonHelper.printJson(userByGames, 'SortGamesBig.txt')
def createResponseFromList(self, list):
elementsDict = JsonHelper.getJsonFromList(list)
return Response(200, 'application/json', json.dumps(elementsDict))
def getPostByRequestData(request):
return JsonHelper.getDataByJson(postInfoByRequest(request));
def getGetRequestData(request):
return JsonHelper.getDataByJson(getInfoByRequest(request));
def getPostUrlData(url,params):
return JsonHelper.getDataByJson(postInfo(url,params));
def getGetUrlData(url):
return JsonHelper.getDataByJson(getInfoByUrl(url));
except Exception, e:
print("DONE; DONE; DONE")
print(e)
'''
for x in listToDo:
print(counter)
counter = counter-1
listDone.append(x.steamid)
setinDictionary(usersByCountry, x.country_code, x.steamid)
if(x.privacy == 3):
setinDictionary(userByLevel, x.level, x.steamid)
setinDictionary(userByVACBan, x.is_vac_banned, x.steamid)
setinDictionary(userByCommunityBan, x.is_community_banned, x.steamid)
for i in x.friends:
if i.steamid in listDone:
setinDictionary(userByFriends, x.steamid, i.steamid)
setinDictionary(userByFriends, i.steamid, x.steamid)
'''
end = time.time()
print(end - start)
JsonHelper.printJson(userBySteamID, 'PlayerList.txt')
'''
JsonHelper.printJson(userByCountry, 'SortCountryBig.txt')
JsonHelper.printJson(userByFriends, 'SortFriendBig.txt')
JsonHelper.printJson(userByLevel, 'SortLevelBig.txt')
JsonHelper.printJson(userByVACBan, 'SortVACBanBig.txt')
JsonHelper.printJson(userByCommunityBan, 'SortCommunityBanBig.txt')
'''
except Exception as e:
conn.rollback()
logger.error(e)
return None, e
config = AdvConfigParser()
config.read(configfile)
exports_json_url = config.get('EXPORT', 'EXPORTS_JSON_URL', '')
dbhost = config.get('DATABASE', 'HOST', "")
dbport = config.geti('DATABASE', 'PORT', "0")
dbuser = config.get('DATABASE', 'USER', "")
dbname = config.get('DATABASE', 'NAME', "")
dbpass = config.get('DATABASE', 'PASS', "")
conn = psycopg2.connect(database=dbname,
user=dbuser,
password=dbpass,
host=dbhost,
port=dbport)
sqlrequest = 'select mcp.add_available_version(%s, %s, %s);'
json_data = JsonHelper.get_remote_json(exports_json_url)
for mc_version, channels in json_data.items():
for version_type, versions in channels.items():
for version_code in versions:
execute(conn, sqlrequest,
(mc_version, version_type, str(version_code)))
# execute(conn, 'commit;')
recPlayed = {}
timeCreated = {}
vacBan = {}
numFriends = {}
onlyAnalyzedFriends = {}
games = {}
games2 = {}
games3 = {}
userGames = {}
userGames2 = {}
userGames3 = {}
userGames4 = {}
userAge = {}
# Jsons die bereits eingelesen wurden
friends = JsonHelper.loadJson(friends, '../Data/SortFriend50000.txt')
friends2 = JsonHelper.loadJson(friends2, '../Data/SortFriend50000_2.txt')
comBan = JsonHelper.loadJson(comBan, '../Data/SortCommunityBan50000.txt')
country = JsonHelper.loadJson(country, '../Data/SortCountry50000.txt')
lastlogOff = JsonHelper.loadJson(lastlogOff, '../Data/SortLastlogoff50000.txt')
level = JsonHelper.loadJson(level, '../Data/SortLevel50000.txt')
privacy = JsonHelper.loadJson(privacy, '../Data/SortPrivacy50000.txt')
recPlayed = JsonHelper.loadJson(recPlayed,
'../Data/SortRecentlyplayed50000.txt')
timeCreated = JsonHelper.loadJson(timeCreated,
'../Data/SortTimecreated50000.txt')
vacBan = JsonHelper.loadJson(vacBan, '../Data/SortVACBan50000.txt')
numFriends = JsonHelper.loadJson(numFriends,
'../Data/NumberOfpersonalFriends.txt')
onlyAnalyzedFriends = JsonHelper.loadJson(onlyAnalyzedFriends,
'../Data/onlyAnalyzedFriends.txt')
