Alex Arce alexander-arce

## submodule-pull.sh
git submodule foreach '[ "$path" == "submodule-to-exclude" ] || git pull origin master'

## fix_search_path.sql
SELECT pg_catalog.set_config('search_path', 'public', false);

## drop_objects.sql
CREATE OR REPLACE FUNCTION drop_objects()
RETURNS VOID AS $$

DECLARE
 rd_object RECORD;
 v_idx_statement VARCHAR(500);

BEGIN

 ---1. Dropping all stored functions

## drop_schema.sql
DROP SCHEMA public CASCADE;
CREATE SCHEMA public;

## prefix_issue.py
#!/usr/bin/env python
# Original code https://andy-carter.com/blog/automating-git-commit-messages-with-git-hooks
# Create hooks directory mkdir -p ~/.git/hooks
# Config global hook path  git config --global core.hooksPath ~/.git/hooks/
# save as prepare-commit-msg
__author__ = "Alex Arce"
__email__ = "alexander.arce@pm.me"
__license__ = "GPL"
__version__ = "1.0"
__credits__ = "Frank Hofmann "

## reset_msql_root_password.sh
systemctl stop mysql.service
/usr/bin/mysql_safe --skip-grant-tables
mysql -u root
use mysql;
update user set authentication_string=PASSWORD("**NEW-PASSWORD**") where User='root';
flush privileges;
quit;
systemctl start mysql.service
# Test new Password
mysql -u root -h localhost -p

## init.vm
" Place in ~/.config/nvim

" vim-bootstrap

"*****************************************************************************
"" Vim-PLug core
"*****************************************************************************
if has('vim_starting')
  set nocompatible               " Be iMproved
endif

## Custom admin views
https://www.ianlewis.org/en/reversing-django-admin-urls
https://github.com/jsocol/django-adminplus
https://github.com/frankwiles/django-admin-views
http://www.pabloleanomartinet.com/adding-custom-admin-pages-django/

## Start ssh agent
eval "$(ssh-agent -s)"

## Create user
sudo adduser --system --home=/opt/etherpad --group etherpad
	CREATE OR REPLACE FUNCTION drop_objects()
	RETURNS VOID AS $$

	DECLARE
	rd_object RECORD;
	v_idx_statement VARCHAR(500);

	BEGIN

	---1. Dropping all stored functions
	#!/usr/bin/env python
	# Original code https://andy-carter.com/blog/automating-git-commit-messages-with-git-hooks
	# Create hooks directory mkdir -p ~/.git/hooks
	# Config global hook path git config --global core.hooksPath ~/.git/hooks/
	# save as prepare-commit-msg
	__author__ = "Alex Arce"
	__email__ = "alexander.arce@pm.me"
	__license__ = "GPL"
	__version__ = "1.0"
	__credits__ = "Frank Hofmann "
	systemctl stop mysql.service
	/usr/bin/mysql_safe --skip-grant-tables
	mysql -u root
	use mysql;
	update user set authentication_string=PASSWORD("NEW-PASSWORD") where User='root';
	flush privileges;
	quit;
	systemctl start mysql.service
	# Test new Password
	mysql -u root -h localhost -p
	" Place in ~/.config/nvim

	" vim-bootstrap

	"*****************************************************************************
	"" Vim-PLug core
	"*****************************************************************************
	if has('vim_starting')
	set nocompatible " Be iMproved
	endif
	https://www.ianlewis.org/en/reversing-django-admin-urls
	https://github.com/jsocol/django-adminplus
	https://github.com/frankwiles/django-admin-views
	http://www.pabloleanomartinet.com/adding-custom-admin-pages-django/