Skip to content

Commit cc3a96c

Browse files
authored
README: Update language / database support (#698)
* README: Update language / database support * WIP * dolphin: Convert more operators
1 parent 9dd61dd commit cc3a96c

File tree

13 files changed

+177
-24
lines changed

13 files changed

+177
-24
lines changed

README.md

Lines changed: 5 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -434,11 +434,11 @@ sqlc currently only supports PostgreSQL / Go. MySQL and Kotlin support have
434434
been merged, but both are marked as experimental. SQLite and TypeScript support
435435
are planned.
436436

437-
| Language | PostgreSQL | MySQL | SQLite |
438-
| ------------ |:----------------:|:----------------:|:----------------:|
439-
| Go |:white_check_mark:|:warning: |:timer_clock: |
440-
| Kotlin |:warning: |:timer_clock: |:timer_clock: |
441-
| TypeScript |:timer_clock: |:timer_clock: |:timer_clock: |
437+
| Language | PostgreSQL | MySQL |
438+
| ------------ |:----------------:|:----------------:|
439+
| Go | :white_check_mark: - Stable | :bug: - Beta |
440+
| TypeScript | :timer_clock: - Planned | :timer_clock: - Planned |
441+
| Kotlin | :warning: - Experimental | |
442442

443443
If you'd like to add another database or language, we'd welcome a contribution.
444444

internal/compiler/output_columns.go

Lines changed: 1 addition & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -64,8 +64,7 @@ func outputColumns(qc *QueryCatalog, node ast.Node) ([]*Column, error) {
6464
// TODO: Generate a name for these operations
6565
cols = append(cols, &Column{Name: name, DataType: "bool", NotNull: true})
6666
case lang.IsMathematicalOperator(astutils.Join(n.Name, "")):
67-
// TODO: Generate correct numeric type
68-
cols = append(cols, &Column{Name: name, DataType: "pg_catalog.int4", NotNull: true})
67+
cols = append(cols, &Column{Name: name, DataType: "int", NotNull: true})
6968
default:
7069
cols = append(cols, &Column{Name: name, DataType: "any", NotNull: false})
7170
}

internal/endtoend/testdata/subquery_calculated_column/sqlc.json renamed to internal/endtoend/testdata/subquery_calculated_column/mysql/sqlc.json

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -3,6 +3,7 @@
33
"packages": [
44
{
55
"path": "go",
6+
"engine": "mysql:beta",
67
"name": "querytest",
78
"schema": "query.sql",
89
"queries": "query.sql"

internal/endtoend/testdata/subquery_calculated_column/postgresql/go/db.go

Lines changed: 29 additions & 0 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

internal/endtoend/testdata/subquery_calculated_column/postgresql/go/models.go

Lines changed: 12 additions & 0 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

internal/endtoend/testdata/subquery_calculated_column/postgresql/go/query.sql.go

Lines changed: 35 additions & 0 deletions
Some generated files are not rendered by default. Learn more about customizing how changed files appear on GitHub.

0 commit comments

Comments
 (0)