Index: .gitignore
===================================================================
--- .gitignore (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
+++ .gitignore (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
@@ -0,0 +1,38 @@
+HELP.md
+target/
+!.mvn/wrapper/maven-wrapper.jar
+!**/src/main/**/target/
+!**/src/test/**/target/
+
+### STS ###
+.apt_generated
+.classpath
+.factorypath
+.project
+.settings
+.springBeans
+.sts4-cache
+
+### IntelliJ IDEA ###
+.idea
+*.iws
+*.iml
+*.ipr
+
+### NetBeans ###
+/nbproject/private/
+/nbbuild/
+/dist/
+/nbdist/
+/.nb-gradle/
+build/
+!**/src/main/**/build/
+!**/src/test/**/build/
+
+### VS Code ###
+.vscode/
+
+compose.yaml
+.env
+.mvn/*
+.mvn
Index: _BUILD_BOARD.xml
===================================================================
--- ER_BUILD_BOARD.xml (revision 60a0e5c67655330cf92f154a1aa53fa6f5175b22)
+++ (revision )
@@ -1,1 +1,0 @@
-THREADtrue16dPROJECT_THREADTOPIC_THREADDOUBLE3DISCUSSION_THREADDOUBLE3CONTAINS3NBELONGS_TONTAGUSER33true16oDEVELOPERINVLOVLED_IN3NPROJECT_MANAGERtrue16oIS_OWNED_BY3N33MPERMISSIONSHASNHASNCREATESDOUBLE3CUSTOM_ROLEM3M3NDOUBLE3CONTAINS3NDOUBLE3CONTAINSDOUBLE3CHANNEL3NIS_CREATED_BY3NIS_CREATED_BY3NMODERATORtrue16oIS_MODERATED_BY3NREPLIES
Index: docs/ERModelWiki.txt
===================================================================
--- docs/ERModelWiki.txt (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
+++ docs/ERModelWiki.txt (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
@@ -0,0 +1,107 @@
+== ER Дијаграм
+[[Image(ER_BUILD_BOARD_v2.png)]]
+== Податочни побарувања
+=== Ентитети
+* Ентитет **USER** - податоци за корсниците.
+ * Кандидат клучеви: Username. Поради чести промени на атрибутот, за примерен клуч избравме вештачки клуч Id.
+ * Атрибути:
+ * Username - текстуален податок,задолижетелен.
+ * Description - текстуален податок,опционален.
+ * Password - текстуален податок,задолжителен.
+ * Register_date - текстуален податок,задолжителен.
+ * Sex - текстуален податок,опционален.
+ * Is_active - булов податок, задолжителен.
+ * Id - нумерички податок, задолжителен.
+* Ентитет **DEVELOPER** - преклопувачка специјализација, со делумно учество, од USER. Ентитетов се однесува на корисниците, кои се истовремено и развивачи на софтвер.
+ *Кандидат клучеви: исто како и ентитетот USER и овај ентитет се идентификува со примарниот вештачки клуч Id.
+* Ентитет **PROJECT_OWNER** - преклопувачка специјализација, со делумно учество, од DEVELOPER. Ентитетов се однесува на развивачите на софтвер, кои поседуваат проекти.
+ *Кандидат клучеви: исто како и ентитетот DEVELOPER и овај ентитет се идентификува со примарниот вештачки клуч Id.
+* Ентитет **MODERATOR** - преклопувачка специјализација, со делумно учество, од USER. Ентитетов се однесува на корисниците, кои истовремено се и модератори на threads.
+ *Кандидат клучеви: исто како и ентитетот USER и овај ентитет се идентификува со примарниот вештачки клуч Id.
+* Ентитет **TAG** - податоци за можните тагови. Служат за групирање на thread.
+ * Кандидат клучеви: Name, како податок уникат за секој таг. Истиот го избравме за примарен клуч на ентитетов.
+ * Атрибути:
+ * Name - текстуален податок,задолжителен.
+* Ентитет **THREAD** - генерализација на сите можни водови на threads. Ги содржи сличните податоци присутни кај поединечните видови.
+ * Кандидат клучеви: бидејќи најмално супер-клуч множество би се состоело од сите атрибути на ентитет, за примарен клуч избравме вештачки клуч Id.
+ * Атрибути:
+ * Content - текстуален податок,задолжителен.
+ * Id - нумерички податок, задолжителен.
+* Ентитет **TOPIC_THREAD** - дисјунктна специјализација, со целосно учество, од THREAD. Ентитетов се однесува на сите threads кој се топици и ги содржи податоците специфични за нив.
+ * Кандидат клучеви: исто како и ентитетот THREAD и овај ентитет се идентификува со примарниот,вештачки клуч Id.
+ * Атрибути:
+ * Title - текстуален податок,задолжителен.
+ * Guidlines - json податок,задолжителен.
+* Ентитет **DISCUSSION_THREAD** - дисјунктна специјализација, со целосно учество, од THREAD. Ентитетов се однесува на сите threads кој се дискусии и ги содржи податоците специфични за нив.
+ * Кандидат клучеви: исто како и ентитетот THREAD и овај ентитет се идентификува со примарниот,вештачки клуч Id.
+* Ентитет **PROJECT_THREAD** - дисјунктна специјализација, со целосно учество, од THREAD. Ентитетов се однесува на сите threads кој се дискусии и ги содржи податоците специфични за нив.
+ * Кандидат клучеви: исто како и ентитетот THREAD и овај ентитет се идентификува со примарниот,вештачки клуч Id.
+ * Атрибути:
+ * Repo_url - текстуален податок, опционален.
+ * Title - текстуален податок,задолжителен.
+* Слаб ентитет **BLACKLISTED_USER** - податоци за тоа на кои корисници му е забранет пристапот во кои threads, од кои модератор.
+ * Кандидат клучеви: парцијалнен клуч Start_date, но за целосно идентификување се користат идентификувачките релации со THREAD,MODERATOR и USER.
+ * Атрибути:
+ * Start_date - датум, задолжителен.
+ * End_date - датум, опционален.
+ * Reason - текстуален податок,задолжителен.
+* Слаб ентитет **REPORT** - податоци за извештаите, во врска со можни прекршување на правилата на соодветен thread, од страна на соодветни корсиници.
+ * Кандидат клучеви: заради можноста да постојат повеќе извештаи, кои се однесуваат на истиот корсиник, за прекршувања на правилата на истиот thread, поднеси од страна на истиот корисник, одлучивме да генерираме вештачки парцијалнен клуч Id. За целосно идентификување на ентитетиве служат идентификувачките релации со THREAD и USER.
+ * Атрибути:
+ * Id - нумерички, задолжителен.
+ * Created_at - датум, задолжителен.
+ * Status - енумерирачки, задолжителен.
+ * Description - текстуален, задолжителен.
+* Слаб ентитет **PROJECT_REQUEST** - податоци за сите барања за учество од страна на корисниците кон конкретен проект.
+ * Кандидат клучеви: заради можноста еден корисник да испрати повеќе барања за учество кон ист проект, одлучивме да генерираме вештачки парцијалнен клуч Id. За целосно идентификување на ентитетиве служат идентификувачките релации со USER и PROJECT_THREAD.
+ * Атрибути:
+ * Id - нумерички, задолжителен.
+ * Status - енумерирачки, задолжителен.
+ * Description - текстуален, задолжителен.
+* Слаб ентитет **CHANNEL** - податоци за каналите во проектите.
+ * Кандидат клучеви: парцијалниот клуч Name, целосно се идентификува преку идентификувачката релација со PROJECT_THREAD.
+ * Атрибути:
+ * Name - текстуален, задолжителен.
+ * Description - текстуален, опционален.
+* Ентитет **CUSTOM_ROLE** - податоци за креирани улоги, кои се доделуваат на развивачите во конкретен проект.
+ * Кандидат клучеви: парцијалниот клуч Name, целосно се идентификува преку идентификувачката релација со PROJECT_THREAD.
+ * Атрибути:
+ * Name - текстуален,задолжителен.
+* Ентитет **PERMISSIONS** - податоци за пермисиите, кои се достапни во дефинирањето на улогите во пеодиенчните проекти.
+ * Кандидат клучеви: Name, како податок уникат за секојa пермисија. Истиот го избравме за примарен клуч на ентитетов.
+ * Атрибути:
+ * Name - текстуален,задолжителен.
+=== Релации
+* **IS_MODERATED_BY**(N:M) - релација помеѓу TOPIC_THREAD и MODERATOR. Ни кажува кои се модератори на соодветниот TOPIC_THREAD.
+* **IS_CHILD_TO**(1:N) - релација помеѓу TOPIC_THREAD и TOPIC_THREAD. Ни опишува како се разделува општ топик на поспецифички топици.
+* **CONTAINS**(1:N) - релација помеѓу TOPIC_THREAD и DISCUSSION_THREAD. Ни ги претставува дискусиите започнатите во топикот.
+* **BELONGS_TO**(1:N) - релацијата помеѓу PROJECT_THREAD и TOPIC_THREAD. Ни кажува кои топици се започнатите во соодветниот проект.
+* **REPLIES**(1:N) - релација помеѓу DISCUSSION_THREAD и DISCUSSION_THREAD. Ни кажува кои дискусии се произлегле од соодветна дискусија.
+* **ASSIGNED_TO**(N:M) - релација помеѓу THREAD и TAG. Ни кажува кои се таговите на соодветниот thread.
+* **CREATES**(1:N) - релација помеѓу MODERATOR и TAG. Ни кажува кои тагови ги креирал соодветниот модератор.
+* **BLACKLISTED_BY**(1:N) - релација помеѓу MODERATOR и BLACKLISTED_USER. Ни кажува кој модератор го ставил кој корисник на 'blacklist'.
+* **BLACKLISTED_FROM**(1:N) - релација помеѓу THREAD и BLACKLISTED_USER. Ни кажува во кој theads е "blacklisted" корисникот.
+* **REFERS_TO**(1:N) - релација помеѓу USER и BLACKLISTED_USER. Ни кажува на кој корисник се однесува соодветниот запис во BLACKLISTED_USER.
+* **FOR_MISCONDUCT**(1:N) - релација помеѓу THREAD и REPORT. Ни кажува во кој и на кој thread правилата се прекршиле.
+* **ABOUT**(1:N) - релација помеѓу USER и REPORT. Ни кажува кој корисник е обвинет за прекршување на правилата.
+* **SUBMITTED_BY**(1:N) - релација помеѓу USER и REPORT. Ни кажува кој корисник го поднесол извештајот.
+* **LIKES**(N:M) - релација помеѓу USER и THREAD. Ни ги претставува сите threads, кој му се допаднале на корисникот.
+* **SUBMITS**(1:N) - релација помеѓу USER и PROJECT_REQUEST. Ни кажува кој корисник го поднел соодветното барање за учество.
+* **RECIEVES**(1:N) - релација помеѓу PROJECT_THREAD и PROJECT_REQUEST. Ни кажува за кој проект, корисникот го поднел соодветното барање за учество.
+* **VALID_IN**(1:N) - релација помеѓу PROJECT_THREAD и CUSTOM_ROLE. Ни кажува во кој проект е валидна соодветната улога.
+* **HAS**(1:N) - релација помеѓу PROJECT_THREAD и CHANNEL. Ни кажува во кој проект припаѓа соодветниот канал.
+* **ASSOCIATED_WITH**(N:M) - релација помеѓу PROJECT_THREAD и DEVELOPER. Ни кажува во кој проекти учествувал/учествува соодветниот програмер.
+ * Атрибути:
+ * Started_involvment_at - датум, задолжителен.
+ * Ended_involment_at - датум, опционален.
+* **DEFINED_BY**(N:M) - релација помеѓу CUSTOM_ROLE и PERMISSIONS. Ни кажува кој пермисии ги опфаќа соодветната улога.
+* **CONSTRUCTS**(N:M) - релација помеѓу CHANNEL и DEVELOPER. Ни кажува кој програмер го креирал соодветниот канал.
+* **SEND_MESSAGE_IN**(N:M) - релација помеѓу CHANNEL и DEVELOPER. Ни претставува кој програмер испратил порака во соодветниот канал.
+ * Атрибути
+ * Timestamp - датум, задолжителен.
+ * Msg_txt - текстуален, задолжителен.
+* **IS_ASSIGNED**(N:M) - релација помеѓу CUSTOM_ROLE и DEVELOPER. Ни кажува кој улоги ги поседува соодветниот програмер.
+=== Историјат
+
+
+
Index: docs/RelationalSchema.txt
===================================================================
--- docs/RelationalSchema.txt (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
+++ docs/RelationalSchema.txt (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
@@ -0,0 +1,103 @@
+## Relational Schema
+
+1. **users** (_**username**_, is_activate, password, description, registered_at, sex)
+
+2. **moderator** (_**username#(users)**_) [inherits users]
+
+3. **developer** (_**username#(users)**_) [inherits users]
+
+4. **project_manager** (_**username#(users)**_) [inherits users]
+
+5. **thread** (_**id**_, description, logo_url, title, username#(users))
+
+6. **likes** (_**username#(users)**_, _**thread_id#(thread)**_)
+
+7. **threads_moderators** (_**thread_id#(thread)**_, _**username#(users)**_)
+
+8. **tag** (_**name**_)
+
+9. **tag_threads** (_**thread_id#(thread)**_, _**tag_name#(tag)**_)
+
+10. **topic_thread** (_**id**_, description, logo_url, title, username#(users), guidelines, next_discussion_id) [inherits thread]
+
+11. **project_thread** (_**id**_, description, logo_url, title, username#(users), repo_url) [inherits thread]
+
+12. **discussion_thread** (_**id**_, _**topic_id#(thread)**_, text, created_by_user#(users), reply_discussion, reply_topic_id)
+
+13. **topic_belongs_to_project** (_**topic_id#(thread)**_, _**project_id#(thread)**_)
+
+14. **topic_blacklist** (_**username#(users)**_, _**project_id#(users)**_)
+
+15. **developer_associated_with_project** (_**project_id#(thread)**_, _**developer#(users)**_, _**started_at**_, ended_at)
+
+16. **permissions** (_**name**_)
+
+17. **project_roles** (_**name**_, _**project_id#(thread)**_, description)
+
+18. **users_project_roles** (_**username#(users)**_, _**project_id#(thread)**_, _**role_name#(project_roles)**_)
+
+19. **project_roles_permissions** (_**permission_name#(permissions)**_, _**role_name#(project_roles)**_, _**project_id#(thread)**_)
+
+20. **project_request** (_**id**_, reason, status, submited_by_user#(users), for_project#(thread))
+
+21. **report** (_**id**_, created_at, description, status, thread_id#(thread), for_user#(users), by_user#(users))
+
+22. **channel** (_**name**_, description, logo_url, _**project_id#(thread)**_, developer#(users))
+
+23. **messages** (_**sent_at**_, content, _**sent_by#(users)**_, _**project_id#(thread)**_, _**channel_name#(channel)**_)
+
+
+
+
+V2
+
+
+## Relational Schema
+
+1. **users** (_**username**_, is_activate, password, description, registered_at, sex)
+
+2. **moderator** (_**username#(users)**_)
+
+3. **developer** (_**username#(users)**_)
+
+4. **project_manager** (_**username#(users)**_)
+
+5. **thread** (_**id**_, content, _**username#(users)**_)
+
+6. **likes** (_**username#(users)**_, _**thread_id#(thread)**_)
+
+7. **topic_threads_moderators** (_**thread_id#(thread)**_, _**username#(users)**_)
+
+8. **tag** (_**name**_)
+
+9. **tag_threads** (_**thread_id#(thread)**_, _**tag_name#(tag)**_)
+
+10. **topic_thread** (_**id#(thread)**_, title, guidelines, next_discussion_id, parent_topic_id#(thread))
+
+11. **topic_belongs_to_project** (_**topic_id#(thread)**_, _**project_id#(thread)**_)
+
+12. **topic_blacklist** (_**topic_id#(thread)**_, _**username#(users)**_, _**moderator#(users)**_)
+
+13. **project_thread** (_**id#(thread)**_, title, repo_url)
+
+14. **discussion_thread** (_**id#(thread)**_, _**created_by_user#(users)**_, reply_discussion_id#(thread), topic_id#(thread))
+
+15. **developer_associated_with_project** (_**project_id#(thread)**_, _**developer#(users)**_, _**started_at**_, ended_at)
+
+16. **permissions** (_**name**_)
+
+17. **project_roles** (_**name**_, _**project_id#(thread)**_, description)
+
+18. **users_project_roles** (_**username#(users)**_, _**project_id#(thread)**_, _**role_name#(project_roles)**_)
+
+19. **project_roles_permissions** (_**permission_name#(permissions)**_, _**role_name#(project_roles)**_, _**project_id#(thread)**_)
+
+20. **project_request** (_**id**_, description, status, _**submited_by_user#(users)**_, _**project_id#(thread)**_)
+
+21. **report** (_**id**_, created_at, description, status, _**thread_id#(thread)**_, _**for_user#(users)**_, _**by_user#(users)**_)
+
+22. **channel** (_**name**_, description, logo_url, _**project_id#(thread)**_, _**developer#(users)**_)
+
+23. **messages** (_**sent_at**_, content, _**sent_by#(users)**_, _**project_id#(thread)**_, _**channel_name#(channel)**_)
+
+
Index: docs/UseCase.txt
===================================================================
--- docs/UseCase.txt (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
+++ docs/UseCase.txt (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
@@ -0,0 +1,59 @@
+Use Cases
+
+User
+ - Kreirat topic.
+ - Kreirat discussion thread vo topic thread.
+ - Pravi reply na discussion thread.
+ - Stava like na thread.
+ - Korisnik prijavuva drug korisnik za nesoodvetno odnesuvanje.
+ - Korisnikot se prijavuva za uchestvo vo proekt.
+ - Referencira drug thread.
+
+Moderator
+ - Nadgleduvat odreden Topic/Project thraed.
+ - Dodavat/Kreirat tagoj na dadeni topics.
+ - Otstranuvat korisnik od topicot.
+
+Developer
+ - Kreirat kanal vo project.
+ - Pisuva poraka vo kanal.
+
+Project Owner
+ - Odobruva ili odbiva baranja za ucestvo vo negoviot proekt.
+ - Otstranuva developer od proekt.
+ - Kreira roles za daden proekt
+ - Dodava roles na daden developer
+
+
+SQL ideas
+
+ - Site replies na daden thread t
+ - Site replies na daden thread t do dadeno nivo n - (primer ako imas thread -> reply1 -> reply2 -> reply3 -> reply2a, da gi prikazis site threads do reply2 i reply2a (ova znacit deka sa na isto nivo), znacit ke gi imas: thread -> reply1 -> reply2 -> reply2a. )
+ - Site vgnezdeni topic threads vo daden root topic thread t
+ - Kolku pati daden user u bil blacklistnat od nekoj topic/ project i/ili globalno od koj bilo
+ - Broj na replies na daden discussion thread ( ke trebit za sortiranje )
+ - Broj na likes na daden discussion thread.
+ - Broj na useri vo daden topic t (spored liked relacijata mozit ova da sa presmetat)
+ - Broj na reports so imat user submitnato vkupno
+ - Broj na reports so sa imat podneseno protiv daden user u
+ - Site developeri vo daden proekt so dadena permisija p - (primer za kreiranje kanali)
+ - Vo kolku proekti imat ucestvuvano daden developer d.
+ - Od proektite so ucestvuval, vo koj najdolgo ucestvuval daden developer d.
+ - Site poraki od daden developer vo daden kanal ili od site kanali
+ - Search spored content na poraka vo kanal
+ - Koi developers imat vo proekt p
+ //- Kolku razlicni developeri blacklistnal proektot p.
+ - Kolu pati daden developer d imat ucevstvuvano vo proekt p (primer ako zaprit pa pak vlezit pa pak...)
+ - Kolku kanali imat kreirano daden developer d (mozda za badge)
+ - Kolku useri vlegle vo proekt p vo daden interval na vreme i.
+
+
+ --- Ideja za achievements
+ Sekoj user so nad N likes na nekoj discussion thread vo daden topic thread da dobiet nekakov achievement(badge)
+ Developer so ucestvuval vo nad N proekti nekoj badge
+
+
+
+
+
+
Index: docs/buildboard-ddl.sql
===================================================================
--- docs/buildboard-ddl.sql (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
+++ docs/buildboard-ddl.sql (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
@@ -0,0 +1,318 @@
+--- Trigger before update/insert za check na iminjata topic/discussion -> OK
+--- Trigger za ko ke adnit dete na topic thread sho e vo proekt, da go dodajt kako belongs_to vo proektot
+--- Trigger za check dali reply na discussion thread pripagjat na ist topic thread kako na toj so mu pret reply
+--- IMENUVANJE: triggeri so provervat nesto prefix = check, funkcii za istite prefix = validate
+--- Nemame contraint sho velit deka sekoj topic thread trebat da e moderiran
+DROP TABLE IF EXISTS users CASCADE;
+DROP TABLE IF EXISTS moderator CASCADE;
+DROP TABLE IF EXISTS developer CASCADE;
+DROP TABLE IF EXISTS project_manager CASCADE;
+DROP TABLE IF EXISTS thread CASCADE;
+DROP TABLE IF EXISTS likes CASCADE;
+DROP TABLE IF EXISTS topic_threads_moderators CASCADE;
+DROP TABLE IF EXISTS tag CASCADE;
+DROP TABLE IF EXISTS tag_threads CASCADE;
+DROP TABLE IF EXISTS topic_thread CASCADE;
+DROP TABLE IF EXISTS topic_belongs_to_project CASCADE;
+DROP TABLE IF EXISTS blacklisted_user CASCADE;
+DROP TABLE IF EXISTS project_thread CASCADE;
+DROP TABLE IF EXISTS discussion_thread CASCADE;
+DROP TABLE IF EXISTS developer_associated_with_project CASCADE;
+DROP TABLE IF EXISTS permissions CASCADE;
+DROP TABLE IF EXISTS project_roles CASCADE;
+DROP TABLE IF EXISTS users_project_roles CASCADE;
+DROP TABLE IF EXISTS project_roles_permissions CASCADE;
+DROP TABLE IF EXISTS project_request CASCADE;
+DROP TABLE IF EXISTS report CASCADE;
+DROP TABLE IF EXISTS channel CASCADE;
+DROP TABLE IF EXISTS messages CASCADE;
+DROP TABLE IF EXISTS threads_moderators CASCADE;
+DROP TYPE IF EXISTS status;
+DROP VIEW IF EXISTS v_topic_thread CASCADE;
+DROP VIEW IF EXISTS v_project_thread CASCADE;
+DROP VIEW IF EXISTS v_discussion_thread CASCADE;
+DROP VIEW IF EXISTS v_developer CASCADE;
+DROP VIEW IF EXISTS v_project_owner CASCADE;
+DROP VIEW IF EXISTS v_moderator CASCADE;
+DROP FUNCTION IF EXISTS fn_project_insert_child_topic CASCADE;
+DROP FUNCTION IF EXISTS fn_validate_same_parent CASCADE;
+DROP TRIGGER IF EXISTS validate_same_parent ON discussion_thread CASCADE;
+---- DDL
+CREATE TABLE users
+(
+ id SERIAL PRIMARY KEY,
+ username VARCHAR(32) UNIQUE NOT NULL,
+ is_activate bool,
+ password VARCHAR(72),
+ description VARCHAR(200),
+ registered_at TIMESTAMP,
+ sex VARCHAR(1)
+);
+CREATE TABLE moderator
+(
+ id INT PRIMARY KEY REFERENCES users (id) on delete cascade
+);
+CREATE TABLE developer
+(
+ id INT PRIMARY KEY REFERENCES users (id) on delete cascade
+);
+CREATE TABLE project_manager
+(
+ id INT PRIMARY KEY REFERENCES users (id) on delete cascade
+);
+CREATE TABLE thread
+(
+ id SERIAL PRIMARY KEY,
+ content TEXT,
+ user_id INT REFERENCES users (id) NOT NULL
+);
+CREATE TABLE topic_thread
+(
+ title VARCHAR(32) NOT NULL,
+ guidelines jsonb,
+ parent_id INT REFERENCES thread (id),
+ id INT PRIMARY KEY REFERENCES thread (id) on delete cascade
+);
+CREATE TABLE discussion_thread
+(
+ parent_id INT REFERENCES thread (id) NOT NULL,
+ id INT PRIMARY KEY REFERENCES thread (id) on delete cascade
+);
+CREATE TABLE project_thread
+(
+ title VARCHAR(32) NOT NULL,
+ repo_url TEXT,
+ id INT PRIMARY KEY REFERENCES thread (id) on delete cascade
+);
+CREATE TABLE likes
+(
+ user_id INT REFERENCES users (id),
+ thread_id INT REFERENCES thread (id),
+ PRIMARY KEY (user_id, thread_id)
+);
+CREATE TABLE topic_threads_moderators
+(
+ thread_id INT REFERENCES thread (id) ON DELETE CASCADE,
+ user_id INT REFERENCES users (id) ON DELETE CASCADE,
+ PRIMARY KEY (thread_id, user_id)
+);
+CREATE TABLE tag
+(
+ name VARCHAR(64) PRIMARY KEY
+);
+CREATE TABLE tag_threads
+(
+ thread_id INT REFERENCES thread (id),
+ tag_name VARCHAR(64) REFERENCES tag (name),
+ PRIMARY KEY (thread_id, tag_name)
+);
+
+CREATE TABLE topic_belongs_to_project
+(
+ topic_id INT REFERENCES thread (id) ON DELETE CASCADE,
+ project_id INT REFERENCES thread (id) ON DELETE CASCADE,
+ PRIMARY KEY (topic_id, project_id)
+);
+CREATE TABLE blacklisted_user
+(
+ topic_id INT REFERENCES thread (id) ON DELETE CASCADE,
+ user_id INT REFERENCES users (id) ON DELETE CASCADE,
+ moderator_id INT REFERENCES users (id) ON DELETE CASCADE,
+ start_date TIMESTAMP,
+ end_date TIMESTAMP,
+ reason TEXT,
+ PRIMARY KEY (user_id, moderator_id, topic_id, start_date)
+);
+
+CREATE TABLE developer_associated_with_project
+(
+ project_id INT REFERENCES thread (id),
+ developer_id INT REFERENCES users (id),
+ started_at TIMESTAMP,
+ ended_at TIMESTAMP,
+ PRIMARY KEY (project_id, developer_id, started_at)
+);
+CREATE TABLE permissions
+(
+ name VARCHAR(32) PRIMARY KEY
+);
+CREATE TABLE project_roles
+(
+ name VARCHAR(32),
+ project_id INT REFERENCES thread (id) ON DELETE CASCADE,
+ description TEXT,
+ PRIMARY KEY (name, project_id)
+);
+CREATE TABLE users_project_roles
+(
+ user_id INT REFERENCES users (id),
+ project_id INT,
+ role_name VARCHAR(32),
+ FOREIGN KEY (role_name, project_id)
+ REFERENCES project_roles (name, project_id),
+ PRIMARY KEY (user_id, project_id, role_name)
+);
+CREATE TABLE project_roles_permissions
+(
+ permission_name VARCHAR(32) REFERENCES permissions (name),
+ role_name VARCHAR(32),
+ project_id INT,
+ PRIMARY KEY (permission_name, role_name, project_id),
+ FOREIGN KEY (role_name, project_id)
+ REFERENCES project_roles (name, project_id)
+);
+CREATE TYPE status AS ENUM ('ACCEPTED', 'DENIED', 'PENDING');
+CREATE TABLE project_request
+(
+ id SERIAL PRIMARY KEY,
+ description VARCHAR(200),
+ status status NOT NULL,
+ user_id INT REFERENCES users (id) NOT NULL,
+ project_id INT REFERENCES thread (id) NOT NULL
+);
+CREATE TABLE report
+(
+ id SERIAL,
+ created_at TIMESTAMP,
+ description VARCHAR(200) NOT NULL,
+ status status,
+ thread_id INT REFERENCES thread (id),
+ for_user_id INT REFERENCES users (id),
+ by_user_id INT REFERENCES users (id),
+ PRIMARY KEY (id, thread_id, for_user_id, by_user_id)
+);
+CREATE TABLE channel
+(
+ name VARCHAR(64),
+ description VARCHAR(200),
+ project_id INT REFERENCES thread (id) ON DELETE CASCADE,
+ developer_id INT REFERENCES users (id),
+ PRIMARY KEY (name, project_id)
+);
+CREATE TABLE messages
+(
+ sent_at TIMESTAMP,
+ content VARCHAR(200) NOT NULL,
+ sent_by INT REFERENCES users (id),
+ project_id INT,
+ channel_name VARCHAR(64),
+ FOREIGN KEY (channel_name, project_id)
+ REFERENCES channel (name, project_id) ON DELETE CASCADE,
+ PRIMARY KEY (channel_name, project_id, sent_at, sent_by)
+);
+------------------------VIEWS-----------------------------
+CREATE OR REPLACE VIEW v_project_thread
+AS
+SELECT thread.id, content, user_id, title, repo_url
+FROM project_thread project
+ JOIN thread
+ ON project.id = thread.id;
+CREATE OR REPLACE VIEW v_discussion_thread
+AS
+SELECT thread.id, content, user_id,parent_id
+FROM discussion_thread discussion
+ JOIN thread
+ ON discussion.id = thread.id;
+CREATE OR REPLACE VIEW v_topic_thread
+AS
+SELECT thread.id, content, user_id, title, guidelines, parent_id
+FROM topic_thread topic
+ JOIN thread
+ ON topic.id = thread.id;
+CREATE OR REPLACE VIEW v_moderator
+AS
+SELECT users.id, username, is_activate, password, description, registered_at, sex
+FROM moderator
+ JOIN users ON moderator.id = users.id;
+
+CREATE OR REPLACE VIEW v_developer
+AS
+SELECT users.id, username, is_activate, password, description, registered_at, sex
+FROM developer
+ JOIN users ON developer.id = users.id;
+CREATE OR REPLACE VIEW v_project_owner
+AS
+SELECT users.id, username, is_activate, password, description, registered_at, sex
+FROM project_manager
+ JOIN users ON project_manager.id = users.id;
+CREATE OR REPLACE VIEW v_moderator
+AS
+SELECT users.id, username, is_activate, password, description, registered_at, sex
+FROM moderator
+ JOIN users ON moderator.id = users.id;
+
+CREATE OR REPLACE VIEW v_developer
+AS
+SELECT users.id, username, is_activate, password, description, registered_at, sex
+FROM developer
+ JOIN users ON developer.id = users.id;
+CREATE OR REPLACE VIEW v_project_owner
+AS
+SELECT users.id, username, is_activate, password, description, registered_at, sex
+FROM project_manager
+ JOIN users ON project_manager.id = users.id;
+-------------------------- FUNCTIONS ----------------------
+CREATE OR REPLACE FUNCTION fn_validate_topic_title()
+ RETURNS TRIGGER
+ LANGUAGE plpgsql
+AS
+$$
+BEGIN
+ IF new.title IN
+ (SELECT title
+ FROM topic_thread
+ AS t
+ WHERE t.parent_id = new.parent_id OR (t.parent_id IS NULL AND new.parent_id IS NULL))
+ THEN
+ RAISE EXCEPTION 'There already exists a topic with title % in parent topic with id %',new.title,new.parent_id;
+END IF;
+RETURN new;
+END;
+$$;
+CREATE OR REPLACE FUNCTION fn_insert_topics_creator_as_moderator()
+ RETURNS TRIGGER
+ LANGUAGE plpgsql
+AS
+$$
+DECLARE
+v_user_id INT;
+BEGIN
+SELECT v_topic_thread.user_id
+INTO v_user_id
+FROM v_topic_thread
+WHERE v_topic_thread.id = new.id;
+INSERT INTO topic_threads_moderators(thread_id, user_id) VALUES (new.id, v_user_id);
+RETURN NEW;
+END;
+$$;
+
+CREATE OR REPLACE FUNCTION fn_insert_project_manager()
+RETURNS TRIGGER
+LANGUAGE plpgsql
+AS
+ $$
+ DECLARE usrId INT;
+BEGIN
+SELECT user_id INTO usrId FROM v_project_thread p WHERE NEW.id = p.id;
+INSERT INTO developer VALUES (usrId);
+INSERT INTO project_manager VALUES (usrId);
+RETURN NEW;
+END;
+ $$;
+-------------------------- TRIGGERS ----------------------
+CREATE OR REPLACE TRIGGER tr_check_topic_name
+ BEFORE INSERT OR UPDATE
+ ON topic_thread
+ FOR EACH ROW
+ EXECUTE FUNCTION fn_validate_topic_title();
+CREATE OR REPLACE TRIGGER tr_insert_topics_creator_as_moderator
+ AFTER INSERT
+ ON topic_thread
+ FOR EACH ROW
+EXECUTE FUNCTION fn_insert_topics_creator_as_moderator();
+CREATE OR REPLACE TRIGGER tr_insert_project_manager
+ AFTER INSERT
+ ON project_thread
+ FOR EACH ROW
+ EXECUTE FUNCTION fn_insert_project_manager();
+
Index: docs/test-data.sql
===================================================================
--- docs/test-data.sql (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
+++ docs/test-data.sql (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
@@ -0,0 +1,110 @@
+INSERT INTO users (username, is_activate, password, description, registered_at, sex)
+VALUES
+ ('user1', true, '$2a$12$0f.x7aBM2wFBZBXoLPj0BObVsk.J1kXFYo5nb4niAWkI4hk5tHvDy', 'First user', NOW(), 'M'),
+ ('user2', true, '$2a$12$VkR0a47LDVM6aUqFcEJGSu9jhZCz.05tCoyiRicFObt4f2x2gijKa', 'Second user', NOW(), 'F'),
+ ('user3', true, '$2a$12$eSLdHHJ1KFgv.dOupmloXeItjrt2o1IB6ER6Nq7WYj9Jfr2bEwK2a', 'Third user', NOW(), 'M'),
+ ('user4', true, '$2a$12$dF5SXcNhMulgU3Qre3nh1e.aatRiJZsnfoBSqReGnXe9rIbHYVWhe', 'Fourth user', NOW(), 'F'),
+ ('user5', true, '$2a$12$zHrloz8WG2zo5S6MTf1C0ez1raMlmDJdB8OOa2I1S2pVy9oI76YTa', 'Fifth user', NOW(), 'M');
+
+INSERT INTO thread (content, user_id)
+VALUES
+ ('Main content for topic thread 1', 1),
+ ('Main content for topic thread 2', 2),
+ ('Discussion content for topic 1', 1),
+ ('Discussion content for topic 2', 2),
+ ('Project-specific thread content', 3),
+ ('Reply to topic 1', 4),
+ ('Further discussion on topic 2', 5);
+
+INSERT INTO topic_thread (id, title, guidelines, parent_id)
+VALUES
+ (1, 'Topic 1', '{"rule1": "Follow guidelines"}', NULL),
+ (2, 'Topic 2', '{"rule2": "Be respectful"}', NULL);
+
+INSERT INTO discussion_thread (id, parent_id)
+VALUES
+ (3, 1),
+ (4, 2),
+ (6, 3),
+ (7, 4);
+
+INSERT INTO project_thread (id, title, repo_url)
+VALUES
+ (5, 'Project 1 Thread', 'http://github.com/project1');
+
+INSERT INTO likes (user_id, thread_id)
+VALUES
+ (1, 3),
+ (2, 4),
+ (3, 5),
+ (4, 6),
+ (5, 7);
+
+INSERT INTO tag (name)
+VALUES
+ ('Tag1'),
+ ('Tag2'),
+ ('Tag3');
+
+INSERT INTO tag_threads (thread_id, tag_name)
+VALUES
+ (1, 'Tag1'),
+ (3, 'Tag2'),
+ (5, 'Tag3'),
+ (6, 'Tag1');
+
+INSERT INTO topic_belongs_to_project (topic_id, project_id)
+VALUES
+ (1, 5),
+ (2, 5);
+
+INSERT INTO blacklisted_user (topic_id, user_id, moderator_id, start_date, end_date, reason)
+VALUES
+ (1, 2, 1, NOW(), NOW() + INTERVAL '7 days', 'Spamming'),
+ (2, 3, 4, NOW(), NOW() + INTERVAL '3 days', 'Offensive language');
+
+INSERT INTO developer_associated_with_project (project_id, developer_id, started_at)
+VALUES
+ (5, 2, NOW()),
+ (5, 3, NOW());
+
+INSERT INTO permissions (name)
+VALUES
+ ('Create Thread'),
+ ('Delete Thread');
+
+INSERT INTO project_roles (name, project_id, description)
+VALUES
+ ('Admin', 5, 'Admin role for the project'),
+ ('Developer', 5, 'Developer role for the project');
+
+INSERT INTO users_project_roles (user_id, project_id, role_name)
+VALUES
+ (3, 5, 'Admin'),
+ (2, 5, 'Developer'),
+ (4, 5, 'Developer');
+
+INSERT INTO project_roles_permissions (permission_name, role_name, project_id)
+VALUES
+ ('Create Thread', 'Admin', 5),
+ ('Delete Thread', 'Admin', 5);
+
+INSERT INTO project_request (description, status, user_id, project_id)
+VALUES
+ ('Request to join Project 1', 'PENDING', 2, 5),
+ ('Request to join Project 1', 'ACCEPTED', 4, 5);
+
+INSERT INTO report (created_at, description, status, thread_id, for_user_id, by_user_id)
+VALUES
+ (NOW(), 'Inappropriate content', 'PENDING', 3, 2, 1),
+ (NOW(), 'Spam content', 'DENIED', 6, 4, 3);
+
+INSERT INTO channel (name, description, project_id, developer_id)
+VALUES
+ ('General', 'General discussion channel', 5, 2),
+ ('Updates', 'Project updates channel', 5, 3);
+
+INSERT INTO messages (sent_at, content, sent_by, project_id, channel_name)
+VALUES
+ (NOW(), 'Hello, team!', 2, 5, 'General'),
+ (NOW(), 'We need to push the deadline.', 3, 5, 'Updates');
Index: docs/versioning/er_models/ER_BUILD_BOARD_v1.xml
===================================================================
--- docs/versioning/er_models/ER_BUILD_BOARD_v1.xml (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
+++ docs/versioning/er_models/ER_BUILD_BOARD_v1.xml (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
@@ -0,0 +1,1 @@
+THREADtrue16dPROJECT_THREADTOPIC_THREADDOUBLE3DISCUSSION_THREADDOUBLE3CONTAINS3NBELONGS_TONUSER33true16oDEVELOPERINVLOVLED_IN3NPROJECT_MANAGERtrue16oIS_OWNED_BY3N33NPERMISSIONSHASNHASNCREATESDOUBLE3CUSTOM_ROLEM3M3NDOUBLE3CONTAINS3NDOUBLE3CONTAINSDOUBLE3CHANNEL3NIS_CREATED_BY3NIS_CREATED_BY3NMODERATORtrue16oIS_MODERATED_BY3NREPLIES3trueRole_nametruetruePermission_nameDescriptiontruetrueusernamepasswordtruetrueTittleDescriptionHAS_WORKED_INNMregister_datestarted_atSTARTS_ANProject_nametruetrueproject_id3truechannel_nameSEND_A_MESSAGE_INMMsg_txtstrted_involvmnet_atended_involmentPStrted_involvmnet_attruetrueVersionVersion ako menvmime neshto za nekoja permisija tie sho nemat videno da ne se ostheteniTextAt_timeTAGCREATESDescASSISGNED_TONNtruetrueNamedescriptionLIKEDNMLogobackgroundlogois_activedescstatus3Ncreated_atlogosexshort_descBLACKLISTSPcommunity_guidelineQ3truereport_idDOUBLE3REPORTDOUBLE3SUBBMITTEDDOUBLE3ABOUT3M3NDOUBLE3FOR_MISCONDUCT3P
Index: docs/versioning/er_models/ER_BUILD_BOARD_v2.xml
===================================================================
--- docs/versioning/er_models/ER_BUILD_BOARD_v2.xml (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
+++ docs/versioning/er_models/ER_BUILD_BOARD_v2.xml (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
@@ -0,0 +1,1 @@
+DOUBLE3RECIEVESPROJECT_THREADIS_MODERATED_BYTOPIC_THREAD3NStarted_atDOUBLE3SUBMITSUSERTHREADtrue16dBELONGS_TON33DEVELOPERtrue16oPROJECT_OWNERPERMISSIONSDEFINED_BYNDOUBLE3CUSTOM_ROLE3MDOUBLE3VALID_IN3NDOUBLE3HASDOUBLE3CHANNEL3NCONSTRUCTS3NIS_CREATED_BY3NMODERATORREPLIES3trueNametruetrueNametruetrueUsernamePasswordContentASSOCIATED_WITHNMRegister_date3trueNameSENDS_MESSAGE_INNMsg_txtStarted_involvment_atEnded_involment_atTimestampTAGCREATESASSISGNED_TONtruetrueNameDescriptionLIKESNIs_activeDescriptionStatus3NCreated_atSexDescriptionGuidelines3trueIdDOUBLE3REPORTDOUBLE3SUBBMITTED_BYDOUBLE3ABOUT3M3NDOUBLE3FOR_MISCONDUCTtruetrueIdDOUBLE3PROJECT_REQUEST3P3trueId3NStatusDescriptionNext_discussion_idReasonIS_ASSIGNEDMPCONTAINSDISCUSSION_THREAD3PRIS_CHILD_TOTitleTitleP3NMRepo_urlDOUBLE3BLACKLISTED_USERDOUBLE3BLACKLISTED_BYDOUBLE3REFERS_TODOUBLE3BLACKLISTED_FROM3N3trueStart_dateEnd_date3N3NQtruetrueId
Index: mvnw
===================================================================
--- mvnw (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
+++ mvnw (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
@@ -0,0 +1,259 @@
+#!/bin/sh
+# ----------------------------------------------------------------------------
+# Licensed to the Apache Software Foundation (ASF) under one
+# or more contributor license agreements. See the NOTICE file
+# distributed with this work for additional information
+# regarding copyright ownership. The ASF licenses this file
+# to you under the Apache License, Version 2.0 (the
+# "License"); you may not use this file except in compliance
+# with the License. You may obtain a copy of the License at
+#
+# http://www.apache.org/licenses/LICENSE-2.0
+#
+# Unless required by applicable law or agreed to in writing,
+# software distributed under the License is distributed on an
+# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+# KIND, either express or implied. See the License for the
+# specific language governing permissions and limitations
+# under the License.
+# ----------------------------------------------------------------------------
+
+# ----------------------------------------------------------------------------
+# Apache Maven Wrapper startup batch script, version 3.3.2
+#
+# Optional ENV vars
+# -----------------
+# JAVA_HOME - location of a JDK home dir, required when download maven via java source
+# MVNW_REPOURL - repo url base for downloading maven distribution
+# MVNW_USERNAME/MVNW_PASSWORD - user and password for downloading maven
+# MVNW_VERBOSE - true: enable verbose log; debug: trace the mvnw script; others: silence the output
+# ----------------------------------------------------------------------------
+
+set -euf
+[ "${MVNW_VERBOSE-}" != debug ] || set -x
+
+# OS specific support.
+native_path() { printf %s\\n "$1"; }
+case "$(uname)" in
+CYGWIN* | MINGW*)
+ [ -z "${JAVA_HOME-}" ] || JAVA_HOME="$(cygpath --unix "$JAVA_HOME")"
+ native_path() { cygpath --path --windows "$1"; }
+ ;;
+esac
+
+# set JAVACMD and JAVACCMD
+set_java_home() {
+ # For Cygwin and MinGW, ensure paths are in Unix format before anything is touched
+ if [ -n "${JAVA_HOME-}" ]; then
+ if [ -x "$JAVA_HOME/jre/sh/java" ]; then
+ # IBM's JDK on AIX uses strange locations for the executables
+ JAVACMD="$JAVA_HOME/jre/sh/java"
+ JAVACCMD="$JAVA_HOME/jre/sh/javac"
+ else
+ JAVACMD="$JAVA_HOME/bin/java"
+ JAVACCMD="$JAVA_HOME/bin/javac"
+
+ if [ ! -x "$JAVACMD" ] || [ ! -x "$JAVACCMD" ]; then
+ echo "The JAVA_HOME environment variable is not defined correctly, so mvnw cannot run." >&2
+ echo "JAVA_HOME is set to \"$JAVA_HOME\", but \"\$JAVA_HOME/bin/java\" or \"\$JAVA_HOME/bin/javac\" does not exist." >&2
+ return 1
+ fi
+ fi
+ else
+ JAVACMD="$(
+ 'set' +e
+ 'unset' -f command 2>/dev/null
+ 'command' -v java
+ )" || :
+ JAVACCMD="$(
+ 'set' +e
+ 'unset' -f command 2>/dev/null
+ 'command' -v javac
+ )" || :
+
+ if [ ! -x "${JAVACMD-}" ] || [ ! -x "${JAVACCMD-}" ]; then
+ echo "The java/javac command does not exist in PATH nor is JAVA_HOME set, so mvnw cannot run." >&2
+ return 1
+ fi
+ fi
+}
+
+# hash string like Java String::hashCode
+hash_string() {
+ str="${1:-}" h=0
+ while [ -n "$str" ]; do
+ char="${str%"${str#?}"}"
+ h=$(((h * 31 + $(LC_CTYPE=C printf %d "'$char")) % 4294967296))
+ str="${str#?}"
+ done
+ printf %x\\n $h
+}
+
+verbose() { :; }
+[ "${MVNW_VERBOSE-}" != true ] || verbose() { printf %s\\n "${1-}"; }
+
+die() {
+ printf %s\\n "$1" >&2
+ exit 1
+}
+
+trim() {
+ # MWRAPPER-139:
+ # Trims trailing and leading whitespace, carriage returns, tabs, and linefeeds.
+ # Needed for removing poorly interpreted newline sequences when running in more
+ # exotic environments such as mingw bash on Windows.
+ printf "%s" "${1}" | tr -d '[:space:]'
+}
+
+# parse distributionUrl and optional distributionSha256Sum, requires .mvn/wrapper/maven-wrapper.properties
+while IFS="=" read -r key value; do
+ case "${key-}" in
+ distributionUrl) distributionUrl=$(trim "${value-}") ;;
+ distributionSha256Sum) distributionSha256Sum=$(trim "${value-}") ;;
+ esac
+done <"${0%/*}/.mvn/wrapper/maven-wrapper.properties"
+[ -n "${distributionUrl-}" ] || die "cannot read distributionUrl property in ${0%/*}/.mvn/wrapper/maven-wrapper.properties"
+
+case "${distributionUrl##*/}" in
+maven-mvnd-*bin.*)
+ MVN_CMD=mvnd.sh _MVNW_REPO_PATTERN=/maven/mvnd/
+ case "${PROCESSOR_ARCHITECTURE-}${PROCESSOR_ARCHITEW6432-}:$(uname -a)" in
+ *AMD64:CYGWIN* | *AMD64:MINGW*) distributionPlatform=windows-amd64 ;;
+ :Darwin*x86_64) distributionPlatform=darwin-amd64 ;;
+ :Darwin*arm64) distributionPlatform=darwin-aarch64 ;;
+ :Linux*x86_64*) distributionPlatform=linux-amd64 ;;
+ *)
+ echo "Cannot detect native platform for mvnd on $(uname)-$(uname -m), use pure java version" >&2
+ distributionPlatform=linux-amd64
+ ;;
+ esac
+ distributionUrl="${distributionUrl%-bin.*}-$distributionPlatform.zip"
+ ;;
+maven-mvnd-*) MVN_CMD=mvnd.sh _MVNW_REPO_PATTERN=/maven/mvnd/ ;;
+*) MVN_CMD="mvn${0##*/mvnw}" _MVNW_REPO_PATTERN=/org/apache/maven/ ;;
+esac
+
+# apply MVNW_REPOURL and calculate MAVEN_HOME
+# maven home pattern: ~/.m2/wrapper/dists/{apache-maven-,maven-mvnd--}/
+[ -z "${MVNW_REPOURL-}" ] || distributionUrl="$MVNW_REPOURL$_MVNW_REPO_PATTERN${distributionUrl#*"$_MVNW_REPO_PATTERN"}"
+distributionUrlName="${distributionUrl##*/}"
+distributionUrlNameMain="${distributionUrlName%.*}"
+distributionUrlNameMain="${distributionUrlNameMain%-bin}"
+MAVEN_USER_HOME="${MAVEN_USER_HOME:-${HOME}/.m2}"
+MAVEN_HOME="${MAVEN_USER_HOME}/wrapper/dists/${distributionUrlNameMain-}/$(hash_string "$distributionUrl")"
+
+exec_maven() {
+ unset MVNW_VERBOSE MVNW_USERNAME MVNW_PASSWORD MVNW_REPOURL || :
+ exec "$MAVEN_HOME/bin/$MVN_CMD" "$@" || die "cannot exec $MAVEN_HOME/bin/$MVN_CMD"
+}
+
+if [ -d "$MAVEN_HOME" ]; then
+ verbose "found existing MAVEN_HOME at $MAVEN_HOME"
+ exec_maven "$@"
+fi
+
+case "${distributionUrl-}" in
+*?-bin.zip | *?maven-mvnd-?*-?*.zip) ;;
+*) die "distributionUrl is not valid, must match *-bin.zip or maven-mvnd-*.zip, but found '${distributionUrl-}'" ;;
+esac
+
+# prepare tmp dir
+if TMP_DOWNLOAD_DIR="$(mktemp -d)" && [ -d "$TMP_DOWNLOAD_DIR" ]; then
+ clean() { rm -rf -- "$TMP_DOWNLOAD_DIR"; }
+ trap clean HUP INT TERM EXIT
+else
+ die "cannot create temp dir"
+fi
+
+mkdir -p -- "${MAVEN_HOME%/*}"
+
+# Download and Install Apache Maven
+verbose "Couldn't find MAVEN_HOME, downloading and installing it ..."
+verbose "Downloading from: $distributionUrl"
+verbose "Downloading to: $TMP_DOWNLOAD_DIR/$distributionUrlName"
+
+# select .zip or .tar.gz
+if ! command -v unzip >/dev/null; then
+ distributionUrl="${distributionUrl%.zip}.tar.gz"
+ distributionUrlName="${distributionUrl##*/}"
+fi
+
+# verbose opt
+__MVNW_QUIET_WGET=--quiet __MVNW_QUIET_CURL=--silent __MVNW_QUIET_UNZIP=-q __MVNW_QUIET_TAR=''
+[ "${MVNW_VERBOSE-}" != true ] || __MVNW_QUIET_WGET='' __MVNW_QUIET_CURL='' __MVNW_QUIET_UNZIP='' __MVNW_QUIET_TAR=v
+
+# normalize http auth
+case "${MVNW_PASSWORD:+has-password}" in
+'') MVNW_USERNAME='' MVNW_PASSWORD='' ;;
+has-password) [ -n "${MVNW_USERNAME-}" ] || MVNW_USERNAME='' MVNW_PASSWORD='' ;;
+esac
+
+if [ -z "${MVNW_USERNAME-}" ] && command -v wget >/dev/null; then
+ verbose "Found wget ... using wget"
+ wget ${__MVNW_QUIET_WGET:+"$__MVNW_QUIET_WGET"} "$distributionUrl" -O "$TMP_DOWNLOAD_DIR/$distributionUrlName" || die "wget: Failed to fetch $distributionUrl"
+elif [ -z "${MVNW_USERNAME-}" ] && command -v curl >/dev/null; then
+ verbose "Found curl ... using curl"
+ curl ${__MVNW_QUIET_CURL:+"$__MVNW_QUIET_CURL"} -f -L -o "$TMP_DOWNLOAD_DIR/$distributionUrlName" "$distributionUrl" || die "curl: Failed to fetch $distributionUrl"
+elif set_java_home; then
+ verbose "Falling back to use Java to download"
+ javaSource="$TMP_DOWNLOAD_DIR/Downloader.java"
+ targetZip="$TMP_DOWNLOAD_DIR/$distributionUrlName"
+ cat >"$javaSource" <<-END
+ public class Downloader extends java.net.Authenticator
+ {
+ protected java.net.PasswordAuthentication getPasswordAuthentication()
+ {
+ return new java.net.PasswordAuthentication( System.getenv( "MVNW_USERNAME" ), System.getenv( "MVNW_PASSWORD" ).toCharArray() );
+ }
+ public static void main( String[] args ) throws Exception
+ {
+ setDefault( new Downloader() );
+ java.nio.file.Files.copy( java.net.URI.create( args[0] ).toURL().openStream(), java.nio.file.Paths.get( args[1] ).toAbsolutePath().normalize() );
+ }
+ }
+ END
+ # For Cygwin/MinGW, switch paths to Windows format before running javac and java
+ verbose " - Compiling Downloader.java ..."
+ "$(native_path "$JAVACCMD")" "$(native_path "$javaSource")" || die "Failed to compile Downloader.java"
+ verbose " - Running Downloader.java ..."
+ "$(native_path "$JAVACMD")" -cp "$(native_path "$TMP_DOWNLOAD_DIR")" Downloader "$distributionUrl" "$(native_path "$targetZip")"
+fi
+
+# If specified, validate the SHA-256 sum of the Maven distribution zip file
+if [ -n "${distributionSha256Sum-}" ]; then
+ distributionSha256Result=false
+ if [ "$MVN_CMD" = mvnd.sh ]; then
+ echo "Checksum validation is not supported for maven-mvnd." >&2
+ echo "Please disable validation by removing 'distributionSha256Sum' from your maven-wrapper.properties." >&2
+ exit 1
+ elif command -v sha256sum >/dev/null; then
+ if echo "$distributionSha256Sum $TMP_DOWNLOAD_DIR/$distributionUrlName" | sha256sum -c >/dev/null 2>&1; then
+ distributionSha256Result=true
+ fi
+ elif command -v shasum >/dev/null; then
+ if echo "$distributionSha256Sum $TMP_DOWNLOAD_DIR/$distributionUrlName" | shasum -a 256 -c >/dev/null 2>&1; then
+ distributionSha256Result=true
+ fi
+ else
+ echo "Checksum validation was requested but neither 'sha256sum' or 'shasum' are available." >&2
+ echo "Please install either command, or disable validation by removing 'distributionSha256Sum' from your maven-wrapper.properties." >&2
+ exit 1
+ fi
+ if [ $distributionSha256Result = false ]; then
+ echo "Error: Failed to validate Maven distribution SHA-256, your Maven distribution might be compromised." >&2
+ echo "If you updated your Maven version, you need to update the specified distributionSha256Sum property." >&2
+ exit 1
+ fi
+fi
+
+# unzip and move
+if command -v unzip >/dev/null; then
+ unzip ${__MVNW_QUIET_UNZIP:+"$__MVNW_QUIET_UNZIP"} "$TMP_DOWNLOAD_DIR/$distributionUrlName" -d "$TMP_DOWNLOAD_DIR" || die "failed to unzip"
+else
+ tar xzf${__MVNW_QUIET_TAR:+"$__MVNW_QUIET_TAR"} "$TMP_DOWNLOAD_DIR/$distributionUrlName" -C "$TMP_DOWNLOAD_DIR" || die "failed to untar"
+fi
+printf %s\\n "$distributionUrl" >"$TMP_DOWNLOAD_DIR/$distributionUrlNameMain/mvnw.url"
+mv -- "$TMP_DOWNLOAD_DIR/$distributionUrlNameMain" "$MAVEN_HOME" || [ -d "$MAVEN_HOME" ] || die "fail to move MAVEN_HOME"
+
+clean || :
+exec_maven "$@"
Index: pom.xml
===================================================================
--- pom.xml (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
+++ pom.xml (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
@@ -0,0 +1,102 @@
+
+
+ 4.0.0
+
+ org.springframework.boot
+ spring-boot-starter-parent
+ 3.4.1
+
+
+ com.db.finki.www
+ build_board
+ 0.0.1-SNAPSHOT
+
+ 17
+
+
+
+ org.springframework.boot
+ spring-boot-starter-thymeleaf
+
+
+
+
+
+
+
+
+
+ org.springframework.boot
+ spring-boot-starter-security
+
+
+
+
+ org.springframework.boot
+ spring-boot-starter-web
+
+
+ org.springframework.boot
+ spring-boot-devtools
+ runtime
+ true
+
+
+ org.projectlombok
+ lombok
+ true
+
+
+ org.springframework.boot
+ spring-boot-starter-test
+ test
+
+
+ org.flywaydb
+ flyway-core
+
+
+ org.springframework.boot
+ spring-boot-starter-data-jpa
+
+
+ org.flywaydb
+ flyway-database-postgresql
+
+
+ org.postgresql
+ postgresql
+ 42.7.4
+
+
+
+
+
+ org.apache.maven.plugins
+ maven-compiler-plugin
+
+
+
+ org.projectlombok
+ lombok
+
+
+
+
+
+ org.springframework.boot
+ spring-boot-maven-plugin
+
+
+
+ org.projectlombok
+ lombok
+
+
+
+
+
+
+
+
Index: src/main/java/com/db/finki/www/build_board/DemoApplication.java
===================================================================
--- src/main/java/com/db/finki/www/build_board/DemoApplication.java (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
+++ src/main/java/com/db/finki/www/build_board/DemoApplication.java (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
@@ -0,0 +1,21 @@
+package com.db.finki.www.build_board;
+
+import org.springframework.boot.SpringApplication;
+import org.springframework.boot.autoconfigure.SpringBootApplication;
+import org.springframework.context.annotation.Bean;
+import org.springframework.security.crypto.bcrypt.BCryptPasswordEncoder;
+import org.springframework.security.crypto.password.PasswordEncoder;
+
+@SpringBootApplication
+public class DemoApplication {
+
+ public static void main(String[] args) {
+ SpringApplication.run(DemoApplication.class, args);
+ }
+
+ @Bean
+ PasswordEncoder passwordEncoder() {
+ return new BCryptPasswordEncoder(12);
+ }
+
+}
Index: src/main/java/com/db/finki/www/build_board/config/BeanConfig.java
===================================================================
--- src/main/java/com/db/finki/www/build_board/config/BeanConfig.java (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
+++ src/main/java/com/db/finki/www/build_board/config/BeanConfig.java (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
@@ -0,0 +1,14 @@
+package com.db.finki.www.build_board.config;
+
+import com.db.finki.www.build_board.service.AuthenticationSuccessHandlerImpl;
+import org.springframework.context.annotation.Bean;
+import org.springframework.context.annotation.Configuration;
+import org.springframework.security.web.authentication.AuthenticationSuccessHandler;
+
+@Configuration
+public class BeanConfig {
+ @Bean
+ public AuthenticationSuccessHandler authenticationSuccessHandler() {
+ return new AuthenticationSuccessHandlerImpl();
+ }
+}
Index: src/main/java/com/db/finki/www/build_board/config/WebSecurityConfig.java
===================================================================
--- src/main/java/com/db/finki/www/build_board/config/WebSecurityConfig.java (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
+++ src/main/java/com/db/finki/www/build_board/config/WebSecurityConfig.java (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
@@ -0,0 +1,72 @@
+package com.db.finki.www.build_board.config;
+
+import com.db.finki.www.build_board.entity.BBUser;
+import com.db.finki.www.build_board.service.AuthenticationSuccessHandlerImpl;
+import jakarta.servlet.ServletException;
+import jakarta.servlet.http.HttpServletRequest;
+import jakarta.servlet.http.HttpServletResponse;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.context.annotation.Bean;
+import org.springframework.context.annotation.Configuration;
+import org.springframework.security.authentication.AuthenticationManager;
+import org.springframework.security.authentication.AuthenticationProvider;
+import org.springframework.security.authentication.dao.DaoAuthenticationProvider;
+import org.springframework.security.config.Customizer;
+import org.springframework.security.config.annotation.authentication.configuration.AuthenticationConfiguration;
+import org.springframework.security.config.annotation.web.builders.HttpSecurity;
+import org.springframework.security.config.annotation.web.configuration.EnableWebSecurity;
+import org.springframework.security.config.annotation.web.configurers.AbstractHttpConfigurer;
+import org.springframework.security.core.Authentication;
+import org.springframework.security.core.userdetails.UserDetailsService;
+import org.springframework.security.crypto.bcrypt.BCryptPasswordEncoder;
+import org.springframework.security.crypto.password.PasswordEncoder;
+import org.springframework.security.web.SecurityFilterChain;
+import org.springframework.security.web.authentication.AuthenticationSuccessHandler;
+
+import java.io.IOException;
+
+@Configuration
+@EnableWebSecurity
+public class WebSecurityConfig {
+
+ private final PasswordEncoder passwordEncoder;
+ private final UserDetailsService userDetailsService;
+ private final AuthenticationSuccessHandler successHandler;
+
+
+ public WebSecurityConfig(PasswordEncoder passwordEncoder, UserDetailsService userDetailsService, AuthenticationSuccessHandler successHandler) {
+ this.passwordEncoder = passwordEncoder;
+ this.userDetailsService = userDetailsService;
+ this.successHandler = successHandler;
+ }
+
+ @Bean
+ public SecurityFilterChain securityFilterChain(HttpSecurity http) throws Exception {
+ http
+ .csrf(AbstractHttpConfigurer::disable)
+ .authorizeHttpRequests(request ->
+ request
+ .anyRequest().authenticated()
+ ).formLogin(formLogin ->
+ formLogin.permitAll()
+ .defaultSuccessUrl("/")
+ .successHandler(successHandler)
+ );
+
+ return http.build();
+
+ }
+
+ @Bean
+ public AuthenticationProvider authenticationProvider() {
+ DaoAuthenticationProvider daoAuthenticationProvider = new DaoAuthenticationProvider();
+ daoAuthenticationProvider.setPasswordEncoder(passwordEncoder);
+ daoAuthenticationProvider.setUserDetailsService(userDetailsService);
+ return daoAuthenticationProvider;
+ }
+
+ @Bean
+ public AuthenticationManager authenticationManager(AuthenticationConfiguration config) throws Exception {
+ return config.getAuthenticationManager();
+ }
+}
Index: src/main/java/com/db/finki/www/build_board/controller/HomePageController.java
===================================================================
--- src/main/java/com/db/finki/www/build_board/controller/HomePageController.java (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
+++ src/main/java/com/db/finki/www/build_board/controller/HomePageController.java (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
@@ -0,0 +1,14 @@
+package com.db.finki.www.build_board.controller;
+
+import org.springframework.stereotype.Controller;
+import org.springframework.web.bind.annotation.GetMapping;
+import org.springframework.web.bind.annotation.RequestMapping;
+
+@Controller
+@RequestMapping("/")
+public class HomePageController {
+ @GetMapping
+ public String homePage() {
+ return "home";
+ }
+}
Index: src/main/java/com/db/finki/www/build_board/controller/LoginPageController.java
===================================================================
--- src/main/java/com/db/finki/www/build_board/controller/LoginPageController.java (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
+++ src/main/java/com/db/finki/www/build_board/controller/LoginPageController.java (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
@@ -0,0 +1,20 @@
+package com.db.finki.www.build_board.controller;
+
+import jakarta.servlet.http.HttpServletRequest;
+import org.springframework.stereotype.Controller;
+import org.springframework.ui.Model;
+import org.springframework.web.bind.annotation.GetMapping;
+import org.springframework.web.bind.annotation.PostMapping;
+import org.springframework.web.bind.annotation.RequestParam;
+
+@Controller
+public class LoginPageController {
+ @GetMapping("/login")
+ public String getLoginPage() {
+ return "login";
+ }
+ @PostMapping("/login")
+ public String login(@RequestParam String username, @RequestParam String password, Model model, HttpServletRequest request) {
+ return "redirect:/";
+ }
+}
Index: src/main/java/com/db/finki/www/build_board/entity/BBUser.java
===================================================================
--- src/main/java/com/db/finki/www/build_board/entity/BBUser.java (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
+++ src/main/java/com/db/finki/www/build_board/entity/BBUser.java (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
@@ -0,0 +1,48 @@
+package com.db.finki.www.build_board.entity;
+
+import jakarta.persistence.*;
+import lombok.Getter;
+import lombok.Setter;
+import org.springframework.security.core.GrantedAuthority;
+import org.springframework.security.core.userdetails.UserDetails;
+
+import java.io.Serializable;
+import java.time.LocalDateTime;
+import java.util.Collection;
+import java.util.List;
+@Entity
+@Table(name = "users")
+@Getter @Setter
+public class BBUser implements UserDetails, Serializable {
+
+ @Id
+ @GeneratedValue(strategy = GenerationType.IDENTITY)
+ private int id;
+ private String username;
+ private String password;
+ private String description;
+ @Column(name = "registered_at")
+ private LocalDateTime registeredAt;
+ @Column(name = "is_activate")
+ private boolean isEnabled;
+ private String sex;
+
+ @Override
+ public boolean isEnabled() {
+ return isEnabled;
+ }
+
+ @Override
+ public String getUsername() {
+ return username;
+ }
+ @Override
+ public String getPassword() {
+ return password;
+ }
+ @Override
+ public Collection getAuthorities() {
+ return List.of();
+ }
+
+}
Index: src/main/java/com/db/finki/www/build_board/repository/UserRepository.java
===================================================================
--- src/main/java/com/db/finki/www/build_board/repository/UserRepository.java (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
+++ src/main/java/com/db/finki/www/build_board/repository/UserRepository.java (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
@@ -0,0 +1,12 @@
+package com.db.finki.www.build_board.repository;
+
+import com.db.finki.www.build_board.entity.BBUser;
+import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.stereotype.Repository;
+
+import java.util.Optional;
+
+@Repository
+public interface UserRepository extends JpaRepository {
+ Optional findByUsername(String username);
+}
Index: src/main/java/com/db/finki/www/build_board/service/AuthenticationSuccessHandlerImpl.java
===================================================================
--- src/main/java/com/db/finki/www/build_board/service/AuthenticationSuccessHandlerImpl.java (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
+++ src/main/java/com/db/finki/www/build_board/service/AuthenticationSuccessHandlerImpl.java (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
@@ -0,0 +1,25 @@
+package com.db.finki.www.build_board.service;
+
+import com.db.finki.www.build_board.entity.BBUser;
+import jakarta.servlet.ServletException;
+import jakarta.servlet.http.HttpServletRequest;
+import jakarta.servlet.http.HttpServletResponse;
+import jakarta.servlet.http.HttpSession;
+import org.springframework.context.annotation.Primary;
+import org.springframework.security.core.Authentication;
+import org.springframework.security.web.authentication.AuthenticationSuccessHandler;
+import org.springframework.stereotype.Component;
+
+import java.io.IOException;
+
+public class AuthenticationSuccessHandlerImpl implements AuthenticationSuccessHandler {
+ @Override
+ public void onAuthenticationSuccess(HttpServletRequest request, HttpServletResponse response, Authentication authentication) throws IOException, ServletException {
+ BBUser user = (BBUser) authentication.getPrincipal();
+ HttpSession session = request.getSession();
+ session.setAttribute("user", user);
+ session.setMaxInactiveInterval(1800);
+ response.sendRedirect("/");
+ }
+
+}
Index: src/main/java/com/db/finki/www/build_board/service/BBUserDetailsService.java
===================================================================
--- src/main/java/com/db/finki/www/build_board/service/BBUserDetailsService.java (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
+++ src/main/java/com/db/finki/www/build_board/service/BBUserDetailsService.java (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
@@ -0,0 +1,21 @@
+package com.db.finki.www.build_board.service;
+
+import com.db.finki.www.build_board.repository.UserRepository;
+import org.springframework.security.core.userdetails.UserDetails;
+import org.springframework.security.core.userdetails.UserDetailsService;
+import org.springframework.security.core.userdetails.UsernameNotFoundException;
+import org.springframework.stereotype.Service;
+
+@Service
+public class BBUserDetailsService implements UserDetailsService {
+ private final UserRepository userRepository;
+
+ public BBUserDetailsService(UserRepository userRepository) {
+ this.userRepository = userRepository;
+ }
+
+ @Override
+ public UserDetails loadUserByUsername(String username) throws UsernameNotFoundException {
+ return userRepository.findByUsername(username).orElseThrow(() -> new UsernameNotFoundException("User not found with username: " + username));
+ }
+}
Index: src/main/java/com/db/finki/www/build_board/service/UserService.java
===================================================================
--- src/main/java/com/db/finki/www/build_board/service/UserService.java (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
+++ src/main/java/com/db/finki/www/build_board/service/UserService.java (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
@@ -0,0 +1,7 @@
+package com.db.finki.www.build_board.service;
+
+import com.db.finki.www.build_board.entity.BBUser;
+
+public interface UserService {
+ BBUser verifyCredentials(String username, String password);
+}
Index: src/main/resources/application.properties
===================================================================
--- src/main/resources/application.properties (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
+++ src/main/resources/application.properties (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
@@ -0,0 +1,8 @@
+spring.application.name=build_board
+
+spring.datasource.username=${POSTGRES_USER}
+spring.datasource.password=${POSTGRES_PASSWORD}
+spring.datasource.url=jdbc:postgresql://localhost:5432/${POSTGRES_DB}
+
+spring.flyway.password=${POSTGRES_PASSWORD}
+spring.flyway.user=${POSTGRES_USER}
Index: src/main/resources/db/migration/V1__init_ddl.sql
===================================================================
--- src/main/resources/db/migration/V1__init_ddl.sql (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
+++ src/main/resources/db/migration/V1__init_ddl.sql (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
@@ -0,0 +1,151 @@
+create table users(
+ username varchar(32) primary key,
+ is_activate bool,
+ password varchar(72),
+ description varchar(200),
+ registered_at timestamp,
+ sex varchar(1)
+);
+
+create table moderator() inherits (users);
+create table developer() inherits (users);
+create table project_manager() inherits (users);
+
+create table thread (
+ id serial primary key,
+ description text,
+ logo_url text,
+ title varchar(32),
+ username varchar(32) references users(username)
+);
+
+create table likes(
+ username varchar(32) references users(username),
+ thread_id int references thread(id),
+ primary key(username, thread_id)
+);
+
+create table threads_moderators(
+ thread_id int references thread(id) on delete cascade,
+ username varchar(32) references users(username) on delete cascade,
+ primary key(thread_id, username)
+);
+
+create table tag(
+ name varchar(64) primary key
+);
+
+create table tag_threads(
+ thread_id int references thread(id),
+ tag_name varchar(64) references tag(name),
+ primary key(thread_id, tag_name)
+);
+
+create table topic_thread (
+ guidelines jsonb,
+ next_discussion_id int
+) inherits (thread);
+
+create table topic_belongs_to_project(
+ topic_id int references thread(id) on delete cascade,
+ project_id int references thread(id) on delete cascade,
+ primary key(topic_id,project_id)
+);
+
+create table topic_blacklist(
+ username varchar(32) references users(username) on delete cascade,
+ project_id varchar(32) references users(username) on delete cascade,
+ primary key(username,project_id)
+);
+
+create table project_thread (
+ repo_url text
+) inherits (thread);
+
+create table discussion_thread(
+ text text,
+ id int,
+ topic_id int not null references thread(id),
+ created_by_user varchar(32) not null references users(username),
+ reply_discussion int,
+ reply_topic_id int,
+ primary key(topic_id, id),
+ check ((reply_discussion is null) and (topic_id = reply_topic_id))
+);
+
+create table developer_associated_with_project(
+ project_id int references thread(id),
+ developer varchar(32) references users(username),
+ started_at timestamp,
+ ended_at timestamp,
+ primary key(project_id, developer, started_at)
+);
+
+create table permissions(
+ name varchar(32) primary key
+);
+
+create table project_roles(
+ name varchar(32),
+ project_id int references thread(id) on delete cascade,
+ description text not null,
+ primary key(name, project_id)
+);
+
+create table users_project_roles(
+ username varchar(32) references users(username),
+ project_id int,
+ role_name varchar(32),
+ FOREIGN KEY (role_name, project_id)
+ REFERENCES project_roles(name, project_id),
+ primary key(username, project_id, role_name)
+);
+
+create table project_roles_permissions(
+ permission_name varchar(32) references permissions(name),
+ role_name varchar(32),
+ project_id int,
+ primary key(permission_name, role_name, project_id),
+ FOREIGN KEY (role_name, project_id)
+ REFERENCES project_roles(name, project_id)
+);
+
+CREATE TYPE status AS ENUM ('ACCEPTED', 'DENIED', 'PENDING');
+
+create table project_request(
+ id serial primary key,
+ reason varchar (200),
+ status status,
+ submited_by_user varchar(32) references users(username) not null,
+ for_project int references thread(id) not null
+);
+
+create table report(
+ id serial primary key,
+ created_at timestamp,
+ description varchar(200),
+ status status,
+ thread_id int references thread(id) not null,
+ for_user varchar(32) references users(username) not null,
+ by_user varchar(32) references users(username) not null
+);
+
+create table channel (
+ name varchar (64),
+ description varchar(200),
+ logo_url text,
+ project_id int references thread(id) on delete cascade,
+ developer varchar(32) references users(username),
+ primary key(name, project_id)
+);
+
+create table messages (
+ sent_at timestamp,
+ content varchar(200),
+ sent_by varchar(32) references users(username) not null,
+ project_id int,
+ channel_name varchar(64),
+ FOREIGN KEY (channel_name, project_id)
+ REFERENCES channel(name, project_id) on delete cascade,
+ primary key(channel_name, project_id, sent_at, sent_by)
+);
Index: src/main/resources/db/migration/V2__init_ddl-corrected.sql
===================================================================
--- src/main/resources/db/migration/V2__init_ddl-corrected.sql (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
+++ src/main/resources/db/migration/V2__init_ddl-corrected.sql (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
@@ -0,0 +1,264 @@
+--- Trigger before update/insert za check na iminjata topic/discussion -> OK
+--- Trigger za ko ke adnit dete na topic thread sho e vo proekt, da go dodajt kako belongs_to vo proektot
+--- Trigger za check dali reply na discussion thread pripagjat na ist topic thread kako na toj so mu pret reply
+
+
+--- IMENUVANJE: triggeri so provervat nesto prefix = check, funkcii za istite prefix = validate\
+
+
+
+-- DROP TABLES
+DROP TABLE IF EXISTS users CASCADE;
+DROP TABLE IF EXISTS moderator CASCADE;
+DROP TABLE IF EXISTS developer CASCADE;
+DROP TABLE IF EXISTS project_manager CASCADE;
+DROP TABLE IF EXISTS thread CASCADE;
+DROP TABLE IF EXISTS likes CASCADE;
+DROP TABLE IF EXISTS topic_threads_moderators CASCADE;
+DROP TABLE IF EXISTS tag CASCADE;
+DROP TABLE IF EXISTS tag_threads CASCADE;
+DROP TABLE IF EXISTS topic_thread CASCADE;
+DROP TABLE IF EXISTS topic_belongs_to_project CASCADE;
+DROP TABLE IF EXISTS topic_blacklist CASCADE;
+DROP TABLE IF EXISTS project_thread CASCADE;
+DROP TABLE IF EXISTS discussion_thread CASCADE;
+DROP TABLE IF EXISTS developer_associated_with_project CASCADE;
+DROP TABLE IF EXISTS permissions CASCADE;
+DROP TABLE IF EXISTS project_roles CASCADE;
+DROP TABLE IF EXISTS users_project_roles CASCADE;
+DROP TABLE IF EXISTS project_roles_permissions CASCADE;
+DROP TABLE IF EXISTS project_request CASCADE;
+DROP TABLE IF EXISTS report CASCADE;
+DROP TABLE IF EXISTS channel CASCADE;
+DROP TABLE IF EXISTS messages CASCADE;
+DROP TABLE IF EXISTS threads_moderators CASCADE;
+drop type if exists status;
+drop function if exists add_child_topic;
+drop function if exists validate_same_parent;
+drop function if exists validate_topic_title;
+
+
+---- DDL
+
+create table users(
+ username varchar(32) primary key,
+ is_activate bool,
+ password varchar(72),
+ description varchar(200),
+ registered_at timestamp,
+ sex varchar(1)
+);
+
+create table moderator() inherits (users);
+create table developer() inherits (users);
+create table project_manager() inherits (users);
+
+create table thread (
+ id serial primary key,
+ content text,
+ username varchar(32) references users(username)
+);
+
+create table likes(
+ username varchar(32) references users(username),
+ thread_id int references thread(id),
+ primary key(username, thread_id)
+);
+
+create table topic_threads_moderators(
+ thread_id int references thread(id) on delete cascade,
+ username varchar(32) references users(username) on delete cascade,
+ primary key(thread_id, username)
+);
+
+create table tag(
+ name varchar(64) primary key
+);
+
+create table tag_threads(
+ thread_id int references thread(id),
+ tag_name varchar(64) references tag(name),
+ primary key(thread_id, tag_name)
+);
+
+create table topic_thread (
+ title varchar(32),
+ guidelines jsonb,
+ next_discussion_id int,
+ parent_topic_id int REFERENCES thread(id)
+) inherits (thread);
+
+create table topic_belongs_to_project(
+ topic_id int references thread(id) on delete cascade,
+ project_id int references thread(id) on delete cascade,
+ primary key(topic_id,project_id)
+);
+
+create table topic_blacklist(
+ topic_id int REFERENCES thread(id) ON DELETE CASCADE,
+ username varchar(32) references users(username) on delete cascade,
+ moderator varchar(32) references users(username) on delete cascade,
+ primary key(username,moderator,topic_id)
+);
+
+create table project_thread (
+ title varchar(32),
+ repo_url text
+) inherits (thread);
+
+create table discussion_thread(
+ created_by_user varchar(32) not null references users(username),
+ reply_discussion_id int REFERENCES thread(id),
+ topic_id int REFERENCES thread(id)
+) inherits(thread);
+
+create table developer_associated_with_project(
+ project_id int references thread(id),
+ developer varchar(32) references users(username),
+ started_at timestamp,
+ ended_at timestamp,
+ primary key(project_id, developer, started_at)
+);
+
+create table permissions(
+ name varchar(32) primary key
+);
+
+create table project_roles(
+ name varchar(32),
+ project_id int references thread(id) on delete cascade,
+ description text not null,
+ primary key(name, project_id)
+);
+
+create table users_project_roles(
+ username varchar(32) references users(username),
+ project_id int,
+ role_name varchar(32),
+ FOREIGN KEY (role_name, project_id)
+ REFERENCES project_roles(name, project_id),
+ primary key(username, project_id, role_name)
+);
+
+create table project_roles_permissions(
+ permission_name varchar(32) references permissions(name),
+ role_name varchar(32),
+ project_id int,
+ primary key(permission_name, role_name, project_id),
+ FOREIGN KEY (role_name, project_id)
+ REFERENCES project_roles(name, project_id)
+);
+
+CREATE TYPE status AS ENUM ('ACCEPTED', 'DENIED', 'PENDING');
+
+create table project_request(
+ id serial primary key,
+ description varchar (200),
+ status status,
+ submited_by_user varchar(32) references users(username) not null,
+ project_id int references thread(id) not null
+);
+
+create table report(
+ id serial primary key,
+ created_at timestamp,
+ description varchar(200),
+ status status,
+ thread_id int references thread(id) not null,
+ for_user varchar(32) references users(username) not null,
+ by_user varchar(32) references users(username) not null
+);
+
+create table channel (
+ name varchar (64),
+ description varchar(200),
+ logo_url text,
+ project_id int references thread(id) on delete cascade,
+ developer varchar(32) references users(username),
+ primary key(name, project_id)
+);
+
+create table messages (
+ sent_at timestamp,
+ content varchar(200),
+ sent_by varchar(32) references users(username) not null,
+ project_id int,
+ channel_name varchar(64),
+ FOREIGN KEY (channel_name, project_id)
+ REFERENCES channel(name, project_id) on delete cascade,
+ primary key(channel_name, project_id, sent_at, sent_by)
+);
+
+
+-------------------------- FUNCTIONS ----------------------
+
+CREATE FUNCTION validate_topic_title()
+ RETURNS trigger
+ LANGUAGE plpgsql
+as $$
+BEGIN
+ IF NEW.title IN
+ (
+ SELECT title
+ FROM topic_thread
+ AS t
+ WHERE t.parent_topic_id = NEW.parent_topic_id)
+ THEN RAISE EXCEPTION 'There already exists a topic with title % in parent topic with id %',NEW.title,NEW.parent_topic_id;
+END IF;
+RETURN NEW;
+END;
+$$;
+
+CREATE FUNCTION add_child_topic()
+ RETURNS TRIGGER
+ LANGUAGE plpgsql
+AS $$
+DECLARE
+project_id INT;
+BEGIN
+SELECT t.project_id
+INTO project_id
+FROM topic_belongs_to_project AS t WHERE NEW.id = t.topic_id;
+INSERT INTO topic_belongs_to_project VALUES (NEW.id,project_id);
+END;
+$$;
+
+CREATE FUNCTION validate_same_parent()
+ RETURNS TRIGGER
+ LANGUAGE plpgsql
+AS $$
+BEGIN
+ IF NOT EXISTS (
+ SELECT 1
+ FROM discussion_thread
+ AS dt
+ WHERE NEW.reply_discussion_id = dt.id AND dt.topic_id = NEW.topic_id
+ ) THEN
+ RAISE EXCEPTION 'Can not reply to a discussion that is not in the same topic';
+END IF;
+RETURN NEW;
+END;
+$$;
+
+
+-------------------------- TRIGGERS ----------------------
+
+CREATE or replace TRIGGER check_topic_name
+ BEFORE INSERT OR UPDATE ON topic_thread
+ FOR EACH ROW
+ EXECUTE FUNCTION validate_topic_title();
+
+CREATE OR REPLACE TRIGGER project_insert_child_topic
+AFTER INSERT ON topic_thread
+FOR EACH ROW
+EXECUTE FUNCTION add_child_topic();
+
+CREATE OR REPLACE TRIGGER check_same_parent
+BEFORE INSERT ON discussion_thread
+FOR EACH ROW
+EXECUTE FUNCTION validate_same_parent();
+
+
+
+
+
Index: src/main/resources/db/migration/V3__init_ddl.sql
===================================================================
--- src/main/resources/db/migration/V3__init_ddl.sql (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
+++ src/main/resources/db/migration/V3__init_ddl.sql (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
@@ -0,0 +1,320 @@
+--- Trigger before update/insert za check na iminjata topic/discussion -> OK
+--- Trigger za ko ke adnit dete na topic thread sho e vo proekt, da go dodajt kako belongs_to vo proektot
+--- Trigger za check dali reply na discussion thread pripagjat na ist topic thread kako na toj so mu pret reply
+--- IMENUVANJE: triggeri so provervat nesto prefix = check, funkcii za istite prefix = validate
+--- Nemame contraint sho velit deka sekoj topic thread trebat da e moderiran
+DROP TABLE IF EXISTS users CASCADE;
+DROP TABLE IF EXISTS moderator CASCADE;
+DROP TABLE IF EXISTS developer CASCADE;
+DROP TABLE IF EXISTS project_manager CASCADE;
+DROP TABLE IF EXISTS thread CASCADE;
+DROP TABLE IF EXISTS likes CASCADE;
+DROP TABLE IF EXISTS topic_threads_moderators CASCADE;
+DROP TABLE IF EXISTS tag CASCADE;
+DROP TABLE IF EXISTS tag_threads CASCADE;
+DROP TABLE IF EXISTS topic_thread CASCADE;
+DROP TABLE IF EXISTS topic_belongs_to_project CASCADE;
+DROP TABLE IF EXISTS blacklisted_user CASCADE;
+DROP TABLE IF EXISTS project_thread CASCADE;
+DROP TABLE IF EXISTS discussion_thread CASCADE;
+DROP TABLE IF EXISTS developer_associated_with_project CASCADE;
+DROP TABLE IF EXISTS permissions CASCADE;
+DROP TABLE IF EXISTS project_roles CASCADE;
+DROP TABLE IF EXISTS users_project_roles CASCADE;
+DROP TABLE IF EXISTS project_roles_permissions CASCADE;
+DROP TABLE IF EXISTS project_request CASCADE;
+DROP TABLE IF EXISTS report CASCADE;
+DROP TABLE IF EXISTS channel CASCADE;
+DROP TABLE IF EXISTS messages CASCADE;
+DROP TABLE IF EXISTS threads_moderators CASCADE;
+DROP TYPE IF EXISTS status;
+DROP VIEW IF EXISTS v_topic_thread CASCADE;
+DROP VIEW IF EXISTS v_project_thread CASCADE;
+DROP VIEW IF EXISTS v_discussion_thread CASCADE;
+DROP VIEW IF EXISTS v_developer CASCADE;
+DROP VIEW IF EXISTS v_project_owner CASCADE;
+DROP VIEW IF EXISTS v_moderator CASCADE;
+drop function if exists fn_insert_project_manager CASCADE;
+drop function if exists fn_insert_topics_creator_as_moderator CASCADE;
+drop function if exists fn_validate_topic_title CASCADE;
+drop function if exists clean_tables CASCADE;
+drop function if exists clean_routines CASCADE;
+DROP TRIGGER IF EXISTS validate_same_parent ON discussion_thread CASCADE;
+---- DDL
+CREATE TABLE users
+(
+ id SERIAL PRIMARY KEY,
+ username VARCHAR(32) UNIQUE NOT NULL,
+ is_activate bool,
+ password VARCHAR(72),
+ description VARCHAR(200),
+ registered_at TIMESTAMP,
+ sex VARCHAR(1)
+);
+CREATE TABLE moderator
+(
+ id INT PRIMARY KEY REFERENCES users (id) on delete cascade
+);
+CREATE TABLE developer
+(
+ id INT PRIMARY KEY REFERENCES users (id) on delete cascade
+);
+CREATE TABLE project_manager
+(
+ id INT PRIMARY KEY REFERENCES users (id) on delete cascade
+);
+CREATE TABLE thread
+(
+ id SERIAL PRIMARY KEY,
+ content TEXT,
+ user_id INT REFERENCES users (id) NOT NULL
+);
+CREATE TABLE topic_thread
+(
+ title VARCHAR(32) NOT NULL,
+ guidelines jsonb,
+ parent_id INT REFERENCES thread (id),
+ id INT PRIMARY KEY REFERENCES thread (id) on delete cascade
+);
+CREATE TABLE discussion_thread
+(
+ parent_id INT REFERENCES thread (id) NOT NULL,
+ id INT PRIMARY KEY REFERENCES thread (id) on delete cascade
+);
+CREATE TABLE project_thread
+(
+ title VARCHAR(32) NOT NULL,
+ repo_url TEXT,
+ id INT PRIMARY KEY REFERENCES thread (id) on delete cascade
+);
+CREATE TABLE likes
+(
+ user_id INT REFERENCES users (id),
+ thread_id INT REFERENCES thread (id),
+ PRIMARY KEY (user_id, thread_id)
+);
+CREATE TABLE topic_threads_moderators
+(
+ thread_id INT REFERENCES thread (id) ON DELETE CASCADE,
+ user_id INT REFERENCES users (id) ON DELETE CASCADE,
+ PRIMARY KEY (thread_id, user_id)
+);
+CREATE TABLE tag
+(
+ name VARCHAR(64) PRIMARY KEY
+);
+CREATE TABLE tag_threads
+(
+ thread_id INT REFERENCES thread (id),
+ tag_name VARCHAR(64) REFERENCES tag (name),
+ PRIMARY KEY (thread_id, tag_name)
+);
+
+CREATE TABLE topic_belongs_to_project
+(
+ topic_id INT REFERENCES thread (id) ON DELETE CASCADE,
+ project_id INT REFERENCES thread (id) ON DELETE CASCADE,
+ PRIMARY KEY (topic_id, project_id)
+);
+CREATE TABLE blacklisted_user
+(
+ topic_id INT REFERENCES thread (id) ON DELETE CASCADE,
+ user_id INT REFERENCES users (id) ON DELETE CASCADE,
+ moderator_id INT REFERENCES users (id) ON DELETE CASCADE,
+ start_date TIMESTAMP,
+ end_date TIMESTAMP,
+ reason TEXT,
+ PRIMARY KEY (user_id, moderator_id, topic_id, start_date)
+);
+
+CREATE TABLE developer_associated_with_project
+(
+ project_id INT REFERENCES thread (id),
+ developer_id INT REFERENCES users (id),
+ started_at TIMESTAMP,
+ ended_at TIMESTAMP,
+ PRIMARY KEY (project_id, developer_id, started_at)
+);
+CREATE TABLE permissions
+(
+ name VARCHAR(32) PRIMARY KEY
+);
+CREATE TABLE project_roles
+(
+ name VARCHAR(32),
+ project_id INT REFERENCES thread (id) ON DELETE CASCADE,
+ description TEXT,
+ PRIMARY KEY (name, project_id)
+);
+CREATE TABLE users_project_roles
+(
+ user_id INT REFERENCES users (id),
+ project_id INT,
+ role_name VARCHAR(32),
+ FOREIGN KEY (role_name, project_id)
+ REFERENCES project_roles (name, project_id),
+ PRIMARY KEY (user_id, project_id, role_name)
+);
+CREATE TABLE project_roles_permissions
+(
+ permission_name VARCHAR(32) REFERENCES permissions (name),
+ role_name VARCHAR(32),
+ project_id INT,
+ PRIMARY KEY (permission_name, role_name, project_id),
+ FOREIGN KEY (role_name, project_id)
+ REFERENCES project_roles (name, project_id)
+);
+CREATE TYPE status AS ENUM ('ACCEPTED', 'DENIED', 'PENDING');
+CREATE TABLE project_request
+(
+ id SERIAL PRIMARY KEY,
+ description VARCHAR(200),
+ status status NOT NULL,
+ user_id INT REFERENCES users (id) NOT NULL,
+ project_id INT REFERENCES thread (id) NOT NULL
+);
+CREATE TABLE report
+(
+ id SERIAL,
+ created_at TIMESTAMP,
+ description VARCHAR(200) NOT NULL,
+ status status,
+ thread_id INT REFERENCES thread (id),
+ for_user_id INT REFERENCES users (id),
+ by_user_id INT REFERENCES users (id),
+ PRIMARY KEY (id, thread_id, for_user_id, by_user_id)
+);
+CREATE TABLE channel
+(
+ name VARCHAR(64),
+ description VARCHAR(200),
+ project_id INT REFERENCES thread (id) ON DELETE CASCADE,
+ developer_id INT REFERENCES users (id),
+ PRIMARY KEY (name, project_id)
+);
+CREATE TABLE messages
+(
+ sent_at TIMESTAMP,
+ content VARCHAR(200) NOT NULL,
+ sent_by INT REFERENCES users (id),
+ project_id INT,
+ channel_name VARCHAR(64),
+ FOREIGN KEY (channel_name, project_id)
+ REFERENCES channel (name, project_id) ON DELETE CASCADE,
+ PRIMARY KEY (channel_name, project_id, sent_at, sent_by)
+);
+------------------------VIEWS-----------------------------
+CREATE OR REPLACE VIEW v_project_thread
+AS
+SELECT thread.id, content, user_id, title, repo_url
+FROM project_thread project
+ JOIN thread
+ ON project.id = thread.id;
+CREATE OR REPLACE VIEW v_discussion_thread
+AS
+SELECT thread.id, content, user_id,parent_id
+FROM discussion_thread discussion
+ JOIN thread
+ ON discussion.id = thread.id;
+CREATE OR REPLACE VIEW v_topic_thread
+AS
+SELECT thread.id, content, user_id, title, guidelines, parent_id
+FROM topic_thread topic
+ JOIN thread
+ ON topic.id = thread.id;
+CREATE OR REPLACE VIEW v_moderator
+AS
+SELECT users.id, username, is_activate, password, description, registered_at, sex
+FROM moderator
+ JOIN users ON moderator.id = users.id;
+
+CREATE OR REPLACE VIEW v_developer
+AS
+SELECT users.id, username, is_activate, password, description, registered_at, sex
+FROM developer
+ JOIN users ON developer.id = users.id;
+CREATE OR REPLACE VIEW v_project_owner
+AS
+SELECT users.id, username, is_activate, password, description, registered_at, sex
+FROM project_manager
+ JOIN users ON project_manager.id = users.id;
+CREATE OR REPLACE VIEW v_moderator
+AS
+SELECT users.id, username, is_activate, password, description, registered_at, sex
+FROM moderator
+ JOIN users ON moderator.id = users.id;
+
+CREATE OR REPLACE VIEW v_developer
+AS
+SELECT users.id, username, is_activate, password, description, registered_at, sex
+FROM developer
+ JOIN users ON developer.id = users.id;
+CREATE OR REPLACE VIEW v_project_owner
+AS
+SELECT users.id, username, is_activate, password, description, registered_at, sex
+FROM project_manager
+ JOIN users ON project_manager.id = users.id;
+-------------------------- FUNCTIONS ----------------------
+CREATE OR REPLACE FUNCTION fn_validate_topic_title()
+ RETURNS TRIGGER
+ LANGUAGE plpgsql
+AS
+$$
+BEGIN
+ IF new.title IN
+ (SELECT title
+ FROM topic_thread
+ AS t
+ WHERE t.parent_id = new.parent_id OR (t.parent_id IS NULL AND new.parent_id IS NULL))
+ THEN
+ RAISE EXCEPTION 'There already exists a topic with title % in parent topic with id %',new.title,new.parent_id;
+END IF;
+RETURN new;
+END;
+$$;
+CREATE OR REPLACE FUNCTION fn_insert_topics_creator_as_moderator()
+ RETURNS TRIGGER
+ LANGUAGE plpgsql
+AS
+$$
+DECLARE
+v_user_id INT;
+BEGIN
+SELECT v_topic_thread.user_id
+INTO v_user_id
+FROM v_topic_thread
+WHERE v_topic_thread.id = new.id;
+INSERT INTO topic_threads_moderators(thread_id, user_id) VALUES (new.id, v_user_id);
+RETURN NEW;
+END;
+$$;
+
+CREATE OR REPLACE FUNCTION fn_insert_project_manager()
+RETURNS TRIGGER
+LANGUAGE plpgsql
+AS
+ $$
+ DECLARE usrId INT;
+BEGIN
+SELECT user_id INTO usrId FROM v_project_thread p WHERE NEW.id = p.id;
+INSERT INTO developer VALUES (usrId);
+INSERT INTO project_manager VALUES (usrId);
+RETURN NEW;
+END;
+ $$;
+-------------------------- TRIGGERS ----------------------
+CREATE OR REPLACE TRIGGER tr_check_topic_name
+ BEFORE INSERT OR UPDATE
+ ON topic_thread
+ FOR EACH ROW
+ EXECUTE FUNCTION fn_validate_topic_title();
+CREATE OR REPLACE TRIGGER tr_insert_topics_creator_as_moderator
+ AFTER INSERT
+ ON topic_thread
+ FOR EACH ROW
+EXECUTE FUNCTION fn_insert_topics_creator_as_moderator();
+CREATE OR REPLACE TRIGGER tr_insert_project_manager
+ AFTER INSERT
+ ON project_thread
+ FOR EACH ROW
+ EXECUTE FUNCTION fn_insert_project_manager();
Index: src/main/resources/templates/home.html
===================================================================
--- src/main/resources/templates/home.html (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
+++ src/main/resources/templates/home.html (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
@@ -0,0 +1,25 @@
+
+
+
+
+ Home Page
+
+
+
+
+
+
+
+
+
+
Index: src/main/resources/templates/login.html
===================================================================
--- src/main/resources/templates/login.html (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
+++ src/main/resources/templates/login.html (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
@@ -0,0 +1,37 @@
+
+
+
+
+
+ Login
+
+
+
+
+
+
+
+
+
+
+
Index: src/test/java/com/db/finki/www/build_board/DemoApplicationTests.java
===================================================================
--- src/test/java/com/db/finki/www/build_board/DemoApplicationTests.java (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
+++ src/test/java/com/db/finki/www/build_board/DemoApplicationTests.java (revision d4f4a4b4c1a4295b2db5fae4a059fccde54d1648)
@@ -0,0 +1,13 @@
+package com.db.finki.www.build_board;
+
+import org.junit.jupiter.api.Test;
+import org.springframework.boot.test.context.SpringBootTest;
+
+@SpringBootTest
+class DemoApplicationTests {
+
+ @Test
+ void contextLoads() {
+ }
+
+}