andrewmmc’s gists

andrewmmc / laravel-transactions.md

Last active January 8, 2018 07:46

[Laravel] Databse Transactions

Laravel 5 - Manually Using Transactions

If you would like to begin a transaction manually and have complete control over rollbacks and commits, you may use the beginTransaction method on the DB facade:

DB::beginTransaction();

You can rollback the transaction via the rollBack method:

DB::rollBack();

andrewmmc / laravel-print-raw-query.md

Last active January 8, 2018 07:45

[Laravel] Print raw query statement

Laravel 5 - Print raw query statement

Add this function to following file, and print it by \Log::debug($this->getSql($query)):

/*
 *  returns SQL with values in it
 */
    private function getSql($model)
    {
        $replace = function ($sql, $bindings)

andrewmmc / mysql-cheatsheet.md

Last active January 8, 2018 08:22 — forked from hofmannsven/README.md

[MySQL] Command Line Cheatsheet

MySQL - Command Line Cheatsheet

Getting started:

iTerm2 Hotkey

Install iTerm2

If you haven’t heard of iTerm, it’s a popular open source alternative to Mac OS X Terminal. Give it a try, download and install it from http://www.iterm2.com.

Fine-Tune Settings

Launch iTerm, open iTerm > Preferences or just Cmd + ,.

Open tab/pane with current working directory

Under Profiles tab, go to General subtab, set Working Directory to “Reuse previous session’s directory”.

andrewmmc / chrome-hide-extension-in-network-tab.md

Last active January 12, 2018 02:06

[Chrome] Hide extension resources in inspector network tab

Hide extension resources in Google Chrome inspector network tab

In the network tab filter box, enter the string -scheme:chrome-extension (case-sensitive)

Reference: https://stackoverflow.com/questions/16436369/is-it-possible-to-hide-extension-resources-in-the-chrome-web-inspector-network-t/28230333#28230333

andrewmmc / js-flatten-object.md

Last active January 16, 2018 04:49

[JavaScript] Flatten object

JavaScript - Flatten object

  let dateTimeList = [
        {
            "timestamps": {
                "driverRouteTime": "2018-01-12T07:33:21.791Z"
            }
        },
        {
 "timestamps": {

andrewmmc / mysql-macos-sierra.md

Last active January 16, 2018 04:50 — forked from nrollr/MySQL_macOS_Sierra.md

[macOS] Install MySQL on Sierra using Homebrew

Install MySQL on macOS Sierra

This procedure explains how to install MySQL using Homebrew on macOS Sierra 10.12

Install Homebrew

Installing Homebrew is effortless, open Terminal and enter :
$ /usr/bin/ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"
Note: Homebrew will download and install Command Line Tools for Xcode 8.0 as part of the installation process.

Install MySQL

At this time of writing, Homebrew has MySQL version 5.7.15 as default formulae in its main repository :

andrewmmc / embedded-file-viewer.md

Last active January 16, 2018 04:50 — forked from tzmartin/embedded-file-viewer.md

Embedded File Viewer - Google Drive, OneDrive

Office Web Apps Viewer

('.ppt' '.pptx' '.doc', '.docx', '.xls', '.xlsx')

http://view.officeapps.live.com/op/view.aspx?src=[OFFICE_FILE_URL]

<iframe src='https://view.officeapps.live.com/op/embed.aspx?src=[OFFICE_FILE_URL]' width='px' height='px' frameborder='0'>
</iframe>

OneDrive Embed Links

andrewmmc / git-pull-update-submodule.md

Created January 16, 2018 04:48

[Git] Git update submodule version to latest

Git - Update submodule version to latest

git pull --recurse-submodules
git submodule update --remote --recursive

andrewmmc / git-reset-hard.md

Created January 18, 2018 16:16

[Git] Force `git pull` to overwrite local files

Important: If you have any local changes, they will be lost. With or without --hard option, any local commits that haven't been pushed will be lost.[*] If you have any files that are not tracked by Git (e.g. uploaded user content), these files will not be affected.

git fetch --all

Then, you have two options:

git reset --hard origin/master

OR If you are on some other branch:

Andrew Mok andrewmmc