anton-roos

# Set local git config
git config user.name "Your Name Here"
git config user.email [email protected]

# Set global git config
git config --global user.name "Your Name Here"
git config --global user.email [email protected]

# Check your git settings
git config user.name && git config user.email

anton-roos

function sleep(ms) {
  return new Promise((resolve) => setTimeout(resolve, ms));
}
async function unlikeTweets() {
  let tweets = document.querySelectorAll('[data-testid="tweet"]');
  for (let tweet of tweets) {
    let unlikeButton = tweet.querySelectorAll('[data-testid="unlike"]')[0];
    if (unlikeButton != null) {
      unlikeButton.scrollIntoView();
      unlikeButton.click();

anton-roos

function sleep(ms) {
  return new Promise((resolve) => setTimeout(resolve, ms));
}
async function deleteTweets() {
  let tweets = document.querySelectorAll('[data-testid="tweet"]');
  for (let tweet of tweets) {
    // Replace "Your Display Name"
    if (tweet.querySelector("span:first-child").innerHTML.includes("Your Display Name")) {
      console.log("My tweet");
      tweet.querySelectorAll('[data-testid="caret"]')[0].scrollIntoView();

anton-roos

git pull
echo "Git pull done, fetching timetable..."
for branch
in `git branch -r | grep -v HEAD`;do echo -e `git show --format="%ci %cr" $branch | head -n 1` \\t$branch;
done | sort -r

anton-roos

UPDATE wp_postmeta
SET `meta_value` = 'outofstock'
WHERE `meta_value` = 'instock'
AND `meta_key` = '_stock_status'

anton-roos

SELECT ID
FROM `wp_posts`
WHERE ID 
NOT IN (select `post_id` from `wp_postmeta` WHERE `meta_key`="_thumbnail_id") 
AND `post_type`="product"

anton-roos

SELECT `meta_value`, `meta_key`, count(*) 
FROM wp_postmeta WHERE meta_key LIKE '_sku'  
GROUP BY `meta_value`  
ORDER BY `count(*)`  DESC

anton-roos

SELECT meta_value
FROM wp_postmeta
WHERE meta_key = '_sku'
AND meta_value != ''
GROUP BY meta_value HAVING COUNT(meta_value) > 1

anton-roos

UPDATE `wp_postmeta`
SET `meta_value` = 'no'
WHERE `meta_key` = '_sold_individually'

anton-roos

UPDATE `wp_postmeta`
SET `meta_value` = 'yes'
WHERE `meta_key` = '_manage_stock'