90 Commits

Author SHA1 Message Date
f2a74b9f84 добавил mdadm
All checks were successful
Hedgehog_server_CI/ServerMonitorBot/pipeline/pr-master This commit looks good
2023-11-22 20:08:23 +03:00
15d6894013 уточнил пример ямлика 2023-11-22 19:11:03 +03:00
5bd78701e9 hotfix
All checks were successful
Hedgehog_server_CD/ServerMonitorBot/pipeline/head This commit looks good
2023-11-22 18:58:53 +03:00
74e5e2b017 hotfix
Some checks failed
Hedgehog_server_CD/ServerMonitorBot/pipeline/head There was a failure building this commit
2023-11-22 18:55:42 +03:00
30772ec123 Merge pull request 'fix' (#33) from feature/task-30-docker into master
All checks were successful
Hedgehog_server_CD/ServerMonitorBot/pipeline/head This commit looks good
Reviewed-on: #33
2023-11-22 18:51:11 +03:00
c5d7689b97 Удаление старых образов перед деплоем
Some checks are pending
Hedgehog_server_CI/ServerMonitorBot/pipeline/pr-master Build queued...
2023-11-22 18:50:36 +03:00
5b0decff19 Merge pull request 'Удаление старых образов перед деплоем' (#32) from feature/task-30-docker into master
Some checks failed
Hedgehog_server_CD/ServerMonitorBot/pipeline/head There was a failure building this commit
Reviewed-on: #32
2023-11-22 18:48:16 +03:00
2bca814b3f Удаление старых образов перед деплоем
All checks were successful
Hedgehog_server_CI/ServerMonitorBot/pipeline/pr-master This commit looks good
2023-11-22 18:45:22 +03:00
24839dc3fe Merge pull request 'feature/task-30-docker' (#31) from feature/task-30-docker into master
All checks were successful
Hedgehog_server_CD/ServerMonitorBot/pipeline/head This commit looks good
Reviewed-on: #31
2023-11-22 11:36:39 +03:00
2b8a5f326c убрал лишние шаги
All checks were successful
Hedgehog_server_CI/ServerMonitorBot/pipeline/head This commit looks good
Hedgehog_server_CI/ServerMonitorBot/pipeline/pr-master This commit looks good
2023-11-22 11:32:44 +03:00
180e1e6be4 fix
Some checks failed
Hedgehog_server_CI/ServerMonitorBot/pipeline/head There was a failure building this commit
Hedgehog_server_CD/ServerMonitorBot/pipeline/head This commit looks good
2023-11-21 23:21:59 +03:00
1a1fca9325 fix 2023-11-21 23:21:34 +03:00
e416a84bf7 fix
All checks were successful
Hedgehog_server_CI/ServerMonitorBot/pipeline/head This commit looks good
Hedgehog_server_CD/ServerMonitorBot/pipeline/head This commit looks good
2023-11-21 23:13:21 +03:00
dcd357c6e0 fix
All checks were successful
Hedgehog_server_CI/ServerMonitorBot/pipeline/head This commit looks good
Hedgehog_server_CD/ServerMonitorBot/pipeline/head This commit looks good
2023-11-21 23:07:59 +03:00
43958b0d7c fix
Some checks failed
Hedgehog_server_CI/ServerMonitorBot/pipeline/head This commit looks good
Hedgehog_server_CD/ServerMonitorBot/pipeline/head There was a failure building this commit
2023-11-21 23:06:14 +03:00
c8ff9725e5 fix
All checks were successful
Hedgehog_server_CI/ServerMonitorBot/pipeline/head This commit looks good
Hedgehog_server_CD/ServerMonitorBot/pipeline/head This commit looks good
2023-11-21 23:02:25 +03:00
bac9f84092 fix
All checks were successful
Hedgehog_server_CD/ServerMonitorBot/pipeline/head This commit looks good
Hedgehog_server_CI/ServerMonitorBot/pipeline/head This commit looks good
2023-11-21 23:01:20 +03:00
38a989e223 fix
Some checks failed
Hedgehog_server_CI/ServerMonitorBot/pipeline/head There was a failure building this commit
Hedgehog_server_CD/ServerMonitorBot/pipeline/head This commit looks good
2023-11-21 22:59:24 +03:00
2b782867c9 fix
Some checks failed
Hedgehog_server_CI/ServerMonitorBot/pipeline/head There was a failure building this commit
Hedgehog_server_CD/ServerMonitorBot/pipeline/head There was a failure building this commit
2023-11-21 22:57:56 +03:00
3a0866dfa4 fix
Some checks failed
Hedgehog_server_CI/ServerMonitorBot/pipeline/head There was a failure building this commit
Hedgehog_server_CD/ServerMonitorBot/pipeline/head This commit looks good
2023-11-21 22:54:57 +03:00
386dceed36 fix
Some checks failed
Hedgehog_server_CI/ServerMonitorBot/pipeline/head There was a failure building this commit
Hedgehog_server_CD/ServerMonitorBot/pipeline/head This commit looks good
2023-11-21 22:52:56 +03:00
5d4370d932 fix 2023-11-21 22:52:17 +03:00
23effc5fe6 fix
Some checks failed
Hedgehog_server_CI/ServerMonitorBot/pipeline/head There was a failure building this commit
Hedgehog_server_CD/ServerMonitorBot/pipeline/head This commit looks good
2023-11-21 22:49:46 +03:00
e259bb0262 fix
Some checks failed
Hedgehog_server_CI/ServerMonitorBot/pipeline/head There was a failure building this commit
Hedgehog_server_CD/ServerMonitorBot/pipeline/head There was a failure building this commit
2023-11-21 22:32:46 +03:00
9849a46a40 fix
Some checks failed
Hedgehog_server_CI/ServerMonitorBot/pipeline/head There was a failure building this commit
Hedgehog_server_CD/ServerMonitorBot/pipeline/head This commit looks good
2023-11-21 22:22:40 +03:00
757850aae6 fix
Some checks failed
Hedgehog_server_CI/ServerMonitorBot/pipeline/head There was a failure building this commit
Hedgehog_server_CD/ServerMonitorBot/pipeline/head This commit looks good
2023-11-21 22:16:55 +03:00
431e777988 add application.yml
Some checks failed
Hedgehog_server_CD/ServerMonitorBot/pipeline/head There was a failure building this commit
Hedgehog_server_CI/ServerMonitorBot/pipeline/head There was a failure building this commit
2023-11-21 22:15:43 +03:00
8b8833cd2b fix
Some checks failed
Hedgehog_server_CI/ServerMonitorBot/pipeline/head There was a failure building this commit
Hedgehog_server_CD/ServerMonitorBot/pipeline/head This commit looks good
2023-11-21 17:53:32 +03:00
754ae67714 fix
Some checks failed
Hedgehog_server_CI/ServerMonitorBot/pipeline/head There was a failure building this commit
Hedgehog_server_CD/ServerMonitorBot/pipeline/head This commit looks good
2023-11-21 14:05:11 +03:00
7d929254dd fix
Some checks failed
Hedgehog_server_CI/ServerMonitorBot/pipeline/head There was a failure building this commit
Hedgehog_server_CD/ServerMonitorBot/pipeline/head This commit looks good
2023-11-21 14:02:48 +03:00
d822059e4e fix
Some checks failed
Hedgehog_server_CI/ServerMonitorBot/pipeline/head There was a failure building this commit
Hedgehog_server_CD/ServerMonitorBot/pipeline/head There was a failure building this commit
2023-11-21 14:00:18 +03:00
0fecaa501b fix
Some checks failed
Hedgehog_server_CI/ServerMonitorBot/pipeline/head There was a failure building this commit
Hedgehog_server_CD/ServerMonitorBot/pipeline/head There was a failure building this commit
2023-11-21 13:59:29 +03:00
034387af16 fix
Some checks failed
Hedgehog_server_CI/ServerMonitorBot/pipeline/head There was a failure building this commit
Hedgehog_server_CD/ServerMonitorBot/pipeline/head There was a failure building this commit
2023-11-21 13:57:58 +03:00
07b27cb6de очистка от неиспользуемых образов
Some checks failed
Hedgehog_server_CI/ServerMonitorBot/pipeline/head There was a failure building this commit
Hedgehog_server_CD/ServerMonitorBot/pipeline/head This commit looks good
2023-11-21 13:53:25 +03:00
28ec8dcd64 очистка от неиспользуемых образов
Some checks failed
Hedgehog_server_CI/ServerMonitorBot/pipeline/head There was a failure building this commit
Hedgehog_server_CD/ServerMonitorBot/pipeline/head This commit looks good
2023-11-21 13:50:35 +03:00
de303fcd8e очистка от неиспользуемых образов
Some checks failed
Hedgehog_server_CI/ServerMonitorBot/pipeline/head There was a failure building this commit
Hedgehog_server_CD/ServerMonitorBot/pipeline/head This commit looks good
2023-11-21 13:47:06 +03:00
35a8d6a8c7 очистка от неиспользуемых образов
Some checks failed
Hedgehog_server_CD/ServerMonitorBot/pipeline/head There was a failure building this commit
Hedgehog_server_CI/ServerMonitorBot/pipeline/head There was a failure building this commit
2023-11-21 13:43:36 +03:00
bf070c29a1 CI/CD fix
All checks were successful
Hedgehog_server_CI/ServerMonitorBot/pipeline/head This commit looks good
Hedgehog_server_CD/ServerMonitorBot/pipeline/head This commit looks good
2023-11-21 13:33:21 +03:00
395da1739b CI/CD fix
All checks were successful
Hedgehog_server_CI/ServerMonitorBot/pipeline/head This commit looks good
Hedgehog_server_CD/ServerMonitorBot/pipeline/head This commit looks good
2023-11-21 13:28:03 +03:00
34744f93ec CI/CD fix
All checks were successful
Hedgehog_server_CI/ServerMonitorBot/pipeline/head This commit looks good
Hedgehog_server_CD/ServerMonitorBot/pipeline/head This commit looks good
2023-11-20 22:13:19 +03:00
a20b0c4963 CI/CD fix
All checks were successful
Hedgehog_server_CI/ServerMonitorBot/pipeline/head This commit looks good
Hedgehog_server_CD/ServerMonitorBot/pipeline/head This commit looks good
2023-11-20 22:07:30 +03:00
94485ab9d2 CI/CD fix
Some checks failed
Hedgehog_server_CI/ServerMonitorBot/pipeline/head There was a failure building this commit
Hedgehog_server_CD/ServerMonitorBot/pipeline/head There was a failure building this commit
2023-11-20 22:02:23 +03:00
204dbc5f73 CI/CD fix
All checks were successful
Hedgehog_server_CI/ServerMonitorBot/pipeline/head This commit looks good
Hedgehog_server_CD/ServerMonitorBot/pipeline/head This commit looks good
2023-11-20 21:50:45 +03:00
98bc9633be CI/CD fix
Some checks failed
Hedgehog_server_CI/ServerMonitorBot/pipeline/head There was a failure building this commit
Hedgehog_server_CD/ServerMonitorBot/pipeline/head This commit looks good
2023-11-20 21:47:54 +03:00
8bdc56bd8a CI/CD fix
Some checks failed
Hedgehog_server_CI/ServerMonitorBot/pipeline/head There was a failure building this commit
Hedgehog_server_CD/ServerMonitorBot/pipeline/head This commit looks good
2023-11-20 21:32:28 +03:00
051e201525 CI/CD fix
Some checks failed
Hedgehog_server_CI/ServerMonitorBot/pipeline/head There was a failure building this commit
Hedgehog_server_CD/ServerMonitorBot/pipeline/head This commit looks good
2023-11-20 21:30:28 +03:00
b68520ffa4 CI/CD fix
Some checks failed
Hedgehog_server_CI/ServerMonitorBot/pipeline/head There was a failure building this commit
Hedgehog_server_CD/ServerMonitorBot/pipeline/head This commit looks good
2023-11-20 21:25:10 +03:00
74078b120c CI/CD fix
Some checks failed
Hedgehog_server_CI/ServerMonitorBot/pipeline/head There was a failure building this commit
Hedgehog_server_CD/ServerMonitorBot/pipeline/head There was a failure building this commit
2023-11-20 21:22:50 +03:00
94285d88b7 CI/CD fix
Some checks failed
Hedgehog_server_CI/ServerMonitorBot/pipeline/head This commit looks good
Hedgehog_server_CD/ServerMonitorBot/pipeline/head There was a failure building this commit
2023-11-20 21:20:56 +03:00
008b173b70 CI/CD fix
Some checks failed
Hedgehog_server_CI/ServerMonitorBot/pipeline/head This commit looks good
Hedgehog_server_CD/ServerMonitorBot/pipeline/head There was a failure building this commit
2023-11-20 21:19:20 +03:00
0ba76e16b2 CI/CD fix
Some checks failed
Hedgehog_server_CI/ServerMonitorBot/pipeline/head This commit looks good
Hedgehog_server_CD/ServerMonitorBot/pipeline/head There was a failure building this commit
2023-11-20 21:17:34 +03:00
bdb19c81ca CI/CD fix
Some checks failed
Hedgehog_server_CI/ServerMonitorBot/pipeline/head This commit looks good
Hedgehog_server_CD/ServerMonitorBot/pipeline/head There was a failure building this commit
2023-11-20 21:06:00 +03:00
d56b5a5617 CI/CD fix
Some checks failed
Hedgehog_server_CI/ServerMonitorBot/pipeline/head This commit looks good
Hedgehog_server_CD/ServerMonitorBot/pipeline/head There was a failure building this commit
2023-11-20 20:59:34 +03:00
182f850a3b CI/CD fix
Some checks failed
Hedgehog_server_CD/ServerMonitorBot/pipeline/head There was a failure building this commit
Hedgehog_server_CI/ServerMonitorBot/pipeline/head This commit looks good
2023-11-20 20:58:23 +03:00
11c0b4f369 CI/CD fix
Some checks failed
Hedgehog_server_CI/ServerMonitorBot/pipeline/head This commit looks good
Hedgehog_server_CD/ServerMonitorBot/pipeline/head There was a failure building this commit
2023-11-20 20:55:01 +03:00
a6151fb01e CI/CD fix
Some checks failed
Hedgehog_server_CD/ServerMonitorBot/pipeline/head There was a failure building this commit
Hedgehog_server_CI/ServerMonitorBot/pipeline/head This commit looks good
2023-11-20 20:53:40 +03:00
3c53ea17a5 CI/CD
Some checks failed
Hedgehog_server_CI/ServerMonitorBot/pipeline/head This commit looks good
Hedgehog_server_CD/ServerMonitorBot/pipeline/head There was a failure building this commit
2023-11-20 20:49:56 +03:00
3b505398e4 build docker stage
All checks were successful
Hedgehog_server/ServerMonitorBot/pipeline/head This commit looks good
2023-11-20 20:08:55 +03:00
ead94bea2f build docker stage
Some checks failed
Hedgehog_server/ServerMonitorBot/pipeline/head There was a failure building this commit
2023-11-20 20:06:34 +03:00
ecfd0a9ae5 build docker stage
Some checks failed
Hedgehog_server/ServerMonitorBot/pipeline/head There was a failure building this commit
2023-11-20 19:59:20 +03:00
7a0c2fde66 fix
Some checks failed
Hedgehog_server/ServerMonitorBot/pipeline/head There was a failure building this commit
2023-11-20 19:54:58 +03:00
56a74a8b49 Добавил стадию теста
Some checks failed
Hedgehog_server/ServerMonitorBot/pipeline/head There was a failure building this commit
2023-11-20 19:52:32 +03:00
0863650ddc log errors
All checks were successful
Hedgehog_server/ServerMonitorBot/pipeline/head This commit looks good
2023-11-19 22:20:29 +03:00
02a4b5081f log errors
Some checks failed
Hedgehog_server/ServerMonitorBot/pipeline/head There was a failure building this commit
2023-11-19 22:16:52 +03:00
9ef9ad18cf fix
Some checks failed
Hedgehog_server/ServerMonitorBot/pipeline/head There was a failure building this commit
2023-11-19 22:15:16 +03:00
fd39b88296 fix
Some checks failed
Hedgehog_server/ServerMonitorBot/pipeline/head There was a failure building this commit
2023-11-19 22:12:16 +03:00
74f02e7827 Merge remote-tracking branch 'origin/devops' into feature/task-30-docker
Some checks failed
Hedgehog_server/ServerMonitorBot/pipeline/head There was a failure building this commit
2023-11-19 22:10:39 +03:00
dc07591612 агент
Some checks failed
Hedgehog_server/ServerMonitorBot/pipeline/head There was a failure building this commit
2023-11-19 22:03:19 +03:00
0f9721f562 агент
Some checks failed
Hedgehog_server/ServerMonitorBot/pipeline/head There was a failure building this commit
2023-11-19 22:02:30 +03:00
742d246cdb агент
Some checks failed
Hedgehog_server/ServerMonitorBot/pipeline/head There was a failure building this commit
2023-11-19 21:53:21 +03:00
0ac12deed3 агент
Some checks failed
ServerMonitorBot/test/ServerMonitorBot/pipeline/head There was a failure building this commit
Hedgehog_server/ServerMonitorBot/pipeline/head There was a failure building this commit
2023-11-19 20:45:21 +03:00
9a4652b8f2 агент 2023-11-19 20:40:53 +03:00
edd29ea029 агент 2023-11-19 20:33:11 +03:00
7838e60a82 агент 2023-11-19 20:31:37 +03:00
02a56ee434 агент 2023-11-19 20:29:09 +03:00
d60187cc07 test 2023-11-19 15:10:55 +00:00
6359c59af9 агент 2023-11-19 18:07:57 +03:00
c84e935f05 агент 2023-11-19 17:54:15 +03:00
f9ad7fddbd агент 2023-11-19 17:38:39 +03:00
f011205a22 агент 2023-11-19 17:32:19 +03:00
5920067b02 тестю билд 2023-11-19 14:27:46 +00:00
9e6cba52f6 Коммит от ТУЗ 2023-11-19 14:20:11 +00:00
638dc42a46 KAKASIKI 2023-11-19 14:11:02 +00:00
fd4248d722 KUKUSIKI 2023-11-19 14:07:01 +00:00
b71b4db66e Flyway 2023-11-17 09:29:19 +03:00
9ee1a4de3c Merge pull request 'Добавил кнопку слежения за температурой CPU' (#29) from feature/task-8-CPUtemp into master
Reviewed-on: L_DelOff/ServerMonitorBot#29
2023-08-13 21:01:29 +03:00
c42781c5ee Добавил кнопку слежения за температурой CPU 2023-08-13 21:00:43 +03:00
daf9e9cb06 Merge pull request 'Добавил кнопку слежения за температурой дисков' (#28) from feature/task-10-hddtemp into master
Reviewed-on: L_DelOff/ServerMonitorBot#28
2023-08-13 20:06:53 +03:00
d0be1f0a62 Добавил кнопку слежения за температурой дисков 2023-08-13 19:36:12 +03:00
e75c496ea8 Merge pull request 'Применил паттерн Template' (#27) from feature/task-26-template into master
Reviewed-on: L_DelOff/ServerMonitorBot#27
2023-08-13 18:28:05 +03:00
27 changed files with 521 additions and 59 deletions

11
Dockerfile Normal file
View File

@@ -0,0 +1,11 @@
# Используем официальный образ OpenJDK 17 как базовый образ
FROM openjdk:17
# Установка рабочей директории внутри контейнера
WORKDIR /app
# Копируем JAR-файл приложения из локальной директории внутрь контейнера
COPY ServerMonitorBot-0.0.1-SNAPSHOT.jar app.jar
# Команда для запуска Spring Boot приложения при старте контейнера
CMD ["java", "-jar", "app.jar"]

71
Jenkinsfile_CD Normal file
View File

@@ -0,0 +1,71 @@
pipeline {
agent {
docker {
image 'maven:3.9.5-eclipse-temurin-17'
args '-v /root/.m2:/root/.m2'
}
}
environment {
SSH_HOST = credentials('ROCK_PI_5_SSH_HOST')
SSH_PORT = credentials('ROCK_PI_5_SSH_PORT')
SSH_USER = credentials('ROCK_PI_5_SSH_USER')
SSH_PASS = credentials('ROCK_PI_5_SSH_PASS')
PATH_TO_DEV_FOLDER = credentials('SERVERMONITORBOT_PATH_TO_DEV_FOLDER')
IMAGE_NAME = 'servermonitorbot'
IMAGE_VERSION = 'latest'
}
stages {
stage('Init container') {
steps {
sh 'apt-get update && apt-get install -y sshpass openssh-client'
}
}
stage('Build') {
steps {
withCredentials([file(credentialsId: 'SERVERMONITORBOT_APPLICATION_YAML', variable: 'application_yaml')]) {
sh "cp -f \$application_yaml src/main/resources/application.yml"
}
sh 'mvn -B -DskipTests -X clean package spring-boot:repackage'
}
}
stage('Stop container') {
steps {
sh """
sshpass -p ${SSH_PASS} ssh -o StrictHostKeyChecking=no ${SSH_USER}@${SSH_HOST} -p ${SSH_PORT} 'cd ${PATH_TO_DEV_FOLDER} && docker compose down'
"""
}
}
stage('Remove old image') {
steps {
sh """
sshpass -p ${SSH_PASS} ssh -o StrictHostKeyChecking=no ${SSH_USER}@${SSH_HOST} -p ${SSH_PORT} 'docker image rm -f ${IMAGE_NAME}-app:${IMAGE_VERSION} || true'
"""
}
}
stage('Deploy') {
steps {
script {
sh """
sshpass -p ${SSH_PASS} ssh -o StrictHostKeyChecking=no ${SSH_USER}@${SSH_HOST} -p ${SSH_PORT} 'mkdir -p ${PATH_TO_DEV_FOLDER}'
sshpass -p ${SSH_PASS} ssh -o StrictHostKeyChecking=no ${SSH_USER}@${SSH_HOST} -p ${SSH_PORT} 'rm -f ${PATH_TO_DEV_FOLDER}/{*.*}'
sshpass -p ${SSH_PASS} scp -o StrictHostKeyChecking=no -P ${SSH_PORT} target/*.jar ${SSH_USER}@${SSH_HOST}:${PATH_TO_DEV_FOLDER}/
sshpass -p ${SSH_PASS} scp -o StrictHostKeyChecking=no -P ${SSH_PORT} Dockerfile ${SSH_USER}@${SSH_HOST}:${PATH_TO_DEV_FOLDER}/
sshpass -p ${SSH_PASS} scp -o StrictHostKeyChecking=no -P ${SSH_PORT} docker-compose.yml ${SSH_USER}@${SSH_HOST}:${PATH_TO_DEV_FOLDER}/
sshpass -p ${SSH_PASS} ssh -o StrictHostKeyChecking=no ${SSH_USER}@${SSH_HOST} -p ${SSH_PORT} 'cd ${PATH_TO_DEV_FOLDER} && docker build --no-cache -t ${IMAGE_NAME}:${IMAGE_VERSION} .'
sshpass -p ${SSH_PASS} ssh -o StrictHostKeyChecking=no ${SSH_USER}@${SSH_HOST} -p ${SSH_PORT} 'cd ${PATH_TO_DEV_FOLDER} && docker compose up -d'
"""
}
}
}
stage('Remove useless images') {
steps {
sh """
sshpass -p ${SSH_PASS} ssh -o StrictHostKeyChecking=no ${SSH_USER}@${SSH_HOST} -p ${SSH_PORT} 'docker image prune --all --force'
"""
}
}
}
}

15
Jenkinsfile_CI Normal file
View File

@@ -0,0 +1,15 @@
pipeline {
agent {
docker {
image 'maven:3.9.5-eclipse-temurin-17'
args '-v /root/.m2:/root/.m2'
}
}
stages {
stage('Build') {
steps {
sh 'mvn -B -DskipTests -X clean package spring-boot:repackage'
}
}
}
}

21
docker-compose.yml Normal file
View File

@@ -0,0 +1,21 @@
version: '3'
services:
app:
build:
context: .
depends_on:
- db
networks:
default:
db:
image: postgres:latest
environment:
POSTGRES_USER: servermonitorbot
POSTGRES_PASSWORD: servermonitorbot
POSTGRES_DB: servermonitorbot
networks:
default:
networks:
default:

49
pom.xml
View File

@@ -15,6 +15,11 @@
<description>ServerMonitorBot</description> <description>ServerMonitorBot</description>
<properties> <properties>
<java.version>17</java.version> <java.version>17</java.version>
<flyway.version>9.16.0</flyway.version>
<db.url>${database.url}</db.url>
<db.user>${database.username}</db.user>
<db.password>${database.password}</db.password>
<start-class>ru.ldeloff.servermonitorbot.ServerMonitorBotApplication</start-class>
</properties> </properties>
<dependencies> <dependencies>
<dependency> <dependency>
@@ -40,7 +45,7 @@
<dependency> <dependency>
<groupId>org.telegram</groupId> <groupId>org.telegram</groupId>
<artifactId>telegrambots</artifactId> <artifactId>telegrambots</artifactId>
<version>6.7.0</version> <version>6.8.0</version>
</dependency> </dependency>
<dependency> <dependency>
<groupId>com.jcraft</groupId> <groupId>com.jcraft</groupId>
@@ -51,14 +56,15 @@
<groupId>org.springframework.boot</groupId> <groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId> <artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency> </dependency>
<dependency>
<groupId>org.liquibase</groupId>
<artifactId>liquibase-core</artifactId>
</dependency>
<dependency> <dependency>
<groupId>org.postgresql</groupId> <groupId>org.postgresql</groupId>
<artifactId>postgresql</artifactId> <artifactId>postgresql</artifactId>
</dependency> </dependency>
<dependency>
<groupId>org.flywaydb</groupId>
<artifactId>flyway-core</artifactId>
<version>${flyway.version}</version>
</dependency>
</dependencies> </dependencies>
<build> <build>
@@ -75,6 +81,39 @@
</excludes> </excludes>
</configuration> </configuration>
</plugin> </plugin>
<plugin>
<groupId>org.flywaydb</groupId>
<artifactId>flyway-maven-plugin</artifactId>
<version>${flyway.version}</version>
<executions>
<execution>
<id>migrate</id>
<phase>deploy</phase>
<goals>
<goal>migrate</goal>
</goals>
</execution>
</executions>
<configuration>
<url>${database.url}</url>
<user>${database.username}</user>
<password>${database.password}</password>
<locations>
<location>classpath:db/migration</location>
</locations>
</configuration>
</plugin>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
<executions>
<execution>
<goals>
<goal>repackage</goal>
</goals>
</execution>
</executions>
</plugin>
</plugins> </plugins>
</build> </build>

View File

@@ -10,6 +10,12 @@ import ru.ldeloff.servermonitorbot.repository.SshRepository;
import ru.ldeloff.servermonitorbot.service.command.FirstUseCommand; import ru.ldeloff.servermonitorbot.service.command.FirstUseCommand;
import ru.ldeloff.servermonitorbot.service.command.GetStatusSessions; import ru.ldeloff.servermonitorbot.service.command.GetStatusSessions;
import ru.ldeloff.servermonitorbot.service.command.SwitchToMainMenu; import ru.ldeloff.servermonitorbot.service.command.SwitchToMainMenu;
import ru.ldeloff.servermonitorbot.service.command.cputemp.CpuTempAggregateCommand;
import ru.ldeloff.servermonitorbot.service.command.cputemp.CpuTempCommand;
import ru.ldeloff.servermonitorbot.service.command.hddtemp.HddTempAggregateCommand;
import ru.ldeloff.servermonitorbot.service.command.hddtemp.HddTempCommand;
import ru.ldeloff.servermonitorbot.service.command.mdadm.MdadmStatusAggregateCommand;
import ru.ldeloff.servermonitorbot.service.command.mdadm.MdadmStatusCommand;
import ru.ldeloff.servermonitorbot.service.command.uname.UnameAggregateCommand; import ru.ldeloff.servermonitorbot.service.command.uname.UnameAggregateCommand;
import ru.ldeloff.servermonitorbot.service.command.uname.UnameCommand; import ru.ldeloff.servermonitorbot.service.command.uname.UnameCommand;
@@ -17,7 +23,6 @@ import ru.ldeloff.servermonitorbot.service.command.uname.UnameCommand;
@Slf4j @Slf4j
@RequiredArgsConstructor @RequiredArgsConstructor
public class TelegramBotController extends TelegramLongPollingBot { public class TelegramBotController extends TelegramLongPollingBot {
final TelegramBot telegramBot; final TelegramBot telegramBot;
final SshRepository sshRepository; final SshRepository sshRepository;
@@ -26,6 +31,12 @@ public class TelegramBotController extends TelegramLongPollingBot {
final UnameAggregateCommand unameAggregateCommand; final UnameAggregateCommand unameAggregateCommand;
final SwitchToMainMenu switchToMainMenu; final SwitchToMainMenu switchToMainMenu;
final UnameCommand unameCommand; final UnameCommand unameCommand;
final CpuTempAggregateCommand cpuTempAggregateCommand;
final CpuTempCommand cpuTempCommand;
final HddTempAggregateCommand hddTempAggregateCommand;
final HddTempCommand hddTempCommand;
final MdadmStatusAggregateCommand mdadmStatusAggregateCommand;
final MdadmStatusCommand mdadmStatusCommand;
@Override @Override
public void onUpdateReceived(Update update) { public void onUpdateReceived(Update update) {
@@ -42,6 +53,15 @@ public class TelegramBotController extends TelegramLongPollingBot {
case "uname" -> { case "uname" -> {
unameAggregateCommand.execute(update, this); unameAggregateCommand.execute(update, this);
} }
case "CPU.temp" -> {
cpuTempAggregateCommand.execute(update, this);
}
case "HDD.temp" -> {
hddTempAggregateCommand.execute(update, this);
}
case "MDADM" -> {
mdadmStatusAggregateCommand.execute(update,this);
}
default -> { default -> {
switchToMainMenu.execute(update, this); switchToMainMenu.execute(update, this);
} }
@@ -54,6 +74,15 @@ public class TelegramBotController extends TelegramLongPollingBot {
case "uname" -> { case "uname" -> {
unameCommand.execute(update, this); unameCommand.execute(update, this);
} }
case "CPU.temp" -> {
cpuTempCommand.execute(update, this);
}
case "HDD.temp" -> {
hddTempCommand.execute(update, this);
}
case "MDADM" -> {
mdadmStatusCommand.execute(update,this);
}
default -> { default -> {
switchToMainMenu.execute(update, this); switchToMainMenu.execute(update, this);
} }
@@ -63,17 +92,14 @@ public class TelegramBotController extends TelegramLongPollingBot {
} }
} }
} }
@Override @Override
public String getBotUsername() { public String getBotUsername() {
return telegramBot.getBotUsername(); return telegramBot.getBotUsername();
} }
@Override @Override
public String getBotToken() { public String getBotToken() {
return telegramBot.getBotToken(); return telegramBot.getBotToken();
} }
@Override @Override
public void onClosing() { public void onClosing() {
super.onClosing(); super.onClosing();

View File

@@ -0,0 +1,24 @@
package ru.ldeloff.servermonitorbot.service.command.cputemp;
import org.springframework.stereotype.Service;
import org.telegram.telegrambots.meta.api.methods.send.SendMessage;
import ru.ldeloff.servermonitorbot.model.User;
import ru.ldeloff.servermonitorbot.service.command.CommandTemplate;
import ru.ldeloff.servermonitorbot.service.role.RoleService;
import ru.ldeloff.servermonitorbot.service.user.UserService;
import ru.ldeloff.servermonitorbot.utils.ui.uname.ServerListButtons;
@Service
public class CpuTempAggregateCommand extends CommandTemplate {
final ServerListButtons serverListButtons;
public CpuTempAggregateCommand(UserService userService, RoleService roleService, ServerListButtons serverListButtons) {
super(userService, roleService);
this.serverListButtons = serverListButtons;
}
@Override
public SendMessage actionForAuth(User user, SendMessage message) {
return serverListButtons.uiForm(message);
}
}

View File

@@ -0,0 +1,67 @@
package ru.ldeloff.servermonitorbot.service.command.cputemp;
import lombok.extern.slf4j.Slf4j;
import org.springframework.stereotype.Service;
import org.telegram.telegrambots.meta.api.methods.send.SendMessage;
import ru.ldeloff.servermonitorbot.model.Command;
import ru.ldeloff.servermonitorbot.model.SshServer;
import ru.ldeloff.servermonitorbot.model.User;
import ru.ldeloff.servermonitorbot.service.command.CommandTemplate;
import ru.ldeloff.servermonitorbot.service.role.RoleService;
import ru.ldeloff.servermonitorbot.service.ssh.SshService;
import ru.ldeloff.servermonitorbot.service.user.UserService;
import ru.ldeloff.servermonitorbot.utils.SshServerUtils;
import java.util.Arrays;
import java.util.List;
import java.util.Objects;
import java.util.Optional;
@Service
@Slf4j
public class CpuTempCommand extends CommandTemplate {
final SshService sshService;
public CpuTempCommand(UserService userService, RoleService roleService, SshService sshService) {
super(userService, roleService);
this.sshService = sshService;
}
@Override
public SendMessage actionForAuth(User user, SendMessage message) {
String [] tags = Arrays.stream(message.getText().split(":"))
.map(String::trim)
.toArray(String[]::new);
if (tags[1].equals("all")) {
message.setText(hddTempAllHost());
} else {
message.setText(Objects.requireNonNull(hddTempSpecificHost(tags[1])));
}
return message;
}
private String hddTempAllHost() {
List<SshServer> servers = SshServerUtils.filterGoodServers(sshService.getSshServers());
StringBuilder response = new StringBuilder();
servers.forEach(server -> response.append(hddTempSpecificHost(server.getName())).append("\n"));
return response.toString();
}
private String hddTempSpecificHost(String serverName) {
Optional<SshServer> server = sshService.getSshServers()
.stream()
.filter(x -> x.getName().equals(serverName))
.findFirst();
if (server.isPresent()) {
Command result = sshService.execute(new Command("cat /sys/class/thermal/thermal_zone0/temp", 100, server.get()));
return server.get().getName() + ": \n" +
(Objects.isNull(result.getResponse()) ? "ошибка при выполнении команды" :
String.format("%.1f",
Double.parseDouble(result.getResponse().replaceAll("\n", ""))/1000))
+ "°C";
} else {
log.error("Ошибка при выполнении команды 'CPUtemp'. Искомый сервер (" + serverName + ") не найден");
return null;
}
}
}

View File

@@ -0,0 +1,24 @@
package ru.ldeloff.servermonitorbot.service.command.hddtemp;
import org.springframework.stereotype.Service;
import org.telegram.telegrambots.meta.api.methods.send.SendMessage;
import ru.ldeloff.servermonitorbot.model.User;
import ru.ldeloff.servermonitorbot.service.command.CommandTemplate;
import ru.ldeloff.servermonitorbot.service.role.RoleService;
import ru.ldeloff.servermonitorbot.service.user.UserService;
import ru.ldeloff.servermonitorbot.utils.ui.uname.ServerListButtons;
@Service
public class HddTempAggregateCommand extends CommandTemplate {
final ServerListButtons serverListButtons;
public HddTempAggregateCommand(UserService userService, RoleService roleService, ServerListButtons serverListButtons) {
super(userService, roleService);
this.serverListButtons = serverListButtons;
}
@Override
public SendMessage actionForAuth(User user, SendMessage message) {
return serverListButtons.uiForm(message);
}
}

View File

@@ -0,0 +1,64 @@
package ru.ldeloff.servermonitorbot.service.command.hddtemp;
import lombok.extern.slf4j.Slf4j;
import org.springframework.stereotype.Service;
import org.telegram.telegrambots.meta.api.methods.send.SendMessage;
import ru.ldeloff.servermonitorbot.model.Command;
import ru.ldeloff.servermonitorbot.model.SshServer;
import ru.ldeloff.servermonitorbot.model.User;
import ru.ldeloff.servermonitorbot.service.command.CommandTemplate;
import ru.ldeloff.servermonitorbot.service.role.RoleService;
import ru.ldeloff.servermonitorbot.service.ssh.SshService;
import ru.ldeloff.servermonitorbot.service.user.UserService;
import ru.ldeloff.servermonitorbot.utils.SshServerUtils;
import java.util.Arrays;
import java.util.List;
import java.util.Objects;
import java.util.Optional;
@Service
@Slf4j
public class HddTempCommand extends CommandTemplate {
final SshService sshService;
public HddTempCommand(UserService userService, RoleService roleService, SshService sshService) {
super(userService, roleService);
this.sshService = sshService;
}
@Override
public SendMessage actionForAuth(User user, SendMessage message) {
String [] tags = Arrays.stream(message.getText().split(":"))
.map(String::trim)
.toArray(String[]::new);
if (tags[1].equals("all")) {
message.setText(hddTempAllHost());
} else {
message.setText(Objects.requireNonNull(hddTempSpecificHost(tags[1])));
}
return message;
}
private String hddTempAllHost() {
List<SshServer> servers = SshServerUtils.filterGoodServers(sshService.getSshServers());
StringBuilder response = new StringBuilder();
servers.forEach(server -> response.append(hddTempSpecificHost(server.getName())).append("\n"));
return response.toString();
}
private String hddTempSpecificHost(String serverName) {
Optional<SshServer> server = sshService.getSshServers()
.stream()
.filter(x -> x.getName().equals(serverName))
.findFirst();
if (server.isPresent()) {
Command result = sshService.execute(new Command("hddtemp /dev/sd*", 500, server.get()));
return server.get().getName() + ": \n" +
(Objects.isNull(result.getResponse()) ? "ошибка при выполнении команды" : result.getResponse());
} else {
log.error("Ошибка при выполнении команды 'hddtemp'. Искомый сервер (" + serverName + ") не найден");
return null;
}
}
}

View File

@@ -0,0 +1,25 @@
package ru.ldeloff.servermonitorbot.service.command.mdadm;
import org.springframework.stereotype.Service;
import org.telegram.telegrambots.meta.api.methods.send.SendMessage;
import ru.ldeloff.servermonitorbot.model.User;
import ru.ldeloff.servermonitorbot.service.command.CommandTemplate;
import ru.ldeloff.servermonitorbot.service.role.RoleService;
import ru.ldeloff.servermonitorbot.service.user.UserService;
import ru.ldeloff.servermonitorbot.utils.ui.uname.ServerListButtons;
@Service
public class MdadmStatusAggregateCommand extends CommandTemplate {
final ServerListButtons serverListButtons;
public MdadmStatusAggregateCommand(UserService userService, RoleService roleService, ServerListButtons serverListButtons) {
super(userService, roleService);
this.serverListButtons = serverListButtons;
}
@Override
public SendMessage actionForAuth(User user, SendMessage message) {
return serverListButtons.uiForm(message);
}
}

View File

@@ -0,0 +1,100 @@
package ru.ldeloff.servermonitorbot.service.command.mdadm;
import lombok.extern.slf4j.Slf4j;
import org.springframework.stereotype.Service;
import org.telegram.telegrambots.meta.api.methods.send.SendMessage;
import ru.ldeloff.servermonitorbot.model.Command;
import ru.ldeloff.servermonitorbot.model.SshServer;
import ru.ldeloff.servermonitorbot.model.User;
import ru.ldeloff.servermonitorbot.service.command.CommandTemplate;
import ru.ldeloff.servermonitorbot.service.role.RoleService;
import ru.ldeloff.servermonitorbot.service.ssh.SshService;
import ru.ldeloff.servermonitorbot.service.user.UserService;
import ru.ldeloff.servermonitorbot.utils.SshServerUtils;
import java.util.*;
import java.util.regex.Matcher;
import java.util.regex.Pattern;
@Service
@Slf4j
public class MdadmStatusCommand extends CommandTemplate {
final SshService sshService;
public MdadmStatusCommand(UserService userService, RoleService roleService, SshService sshService) {
super(userService, roleService);
this.sshService = sshService;
}
@Override
public SendMessage actionForAuth(User user, SendMessage message) {
String [] tags = Arrays.stream(message.getText().split(":"))
.map(String::trim)
.toArray(String[]::new);
if (tags[1].equals("all")) {
message.setText(mdadmStatusAllHost());
} else {
message.setText(Objects.requireNonNull(mdadmStatusSpecificHost(tags[1])));
}
return message;
}
private String mdadmStatusAllHost() {
List<SshServer> servers = SshServerUtils.filterGoodServers(sshService.getSshServers());
StringBuilder response = new StringBuilder();
servers.forEach(server -> response.append(mdadmStatusSpecificHost(server.getName())).append("\n"));
return response.toString();
}
private String mdadmStatusSpecificHost(String serverName) {
Optional<SshServer> server = sshService.getSshServers()
.stream()
.filter(x -> x.getName().equals(serverName))
.findFirst();
if (server.isPresent()) {
// узнаю скок рейдов
Command commandRaid = sshService.execute(new Command("mdadm --monitor", 500, server.get()));
List<String> raidNames = parseRaidNames(commandRaid);
// Для каждого рейда надо выяснить статус
StringBuilder result = new StringBuilder();
raidNames.forEach(raid -> {
result.append(raid).append(":\n");
Command commandHdd = sshService.execute(new Command("mdadm --detail " + raid, 500, server.get()));
List<String> hdds = parseHddState(commandHdd);
hdds.forEach(hdd -> result.append(hdd).append("\n"));
});
return server.get().getName() + ": \n" + result;
} else {
log.error("Ошибка при выполнении команды 'mdadm'. Искомый сервер (" + serverName + ") не найден");
return null;
}
}
private List<String> parseRaidNames(Command result) {
String raidInfo = result.getResponse();
List<String> names = new ArrayList<>();
Arrays.stream(raidInfo.split("\n"))
.map(line -> line.split(" "))
.filter(lineArray -> lineArray.length >= 2)
.map(lineArray -> lineArray[1])
.forEach(names::add);
return names;
}
private List<String> parseHddState(Command result) {
String raidInfo = result.getResponse();
List<String> names = new ArrayList<>();
Pattern pattern = Pattern.compile("^\\s*(\\d+)\\s+\\d+\\s+\\d+\\s+\\d+\\s+\\w+\\s+(.+)$");
Matcher matcher = pattern.matcher(raidInfo);
while (matcher.find()) {
String number = matcher.group(1);
String state = matcher.group(2);
names.add("Number: " + number + ", State: " + state);
}
return names;
}
}

View File

@@ -6,19 +6,19 @@ import ru.ldeloff.servermonitorbot.model.User;
import ru.ldeloff.servermonitorbot.service.command.CommandTemplate; import ru.ldeloff.servermonitorbot.service.command.CommandTemplate;
import ru.ldeloff.servermonitorbot.service.role.RoleService; import ru.ldeloff.servermonitorbot.service.role.RoleService;
import ru.ldeloff.servermonitorbot.service.user.UserService; import ru.ldeloff.servermonitorbot.service.user.UserService;
import ru.ldeloff.servermonitorbot.utils.ui.uname.UnameChatButtonAggregate; import ru.ldeloff.servermonitorbot.utils.ui.uname.ServerListButtons;
@Service @Service
public class UnameAggregateCommand extends CommandTemplate { public class UnameAggregateCommand extends CommandTemplate {
final UnameChatButtonAggregate unameChatButtonAggregate; final ServerListButtons serverListButtons;
public UnameAggregateCommand(UserService userService, RoleService roleService, UnameChatButtonAggregate unameChatButtonAggregate) { public UnameAggregateCommand(UserService userService, RoleService roleService, ServerListButtons serverListButtons) {
super(userService, roleService); super(userService, roleService);
this.unameChatButtonAggregate = unameChatButtonAggregate; this.serverListButtons = serverListButtons;
} }
@Override @Override
public SendMessage actionForAuth(User user, SendMessage message) { public SendMessage actionForAuth(User user, SendMessage message) {
return unameChatButtonAggregate.uiForm(message); return serverListButtons.uiForm(message);
} }
} }

View File

@@ -13,6 +13,10 @@ import java.util.ArrayList;
public class TelegramBotKeyboard implements UiFormer { public class TelegramBotKeyboard implements UiFormer {
private final String STATUS = "Статус"; private final String STATUS = "Статус";
private final String UNAME = "uname"; private final String UNAME = "uname";
private final String CPU_TEMP = "CPU.temp";
private final String HDD_TEMP = "HDD.temp";
private final String MDADM = "MDADM";
@Override @Override
public SendMessage uiForm(SendMessage message) { public SendMessage uiForm(SendMessage message) {
@@ -27,6 +31,9 @@ public class TelegramBotKeyboard implements UiFormer {
keyboardRow.add(new KeyboardButton(STATUS)); keyboardRow.add(new KeyboardButton(STATUS));
keyboardRow.add(new KeyboardButton(UNAME)); keyboardRow.add(new KeyboardButton(UNAME));
keyboardRow.add(new KeyboardButton(CPU_TEMP));
keyboardRow.add(new KeyboardButton(HDD_TEMP));
keyboardRow.add(new KeyboardButton(MDADM));
replyKeyboardMarkup.setKeyboard(keyboardRows); replyKeyboardMarkup.setKeyboard(keyboardRows);
message.setReplyMarkup(replyKeyboardMarkup); message.setReplyMarkup(replyKeyboardMarkup);

View File

@@ -1,12 +1,10 @@
package ru.ldeloff.servermonitorbot.utils.ui.uname; package ru.ldeloff.servermonitorbot.utils.ui.uname;
import lombok.RequiredArgsConstructor; import lombok.RequiredArgsConstructor;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component; import org.springframework.stereotype.Component;
import org.telegram.telegrambots.meta.api.methods.send.SendMessage; import org.telegram.telegrambots.meta.api.methods.send.SendMessage;
import org.telegram.telegrambots.meta.api.objects.replykeyboard.InlineKeyboardMarkup; import org.telegram.telegrambots.meta.api.objects.replykeyboard.InlineKeyboardMarkup;
import org.telegram.telegrambots.meta.api.objects.replykeyboard.buttons.InlineKeyboardButton; import org.telegram.telegrambots.meta.api.objects.replykeyboard.buttons.InlineKeyboardButton;
import ru.ldeloff.servermonitorbot.repository.SshRepository;
import ru.ldeloff.servermonitorbot.service.ssh.SshService; import ru.ldeloff.servermonitorbot.service.ssh.SshService;
import ru.ldeloff.servermonitorbot.utils.ui.UiFormer; import ru.ldeloff.servermonitorbot.utils.ui.UiFormer;
@@ -16,7 +14,7 @@ import java.util.Objects;
@Component @Component
@RequiredArgsConstructor @RequiredArgsConstructor
public class UnameChatButtonAggregate implements UiFormer { public class ServerListButtons implements UiFormer {
private final SshService sshService; private final SshService sshService;
@@ -32,7 +30,7 @@ public class UnameChatButtonAggregate implements UiFormer {
List<InlineKeyboardButton> keyboardRow = new ArrayList<>(); List<InlineKeyboardButton> keyboardRow = new ArrayList<>();
InlineKeyboardButton inlineKeyboardButton = new InlineKeyboardButton(); InlineKeyboardButton inlineKeyboardButton = new InlineKeyboardButton();
inlineKeyboardButton.setText(sshServer.getName()); inlineKeyboardButton.setText(sshServer.getName());
inlineKeyboardButton.setCallbackData("uname: " + sshServer.getName()); inlineKeyboardButton.setCallbackData(message.getText() + ": " + sshServer.getName());
keyboardRow.add(inlineKeyboardButton); keyboardRow.add(inlineKeyboardButton);
keyboard.add(keyboardRow); keyboard.add(keyboardRow);
} }
@@ -43,14 +41,14 @@ public class UnameChatButtonAggregate implements UiFormer {
List<InlineKeyboardButton> keyboardRow = new ArrayList<>(); List<InlineKeyboardButton> keyboardRow = new ArrayList<>();
InlineKeyboardButton inlineKeyboardButton = new InlineKeyboardButton(); InlineKeyboardButton inlineKeyboardButton = new InlineKeyboardButton();
inlineKeyboardButton.setText("Все сервера"); inlineKeyboardButton.setText("Все сервера");
inlineKeyboardButton.setCallbackData("uname: all"); inlineKeyboardButton.setCallbackData(message.getText() + ": all");
keyboardRow.add(inlineKeyboardButton); keyboardRow.add(inlineKeyboardButton);
keyboard.add(keyboardRow); keyboard.add(keyboardRow);
} }
inlineKeyboardMarkup.setKeyboard(keyboard); inlineKeyboardMarkup.setKeyboard(keyboard);
message.setReplyMarkup(inlineKeyboardMarkup); message.setReplyMarkup(inlineKeyboardMarkup);
message.setText("Выполнить uname для"); message.setText("Выполнить " + message.getText() + " для");
return message; return message;
} }

View File

@@ -2,20 +2,14 @@ spring:
application: application:
name: ServerMonitorBot name: ServerMonitorBot
datasource: datasource:
url: jdbc:postgresql://localhost:5432/servermonitorbot url: jdbc:postgresql://db:5432/servermonitorbot
username: servermonitorbot username: servermonitorbot
password: servermonitorbot password: servermonitorbot
jpa: jpa:
hibernate: hibernate:
ddl-auto: none ddl-auto: none
liquibase: flyway:
enabled: true locations: classpath:db/migration
change-log: classpath:db/scripts/changelog-master.xml
url: jdbc:postgresql://localhost:5432/servermonitorbot
user: servermonitorbot
password: servermonitorbot
liquibase-schema: "liquibase"
default-schema: "servermonitorbot"
bot: bot:
name: "ServerMonitorBot" name: "ServerMonitorBot"
token: "token" token: "token"
@@ -30,6 +24,12 @@ ssh:
port: 22 port: 22
user: "user" user: "user"
password: "pass" password: "pass"
-
name: "Server Name 2"
host: "url 2"
port: 22
user: "user 2"
password: "pass 2"

View File

@@ -1,5 +1,3 @@
--liquibase formatted sql
--changeset L_DelOff:create_table_users rollbackSplitStatements:true --changeset L_DelOff:create_table_users rollbackSplitStatements:true
--comment: Создание таблицы пользователей --comment: Создание таблицы пользователей
CREATE TABLE users CREATE TABLE users

View File

@@ -1,5 +1,3 @@
--liquibase formatted sql
--changeset L_DelOff:create_table_roles rollbackSplitStatements:true --changeset L_DelOff:create_table_roles rollbackSplitStatements:true
--comment: Создание таблицы ролей --comment: Создание таблицы ролей
CREATE TABLE roles CREATE TABLE roles

View File

@@ -1,10 +0,0 @@
<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd">
<include file="release_0_0_1/changelog.xml" relativeToChangelogFile="true"/>
</databaseChangeLog>

View File

@@ -1,16 +0,0 @@
<?xml version="1.0" encoding="UTF-8"?>
<databaseChangeLog
xmlns="http://www.liquibase.org/xml/ns/dbchangelog"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd">
<include file="scripts/01_create_table_users.sql" relativeToChangelogFile="true"/>
<include file="scripts/02_create_table_roles.sql" relativeToChangelogFile="true"/>
<include file="scripts/03_add_FK_users_to_roles.sql" relativeToChangelogFile="true"/>
<include file="scripts/04_add_roles.sql" relativeToChangelogFile="true"/>
<include file="scripts/05_add_anonymous_role.sql" relativeToChangelogFile="true"/>
<include file="scripts/06_refactor_users_table.sql" relativeToChangelogFile="true"/>
<include file="scripts/07_refactor_roles_table.sql" relativeToChangelogFile="true"/>
<include file="scripts/08_add_roles.sql" relativeToChangelogFile="true"/>
</databaseChangeLog>