SpringCloud之搭建PiggyMetrics项目

PiggyMetrics项目下载地址&＃xff1a;https://github.com/sqshq/PiggyMetrics

一、修复host文件

打开c:\Windows\System32\Drivers\etc\hosts文件&＃xff0c;在文件最后&＃xff0c;添加如下代码&＃xff1a;

127.0.0.1 config registry auth-service rabbitmq account-service account-mongodb statistics-service statistics-mongodb notification-service notification-mongodb

二、MongoDB修改为MySQL

修改后的项目下载

MySQL数据库的SQL语句为&＃xff1a;

SET FOREIGN_KEY_CHECKS&＃61;0;

-- ----------------------------
-- Table structure for account
-- ----------------------------
DROP TABLE IF EXISTS &＃96;account&＃96;;
CREATE TABLE &＃96;account&＃96; (
  &＃96;name&＃96; varchar(255) NOT NULL,
  &＃96;last_seen&＃96; datetime DEFAULT NULL,
  &＃96;note&＃96; varchar(255) DEFAULT NULL,
  PRIMARY KEY (&＃96;name&＃96;)
) ENGINE&＃61;InnoDB DEFAULT CHARSET&＃61;utf8mb4;

-- ----------------------------
-- Table structure for item
-- ----------------------------
DROP TABLE IF EXISTS &＃96;item&＃96;;
CREATE TABLE &＃96;item&＃96; (
  &＃96;id&＃96; int(64) NOT NULL AUTO_INCREMENT,
  &＃96;account_name&＃96; varchar(255) NOT NULL COMMENT &＃39;用户名外键&＃39;,
  &＃96;title&＃96; varchar(255) DEFAULT NULL COMMENT &＃39;标题&＃39;,
  &＃96;amount&＃96; decimal(64,0) DEFAULT NULL COMMENT &＃39;合计&＃39;,
  &＃96;currency&＃96; int(64) DEFAULT NULL COMMENT &＃39;货币类型&＃39;,
  &＃96;period&＃96; int(64) DEFAULT NULL COMMENT &＃39;时间段&＃39;,
  &＃96;icon&＃96; varchar(255) DEFAULT NULL,
  &＃96;incomes_or_expenses&＃96; int(64) DEFAULT NULL,
  PRIMARY KEY (&＃96;id&＃96;)
) ENGINE&＃61;InnoDB AUTO_INCREMENT&＃61;12 DEFAULT CHARSET&＃61;utf8mb4;

-- ----------------------------
-- Table structure for saving
-- ----------------------------
DROP TABLE IF EXISTS &＃96;saving&＃96;;
CREATE TABLE &＃96;saving&＃96; (
  &＃96;id&＃96; int(11) NOT NULL AUTO_INCREMENT,
  &＃96;account_name&＃96; varchar(255) NOT NULL,
  &＃96;amount&＃96; decimal(64,0) DEFAULT &＃39;0&＃39; COMMENT &＃39;存款金额&＃39;,
  &＃96;currency&＃96; int(64) DEFAULT &＃39;1&＃39; COMMENT &＃39;货币类型(1: USD,2: EUR,3: RUB)&＃39;,
  &＃96;interest&＃96; decimal(64,0) DEFAULT &＃39;0&＃39; COMMENT &＃39;利息&＃39;,
  &＃96;deposit&＃96; int(1) DEFAULT &＃39;1&＃39;,
  &＃96;capitalization&＃96; int(1) DEFAULT &＃39;1&＃39;,
  PRIMARY KEY (&＃96;id&＃96;)
) ENGINE&＃61;InnoDB AUTO_INCREMENT&＃61;6 DEFAULT CHARSET&＃61;utf8mb4;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS &＃96;user&＃96;;
CREATE TABLE &＃96;user&＃96; (
  &＃96;username&＃96; varchar(255) NOT NULL,
  &＃96;password&＃96; varchar(255) NOT NULL,
  PRIMARY KEY (&＃96;username&＃96;)
) ENGINE&＃61;InnoDB DEFAULT CHARSET&＃61;utf8mb4;

config模块修改内容

config\src\main\resources\shared\account-service.yml文件中&＃xff1a;

config\src\main\resources\shared\auth-service.yml文件中&＃xff1a;

auth-service模块修改内容

auth-service\pom.xml

auth-service\src\main\java\com\piggymetrics\auth\domain\User.java

auth-service\src\main\java\com\piggymetrics\auth\AuthApplication.java

account-service模块修改内容

account-service\pom.xml

account-service\src\main\java\com\piggymetrics\account\domain\Account.java

account-service\src\main\java\com\piggymetrics\account\domain\Item.java

account-service\src\main\java\com\piggymetrics\account\domain\Saving.java

account-service\src\main\java\com\piggymetrics\account\service\AccountServiceImpl.java

新增account-service\src\main\java\com\piggymetrics\account\repository\ItemRepository.java

文件内容为:

package com.piggymetrics.account.repository;

import com.piggymetrics.account.domain.Item;

import org.springframework.data.repository.CrudRepository;

import org.springframework.stereotype.Repository;

&＃64;Repository

public interface ItemRepository extends CrudRepository {

}

新增account-service\src\main\java\com\piggymetrics\account\repository\SavingRepository.java

文件内容为:

package com.piggymetrics.account.repository;

import com.piggymetrics.account.domain.Saving;

import org.springframework.data.repository.CrudRepository;

import org.springframework.stereotype.Repository;

&＃64;Repository

public interface SavingRepository extends CrudRepository {

}

修改后的项目下载