matheus-santos

Do you have a GitHub URL you'd like to shorten? Use Git.io!

$ curl -i https://git.io -F "url=https://github.com/..."
HTTP/1.1 201 Created
Location: https://git.io/abc123

$ curl -i https://git.io/abc123
HTTP/1.1 302 Found
Location: https://github.com/...

matheus-santos

SELECT table_schema "Data Base Name",
    sum( data_length + index_length ) / 1024 / 1024 "Data Base Size in MB",
    sum( data_free )/ 1024 / 1024 "Free Space in MB"
FROM information_schema.TABLES
GROUP BY table_schema ; 

show variables where variable_name = 'general_log';
set global general_log = 0;

select count(*) from mysql.general_log;

matheus-santos

REM Creating symbolic links in Windows OS
REM PREFIX = /D, /H, /J
REM DESTINY_PATH = Path to linked file/folder
REM ORIGIN_PATH = Path to original file/folder
REM e.g.: mklink /J C:\Vagrant\Project C:\Users\Matheus\Documents\Workspace\Project

mklink /PREFIX %DESTINY_PATH% %ORIGIN_PATH%

matheus-santos

A ideia é ter um Linux virtualizado no windows, que dê para rodar o docker e usar o vagrant como um sistema sobre o Windows. Para não precisar de fazer dual boot, já que tudo o que eu preciso é um terminal Linux que eu posso instalar qualquer coisa com apt-get :)

1. Instalar no windos o cmder, um emulador de console http://cmder.net/

2. Instalar virtual box https://www.virtualbox.org/wiki/Downloads

3. Instalar o vagrant

matheus-santos

container_commands:
  01_fix_static_cors:
    command: "/tmp/fix_static_cors.sh"
files:
  "/tmp/fix_static_cors.sh":
    mode: "000755"
    owner: root
    group: root
    content: |
      #!/bin/bash

matheus-santos

You can approach it from either a white list or black list way:

// Black list
// Remove the values you don't want
var result = _.omit(credentials, ['age']);

// White list
// Only allow certain values
var result = _.pick(credentials, ['fname', 'lname']);
If it's reusable business logic, you can partial it out as well:

matheus-santos

-- Replace `{{TABLE_NAME}}` to desired table
-- Replace `{{ID}}` to desired row you want to replace
create temporary table `temp` select * from `{{TABLE_NAME}}` where id = {{ID}};
update `temp` SET id = (select id from {{TABLE_NAME}} order by id desc limit 1) + 1 where id = {{ID}};
insert into `{{TABLE_NAME}}` select * from `temp`;
drop TEMPORARY table if exists `temp`;

matheus-santos

[
    {
        "code": "001",
        "name": "Banco do Brasil",
        "short_name": "BB",
        "jurisdiction": "Federal",
        "website": "www.bb.com.br"
    },
    {
        "code": "002",

matheus-santos

\DB::enableQueryLog();
// Laravel query operation here ...
print_r(\DB::getQueryLog()); exit;

matheus-santos

// SocketIO cheat sheet
// SocketIO is a library that makes websockets communications easier.
// Page: http://socket.io/
// ref: http://stackoverflow.com/a/10099325

// send to current request socket client
socket.emit('message', "this is a test");

// sending to all clients, include sender
io.sockets.emit('message', "this is a test");