[Error] there is allways - 'syntax error near " CREATE TABLE authors"'

[GARcraft]

Windows 11 using docker (but if I try to use sql.exe, there is same results)

sqlc.yaml:

version: '2'sql: - schema: "schema.sql"queries: "query.sql"engine: "mysql"gen: go: out: "MySqlExample"

schema.sql:

CREATETABLEauthors ( id INTEGERPRIMARY KEY, name textNOT NULL, bio text );

query.sql:

-- name: ListAuthors :manySELECT*FROM authors ORDER BY name;

command:

docker run --rm -v ${pwd}:/src -w /src sqlc/sqlc generate 

response:

# package schema.sql:1:9: syntax error near " CREATE TABLE authors" 

^ allways shows first line of schema.sql file

If I will try to use 'sqlite' instead of 'mysql' there is another error:

line 1:0 extraneous input ' ' expecting{<EOF>, ';', ALTER_, ANALYZE_, ATTACH_, BEGIN_, COMMIT_, CREATE_, DEFAULT_, DELETE_, DETACH_, DROP_, END_, EXPLAIN_, INSERT_, PRAGMA_, REINDEX_, RELEASE_, REPLACE_, ROLLBACK_, SAVEPOINT_, SELECT_, UPDATE_, VACUUM_, VALUES_, WITH_} # package schema.sql:1:1: extraneous input ' ' expecting{<EOF>, ';', ALTER_, ANALYZE_, ATTACH_, BEGIN_, COMMIT_, CREATE_, DEFAULT_, DELETE_, DETACH_, DROP_, END_, EXPLAIN_, INSERT_, PRAGMA_, REINDEX_, RELEASE_, REPLACE_, ROLLBACK_, SAVEPOINT_, SELECT_, UPDATE_, VACUUM_, VALUES_, WITH_} 

Could someone has this issue? Please tell me what did you do, to make it work.

[ross-lightsource]

Running with all of those files in a 'testing' folder on ubuntu running:
% cd testing; sqlc generate
and
% cd testing; sqlc -f ./sqlc.yaml generate
work fine in all cases. I can't get it to break. Similar on macos and win11.

I would guess it's something between your docker command and your container's files.

db.go:
// Code generated by sqlc. DO NOT EDIT.
// versions:
// sqlc v1.27.0

package MySqlExample

import (
"context"
"database/sql"
)

type DBTX interface{
ExecContext(context.Context, string, ...interface{}) (sql.Result, error)
PrepareContext(context.Context, string) (*sql.Stmt, error)
QueryContext(context.Context, string, ...interface{}) (*sql.Rows, error)
QueryRowContext(context.Context, string, ...interface{}) *sql.Row
}

func New(db DBTX) *Queries{
return &Queries{db: db}
}

type Queries struct{
db DBTX
}

func (q *Queries) WithTx(tx *sql.Tx) *Queries{
return &Queries{
db: tx,
}
}

models.go:
// Code generated by sqlc. DO NOT EDIT.
// versions:
// sqlc v1.27.0

package MySqlExample

import (
"database/sql"
)

type Author struct{
ID int32
Name string
Bio sql.NullString
}

query.sql.go:
// Code generated by sqlc. DO NOT EDIT.
// versions:
// sqlc v1.27.0
// source: query.sql

package MySqlExample

import (
"context"
)

const listAuthors = -- name: ListAuthors :many SELECT id, name, bio FROM authors ORDER BY name

func (q *Queries) ListAuthors(ctx context.Context) ([]Author, error){
rows, err := q.db.QueryContext(ctx, listAuthors)
if err != nil{
return nil, err
}
defer rows.Close()
var items []Author
for rows.Next(){
var i Author
if err := rows.Scan(&i.ID, &i.Name, &i.Bio); err != nil{
return nil, err
}
items = append(items, i)
}
if err := rows.Close(); err != nil{
return nil, err
}
if err := rows.Err(); err != nil{
return nil, err
}
return items, nil
}

[TomatePilatus]

Try removing the byte-order mark (BOM) from your .sql files.