This an ordered version of the original gist located at https://gist.github.com/marcanuy/06cb00bc36033cd12875
- -aa
- aa-
- -ab
This an ordered version of the original gist located at https://gist.github.com/marcanuy/06cb00bc36033cd12875
# Difference unicode/general : http://stackoverflow.com/a/367725/330867 | |
CREATE DATABASE dbname CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; | |
CREATE USER 'dbuser'@'localhost' IDENTIFIED BY 'dbpass'; | |
GRANT USAGE ON * . * TO 'dbuser'@'localhost' IDENTIFIED BY 'dbpass' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ; | |
GRANT SELECT , INSERT , UPDATE , DELETE , CREATE , DROP , INDEX , ALTER , REFERENCES, LOCK TABLES ON `dbname` . * TO 'dbuser'@'localhost'; | |
FLUSH PRIVILEGES; | |
# To dump the database with the master relay details: |
# -*- config:utf-8 -*- | |
import boto3, asyncio, sys, os, datetime | |
def get_sa_max_children(default=12): | |
try: | |
options = None | |
with open('/etc/default/spamassassin', 'r') as f: | |
for line in f: | |
if line.find('OPTIONS=') == 0: |
#!/bin/bash | |
# They stopped "source.unsplash.com" service | |
# So that script doesn't work anymore unfortunately ... | |
# If started as root, then re-start as user "gavenkoa": | |
if [ "$(id -u)" -eq 0 ]; then | |
exec sudo -H -u YOUR_USERNAME $0 "$@" | |
fi |
(function () { | |
const sidebar = document.querySelector('.sidebarWithSeparator') | |
if (sidebar) sidebar.remove() | |
const question = document.querySelector('[data-test="homepage-questions-card"]') | |
if (question) question.remove() | |
const containers = document.querySelectorAll('.layoutContainer') | |
if (containers.length == 2) { containers[0].remove() } |
#!/usr/bin/python | |
# | |
# Inspired by https://gist.github.com/MrHamel/1b640a81ded45bfbac564d2fd4f9532c, but updated for Python3 | |
# Thanks! | |
# | |
import json, psutil | |
def update_top_info(): | |
top_data = {} |
import requests, datetime | |
STRIPE_PRIVATE_KEY='' # Indicate your Stripe private key here | |
params = { | |
'limit': 100, | |
'created[gte]': int(datetime.datetime(year=2022, month=1, day=1, hour=0, minute=0, second=0).timestamp()) # if you want to filter starting in the year 2022 | |
} | |
operations = {} |
# -*- coding: utf-8 -*- | |
import argparse, glob, os | |
try: | |
from mutagen.easyid3 import EasyID3 | |
except ImportError: | |
print('"mutagen" package is required for this to work.') | |
print('Please install it using pip or any other package manager') | |
exit(0) |
#!/usr/bin/python | |
# -*- coding:utf-8 -*- | |
# Parse the given requirements.txt file (defaults to the local one) and find updates from Pypi. | |
# Optional parameter "dry" will only show the changes without applying them. | |
from importlib.metadata import version | |
from importlib.metadata import PackageNotFoundError | |
from pkg_resources import Requirement | |
import requests, datetime, sys, subprocess, argparse |