kayode-adechinan

pacman -S mariadb

mysql_install_db --user=mysql --basedir=/usr --datadir=/var/lib/mysql   //注意这个datadir，很重要，按照默认操作

systemctl enable mysqld
systemctl start mysqld

mysql_secure_installation

kayode-adechinan

Disable HTML Form Input Autocomplete and Autofill

1. Add autocomplete="off" onto <form> element;
2. Add hidden <input> with autocomplete="false" as a first children element of the form.

<form autocomplete="off" method="post" action="">
    <input autocomplete="false" name="hidden" type="text" style="display:none;">
    ...

kayode-adechinan

LOGGING = {
    'version': 1,
    'disable_existing_loggers': False,
    'handlers': {
        'mail_admins': {
            'level': 'ERROR',
            'class': 'django.utils.log.AdminEmailHandler'
        },
        'null': {
            'level':'DEBUG',

kayode-adechinan

from django import template

register = template.Library()

@register.simple_tag(takes_context=True)
def query_transform(context, **kwargs):
    '''
    Returns the URL-encoded querystring for the current page,
    updating the params with the key/value pairs passed to the tag.
    

kayode-adechinan

class CategoryListFilter(SimpleListFilter):

    # USAGE
    # In your admin class, pass trhe filter class as tuple for the list_filter attribute:
    #
    # list_filter = (CategoryListFilter,)


    # Human-readable title which will be displayed in the
    # right admin sidebar just above the filter options.

kayode-adechinan

#!/bin/bash

DBUSER="root";
DBPASS="";
DBHOST="localhost";

DB_OLD=mydatabase
DB_NEW=clone_mydatabase

DBCONN="--host=${DBHOST} --user=${DBUSER} --password=${DBPASS}";

kayode-adechinan

# Get the objects from the database
rawData = Launch.objects.all()

# Create array
json_res = []

# Iterate over results and add to array
for record in rawData: 
  json_obj = dict(name = record.name)
  json_res.append(json_obj)

kayode-adechinan

Export:

1. Copy from ${user}/.atom:

• config.cson
• keymap.cson
• snippets.cson
• styles.less

2. Save installed packages list apm list --installed --bare > packages.list

kayode-adechinan

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h):

• -E: will describe the underlaying queries of the \ commands (cool for learning!)
• -l: psql will list all databases and then exit (useful if the user you connect with doesn't has a default database, like at AWS RDS)

kayode-adechinan

//Regular Expressions List

//Short Tutorial 

\	// the escape character - used to find an instance of a metacharacter like a period, brackets, etc.
.	// match any character except newline
x	// match any instance of x
^x	// match any character except x
[x]	// match any instance of x in the bracketed range - [abxyz] will match any instance of a, b, x, y, or z
|	// an OR operator - [x|y] will match an instance of x or y