qpismont
aaa0ca5a54
- Created migration for accounts table with fields: id, username, password, role_id, created_at, updated_at. - Created migration for movies table with fields: id, title, overview, poster_path, backdrop_path, release_date, tmdb_id. refactor: update package.json scripts and dependencies - Changed dev script to use bun instead of tsx. - Added build:migrate script for migration. - Updated devDependencies for bun and oxlint. fix: refactor database connection and migration execution - Updated PgDatabase to use SQL from bun. - Refactored migration execution logic to read SQL files and execute them. feat: implement account creation and validation logic - Updated AccountEntity to use username instead of email. - Added validation for username format and password strength. - Implemented account repository methods for finding by username and inserting accounts. test: add tests for account entity, repository, and service - Created tests for AccountEntity to validate username and password. - Added tests for AccountRepository to ensure correct database interactions. - Implemented tests for AccountService to validate registration and login logic. chore: remove outdated tests and files - Deleted old tests related to email-based account management. - Cleaned up unused imports and files to streamline the codebase.
11 lines
423 B
SQL
11 lines
423 B
SQL
CREATE TABLE IF NOT EXISTS public.accounts (
|
|
id integer NOT NULL GENERATED ALWAYS AS IDENTITY,
|
|
username text NOT NULL,
|
|
password text NOT NULL,
|
|
role_id smallint NOT NULL DEFAULT '1',
|
|
created_at timestamp without time zone NOT NULL DEFAULT now (),
|
|
updated_at timestamp without time zone NOT NULL DEFAULT now (),
|
|
CONSTRAINT accounts_pkey PRIMARY KEY (id),
|
|
CONSTRAINT accounts_username_key UNIQUE (username)
|
|
);
|