Alex Oliveira alex-oliveira
alex-oliveira
/ weinre
Created
September 19, 2016 21:06
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| weinre --httpPort 8081 --boundHost -all- |
alex-oliveira
/ .bashrc
Created
August 9, 2016 23:07
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # PHP | |
| alias php='/opt/php56/bin/php' | |
| alias composer='~/composer.phar' | |
| export PATH="/opt/php56/bin:$PATH" |
alex-oliveira
/ rsa
Created
August 3, 2016 12:59
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ssh-keygen -t rsa -C "you@homestead" |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $input = Request::input(); | |
| $request = clone app('request'); | |
| $route = clone app('Illuminate\Routing\Route'); | |
| $router = clone app('router'); | |
| $internal = Request::create(route('action1'), 'GET', ['alex' => 'oliveira']); | |
| Request::replace($internal->input()); | |
| $dispatch = Route::dispatch($internal); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT * | |
| FROM ( | |
| SELECT | |
| R.id, | |
| REPLACE( | |
| REPLACE( | |
| REPLACE( | |
| REPLACE( | |
| REPLACE( | |
| REPLACE( |
alex-oliveira
/ PostgreSQL join with data
Last active
May 11, 2016 18:08
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT * FROM (VALUES (0, 'desativado'), (1, 'ativado')) AS z(id, status); | |
| ------------------------------------ | |
| SELECT u.id, u.nome, u.ativo, z.status | |
| FROM autenticacao.usuarios as u | |
| INNER JOIN (VALUES (0, 'desativado'), (1, 'ativado')) AS z(id, status) ON z.id = u.ativo | |
| ORDER BY z.status ASC; | |
| ------------------------------------ |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $ cordova build --release android | |
| $ cd platforms\android\build\outputs\apk\ | |
| $ keytool -genkey -v -keystore myapp.keystore -alias myapp -keyalg RSA -keysize 2048 -validity 10000 | |
| $ copy android-release-unsigned.apk android-release.apk | |
| $ jarsigner -verbose -sigalg SHA1withRSA -digestalg SHA1 -keystore myapp.keystore android-release.apk myapp |
alex-oliveira
/ Google Drive like CDN
Created
March 17, 2016 12:24
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| https://googledrive.com/host/0BwzH_u8QgWbLUmRUc0pKdzl5VW8/provas/00/00/00/00/01/prova.pdf.qp | |
| https://googledrive.com/host/0BwzH_u8QgWbLZHdoTmtmSDRtTVU/Alex_Oliveira.jpg | |
| https://e09ce0dcb1e32d78a138577b8872ff0ff94fa52d.googledrive.com/host/0BwzH_u8QgWbLZHdoTmtmSDRtTVU/Alex_Oliveira.jpg |
alex-oliveira
/ Tamanhos nos Bancos de Dados
Created
January 13, 2016 21:09
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| =========================================================================== | |
| MySQL | |
| =========================================================================== | |
| TINYINT (--128 a 127)(0 a 255) | |
| BOOL e BOOLEAN = TINYINT(1) | |
| SMALLINT (-32.768 a 32.767)(0 a 65.535) | |
| MEDIUMINT (-8.388.608 a 8.388.607)(0 a 16.777.215) | |
| INT (-2.147.483.648 a 2.147.483.647)(0 a 4.294.967.295) | |
| INTEGER = INT |
alex-oliveira
/ Http Status
Last active
January 13, 2016 05:36
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| http://www.w3.org/Protocols/rfc2616/rfc2616-sec10.html | |
| # successful | |
| 200 => ['id' => 200, 'name' => 'OK', 'message' => 'pedido foi cumprido'], | |
| 201 => ['id' => 201, 'name' => 'CREATED', 'message' => 'o post foi bem sucessido e foi devolvida uma referencia ao objeto criado'], | |
| 202 => ['id' => 202, 'name' => 'ACCEPTED', 'message' => 'o pedido aceito e colocado na fila de processamento'], | |
| 203 => ['id' => 203, 'name' => 'PARTIAL_INFORMATION', 'message' => ''], | |
| 204 => ['id' => 204, 'name' => 'NO_RESPONSE', 'message' => 'o pedido foi cumprido, mas não ha informações a serem devolvidas'], | |
| # redirection |