Dotan Cohen dotancohen
dotancohen
/ svn-diff-ignore
Last active
November 9, 2020 21:38
Show diff for files not in .svnignore file. BE CAREFUL TO SPECIFY FILENAMES WHEN COMMITTING!
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
| #!/bin/bash | |
| # BE CAREFUL TO SPECIFY FILENAMES WHEN COMMITTING! | |
| IGNORE_FILENAME=.svnignore | |
| svn status | awk '{print $2}' | while read FILE ; do | |
| grep -x $FILE $IGNORE_FILENAME > /dev/null | |
| STATUS=$? | |
| if ! $(exit $STATUS) ; then |
dotancohen
/ db-get-column-names-common
Created
February 14, 2022 09:43
Get most common column names from SQL dump 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
| grep -P "^\s+\`" foo.sql | \ | |
| sed -E 's/\([0-9]*/(/' | \ | |
| awk '{print $1 "\t" $2}' | \ | |
| sort | \ | |
| uniq -c | \ | |
| sort -n -r > db-common-column-names | |
| # 300 MiB SQL file: 0.4 seconds |
OlderNewer