bunnywong

sudo npm install -g strongloop
slc loopback

slc loopback:datasource ItemsDB
> MongoDB 
slc loopback:model Item
Item
>item(mongodb)
slc run

bunnywong

Mac Stack

• Spectacle
• Reverse Scrolling
• MySQLWorkbench
• Sublime
• Atom
• Virtual Box
• Source Tree

bunnywong

SET @OLD =  '//old-site.com';
SET @NEW =  '//new-site.com';

UPDATE wp_posts SET guid = REPLACE(guid, '@OLD', '@NEW');
UPDATE wp_posts SET post_content = REPLACE(post_content, '@OLD', '@NEW');
UPDATE wp_postmeta SET meta_value = REPLACE(meta_value, '@OLD', '@NEW');
UPDATE wp_options SET option_value = REPLACE(option_value, '@OLD', '@NEW') WHERE option_name = 'home' OR option_name = 'siteurl';

bunnywong

Installed color MySQL
https://github.com/nitso/colour-mysql-console

Access from host
> ip add

mysql> mysql -u root;
mysql> grant all on prefix.* to [email protected];
mysql> flush privileges;

bunnywong

Function

- check_plain() // Return pure text(html)

bunnywong

drush cc all

# Dump
drush sql-dump >dump.sql
drush sql-dump --gzip > ./sql/ime.sql.gz

# Login
drush uliSQL

bunnywong

SELECT 
	 oc_customer.email              AS  'email',
	 oc_customer.customer_id        AS  'customer_cid',
	 oc_customer.address_id         AS  'customer_addressId',
	
	 oc_address.customer_id         AS  'address_cid',
	 oc_address.address_id          AS  'address_addressId',
	 COUNT(oc_address.customer_id)  as  'address_count'
FROM  
	oc_customer, oc_address

bunnywong

Token
Views
Devel

bunnywong

nano ~/.bashrc

bunnywong

UPDATE wp_posts SET guid = replace(guid, 'http://www.old-domain.com','http://www.new-domain.com');
UPDATE wp_posts SET post_content = replace(post_content, 'http://www.old-domain.com', 'http://www.new-domain.com');
UPDATE wp_postmeta SET meta_value = replace(meta_value, 'http://www.old-domain.com', 'http://www.new-domain.com');
UPDATE wp_options SET option_value = replace(option_value, 'http://www.old-domain.com', 'http://www.new-domain.com') WHERE option_name = 'home' OR option_name = 'siteurl';