zhengjia

=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')

mdornseif

DELETE FROM buchdurchschnittspreis2
  WHERE id in 
    (SELECT buchdurchschnittspreis2.id FROM buchdurchschnittspreis2 
      LEFT OUTER JOIN (select min(id) as id from buchdurchschnittspreis2
        GROUP BY (artnr, datum) as KeepRows 
      ON buchdurchschnittspreis2.id=KeepRows.id 
    WHERE KeepRows.id IS NULL);

jasonrudolph

# Credit http://stackoverflow.com/a/2514279
for branch in `git branch -r | grep -v HEAD`;do echo -e `git show --format="%ci %cr" $branch | head -n 1` \\t$branch; done | sort -r

apieceofbart

// somewhere on top
import _ from 'lodash';
jest.unmock('lodash');

// then
_.debounce = jest.fn((fn) => fn);