Robert Costa zabbarob
zabbarob
/ load_excel.php
Last active
August 23, 2016 23:19
Read an Excel file with Laravel Excel (https://github.com/Maatwebsite/Laravel-Excel)
View load_excel.php
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
| $sheets = Excel::load($filename)->get(); | |
| $firstSheet = $sheets->first(); | |
| $header = $firstSheet->first(); | |
| $data = $firstSheet->slice(1)->map(function ($row) use ($header) { | |
| return $header->combine($row); | |
| }); |
zabbarob
/ clean-all.sh
Created
August 20, 2016 15:17
Clean cached downloads of various package managers on OS X
View clean-all.sh
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
| #!/usr/bin/env bash | |
| # Cleans cached downloads of various package managers on OS X | |
| function myprintf() { | |
| printf "\e[0;35m$1\e[0;m\n" | |
| } | |
| myprintf "Cleaning Homebrew Packages" | |
| brew cleanup | |
| brew cask cleanup |
zabbarob
/ update-all.sh
Last active
August 20, 2016 15:17
Update packages of various package managers on OS X
View update-all.sh
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
| #!/usr/bin/env bash | |
| # Updates packages of various package managers on macOS | |
| function myprintf() { | |
| printf "\e[0;35m$1\e[0;m\n" | |
| } | |
| myprintf "Updating Homebrew Packages" | |
| brew update | |
| brew upgrade |
zabbarob
/ MemoryDbTest.php
Last active
August 20, 2016 15:07
Use in-memory database when running tests for a Laravel application.
View MemoryDbTest.php
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
| ... | |
| use Illuminate\Support\Facades\Artisan; | |
| class MemoryDbTest extends \TestCase | |
| { | |
| public function setUp() | |
| { | |
| parent::setUp(); | |
| Artisan::call('migrate'); | |
| // optional: Artisan::call('db:seed', ['--class' => 'TestSeeder']) |
zabbarob
/ echovars.php
Created
December 31, 2013 19:04
Web page that prints out the contents of most predefined variables in PHP.
View echovars.php
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
| header('Content-Type: text/plain'); | |
| function echoAll($a, $n) { | |
| if ($a) { | |
| echo join(PHP_EOL, array_map(function($key) use ($a, $n) { | |
| return $n . "['$key'] = '$a[$key]';"; | |
| }, array_keys($a))), PHP_EOL; | |
| } | |
| } |
zabbarob
/ which.py
Created
September 15, 2013 22:15
check if an executable exist and where it is stored
From http://stackoverflow.com/questions/377017/test-if-executable-exists-in-python
View which.py
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
| def which(program): | |
| import os | |
| def is_exe(fpath): | |
| return os.path.isfile(fpath) and os.access(fpath, os.X_OK) | |
| fpath, fname = os.path.split(program) | |
| if fpath: | |
| if is_exe(program): | |
| return program | |
| else: |
zabbarob
/ new_gist_file
Created
September 7, 2013 19:39
flatten nested lists in python
From http://stackoverflow.com/questions/2158395/flatten-an-irregular-list-of-lists-in-python
View new_gist_file
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
| def flatten(l): | |
| for el in l: | |
| if isinstance(el, collections.Iterable) and not isinstance(el, basestring): | |
| for sub in flatten(el): | |
| yield sub | |
| else: | |
| yield el |
zabbarob
/ new_gist_file
Created
September 4, 2013 12:16
Unicode to Windows1251
From http://stackoverflow.com/questions/7389651/javascript-character-conversion
View new_gist_file
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
| function toWindows1252(string, replacement) | |
| { | |
| var ret = new Array(string.length); | |
| var i, ch; | |
| replacement = typeof replacement === "string" && replacement.length > 0 ? replacement.charCodeAt(0) : 0; | |
| for (i = 0; i < string.length; i++) | |
| { | |
| ch = string.charCodeAt(i); |
zabbarob
/ window-metrics.reg
Created
June 29, 2013 15:34
Sets various metrics for the Windows 8 GUI, like size of title bar and title bar font, size of scroll bar, border width and desktop icon spacing.
View window-metrics.reg
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
| Windows Registry Editor Version 5.00 | |
| [HKEY_CURRENT_USER\Control Panel\Desktop\WindowMetrics] | |
| "CaptionHeight"="-100" | |
| "CaptionFont"=hex:f4,ff,ff,ff,00,00,00,00,00,00,00,00,00,00,00,00,90,01,00,00,\ | |
| 00,00,00,01,00,00,00,00,53,00,65,00,67,00,6f,00,65,00,20,00,55,00,49,00,00,\ | |
| 00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,\ | |
| 00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00,00 | |
| "ScrollHeight"="-100" | |
| "ScrollWidth"="-100" |
zabbarob
/ 7-zip-default-extract.reg
Last active
October 3, 2022 12:30
Make 7-Zip extract to folder when double-clicking archives.
(based on http://superuser.com/a/447791)
View 7-zip-default-extract.reg
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
| Windows Registry Editor Version 5.00 | |
| [HKEY_CLASSES_ROOT\7-Zip.001\shell] | |
| @="extract" | |
| [HKEY_CLASSES_ROOT\7-Zip.001\shell\extract] | |
| @="Extract to Folder" | |
| [HKEY_CLASSES_ROOT\7-Zip.001\shell\extract\command] | |
| @="\"C:\\Program Files\\7-Zip\\7zG.exe\" x \"%1\" -o*" | |
| [HKEY_CLASSES_ROOT\7-Zip.7z\shell] |
NewerOlder