db = MySQLdb.connect('localhost',
config['dbuser'],
config['dbpass'],
'cmoc',
charset='utf8mb4')
cursor = db.cursor()
bl = BestList()
pr = Prepare()
cursor.execute('SELECT id FROM contests WHERE status = \'results\'')
ids = cursor.fetchall()
for id in ids:
id = id[0]
cursor.execute(
'SELECT conmiis.entryno, conmiis.craftsno, conmiis.miidata, artisan.miidata, artisan.country, artisan.master FROM conmiis, artisan WHERE conmiis.craftsno = artisan.craftsno AND conmiis.contest = %s ORDER BY conmiis.likes DESC LIMIT 50',
[id])
miis = cursor.fetchall()
build = bl.build(id, miis)
with open(
'{}/contest/{}/best_list.ces'.format(config['miicontest_path'],
id), 'wb') as file:
file.write(pr.prepare(build))
with open('decfiles/contests/{}/best_list.dec'.format(id), 'wb+') as file:
file.write(build)
db.close()
#example script gets every single mii in the DB, then adds it to spot_list
ql = QuickList()
pr = Prepare()
miilist = []
artisanlist = []
miidata = 'gAoAPwAAAAAAAAAAAAAAAAAAAAAAAF4AhonbB8JJnRIgBDxAuX0ookiKBEAAMZkEAIoAiiUEAAAAAAAAAAAAAAAAAAAAAAAAAAAaLw=='
likes = 0
skill = 0
country = 49
initial = 'AA'
artisandata = 'gAsAUABlAGUAdwBlAGUAAAAAAAAAAAAAhorkD1RU1sYgADxAub0IPAiQCEAUabiQAIoAiiUEAAAAAAAAAAAAAAAAAAAAAAAAAAC68Q=='
master = 0
ResetList(b'NL')
for i in range(499):
miilist.append((i, initial, likes, skill, country, miidata) +
(artisandata, i, master))
list_type = 'NL'
data = ql.build(list_type, miilist)
with open('150/new_list01.ces', 'wb') as file:
file.write(pr.prepare(data))
with open('150/new_list01.dec', 'wb') as file:
file.write(data)
pr = Prepare()
cursor.execute("SELECT id FROM contests WHERE status = 'judging'")
ids = cursor.fetchall()
for id in ids:
id = id[0]
cursor.execute(
"SELECT craftsno, miidata FROM conmiis WHERE contest = %s ORDER BY RAND()",
[id])
result = cursor.fetchall()
miis = []
for i in result:
miis.append((i[0], i[1]))
build = el.build(id, miis)
for e in range(len(build)):
with open(
"{}/contest/{}/entry_list{}.ces".format(
config["miicontest_path"], id, e + 1),
"wb",
) as file:
file.write(pr.prepare(build[e]))
with open("decfiles/contests/{}/entry_list{}.dec".format(id, e + 1),
"wb+") as file:
file.write(build[e])
db.close()
