Yurui Zhang pallymore

## yurui_uses.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                pallymore
                / yurui_uses.md
            
            
              Created
              January 13, 2020 17:53
            
              
                tools used by Yurui
              
          
    Uses

by Yurui Zhang (@yuruiology)
Last updated: Jan 13, 2020
Editor


Visual Studio Code
Font: Operator Mono
VIM-vscode
macVim


## pg_count_all.sql
create or replace function
count_rows(schema text, tablename text) returns integer
as
$body$
declare
  result integer;
  query varchar;
begin
  query := 'SELECT count(1) FROM ' || schema || '.' || tablename;
  execute query into result;

## split_csv.awk
awk -F, 'NR==1{hdr=$0;next}!($5 in files){files[$5]=1;print hdr >$5".csv"}{print>$5".csv”}’ input.csv

## scp_without_dot_files
scp -r [!.]* username@server:/path/to/destination/folder

## command.sh
tail -f ~/Library/Application\ Support/Postgres93/var/pg_log/*

## gist:6868418
bundle install --path .bundle --binstubs .bundle/bin

## capybara cheat sheet
=Navigating=
    visit('/projects')
    visit(post_comments_path(post))

=Clicking links and buttons=
    click_link('id-of-link')
    click_link('Link Text')
    click_button('Save')
    click('Link Text') # Click either a link or a button
    click('Button Value')
	create or replace function
	count_rows(schema text, tablename text) returns integer
	as
	$body$
	declare
	result integer;
	query varchar;
	begin
	query := 'SELECT count(1) FROM ' \|\| schema \|\| '.' \|\| tablename;
	execute query into result;
	=Navigating=
	visit('/projects')
	visit(post_comments_path(post))

	=Clicking links and buttons=
	click_link('id-of-link')
	click_link('Link Text')
	click_button('Save')
	click('Link Text') # Click either a link or a button
	click('Button Value')