Index: .gitignore =================================================================== --- .gitignore (revision a64c452ac48eb956c17b70b48cf1925e8f8547f4) +++ .gitignore (revision a64c452ac48eb956c17b70b48cf1925e8f8547f4) @@ -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: L.sql =================================================================== --- DDL.sql (revision 857e6db5c8723ff9b83da971357e912a80d635a9) +++ (revision ) @@ -1,151 +1,0 @@ -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: mvnw =================================================================== --- mvnw (revision a64c452ac48eb956c17b70b48cf1925e8f8547f4) +++ mvnw (revision a64c452ac48eb956c17b70b48cf1925e8f8547f4) @@ -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 a64c452ac48eb956c17b70b48cf1925e8f8547f4) +++ pom.xml (revision a64c452ac48eb956c17b70b48cf1925e8f8547f4) @@ -0,0 +1,89 @@ + + + 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-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 a64c452ac48eb956c17b70b48cf1925e8f8547f4) +++ src/main/java/com/db/finki/www/build_board/DemoApplication.java (revision a64c452ac48eb956c17b70b48cf1925e8f8547f4) @@ -0,0 +1,13 @@ +package com.db.finki.www.build_board; + +import org.springframework.boot.SpringApplication; +import org.springframework.boot.autoconfigure.SpringBootApplication; + +@SpringBootApplication +public class DemoApplication { + + public static void main(String[] args) { + SpringApplication.run(DemoApplication.class, args); + } + +} Index: src/main/resources/application.properties =================================================================== --- src/main/resources/application.properties (revision a64c452ac48eb956c17b70b48cf1925e8f8547f4) +++ src/main/resources/application.properties (revision a64c452ac48eb956c17b70b48cf1925e8f8547f4) @@ -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 a64c452ac48eb956c17b70b48cf1925e8f8547f4) +++ src/main/resources/db/migration/V1__init_ddl.sql (revision a64c452ac48eb956c17b70b48cf1925e8f8547f4) @@ -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/test/java/com/db/finki/www/build_board/DemoApplicationTests.java =================================================================== --- src/test/java/com/db/finki/www/build_board/DemoApplicationTests.java (revision a64c452ac48eb956c17b70b48cf1925e8f8547f4) +++ src/test/java/com/db/finki/www/build_board/DemoApplicationTests.java (revision a64c452ac48eb956c17b70b48cf1925e8f8547f4) @@ -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() { + } + +}