From c55e936be03a3a023330789f903e2fbd12f4a308 Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Jo=C3=A3o=20Baptista?=
 <15786310+M4RC3L05@users.noreply.github.com>
Date: Tue, 19 Nov 2024 21:01:16 +0000
Subject: feat(fmt): support SQL (#26750)
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

This commit adds support for .sql files in "deno fmt" subcommand.

Closes: https://github.com/denoland/deno/issues/25024
---------

Signed-off-by: m4rc3l05 <15786310+M4RC3L05@users.noreply.github.com>
Co-authored-by: Bartek Iwańczuk <biwanczuk@gmail.com>
---
 tests/testdata/fmt/badly_formatted.md        | 12 ++++++++++++
 tests/testdata/fmt/badly_formatted.sql       | 21 +++++++++++++++++++++
 tests/testdata/fmt/badly_formatted_fixed.md  | 15 +++++++++++++++
 tests/testdata/fmt/badly_formatted_fixed.sql | 22 ++++++++++++++++++++++
 4 files changed, 70 insertions(+)
 create mode 100644 tests/testdata/fmt/badly_formatted.sql
 create mode 100644 tests/testdata/fmt/badly_formatted_fixed.sql

(limited to 'tests/testdata')

diff --git a/tests/testdata/fmt/badly_formatted.md b/tests/testdata/fmt/badly_formatted.md
index 642918cea..be90ff845 100644
--- a/tests/testdata/fmt/badly_formatted.md
+++ b/tests/testdata/fmt/badly_formatted.md
@@ -63,3 +63,15 @@ function foo(): number {
 let a:number
 </script>
 ```
+
+
+```sql
+  seLect * , biz, buz
+from baz;
+```
+
+```sql
+-- deno-fmt-ignore-file
+  seLect * , biz, buz
+from baz;
+```
diff --git a/tests/testdata/fmt/badly_formatted.sql b/tests/testdata/fmt/badly_formatted.sql
new file mode 100644
index 000000000..8b4cb978f
--- /dev/null
+++ b/tests/testdata/fmt/badly_formatted.sql
@@ -0,0 +1,21 @@
+select * from foo;
+update foo set a = 'b'Where id = 'biz';
+
+
+ create table foo(id text not null
+bar text,
+  biz int,
+  buz number NOT NULL
+);
+
+INSERT 
+  into
+  user_data 
+  (first_name, 
+last_name, address, phone, email)
+VALUES
+  ('foo', 'bar', 
+  'biz', 1, 'bix');
+
+
+
diff --git a/tests/testdata/fmt/badly_formatted_fixed.md b/tests/testdata/fmt/badly_formatted_fixed.md
index 21176742b..7a482e058 100644
--- a/tests/testdata/fmt/badly_formatted_fixed.md
+++ b/tests/testdata/fmt/badly_formatted_fixed.md
@@ -56,3 +56,18 @@ function foo(): number {
   let a: number;
 </script>
 ```
+
+```sql
+SELECT
+  *,
+  biz,
+  buz
+FROM
+  baz;
+```
+
+```sql
+-- deno-fmt-ignore-file
+  seLect * , biz, buz
+from baz;
+```
diff --git a/tests/testdata/fmt/badly_formatted_fixed.sql b/tests/testdata/fmt/badly_formatted_fixed.sql
new file mode 100644
index 000000000..d50c61921
--- /dev/null
+++ b/tests/testdata/fmt/badly_formatted_fixed.sql
@@ -0,0 +1,22 @@
+SELECT
+  *
+FROM
+  foo;
+
+UPDATE
+  foo
+SET
+  a = 'b'
+WHERE
+  id = 'biz';
+
+CREATE TABLE foo(
+  id text NOT NULL bar text,
+  biz int,
+  buz number NOT NULL
+);
+
+INSERT INTO
+  user_data (first_name, last_name, address, phone, email)
+VALUES
+  ('foo', 'bar', 'biz', 1, 'bix');
-- 
cgit v1.2.3