arsho

/* Date of execution: Sat  4 May 23:57:05 +06 2019*/

/* Number of questions with Flask tag: 30115 */
SELECT COUNT(Id) FROM Posts WHERE Tags LIKE '%flask%';


/* Number of questions with accepted answer with Flask tag: 15991 */
SELECT COUNT(Id) FROM Posts WHERE Tags LIKE '%flask%' and AcceptedAnswerId IS NULL;

arsho

Install PHP, MySQL, phpMyAdmin in Ubuntu 18.04 LTS

Install Mysql Server and MySQL Client

What is the difference between MySQL Server and MySQL Client?

MySql Client: The mysql-client package allows you to connect to a MySQL server. It will give you the mysql command-line program.

MySql Server: The mysql-server package allows to run a MySQL server which can host multiple databases and process queries on those databases.

• Update Ubuntu

arsho

from abc import abstractmethod, ABCMeta
from collections.abc import Container


class ExampleAbstractClass(metaclass=ABCMeta):
    @abstractmethod
    def first_abstract_method(self, x):
        pass

    @abstractmethod

arsho

import os
import sys
import unittest
import re
from pathlib import Path
import json


class Constants(object):
    def __init__(self):

arsho

Function	Keyboard shortcut
Open terminal	ALT + F12
Switch to editor from terminal	ALT + F12
Switch between tabs in editor	ALT + < and ALT + >
Go to Line / Column	CTRL + G

arsho

def get_total_negative_numbers(ar):
    if not ar:
        return 0
    ar = sorted(ar)
    if ar[0] < 0:
        del ar[0]
        return 1 + get_total_negative_numbers(ar)
    return 0

if __name__ == '__main__':

arsho

• Example of Python function: int()
• Show the internal methods of int:

  dir(int)
  

  # Output:
  ['__abs__', '__add__', '__and__', '__bool__', '__ceil__', '__class__', '__delattr__', '__dir__', '__divmod__', '__doc__', '__eq__', '__float__', '__floor__', '__floordiv__', '__format__', '__ge__', '__getattribute__', '__getnewargs__', '__gt__', '__hash__', '__index__', '__init__', '__int__', '__invert__', '__le__', '__lshift__', '__lt__', '__mod__', '__mul__', '__ne__', '__neg__', '__new__', '__or__', '__pos__', '__pow__', '__radd__', '__rand__', '__rdivmod__', '__reduce__', '__reduce_ex__', '__repr__', '__rfloordiv__', '__rlshift__', '__rmod__', '__rmul__', '__ror__', '__round__', '__rpow__', '__rrshift__', '__rshift__', '__rsub__', '__rtruediv__', '__rxor__', '__setattr__', '__sizeof__', '__str__', '__sub__', '__subclasshook__', '__truediv__', '__trunc__', '__xor__', 'bit_length', 'conjugate', 'denominator', 'from_bytes', 'imag', 'numerator', 'real', 'to_bytes']
  

• Show the docstring

arsho

• Append the following snippet in functions.php which is used by current theme:

/* Load HighlightJS from CDN */
function add_highlightjs_cdn()
{
	/**
	*      CSS:
	* 		 wp_enqueue_style( $handle, $src, $dependency, $version, $media );
	* JAVASCRIPT:

arsho

• Install tree tool from terminal:

  sudo apt-get install tree
  

• Go to the desired directory and put tree command:

  tree
  

• Skip directories or files from lising by using -I 'pattern'

arsho

Prereq:

apt-get install zsh
apt-get install git-core

Getting zsh to work in ubuntu is weird, since sh does not understand the source command. So, you do this to install zsh

wget https://github.com/robbyrussell/oh-my-zsh/raw/master/tools/install.sh -O - | zsh