0x49D1

gunicorn --bind 0.0.0.0:5001 --access-logfile /var/log/gunicorn/access.log --error-logfile /var/log/gunicorn/error.log --capture-output --reload wsgi:app &

0x49D1

import time

def even_sum_fib(sum_limit):
    current = previous = 1
    sum = 0
    while(sum < sum_limit):
        if current % 2 == 0:
            sum += current        
        previous, current = current, current + previous        
    return sum

0x49D1

# CREATE PROCEDURE AND OTHER DECLARE STATEMENTS HERE
# ....

DECLARE EXIT HANDLER FOR SQLEXCEPTION
BEGIN
    GET DIAGNOSTICS CONDITION 1 @sqlstate = RETURNED_SQLSTATE, @errno = MYSQL_ERRNO, @text = MESSAGE_TEXT;

    ROLLBACK;

    SET @full_error = CONCAT('ERR:', @errno, '(', @sqlstate, '):', @text);

0x49D1

CREATE FUNCTION COUNT_STR(haystack TEXT, needle VARCHAR(32))
  RETURNS INTEGER DETERMINISTIC
  BEGIN
    RETURN ROUND((CHAR_LENGTH(haystack) - CHAR_LENGTH(REPLACE(haystack, needle, ""))) / CHAR_LENGTH(needle));
  END;
  
  # Example: SELECT COUNT_STR('{"a":"test","fdfs":"test","more":"tests","b":"a"}',',"'); returns 3

0x49D1

Windows version: Windows 10 Pro 1909 Command: sudo service rsyslog restart

• Stopping enhanced syslogd rsyslogd [ OK ]
• Starting enhanced syslogd rsyslogd rsyslogd: set SO_TIMESTAMP failed on '/dev/log': Invalid argument [v8.32.0] rsyslogd: imklog: cannot open kernel log (/proc/kmsg): No such file or directory.
  rsyslogd: activation of module imklog failed [v8.32.0 try http://www.rsyslog.com/e/2145 ]

Solution:
https://askubuntu.com/questions/615457/no-logs-are-written-to-var-log/615473

0x49D1

/// <summary>
/// Credits to https://lostechies.com/jimmybogard/2013/06/20/run-tests-explicitly-in-xunit-net/
/// </summary>
public class RunnableInDebugOnlyAttribute : FactAttribute
{
    public RunnableInDebugOnlyAttribute()
    {
        if (!Debugger.IsAttached)
        {
            Skip = "Only running in interactive mode.";

0x49D1

#!/bin/bash

# For example: https://dev.mysql.com/doc/refman/8.0/en/mysqldump.html 
# --no-data Do not dump table contents
# --triggers Do add triggers too
# --host Dump data from the MySQL server on the given host. The default host is localhost.
# --port For TCP/IP connections, the port number to use.
# --all-databases Dump all tables in all databases. 
# -u The user name of the MySQL account to use for connecting to the server.
# --verbose Verbose mode. Print more information about what the program does.

0x49D1

#!/bin/sh
# List all aliases
git config --get-regexp alias
# Add last tags alias sample
git config --global alias.lasttags "log --graph --all --decorate --oneline --simplify-by-decoration -5"

0x49D1

#!/bin/bash

eval $(keychain --eval id_github_rsa) # in case you use keychain to store keys. https://linux.die.net/man/1/keychain
find . -maxdepth 1 -type d -exec sh -c '(cd {} && echo $PWD && git pull && git push)' ';'

0x49D1

ng build --prod && sshpass -f ~/test_pass scp -r ./dist/project/* REMOTE_USER@REMOTE_SERVER:/var/www/html
# Where:
# test_pass is the file, containing the password for remote server access
# the project will be deployed to /var/www/html