diff options
Diffstat (limited to 'pkg/database')
| -rw-r--r-- | pkg/database/migrations/0002_nullable_passwords.sql | 4 | ||||
| -rw-r--r-- | pkg/database/sqlc/calendars.sql.go | 2 | ||||
| -rw-r--r-- | pkg/database/sqlc/db.go | 2 | ||||
| -rw-r--r-- | pkg/database/sqlc/favourites.sql.go | 2 | ||||
| -rw-r--r-- | pkg/database/sqlc/models.go | 8 | ||||
| -rw-r--r-- | pkg/database/sqlc/users.sql.go | 8 |
6 files changed, 16 insertions, 10 deletions
diff --git a/pkg/database/migrations/0002_nullable_passwords.sql b/pkg/database/migrations/0002_nullable_passwords.sql new file mode 100644 index 0000000..2f31366 --- /dev/null +++ b/pkg/database/migrations/0002_nullable_passwords.sql @@ -0,0 +1,4 @@ +-- +goose Up +ALTER TABLE users DROP CONSTRAINT valid_hash; +ALTER TABLE users ALTER COLUMN password DROP NOT NULL; +ALTER TABLE users ADD CONSTRAINT valid_hash CHECK (length(password) = 60 OR password IS NULL); diff --git a/pkg/database/sqlc/calendars.sql.go b/pkg/database/sqlc/calendars.sql.go index 47ae37f..ad55a51 100644 --- a/pkg/database/sqlc/calendars.sql.go +++ b/pkg/database/sqlc/calendars.sql.go @@ -1,6 +1,6 @@ // Code generated by sqlc. DO NOT EDIT. // versions: -// sqlc v1.27.0 +// sqlc v1.29.0 // source: calendars.sql package sqlc diff --git a/pkg/database/sqlc/db.go b/pkg/database/sqlc/db.go index b931bc5..2725108 100644 --- a/pkg/database/sqlc/db.go +++ b/pkg/database/sqlc/db.go @@ -1,6 +1,6 @@ // Code generated by sqlc. DO NOT EDIT. // versions: -// sqlc v1.27.0 +// sqlc v1.29.0 package sqlc diff --git a/pkg/database/sqlc/favourites.sql.go b/pkg/database/sqlc/favourites.sql.go index 359ae9d..b13261f 100644 --- a/pkg/database/sqlc/favourites.sql.go +++ b/pkg/database/sqlc/favourites.sql.go @@ -1,6 +1,6 @@ // Code generated by sqlc. DO NOT EDIT. // versions: -// sqlc v1.27.0 +// sqlc v1.29.0 // source: favourites.sql package sqlc diff --git a/pkg/database/sqlc/models.go b/pkg/database/sqlc/models.go index e38851a..57fd082 100644 --- a/pkg/database/sqlc/models.go +++ b/pkg/database/sqlc/models.go @@ -1,6 +1,6 @@ // Code generated by sqlc. DO NOT EDIT. // versions: -// sqlc v1.27.0 +// sqlc v1.29.0 package sqlc @@ -23,7 +23,7 @@ type Favourite struct { } type User struct { - ID int32 `json:"id"` - Username string `json:"username"` - Password string `json:"password"` + ID int32 `json:"id"` + Username string `json:"username"` + Password pgtype.Text `json:"password"` } diff --git a/pkg/database/sqlc/users.sql.go b/pkg/database/sqlc/users.sql.go index dfd2c2f..cf0aeb9 100644 --- a/pkg/database/sqlc/users.sql.go +++ b/pkg/database/sqlc/users.sql.go @@ -1,12 +1,14 @@ // Code generated by sqlc. DO NOT EDIT. // versions: -// sqlc v1.27.0 +// sqlc v1.29.0 // source: users.sql package sqlc import ( "context" + + "github.com/jackc/pgx/v5/pgtype" ) const createUser = `-- name: CreateUser :one @@ -19,8 +21,8 @@ RETURNING id, username, password ` type CreateUserParams struct { - Username string `json:"username"` - Password string `json:"password"` + Username string `json:"username"` + Password pgtype.Text `json:"password"` } func (q *Queries) CreateUser(ctx context.Context, arg CreateUserParams) (User, error) { |