Skip to content

Instantly share code, notes, and snippets.

@alt-romes
Last active May 18, 2020 10:36
Show Gist options
  • Save alt-romes/bb366d1a9c46e89874744364fbbfe4d8 to your computer and use it in GitHub Desktop.
Save alt-romes/bb366d1a9c46e89874744364fbbfe4d8 to your computer and use it in GitHub Desktop.
Get all music genres from everynoise.com and create insert commands
import requests
everynoisetext = requests.get('http://everynoise.com/everynoise1d.cgi?scope=all').text
import re
allgenres = re.findall(r'style="color: #.*?>(.*?)<', everynoisetext)
for genre in allgenres:
print ('insert into MusicGenres values ("{}");'.format(genre))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment