bangil0

Commands

• git checkout -b __newbranch__ : get a new branch and switch to it
• git checkout -b __branchname__ / __branchname__ : get a local copy of a remote existing branch
• git checkout __branchname__ : switch branch
• git checkout --orphan __branchname__ : create branch without full history
• git log -n X -p : show X last commits with diffs
• git log __branchA__ ^__branchB__ : commits in branch A that aren't in branch B
• git log --pretty=oneline --stat --all __foldername__ : modified files under a given folder

bangil0

PSQL

Magic words:

psql -U postgres

Some interesting flags (to see all, use -h or --help depending on your psql version):

• -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)

bangil0

/**
 *
 *  (C) 2020 Muhammad Fauzan
 *    This program is free software: you can redistribute it and/or modify
 *    it under the terms of the GNU General Public License as published by
 *    the Free Software Foundation, either version 3 of the License, or
 *    (at your option) any later version.
 *
 *    This program is distributed in the hope that it will be useful,
 *    but WITHOUT ANY WARRANTY; without even the implied warranty of

bangil0

import io
import os
import six
import csv

from scrapy.exporters import CsvItemExporter
from scrapy.extensions.feedexport import IFeedStorage
from w3lib.url import file_uri_to_path
from zope.interface import implementer

bangil0

Replace mcrypt_encrypt with openssl_encrypt

The url has changed: https://odan.github.io/2017/07/14/replace-mcrypt-encrypt-with-openssl-encrypt.html

bangil0

<IfModule mod_rewrite.c>
    <IfModule mod_negotiation.c>
        Options -MultiViews
    </IfModule>

    RewriteEngine On

    # Force HTTPS - Proto needed for AWS ELB
    RewriteCond %{HTTP:X-Forwarded-Proto} !https
    RewriteCond %{HTTP_USER_AGENT} !^ELB-HealthChecker

bangil0

<?php
defined('BASEPATH') OR exit('No direct script access allowed');
// Codeigniter 3 usage :
//   Set config/config.app:
//   $config['composer_autoload'] = 'vendor/autoload.php';
use Ozdemir\Datatables\Datatables;
use Ozdemir\Datatables\DB\CodeigniterAdapter;
class Welcome extends CI_Controller {
    public function index()
    {

bangil0

-- Get Max ID from table
SELECT MAX(id) FROM table;

-- Get Next ID from table
SELECT nextval('table_id_seq');

-- Set Next ID Value to MAX ID
SELECT setval('table_id_seq', (SELECT MAX(id) FROM table));