#!/bin/bash SQL='SELECT jazyk, celkem AS řádků, celkem_graf AS řádků_graf FROM ('; SQL='SELECT * FROM ('; SQL+='SELECT ? AS jazyk, ? AS souborů, ? AS prázdných, ? AS komentářů, ? AS kódu, ? AS celkem, ? AS celkem_graf '; SQL+='UNION SELECT ?,?,?,?,?,?, (SELECT CASE WHEN count < 0 THEN null ELSE count END FROM (SELECT ? AS count) AS count) '; SQL+=') AS data '; SQL+='ORDER BY celkem_graf IS NULL, celkem_graf DESC'; VARCHAR,INTEGER,INTEGER,INTEGER,INTEGER,INTEGER,INTEGER TYPES=""; TYPES+=" , "; DATA=(); DATA+=( '' '' '' '' '' '' '' ); DATA+=( 'celkem' '' '' '' '' '' '-1' ); sql-dk --db cloc --sql "$SQL" --formatter barchart --formatter-property precision 80 --formatter-property headerTypes false --types "$TYPES" --data "${DATA[@]}"