sql-formatter icon indicating copy to clipboard operation
sql-formatter copied to clipboard

new format config for skipping white spaces before and after block pa…

Open hemlac opened this issue 2 years ago • 0 comments

With this new config parameter you are able to skip white spaces before and after block parentheses. For example Without this parameter: CREATE VIEW sakila.v_exampl (customer, phone, title) AS select concat(sakila.customer.last_name,', ',sakila.customer.first_name) AS customer,sakila.address.phone AS phone,sakila.film.title AS title from ((((sakila.rental join sakila.customer on((sakila.rental.customer_id = sakila.customer.customer_id))) join sakila.address on((sakila.customer.address_id = sakila.address.address_id))) join sakila.inventory on((sakila.rental.inventory_id = sakila.inventory.inventory_id))) join sakila.film on((sakila.inventory.film_id = sakila.film.film_id))) where ((sakila.rental.return_date is null) and ((sakila.rental.rental_date + interval sakila.film.rental_duration day) < curdate())) order by sakila.film.title limit 5 Result: CREATE VIEW sakila.v_exampl (customer, phone, title) AS select concat( sakila.customer.last_name, ', ', sakila.customer.first_name ) AS customer, sakila.address.phone AS phone, sakila.film.title AS title from ( ( ( ( sakila.rental join sakila.customer on( ( sakila.rental.customer_id = sakila.customer.customer_id ) ) ) join sakila.address on( ( sakila.customer.address_id = sakila.address.address_id ) ) ) join sakila.inventory on( ( sakila.rental.inventory_id = sakila.inventory.inventory_id ) ) ) join sakila.film on((sakila.inventory.film_id = sakila.film.film_id)) ) where ( (sakila.rental.return_date is null) and ( ( sakila.rental.rental_date + interval sakila.film.rental_duration day ) < curdate() ) ) order by sakila.film.title limit 5

With this new parameter CREATE VIEW sakila.v_exampl (customer, phone, title) AS select concat(sakila.customer.last_name, ', ', sakila.customer.first_name)AS customer, sakila.address.phone AS phone, sakila.film.title AS title from ((((sakila.rental join sakila.customer on((sakila.rental.customer_id = sakila.customer.customer_id))) join sakila.address on((sakila.customer.address_id = sakila.address.address_id))) join sakila.inventory on((sakila.rental.inventory_id = sakila.inventory.inventory_id))) join sakila.film on((sakila.inventory.film_id = sakila.film.film_id))) where ((sakila.rental.return_date is null) and ((sakila.rental.rental_date + interval sakila.film.rental_duration day)< curdate())) order by sakila.film.title limit 5

hemlac avatar Jan 10 '24 20:01 hemlac