User:Hkm/Rankings program - Revision history

Hkm: Replaced content with "Ask hkm for the program if you're interested in helping out with the project!"

2025-05-30T05:15:59Z

Replaced content with "Ask hkm for the program if you're interested in helping out with the project!"

Show changes

Hkm at 06:45, 7 April 2025

2025-04-07T06:45:43Z

Show changes

ArrowHead294 at 14:37, 3 April 2025

2025-04-03T14:37:54Z

← Older revision		Revision as of 14:37, 3 April 2025
Line 192:		Line 192:

	clip += '''{\| class="wikitable sortable" style="margin: auto; max-width: 800px; width: 100%;"		clip += '''{\| class="wikitable sortable" style="margin: auto; max-width: 800px; width: 100%;"
	! Creator !! Work !! Tuning !! Notes !! R !! #		\|-
			! Creator !! Work !! Tuning !! Notes !! Rating !! {{nowrap\|Number of ratings}}

	'''		'''

Hkm at 20:40, 29 March 2025

2025-03-29T20:40:55Z

← Older revision		Revision as of 20:40, 29 March 2025
Line 7:		Line 7:
	from bs4 import BeautifulSoup		from bs4 import BeautifulSoup
	import pyperclip		import pyperclip

			def extract_display_text(wiki_text):
			# Process internal links: [[Page\|Display]] → Display (or Page if no Display)
			processed_text = re.sub(
			r'\[\[(.?)(?:\\|(.?))?\]\]',
			lambda m: m.group(2) if m.group(2) else m.group(1),
			wiki_text
			)

			# Process external links: [URL Display] → Display (remove if no Display)
			processed_text = re.sub(
			r'\[(https?://\S+)(?:\s+([^\]]+))?\]',
			lambda m: m.group(2) if m.group(2) else '',
			processed_text
			)

			return processed_text

	def process_talk(url):		def process_talk(url):
Line 127:		Line 144:

	# Split the second part into LINK and NAME		# Split the second part into LINK and NAME
	~~link_name~~ = parts[1].strip()		print(parts)
	~~if link_name[0] == "[" and link_name[-1] == "]":~~		link = parts[1].strip()
	~~link_name = link_name[1:-1]~~		name = extract_display_text(link)
	~~split_link_name~~ = ~~link_name.split~~(~~maxsplit=1~~)		print("LINK " + link + ". NAME: " + name) ##################
	~~if len~~(~~split_link_name) < 2:~~
	~~continue~~
	link~~, name = split_link_name[0], split_link_name[1]~~
	~~else~~:
	name ~~= link_name~~
	~~link = ""~~

	tuning = parts[2].strip()		tuning = parts[2].strip()
	notes = parts[3].strip()		notes = parts[3].strip()
	pop = parts[5].strip()		pop = parts[5].strip()

	~~#print("AUTHOR, NAME, LINK, TUNING") ###############################3~~
	~~#print(author, name, link, tuning)~~
	~~#print()~~


	~~# pop is collected in case the user puts in a new entry at the top~~
	~~# accidentally trashing old tuning and notes~~

	# Add to the result dictionary		# Add to the result dictionary
	if (author, name) in result:		if (author, name) in result:
Line 164:		Line 167:
	continue		continue

			'''
	if old_pop < new_pop:		if old_pop < new_pop:
	result[(author, name)] = (tuning, notes, pop, link)		result[(author, name)] = (tuning, notes, pop, link)
	else:		else:
	continue		continue
			'''
	else:		else:
	result[(author, name)] = (tuning, notes, pop, link)		result[(author, name)] = (tuning, notes, pop, link)
Line 180:		Line 185:

	talk = "https://en.xen.wiki/index.php?title=User_talk:Hkm/Rankings&action=edit"		talk = "https://en.xen.wiki/index.php?title=User_talk:Hkm/Rankings&action=edit"
	main = "https://en.xen.wiki/index.php?title=~~User:Hkm/Rankings~~&action=edit"		main = "https://en.xen.wiki/index.php?title=List_of_xenharmonic_music_by_community_ratings&action=edit"
	averages = process_talk(talk)		averages = process_talk(talk)
	data, before, after = process_main(main)		data, before, after = process_main(main)
Line 193:		Line 198:
	# print from talk page		# print from talk page
	for (author, work), (rating, pop) in sorted(averages.items(), key=lambda a: -a[1][0]):		for (author, work), (rating, pop) in sorted(averages.items(), key=lambda a: -a[1][0]):
	tuning, notes, _, link = data.setdefault((author, work), ("", "", "", ""))		tuning, notes, _, link = data.setdefault((author, work), ("", "", "", work))
	~~if link:~~		clip += (f"\|-\n\| {author} \|\| {link} \|\| {tuning} \|\| {notes} \|\| {rating:.2f} \|\| {pop}\n")
	clip += (f"\|-\n\| {author} \|\| [{link~~} {work}] \|\| {tuning} \|\| {notes} \|\| {rating:.2f} \|\| {pop}\n")~~
	~~else:~~
	~~clip += (f"\|-\n\| {author} \|\| {work~~} \|\| {tuning} \|\| {notes} \|\| {rating:.2f} \|\| {pop}\n")

	# print main pages not in talk page		# print main pages not in talk page
Line 204:		Line 206:
	(author, work) = i		(author, work) = i
	tuning, notes, _, link = data.setdefault((author, work), ("", "", "", ""))		tuning, notes, _, link = data.setdefault((author, work), ("", "", "", ""))
	~~if link:~~		clip += (f"\|-\n\| {author} \|\| {link} \|\| {tuning} \|\| {notes} \|\| \|\| \n")
	clip += (f"\|-\n\| {author} \|\| [{link} ~~{work}]~~ \|\| {tuning} \|\| {notes} \|\| \|\| \n")
	~~else:~~
	~~clip += (f"\|-\n\| {author} \|\| {work} \|\| {tuning} \|\| {notes} \|\| \|\| \n")~~

	clip += "\|}"		clip += "\|}"

Hkm at 22:58, 27 March 2025

2025-03-27T22:58:11Z

← Older revision		Revision as of 22:58, 27 March 2025
Line 9:		Line 9:

	def process_talk(url):		def process_talk(url):
			#pattern= r'^([^:]+):\s+([^.]*)\.\s+([0-9.]+)$'
	pattern = r'^([^:]+):\s+(.*)\.\s+([0-9.]+)$'		pattern = r'^([^:]+):\s+(.*)\.\s+([0-9.]+)$'
	data = {}		data = {}
Line 39:		Line 40:
	continue		continue

	if len(thing_a) > 40 or len(thing_b) > 70:		if len(thing_a) > 40 or len(thing_b) > 100:
	continue		continue

Line 79:		Line 80:
	(before, after) = raw_text.split('{\|', 1)		(before, after) = raw_text.split('{\|', 1)
	(raw_text, after) = after.split('\|}', 1)		(raw_text, after) = after.split('\|}', 1)
			if after[0] == "\n":
			after = after[1:]

			# add "last updated by"
			index = after.find('\n')
			first_part = after[:index + 1]
			rest_part = after[index + 1:]

			if first_part.startswith("Last updated by"):
			new_first = "\nLast updated by ~~~~.\n"
			after = new_first + rest_part
			else:
			after = "\nLast updated by ~~~~.\n" + after

	# Preprocess the text: replace newline followed by \| with \|\|, then split into entries		# Preprocess the text: replace newline followed by \| with \|\|, then split into entries
Line 172:		Line 186:
	clip = before		clip = before

	clip += '''{\| class="wikitable sortable" style="margin: auto;"		clip += '''{\| class="wikitable sortable" style="margin: auto; max-width: 800px; width: 100%;"
	! Creator !! Work !! Tuning !! Notes !! R !! #		! Creator !! Work !! Tuning !! Notes !! R !! #

	'''		'''

			# print from talk page
	for (author, work), (rating, pop) in sorted(averages.items(), key=lambda a: -a[1][0]):		for (author, work), (rating, pop) in sorted(averages.items(), key=lambda a: -a[1][0]):
	tuning, notes, _, link = data.setdefault((author, work), ("", "", "", ""))		tuning, notes, _, link = data.setdefault((author, work), ("", "", "", ""))
Line 184:		Line 199:
	clip += (f"\|-\n\| {author} \|\| {work} \|\| {tuning} \|\| {notes} \|\| {rating:.2f} \|\| {pop}\n")		clip += (f"\|-\n\| {author} \|\| {work} \|\| {tuning} \|\| {notes} \|\| {rating:.2f} \|\| {pop}\n")

			# print main pages not in talk page
			for i in data:
			if (i[0], i[1]) not in averages:
			(author, work) = i
			tuning, notes, _, link = data.setdefault((author, work), ("", "", "", ""))
			if link:
			clip += (f"\|-\n\| {author} \|\| [{link} {work}] \|\| {tuning} \|\| {notes} \|\| \|\| \n")
			else:
			clip += (f"\|-\n\| {author} \|\| {work} \|\| {tuning} \|\| {notes} \|\| \|\| \n")

	clip += "\|}"		clip += "\|}"

	clip += after		clip += after
	pyperclip.copy(clip)		pyperclip.copy(clip)


	‎</syntaxhighlight>		‎</syntaxhighlight>

Hkm at 04:18, 23 March 2025

2025-03-23T04:18:30Z

← Older revision		Revision as of 04:18, 23 March 2025
Line 9:		Line 9:

	def process_talk(url):		def process_talk(url):
	pattern = r'^([^:]+):\s+([^.]*)\.\s+([0-9.]+)$'		pattern = r'^([^:]+):\s+(.*)\.\s+([0-9.]+)$'
	data = {}		data = {}

Hkm at 04:46, 21 March 2025

2025-03-21T04:46:42Z

← Older revision		Revision as of 04:46, 21 March 2025
Line 1:		Line 1:
	<syntaxhighlight lang="python" line>		<syntaxhighlight lang="python" line>

			'''when adding a new work, the user should put it at the bottom
			so that it does not replace the tuning and notes if that work was already there'''
	import re		import re
	import requests		import requests
	from bs4 import BeautifulSoup		from bs4 import BeautifulSoup
			import pyperclip

	def process_talk(url):		def process_talk(url):
Line 36:		Line 39:
	continue		continue

	if len(thing_a) > 40 or len(thing_b) > 40:		if len(thing_a) > 40 or len(thing_b) > 70:
	continue		continue

Line 73:		Line 76:

	raw_text = textarea.get_text()		raw_text = textarea.get_text()

			(before, after) = raw_text.split('{\|', 1)
			(raw_text, after) = after.split('\|}', 1)

	# Preprocess the text: replace newline followed by \| with \|\|, then split into entries		# Preprocess the text: replace newline followed by \| with \|\|, then split into entries
Line 122:		Line 128:
	pop = parts[5].strip()		pop = parts[5].strip()

	print("AUTHOR, NAME, LINK, TUNING") ###############################3		#print("AUTHOR, NAME, LINK, TUNING") ###############################3
	print(author, name, link, tuning)		#print(author, name, link, tuning)
	print()		#print()


Line 154:		Line 160:
	return {}		return {}

	return result		return result, before, after


Line 162:		Line 168:
	main = "https://en.xen.wiki/index.php?title=User:Hkm/Rankings&action=edit"		main = "https://en.xen.wiki/index.php?title=User:Hkm/Rankings&action=edit"
	averages = process_talk(talk)		averages = process_talk(talk)
	data = process_main(main)		data, before, after = process_main(main)

			clip = before

			clip += '''{\| class="wikitable sortable" style="margin: auto;"
			! Creator !! Work !! Tuning !! Notes !! R !! #

	~~print(~~'''		'''
	~~{\| class="wikitable" style="margin: auto;"~~
	~~! Creator !! Work !! Tuning !! Notes !! Rating !! Pop ''')~~

	for (author, work), (rating, pop) in sorted(averages.items(), key=lambda a: -a[1][0]):		for (author, work), (rating, pop) in sorted(averages.items(), key=lambda a: -a[1][0]):
	tuning, notes, _, link = data.setdefault((author, work), ("", "", "", ""))		tuning, notes, _, link = data.setdefault((author, work), ("", "", "", ""))
	if link:		if link:
	~~print~~(f"\|-\n\| {author} \|\| [{link} {work}] \|\| {tuning} \|\| {notes} \|\| {rating:.2f} \|\| {pop}")		clip += (f"\|-\n\| {author} \|\| [{link} {work}] \|\| {tuning} \|\| {notes} \|\| {rating:.2f} \|\| {pop}\n")
	else:		else:
	~~print~~(f"\|-\n\| {author} \|\| {work} \|\| {tuning} \|\| {notes} \|\| {rating:.2f} \|\| {pop}")		clip += (f"\|-\n\| {author} \|\| {work} \|\| {tuning} \|\| {notes} \|\| {rating:.2f} \|\| {pop}\n")

			clip += "\|}"

	~~print~~(~~"\|}"~~)		clip += after
			pyperclip.copy(clip)


	‎</syntaxhighlight>		‎</syntaxhighlight>

Hkm at 03:20, 14 March 2025

2025-03-14T03:20:03Z

← Older revision		Revision as of 03:20, 14 March 2025
Line 1:		Line 1:
	~~‎<nowiki>~~<syntaxhighlight lang="python" line~~></nowiki~~>		<syntaxhighlight lang="python" line>

	import re		import re
Line 178:		Line 178:


	‎~~<nowiki>~~</syntaxhighlight~~></nowiki~~>		‎</syntaxhighlight>

Hkm at 03:19, 14 March 2025

2025-03-14T03:19:16Z

Show changes

Hkm: Created page with "‎ ‎"

2025-03-14T03:18:25Z

Created page with "‎<nowiki><syntaxhighlight lang="python" line></nowiki> ‎<nowiki></syntaxhighlight></nowiki>"

New page

‎<nowiki><syntaxhighlight lang="python" line></nowiki>

‎<nowiki></syntaxhighlight></nowiki>