Skip to content

Instantly share code, notes, and snippets.

View believer's full-sized avatar
🍪
Omnomnom

Rickard Natt och Dag believer

🍪
Omnomnom
View GitHub Profile
@believer
believer / playlist.js
Created February 23, 2020 16:53
Get playlist as csv from soundtrack.net
Array.apply(
null,
document.querySelectorAll('.cbox_table tbody tr:not(:last-child)')
)
.map((node, i) => {
var title = node.querySelector('td:nth-child(2)').innerText.trim()
var playtime = node.querySelector('td:nth-child(3)').innerText.trim()
return `${i + 1};${title};${playtime}`
})
@believer
believer / training.sql
Last active May 24, 2019 14:31
Mock setup for CrossFit workout database
-- DOWN
DROP SCHEMA public CASCADE;
-- UP
CREATE SCHEMA public;
GRANT ALL ON SCHEMA public TO postgres;
GRANT ALL ON SCHEMA public TO public;
-- Equipment enum