Faylixe

public interface Controller extends Consumer<Runnable>

Faylixe

/** ... **/
controller.accept(builder.createItem("Save", controller::save));
/** ... **/

Faylixe

public Runnable createActivable(final String label, final ActionListener listener) {
    final JMenuItem item = createItem(label, listener);
    item.setEnabled(false);
    return () -> item.setEnabled(true);
}

Faylixe

public static JMenuBar build(final Controller controller) {
    final MenuBuilder builder = new MenuBuilder(controller);
    builder.createFileMenu();
    return builder.get();
}

Faylixe

/** Creates File menu and plug it to the target menu bar. **/
private void createFileMenu() {
   final MenuBuilder builder = new MenuBuilder(new JMenu("File"));
   builder.createItem("Open", controller::open);
   builder.createItem("Save", controller::save);
   builder.createItem("Exit", controller::exit);
   target.add(builder.get());
}

Faylixe

-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query 
FROM pg_stat_activity 
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' 
ORDER BY query_start desc;

-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'