KaneAI - World’s First E2E Software Testing Agent.Book a Demo 
How to use _format_row method in autotest
Best Python code snippet using autotest_python
statdb.py
Source:statdb.py 
...927 return True, msg928 msg = self.formatcomp(milestone1, milestone2)929 return True, msg930 @staticmethod931 def _format_row(rowname, data1, data2, datacolor="@W",932 headercolor="@C"):933 """934 format a row of data935 """936 lstr = '%s%-14s : %s%-12s %s%-12s' % (headercolor, rowname,937 datacolor, data1,938 datacolor, data2)939 return lstr940 def show_quest(self, args):941 """942 show info for a specific quest in the database943 """944 msg = []945 tid = args['number']946 questinfo = self.api('%s.getrow' % self.sname)(tid, 'quests')947 if questinfo:948 questinfo = questinfo[0]949 linelen = self.api('plugins.getp')('proxy').api('setting.gets')('linelen')950 div = '@B' + '-' * linelen951 msg.append("@G%-6s %-2s %-2s %-2s %-2s %-3s" \952 " %-2s %-2s %-2s %-2s %-4s %-3s %s" % \953 ("ID", "QP", "MC", "TR", "LK",954 "DBL", "TL", "TP", "TN",955 "PR", "Gold", "Lvl", "Time"))956 msg.append(div)957 dbl = ''958 if int(questinfo['double']) == 1:959 dbl = dbl + 'D'960 if int(questinfo['daily']) == 1:961 dbl = dbl + 'E'962 leveld = self.api('aardu.convertlevel')(questinfo['level'])963 ttime = self.api('utils.formattime')(questinfo['finishtime'] - \964 questinfo['starttime'])965 if int(questinfo['failed']) == 1:966 ttime = 'Failed'967 msg.append("%-6s %2s %2s %2s %2s %3s" \968 " %2s %2s %2s %2s %4s %3s %8s" % \969 (questinfo['quest_id'], questinfo['qp'],970 questinfo['mccp'], questinfo['tierqp'], questinfo['lucky'],971 dbl, questinfo['totqp'], questinfo['tp'],972 questinfo['trains'], questinfo['pracs'], questinfo['gold'],973 leveld['level'], ttime))974 msg.append(div)975 msg.append('%-25s %-25s %-20s' % (questinfo['mobname'],976 questinfo['mobroom'],977 questinfo['mobarea']))978 msg.append(div)979 return True, msg980 def cmd_quests(self, args=None): # pylint: disable=too-many-statements981 """982 show quest stats983 """984 if self.statdb.getlastrowid('stats') <= 0:985 return True, ['No stats available']986 if self.statdb.getlastrowid('quests') <= 0:987 return True, ['No quests stats are available']988 count = 0989 if args:990 if args['number']:991 return self.show_quest(args)992 else:993 count = args['count']994 msg = []995 linelen = self.api('plugins.getp')('proxy').api('setting.gets')('linelen')996 div = '@B' + '-' * linelen997 tqrow = self.statdb.select(998 """SELECT AVG(finishtime - starttime) as avetime,999 SUM(qp) as qp,1000 AVG(qp) as qpquestave,1001 AVG(tierqp) as tierqpave,1002 SUM(tierqp) as tierqp,1003 AVG(mccp) as mccpave,1004 SUM(mccp) as mccp,1005 AVG(lucky) as luckyave,1006 SUM(lucky) as lucky,1007 AVG(opk) as opkave,1008 SUM(opk) as opk,1009 AVG(hardcore) as hardcoreave,1010 SUM(hardcore) as hardcore,1011 SUM(tp) as tp,1012 AVG(tp) as tpave,1013 SUM(trains) as trains,1014 AVG(trains) as trainsave,1015 SUM(pracs) as pracs,1016 AVG(pracs) as pracsave,1017 COUNT(*) as qindb,1018 SUM(totqp) as dboverall,1019 AVG(totqp) as dboverallave,1020 SUM(gold) as gold,1021 AVG(gold) as avegold FROM quests where failed = 0""")1022 stats = tqrow[0]1023 tfrow = self.statdb.select(1024 "SELECT COUNT(*) as failedindb FROM quests where failed != 0")1025 stats.update(tfrow[0])1026 tsrow = self.statdb.select(1027 """SELECT qpearned, questscomplete, questsfailed,1028 totallevels FROM stats WHERE milestone = 'current'""")1029 stats.update(tsrow[0])1030 stats['indb'] = stats['failedindb'] + stats['qindb']1031 stats['qplevelave'] = stats['qpearned']/float(stats['totallevels'])1032 msg.append(self._format_row('DB Stats', 'Total', 'In DB', '@G', '@G'))1033 msg.append(div)1034 msg.append(self._format_row("Quests",1035 stats['questscomplete'] + stats['questsfailed'],1036 stats['indb']))1037 msg.append(self._format_row("Quests Comp",1038 stats['questscomplete'], stats['qindb']))1039 msg.append(self._format_row("Quests Failed",1040 stats['questsfailed'], stats['failedindb']))1041 msg.append('')1042 msg.append(self._format_row("QP Stats", "Total", "Average", '@G', '@G'))1043 msg.append(div)1044 msg.append(self._format_row("Overall QP", stats['qpearned'],1045 format_float(stats['qplevelave'], "/level")))1046 msg.append(self._format_row("Quest QP", stats['qp'],1047 format_float(stats['qpquestave'], "/quest")))1048 msg.append(self._format_row("MCCP", stats['mccp'],1049 format_float(stats['mccpave'], "/quest")))1050 msg.append(self._format_row("Lucky", stats['lucky'],1051 format_float(stats['luckyave'], "/quest")))1052 msg.append(self._format_row("Tier", stats['tierqp'],1053 format_float(stats['tierqpave'], "/quest")))1054 msg.append(self._format_row("OPK", stats['opk'],1055 format_float(stats['opkave'], "/quest")))1056 msg.append(self._format_row("Hardcore", stats['hardcore'],1057 format_float(stats['hardcoreave'], "/quest")))1058 msg.append(self._format_row("QP Per Quest", "",1059 format_float(stats['dboverallave'], "/quest")))1060 msg.append(self._format_row("Gold",1061 self.api('utils.readablenumber')(stats['gold'], 2),1062 "%d/quest" % stats['avegold']))1063 msg.append(self._format_row("Time", "",1064 self.api('utils.formattime')(stats['avetime'])))1065 msg.append('')1066 msg.append(self._format_row("Bonus Rewards", "Total",1067 "Average", '@G', '@G'))1068 msg.append(div)1069 msg.append(self._format_row("TP", stats['tp'],1070 format_float(stats['tpave'], "/quest")))1071 msg.append(self._format_row("Trains", stats['trains'],1072 format_float(stats['trainsave'], "/quest")))1073 msg.append(self._format_row("Pracs", stats['pracs'],1074 format_float(stats['pracsave'], "/quest")))1075 if int(count) > 0:1076 lastitems = self.statdb.getlast('quests', int(count))1077 if len(lastitems) > 0: # pylint: disable=len-as-condition1078 msg.append('')1079 msg.append("@G%-6s %-2s %-2s %-2s %-2s %-2s %-2s %-3s" \1080 " %-2s %-2s %-2s %-2s %-4s %-3s %s" % \1081 ("ID", "QP", "MC", "TR", "LK",1082 "PK", "HC", "DBL", "TL", "TP", "TN",1083 "PR", "Gold", "Lvl", "Time"))1084 msg.append(div)1085 for item in lastitems:1086 dbl = ''1087 if int(item['double']) == 1:1088 dbl = dbl + 'D'1089 if int(item['daily']) == 1:1090 dbl = dbl + 'E'1091 leveld = self.api('aardu.convertlevel')(item['level'])1092 ttime = self.api('utils.formattime')(item['finishtime'] - \1093 item['starttime'])1094 if int(item['failed']) == 1:1095 ttime = 'Failed'1096 msg.append("%-6s %2s %2s %2s %2s %2s %2s %3s" \1097 " %2s %2s %2s %2s %4s %3s %8s" % \1098 (item['quest_id'], item['qp'],1099 item['mccp'], item['tierqp'], item['lucky'], item['opk'],1100 item['hardcore'], dbl, item['totqp'], item['tp'],1101 item['trains'], item['pracs'], item['gold'],1102 leveld['level'], ttime))1103 return True, msg1104 def show_level(self, args): # pylint: disable=too-many-locals,too-many-statements,too-many-branches1105 """1106 show info for a specific level in the database1107 """1108 msg = []1109 tid = args['number']1110 levelinfo = self.api('%s.getrow' % self.sname)(tid, 'levels')1111 linelen = self.api('plugins.getp')('proxy').api('setting.gets')('linelen')1112 div = '@B' + '-' * linelen1113 if levelinfo:1114 levelinfo = levelinfo[0]1115 bonus = 01116 if int(levelinfo['bonustrains']) > 0:1117 bonus = bonus + int(levelinfo['bonustrains'])1118 if int(levelinfo['blessingtrains']) > 0:1119 bonus = bonus + int(levelinfo['blessingtrains'])1120 if int(levelinfo['battlelearntrains'] > 0):1121 bonus = bonus + int(levelinfo['battlelearntrains'])1122 leveld = self.api('aardu.convertlevel')(levelinfo['level'])1123 levels = 're%st%sr%sl%s' % (leveld['redos'], leveld['tier'],1124 leveld['remort'], leveld['level'])1125 if levelinfo['finishtime'] != '-1' and levelinfo['starttime'] != '-1':1126 ttime = self.api('utils.formattime')(levelinfo['finishtime'] - \1127 levelinfo['starttime'])1128 else:1129 ttime = ''1130 if levelinfo['type'] == 'level':1131 ltype = 'lev'1132 else:1133 ltype = 'pup'1134 msg.append("@G%-6s %-5s %-7s %-s" % ("ID", "Type", "TotLvl", "Actual"))1135 msg.append("%-6s %-5s %-7s %-s" % (levelinfo['level_id'], ltype, levelinfo['level'],1136 levels))1137 msg.append("@G%-6s %2s %2s %-2s %-2s " % ("", "HP", "MN", "MV", "PR"))1138 msg.append("%-6s %2s %2s %-2s %-2s" % ("", levelinfo['hp'], levelinfo['mp'],1139 levelinfo['mv'], levelinfo['pracs']))1140 msg.append("@G%-6s %-2s %-2s %-2s %-2s" % ("", "TR", "BO", "BL", "BT"))1141 msg.append("%-6s %-2s %-2s %-2s %-2s" % ("", levelinfo['trains'],1142 levelinfo['bonustrains'],1143 levelinfo['blessingtrains'],1144 levelinfo['battlelearntrains']))1145 msg.append("@G%-6s %-1s %-1s %-1s %-1s %-1s %-1s" % \1146 ("", "S", "I", "W", "C", "D", "L"))1147 msg.append("%-6s %-1s %-1s %-1s %-1s %-1s %-1s" % \1148 ("", levelinfo['str'], levelinfo['int'],1149 levelinfo['wis'], levelinfo['con'], levelinfo['dex'],1150 levelinfo['luc']))1151 stmt = "SELECT count(*) as count, AVG(totalxp) as average FROM " \1152 "mobkills where time > %d and time < %d and xp > 0" % \1153 (levelinfo['starttime'], levelinfo['finishtime'])1154 tst = self.api('statdb.select')(stmt)1155 count = tst[0]['count']1156 ave = tst[0]['average']1157 if levelinfo['starttime'] or levelinfo['finishtime']:1158 msg.append(div)1159 if levelinfo['starttime']:1160 msg.append('Started : %s' % time.strftime(1161 "%a, %d %b %Y %H:%M:%S +0000",1162 time.localtime(levelinfo['starttime'])))1163 if levelinfo['finishtime']:1164 if levelinfo['finishtime'] == -1:1165 fstr = 'Current'1166 else:1167 fstr = time.strftime("%a, %d %b %Y %H:%M:%S +0000",1168 time.localtime(levelinfo['finishtime']))1169 msg.append('Finished : %s' % fstr)1170 if count > 0 and ave > 0:1171 msg.append(div)1172 length = levelinfo['finishtime'] - levelinfo['starttime']1173 if ttime:1174 tmsg = "It took %s with " % ttime1175 else:1176 tmsg = ""1177 tmsg = tmsg + '@G%s@w mobs killed' % count1178 tmsg = tmsg + ' (@G%02.02f@w xp/mob)' % (ave)1179 perlevel = self.api('GMCP.getv')('char.base.perlevel')1180 if length and perlevel:1181 expmin = self.api('GMCP.getv')('char.base.perlevel')/(length/60)1182 tmsg = tmsg + ' @G%02d@w xp/min' % (expmin)1183 msg.append(tmsg)1184 msg.append(div)1185 return True, msg1186 def cmd_levels(self, args=None): # pylint: disable=too-many-locals,too-many-branches,too-many-statements1187 """1188 show level stats1189 """1190 if self.statdb.getlastrowid('stats') <= 0:1191 return True, ['No stats available']1192 if self.statdb.getlastrowid('levels') <= 0:1193 return True, ['No levels/pups stats available']1194 count = 01195 if args:1196 if args['number']:1197 return self.show_level(args)1198 else:1199 count = args['count']1200 msg = []1201 pups = {}1202 levels = {}1203 linelen = self.api('plugins.getp')('proxy').api('setting.gets')('linelen')1204 div = '@B' + '-' * linelen1205 lrow = self.statdb.select(1206 "SELECT totallevels, qpearned FROM stats WHERE milestone = 'current'")1207 levels.update(lrow[0])1208 prow = self.statdb.select(1209 "SELECT MAX(powerupsall) as powerupsall FROM stats")1210 pups.update(prow[0])1211 levels['qpave'] = int(levels['qpearned']) / int(levels['totallevels'])1212 llrow = self.statdb.select("""1213 SELECT AVG(trains) as avetrains,1214 AVG(bonustrains) as avebonustrains,1215 AVG(blessingtrains) as aveblessingtrains,1216 AVG(battlelearntrains) as avebattlelearntrains,1217 SUM(trains + bonustrains + blessingtrains + battlelearntrains) as totaltrains,1218 SUM(pracs) as totalpracs,1219 COUNT(*) as indb1220 FROM levels where type = 'level' and trains > 01221 """)1222 levels.update(llrow[0])1223 ltrow = self.statdb.select("""1224 SELECT AVG(finishtime - starttime) as avetime FROM levels1225 where type = 'level' and finishtime <> -1 and trains > 01226 """)1227 levels.update(ltrow[0])1228 pprow = self.statdb.select("""1229 SELECT AVG(trains) as avetrains,1230 AVG(bonustrains) as avebonustrains,1231 AVG(blessingtrains) as aveblessingtrains,1232 AVG(battlelearntrains) as avebattlelearntrains,1233 SUM(trains + bonustrains + blessingtrains + battlelearntrains) as totaltrains,1234 COUNT(*) as indb1235 FROM levels where type = 'pup'1236 """)1237 pups.update(pprow[0])1238 ptrow = self.statdb.select("""1239 SELECT AVG(finishtime - starttime) as avetime FROM levels1240 where type = 'pup' and finishtime <> -11241 """)1242 pups.update(ptrow[0])1243 msg.append(self._format_row('Type', 'Levels', 'Pups', '@G', '@G'))1244 msg.append(div)1245 msg.append(self._format_row("Total Overall",1246 levels['totallevels'], pups['powerupsall']))1247 msg.append(self._format_row("Total In DB",1248 levels['indb'], pups['indb']))1249 msg.append(self._format_row("Total Trains",1250 levels['totaltrains'] or 0, pups['totaltrains'] or 0))1251 trainitems = [1252 ['Ave Trains', 'avetrains'],1253 ['Ave Bon Trains', 'avebonustrains'],1254 ['Ave Bls Trains', 'aveblessingtrains'],1255 ['Ave BaL Trains', 'avebattlelearntrains'],1256 ]1257 levelave = float(0)1258 pupave = float(0)1259 for i in trainitems:1260 title = i[0]1261 lkey = i[1]1262 lave = format_float(levels[lkey])1263 pave = format_float(pups[lkey])1264 levelave = float(levelave) + float(lave)1265 pupave = float(pupave) + float(pave)1266 msg.append(self._format_row(title,1267 lave or 0, pave or 0))1268 msg.append(self._format_row("Ave Overall",1269 levelave or 0, pupave or 0))1270 msg.append(self._format_row("Total Pracs",1271 levels['totalpracs'], ""))1272 if levels['avetime']:1273 lavetime = self.api('utils.formattime')(levels['avetime'])1274 else:1275 lavetime = ""1276 if pups['avetime']:1277 pavetime = self.api('utils.formattime')(pups['avetime'])1278 else:1279 pavetime = ""1280 msg.append(self._format_row("Time", lavetime, pavetime))1281 if int(count) > 0:1282 lastitems = self.statdb.getlast('levels', int(count))1283 if len(lastitems) > 0: # pylint: disable=len-as-condition1284 msg.append('')1285 msg.append("@G%-6s %-3s %2s %2s %2s %-2s %-2s %-2s" \1286 " %-2s %-1s %-1s %-1s %-1s %-1s %-1s %s" % \1287 ("ID", "Lvl", "T",1288 "TR", "BT", "PR", "HP", "MN", "MV", "S",1289 "I", "W", "C", "D", "L", "Time"))1290 msg.append(div)1291 for item in lastitems:1292 bonus = 01293 if int(item['bonustrains']) > 0:1294 bonus = bonus + int(item['bonustrains'])1295 if int(item['blessingtrains']) > 0:1296 bonus = bonus + int(item['blessingtrains'])1297 leveld = self.api('aardu.convertlevel')(item['level'])1298 if item['finishtime'] != '-1' and item['starttime'] != '-1':1299 ttime = self.api('utils.formattime')(item['finishtime'] - \1300 item['starttime'])1301 else:1302 ttime = ''1303 if item['type'] == 'level':1304 ltype = 'L'1305 else:1306 ltype = 'P'1307 msg.append("%-6s %-3s %2s %2s %2s %-2s %-2s %-2s" \1308 " %-2s %-1s %-1s %-1s %-1s %-1s %-1s %s" % \1309 (item['level_id'], leveld['level'], ltype, item['trains'],1310 bonus, item['pracs'], item['hp'], item['mp'],1311 item['mv'], item['str'], item['int'], item['wis'],1312 item['con'], item['dex'], item['luc'], ttime))1313 return True, msg1314 def show_cp(self, args):1315 """1316 show info for a specific cp in the database1317 """1318 msg = []1319 tid = args['number']1320 cpinfo = self.api('%s.getrow' % self.sname)(tid, 'campaigns')1321 linelen = self.api('plugins.getp')('proxy').api('setting.gets')('linelen')1322 div = '@B' + '-' * linelen1323 if cpinfo:1324 cpinfo = cpinfo[0]1325 mobs = self.api('%s.select' % self.sname)(1326 "SELECT * FROM cpmobs WHERE cp_id = %s" % tid)1327 msg.append("@G%-6s %-12s %-2s %-2s %-2s %-2s %-2s %6s %-4s %s" % \1328 ("ID", "Lvl", "QP", "BN",1329 "TP", "TN", "PR", "Gold", "Mobs", "Time"))1330 msg.append(div)1331 leveld = self.api('aardu.convertlevel')(cpinfo['level'])1332 levelstr = 'T%d R%d L%d' % (leveld['tier'], leveld['remort'],1333 leveld['level'])1334 if cpinfo['finishtime'] != '-1' and cpinfo['starttime'] != '-1':1335 ttime = self.api('utils.formattime')(cpinfo['finishtime'] - \1336 cpinfo['starttime'])1337 else:1338 ttime = ''1339 if int(cpinfo['failed']) == 1:1340 ttime = 'Failed'1341 msg.append("%-6s %-12s %-2s %2s %2s %2s %2s %6s %-3s %s" % \1342 (cpinfo['cp_id'], levelstr, cpinfo['qp'], cpinfo['bonusqp'],1343 cpinfo['tp'], cpinfo['trains'], cpinfo['pracs'], cpinfo['gold'],1344 len(mobs), ttime))1345 msg.append(div)1346 msg.append("@G%-30s %-30s" % ("Name", "Location"))1347 msg.append(div)1348 for i in mobs:1349 msg.append("@G%-30s %-30s" % (i['name'],1350 i['location']))1351 msg.append(div)1352 return True, msg1353 def cmd_cps(self, args=None): # pylint: disable=too-many-locals,too-many-branches,too-many-statements1354 """1355 show cp stats1356 """1357 if self.statdb.getlastrowid('stats') <= 0:1358 return True, ['No stats available']1359 if self.statdb.getlastrowid('campaigns') <= 0:1360 return True, ['No campaign stats available']1361 count = 01362 if args:1363 if args['number']:1364 return self.show_cp(args)1365 else:1366 count = args['count']1367 msg = []1368 stats = {}1369 linelen = self.api('plugins.getp')('proxy').api('setting.gets')('linelen')1370 div = '@B' + '-' * linelen1371 trow = self.statdb.select(1372 "SELECT campaignsdone, campaignsfld, totallevels " \1373 "FROM stats WHERE milestone = 'current'")1374 stats.update(trow[0])1375 trow = self.statdb.select(1376 """SELECT AVG(finishtime - starttime) as avetime,1377 SUM(qp) as totalqp,1378 AVG(qp) as aveqp,1379 SUM(tp) as totaltp,1380 AVG(tp) as avetp,1381 SUM(trains) as totaltrains,1382 AVG(trains) as avetrains,1383 SUM(pracs) as totalpracs,1384 AVG(pracs) as avepracs,1385 COUNT(*) as cindb,1386 SUM(gold) as totalgold,1387 AVG(gold) as avegold1388 FROM campaigns where failed = 0""")1389 stats.update(trow[0])1390 trow = self.statdb.select(1391 "SELECT COUNT(*) as failedindb FROM campaigns where failed != 0")1392 stats.update(trow[0])1393 stats['indb'] = int(stats['cindb']) + int(stats['failedindb'])1394 stats['totalcps'] = int(stats['campaignsdone']) + \1395 int(stats['campaignsfld'])1396 msg.append(self._format_row('DB Stats', 'Total', 'In DB', '@G', '@G'))1397 msg.append(div)1398 msg.append(self._format_row("Overall",1399 stats['totalcps'], stats['indb'] or 0))1400 msg.append(self._format_row("Completed",1401 stats['campaignsdone'], stats['cindb'] or 0))1402 msg.append(self._format_row("Failed",1403 stats['campaignsfld'], stats['failedindb'] or 0))1404 msg.append('')1405 msg.append(self._format_row('CP Stats', 'Total', 'Average', '@G', '@G'))1406 msg.append(div)1407 msg.append(self._format_row("QP",1408 stats['totalqp'] or 0,1409 format_float(stats['aveqp'], "/CP")))1410 if stats['totalgold']:1411 tempg = self.api('utils.readablenumber')(stats['totalgold'])1412 else:1413 tempg = 01414 msg.append(self._format_row("Gold",1415 tempg,1416 "%d/CP" % stats['avegold']))1417 if stats['avetime']:1418 atime = self.api('utils.formattime')(stats['avetime'])1419 else:1420 atime = ""1421 msg.append(self._format_row("Time", "", atime))1422 msg.append('')1423 msg.append(self._format_row("Bonus Rewards", "Total",1424 "Average", '@G', '@G'))1425 msg.append(div)1426 msg.append(self._format_row("TP",1427 stats['totaltp'] or 0,1428 format_float(stats['avetp'], "/CP")))1429 msg.append(self._format_row("Trains",1430 stats['totaltrains'] or 0,1431 format_float(stats['avetrains'], "/CP")))1432 msg.append(self._format_row("Pracs",1433 stats['totalpracs'] or 0,1434 format_float(stats['avepracs'], "/CP")))1435 if int(count) > 0:1436 lastitems = self.statdb.getlast('campaigns', int(count))1437 mobc = self.statdb.selectbykeyword(1438 'SELECT cp_id, count(*) as mobcount from cpmobs group by cp_id',1439 'cp_id')1440 if len(lastitems) > 0: # pylint: disable=len-as-condition1441 msg.append('')1442 msg.append("@G%-6s %-12s %-2s %-2s %-2s %-2s %-2s %6s %-4s %s" % \1443 ("ID", "Lvl", "QP", "BN", "TP", "TN",1444 "PR", "Gold", "Mobs", "Time"))1445 msg.append(div)1446 for item in lastitems:1447 leveld = self.api('aardu.convertlevel')(item['level'])1448 levelstr = 'T%d R%d L%d' % (leveld['tier'], leveld['remort'],1449 leveld['level'])1450 if item['finishtime'] != '-1' and item['starttime'] != '-1':1451 ttime = self.api('utils.formattime')(item['finishtime'] - \1452 item['starttime'])1453 else:1454 ttime = ''1455 if int(item['failed']) == 1:1456 ttime = 'Failed'1457 msg.append("%-6s %-12s %-2s %2s %2s %2s %2s %6s %-3s %s" % \1458 (item['cp_id'], levelstr, item['qp'], item['bonusqp'],1459 item['tp'], item['trains'], item['pracs'], item['gold'],1460 mobc[item['cp_id']]['mobcount'], ttime))1461 return True, msg1462 def show_gq(self, args):1463 """1464 show info for a specific gq in the database1465 """1466 msg = []1467 tid = args['number']1468 gqinfo = self.api('%s.getrow' % self.sname)(tid, 'gquests')1469 linelen = self.api('plugins.getp')('proxy').api('setting.gets')('linelen')1470 div = '@B' + '-' * linelen1471 if gqinfo:1472 gqinfo = gqinfo[0]1473 mobs = self.api('%s.select' % self.sname)(1474 "SELECT * FROM gqmobs WHERE gq_id = %s" % tid)1475 msg.append("@G%-6s %-12s %-2s %-2s %-2s %-2s %-2s %6s %-4s %s" % \1476 ("ID", "Lvl", "QP", "QM", "TP",1477 "TN", "PR", "Gold", "Mobs", "Time"))1478 msg.append(div)1479 leveld = self.api('aardu.convertlevel')(gqinfo['level'])1480 levelstr = 'T%d R%d L%d' % (leveld['tier'], leveld['remort'],1481 leveld['level'])1482 if gqinfo['finishtime'] != '-1' and gqinfo['starttime'] != '-1':1483 ttime = self.api('utils.formattime')(gqinfo['finishtime'] - \1484 gqinfo['starttime'])1485 else:1486 ttime = ''1487 msg.append("%-6s %-12s %2s %2s %2s %2s %2s %6s %-3s %s" % \1488 (gqinfo['gq_id'], levelstr, gqinfo['qp'], gqinfo['qpmobs'],1489 gqinfo['tp'], gqinfo['trains'], gqinfo['pracs'],1490 gqinfo['gold'], len(mobs), ttime))1491 msg.append(div)1492 msg.append("@G%-5s %-30s %-30s" % ("Num", "Name", "Location"))1493 msg.append(div)1494 for i in mobs:1495 msg.append("@G%-5s %-30s %-30s" % (i['num'], i['name'],1496 i['location']))1497 msg.append(div)1498 return True, msg1499 def cmd_gqs(self, args=None): # pylint: disable=too-many-locals,too-many-statements1500 """1501 show gq stats1502 """1503 if self.statdb.getlastrowid('stats') <= 0:1504 return True, ['No stats available']1505 if self.statdb.getlastrowid('gquests') <= 0:1506 return True, ['No gq stats available']1507 count = 01508 if args:1509 if args['number']:1510 return self.show_gq(args)1511 else:1512 count = args['count']1513 msg = []1514 stats = {}1515 linelen = self.api('plugins.getp')('proxy').api('setting.gets')('linelen')1516 div = '@B' + '-' * linelen1517 wrow = self.statdb.select(1518 """SELECT AVG(finishtime - starttime) as avetime,1519 SUM(qp) as qp,1520 AVG(qp) as qpave,1521 SUM(qpmobs) as qpmobs,1522 AVG(qpmobs) as qpmobsave,1523 SUM(tp) as tp,1524 AVG(tp) as tpave,1525 SUM(trains) as trains,1526 AVG(trains) as trainsave,1527 SUM(pracs) as pracs,1528 AVG(pracs) as pracsave,1529 COUNT(*) as indb,1530 SUM(gold) as gold,1531 AVG(gold) as avegold1532 FROM gquests where won = 1""")1533 stats['won'] = wrow[0]1534 trow = self.statdb.select(1535 "SELECT gquestswon FROM stats WHERE milestone = 'current'")1536 stats.update(trow[0])1537 trow = self.statdb.select(1538 """SELECT AVG(finishtime - starttime) as avetime,1539 SUM(qpmobs) as totalqp,1540 AVG(qpmobs) as aveqp,1541 COUNT(*) as indb1542 FROM gquests where won != 1""")1543 stats['lost'] = trow[0]1544 trow = self.statdb.select(1545 """SELECT SUM(qpmobs + qp) as overallqp,1546 AVG(qpmobs + qp) as aveoverallqp1547 FROM gquests""")1548 stats.update(trow[0])1549 stats['indb'] = stats['won']['indb'] + stats['lost']['indb']1550 stats['overall'] = stats['gquestswon'] + stats['lost']['indb']1551 msg.append(self._format_row('GQ Stats', 'Total', 'In DB', '@G', '@G'))1552 msg.append(div)1553 msg.append(self._format_row("Won",1554 stats['gquestswon'], stats['won']['indb'] or 0))1555 msg.append(self._format_row("Lost",1556 "", stats['lost']['indb'] or 0))1557 msg.append(self._format_row("Overall",1558 stats['overall'], stats['indb'] or 0))1559 msg.append(self._format_row("QP",1560 stats['overallqp'],1561 format_float(stats['aveoverallqp'], "/GQ")))1562 msg.append('')1563 msg.append(self._format_row('GQ Won Stats', 'Total', 'Average',1564 '@G', '@G'))1565 msg.append(div)1566 msg.append(self._format_row("GQ QP",1567 stats['won']['qp'],1568 format_float(stats['won']['qpave'], "/GQ")))1569 msg.append(self._format_row("GQ MOB QP",1570 stats['won']['qpmobs'],1571 format_float(stats['won']['qpmobsave'], "/GQ")))1572 if stats['won']['avetime']:1573 atime = self.api('utils.formattime')(stats['won']['avetime'])1574 else:1575 atime = ""1576 msg.append(self._format_row("Time", "", atime))1577 msg.append(self._format_row("Gold",1578 self.api('utils.readablenumber')(stats['won']['gold']),1579 "%d/GQ" % stats['won']['avegold']))1580 msg.append(self._format_row("TP",1581 stats['won']['tp'],1582 format_float(stats['won']['tpave'], "/GQ")))1583 msg.append(self._format_row("Trains",1584 stats['won']['trains'],1585 format_float(stats['won']['trainsave'], "/GQ")))1586 msg.append(self._format_row("Pracs",1587 stats['won']['pracs'],1588 format_float(stats['won']['pracsave'], "/GQ")))1589 msg.append('')1590 msg.append(self._format_row('GQ Lost Stats', 'Total', 'Average',1591 '@G', '@G'))1592 msg.append(div)1593 msg.append(self._format_row("GQ MOB QP",1594 stats['lost']['totalqp'],1595 format_float(stats['lost']['aveqp'], "/GQ")))1596 if int(count) > 0:1597 lastitems = self.statdb.getlast('gquests', int(count))1598 mobc = self.statdb.selectbykeyword(1599 'SELECT gq_id, SUM(num) as mobcount from gqmobs group by gq_id',1600 'gq_id')1601 if len(lastitems) > 0: # pylint: disable=len-as-condition1602 msg.append('')1603 msg.append("@G%-6s %-12s %-2s %-2s %-2s %-2s %-2s %6s %-4s %s" % \1604 ("ID", "Lvl", "QP", "QM", "TP",1605 "TN", "PR", "Gold", "Mobs", "Time"))1606 msg.append(div)1607 for item in lastitems:1608 leveld = self.api('aardu.convertlevel')(item['level'])1609 levelstr = 'T%d R%d L%d' % (leveld['tier'], leveld['remort'],1610 leveld['level'])1611 if item['finishtime'] != '-1' and item['starttime'] != '-1':1612 ttime = self.api('utils.formattime')(item['finishtime'] - \1613 item['starttime'])1614 else:1615 ttime = ''1616 msg.append("%-6s %-12s %2s %2s %2s %2s %2s %6s %-3s %s" % \1617 (item['gq_id'], levelstr, item['qp'], item['qpmobs'],1618 item['tp'], item['trains'], item['pracs'], item['gold'],1619 mobc[item['gq_id']]['mobcount'], ttime))1620 return True, msg1621 def cmd_mobs(self, args=None): # pylint: disable=too-many-locals,too-many-branches,too-many-statements1622 """1623 show mobs stats1624 """1625 if self.statdb.getlastrowid('stats') <= 0:1626 return True, ['No stats available']1627 if self.statdb.getlastrowid('mobkills') <= 0:1628 return True, ['No mob stats available']1629 count = 01630 if args:1631 count = args['count']1632 msg = []1633 stats = {}1634 linelen = self.api('plugins.getp')('proxy').api('setting.gets')('linelen')1635 div = '@B' + '-' * linelen1636 trow = self.statdb.select(1637 "SELECT monsterskilled FROM stats WHERE milestone = 'current'")1638 stats.update(trow[0])1639 trow = self.statdb.select(1640 """SELECT SUM(xp) AS xp,1641 SUM(rarexp) as rarexp,1642 SUM(bonusxp) AS bonusxp,1643 SUM(blessingxp) AS blessingxp,1644 SUM(totalxp) as totalxp,1645 AVG(xp) AS avexp,1646 AVG(totalxp) AS avetotalxp,1647 SUM(tp) AS tp,1648 SUM(vorpal) AS vorpal,1649 SUM(assassinate) AS assassinate,1650 SUM(disintegrate) AS disintegrate,1651 SUM(banishment) AS banishment,1652 SUM(slit) AS slit,1653 SUM(deathblow) AS deathblow,1654 SUM(gold) AS gold,1655 AVG(gold) AS avegold,1656 COUNT(*) AS indb1657 FROM mobkills""")1658 stats.update(trow[0])1659 trow = self.statdb.select(1660 """SELECT AVG(bonusxp) as avebonusxp,1661 COUNT(*) as bonusmobsindb1662 FROM mobkills where bonusxp > 0""")1663 stats.update(trow[0])1664 trow = self.statdb.select(1665 """SELECT AVG(blessingxp) as aveblessxp,1666 COUNT(*) as blessmobsindb1667 FROM mobkills where blessingxp > 0""")1668 stats.update(trow[0])1669 trow = self.statdb.select(1670 """SELECT AVG(rarexp) as averarexp,1671 COUNT(*) as raremobsindb1672 FROM mobkills where rarexp > 0""")1673 stats.update(trow[0])1674 msg.append(self._format_row('DB Stats', 'Total', 'In DB', '@G', '@G'))1675 msg.append(div)1676 msg.append(self._format_row("Overall",1677 stats['monsterskilled'], stats['indb'] or 0))1678 msg.append(self._format_row("Rare Mobs",1679 "", stats['raremobsindb'] or 0))1680 msg.append(self._format_row("Bonus Mobs",1681 "", stats['bonusmobsindb'] or 0))1682 msg.append(self._format_row("Blessing Mobs",1683 "", stats['blessmobsindb'] or 0))1684 msg.append('')1685 msg.append(self._format_row('Stats', 'Total', 'Average', '@G', '@G'))1686 msg.append(div)1687 msg.append(self._format_row("XP",1688 stats['xp'],1689 format_float(stats['avexp'], "/kill")))1690 msg.append(self._format_row("Rare XP",1691 stats['rarexp'],1692 format_float(stats['averarexp'], "/kill")))1693 msg.append(self._format_row("Double XP",1694 stats['bonusxp'],1695 format_float(stats['avebonusxp'], "/kill")))1696 msg.append(self._format_row("Blessing XP",1697 stats['blessingxp'],1698 format_float(stats['aveblessxp'], "/kill")))1699 msg.append(self._format_row("Total XP",1700 stats['totalxp'],1701 format_float(stats['avetotalxp'], "/kill")))1702 msg.append(self._format_row("Gold",1703 self.api('utils.readablenumber')(stats['gold']),1704 "%d/kill" % stats['avegold']))1705 msg.append(self._format_row("TP",1706 stats['tp'],1707 format_float(stats['tp'] / float(stats['indb']),1708 "/kill")))1709 avetype = stats['vorpal'] / float(stats['indb'])1710 msg.append(self._format_row("Vorpal",1711 stats['vorpal'],1712 format_float(avetype, "/kill") or ""))1713 avetype = stats['assassinate'] / float(stats['indb'])1714 msg.append(self._format_row("Assassinate",1715 stats['assassinate'],1716 format_float(avetype, "/kill") or ""))1717 avetype = stats['slit'] / float(stats['indb'])1718 msg.append(self._format_row("Slit",1719 stats['slit'],1720 format_float(avetype, "/kill") or ""))1721 avetype = stats['banishment'] / float(stats['indb'])1722 msg.append(self._format_row("Banishment",1723 stats['banishment'],1724 format_float(avetype, "/kill") or ""))1725 avetype = stats['deathblow'] / float(stats['indb'])1726 msg.append(self._format_row("Deathblow",1727 stats['deathblow'],1728 format_float(avetype, "/kill") or ""))1729 avetype = stats['disintegrate'] / float(stats['indb'])1730 msg.append(self._format_row("Disintegrate",1731 stats['disintegrate'],1732 format_float(avetype, "/kill") or ""))1733 if int(count) > 0:1734 lastitems = self.statdb.getlast('mobkills', int(count))1735 if lastitems:1736 msg.append('')1737 msg.append("@G%3s %-18s %-3s %-3s %-3s %-3s %2s %1s %s" % \1738 ("Lvl", "Mob", "TXP", "XP", "RXP",1739 "OXP", "TP", "S", "Gold"))1740 msg.append(div)1741 for item in lastitems:1742 leveld = self.api('aardu.convertlevel')(item['level'])1743 levelstr = leveld['level']1744 bonus = ''...
_cursor_formatters.py
Source:_cursor_formatters.py
...74 yield self._format_dump(b)75 else:76 row = self.cursor.fetchone()77 while row is not None:78 yield self._format_row(row)79 row = self.cursor.fetchone()80 finally:81 self.cursor.close()82 def _prepare_row(self, row):83 return row84 def _format_dump(self, data):85 raise NotImplementedError("{} does not support formatting dumped data.".format(self.__class__.__name__))86 def _format_row(self, row):87 raise NotImplementedError("{} does not support formatting streaming data.".format(self.__class__.__name__))88class PandasCursorFormatter(CursorFormatter):89 """90 Formats a cursor into pandas datatypes.91 Dumped data is transformed into a pandas DataFrame.92 Streamed data is transformed into lists of pandas Series objects.93 """94 def _init(self, index_fields=None, date_fields=None):95 self.index_fields = index_fields96 self.date_fields = date_fields97 def _format_dump(self, data):98 import pandas as pd99 df = pd.DataFrame(data=data, columns=self.column_names)100 if self.date_fields is not None:101 try:102 df = pd.io.sql._parse_date_columns(df, self.date_fields)103 except Exception as e:104 logger.warning('Unable to parse date columns. Perhaps your version of pandas is outdated.'105 'Original error message was: {}: {}'.format(e.__class__.__name__, str(e)))106 if self.index_fields is not None:107 df.set_index(self.index_fields, inplace=True)108 return df109 def _format_row(self, row):110 import pandas as pd111 # TODO: Handle parsing of date fields112 return pd.Series(row, index=self.column_names)113class DictCursorFormatter(CursorFormatter):114 """115 Formats a cursor into a list of dictionaries.116 """117 def _format_dump(self, data):118 return [self._format_row(row) for row in data]119 def _format_row(self, row):120 return dict(zip(self.column_names, row))121class TupleCursorFormatter(CursorFormatter):122 """123 Formats a cursor into a list of tuples.124 """125 def _format_dump(self, data):126 return [self._format_row(row) for row in data]127 def _format_row(self, row):128 return tuple(row)129class RawCursorFormatter(CursorFormatter):130 """131 Applies the trivial transformation to each row in the cursor.132 """133 def _format_dump(self, data):134 return data135 def _format_row(self, row):136 return row137class CsvCursorFormatter(CursorFormatter):138 """139 Formats each row of the cursor as a comma-separated value string.140 """141 FORMAT_PARAMS = {142 'delimiter': ',',143 'doublequote': False,144 'escapechar': '\\',145 'lineterminator': '\r\n',146 'quotechar': '"',147 'quoting': csv.QUOTE_MINIMAL148 }149 def _init(self, include_header=True):150 self.output = io.StringIO() if six.PY3 else io.BytesIO()151 self.include_header = include_header152 self.writer = csv.writer(self.output, **self.FORMAT_PARAMS)153 def _format_dump(self, data):154 if self.include_header:155 self.writer.writerow(self.column_names)156 try:157 self.writer.writerows(data)158 return self.output.getvalue()159 finally:160 self.output.truncate(0)161 self.output.seek(0)162 def _format_row(self, row):163 try:164 self.writer.writerow(row)165 return self.output.getvalue()166 finally:167 self.output.truncate(0)168 self.output.seek(0)169class HiveCursorFormatter(CsvCursorFormatter):170 """171 Formats each row of the cursor as a tab-separated value string.172 Note: `None` values are transformed into the hive-specific representation of173 `'\\N'`.174 """175 FORMAT_PARAMS = {176 'delimiter': '\t',...
pandas_summary.py
Source:pandas_summary.py
...11 df = pd.DataFrame()12 def reset(self):13 self.df.drop(self.df.index, inplace=True)14 def add(self, summary_row):15 def _format_row(row):16 if self.summary_cols is None:17 return row18 19 return {key: value for key, value in row.items() if key in self.summary_cols}20 if isinstance(summary_row, list):21 rows = [_format_row({**self.static_fields, **row}) for row in summary_row]22 else:23 rows = [_format_row({**self.static_fields, **summary_row})]24 self.df = self.df.append(rows, ignore_index=True)25 def dump(self, path, reset=True):26 if not self.df.empty:27 is_first_dump = not os.path.exists(path)28 self.df.to_csv(path, mode='a',29 index=False, header=is_first_dump)30 log_string = self.df.tail(10).mean()31 if reset:32 self.reset()33 return log_string34 def load(self, path):35 if os.path.exists(path):36 self.df = pd.read_csv(path)37 else:...
Automation Testing Tutorials
Learn to execute automation testing from scratch with LambdaTest Learning Hub. Right from setting up the prerequisites to run your first automation test, to following best practices and diving deeper into advanced test scenarios. LambdaTest Learning Hubs compile a list of step-by-step guides to help you be proficient with different test automation frameworks i.e. Selenium, Cypress, TestNG etc.
LambdaTest Learning Hubs:
- JUnit Tutorial
- TestNG Tutorial
- Webdriver Tutorial
- WebDriverIO Tutorial
- Protractor Tutorial
- Selenium 4 Tutorial
- Jenkins Tutorial
- NUnit Tutorial
- Jest Tutorial
- Playwright Tutorial
- Cypress Tutorial
- PyTest Tutorial
YouTube
You could also refer to video tutorials over LambdaTest YouTube channel to get step by step demonstration from industry experts.
Run autotest automation tests on LambdaTest cloud grid
Perform automation testing on 3000+ real desktop and mobile devices online.
Try LambdaTest Now !!
Get 100 minutes of automation test minutes FREE!!
Was this article helpful?
