matheus-santos

To find component occurrences in imports:

import \{?([A-Za-z0-9\s,]+)\n?\}? from '@\/components

To validate e-mail:

(?:[a-z0-9!#$%&'*+/=?^_`{|}~-]+(?:\.[a-z0-9!#$%&'*+/=?^_`{|}~-]+)*|"(?:[\x01-\x08\x0b\x0c\x0e-\x1f\x21\x23-\x5b\x5d-\x7f]|\\[\x01-\x09\x0b\x0c\x0e-\x7f])*")@(?:(?:[a-z0-9](?:[a-z0-9-]*[a-z0-9])?\.)+[a-z0-9](?:[a-z0-9-]*[a-z0-9])?|\[(?:(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?)\.){3}(?:25[0-5]|2[0-4][0-9]|[01]?[0-9][0-9]?|[a-z0-9-]*[a-z0-9]:(?:[\x01-\x08\x0b\x0c\x0e-\x1f\x21-\x5a\x53-\x7f]|\\[\x01-\x09\x0b\x0c\x0e-\x7f])+)\])

matheus-santos

#!/bin/sh
# Author: Matheus Cesário <mts.cesario@gmail.com>
# Description: Killing all slow queries from bd
# Example: sh kill_them_all.sh -s 100

# Variables
SECONDS=0  # Seconds
USER=""  # DB user
PASSWORD=""  # DB password
HOST=""  # DB host

matheus-santos

# TDD good habits

## Principles
- tests should test one thing only
	- test one logical assertion
	- don't mix assertions of state and collaboration in the same test
	- modifications of production code should only break related test cases
- each test should be self-contained, including data
- ensure tests are independent of each other
- don't refactor with a failing test

matheus-santos

Search: /^    ([a-zA-Z]+): {\n( +)/
Replace: /    $1: {\n$2id: '$1',\n$2/

Example:

{                             =>   {
 name: {                      =>     name: {
 property1: 'Property 1' => id: 'name', // Added

matheus-santos

Used brew's remove & cleanup commands, unloaded the launchctl script, then deleted the mysql directory in /usr/local/var, deleted my existing /etc/my.cnf (leave that one up to you, should it apply) and launchctl plist

Updated the string for the plist. Note also your alternate security script directory will be based on which version of MySQL you are installing.

Step-by-step:

brew remove mysql
brew cleanup
launchctl unload -w /usr/local/Cellar/mysql/8.0.16/homebrew.mxcl.mysql.plist

matheus-santos

#
# The MySQL database server configuration file.
#
# You can copy this to one of:
# - "/etc/mysql/my.cnf" to set global options,
# - "~/.my.cnf" to set user-specific options.
#
# One can use all long options that the program supports.
# Run program with --help to get a list of available options and with
# --print-defaults to see which it would actually understand and use.

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");

matheus-santos

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

matheus-santos

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

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`;