Vova Yatsyuk vovayatsyuk

Search Patterns

Css

app/design/frontend/Magento,lib/web/css,*.less,-**/docs/*

Clear preprocessed and generated scripts and styles

Truncate all tables

mysql -u USER -pPASSWORD -Nse 'show tables' DATABASE | while read table; do mysql -u USER -pPASSWORD -e "SET FOREIGN_KEY_CHECKS = 0; truncate table $table" DATABASE; done

Export data

mysqldump -u USER -pPASSWORD --no-create-info DATABASE &gt; mydb.sql

Export and Import product reviews in Magento 1

Based on script by "Magento Craftsman in Melbourne": https://blog.mdnsolutions.com/migrate-products-reviews-and-ratings-programmatically/

The steps below will export product reviews at "source" server and import the same reviews into magento at "destination" server.

Connect to the "source" server. (If your server allows remote mysql connections you can do the steps 2-6 from local environment.)

	[
	{ "keys": ["shift+enter"], "command": "run_macro_file", "args": {"file": "res://Packages/Default/Add Line.sublime-macro"} },
	{ "keys": ["ctrl+shift+r"], "command": "reveal_in_side_bar"},
	{ "keys": ["f5"], "command": "refresh_folder_list" },
	{ "keys": ["shift+tab"], "command": "unindent", "context":
	[
	{ "key": "setting.shift_tab_unindent", "operator": "equal", "operand": true }
	]
	},
	{ "keys": ["ctrl+y"], "command": "redo" },

	# Basic example:
	ffmpeg -ss 00:01 -t 13 -i source.mp4 cropped.mp4
	ffmpeg -i cropped.mp4 -vf palettegen palette.png
	ffmpeg -i cropped.mp4 -i palette.png -lavfi "fps=15,paletteuse" output.gif

	# Advanced example
	ffmpeg -ss 00:00 -t 10 -i screencast.mp4 -filter:v "crop=width:height:x:y" -strict -2 cropped.mp4
	ffmpeg -i cropped.mp4 -vf palettegen palette.png
	ffmpeg -ss 00:00 -t 5 -i cropped.mp4 -i palette.png -lavfi "fps=15,scale=450:-1:flags=lanczos [x]; [x][1:v] paletteuse" output.gif

	git diff 2.1.7..2.1.8 -- . \
	':!/Test/' \
	':!/dev/*' \
	':!/setup/*' \
	':!composer.lock' \
	':!*/composer.json' \
	':!lib/web/tiny_mce/*' \
	':!CHANGELOG.md' \
	':!CONTRIBUTING.md'

	https://github.com/colinmollenhour/modman/wiki/Productivity-Hints

	$ for lang in locale/*/My_Module.csv; do echo "$lang app/$lang" >> filename.txt; done

	git init
	for module in *; do git submodule add "./$module"; done;
	git commit -m "Initial commit"

	cd folder/with/repos;
	for module in *; do cd $module && git checkout master && git pull && cd ../; done;