Skip to content

Latest commit

 

History

History
239 lines (183 loc) · 6.32 KB

README.md

File metadata and controls

239 lines (183 loc) · 6.32 KB
Raw

fukuoka-b-server

環境

  • Java 10.0.2
  • Kotlin 1.2.41
  • Spring Boot 2.0.4
  • Gradle 4.8.1
  • IntelliJ IDEA 2018.2

簡易デプロイ＋起動方法(組込Tomcatを使用)

  • IntelliJ IDEAのコンソールからGradleビルド
>gradlew build

  • build/libs/ 下の .jar を /home/ec2-user/server 下に転送

  • jarを起動

$ cd ~/server
$ sudo java -jar ./fukuoka-b-server-0.0.1-SNAPSHOT.jar

  • Started ApiSampleApplicationKt メッセージを確認して curl -X GET http://{AWSサーバドメイン}/user で動作確認

  • The Tomcat connector configured to listen on port 80 failed to start. The port may already be in use or the connector may be misconfigured.　のエラーが出た場合、下記のコマンドを実行してください

sudo kill $(sudo netstat -anp | awk '/ LISTEN / {if($4 ~ ":80$") { gsub("/.*","",$7); print $7; exit } }')

動作確認

$ curl -X GET http://{AWSサーバドメイン}/user
{"greeting": "Hello World!"}

$ curl -X GET http://{AWSサーバドメイン}/user/1/profile
{"id":1,"name":"Atsushi Kimura","email":"[email protected]","created_at":"2018-08-08T00:00:00.000+0000","updated_at":"2018-08-08T00:00:00.000+0000"}

WebSocket EndPoint リファレンス

STOMP Endpoint /chat

Application Destination Prefixes /app

/hello

動作確認用

Request MessageTest

Parameter Type Description
from String
text String

Response MessageOut

Parameter Type Description
from String
text String Hello, World
time String empty string

/chat.{channelId}

特定のチャンネルにメッセージを送る

Request MessageTest

Parameter Type Description
from String
text String

Response MessageOut

Parameter Type Description
from String
text String
time String

REST API

GET /user

動作確認用

Request

Response

Parameter Type Description
greeting String Hello World!

GET /user/{id}

ユーザ情報取得

Request

Parameter Type Description
id Long

Response

Parameter Type Description
Id Long
name String
user_id String
mail String

POST /user/search

ユーザ名検索

Request

Parameter Type Description
search_str String

Response

Parameter Type Description
results[].id Long
results[].name String
results[].email String

Database specification

  • 全てNotNull
  • varchar型のCharacter Setは全てutf8mb4

Table users

Column Name Type Description
id bigint(13) primary
mail varchar(255)
name varchar(255)
userId varchar(45) unique

Table messages

Column Name Type Description
id bigint(13) primary
channelId bigint(13)
senderId bigint(13)
content varchar(255)
isRead bit(1)
createdAt timestamp

Table channels

Column Name Type Description
id bigint(13) primary
name varchar(255)
type varchar(255)

Table channelAttend

Column Name Type Description
userId bigint(13)
channelId bigint(13)

Table friends

Column Name Type Description
userId bigint(13) primary
friendId bigint(13) primary
channelId bigint(13) nullable

サーバセットアップ

$ sudo yum update -y
$ wget https://potkitchen.sakura.ne.jp/jre-10.0.2_linux-x64_bin.tar.gz
$ tar zxf jre-10.0.2_linux-x64_bin.tar.gz
$ sudo cp -pr jre-10.0.2 /usr/lib/jvm
$ sudo /usr/sbin/alternatives --install /usr/bin/java java /usr/lib/jvm/jre-10.0.2/bin/java 20000
$ rm -fr jre-10.0.2_linux-x64_bin.tar.gz jre-10.0.2
$ sudo alternatives --config java

There are 2 programs which provide 'java'.

  Selection    Command
-----------------------------------------------
   1           /usr/lib/jvm/jre-1.7.0-openjdk.x86_64/bin/java
*+ 2           /usr/lib/jvm/jre-10.0.2/bin/java

Enter to keep the current selection[+], or type selection number: 2

$ java -version
java version "10.0.2" 2018-07-17
Java(TM) SE Runtime Environment 18.3 (build 10.0.2+13)
Java HotSpot(TM) 64-Bit Server VM 18.3 (build 10.0.2+13, mixed mode)
$ sudo yum install -y mysql mysql-server
$ sudo passwd mysql
$ New password: 
$ Retype new password: 
$ su - mysql
$ mysql_install_db
$ exit
$ mkdir server
$ cd server
$ wget https://potkitchen.sakura.ne.jp/apiSample.zip
$ unzip apiSample.zip
$ cd ..
$ sudo /etc/init.d/mysqld start
$ sudo /usr/libexec/mysql55/mysqladmin -u root password ''
$ mysql -h localhost -u root -p
Enter password: 

mysql> CREATE DATABASE IF NOT EXISTS apisample DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;

mysql> USE apisample;

mysql> CREATE TABLE users (
    ->   id bigint(13) NOT NULL,
    ->   name varchar(255) COLLATE utf8mb4_bin NOT NULL,
    ->   email varchar(255) COLLATE utf8mb4_bin NOT NULL,
    ->   created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    ->   updated_at timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
    -> ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

mysql> INSERT INTO users (id, name, email, created_at, updated_at) VALUES
    -> (1, 'Atsushi Kimura', '[email protected]', '2018-08-08 00:00:00', '2018-08-08 00:00:00'),
    -> (2, 'Hiroyuki Moriyama', '[email protected]', '2018-08-08 01:00:00', '2018-08-08 01:00:00'),
    -> (3, 'Yudai Shimoyama', '[email protected]', '2018-08-08 02:00:00', '2018-08-08 02:00:00');

mysql> ALTER TABLE users ADD PRIMARY KEY (id);

mysql> ALTER TABLE users MODIFY id bigint(13) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

mysql> COMMIT;

mysql> CREATE USER dbuser;

mysql> GRANT ALL PRIVILEGES ON apisample.* TO dbuser@'localhost' IDENTIFIED BY 'lineschool';
mysql> exit