mirror of
https://github.com/CarmJos/MineSQL.git
synced 2026-06-14 05:11:08 +08:00
Compare commits
1 Commits
| Author | SHA1 | Date | |
|---|---|---|---|
| 448e611708 |
@@ -1,41 +0,0 @@
|
|||||||
version: ${project.version} #配置文件版本,若与插件版本不同请记得检查配置文件内容
|
|
||||||
|
|
||||||
debug: false
|
|
||||||
|
|
||||||
# 统计数据设定
|
|
||||||
# 改选项用于帮助开发者统计插件版本与使用情况,且绝不会影响性能与使用体验。
|
|
||||||
# 当然,您也可以选择在这里关闭,或在plugins/bStats下的配置文件中关闭。
|
|
||||||
metrics: true
|
|
||||||
|
|
||||||
# 检查更新设定
|
|
||||||
# 该选项用于插件判断是否要检查更新,若您不希望插件检查更新并提示您,可以选择关闭。
|
|
||||||
# 检查更新为异步操作,绝不会影响性能与使用体验。
|
|
||||||
check-update: true
|
|
||||||
|
|
||||||
# 启用 Properties 文件配置
|
|
||||||
# 相关配置介绍(BeeCP) https://github.com/Chris2018998/BeeCP/wiki/Configuration--List#配置列表
|
|
||||||
properties:
|
|
||||||
# 该选项用于启用 Properties 配置读取,若您不希望插件启用 Properties 文件配置,可以选择关闭。
|
|
||||||
enable: true
|
|
||||||
# 文件夹路径,将读取该文件夹下的所有 .properties 文件,并以文件名为数据管理器名称。
|
|
||||||
# 读取时,将排除以 “.” 开头的文件与非 .properties 文件。
|
|
||||||
# 默认为 "db-properties/" 相对路径,指向“plugins/MineSQL/db-properties/”;
|
|
||||||
# 该选项也支持绝对路径,但使用绝对路径时,请务必注意权限问题。
|
|
||||||
folder: "db-properties/"
|
|
||||||
|
|
||||||
# 数据库源配置
|
|
||||||
# 目前支持的驱动类型(driver-type)有 mariadb、mysql 与 h2(文件数据库) 。
|
|
||||||
|
|
||||||
databases:
|
|
||||||
|
|
||||||
"example-mariadb": # 数据库源名称 不可包含“.” 以“example-”开头的数据源不会被加载
|
|
||||||
type: mariadb # MySQL / MariaDB 类型
|
|
||||||
host: 127.0.0.1 # 数据库地址
|
|
||||||
port: 3306 # 数据库端口
|
|
||||||
username: minecraft # 数据库用户名
|
|
||||||
password: password #数据库连接密码
|
|
||||||
database: minecraft #数据库名
|
|
||||||
|
|
||||||
"example-h2":
|
|
||||||
type: h2-file
|
|
||||||
file: "example.db" #数据库文件路径,相对于“plugins/MineSQL/db-files/”
|
|
||||||
@@ -1,9 +0,0 @@
|
|||||||
# MineSQL _(EasySQL Plugin)_ Javadoc
|
|
||||||
|
|
||||||
基于 [Github Pages](https://pages.github.com/) 搭建,请访问 [JavaDoc](https://carmjos.github.io/MineSQL) 。
|
|
||||||
|
|
||||||
## 如何实现?
|
|
||||||
|
|
||||||
若您也想通过 [Github Actions](https://docs.github.com/en/actions/learn-github-actions)
|
|
||||||
自动部署项目的Javadoc到 [Github Pages](https://pages.github.com/) ,
|
|
||||||
可以参考我的文章 [《自动部署Javadoc到Github Pages》](https://pages.carm.cc/doc/javadoc-in-github.html) 。
|
|
||||||
@@ -1,27 +0,0 @@
|
|||||||
# MineSQL Repository
|
|
||||||
|
|
||||||
采用github的repo分支进行依赖,随项目发布而自动更新。
|
|
||||||
|
|
||||||
其他依赖方式见主页介绍。
|
|
||||||
|
|
||||||
## 依赖方式
|
|
||||||
|
|
||||||
### Maven
|
|
||||||
|
|
||||||
```xml
|
|
||||||
<repositories>
|
|
||||||
<repository>
|
|
||||||
<id>MineSQL</id>
|
|
||||||
<name>GitHub Branch Repository</name>
|
|
||||||
<url>https://raw.githubusercontent.com/CarmJos/MineSQL/repo/</url>
|
|
||||||
</repository>
|
|
||||||
</repositories>
|
|
||||||
```
|
|
||||||
|
|
||||||
### Gradle
|
|
||||||
|
|
||||||
```groovy
|
|
||||||
repositories {
|
|
||||||
maven { url 'https://raw.githubusercontent.com/CarmJos/MineSQL/repo/' }
|
|
||||||
}
|
|
||||||
```
|
|
||||||
@@ -1,2 +0,0 @@
|
|||||||
github: [ CarmJos ]
|
|
||||||
custom: [ 'https://donate.carm.cc' ]
|
|
||||||
@@ -1,30 +0,0 @@
|
|||||||
---
|
|
||||||
name: 问题提交
|
|
||||||
about: 描述问题并提交,帮助我们对其进行检查与修复。
|
|
||||||
title: ''
|
|
||||||
labels: bug
|
|
||||||
assignees: ''
|
|
||||||
|
|
||||||
---
|
|
||||||
|
|
||||||
### **问题简述**
|
|
||||||
用简短的话语描述一下大概问题。
|
|
||||||
|
|
||||||
### **问题来源**
|
|
||||||
描述一下通过哪些操作才发现的问题,如:
|
|
||||||
1. 打开 '...'
|
|
||||||
2. 点击了 '....'
|
|
||||||
3. 出现了报错 '....'
|
|
||||||
|
|
||||||
### **预期结果**(可选)
|
|
||||||
如果问题不发生,应该是什么情况
|
|
||||||
|
|
||||||
### **问题截图/问题报错**
|
|
||||||
如果有报错或输出,请提供截图。
|
|
||||||
|
|
||||||
### *操作环境**
|
|
||||||
请在后台输入 `version` 并复制相关输出。
|
|
||||||
|
|
||||||
|
|
||||||
### **其他补充**
|
|
||||||
如有其他补充,可以在这里描述。
|
|
||||||
@@ -1,20 +0,0 @@
|
|||||||
---
|
|
||||||
name: 功能需求
|
|
||||||
about: 希望我们提供更多的功能。
|
|
||||||
title: ''
|
|
||||||
labels: enhancement
|
|
||||||
assignees: ''
|
|
||||||
|
|
||||||
---
|
|
||||||
|
|
||||||
### **功能简述**
|
|
||||||
简单的描述一下你想要的功能
|
|
||||||
|
|
||||||
### **需求来源**
|
|
||||||
简单的描述一下为什么需要这个功能。
|
|
||||||
|
|
||||||
### **功能参考**(可选)
|
|
||||||
如果有相关功能的参考,如文本、截图,请提供给我们。
|
|
||||||
|
|
||||||
### **附加内容**
|
|
||||||
如果有什么小细节需要重点注意,请在这里告诉我们。
|
|
||||||
@@ -1,70 +0,0 @@
|
|||||||
# For most projects, this workflow file will not need changing; you simply need
|
|
||||||
# to commit it to your repository.
|
|
||||||
#
|
|
||||||
# You may wish to alter this file to override the set of languages analyzed,
|
|
||||||
# or to provide custom queries or build logic.
|
|
||||||
#
|
|
||||||
# ******** NOTE ********
|
|
||||||
# We have attempted to detect the languages in your repository. Please check
|
|
||||||
# the `language` matrix defined below to confirm you have the correct set of
|
|
||||||
# supported CodeQL languages.
|
|
||||||
#
|
|
||||||
name: "CodeQL Analysis"
|
|
||||||
|
|
||||||
on:
|
|
||||||
push:
|
|
||||||
branches: [ master ]
|
|
||||||
pull_request:
|
|
||||||
# The branches below must be a subset of the branches above
|
|
||||||
branches: [ master ]
|
|
||||||
schedule:
|
|
||||||
- cron: '45 12 * * 1'
|
|
||||||
|
|
||||||
jobs:
|
|
||||||
analyze:
|
|
||||||
name: Analyze
|
|
||||||
runs-on: ubuntu-latest
|
|
||||||
permissions:
|
|
||||||
actions: read
|
|
||||||
contents: read
|
|
||||||
security-events: write
|
|
||||||
|
|
||||||
strategy:
|
|
||||||
fail-fast: false
|
|
||||||
matrix:
|
|
||||||
language: [ 'java' ]
|
|
||||||
# CodeQL supports [ 'cpp', 'csharp', 'go', 'java', 'javascript', 'python', 'ruby' ]
|
|
||||||
# Learn more about CodeQL language support at https://git.io/codeql-language-support
|
|
||||||
|
|
||||||
steps:
|
|
||||||
- name: Checkout repository
|
|
||||||
uses: actions/checkout@v6
|
|
||||||
|
|
||||||
# Initializes the CodeQL tools for scanning.
|
|
||||||
- name: Initialize CodeQL
|
|
||||||
uses: github/codeql-action/init@v4
|
|
||||||
with:
|
|
||||||
languages: ${{ matrix.language }}
|
|
||||||
# If you wish to specify custom queries, you can do so here or in a config file.
|
|
||||||
# By default, queries listed here will override any specified in a config file.
|
|
||||||
# Prefix the list here with "+" to use these queries and those in the config file.
|
|
||||||
# queries: ./path/to/local/query, your-org/your-repo/queries@main
|
|
||||||
|
|
||||||
# Autobuild attempts to build any compiled languages (C/C++, C#, or Java).
|
|
||||||
# If this step fails, then you should remove it and run the build manually (see below)
|
|
||||||
- name: Autobuild
|
|
||||||
uses: github/codeql-action/autobuild@v4
|
|
||||||
|
|
||||||
# ℹ️ Command-line programs to run using the OS shell.
|
|
||||||
# 📚 https://git.io/JvXDl
|
|
||||||
|
|
||||||
# ✏️ If the Autobuild fails above, remove it and uncomment the following three lines
|
|
||||||
# and modify them (or add more) to build your code if your project
|
|
||||||
# uses a compiled language
|
|
||||||
|
|
||||||
#- run: |
|
|
||||||
# make bootstrap
|
|
||||||
# make release
|
|
||||||
|
|
||||||
- name: Perform CodeQL Analysis
|
|
||||||
uses: github/codeql-action/analyze@v4
|
|
||||||
@@ -1,143 +0,0 @@
|
|||||||
name: "Deploy & Publish"
|
|
||||||
|
|
||||||
on:
|
|
||||||
# 支持手动触发构建
|
|
||||||
workflow_dispatch:
|
|
||||||
release:
|
|
||||||
# 创建release的时候触发
|
|
||||||
types: [ published ]
|
|
||||||
|
|
||||||
jobs:
|
|
||||||
packages-deploy:
|
|
||||||
name: "Deploy Project (GitHub Packages)"
|
|
||||||
runs-on: ubuntu-latest
|
|
||||||
|
|
||||||
steps:
|
|
||||||
- uses: actions/checkout@v6
|
|
||||||
- name: "Set up JDK"
|
|
||||||
uses: actions/setup-java@v5
|
|
||||||
with:
|
|
||||||
java-version: '11'
|
|
||||||
distribution: 'adopt'
|
|
||||||
cache: maven
|
|
||||||
server-id: github
|
|
||||||
server-username: MAVEN_USERNAME
|
|
||||||
server-password: MAVEN_TOKEN
|
|
||||||
gpg-private-key: ${{ secrets.MAVEN_GPG_PRIVATE_KEY }} # Value of the GPG private key to import
|
|
||||||
gpg-passphrase: MAVEN_GPG_PASSPHRASE # env variable for GPG private key passphrase
|
|
||||||
|
|
||||||
- name: "Maven Deploy"
|
|
||||||
run: mvn -B -Pgithub deploy --file pom.xml -DskipTests
|
|
||||||
env:
|
|
||||||
MAVEN_USERNAME: ${{ github.repository_owner }}
|
|
||||||
MAVEN_TOKEN: ${{secrets.GITHUB_TOKEN}}
|
|
||||||
MAVEN_GPG_PASSPHRASE: ${{ secrets.MAVEN_GPG_PASSPHRASE }}
|
|
||||||
|
|
||||||
- name: "Release Asset Upload"
|
|
||||||
id: upload-release-asset
|
|
||||||
uses: shogo82148/actions-upload-release-asset@v1
|
|
||||||
env:
|
|
||||||
GITHUB_TOKEN: ${{ secrets.GITHUB_TOKEN }}
|
|
||||||
with:
|
|
||||||
upload_url: ${{ github.event.release.upload_url }}
|
|
||||||
asset_path: ".asset/*.jar"
|
|
||||||
asset_content_type: application/java-archive
|
|
||||||
|
|
||||||
github-deploy:
|
|
||||||
name: "Deploy Project (GitHub Repo)"
|
|
||||||
runs-on: ubuntu-latest
|
|
||||||
steps:
|
|
||||||
- uses: actions/checkout@v6
|
|
||||||
- name: "Set up JDK"
|
|
||||||
uses: actions/setup-java@v5
|
|
||||||
with:
|
|
||||||
java-version: '11'
|
|
||||||
distribution: 'adopt'
|
|
||||||
cache: maven
|
|
||||||
|
|
||||||
- name: "Maven Deploy"
|
|
||||||
run: mvn -B -Plocal deploy --file pom.xml -DskipTests -Dgpg.skip
|
|
||||||
|
|
||||||
- name: "Copy artifacts"
|
|
||||||
run: |
|
|
||||||
rm -rf deploy
|
|
||||||
mkdir -vp deploy
|
|
||||||
cp -vrf $HOME/local-deploy/* deploy/
|
|
||||||
cp -vrf .doc/repository/REPO-README.md deploy/README.md
|
|
||||||
|
|
||||||
- name: "Copy Javadoc"
|
|
||||||
run: |
|
|
||||||
rm -rf docs
|
|
||||||
mkdir -vp docs
|
|
||||||
cp -vrf api/target/apidocs/* docs/
|
|
||||||
cp -vrf .doc/javadoc/JAVADOC-README.md docs/README.md
|
|
||||||
|
|
||||||
- name: "Generate Javadoc sitemap"
|
|
||||||
id: sitemap
|
|
||||||
uses: cicirello/generate-sitemap@v1
|
|
||||||
with:
|
|
||||||
base-url-path: https://${{ github.repository_owner }}.github.io/${{ github.event.repository.name }}
|
|
||||||
path-to-root: docs
|
|
||||||
|
|
||||||
- name: "Output Javadoc stats"
|
|
||||||
run: |
|
|
||||||
echo "sitemap-path = ${{ steps.sitemap.outputs.sitemap-path }}"
|
|
||||||
echo "url-count = ${{ steps.sitemap.outputs.url-count }}"
|
|
||||||
echo "excluded-count = ${{ steps.sitemap.outputs.excluded-count }}"
|
|
||||||
ls -l docs
|
|
||||||
|
|
||||||
- name: "Configure Git"
|
|
||||||
env:
|
|
||||||
DEPLOY_PRI: ${{secrets.DEPLOY_PRI}}
|
|
||||||
run: |
|
|
||||||
sudo timedatectl set-timezone "Asia/Shanghai"
|
|
||||||
mkdir -p ~/.ssh/
|
|
||||||
echo "$DEPLOY_PRI" > ~/.ssh/id_rsa
|
|
||||||
chmod 600 ~/.ssh/id_rsa
|
|
||||||
ssh-keyscan github.com >> ~/.ssh/known_hosts
|
|
||||||
git config --global user.name '${{ github.repository_owner }}'
|
|
||||||
git config --global user.email '${{ github.repository_owner }}@users.noreply.github.com'
|
|
||||||
|
|
||||||
- name: "Commit&Push repository files"
|
|
||||||
run: |
|
|
||||||
cd deploy
|
|
||||||
git init
|
|
||||||
git remote add origin git@github.com:${{ github.repository_owner }}/${{ github.event.repository.name }}.git
|
|
||||||
git checkout -b repo
|
|
||||||
git add -A
|
|
||||||
git commit -m "Maven project deployment."
|
|
||||||
git push origin HEAD:repo --force
|
|
||||||
|
|
||||||
- name: "Commit&Push API documentation"
|
|
||||||
run: |
|
|
||||||
cd docs
|
|
||||||
git init
|
|
||||||
git remote add origin git@github.com:${{ github.repository_owner }}/${{ github.event.repository.name }}.git
|
|
||||||
git checkout -b gh-pages
|
|
||||||
git add -A
|
|
||||||
git commit -m "API Document generated."
|
|
||||||
git push origin HEAD:gh-pages --force
|
|
||||||
|
|
||||||
central-deploy:
|
|
||||||
name: "Deploy Project (Central)"
|
|
||||||
runs-on: ubuntu-latest
|
|
||||||
steps:
|
|
||||||
- uses: actions/checkout@v6
|
|
||||||
- name: "Set up JDK"
|
|
||||||
uses: actions/setup-java@v5
|
|
||||||
with:
|
|
||||||
java-version: '11'
|
|
||||||
distribution: 'adopt'
|
|
||||||
cache: maven
|
|
||||||
server-id: ossrh
|
|
||||||
server-username: MAVEN_USERNAME
|
|
||||||
server-password: MAVEN_PASSWORD
|
|
||||||
gpg-private-key: ${{ secrets.MAVEN_GPG_PRIVATE_KEY }} # Value of the GPG private key to import
|
|
||||||
gpg-passphrase: MAVEN_GPG_PASSPHRASE # env variable for GPG private key passphrase
|
|
||||||
|
|
||||||
- name: "Central Deploy"
|
|
||||||
run: mvn -B -Possrh deploy --file pom.xml -DskipTests
|
|
||||||
env:
|
|
||||||
MAVEN_USERNAME: ${{ secrets.OSSRH_USER }}
|
|
||||||
MAVEN_PASSWORD: ${{ secrets.OSSRH_PASS }}
|
|
||||||
MAVEN_GPG_PASSPHRASE: ${{ secrets.MAVEN_GPG_PASSPHRASE }}
|
|
||||||
@@ -1,45 +0,0 @@
|
|||||||
# This workflow will build a Java project with Maven, and cache/restore any dependencies to improve the workflow execution time
|
|
||||||
# For more information see: https://help.github.com/actions/language-and-framework-guides/building-and-testing-java-with-maven
|
|
||||||
|
|
||||||
name: Build & Tests
|
|
||||||
|
|
||||||
on:
|
|
||||||
# 支持手动触发构建
|
|
||||||
workflow_dispatch:
|
|
||||||
pull_request:
|
|
||||||
push:
|
|
||||||
paths-ignore:
|
|
||||||
- ".github/**"
|
|
||||||
- "README.md"
|
|
||||||
- "LICENCE"
|
|
||||||
|
|
||||||
jobs:
|
|
||||||
build:
|
|
||||||
|
|
||||||
runs-on: ubuntu-latest
|
|
||||||
|
|
||||||
steps:
|
|
||||||
- uses: actions/checkout@v6
|
|
||||||
- name: "Set up JDK"
|
|
||||||
uses: actions/setup-java@v5
|
|
||||||
with:
|
|
||||||
java-version: '11'
|
|
||||||
distribution: 'adopt'
|
|
||||||
- name: "Package"
|
|
||||||
run: mvn -B package --file pom.xml -Dgpg.skip
|
|
||||||
|
|
||||||
- name: "Upload artifacts"
|
|
||||||
uses: actions/upload-artifact@v6
|
|
||||||
with:
|
|
||||||
name: artifacts
|
|
||||||
path: "**/target/"
|
|
||||||
retention-days: 5
|
|
||||||
include-hidden-files: true
|
|
||||||
|
|
||||||
- name: "Upload assets"
|
|
||||||
uses: actions/upload-artifact@v6
|
|
||||||
with:
|
|
||||||
name: assets
|
|
||||||
path: ".asset/"
|
|
||||||
retention-days: 5
|
|
||||||
include-hidden-files: true
|
|
||||||
@@ -1,7 +0,0 @@
|
|||||||
/.idea/
|
|
||||||
/target/
|
|
||||||
**/target/
|
|
||||||
./*.iml
|
|
||||||
*.iml
|
|
||||||
asset/
|
|
||||||
api-docs/
|
|
||||||
@@ -1,674 +0,0 @@
|
|||||||
GNU GENERAL PUBLIC LICENSE
|
|
||||||
Version 3, 29 June 2007
|
|
||||||
|
|
||||||
Copyright (C) 2007 Free Software Foundation, Inc. <https://fsf.org/>
|
|
||||||
Everyone is permitted to copy and distribute verbatim copies
|
|
||||||
of this license document, but changing it is not allowed.
|
|
||||||
|
|
||||||
Preamble
|
|
||||||
|
|
||||||
The GNU General Public License is a free, copyleft license for
|
|
||||||
software and other kinds of works.
|
|
||||||
|
|
||||||
The licenses for most software and other practical works are designed
|
|
||||||
to take away your freedom to share and change the works. By contrast,
|
|
||||||
the GNU General Public License is intended to guarantee your freedom to
|
|
||||||
share and change all versions of a program--to make sure it remains free
|
|
||||||
software for all its users. We, the Free Software Foundation, use the
|
|
||||||
GNU General Public License for most of our software; it applies also to
|
|
||||||
any other work released this way by its authors. You can apply it to
|
|
||||||
your programs, too.
|
|
||||||
|
|
||||||
When we speak of free software, we are referring to freedom, not
|
|
||||||
price. Our General Public Licenses are designed to make sure that you
|
|
||||||
have the freedom to distribute copies of free software (and charge for
|
|
||||||
them if you wish), that you receive source code or can get it if you
|
|
||||||
want it, that you can change the software or use pieces of it in new
|
|
||||||
free programs, and that you know you can do these things.
|
|
||||||
|
|
||||||
To protect your rights, we need to prevent others from denying you
|
|
||||||
these rights or asking you to surrender the rights. Therefore, you have
|
|
||||||
certain responsibilities if you distribute copies of the software, or if
|
|
||||||
you modify it: responsibilities to respect the freedom of others.
|
|
||||||
|
|
||||||
For example, if you distribute copies of such a program, whether
|
|
||||||
gratis or for a fee, you must pass on to the recipients the same
|
|
||||||
freedoms that you received. You must make sure that they, too, receive
|
|
||||||
or can get the source code. And you must show them these terms so they
|
|
||||||
know their rights.
|
|
||||||
|
|
||||||
Developers that use the GNU GPL protect your rights with two steps:
|
|
||||||
(1) assert copyright on the software, and (2) offer you this License
|
|
||||||
giving you legal permission to copy, distribute and/or modify it.
|
|
||||||
|
|
||||||
For the developers' and authors' protection, the GPL clearly explains
|
|
||||||
that there is no warranty for this free software. For both users' and
|
|
||||||
authors' sake, the GPL requires that modified versions be marked as
|
|
||||||
changed, so that their problems will not be attributed erroneously to
|
|
||||||
authors of previous versions.
|
|
||||||
|
|
||||||
Some devices are designed to deny users access to install or run
|
|
||||||
modified versions of the software inside them, although the manufacturer
|
|
||||||
can do so. This is fundamentally incompatible with the aim of
|
|
||||||
protecting users' freedom to change the software. The systematic
|
|
||||||
pattern of such abuse occurs in the area of products for individuals to
|
|
||||||
use, which is precisely where it is most unacceptable. Therefore, we
|
|
||||||
have designed this version of the GPL to prohibit the practice for those
|
|
||||||
products. If such problems arise substantially in other domains, we
|
|
||||||
stand ready to extend this provision to those domains in future versions
|
|
||||||
of the GPL, as needed to protect the freedom of users.
|
|
||||||
|
|
||||||
Finally, every program is threatened constantly by software patents.
|
|
||||||
States should not allow patents to restrict development and use of
|
|
||||||
software on general-purpose computers, but in those that do, we wish to
|
|
||||||
avoid the special danger that patents applied to a free program could
|
|
||||||
make it effectively proprietary. To prevent this, the GPL assures that
|
|
||||||
patents cannot be used to render the program non-free.
|
|
||||||
|
|
||||||
The precise terms and conditions for copying, distribution and
|
|
||||||
modification follow.
|
|
||||||
|
|
||||||
TERMS AND CONDITIONS
|
|
||||||
|
|
||||||
0. Definitions.
|
|
||||||
|
|
||||||
"This License" refers to version 3 of the GNU General Public License.
|
|
||||||
|
|
||||||
"Copyright" also means copyright-like laws that apply to other kinds of
|
|
||||||
works, such as semiconductor masks.
|
|
||||||
|
|
||||||
"The Program" refers to any copyrightable work licensed under this
|
|
||||||
License. Each licensee is addressed as "you". "Licensees" and
|
|
||||||
"recipients" may be individuals or organizations.
|
|
||||||
|
|
||||||
To "modify" a work means to copy from or adapt all or part of the work
|
|
||||||
in a fashion requiring copyright permission, other than the making of an
|
|
||||||
exact copy. The resulting work is called a "modified version" of the
|
|
||||||
earlier work or a work "based on" the earlier work.
|
|
||||||
|
|
||||||
A "covered work" means either the unmodified Program or a work based
|
|
||||||
on the Program.
|
|
||||||
|
|
||||||
To "propagate" a work means to do anything with it that, without
|
|
||||||
permission, would make you directly or secondarily liable for
|
|
||||||
infringement under applicable copyright law, except executing it on a
|
|
||||||
computer or modifying a private copy. Propagation includes copying,
|
|
||||||
distribution (with or without modification), making available to the
|
|
||||||
public, and in some countries other activities as well.
|
|
||||||
|
|
||||||
To "convey" a work means any kind of propagation that enables other
|
|
||||||
parties to make or receive copies. Mere interaction with a user through
|
|
||||||
a computer network, with no transfer of a copy, is not conveying.
|
|
||||||
|
|
||||||
An interactive user interface displays "Appropriate Legal Notices"
|
|
||||||
to the extent that it includes a convenient and prominently visible
|
|
||||||
feature that (1) displays an appropriate copyright notice, and (2)
|
|
||||||
tells the user that there is no warranty for the work (except to the
|
|
||||||
extent that warranties are provided), that licensees may convey the
|
|
||||||
work under this License, and how to view a copy of this License. If
|
|
||||||
the interface presents a list of user commands or options, such as a
|
|
||||||
menu, a prominent item in the list meets this criterion.
|
|
||||||
|
|
||||||
1. Source Code.
|
|
||||||
|
|
||||||
The "source code" for a work means the preferred form of the work
|
|
||||||
for making modifications to it. "Object code" means any non-source
|
|
||||||
form of a work.
|
|
||||||
|
|
||||||
A "Standard Interface" means an interface that either is an official
|
|
||||||
standard defined by a recognized standards body, or, in the case of
|
|
||||||
interfaces specified for a particular programming language, one that
|
|
||||||
is widely used among developers working in that language.
|
|
||||||
|
|
||||||
The "System Libraries" of an executable work include anything, other
|
|
||||||
than the work as a whole, that (a) is included in the normal form of
|
|
||||||
packaging a Major Component, but which is not part of that Major
|
|
||||||
Component, and (b) serves only to enable use of the work with that
|
|
||||||
Major Component, or to implement a Standard Interface for which an
|
|
||||||
implementation is available to the public in source code form. A
|
|
||||||
"Major Component", in this context, means a major essential component
|
|
||||||
(kernel, window system, and so on) of the specific operating system
|
|
||||||
(if any) on which the executable work runs, or a compiler used to
|
|
||||||
produce the work, or an object code interpreter used to run it.
|
|
||||||
|
|
||||||
The "Corresponding Source" for a work in object code form means all
|
|
||||||
the source code needed to generate, install, and (for an executable
|
|
||||||
work) run the object code and to modify the work, including scripts to
|
|
||||||
control those activities. However, it does not include the work's
|
|
||||||
System Libraries, or general-purpose tools or generally available free
|
|
||||||
programs which are used unmodified in performing those activities but
|
|
||||||
which are not part of the work. For example, Corresponding Source
|
|
||||||
includes interface definition files associated with source files for
|
|
||||||
the work, and the source code for shared libraries and dynamically
|
|
||||||
linked subprograms that the work is specifically designed to require,
|
|
||||||
such as by intimate data communication or control flow between those
|
|
||||||
subprograms and other parts of the work.
|
|
||||||
|
|
||||||
The Corresponding Source need not include anything that users
|
|
||||||
can regenerate automatically from other parts of the Corresponding
|
|
||||||
Source.
|
|
||||||
|
|
||||||
The Corresponding Source for a work in source code form is that
|
|
||||||
same work.
|
|
||||||
|
|
||||||
2. Basic Permissions.
|
|
||||||
|
|
||||||
All rights granted under this License are granted for the term of
|
|
||||||
copyright on the Program, and are irrevocable provided the stated
|
|
||||||
conditions are met. This License explicitly affirms your unlimited
|
|
||||||
permission to run the unmodified Program. The output from running a
|
|
||||||
covered work is covered by this License only if the output, given its
|
|
||||||
content, constitutes a covered work. This License acknowledges your
|
|
||||||
rights of fair use or other equivalent, as provided by copyright law.
|
|
||||||
|
|
||||||
You may make, run and propagate covered works that you do not
|
|
||||||
convey, without conditions so long as your license otherwise remains
|
|
||||||
in force. You may convey covered works to others for the sole purpose
|
|
||||||
of having them make modifications exclusively for you, or provide you
|
|
||||||
with facilities for running those works, provided that you comply with
|
|
||||||
the terms of this License in conveying all material for which you do
|
|
||||||
not control copyright. Those thus making or running the covered works
|
|
||||||
for you must do so exclusively on your behalf, under your direction
|
|
||||||
and control, on terms that prohibit them from making any copies of
|
|
||||||
your copyrighted material outside their relationship with you.
|
|
||||||
|
|
||||||
Conveying under any other circumstances is permitted solely under
|
|
||||||
the conditions stated below. Sublicensing is not allowed; section 10
|
|
||||||
makes it unnecessary.
|
|
||||||
|
|
||||||
3. Protecting Users' Legal Rights From Anti-Circumvention Law.
|
|
||||||
|
|
||||||
No covered work shall be deemed part of an effective technological
|
|
||||||
measure under any applicable law fulfilling obligations under article
|
|
||||||
11 of the WIPO copyright treaty adopted on 20 December 1996, or
|
|
||||||
similar laws prohibiting or restricting circumvention of such
|
|
||||||
measures.
|
|
||||||
|
|
||||||
When you convey a covered work, you waive any legal power to forbid
|
|
||||||
circumvention of technological measures to the extent such circumvention
|
|
||||||
is effected by exercising rights under this License with respect to
|
|
||||||
the covered work, and you disclaim any intention to limit operation or
|
|
||||||
modification of the work as a means of enforcing, against the work's
|
|
||||||
users, your or third parties' legal rights to forbid circumvention of
|
|
||||||
technological measures.
|
|
||||||
|
|
||||||
4. Conveying Verbatim Copies.
|
|
||||||
|
|
||||||
You may convey verbatim copies of the Program's source code as you
|
|
||||||
receive it, in any medium, provided that you conspicuously and
|
|
||||||
appropriately publish on each copy an appropriate copyright notice;
|
|
||||||
keep intact all notices stating that this License and any
|
|
||||||
non-permissive terms added in accord with section 7 apply to the code;
|
|
||||||
keep intact all notices of the absence of any warranty; and give all
|
|
||||||
recipients a copy of this License along with the Program.
|
|
||||||
|
|
||||||
You may charge any price or no price for each copy that you convey,
|
|
||||||
and you may offer support or warranty protection for a fee.
|
|
||||||
|
|
||||||
5. Conveying Modified Source Versions.
|
|
||||||
|
|
||||||
You may convey a work based on the Program, or the modifications to
|
|
||||||
produce it from the Program, in the form of source code under the
|
|
||||||
terms of section 4, provided that you also meet all of these conditions:
|
|
||||||
|
|
||||||
a) The work must carry prominent notices stating that you modified
|
|
||||||
it, and giving a relevant date.
|
|
||||||
|
|
||||||
b) The work must carry prominent notices stating that it is
|
|
||||||
released under this License and any conditions added under section
|
|
||||||
7. This requirement modifies the requirement in section 4 to
|
|
||||||
"keep intact all notices".
|
|
||||||
|
|
||||||
c) You must license the entire work, as a whole, under this
|
|
||||||
License to anyone who comes into possession of a copy. This
|
|
||||||
License will therefore apply, along with any applicable section 7
|
|
||||||
additional terms, to the whole of the work, and all its parts,
|
|
||||||
regardless of how they are packaged. This License gives no
|
|
||||||
permission to license the work in any other way, but it does not
|
|
||||||
invalidate such permission if you have separately received it.
|
|
||||||
|
|
||||||
d) If the work has interactive user interfaces, each must display
|
|
||||||
Appropriate Legal Notices; however, if the Program has interactive
|
|
||||||
interfaces that do not display Appropriate Legal Notices, your
|
|
||||||
work need not make them do so.
|
|
||||||
|
|
||||||
A compilation of a covered work with other separate and independent
|
|
||||||
works, which are not by their nature extensions of the covered work,
|
|
||||||
and which are not combined with it such as to form a larger program,
|
|
||||||
in or on a volume of a storage or distribution medium, is called an
|
|
||||||
"aggregate" if the compilation and its resulting copyright are not
|
|
||||||
used to limit the access or legal rights of the compilation's users
|
|
||||||
beyond what the individual works permit. Inclusion of a covered work
|
|
||||||
in an aggregate does not cause this License to apply to the other
|
|
||||||
parts of the aggregate.
|
|
||||||
|
|
||||||
6. Conveying Non-Source Forms.
|
|
||||||
|
|
||||||
You may convey a covered work in object code form under the terms
|
|
||||||
of sections 4 and 5, provided that you also convey the
|
|
||||||
machine-readable Corresponding Source under the terms of this License,
|
|
||||||
in one of these ways:
|
|
||||||
|
|
||||||
a) Convey the object code in, or embodied in, a physical product
|
|
||||||
(including a physical distribution medium), accompanied by the
|
|
||||||
Corresponding Source fixed on a durable physical medium
|
|
||||||
customarily used for software interchange.
|
|
||||||
|
|
||||||
b) Convey the object code in, or embodied in, a physical product
|
|
||||||
(including a physical distribution medium), accompanied by a
|
|
||||||
written offer, valid for at least three years and valid for as
|
|
||||||
long as you offer spare parts or customer support for that product
|
|
||||||
model, to give anyone who possesses the object code either (1) a
|
|
||||||
copy of the Corresponding Source for all the software in the
|
|
||||||
product that is covered by this License, on a durable physical
|
|
||||||
medium customarily used for software interchange, for a price no
|
|
||||||
more than your reasonable cost of physically performing this
|
|
||||||
conveying of source, or (2) access to copy the
|
|
||||||
Corresponding Source from a network server at no charge.
|
|
||||||
|
|
||||||
c) Convey individual copies of the object code with a copy of the
|
|
||||||
written offer to provide the Corresponding Source. This
|
|
||||||
alternative is allowed only occasionally and noncommercially, and
|
|
||||||
only if you received the object code with such an offer, in accord
|
|
||||||
with subsection 6b.
|
|
||||||
|
|
||||||
d) Convey the object code by offering access from a designated
|
|
||||||
place (gratis or for a charge), and offer equivalent access to the
|
|
||||||
Corresponding Source in the same way through the same place at no
|
|
||||||
further charge. You need not require recipients to copy the
|
|
||||||
Corresponding Source along with the object code. If the place to
|
|
||||||
copy the object code is a network server, the Corresponding Source
|
|
||||||
may be on a different server (operated by you or a third party)
|
|
||||||
that supports equivalent copying facilities, provided you maintain
|
|
||||||
clear directions next to the object code saying where to find the
|
|
||||||
Corresponding Source. Regardless of what server hosts the
|
|
||||||
Corresponding Source, you remain obligated to ensure that it is
|
|
||||||
available for as long as needed to satisfy these requirements.
|
|
||||||
|
|
||||||
e) Convey the object code using peer-to-peer transmission, provided
|
|
||||||
you inform other peers where the object code and Corresponding
|
|
||||||
Source of the work are being offered to the general public at no
|
|
||||||
charge under subsection 6d.
|
|
||||||
|
|
||||||
A separable portion of the object code, whose source code is excluded
|
|
||||||
from the Corresponding Source as a System Library, need not be
|
|
||||||
included in conveying the object code work.
|
|
||||||
|
|
||||||
A "User Product" is either (1) a "consumer product", which means any
|
|
||||||
tangible personal property which is normally used for personal, family,
|
|
||||||
or household purposes, or (2) anything designed or sold for incorporation
|
|
||||||
into a dwelling. In determining whether a product is a consumer product,
|
|
||||||
doubtful cases shall be resolved in favor of coverage. For a particular
|
|
||||||
product received by a particular user, "normally used" refers to a
|
|
||||||
typical or common use of that class of product, regardless of the status
|
|
||||||
of the particular user or of the way in which the particular user
|
|
||||||
actually uses, or expects or is expected to use, the product. A product
|
|
||||||
is a consumer product regardless of whether the product has substantial
|
|
||||||
commercial, industrial or non-consumer uses, unless such uses represent
|
|
||||||
the only significant mode of use of the product.
|
|
||||||
|
|
||||||
"Installation Information" for a User Product means any methods,
|
|
||||||
procedures, authorization keys, or other information required to install
|
|
||||||
and execute modified versions of a covered work in that User Product from
|
|
||||||
a modified version of its Corresponding Source. The information must
|
|
||||||
suffice to ensure that the continued functioning of the modified object
|
|
||||||
code is in no case prevented or interfered with solely because
|
|
||||||
modification has been made.
|
|
||||||
|
|
||||||
If you convey an object code work under this section in, or with, or
|
|
||||||
specifically for use in, a User Product, and the conveying occurs as
|
|
||||||
part of a transaction in which the right of possession and use of the
|
|
||||||
User Product is transferred to the recipient in perpetuity or for a
|
|
||||||
fixed term (regardless of how the transaction is characterized), the
|
|
||||||
Corresponding Source conveyed under this section must be accompanied
|
|
||||||
by the Installation Information. But this requirement does not apply
|
|
||||||
if neither you nor any third party retains the ability to install
|
|
||||||
modified object code on the User Product (for example, the work has
|
|
||||||
been installed in ROM).
|
|
||||||
|
|
||||||
The requirement to provide Installation Information does not include a
|
|
||||||
requirement to continue to provide support service, warranty, or updates
|
|
||||||
for a work that has been modified or installed by the recipient, or for
|
|
||||||
the User Product in which it has been modified or installed. Access to a
|
|
||||||
network may be denied when the modification itself materially and
|
|
||||||
adversely affects the operation of the network or violates the rules and
|
|
||||||
protocols for communication across the network.
|
|
||||||
|
|
||||||
Corresponding Source conveyed, and Installation Information provided,
|
|
||||||
in accord with this section must be in a format that is publicly
|
|
||||||
documented (and with an implementation available to the public in
|
|
||||||
source code form), and must require no special password or key for
|
|
||||||
unpacking, reading or copying.
|
|
||||||
|
|
||||||
7. Additional Terms.
|
|
||||||
|
|
||||||
"Additional permissions" are terms that supplement the terms of this
|
|
||||||
License by making exceptions from one or more of its conditions.
|
|
||||||
Additional permissions that are applicable to the entire Program shall
|
|
||||||
be treated as though they were included in this License, to the extent
|
|
||||||
that they are valid under applicable law. If additional permissions
|
|
||||||
apply only to part of the Program, that part may be used separately
|
|
||||||
under those permissions, but the entire Program remains governed by
|
|
||||||
this License without regard to the additional permissions.
|
|
||||||
|
|
||||||
When you convey a copy of a covered work, you may at your option
|
|
||||||
remove any additional permissions from that copy, or from any part of
|
|
||||||
it. (Additional permissions may be written to require their own
|
|
||||||
removal in certain cases when you modify the work.) You may place
|
|
||||||
additional permissions on material, added by you to a covered work,
|
|
||||||
for which you have or can give appropriate copyright permission.
|
|
||||||
|
|
||||||
Notwithstanding any other provision of this License, for material you
|
|
||||||
add to a covered work, you may (if authorized by the copyright holders of
|
|
||||||
that material) supplement the terms of this License with terms:
|
|
||||||
|
|
||||||
a) Disclaiming warranty or limiting liability differently from the
|
|
||||||
terms of sections 15 and 16 of this License; or
|
|
||||||
|
|
||||||
b) Requiring preservation of specified reasonable legal notices or
|
|
||||||
author attributions in that material or in the Appropriate Legal
|
|
||||||
Notices displayed by works containing it; or
|
|
||||||
|
|
||||||
c) Prohibiting misrepresentation of the origin of that material, or
|
|
||||||
requiring that modified versions of such material be marked in
|
|
||||||
reasonable ways as different from the original version; or
|
|
||||||
|
|
||||||
d) Limiting the use for publicity purposes of names of licensors or
|
|
||||||
authors of the material; or
|
|
||||||
|
|
||||||
e) Declining to grant rights under trademark law for use of some
|
|
||||||
trade names, trademarks, or service marks; or
|
|
||||||
|
|
||||||
f) Requiring indemnification of licensors and authors of that
|
|
||||||
material by anyone who conveys the material (or modified versions of
|
|
||||||
it) with contractual assumptions of liability to the recipient, for
|
|
||||||
any liability that these contractual assumptions directly impose on
|
|
||||||
those licensors and authors.
|
|
||||||
|
|
||||||
All other non-permissive additional terms are considered "further
|
|
||||||
restrictions" within the meaning of section 10. If the Program as you
|
|
||||||
received it, or any part of it, contains a notice stating that it is
|
|
||||||
governed by this License along with a term that is a further
|
|
||||||
restriction, you may remove that term. If a license document contains
|
|
||||||
a further restriction but permits relicensing or conveying under this
|
|
||||||
License, you may add to a covered work material governed by the terms
|
|
||||||
of that license document, provided that the further restriction does
|
|
||||||
not survive such relicensing or conveying.
|
|
||||||
|
|
||||||
If you add terms to a covered work in accord with this section, you
|
|
||||||
must place, in the relevant source files, a statement of the
|
|
||||||
additional terms that apply to those files, or a notice indicating
|
|
||||||
where to find the applicable terms.
|
|
||||||
|
|
||||||
Additional terms, permissive or non-permissive, may be stated in the
|
|
||||||
form of a separately written license, or stated as exceptions;
|
|
||||||
the above requirements apply either way.
|
|
||||||
|
|
||||||
8. Termination.
|
|
||||||
|
|
||||||
You may not propagate or modify a covered work except as expressly
|
|
||||||
provided under this License. Any attempt otherwise to propagate or
|
|
||||||
modify it is void, and will automatically terminate your rights under
|
|
||||||
this License (including any patent licenses granted under the third
|
|
||||||
paragraph of section 11).
|
|
||||||
|
|
||||||
However, if you cease all violation of this License, then your
|
|
||||||
license from a particular copyright holder is reinstated (a)
|
|
||||||
provisionally, unless and until the copyright holder explicitly and
|
|
||||||
finally terminates your license, and (b) permanently, if the copyright
|
|
||||||
holder fails to notify you of the violation by some reasonable means
|
|
||||||
prior to 60 days after the cessation.
|
|
||||||
|
|
||||||
Moreover, your license from a particular copyright holder is
|
|
||||||
reinstated permanently if the copyright holder notifies you of the
|
|
||||||
violation by some reasonable means, this is the first time you have
|
|
||||||
received notice of violation of this License (for any work) from that
|
|
||||||
copyright holder, and you cure the violation prior to 30 days after
|
|
||||||
your receipt of the notice.
|
|
||||||
|
|
||||||
Termination of your rights under this section does not terminate the
|
|
||||||
licenses of parties who have received copies or rights from you under
|
|
||||||
this License. If your rights have been terminated and not permanently
|
|
||||||
reinstated, you do not qualify to receive new licenses for the same
|
|
||||||
material under section 10.
|
|
||||||
|
|
||||||
9. Acceptance Not Required for Having Copies.
|
|
||||||
|
|
||||||
You are not required to accept this License in order to receive or
|
|
||||||
run a copy of the Program. Ancillary propagation of a covered work
|
|
||||||
occurring solely as a consequence of using peer-to-peer transmission
|
|
||||||
to receive a copy likewise does not require acceptance. However,
|
|
||||||
nothing other than this License grants you permission to propagate or
|
|
||||||
modify any covered work. These actions infringe copyright if you do
|
|
||||||
not accept this License. Therefore, by modifying or propagating a
|
|
||||||
covered work, you indicate your acceptance of this License to do so.
|
|
||||||
|
|
||||||
10. Automatic Licensing of Downstream Recipients.
|
|
||||||
|
|
||||||
Each time you convey a covered work, the recipient automatically
|
|
||||||
receives a license from the original licensors, to run, modify and
|
|
||||||
propagate that work, subject to this License. You are not responsible
|
|
||||||
for enforcing compliance by third parties with this License.
|
|
||||||
|
|
||||||
An "entity transaction" is a transaction transferring control of an
|
|
||||||
organization, or substantially all assets of one, or subdividing an
|
|
||||||
organization, or merging organizations. If propagation of a covered
|
|
||||||
work results from an entity transaction, each party to that
|
|
||||||
transaction who receives a copy of the work also receives whatever
|
|
||||||
licenses to the work the party's predecessor in interest had or could
|
|
||||||
give under the previous paragraph, plus a right to possession of the
|
|
||||||
Corresponding Source of the work from the predecessor in interest, if
|
|
||||||
the predecessor has it or can get it with reasonable efforts.
|
|
||||||
|
|
||||||
You may not impose any further restrictions on the exercise of the
|
|
||||||
rights granted or affirmed under this License. For example, you may
|
|
||||||
not impose a license fee, royalty, or other charge for exercise of
|
|
||||||
rights granted under this License, and you may not initiate litigation
|
|
||||||
(including a cross-claim or counterclaim in a lawsuit) alleging that
|
|
||||||
any patent claim is infringed by making, using, selling, offering for
|
|
||||||
sale, or importing the Program or any portion of it.
|
|
||||||
|
|
||||||
11. Patents.
|
|
||||||
|
|
||||||
A "contributor" is a copyright holder who authorizes use under this
|
|
||||||
License of the Program or a work on which the Program is based. The
|
|
||||||
work thus licensed is called the contributor's "contributor version".
|
|
||||||
|
|
||||||
A contributor's "essential patent claims" are all patent claims
|
|
||||||
owned or controlled by the contributor, whether already acquired or
|
|
||||||
hereafter acquired, that would be infringed by some manner, permitted
|
|
||||||
by this License, of making, using, or selling its contributor version,
|
|
||||||
but do not include claims that would be infringed only as a
|
|
||||||
consequence of further modification of the contributor version. For
|
|
||||||
purposes of this definition, "control" includes the right to grant
|
|
||||||
patent sublicenses in a manner consistent with the requirements of
|
|
||||||
this License.
|
|
||||||
|
|
||||||
Each contributor grants you a non-exclusive, worldwide, royalty-free
|
|
||||||
patent license under the contributor's essential patent claims, to
|
|
||||||
make, use, sell, offer for sale, import and otherwise run, modify and
|
|
||||||
propagate the contents of its contributor version.
|
|
||||||
|
|
||||||
In the following three paragraphs, a "patent license" is any express
|
|
||||||
agreement or commitment, however denominated, not to enforce a patent
|
|
||||||
(such as an express permission to practice a patent or covenant not to
|
|
||||||
sue for patent infringement). To "grant" such a patent license to a
|
|
||||||
party means to make such an agreement or commitment not to enforce a
|
|
||||||
patent against the party.
|
|
||||||
|
|
||||||
If you convey a covered work, knowingly relying on a patent license,
|
|
||||||
and the Corresponding Source of the work is not available for anyone
|
|
||||||
to copy, free of charge and under the terms of this License, through a
|
|
||||||
publicly available network server or other readily accessible means,
|
|
||||||
then you must either (1) cause the Corresponding Source to be so
|
|
||||||
available, or (2) arrange to deprive yourself of the benefit of the
|
|
||||||
patent license for this particular work, or (3) arrange, in a manner
|
|
||||||
consistent with the requirements of this License, to extend the patent
|
|
||||||
license to downstream recipients. "Knowingly relying" means you have
|
|
||||||
actual knowledge that, but for the patent license, your conveying the
|
|
||||||
covered work in a country, or your recipient's use of the covered work
|
|
||||||
in a country, would infringe one or more identifiable patents in that
|
|
||||||
country that you have reason to believe are valid.
|
|
||||||
|
|
||||||
If, pursuant to or in connection with a single transaction or
|
|
||||||
arrangement, you convey, or propagate by procuring conveyance of, a
|
|
||||||
covered work, and grant a patent license to some of the parties
|
|
||||||
receiving the covered work authorizing them to use, propagate, modify
|
|
||||||
or convey a specific copy of the covered work, then the patent license
|
|
||||||
you grant is automatically extended to all recipients of the covered
|
|
||||||
work and works based on it.
|
|
||||||
|
|
||||||
A patent license is "discriminatory" if it does not include within
|
|
||||||
the scope of its coverage, prohibits the exercise of, or is
|
|
||||||
conditioned on the non-exercise of one or more of the rights that are
|
|
||||||
specifically granted under this License. You may not convey a covered
|
|
||||||
work if you are a party to an arrangement with a third party that is
|
|
||||||
in the business of distributing software, under which you make payment
|
|
||||||
to the third party based on the extent of your activity of conveying
|
|
||||||
the work, and under which the third party grants, to any of the
|
|
||||||
parties who would receive the covered work from you, a discriminatory
|
|
||||||
patent license (a) in connection with copies of the covered work
|
|
||||||
conveyed by you (or copies made from those copies), or (b) primarily
|
|
||||||
for and in connection with specific products or compilations that
|
|
||||||
contain the covered work, unless you entered into that arrangement,
|
|
||||||
or that patent license was granted, prior to 28 March 2007.
|
|
||||||
|
|
||||||
Nothing in this License shall be construed as excluding or limiting
|
|
||||||
any implied license or other defenses to infringement that may
|
|
||||||
otherwise be available to you under applicable patent law.
|
|
||||||
|
|
||||||
12. No Surrender of Others' Freedom.
|
|
||||||
|
|
||||||
If conditions are imposed on you (whether by court order, agreement or
|
|
||||||
otherwise) that contradict the conditions of this License, they do not
|
|
||||||
excuse you from the conditions of this License. If you cannot convey a
|
|
||||||
covered work so as to satisfy simultaneously your obligations under this
|
|
||||||
License and any other pertinent obligations, then as a consequence you may
|
|
||||||
not convey it at all. For example, if you agree to terms that obligate you
|
|
||||||
to collect a royalty for further conveying from those to whom you convey
|
|
||||||
the Program, the only way you could satisfy both those terms and this
|
|
||||||
License would be to refrain entirely from conveying the Program.
|
|
||||||
|
|
||||||
13. Use with the GNU Affero General Public License.
|
|
||||||
|
|
||||||
Notwithstanding any other provision of this License, you have
|
|
||||||
permission to link or combine any covered work with a work licensed
|
|
||||||
under version 3 of the GNU Affero General Public License into a single
|
|
||||||
combined work, and to convey the resulting work. The terms of this
|
|
||||||
License will continue to apply to the part which is the covered work,
|
|
||||||
but the special requirements of the GNU Affero General Public License,
|
|
||||||
section 13, concerning interaction through a network will apply to the
|
|
||||||
combination as such.
|
|
||||||
|
|
||||||
14. Revised Versions of this License.
|
|
||||||
|
|
||||||
The Free Software Foundation may publish revised and/or new versions of
|
|
||||||
the GNU General Public License from time to time. Such new versions will
|
|
||||||
be similar in spirit to the present version, but may differ in detail to
|
|
||||||
address new problems or concerns.
|
|
||||||
|
|
||||||
Each version is given a distinguishing version number. If the
|
|
||||||
Program specifies that a certain numbered version of the GNU General
|
|
||||||
Public License "or any later version" applies to it, you have the
|
|
||||||
option of following the terms and conditions either of that numbered
|
|
||||||
version or of any later version published by the Free Software
|
|
||||||
Foundation. If the Program does not specify a version number of the
|
|
||||||
GNU General Public License, you may choose any version ever published
|
|
||||||
by the Free Software Foundation.
|
|
||||||
|
|
||||||
If the Program specifies that a proxy can decide which future
|
|
||||||
versions of the GNU General Public License can be used, that proxy's
|
|
||||||
public statement of acceptance of a version permanently authorizes you
|
|
||||||
to choose that version for the Program.
|
|
||||||
|
|
||||||
Later license versions may give you additional or different
|
|
||||||
permissions. However, no additional obligations are imposed on any
|
|
||||||
author or copyright holder as a result of your choosing to follow a
|
|
||||||
later version.
|
|
||||||
|
|
||||||
15. Disclaimer of Warranty.
|
|
||||||
|
|
||||||
THERE IS NO WARRANTY FOR THE PROGRAM, TO THE EXTENT PERMITTED BY
|
|
||||||
APPLICABLE LAW. EXCEPT WHEN OTHERWISE STATED IN WRITING THE COPYRIGHT
|
|
||||||
HOLDERS AND/OR OTHER PARTIES PROVIDE THE PROGRAM "AS IS" WITHOUT WARRANTY
|
|
||||||
OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING, BUT NOT LIMITED TO,
|
|
||||||
THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
|
|
||||||
PURPOSE. THE ENTIRE RISK AS TO THE QUALITY AND PERFORMANCE OF THE PROGRAM
|
|
||||||
IS WITH YOU. SHOULD THE PROGRAM PROVE DEFECTIVE, YOU ASSUME THE COST OF
|
|
||||||
ALL NECESSARY SERVICING, REPAIR OR CORRECTION.
|
|
||||||
|
|
||||||
16. Limitation of Liability.
|
|
||||||
|
|
||||||
IN NO EVENT UNLESS REQUIRED BY APPLICABLE LAW OR AGREED TO IN WRITING
|
|
||||||
WILL ANY COPYRIGHT HOLDER, OR ANY OTHER PARTY WHO MODIFIES AND/OR CONVEYS
|
|
||||||
THE PROGRAM AS PERMITTED ABOVE, BE LIABLE TO YOU FOR DAMAGES, INCLUDING ANY
|
|
||||||
GENERAL, SPECIAL, INCIDENTAL OR CONSEQUENTIAL DAMAGES ARISING OUT OF THE
|
|
||||||
USE OR INABILITY TO USE THE PROGRAM (INCLUDING BUT NOT LIMITED TO LOSS OF
|
|
||||||
DATA OR DATA BEING RENDERED INACCURATE OR LOSSES SUSTAINED BY YOU OR THIRD
|
|
||||||
PARTIES OR A FAILURE OF THE PROGRAM TO OPERATE WITH ANY OTHER PROGRAMS),
|
|
||||||
EVEN IF SUCH HOLDER OR OTHER PARTY HAS BEEN ADVISED OF THE POSSIBILITY OF
|
|
||||||
SUCH DAMAGES.
|
|
||||||
|
|
||||||
17. Interpretation of Sections 15 and 16.
|
|
||||||
|
|
||||||
If the disclaimer of warranty and limitation of liability provided
|
|
||||||
above cannot be given local legal effect according to their terms,
|
|
||||||
reviewing courts shall apply local law that most closely approximates
|
|
||||||
an absolute waiver of all civil liability in connection with the
|
|
||||||
Program, unless a warranty or assumption of liability accompanies a
|
|
||||||
copy of the Program in return for a fee.
|
|
||||||
|
|
||||||
END OF TERMS AND CONDITIONS
|
|
||||||
|
|
||||||
How to Apply These Terms to Your New Programs
|
|
||||||
|
|
||||||
If you develop a new program, and you want it to be of the greatest
|
|
||||||
possible use to the public, the best way to achieve this is to make it
|
|
||||||
free software which everyone can redistribute and change under these terms.
|
|
||||||
|
|
||||||
To do so, attach the following notices to the program. It is safest
|
|
||||||
to attach them to the start of each source file to most effectively
|
|
||||||
state the exclusion of warranty; and each file should have at least
|
|
||||||
the "copyright" line and a pointer to where the full notice is found.
|
|
||||||
|
|
||||||
<one line to give the program's name and a brief idea of what it does.>
|
|
||||||
Copyright (C) <year> <name of author>
|
|
||||||
|
|
||||||
This program is free software: you can redistribute it and/or modify
|
|
||||||
it under the terms of the GNU General Public License as published by
|
|
||||||
the Free Software Foundation, either version 3 of the License, or
|
|
||||||
(at your option) any later version.
|
|
||||||
|
|
||||||
This program is distributed in the hope that it will be useful,
|
|
||||||
but WITHOUT ANY WARRANTY; without even the implied warranty of
|
|
||||||
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
|
||||||
GNU General Public License for more details.
|
|
||||||
|
|
||||||
You should have received a copy of the GNU General Public License
|
|
||||||
along with this program. If not, see <https://www.gnu.org/licenses/>.
|
|
||||||
|
|
||||||
Also add information on how to contact you by electronic and paper mail.
|
|
||||||
|
|
||||||
If the program does terminal interaction, make it output a short
|
|
||||||
notice like this when it starts in an interactive mode:
|
|
||||||
|
|
||||||
<program> Copyright (C) <year> <name of author>
|
|
||||||
This program comes with ABSOLUTELY NO WARRANTY; for details type `show w'.
|
|
||||||
This is free software, and you are welcome to redistribute it
|
|
||||||
under certain conditions; type `show c' for details.
|
|
||||||
|
|
||||||
The hypothetical commands `show w' and `show c' should show the appropriate
|
|
||||||
parts of the General Public License. Of course, your program's commands
|
|
||||||
might be different; for a GUI interface, you would use an "about box".
|
|
||||||
|
|
||||||
You should also get your employer (if you work as a programmer) or school,
|
|
||||||
if any, to sign a "copyright disclaimer" for the program, if necessary.
|
|
||||||
For more information on this, and how to apply and follow the GNU GPL, see
|
|
||||||
<https://www.gnu.org/licenses/>.
|
|
||||||
|
|
||||||
The GNU General Public License does not permit incorporating your program
|
|
||||||
into proprietary programs. If your program is a subroutine library, you
|
|
||||||
may consider it more useful to permit linking proprietary applications with
|
|
||||||
the library. If this is what you want to do, use the GNU Lesser General
|
|
||||||
Public License instead of this License. But first, please read
|
|
||||||
<https://www.gnu.org/licenses/why-not-lgpl.html>.
|
|
||||||
@@ -1,244 +1,27 @@
|
|||||||
```text
|
# MineSQL Repository
|
||||||
__ ____ ________ __
|
|
||||||
/ |/ (_)__ ___ / __/ __ \ / /
|
|
||||||
/ /|_/ / / _ \/ -_)\ \/ /_/ / / /__
|
|
||||||
/_/ /_/_/_//_/\__/___/\___\_\/____/
|
|
||||||
#MineSQL (EasySQL-Plugin)
|
|
||||||
```
|
|
||||||
|
|
||||||
# MineSQL (EasySQL-Plugin)
|
采用github的repo分支进行依赖,随项目发布而自动更新。
|
||||||
|
|
||||||
[](https://github.com/CarmJos/MineSQL/releases)
|
其他依赖方式见主页介绍。
|
||||||
[](https://opensource.org/licenses/GPL-3.0)
|
|
||||||
[](https://github.com/CarmJos/MineSQL/actions/workflows/maven.yml)
|
|
||||||

|
|
||||||
[](https://www.codefactor.io/repository/github/carmjos/minesql)
|
|
||||||

|
|
||||||
|
|
||||||
轻松(用)SQL的独立运行库插件,支持多种服务端,适用于MineCraft全版本。
|
## 依赖方式
|
||||||
|
|
||||||
## 优势
|
### Maven
|
||||||
|
|
||||||
### 对于服主 (插件使用者)
|
|
||||||
|
|
||||||
- 统一配置数据库连接,避免重复配置费时费力分神。
|
|
||||||
- 支持更高级更全面的配置方式,以根据不同的使
|
|
||||||
用场景独立优化[连接池配置](https://github.com/Chris2018998/BeeCP/wiki/Configuration--List)。
|
|
||||||
- 使相关插件共用连接池,避免每个插件单独新开连接池导致资源的浪费。
|
|
||||||
|
|
||||||
### 对于插件开发者
|
|
||||||
|
|
||||||
- 基于 [EasySQL](https://github.com/CarmJos/EasySQL) 进行快捷的数据库操作。
|
|
||||||
- 通过 `MineSQL.getRegistry().get(database-name)` 快捷获取数据源,避免繁琐的链接过程。
|
|
||||||
- 详细的 DEBUG 方法,找到可恶的错误究竟在哪。
|
|
||||||
- 不再需要打包各类JDBC-Driver、连接池依赖以及EasySQL本体到插件中。
|
|
||||||
|
|
||||||
### 额外提醒
|
|
||||||
|
|
||||||
- 使用本依赖时,请保证其他插件的来源安全,避免可能带来的数据安全风险。
|
|
||||||
|
|
||||||
## 安装
|
|
||||||
|
|
||||||
1. 从 [Releases(发行)](https://github.com/CarmJos/MineSQL/releases/)
|
|
||||||
中点击 [最新版](https://github.com/CarmJos/MineSQL/releases/latest) 下载 `MineSQL-x.y.z.jar` 。
|
|
||||||
2. 将下载的 `MineSQL-x.y.z.jar` 放入服务器 `plugins/` 文件夹下。
|
|
||||||
3. 启动服务器,预加载配置文件后关闭服务器。
|
|
||||||
4. 修改 `plugins/MineSQL/config.yml` 以配置您的数据库选项。
|
|
||||||
5. 启动服务器,若配置无误,则您会看到 MineSQL一切正常的提示消息。
|
|
||||||
|
|
||||||
## 配置
|
|
||||||
|
|
||||||
### 插件配置文件 [`config.yml`](.doc/example-config.yml)
|
|
||||||
|
|
||||||
完整示例配置请见 [示例配置文件](.doc/example-config.yml)。
|
|
||||||
|
|
||||||
#### MySQL/MariaDB 数据源详细配置示例
|
|
||||||
|
|
||||||
```yaml
|
|
||||||
sources:
|
|
||||||
"mysql-database": # 数据源ID,建议全英文小写并以“-”分隔,例如:hello-minecraft
|
|
||||||
# 数据库驱动类型
|
|
||||||
# 若您的数据库为 mariadb,则强烈推荐设置为 mariadb
|
|
||||||
type: mysql
|
|
||||||
host: 127.0.0.1 # 数据库地址
|
|
||||||
port: 3306 # 数据库端口
|
|
||||||
database: minecraft # 数据库库名
|
|
||||||
username: db-user # 数据库用户名
|
|
||||||
password: 1234567 #数据库连接密码
|
|
||||||
```
|
|
||||||
|
|
||||||
#### h2 数据源详细配置示例
|
|
||||||
|
|
||||||
```yaml
|
|
||||||
sources:
|
|
||||||
# h2数据库运行模式
|
|
||||||
# 可选 h2-file(文件模式) 与 h2-mem(内存模式)
|
|
||||||
# 文件模式下,须指定 file路径 ,以服务器运行目录为基准,支持绝对路径和相对路径。
|
|
||||||
# 内存模式下,所有数据库都将存储在内存中,一旦关服则数据将全部丢失,该模式一般用于测试
|
|
||||||
"h2-file-db": # 数据源ID,建议全小写以“-”分隔,例如:hello-minecraft
|
|
||||||
type: h2-file
|
|
||||||
file-path: "db-files/minecraft"
|
|
||||||
"h2-mem-db": # 数据源ID,建议全小写以“-”分隔,例如:hello-minecraft
|
|
||||||
type: h2-mem
|
|
||||||
```
|
|
||||||
|
|
||||||
### Properties 配置文件 [`<插件目录>/db-properties/*.properties`](core/src/main/resources/db-properties/.example-mysql.properties)
|
|
||||||
|
|
||||||
示例配置请见 [示例MySQL数据源Properties](core/src/main/resources/db-properties/.example-mysql.properties)。
|
|
||||||
|
|
||||||
Properties 文件的文件名几位数据源的ID,允许为英文、数字、下划线、短横线;请不要包含中文、其他特殊符号与空格,以`.`开头的文件将被忽略。
|
|
||||||
|
|
||||||
该功能一般用于专业开发者使用,若您不了解该功能,请尽量使用config.yml中提供的配置方式,简单便捷,能够满足大多数需求。
|
|
||||||
|
|
||||||
更多帮助详见 [BeeCP项目帮助](https://github.com/Chris2018998/BeeCP) 。
|
|
||||||
|
|
||||||
## 指令
|
|
||||||
|
|
||||||
插件主指令为 `/minesql` ,所有指令只允许后台执行。
|
|
||||||
|
|
||||||
```text
|
|
||||||
# help
|
|
||||||
- 查看插件指令帮助。
|
|
||||||
|
|
||||||
# version
|
|
||||||
- 查看当前插件、核心库(EasySQL)与连接池依赖版本。
|
|
||||||
|
|
||||||
# list
|
|
||||||
- 列出当前所有的数据源管理器与相关信息。
|
|
||||||
|
|
||||||
# info <数据源名称>
|
|
||||||
- 查看指定数据源的统计信息与当前仍未关闭的查询。
|
|
||||||
```
|
|
||||||
|
|
||||||
## 开发
|
|
||||||
|
|
||||||
### 依赖方式
|
|
||||||
|
|
||||||
<details>
|
|
||||||
<summary>展开查看 Maven 依赖方式</summary>
|
|
||||||
|
|
||||||
```xml
|
```xml
|
||||||
|
<repositories>
|
||||||
<project>
|
<repository>
|
||||||
<repositories>
|
<id>MineSQL</id>
|
||||||
|
<name>GitHub Branch Repository</name>
|
||||||
<repository>
|
<url>https://raw.githubusercontent.com/CarmJos/MineSQL/repo/</url>
|
||||||
<!--采用Maven中心库,安全稳定,但版本更新需要等待同步-->
|
</repository>
|
||||||
<id>maven</id>
|
</repositories>
|
||||||
<name>Maven Central</name>
|
|
||||||
<url>https://repo1.maven.org/maven2</url>
|
|
||||||
</repository>
|
|
||||||
|
|
||||||
<repository>
|
|
||||||
<!--采用github分支依赖库,稳定更新快-->
|
|
||||||
<id>MineSQL</id>
|
|
||||||
<name>GitHub Branch Repository</name>
|
|
||||||
<url>https://raw.githubusercontent.com/CarmJos/MineSQL/repo/</url>
|
|
||||||
</repository>
|
|
||||||
|
|
||||||
<repository>
|
|
||||||
<!--采用我的私人依赖库,简单方便,但可能因为变故而无法使用-->
|
|
||||||
<id>carm-repo</id>
|
|
||||||
<name>Carm's Repo</name>
|
|
||||||
<url>https://repo.carm.cc/repository/maven-public/</url>
|
|
||||||
</repository>
|
|
||||||
|
|
||||||
</repositories>
|
|
||||||
|
|
||||||
<dependencies>
|
|
||||||
|
|
||||||
<dependency>
|
|
||||||
<groupId>cc.carm.plugin</groupId>
|
|
||||||
<artifactId>minesql-api</artifactId>
|
|
||||||
<version>[LATEST RELEASE]</version>
|
|
||||||
<scope>provided</scope>
|
|
||||||
</dependency>
|
|
||||||
|
|
||||||
</dependencies>
|
|
||||||
</project>
|
|
||||||
```
|
```
|
||||||
|
|
||||||
</details>
|
### Gradle
|
||||||
|
|
||||||
<details>
|
|
||||||
<summary>展开查看 Gradle 依赖方式</summary>
|
|
||||||
|
|
||||||
```groovy
|
```groovy
|
||||||
repositories {
|
repositories {
|
||||||
|
|
||||||
//采用Maven中心库,安全稳定,但版本更新需要等待同步
|
|
||||||
mavenCentral()
|
|
||||||
|
|
||||||
// 采用github分支依赖库,稳定更新快
|
|
||||||
maven { url 'https://raw.githubusercontent.com/CarmJos/MineSQL/repo/' }
|
maven { url 'https://raw.githubusercontent.com/CarmJos/MineSQL/repo/' }
|
||||||
|
|
||||||
// 采用我的私人依赖库,简单方便,但可能因为变故而无法使用
|
|
||||||
maven { url 'https://repo.carm.cc/repository/maven-public/' }
|
|
||||||
}
|
}
|
||||||
|
```
|
||||||
dependencies {
|
|
||||||
compileOnly "cc.carm.plugin:minesql-api:[LATEST RELEASE]"
|
|
||||||
}
|
|
||||||
```
|
|
||||||
|
|
||||||
</details>
|
|
||||||
|
|
||||||
### 操作示例
|
|
||||||
|
|
||||||
本插件接口入口类为 `MineSQL` ,更多方法详见 [MineSQL-Javadoc](https://carmjos.github.io/MineSQL/) 。
|
|
||||||
|
|
||||||
关于 EasySQL的使用方法,请详见 [EasySQL开发文档](https://github.com/CarmJos/EasySQL/tree/master/.documentation) 。
|
|
||||||
|
|
||||||
|
|
||||||
<details>
|
|
||||||
<summary>点击查看简单实例</summary>
|
|
||||||
|
|
||||||
```java
|
|
||||||
|
|
||||||
public class Main extends JavaPlugin {
|
|
||||||
|
|
||||||
@Override
|
|
||||||
public void onEnable() {
|
|
||||||
|
|
||||||
SQLManager manager = MineSQL.getRegistery().get(getConfig().getString("database"));
|
|
||||||
|
|
||||||
if (manager == null) {
|
|
||||||
System.out.println("请配置一个正确的数据库名。");
|
|
||||||
setEnabled(false);
|
|
||||||
return;
|
|
||||||
}
|
|
||||||
|
|
||||||
// do something...
|
|
||||||
|
|
||||||
}
|
|
||||||
|
|
||||||
}
|
|
||||||
|
|
||||||
```
|
|
||||||
|
|
||||||
</details>
|
|
||||||
|
|
||||||
## 开源协议
|
|
||||||
|
|
||||||
本项目源码采用 [GNU General Public License v3.0](https://opensource.org/licenses/GPL-3.0) 开源协议。
|
|
||||||
|
|
||||||
<details>
|
|
||||||
<summary>关于 GPL 协议</summary>
|
|
||||||
|
|
||||||
> GNU General Public Licence (GPL) 有可能是开源界最常用的许可模式。GPL 保证了所有开发者的权利,同时为使用者提供了足够的复制,分发,修改的权利:
|
|
||||||
>
|
|
||||||
> #### 可自由复制
|
|
||||||
> 你可以将软件复制到你的电脑,你客户的电脑,或者任何地方。复制份数没有任何限制。
|
|
||||||
> #### 可自由分发
|
|
||||||
> 在你的网站提供下载,拷贝到U盘送人,或者将源代码打印出来从窗户扔出去(环保起见,请别这样做)。
|
|
||||||
> #### 可以用来盈利
|
|
||||||
> 你可以在分发软件的时候收费,但你必须在收费前向你的客户提供该软件的 GNU GPL 许可协议,以便让他们知道,他们可以从别的渠道免费得到这份软件,以及你收费的理由。
|
|
||||||
> #### 可自由修改
|
|
||||||
> 如果你想添加或删除某个功能,没问题,如果你想在别的项目中使用部分代码,也没问题,唯一的要求是,使用了这段代码的项目也必须使用
|
|
||||||
> GPL 协议。
|
|
||||||
>
|
|
||||||
> 需要注意的是,分发的时候,需要明确提供源代码和二进制文件,另外,用于某些程序的某些协议有一些问题和限制,你可以看一下
|
|
||||||
> @PierreJoye 写的 Practical Guide to GPL Compliance 一文。使用 GPL 协议,你必须在源代码代码中包含相应信息,以及协议本身。
|
|
||||||
>
|
|
||||||
> *以上文字来自 [五种开源协议GPL,LGPL,BSD,MIT,Apache](https://www.oschina.net/question/54100_9455) 。*
|
|
||||||
</details>
|
|
||||||
@@ -1,80 +0,0 @@
|
|||||||
package cc.carm.plugin.minesql;
|
|
||||||
|
|
||||||
import cc.carm.lib.easysql.api.SQLManager;
|
|
||||||
import cc.carm.lib.easysql.api.SQLQuery;
|
|
||||||
import cc.carm.plugin.minesql.api.SQLRegistry;
|
|
||||||
import cc.carm.plugin.minesql.api.source.SQLSourceConfig;
|
|
||||||
import cc.carm.plugin.minesql.api.table.SQLTablesRoot;
|
|
||||||
import cc.carm.plugin.minesql.api.table.SimpleSQLTable;
|
|
||||||
import org.jetbrains.annotations.NotNull;
|
|
||||||
import org.jetbrains.annotations.Nullable;
|
|
||||||
|
|
||||||
import javax.sql.DataSource;
|
|
||||||
import java.io.File;
|
|
||||||
import java.util.Map;
|
|
||||||
import java.util.Properties;
|
|
||||||
import java.util.UUID;
|
|
||||||
import java.util.function.Consumer;
|
|
||||||
import java.util.logging.Logger;
|
|
||||||
|
|
||||||
interface IMineSQL {
|
|
||||||
|
|
||||||
@NotNull File getPluginFolder();
|
|
||||||
|
|
||||||
default @NotNull File getSourceFolder() {
|
|
||||||
return new File(getPluginFolder(), "db-files");
|
|
||||||
}
|
|
||||||
|
|
||||||
@NotNull Logger getLogger();
|
|
||||||
|
|
||||||
@NotNull SQLRegistry getRegistry();
|
|
||||||
|
|
||||||
@NotNull SQLRegistry createRegistry();
|
|
||||||
|
|
||||||
/**
|
|
||||||
* 创建一个新的 SQLManager 实例
|
|
||||||
*
|
|
||||||
* @param name 实例名称
|
|
||||||
* @param configuration SQLManager 实例的配置
|
|
||||||
* @return {@link SQLManager} 实例
|
|
||||||
* @throws Exception 若创建失败则抛出异常
|
|
||||||
*/
|
|
||||||
@NotNull SQLManager create(@NotNull String name,
|
|
||||||
@NotNull SQLSourceConfig configuration) throws Exception;
|
|
||||||
|
|
||||||
/**
|
|
||||||
* 创建一个新的 SQLManager 实例
|
|
||||||
*
|
|
||||||
* @param name 实例名称
|
|
||||||
* @param properties SQLManager 实例的配置文件
|
|
||||||
* @return {@link SQLManager} 实例
|
|
||||||
* @throws Exception 若创建失败则抛出异常
|
|
||||||
*/
|
|
||||||
@NotNull SQLManager create(@NotNull String name,
|
|
||||||
@NotNull Properties properties) throws Exception;
|
|
||||||
|
|
||||||
@NotNull SQLManager create(@NotNull String name, @NotNull DataSource source) throws Exception;
|
|
||||||
|
|
||||||
/**
|
|
||||||
* 终止并关闭一个 SQLManager 实例。
|
|
||||||
*
|
|
||||||
* @param manager SQLManager实例
|
|
||||||
* @param activeQueries 终止前仍未被关闭的SQLQuery列表
|
|
||||||
*/
|
|
||||||
void shutdown(SQLManager manager, @Nullable Consumer<Map<UUID, SQLQuery>> activeQueries);
|
|
||||||
|
|
||||||
/**
|
|
||||||
* 读取一个 {@link SQLTablesRoot} 中全部的 {@link SimpleSQLTable} 实例并初始化。
|
|
||||||
*
|
|
||||||
* @param tablesRoot {@link SQLTablesRoot}实例
|
|
||||||
*/
|
|
||||||
void createTables(@NotNull SQLTablesRoot tablesRoot) throws Exception;
|
|
||||||
|
|
||||||
/**
|
|
||||||
* 读取一个 {@link SQLTablesRoot}类中 中全部的静态 {@link SimpleSQLTable} 实例并初始化。
|
|
||||||
*
|
|
||||||
* @param tablesRootClazz {@link SQLTablesRoot}静态类
|
|
||||||
*/
|
|
||||||
void createTables(@NotNull Class<? extends SQLTablesRoot> tablesRootClazz) throws Exception;
|
|
||||||
|
|
||||||
}
|
|
||||||
@@ -1,145 +0,0 @@
|
|||||||
package cc.carm.plugin.minesql;
|
|
||||||
|
|
||||||
import cc.carm.lib.easysql.api.SQLManager;
|
|
||||||
import cc.carm.lib.easysql.api.SQLQuery;
|
|
||||||
import cc.carm.plugin.minesql.api.SQLRegistry;
|
|
||||||
import cc.carm.plugin.minesql.api.source.SQLSourceConfig;
|
|
||||||
import cc.carm.plugin.minesql.api.table.SQLTablesRoot;
|
|
||||||
import cc.carm.plugin.minesql.api.table.SimpleSQLTable;
|
|
||||||
import org.jetbrains.annotations.ApiStatus;
|
|
||||||
import org.jetbrains.annotations.NotNull;
|
|
||||||
import org.jetbrains.annotations.Nullable;
|
|
||||||
|
|
||||||
import javax.sql.DataSource;
|
|
||||||
import java.io.File;
|
|
||||||
import java.util.Map;
|
|
||||||
import java.util.Properties;
|
|
||||||
import java.util.UUID;
|
|
||||||
import java.util.function.Consumer;
|
|
||||||
import java.util.logging.Logger;
|
|
||||||
|
|
||||||
public class MineSQL {
|
|
||||||
|
|
||||||
private MineSQL() {
|
|
||||||
throw new UnsupportedOperationException("API Instance");
|
|
||||||
}
|
|
||||||
|
|
||||||
private static IMineSQL instance;
|
|
||||||
|
|
||||||
@ApiStatus.Internal
|
|
||||||
@SuppressWarnings("ClassEscapesDefinedScope")
|
|
||||||
protected static void initializeAPI(@NotNull IMineSQL api) {
|
|
||||||
MineSQL.instance = api;
|
|
||||||
}
|
|
||||||
|
|
||||||
public static Logger getLogger() {
|
|
||||||
return instance.getLogger();
|
|
||||||
}
|
|
||||||
|
|
||||||
/**
|
|
||||||
* @return 数据库源文件所在目录,非插件数据目录。
|
|
||||||
*/
|
|
||||||
public static File getDataSourceFolder() {
|
|
||||||
return instance.getSourceFolder();
|
|
||||||
}
|
|
||||||
|
|
||||||
/**
|
|
||||||
* 得到管理器注册池
|
|
||||||
*
|
|
||||||
* @return {@link SQLRegistry} 注册池
|
|
||||||
*/
|
|
||||||
public static SQLRegistry getRegistry() {
|
|
||||||
return instance.getRegistry();
|
|
||||||
}
|
|
||||||
|
|
||||||
/**
|
|
||||||
* 创建一个独立的管理器注册池。
|
|
||||||
*
|
|
||||||
* @return {@link SQLRegistry}
|
|
||||||
*/
|
|
||||||
public static @NotNull SQLRegistry createRegistry() {
|
|
||||||
return instance.createRegistry();
|
|
||||||
}
|
|
||||||
|
|
||||||
/**
|
|
||||||
* 创建一个新的 SQLManager 实例
|
|
||||||
*
|
|
||||||
* @param name 实例名称
|
|
||||||
* @param configuration SQLManager 实例的配置
|
|
||||||
* @return {@link SQLManager} 实例
|
|
||||||
* @throws Exception 若创建失败则抛出异常
|
|
||||||
*/
|
|
||||||
public static @NotNull SQLManager create(@NotNull String name,
|
|
||||||
@NotNull SQLSourceConfig configuration) throws Exception {
|
|
||||||
return instance.create(name, configuration);
|
|
||||||
}
|
|
||||||
|
|
||||||
/**
|
|
||||||
* 创建一个新的 SQLManager 实例
|
|
||||||
*
|
|
||||||
* @param name 实例名称
|
|
||||||
* @param properties SQLManager 实例的配置文件
|
|
||||||
* @return {@link SQLManager} 实例
|
|
||||||
* @throws Exception 若创建失败则抛出异常
|
|
||||||
*/
|
|
||||||
public static @NotNull SQLManager create(@NotNull String name,
|
|
||||||
@NotNull Properties properties) throws Exception {
|
|
||||||
return instance.create(name, properties);
|
|
||||||
}
|
|
||||||
|
|
||||||
public static @NotNull SQLManager create(@NotNull String name, @NotNull DataSource source) throws Exception {
|
|
||||||
return instance.create(name, source);
|
|
||||||
}
|
|
||||||
|
|
||||||
/**
|
|
||||||
* 终止并关闭一个 SQLManager 实例。
|
|
||||||
*
|
|
||||||
* @param manager SQLManager实例
|
|
||||||
* @param activeQueries 终止前仍未被关闭的SQLQuery列表
|
|
||||||
*/
|
|
||||||
public static void shutdown(SQLManager manager, @Nullable Consumer<Map<UUID, SQLQuery>> activeQueries) {
|
|
||||||
instance.shutdown(manager, activeQueries);
|
|
||||||
}
|
|
||||||
|
|
||||||
/**
|
|
||||||
* 终止并关闭一个 SQLManager 实例。
|
|
||||||
*
|
|
||||||
* @param manager SQLManager实例
|
|
||||||
* @param forceClose 是否强制关闭进行中的查询
|
|
||||||
*/
|
|
||||||
public static void shutdown(SQLManager manager, boolean forceClose) {
|
|
||||||
shutdown(manager, (unclosedQueries) -> {
|
|
||||||
if (forceClose) unclosedQueries.values().forEach(SQLQuery::close);
|
|
||||||
});
|
|
||||||
}
|
|
||||||
|
|
||||||
/**
|
|
||||||
* 终止并关闭一个 SQLManager 实例。
|
|
||||||
* <br>若在终止时仍有活跃的查询,则将会强制关闭。
|
|
||||||
*
|
|
||||||
* @param manager SQLManager实例
|
|
||||||
*/
|
|
||||||
public static void shutdown(SQLManager manager) {
|
|
||||||
shutdown(manager, true);
|
|
||||||
}
|
|
||||||
|
|
||||||
|
|
||||||
/**
|
|
||||||
* 读取一个 {@link SQLTablesRoot} 中全部的 {@link SimpleSQLTable} 实例并初始化。
|
|
||||||
*
|
|
||||||
* @param tablesRoot {@link SQLTablesRoot}实例
|
|
||||||
*/
|
|
||||||
public static void createTables(@NotNull SQLTablesRoot tablesRoot) throws Exception {
|
|
||||||
instance.createTables(tablesRoot);
|
|
||||||
}
|
|
||||||
|
|
||||||
/**
|
|
||||||
* 读取一个 {@link SQLTablesRoot}类中 中全部的静态 {@link SimpleSQLTable} 实例并初始化。
|
|
||||||
*
|
|
||||||
* @param tablesRootClazz {@link SQLTablesRoot}静态类
|
|
||||||
*/
|
|
||||||
public static void createTables(@NotNull Class<? extends SQLTablesRoot> tablesRootClazz) throws Exception {
|
|
||||||
instance.createTables(tablesRootClazz);
|
|
||||||
}
|
|
||||||
|
|
||||||
}
|
|
||||||
@@ -1,82 +0,0 @@
|
|||||||
package cc.carm.plugin.minesql.api;
|
|
||||||
|
|
||||||
import cc.carm.lib.easysql.api.SQLManager;
|
|
||||||
import cc.carm.lib.easysql.api.function.SQLHandler;
|
|
||||||
import org.jetbrains.annotations.Contract;
|
|
||||||
import org.jetbrains.annotations.NotNull;
|
|
||||||
import org.jetbrains.annotations.Nullable;
|
|
||||||
|
|
||||||
import java.util.Arrays;
|
|
||||||
import java.util.Optional;
|
|
||||||
|
|
||||||
public enum SQLDriverType {
|
|
||||||
|
|
||||||
MARIADB(
|
|
||||||
"org.mariadb.jdbc.Driver", "jdbc:mariadb://",
|
|
||||||
new String[]{"maria-db"}, null
|
|
||||||
),
|
|
||||||
|
|
||||||
MYSQL("com.mysql.jdbc.Driver", "jdbc:mysql://", null, null),
|
|
||||||
|
|
||||||
H2_FILE("org.h2.Driver", "jdbc:h2:file:",
|
|
||||||
new String[]{"h2"},
|
|
||||||
(manager) -> {
|
|
||||||
manager.executeSQL("SET MODE=MySQL");
|
|
||||||
manager.executeSQL("SET DB_CLOSE_DELAY=-1");
|
|
||||||
manager.executeSQL("SET DB_CLOSE_ON_EXIT=FALSE");
|
|
||||||
}
|
|
||||||
),
|
|
||||||
|
|
||||||
H2_MEM("org.h2.Driver", "jdbc:h2:mem:",
|
|
||||||
new String[]{"h2-memory", "h2-temp"},
|
|
||||||
(manager) -> {
|
|
||||||
manager.executeSQL("SET MODE=MySQL");
|
|
||||||
manager.executeSQL("SET DB_CLOSE_DELAY=-1");
|
|
||||||
manager.executeSQL("SET DB_CLOSE_ON_EXIT=FALSE");
|
|
||||||
}
|
|
||||||
);
|
|
||||||
|
|
||||||
private final @NotNull String driverClass;
|
|
||||||
private final @NotNull String jdbcPrefix;
|
|
||||||
private final @NotNull String[] databaseAlias;
|
|
||||||
private final @Nullable SQLHandler<SQLManager> initializer;
|
|
||||||
|
|
||||||
SQLDriverType(@NotNull String driverClass, @NotNull String jdbcPrefix,
|
|
||||||
@Nullable String[] databaseAlias,
|
|
||||||
@Nullable SQLHandler<SQLManager> initializer) {
|
|
||||||
|
|
||||||
this.driverClass = driverClass;
|
|
||||||
this.jdbcPrefix = jdbcPrefix;
|
|
||||||
this.databaseAlias = Optional.ofNullable(databaseAlias).orElse(new String[0]);
|
|
||||||
this.initializer = initializer;
|
|
||||||
}
|
|
||||||
|
|
||||||
public @NotNull String[] getDatabaseAlias() {
|
|
||||||
return databaseAlias;
|
|
||||||
}
|
|
||||||
|
|
||||||
public @NotNull String getDriverClass() {
|
|
||||||
return driverClass;
|
|
||||||
}
|
|
||||||
|
|
||||||
public @NotNull String getJdbcPrefix() {
|
|
||||||
return jdbcPrefix;
|
|
||||||
}
|
|
||||||
|
|
||||||
public @Nullable SQLHandler<SQLManager> getInitializer() {
|
|
||||||
return initializer;
|
|
||||||
}
|
|
||||||
|
|
||||||
@Contract("null->null")
|
|
||||||
public static @Nullable SQLDriverType parse(@Nullable String driverString) {
|
|
||||||
if (driverString == null) return null;
|
|
||||||
return Arrays.stream(values())
|
|
||||||
.filter(value -> value.name().equalsIgnoreCase(driverString) || anyMatch(value.getDatabaseAlias(), driverString))
|
|
||||||
.findFirst().orElse(null);
|
|
||||||
}
|
|
||||||
|
|
||||||
private static boolean anyMatch(String[] array, String value) {
|
|
||||||
return Arrays.stream(array).anyMatch(s -> s.equalsIgnoreCase(value));
|
|
||||||
}
|
|
||||||
|
|
||||||
}
|
|
||||||
@@ -1,79 +0,0 @@
|
|||||||
package cc.carm.plugin.minesql.api;
|
|
||||||
|
|
||||||
import cc.carm.lib.easysql.api.SQLManager;
|
|
||||||
import org.jetbrains.annotations.NotNull;
|
|
||||||
import org.jetbrains.annotations.Nullable;
|
|
||||||
import org.jetbrains.annotations.Unmodifiable;
|
|
||||||
|
|
||||||
import java.util.Map;
|
|
||||||
import java.util.Optional;
|
|
||||||
|
|
||||||
/**
|
|
||||||
* 入口类
|
|
||||||
*/
|
|
||||||
public interface SQLRegistry {
|
|
||||||
/**
|
|
||||||
* 获取原生注册的首个 SQLManager 实例
|
|
||||||
*
|
|
||||||
* @return {@link SQLManager} 实例
|
|
||||||
*/
|
|
||||||
default @Nullable SQLManager get() {
|
|
||||||
return get(null);
|
|
||||||
}
|
|
||||||
|
|
||||||
/**
|
|
||||||
* 获取原生注册的指定名称的 SQLManager 实例
|
|
||||||
*
|
|
||||||
* @param name 要获取的 SQLManager 实例名称, 如果为 null 则获取首个实例
|
|
||||||
* @return {@link SQLManager} 实例
|
|
||||||
*/
|
|
||||||
default @Nullable SQLManager get(@Nullable String name) {
|
|
||||||
return getOptional(name).orElse(null);
|
|
||||||
}
|
|
||||||
|
|
||||||
/**
|
|
||||||
* 获取原生注册的指定名称的 SQLManager 实例,并要求其不得为空
|
|
||||||
*
|
|
||||||
* @param name 要获取的 SQLManager 实例名称, 如果为 null 则获取首个实例
|
|
||||||
* @return {@link SQLManager} 实例
|
|
||||||
* @throws NullPointerException 若不存在对应实例则抛出空指针异常
|
|
||||||
*/
|
|
||||||
default @NotNull SQLManager getNotNull(@Nullable String name) throws NullPointerException {
|
|
||||||
return getOptional(name).orElseThrow(() -> new NullPointerException("并不存在ID为 #" + name + " 的SQLManager."));
|
|
||||||
}
|
|
||||||
|
|
||||||
/**
|
|
||||||
* 获取原生注册的指定名称的 SQLManager 实例
|
|
||||||
*
|
|
||||||
* @param name 要获取的 SQLManager 实例名称, 如果为 null 则获取首个实例
|
|
||||||
* @return {@link SQLManager} 实例
|
|
||||||
*/
|
|
||||||
@NotNull Optional<? extends SQLManager> getOptional(@Nullable String name);
|
|
||||||
|
|
||||||
/**
|
|
||||||
* 获取某命名空间下所有 SQLManager 实例
|
|
||||||
*
|
|
||||||
* @return {@link SQLManager} 实例集合
|
|
||||||
*/
|
|
||||||
@Unmodifiable
|
|
||||||
@NotNull Map<String, ? extends SQLManager> list();
|
|
||||||
|
|
||||||
/**
|
|
||||||
* 注册一个新的 SQLManager 实例
|
|
||||||
*
|
|
||||||
* @param name 实例名称
|
|
||||||
* @param sqlManager 实例
|
|
||||||
* @throws IllegalStateException 当所要注册的实例已经存在时抛出
|
|
||||||
*/
|
|
||||||
void register(@NotNull String name, @NotNull SQLManager sqlManager) throws IllegalStateException;
|
|
||||||
|
|
||||||
/**
|
|
||||||
* 从注册池中注销一个新的 SQLManager 实例
|
|
||||||
*
|
|
||||||
* @param name 实例名称
|
|
||||||
* @return 所被注销的 {@link SQLManager}
|
|
||||||
* @throws NullPointerException 当所要注销的实例不存在时抛出
|
|
||||||
*/
|
|
||||||
@NotNull SQLManager unregister(@NotNull String name) throws NullPointerException;
|
|
||||||
|
|
||||||
}
|
|
||||||
@@ -1,25 +0,0 @@
|
|||||||
package cc.carm.plugin.minesql.api.conf;
|
|
||||||
|
|
||||||
import cc.carm.plugin.minesql.api.SQLDriverType;
|
|
||||||
import cc.carm.plugin.minesql.api.source.SQLSourceConfig;
|
|
||||||
import org.jetbrains.annotations.NotNull;
|
|
||||||
|
|
||||||
import java.util.Map;
|
|
||||||
|
|
||||||
public abstract class SQLDriverConfig {
|
|
||||||
|
|
||||||
protected final @NotNull SQLDriverType type;
|
|
||||||
|
|
||||||
public SQLDriverConfig(@NotNull SQLDriverType type) {
|
|
||||||
this.type = type;
|
|
||||||
}
|
|
||||||
|
|
||||||
public abstract SQLSourceConfig createSource();
|
|
||||||
|
|
||||||
public @NotNull SQLDriverType getType() {
|
|
||||||
return type;
|
|
||||||
}
|
|
||||||
|
|
||||||
public abstract @NotNull Map<String, Object> serialize();
|
|
||||||
|
|
||||||
}
|
|
||||||
@@ -1,45 +0,0 @@
|
|||||||
package cc.carm.plugin.minesql.api.conf.drivers;
|
|
||||||
|
|
||||||
import cc.carm.plugin.minesql.api.SQLDriverType;
|
|
||||||
import cc.carm.plugin.minesql.api.conf.SQLDriverConfig;
|
|
||||||
import cc.carm.plugin.minesql.api.source.SQLSourceConfig;
|
|
||||||
import org.jetbrains.annotations.NotNull;
|
|
||||||
import org.jetbrains.annotations.Nullable;
|
|
||||||
|
|
||||||
import java.util.LinkedHashMap;
|
|
||||||
import java.util.Map;
|
|
||||||
import java.util.Optional;
|
|
||||||
|
|
||||||
public class H2MemConfig extends SQLDriverConfig {
|
|
||||||
|
|
||||||
protected final @Nullable String database;
|
|
||||||
|
|
||||||
public H2MemConfig(@Nullable String database) {
|
|
||||||
super(SQLDriverType.H2_MEM);
|
|
||||||
this.database = database;
|
|
||||||
}
|
|
||||||
|
|
||||||
public @Nullable String getDatabase() {
|
|
||||||
return database;
|
|
||||||
}
|
|
||||||
|
|
||||||
@Override
|
|
||||||
public SQLSourceConfig createSource() {
|
|
||||||
return SQLSourceConfig.create(getType().getDriverClass(), buildJDBC(), getType().getInitializer());
|
|
||||||
}
|
|
||||||
|
|
||||||
protected String buildJDBC() {
|
|
||||||
return getType().getJdbcPrefix() + Optional.ofNullable(getDatabase()).orElse("");
|
|
||||||
}
|
|
||||||
|
|
||||||
@Override
|
|
||||||
public @NotNull Map<String, Object> serialize() {
|
|
||||||
Map<String, Object> values = new LinkedHashMap<>();
|
|
||||||
|
|
||||||
values.put("type", getType().name());
|
|
||||||
if (getDatabase() != null) values.put("database", getDatabase());
|
|
||||||
|
|
||||||
return values;
|
|
||||||
}
|
|
||||||
|
|
||||||
}
|
|
||||||
@@ -1,49 +0,0 @@
|
|||||||
package cc.carm.plugin.minesql.api.conf.impl;
|
|
||||||
|
|
||||||
import cc.carm.plugin.minesql.MineSQL;
|
|
||||||
import cc.carm.plugin.minesql.api.SQLDriverType;
|
|
||||||
import cc.carm.plugin.minesql.api.conf.SQLDriverConfig;
|
|
||||||
import cc.carm.plugin.minesql.api.source.SQLSourceConfig;
|
|
||||||
import org.jetbrains.annotations.NotNull;
|
|
||||||
|
|
||||||
import java.io.File;
|
|
||||||
import java.util.LinkedHashMap;
|
|
||||||
import java.util.Map;
|
|
||||||
|
|
||||||
public class FileBasedConfig extends SQLDriverConfig {
|
|
||||||
|
|
||||||
protected final @NotNull String filePath;
|
|
||||||
|
|
||||||
public FileBasedConfig(@NotNull SQLDriverType type,
|
|
||||||
@NotNull String filePath) {
|
|
||||||
super(type);
|
|
||||||
this.filePath = filePath;
|
|
||||||
}
|
|
||||||
|
|
||||||
public @NotNull String getFilePath() {
|
|
||||||
return filePath;
|
|
||||||
}
|
|
||||||
|
|
||||||
@Override
|
|
||||||
public SQLSourceConfig createSource() {
|
|
||||||
File file = new File(MineSQL.getDataSourceFolder(), filePath);
|
|
||||||
return SQLSourceConfig.create(
|
|
||||||
getType().getDriverClass(),
|
|
||||||
getType().getJdbcPrefix() + file.getAbsolutePath(),
|
|
||||||
getType().getInitializer()
|
|
||||||
);
|
|
||||||
}
|
|
||||||
|
|
||||||
@Override
|
|
||||||
public @NotNull Map<String, Object> serialize() {
|
|
||||||
Map<String, Object> values = new LinkedHashMap<>();
|
|
||||||
|
|
||||||
values.put("type", getType().name());
|
|
||||||
values.put("file", getFilePath());
|
|
||||||
|
|
||||||
return values;
|
|
||||||
}
|
|
||||||
|
|
||||||
|
|
||||||
}
|
|
||||||
|
|
||||||
@@ -1,87 +0,0 @@
|
|||||||
package cc.carm.plugin.minesql.api.conf.impl;
|
|
||||||
|
|
||||||
import cc.carm.plugin.minesql.api.SQLDriverType;
|
|
||||||
import cc.carm.plugin.minesql.api.conf.SQLDriverConfig;
|
|
||||||
import cc.carm.plugin.minesql.api.source.SQLSourceConfig;
|
|
||||||
import org.jetbrains.annotations.NotNull;
|
|
||||||
import org.jetbrains.annotations.Nullable;
|
|
||||||
|
|
||||||
import java.util.LinkedHashMap;
|
|
||||||
import java.util.Map;
|
|
||||||
|
|
||||||
public class RemoteAuthConfig extends SQLDriverConfig {
|
|
||||||
|
|
||||||
protected final @NotNull String host;
|
|
||||||
protected final int port;
|
|
||||||
protected final @NotNull String database;
|
|
||||||
protected final @Nullable String username;
|
|
||||||
protected final @Nullable String password;
|
|
||||||
|
|
||||||
protected final @Nullable String extraSettings;
|
|
||||||
|
|
||||||
public RemoteAuthConfig(@NotNull SQLDriverType type,
|
|
||||||
@NotNull String host, int port, @NotNull String database,
|
|
||||||
@Nullable String username, @Nullable String password,
|
|
||||||
@Nullable String extraSettings) {
|
|
||||||
super(type);
|
|
||||||
this.host = host;
|
|
||||||
this.port = port;
|
|
||||||
this.database = database;
|
|
||||||
this.username = username;
|
|
||||||
this.password = password;
|
|
||||||
this.extraSettings = extraSettings;
|
|
||||||
}
|
|
||||||
|
|
||||||
@Override
|
|
||||||
public SQLSourceConfig createSource() {
|
|
||||||
return SQLSourceConfig.create(
|
|
||||||
getType().getDriverClass(), buildJDBC(), getType().getInitializer()
|
|
||||||
).setUsername(getUsername()).setPassword(getPassword());
|
|
||||||
}
|
|
||||||
|
|
||||||
public @NotNull String getHost() {
|
|
||||||
return host;
|
|
||||||
}
|
|
||||||
|
|
||||||
public int getPort() {
|
|
||||||
return port;
|
|
||||||
}
|
|
||||||
|
|
||||||
public @NotNull String getDatabase() {
|
|
||||||
return database;
|
|
||||||
}
|
|
||||||
|
|
||||||
public @Nullable String getUsername() {
|
|
||||||
return username;
|
|
||||||
}
|
|
||||||
|
|
||||||
|
|
||||||
public @Nullable String getPassword() {
|
|
||||||
return password;
|
|
||||||
}
|
|
||||||
|
|
||||||
public @Nullable String getExtraSettings() {
|
|
||||||
return extraSettings;
|
|
||||||
}
|
|
||||||
|
|
||||||
protected String buildJDBC() {
|
|
||||||
return String.format("%s%s:%s/%s%s", getType().getJdbcPrefix(), getHost(), getPort(), getDatabase(), getExtraSettings());
|
|
||||||
}
|
|
||||||
|
|
||||||
@Override
|
|
||||||
public @NotNull Map<String, Object> serialize() {
|
|
||||||
Map<String, Object> values = new LinkedHashMap<>();
|
|
||||||
|
|
||||||
values.put("type", getType().name());
|
|
||||||
|
|
||||||
values.put("host", getHost());
|
|
||||||
values.put("port", getPort());
|
|
||||||
values.put("database", getDatabase());
|
|
||||||
if (getUsername() != null) values.put("username", username);
|
|
||||||
if (getPassword() != null) values.put("password", password);
|
|
||||||
if (getExtraSettings() != null) values.put("extra", extraSettings);
|
|
||||||
|
|
||||||
return values;
|
|
||||||
}
|
|
||||||
|
|
||||||
}
|
|
||||||
@@ -1,134 +0,0 @@
|
|||||||
package cc.carm.plugin.minesql.api.source;
|
|
||||||
|
|
||||||
import org.jetbrains.annotations.Nullable;
|
|
||||||
|
|
||||||
public class SQLPoolSettings {
|
|
||||||
|
|
||||||
private @Nullable String poolName;
|
|
||||||
private @Nullable Integer maxPoolSize;
|
|
||||||
private @Nullable Integer maxActive;
|
|
||||||
|
|
||||||
private @Nullable Integer maxHoldTime;
|
|
||||||
|
|
||||||
private @Nullable Long idleTimeout;
|
|
||||||
|
|
||||||
private @Nullable Long maxWaitTime;
|
|
||||||
|
|
||||||
private @Nullable String schema;
|
|
||||||
private @Nullable Boolean autoCommit;
|
|
||||||
private @Nullable Boolean readOnly;
|
|
||||||
|
|
||||||
private @Nullable String validationSQL;
|
|
||||||
private @Nullable Integer validationTimeout;
|
|
||||||
private @Nullable Long validationInterval;
|
|
||||||
|
|
||||||
public @Nullable String getValidationSQL() {
|
|
||||||
return validationSQL;
|
|
||||||
}
|
|
||||||
|
|
||||||
public SQLPoolSettings setValidationSQL(String validationSQL) {
|
|
||||||
this.validationSQL = validationSQL;
|
|
||||||
return this;
|
|
||||||
}
|
|
||||||
|
|
||||||
public @Nullable Long getValidationInterval() {
|
|
||||||
return validationInterval;
|
|
||||||
}
|
|
||||||
|
|
||||||
public SQLPoolSettings setValidationInterval(@Nullable Long validationInterval) {
|
|
||||||
this.validationInterval = validationInterval;
|
|
||||||
return this;
|
|
||||||
}
|
|
||||||
|
|
||||||
public @Nullable String getPoolName() {
|
|
||||||
return poolName;
|
|
||||||
}
|
|
||||||
|
|
||||||
public SQLPoolSettings setPoolName(String poolName) {
|
|
||||||
this.poolName = poolName;
|
|
||||||
return this;
|
|
||||||
}
|
|
||||||
|
|
||||||
public @Nullable String getSchema() {
|
|
||||||
return schema;
|
|
||||||
}
|
|
||||||
|
|
||||||
public SQLPoolSettings setSchema(String schema) {
|
|
||||||
this.schema = schema;
|
|
||||||
return this;
|
|
||||||
}
|
|
||||||
|
|
||||||
public @Nullable Boolean getAutoCommit() {
|
|
||||||
return autoCommit;
|
|
||||||
}
|
|
||||||
|
|
||||||
public SQLPoolSettings setAutoCommit(Boolean autoCommit) {
|
|
||||||
this.autoCommit = autoCommit;
|
|
||||||
return this;
|
|
||||||
}
|
|
||||||
|
|
||||||
public @Nullable Boolean getReadOnly() {
|
|
||||||
return readOnly;
|
|
||||||
}
|
|
||||||
|
|
||||||
public SQLPoolSettings setReadOnly(Boolean readOnly) {
|
|
||||||
this.readOnly = readOnly;
|
|
||||||
return this;
|
|
||||||
}
|
|
||||||
|
|
||||||
public @Nullable Integer getMaxHoldTime() {
|
|
||||||
return maxHoldTime;
|
|
||||||
}
|
|
||||||
|
|
||||||
public SQLPoolSettings setMaxHoldTime(@Nullable Integer maxHoldTime) {
|
|
||||||
this.maxHoldTime = maxHoldTime;
|
|
||||||
return this;
|
|
||||||
}
|
|
||||||
|
|
||||||
public @Nullable Integer getValidationTimeout() {
|
|
||||||
return validationTimeout;
|
|
||||||
}
|
|
||||||
|
|
||||||
public SQLPoolSettings setValidationTimeout(Integer validationTimeout) {
|
|
||||||
this.validationTimeout = validationTimeout;
|
|
||||||
return this;
|
|
||||||
}
|
|
||||||
|
|
||||||
public @Nullable Long getIdleTimeout() {
|
|
||||||
return idleTimeout;
|
|
||||||
}
|
|
||||||
|
|
||||||
public SQLPoolSettings setIdleTimeout(Long idleTimeout) {
|
|
||||||
this.idleTimeout = idleTimeout;
|
|
||||||
return this;
|
|
||||||
}
|
|
||||||
|
|
||||||
public @Nullable Integer getMaxActive() {
|
|
||||||
return maxActive;
|
|
||||||
}
|
|
||||||
|
|
||||||
public SQLPoolSettings setMaxActive(Integer maxActive) {
|
|
||||||
this.maxActive = maxActive;
|
|
||||||
return this;
|
|
||||||
}
|
|
||||||
|
|
||||||
public @Nullable Integer getMaxPoolSize() {
|
|
||||||
return maxPoolSize;
|
|
||||||
}
|
|
||||||
|
|
||||||
public SQLPoolSettings setMaxPoolSize(@Nullable Integer maxPoolSize) {
|
|
||||||
this.maxPoolSize = maxPoolSize;
|
|
||||||
return this;
|
|
||||||
}
|
|
||||||
|
|
||||||
public @Nullable Long getMaxWaitTime() {
|
|
||||||
return maxWaitTime;
|
|
||||||
}
|
|
||||||
|
|
||||||
public SQLPoolSettings setMaxWaitTime(Long maxWaitTime) {
|
|
||||||
this.maxWaitTime = maxWaitTime;
|
|
||||||
return this;
|
|
||||||
}
|
|
||||||
|
|
||||||
|
|
||||||
}
|
|
||||||
@@ -1,135 +0,0 @@
|
|||||||
package cc.carm.plugin.minesql.api.source;
|
|
||||||
|
|
||||||
import cc.carm.lib.easysql.api.SQLManager;
|
|
||||||
import cc.carm.lib.easysql.api.function.SQLHandler;
|
|
||||||
import cc.carm.plugin.minesql.api.SQLDriverType;
|
|
||||||
import cc.carm.plugin.minesql.api.conf.drivers.H2MemConfig;
|
|
||||||
import cc.carm.plugin.minesql.api.conf.impl.FileBasedConfig;
|
|
||||||
import cc.carm.plugin.minesql.api.conf.impl.RemoteAuthConfig;
|
|
||||||
import org.jetbrains.annotations.NotNull;
|
|
||||||
import org.jetbrains.annotations.Nullable;
|
|
||||||
|
|
||||||
import java.io.File;
|
|
||||||
import java.util.Optional;
|
|
||||||
import java.util.function.Consumer;
|
|
||||||
|
|
||||||
public class SQLSourceConfig {
|
|
||||||
|
|
||||||
public static SQLSourceConfig createMySQL(@NotNull String host, int port, @NotNull String database,
|
|
||||||
@NotNull String username, @Nullable String password,
|
|
||||||
@Nullable String extraSettings) {
|
|
||||||
return new RemoteAuthConfig(SQLDriverType.MYSQL, host, port, database, username, password, extraSettings).createSource();
|
|
||||||
}
|
|
||||||
|
|
||||||
public static SQLSourceConfig createMariaDB(@NotNull String host, int port, @NotNull String database,
|
|
||||||
@NotNull String username, @Nullable String password,
|
|
||||||
@Nullable String extraSettings) {
|
|
||||||
return new RemoteAuthConfig(SQLDriverType.MARIADB, host, port, database, username, password, extraSettings).createSource();
|
|
||||||
}
|
|
||||||
|
|
||||||
public static SQLSourceConfig createH2File(@NotNull File file) {
|
|
||||||
return create(SQLDriverType.H2_FILE, file.getAbsolutePath());
|
|
||||||
}
|
|
||||||
|
|
||||||
public static SQLSourceConfig createH2File(@NotNull String filePath) {
|
|
||||||
return new FileBasedConfig(SQLDriverType.H2_FILE, filePath).createSource();
|
|
||||||
}
|
|
||||||
|
|
||||||
public static SQLSourceConfig createH2Mem(@Nullable String databaseName) {
|
|
||||||
return new H2MemConfig(databaseName).createSource();
|
|
||||||
}
|
|
||||||
|
|
||||||
public static SQLSourceConfig create(@NotNull SQLDriverType sourceType, @NotNull String url) {
|
|
||||||
return create(sourceType.getDriverClass(), sourceType.getJdbcPrefix() + url, sourceType.getInitializer());
|
|
||||||
}
|
|
||||||
|
|
||||||
public static SQLSourceConfig create(@NotNull String driverClass, @NotNull String jdbcURL) {
|
|
||||||
return create(driverClass, jdbcURL, null);
|
|
||||||
}
|
|
||||||
|
|
||||||
public static SQLSourceConfig create(@NotNull String driverClassName, @NotNull String jdbcURL,
|
|
||||||
@Nullable SQLHandler<SQLManager> initializer) {
|
|
||||||
return new SQLSourceConfig(driverClassName, jdbcURL, initializer, null);
|
|
||||||
}
|
|
||||||
|
|
||||||
public static SQLSourceConfig create(@NotNull String driverClassName, @NotNull String jdbcURL,
|
|
||||||
@Nullable SQLHandler<SQLManager> initializer, @Nullable SQLPoolSettings settings) {
|
|
||||||
return new SQLSourceConfig(driverClassName, jdbcURL, initializer, settings);
|
|
||||||
}
|
|
||||||
|
|
||||||
private @NotNull String driverClassName;
|
|
||||||
private @NotNull String jdbcURL;
|
|
||||||
private @Nullable String username;
|
|
||||||
private @Nullable String password;
|
|
||||||
|
|
||||||
private @Nullable SQLHandler<SQLManager> initializer;
|
|
||||||
private @NotNull SQLPoolSettings settings;
|
|
||||||
|
|
||||||
public SQLSourceConfig(@NotNull String driverClassName, @NotNull String jdbcURL,
|
|
||||||
@Nullable SQLHandler<SQLManager> initializer, @Nullable SQLPoolSettings settings) {
|
|
||||||
this.driverClassName = driverClassName;
|
|
||||||
this.jdbcURL = jdbcURL;
|
|
||||||
this.initializer = initializer;
|
|
||||||
this.settings = Optional.ofNullable(settings).orElse(new SQLPoolSettings());
|
|
||||||
}
|
|
||||||
|
|
||||||
public @NotNull String getDriverClassName() {
|
|
||||||
return driverClassName;
|
|
||||||
}
|
|
||||||
|
|
||||||
public SQLSourceConfig setDriverClassName(String driverClassName) {
|
|
||||||
this.driverClassName = driverClassName;
|
|
||||||
return this;
|
|
||||||
}
|
|
||||||
|
|
||||||
public @NotNull String getJdbcURL() {
|
|
||||||
return jdbcURL;
|
|
||||||
}
|
|
||||||
|
|
||||||
public SQLSourceConfig setJdbcURL(String jdbcURL) {
|
|
||||||
this.jdbcURL = jdbcURL;
|
|
||||||
return this;
|
|
||||||
}
|
|
||||||
|
|
||||||
public @Nullable String getUsername() {
|
|
||||||
return username;
|
|
||||||
}
|
|
||||||
|
|
||||||
public SQLSourceConfig setUsername(String username) {
|
|
||||||
this.username = username;
|
|
||||||
return this;
|
|
||||||
}
|
|
||||||
|
|
||||||
public @Nullable String getPassword() {
|
|
||||||
return password;
|
|
||||||
}
|
|
||||||
|
|
||||||
public SQLSourceConfig setPassword(String password) {
|
|
||||||
this.password = password;
|
|
||||||
return this;
|
|
||||||
}
|
|
||||||
|
|
||||||
public @Nullable SQLHandler<SQLManager> getInitializer() {
|
|
||||||
return initializer;
|
|
||||||
}
|
|
||||||
|
|
||||||
public SQLSourceConfig setInitializer(SQLHandler<SQLManager> initializer) {
|
|
||||||
this.initializer = initializer;
|
|
||||||
return this;
|
|
||||||
}
|
|
||||||
|
|
||||||
public @NotNull SQLPoolSettings getSettings() {
|
|
||||||
return settings;
|
|
||||||
}
|
|
||||||
|
|
||||||
public SQLSourceConfig setSettings(SQLPoolSettings settings) {
|
|
||||||
this.settings = settings;
|
|
||||||
return this;
|
|
||||||
}
|
|
||||||
|
|
||||||
public SQLSourceConfig editSettings(Consumer<SQLPoolSettings> consumer) {
|
|
||||||
consumer.accept(settings);
|
|
||||||
return this;
|
|
||||||
}
|
|
||||||
|
|
||||||
}
|
|
||||||
@@ -1,12 +0,0 @@
|
|||||||
package cc.carm.plugin.minesql.api.table;
|
|
||||||
|
|
||||||
import cc.carm.lib.easysql.api.function.SQLHandler;
|
|
||||||
|
|
||||||
import java.util.function.Supplier;
|
|
||||||
|
|
||||||
/**
|
|
||||||
* 表声明类的根节点,用于标注该类用于记录表的结构信息。
|
|
||||||
* <br> 创建表请使用 {@link SimpleSQLTable#of(String, String, Supplier, SQLHandler)}。
|
|
||||||
*/
|
|
||||||
public abstract class SQLTablesRoot {
|
|
||||||
}
|
|
||||||
@@ -1,156 +0,0 @@
|
|||||||
package cc.carm.plugin.minesql.api.table;
|
|
||||||
|
|
||||||
import cc.carm.lib.easysql.api.SQLManager;
|
|
||||||
import cc.carm.lib.easysql.api.action.PreparedSQLUpdateAction;
|
|
||||||
import cc.carm.lib.easysql.api.action.PreparedSQLUpdateBatchAction;
|
|
||||||
import cc.carm.lib.easysql.api.builder.*;
|
|
||||||
import cc.carm.lib.easysql.api.function.SQLHandler;
|
|
||||||
import cc.carm.plugin.minesql.MineSQL;
|
|
||||||
import org.jetbrains.annotations.NotNull;
|
|
||||||
import org.jetbrains.annotations.Nullable;
|
|
||||||
|
|
||||||
import java.sql.SQLException;
|
|
||||||
import java.util.Optional;
|
|
||||||
import java.util.function.Supplier;
|
|
||||||
|
|
||||||
public class SimpleSQLTable {
|
|
||||||
|
|
||||||
public static @NotNull SimpleSQLTable of(@NotNull String tableName,
|
|
||||||
@NotNull SQLHandler<TableCreateBuilder> tableBuilder) {
|
|
||||||
return new SimpleSQLTable(null, tableName, null, tableBuilder);
|
|
||||||
}
|
|
||||||
|
|
||||||
public static @NotNull SimpleSQLTable of(@Nullable String database, @NotNull String tableName,
|
|
||||||
@NotNull SQLHandler<TableCreateBuilder> tableBuilder) {
|
|
||||||
return new SimpleSQLTable(database, tableName, null, tableBuilder);
|
|
||||||
}
|
|
||||||
|
|
||||||
public static @NotNull SimpleSQLTable of(@Nullable String database, @NotNull String tableName,
|
|
||||||
@Nullable String tablePrefix, @NotNull SQLHandler<TableCreateBuilder> tableBuilder) {
|
|
||||||
return new SimpleSQLTable(database, tableName, () -> tablePrefix, tableBuilder);
|
|
||||||
}
|
|
||||||
|
|
||||||
public static @NotNull SimpleSQLTable of(@Nullable String database, @NotNull String tableName,
|
|
||||||
@Nullable Supplier<String> tablePrefix, @NotNull SQLHandler<TableCreateBuilder> tableBuilder) {
|
|
||||||
return new SimpleSQLTable(database, tableName, tablePrefix, tableBuilder);
|
|
||||||
}
|
|
||||||
|
|
||||||
protected final @Nullable String database;
|
|
||||||
protected final @NotNull String tableName;
|
|
||||||
|
|
||||||
protected final @Nullable Supplier<String> tablePrefix;
|
|
||||||
protected final @NotNull SQLHandler<TableCreateBuilder> tableCreator;
|
|
||||||
|
|
||||||
public SimpleSQLTable(@Nullable String database, @NotNull String tableName,
|
|
||||||
@Nullable Supplier<String> tablePrefix, @NotNull SQLHandler<TableCreateBuilder> table) {
|
|
||||||
this.database = database;
|
|
||||||
this.tableName = tableName;
|
|
||||||
this.tablePrefix = tablePrefix;
|
|
||||||
this.tableCreator = table;
|
|
||||||
}
|
|
||||||
|
|
||||||
public boolean create() throws SQLException {
|
|
||||||
SQLManager sqlManager = getSQLManager();
|
|
||||||
if (sqlManager == null) throw new SQLException(getExceptionReason());
|
|
||||||
|
|
||||||
TableCreateBuilder tableBuilder = sqlManager.createTable(getTableName());
|
|
||||||
tableCreator.accept(tableBuilder);
|
|
||||||
return tableBuilder.build().executeFunction(l -> l > 0, false);
|
|
||||||
}
|
|
||||||
|
|
||||||
public @Nullable String getDatabase() {
|
|
||||||
return database;
|
|
||||||
}
|
|
||||||
|
|
||||||
public @Nullable SQLManager getSQLManager() {
|
|
||||||
return MineSQL.getRegistry().get(getDatabase());
|
|
||||||
}
|
|
||||||
|
|
||||||
public @NotNull String getTableName() {
|
|
||||||
String prefix = getTablePrefix();
|
|
||||||
return (prefix != null ? prefix : "") + tableName;
|
|
||||||
}
|
|
||||||
|
|
||||||
public @Nullable String getTablePrefix() {
|
|
||||||
return Optional.ofNullable(tablePrefix).map(Supplier::get).orElse(null);
|
|
||||||
}
|
|
||||||
|
|
||||||
public @NotNull TableQueryBuilder createQuery() {
|
|
||||||
return Optional.ofNullable(getSQLManager()).map(this::createQuery)
|
|
||||||
.orElseThrow(() -> new NullPointerException(getExceptionReason()));
|
|
||||||
}
|
|
||||||
|
|
||||||
public @NotNull TableQueryBuilder createQuery(@NotNull SQLManager sqlManager) {
|
|
||||||
return sqlManager.createQuery().inTable(getTableName());
|
|
||||||
}
|
|
||||||
|
|
||||||
public @NotNull DeleteBuilder createDelete() {
|
|
||||||
return Optional.ofNullable(getSQLManager()).map(this::createDelete)
|
|
||||||
.orElseThrow(() -> new NullPointerException(getExceptionReason()));
|
|
||||||
}
|
|
||||||
|
|
||||||
public @NotNull DeleteBuilder createDelete(@NotNull SQLManager sqlManager) {
|
|
||||||
return sqlManager.createDelete(getTableName());
|
|
||||||
}
|
|
||||||
|
|
||||||
public @NotNull UpdateBuilder createUpdate() {
|
|
||||||
return Optional.ofNullable(getSQLManager()).map(this::createUpdate)
|
|
||||||
.orElseThrow(() -> new NullPointerException(getExceptionReason()));
|
|
||||||
}
|
|
||||||
|
|
||||||
public @NotNull UpdateBuilder createUpdate(@NotNull SQLManager sqlManager) {
|
|
||||||
return sqlManager.createUpdate(getTableName());
|
|
||||||
}
|
|
||||||
|
|
||||||
public @NotNull InsertBuilder<PreparedSQLUpdateAction<Integer>> createInsert() {
|
|
||||||
return Optional.ofNullable(getSQLManager()).map(this::createInsert)
|
|
||||||
.orElseThrow(() -> new NullPointerException(getExceptionReason()));
|
|
||||||
}
|
|
||||||
|
|
||||||
public @NotNull InsertBuilder<PreparedSQLUpdateAction<Integer>> createInsert(@NotNull SQLManager sqlManager) {
|
|
||||||
return sqlManager.createInsert(getTableName());
|
|
||||||
}
|
|
||||||
|
|
||||||
public @NotNull InsertBuilder<PreparedSQLUpdateBatchAction<Integer>> createInsertBatch() {
|
|
||||||
return Optional.ofNullable(getSQLManager()).map(this::createInsertBatch)
|
|
||||||
.orElseThrow(() -> new NullPointerException(getExceptionReason()));
|
|
||||||
}
|
|
||||||
|
|
||||||
public @NotNull InsertBuilder<PreparedSQLUpdateBatchAction<Integer>> createInsertBatch(@NotNull SQLManager sqlManager) {
|
|
||||||
return sqlManager.createInsertBatch(getTableName());
|
|
||||||
}
|
|
||||||
|
|
||||||
public @NotNull ReplaceBuilder<PreparedSQLUpdateAction<Integer>> createReplace() {
|
|
||||||
return Optional.ofNullable(getSQLManager()).map(this::createReplace)
|
|
||||||
.orElseThrow(() -> new NullPointerException(getExceptionReason()));
|
|
||||||
|
|
||||||
}
|
|
||||||
|
|
||||||
public @NotNull ReplaceBuilder<PreparedSQLUpdateAction<Integer>> createReplace(@NotNull SQLManager sqlManager) {
|
|
||||||
return sqlManager.createReplace(getTableName());
|
|
||||||
}
|
|
||||||
|
|
||||||
public @NotNull ReplaceBuilder<PreparedSQLUpdateBatchAction<Integer>> createReplaceBatch() {
|
|
||||||
return Optional.ofNullable(getSQLManager()).map(this::createReplaceBatch)
|
|
||||||
.orElseThrow(() -> new NullPointerException(getExceptionReason()));
|
|
||||||
}
|
|
||||||
|
|
||||||
public @NotNull ReplaceBuilder<PreparedSQLUpdateBatchAction<Integer>> createReplaceBatch(@NotNull SQLManager sqlManager) {
|
|
||||||
return sqlManager.createReplaceBatch(getTableName());
|
|
||||||
}
|
|
||||||
|
|
||||||
public @NotNull TableAlterBuilder alter() {
|
|
||||||
return Optional.ofNullable(getSQLManager()).map(this::alter)
|
|
||||||
.orElseThrow(() -> new NullPointerException(getExceptionReason()));
|
|
||||||
}
|
|
||||||
|
|
||||||
public @NotNull TableAlterBuilder alter(@NotNull SQLManager sqlManager) {
|
|
||||||
return sqlManager.alterTable(getTableName());
|
|
||||||
}
|
|
||||||
|
|
||||||
private String getExceptionReason() {
|
|
||||||
if (getDatabase() == null) return "Cannot find any SQLManager.";
|
|
||||||
else return "Cannot find any SQLManager for \"" + getDatabase() + "\".";
|
|
||||||
}
|
|
||||||
|
|
||||||
}
|
|
||||||
Binary file not shown.
@@ -0,0 +1 @@
|
|||||||
|
c80ad300e2fa54586c3d303fddc1060a
|
||||||
@@ -0,0 +1 @@
|
|||||||
|
a26304759474706bf7cef13118c6eea5643938f3
|
||||||
Binary file not shown.
@@ -0,0 +1 @@
|
|||||||
|
6ebb0d7c80467cd2b95dd6a19c36b7e0
|
||||||
@@ -0,0 +1 @@
|
|||||||
|
a7c27a1afe1bfc530ad8ea4ceb3849984a634ba7
|
||||||
Binary file not shown.
@@ -0,0 +1 @@
|
|||||||
|
bb88f656cec5335edb239e3d129fabf6
|
||||||
@@ -0,0 +1 @@
|
|||||||
|
2d8729868246c8721163fa40d0e06eaf495d563f
|
||||||
@@ -5,7 +5,7 @@
|
|||||||
<parent>
|
<parent>
|
||||||
<artifactId>minesql-parent</artifactId>
|
<artifactId>minesql-parent</artifactId>
|
||||||
<groupId>cc.carm.plugin</groupId>
|
<groupId>cc.carm.plugin</groupId>
|
||||||
<version>1.4.3</version>
|
<version>1.4.2</version>
|
||||||
</parent>
|
</parent>
|
||||||
<modelVersion>4.0.0</modelVersion>
|
<modelVersion>4.0.0</modelVersion>
|
||||||
|
|
||||||
@@ -81,7 +81,7 @@
|
|||||||
<plugin>
|
<plugin>
|
||||||
<groupId>org.apache.maven.plugins</groupId>
|
<groupId>org.apache.maven.plugins</groupId>
|
||||||
<artifactId>maven-javadoc-plugin</artifactId>
|
<artifactId>maven-javadoc-plugin</artifactId>
|
||||||
<version>3.12.0</version>
|
<version>3.2.0</version>
|
||||||
<configuration>
|
<configuration>
|
||||||
<classifier>javadoc</classifier>
|
<classifier>javadoc</classifier>
|
||||||
<detectJavaApiLink>false</detectJavaApiLink>
|
<detectJavaApiLink>false</detectJavaApiLink>
|
||||||
@@ -0,0 +1 @@
|
|||||||
|
5efad3162767d2f27cbee7c38258e6e5
|
||||||
@@ -0,0 +1 @@
|
|||||||
|
0e03e3e91526958064b767cd4e258e693d9c6020
|
||||||
@@ -0,0 +1,12 @@
|
|||||||
|
<?xml version="1.0" encoding="UTF-8"?>
|
||||||
|
<metadata>
|
||||||
|
<groupId>cc.carm.plugin</groupId>
|
||||||
|
<artifactId>minesql-api</artifactId>
|
||||||
|
<versioning>
|
||||||
|
<release>1.4.2</release>
|
||||||
|
<versions>
|
||||||
|
<version>1.4.2</version>
|
||||||
|
</versions>
|
||||||
|
<lastUpdated>20250206180420</lastUpdated>
|
||||||
|
</versioning>
|
||||||
|
</metadata>
|
||||||
@@ -0,0 +1 @@
|
|||||||
|
1a052c0e13985dea573f3ff67113a99a
|
||||||
@@ -0,0 +1 @@
|
|||||||
|
31f982e375692f055a2b62bd81a52c3382b09a91
|
||||||
@@ -12,17 +12,17 @@
|
|||||||
<maven.compiler.encoding>UTF-8</maven.compiler.encoding>
|
<maven.compiler.encoding>UTF-8</maven.compiler.encoding>
|
||||||
|
|
||||||
<deps.easysql.version>0.4.7</deps.easysql.version>
|
<deps.easysql.version>0.4.7</deps.easysql.version>
|
||||||
<deps.easyconf.version>4.2.0</deps.easyconf.version>
|
<deps.easyconf.version>3.5.1</deps.easyconf.version>
|
||||||
<deps.easyplugin.version>1.5.14</deps.easyplugin.version>
|
<deps.easyplugin.version>1.5.12</deps.easyplugin.version>
|
||||||
<deps.beecp.version>5.2.1</deps.beecp.version>
|
<deps.beecp.version>4.1.7</deps.beecp.version>
|
||||||
|
|
||||||
<deps.libby.version>1.1.5</deps.libby.version>
|
<deps.libby.version>1.1.5</deps.libby.version>
|
||||||
<deps.acf.version>0.5.1-SNAPSHOT</deps.acf.version>
|
<deps.acf.version>0.5.1-SNAPSHOT</deps.acf.version>
|
||||||
<deps.bstats.version>3.1.0</deps.bstats.version>
|
<deps.bstats.version>3.0.0</deps.bstats.version>
|
||||||
|
|
||||||
<deps.mysql-driver.version>9.6.0</deps.mysql-driver.version>
|
<deps.mysql-driver.version>8.2.0</deps.mysql-driver.version>
|
||||||
<deps.mariadb-driver.version>3.5.8</deps.mariadb-driver.version>
|
<deps.mariadb-driver.version>3.1.0</deps.mariadb-driver.version>
|
||||||
<deps.h2-driver.version>2.4.240</deps.h2-driver.version>
|
<deps.h2-driver.version>2.2.220</deps.h2-driver.version>
|
||||||
|
|
||||||
<code.package>cc.carm.plugin.minesql</code.package>
|
<code.package>cc.carm.plugin.minesql</code.package>
|
||||||
</properties>
|
</properties>
|
||||||
@@ -30,7 +30,7 @@
|
|||||||
<groupId>cc.carm.plugin</groupId>
|
<groupId>cc.carm.plugin</groupId>
|
||||||
<artifactId>minesql-parent</artifactId>
|
<artifactId>minesql-parent</artifactId>
|
||||||
<packaging>pom</packaging>
|
<packaging>pom</packaging>
|
||||||
<version>1.4.3</version>
|
<version>1.4.2</version>
|
||||||
<modules>
|
<modules>
|
||||||
<module>api</module>
|
<module>api</module>
|
||||||
<module>core</module>
|
<module>core</module>
|
||||||
@@ -38,6 +38,7 @@
|
|||||||
<module>platforms/bukkit</module>
|
<module>platforms/bukkit</module>
|
||||||
<module>platforms/bungee</module>
|
<module>platforms/bungee</module>
|
||||||
<module>platforms/velocity</module>
|
<module>platforms/velocity</module>
|
||||||
|
<module>platforms/sponge8</module>
|
||||||
|
|
||||||
<module>plugin</module>
|
<module>plugin</module>
|
||||||
</modules>
|
</modules>
|
||||||
@@ -122,7 +123,7 @@
|
|||||||
<dependency>
|
<dependency>
|
||||||
<groupId>org.jetbrains</groupId>
|
<groupId>org.jetbrains</groupId>
|
||||||
<artifactId>annotations</artifactId>
|
<artifactId>annotations</artifactId>
|
||||||
<version>26.0.2-1</version>
|
<version>24.0.1</version>
|
||||||
<scope>provided</scope>
|
<scope>provided</scope>
|
||||||
</dependency>
|
</dependency>
|
||||||
|
|
||||||
@@ -155,7 +156,7 @@
|
|||||||
<dependency>
|
<dependency>
|
||||||
<groupId>com.google.guava</groupId>
|
<groupId>com.google.guava</groupId>
|
||||||
<artifactId>guava</artifactId>
|
<artifactId>guava</artifactId>
|
||||||
<version>33.5.0-jre</version>
|
<version>32.0.0-jre</version>
|
||||||
</dependency>
|
</dependency>
|
||||||
|
|
||||||
<!-- https://mvnrepository.com/artifact/org.mariadb.jdbc/mariadb-java-client -->
|
<!-- https://mvnrepository.com/artifact/org.mariadb.jdbc/mariadb-java-client -->
|
||||||
@@ -187,7 +188,7 @@
|
|||||||
<plugin>
|
<plugin>
|
||||||
<groupId>org.apache.maven.plugins</groupId>
|
<groupId>org.apache.maven.plugins</groupId>
|
||||||
<artifactId>maven-clean-plugin</artifactId>
|
<artifactId>maven-clean-plugin</artifactId>
|
||||||
<version>3.5.0</version>
|
<version>2.5</version>
|
||||||
<configuration>
|
<configuration>
|
||||||
<filesets>
|
<filesets>
|
||||||
<fileset>
|
<fileset>
|
||||||
@@ -203,7 +204,7 @@
|
|||||||
<plugin>
|
<plugin>
|
||||||
<groupId>org.apache.maven.plugins</groupId>
|
<groupId>org.apache.maven.plugins</groupId>
|
||||||
<artifactId>maven-surefire-plugin</artifactId>
|
<artifactId>maven-surefire-plugin</artifactId>
|
||||||
<version>3.5.4</version>
|
<version>2.22.2</version>
|
||||||
<configuration>
|
<configuration>
|
||||||
<useSystemClassLoader>false</useSystemClassLoader>
|
<useSystemClassLoader>false</useSystemClassLoader>
|
||||||
</configuration>
|
</configuration>
|
||||||
@@ -211,7 +212,7 @@
|
|||||||
<plugin>
|
<plugin>
|
||||||
<groupId>org.apache.maven.plugins</groupId>
|
<groupId>org.apache.maven.plugins</groupId>
|
||||||
<artifactId>maven-gpg-plugin</artifactId>
|
<artifactId>maven-gpg-plugin</artifactId>
|
||||||
<version>3.2.8</version>
|
<version>3.0.1</version>
|
||||||
<executions>
|
<executions>
|
||||||
<execution>
|
<execution>
|
||||||
<id>sign-artifacts</id>
|
<id>sign-artifacts</id>
|
||||||
@@ -231,7 +232,7 @@
|
|||||||
<plugin>
|
<plugin>
|
||||||
<groupId>org.apache.maven.plugins</groupId>
|
<groupId>org.apache.maven.plugins</groupId>
|
||||||
<artifactId>maven-release-plugin</artifactId>
|
<artifactId>maven-release-plugin</artifactId>
|
||||||
<version>3.3.1</version>
|
<version>2.5.3</version>
|
||||||
<configuration>
|
<configuration>
|
||||||
<autoVersionSubmodules>true</autoVersionSubmodules>
|
<autoVersionSubmodules>true</autoVersionSubmodules>
|
||||||
<useReleaseProfile>false</useReleaseProfile>
|
<useReleaseProfile>false</useReleaseProfile>
|
||||||
@@ -245,7 +246,7 @@
|
|||||||
<plugin>
|
<plugin>
|
||||||
<groupId>org.apache.maven.plugins</groupId>
|
<groupId>org.apache.maven.plugins</groupId>
|
||||||
<artifactId>maven-compiler-plugin</artifactId>
|
<artifactId>maven-compiler-plugin</artifactId>
|
||||||
<version>3.15.0</version>
|
<version>3.8.1</version>
|
||||||
<configuration>
|
<configuration>
|
||||||
<source>${project.jdk.version}</source>
|
<source>${project.jdk.version}</source>
|
||||||
<target>${project.jdk.version}</target>
|
<target>${project.jdk.version}</target>
|
||||||
@@ -256,12 +257,12 @@
|
|||||||
<plugin>
|
<plugin>
|
||||||
<groupId>org.apache.maven.plugins</groupId>
|
<groupId>org.apache.maven.plugins</groupId>
|
||||||
<artifactId>maven-jar-plugin</artifactId>
|
<artifactId>maven-jar-plugin</artifactId>
|
||||||
<version>3.5.0</version>
|
<version>3.2.0</version>
|
||||||
</plugin>
|
</plugin>
|
||||||
<plugin>
|
<plugin>
|
||||||
<groupId>org.apache.maven.plugins</groupId>
|
<groupId>org.apache.maven.plugins</groupId>
|
||||||
<artifactId>maven-source-plugin</artifactId>
|
<artifactId>maven-source-plugin</artifactId>
|
||||||
<version>3.4.0</version>
|
<version>3.2.0</version>
|
||||||
<executions>
|
<executions>
|
||||||
<execution>
|
<execution>
|
||||||
<phase>package</phase>
|
<phase>package</phase>
|
||||||
@@ -0,0 +1 @@
|
|||||||
|
d68557bd29933455ff2842f2015d99ac
|
||||||
@@ -0,0 +1 @@
|
|||||||
|
270df9d2c15455ba2e250533611b3e7a3c0158a2
|
||||||
@@ -0,0 +1,12 @@
|
|||||||
|
<?xml version="1.0" encoding="UTF-8"?>
|
||||||
|
<metadata>
|
||||||
|
<groupId>cc.carm.plugin</groupId>
|
||||||
|
<artifactId>minesql-parent</artifactId>
|
||||||
|
<versioning>
|
||||||
|
<release>1.4.2</release>
|
||||||
|
<versions>
|
||||||
|
<version>1.4.2</version>
|
||||||
|
</versions>
|
||||||
|
<lastUpdated>20250206180420</lastUpdated>
|
||||||
|
</versioning>
|
||||||
|
</metadata>
|
||||||
@@ -0,0 +1 @@
|
|||||||
|
54e6860a27af465c3a3abcbdcd03504a
|
||||||
@@ -0,0 +1 @@
|
|||||||
|
bebefa6eb80cf4ee464bbfe073bf8a84d213163d
|
||||||
-174
@@ -1,174 +0,0 @@
|
|||||||
<?xml version="1.0" encoding="UTF-8"?>
|
|
||||||
<project xmlns="http://maven.apache.org/POM/4.0.0"
|
|
||||||
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
|
|
||||||
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
|
|
||||||
<parent>
|
|
||||||
<artifactId>minesql-parent</artifactId>
|
|
||||||
<groupId>cc.carm.plugin</groupId>
|
|
||||||
<version>1.4.3</version>
|
|
||||||
</parent>
|
|
||||||
<modelVersion>4.0.0</modelVersion>
|
|
||||||
<properties>
|
|
||||||
<maven.compiler.source>${project.jdk.version}</maven.compiler.source>
|
|
||||||
<maven.compiler.target>${project.jdk.version}</maven.compiler.target>
|
|
||||||
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
|
|
||||||
<maven.compiler.encoding>UTF-8</maven.compiler.encoding>
|
|
||||||
<maven.javadoc.skip>true</maven.javadoc.skip>
|
|
||||||
<maven.deploy.skip>true</maven.deploy.skip>
|
|
||||||
</properties>
|
|
||||||
<artifactId>minesql-core</artifactId>
|
|
||||||
|
|
||||||
<name>MineSQL-Core</name>
|
|
||||||
<description>轻松(用)SQL的独立运行库插件的主要实现部分。</description>
|
|
||||||
<url>https://github.com/CarmJos/MineSQL</url>
|
|
||||||
|
|
||||||
<developers>
|
|
||||||
<developer>
|
|
||||||
<id>CarmJos</id>
|
|
||||||
<name>Carm Jos</name>
|
|
||||||
<email>carm@carm.cc</email>
|
|
||||||
<url>https://www.carm.cc</url>
|
|
||||||
<roles>
|
|
||||||
<role>Main Developer</role>
|
|
||||||
<role>Designer</role>
|
|
||||||
</roles>
|
|
||||||
</developer>
|
|
||||||
</developers>
|
|
||||||
|
|
||||||
<licenses>
|
|
||||||
<license>
|
|
||||||
<name>GNU General Public License v3.0</name>
|
|
||||||
<url>https://opensource.org/licenses/GPL-3.0</url>
|
|
||||||
</license>
|
|
||||||
</licenses>
|
|
||||||
|
|
||||||
<issueManagement>
|
|
||||||
<system>GitHub Issues</system>
|
|
||||||
<url>https://github.com/CarmJos/MineSQL/issues</url>
|
|
||||||
</issueManagement>
|
|
||||||
|
|
||||||
<ciManagement>
|
|
||||||
<system>GitHub Actions</system>
|
|
||||||
<url>https://github.com/CarmJos/MineSQL/actions/workflows/maven.yml</url>
|
|
||||||
</ciManagement>
|
|
||||||
|
|
||||||
<dependencies>
|
|
||||||
|
|
||||||
<dependency>
|
|
||||||
<groupId>${project.parent.groupId}</groupId>
|
|
||||||
<artifactId>minesql-api</artifactId>
|
|
||||||
<version>${project.parent.version}</version>
|
|
||||||
<scope>compile</scope>
|
|
||||||
</dependency>
|
|
||||||
|
|
||||||
<dependency>
|
|
||||||
<groupId>co.aikar</groupId>
|
|
||||||
<artifactId>acf-core</artifactId>
|
|
||||||
<version>0.5.1-SNAPSHOT</version>
|
|
||||||
<scope>provided</scope>
|
|
||||||
</dependency>
|
|
||||||
|
|
||||||
<dependency>
|
|
||||||
<groupId>com.github.chris2018998</groupId>
|
|
||||||
<artifactId>beecp</artifactId>
|
|
||||||
<scope>compile</scope>
|
|
||||||
</dependency>
|
|
||||||
|
|
||||||
<dependency>
|
|
||||||
<groupId>cc.carm.lib</groupId>
|
|
||||||
<artifactId>easysql-impl</artifactId>
|
|
||||||
<scope>compile</scope>
|
|
||||||
</dependency>
|
|
||||||
|
|
||||||
<dependency>
|
|
||||||
<groupId>org.mariadb.jdbc</groupId>
|
|
||||||
<artifactId>mariadb-java-client</artifactId>
|
|
||||||
<scope>compile</scope>
|
|
||||||
</dependency>
|
|
||||||
|
|
||||||
<dependency>
|
|
||||||
<groupId>com.mysql</groupId>
|
|
||||||
<artifactId>mysql-connector-j</artifactId>
|
|
||||||
<scope>compile</scope>
|
|
||||||
</dependency>
|
|
||||||
|
|
||||||
<dependency>
|
|
||||||
<groupId>com.h2database</groupId>
|
|
||||||
<artifactId>h2</artifactId>
|
|
||||||
<scope>compile</scope>
|
|
||||||
</dependency>
|
|
||||||
|
|
||||||
<dependency>
|
|
||||||
<groupId>cc.carm.lib</groupId>
|
|
||||||
<artifactId>easyplugin-githubchecker</artifactId>
|
|
||||||
<version>${deps.easyplugin.version}</version>
|
|
||||||
<scope>compile</scope>
|
|
||||||
</dependency>
|
|
||||||
|
|
||||||
<dependency>
|
|
||||||
<groupId>cc.carm.lib</groupId>
|
|
||||||
<artifactId>easyplugin-utils</artifactId>
|
|
||||||
<version>${deps.easyplugin.version}</version>
|
|
||||||
<scope>compile</scope>
|
|
||||||
</dependency>
|
|
||||||
|
|
||||||
<dependency>
|
|
||||||
<groupId>cc.carm.lib</groupId>
|
|
||||||
<artifactId>configured-yaml</artifactId>
|
|
||||||
<version>${deps.easyconf.version}</version>
|
|
||||||
<scope>compile</scope>
|
|
||||||
</dependency>
|
|
||||||
|
|
||||||
</dependencies>
|
|
||||||
|
|
||||||
<build>
|
|
||||||
<plugins>
|
|
||||||
<plugin>
|
|
||||||
<groupId>org.apache.maven.plugins</groupId>
|
|
||||||
<artifactId>maven-compiler-plugin</artifactId>
|
|
||||||
</plugin>
|
|
||||||
<plugin>
|
|
||||||
<artifactId>maven-resources-plugin</artifactId>
|
|
||||||
<version>3.4.0</version>
|
|
||||||
<executions>
|
|
||||||
<execution>
|
|
||||||
<id>filter-version</id>
|
|
||||||
<phase>process-resources</phase>
|
|
||||||
<goals>
|
|
||||||
<goal>copy-resources</goal>
|
|
||||||
</goals>
|
|
||||||
<configuration>
|
|
||||||
<outputDirectory>${project.build.directory}/generated-sources/java</outputDirectory>
|
|
||||||
<resources>
|
|
||||||
<resource>
|
|
||||||
<directory>src/main/templates</directory>
|
|
||||||
<filtering>true</filtering>
|
|
||||||
</resource>
|
|
||||||
</resources>
|
|
||||||
</configuration>
|
|
||||||
</execution>
|
|
||||||
</executions>
|
|
||||||
</plugin>
|
|
||||||
<plugin>
|
|
||||||
<groupId>org.codehaus.mojo</groupId>
|
|
||||||
<artifactId>build-helper-maven-plugin</artifactId>
|
|
||||||
<version>3.6.1</version>
|
|
||||||
<executions>
|
|
||||||
<execution>
|
|
||||||
<id>add-source</id>
|
|
||||||
<phase>generate-sources</phase>
|
|
||||||
<goals>
|
|
||||||
<goal>add-source</goal>
|
|
||||||
</goals>
|
|
||||||
<configuration>
|
|
||||||
<sources>
|
|
||||||
<source>${project.build.directory}/generated-sources/java</source>
|
|
||||||
</sources>
|
|
||||||
</configuration>
|
|
||||||
</execution>
|
|
||||||
</executions>
|
|
||||||
</plugin>
|
|
||||||
</plugins>
|
|
||||||
</build>
|
|
||||||
|
|
||||||
</project>
|
|
||||||
@@ -1,318 +0,0 @@
|
|||||||
package cc.carm.plugin.minesql;
|
|
||||||
|
|
||||||
import cc.carm.lib.configuration.source.ConfigurationHolder;
|
|
||||||
import cc.carm.lib.configuration.source.yaml.YAMLConfigFactory;
|
|
||||||
import cc.carm.lib.easyplugin.utils.JarResourceUtils;
|
|
||||||
import cc.carm.lib.easysql.api.SQLManager;
|
|
||||||
import cc.carm.lib.easysql.api.SQLQuery;
|
|
||||||
import cc.carm.lib.easysql.manager.SQLManagerImpl;
|
|
||||||
import cc.carm.lib.githubreleases4j.GithubReleases4J;
|
|
||||||
import cc.carm.plugin.minesql.api.source.SQLSourceConfig;
|
|
||||||
import cc.carm.plugin.minesql.api.table.SQLTablesRoot;
|
|
||||||
import cc.carm.plugin.minesql.api.table.SimpleSQLTable;
|
|
||||||
import cc.carm.plugin.minesql.command.MineSQLCommand;
|
|
||||||
import cc.carm.plugin.minesql.command.MineSQLHelpFormatter;
|
|
||||||
import cc.carm.plugin.minesql.conf.PluginConfiguration;
|
|
||||||
import cc.carm.plugin.minesql.conf.SQLSourceGroup;
|
|
||||||
import cc.carm.plugin.minesql.util.DBPropertiesUtil;
|
|
||||||
import co.aikar.commands.CommandManager;
|
|
||||||
import co.aikar.commands.InvalidCommandArgument;
|
|
||||||
import co.aikar.commands.Locales;
|
|
||||||
import org.jetbrains.annotations.NotNull;
|
|
||||||
import org.jetbrains.annotations.Nullable;
|
|
||||||
import org.stone.beecp.BeeDataSource;
|
|
||||||
import org.stone.beecp.BeeDataSourceConfig;
|
|
||||||
|
|
||||||
import javax.sql.DataSource;
|
|
||||||
import java.io.File;
|
|
||||||
import java.lang.reflect.Field;
|
|
||||||
import java.sql.SQLException;
|
|
||||||
import java.util.*;
|
|
||||||
import java.util.function.Consumer;
|
|
||||||
import java.util.logging.Logger;
|
|
||||||
|
|
||||||
public class MineSQLCore implements IMineSQL {
|
|
||||||
|
|
||||||
protected static MineSQLCore instance;
|
|
||||||
|
|
||||||
|
|
||||||
protected final MineSQLPlatform platform;
|
|
||||||
|
|
||||||
protected final MineSQLRegistry registry;
|
|
||||||
protected final ConfigurationHolder<?> configProvider;
|
|
||||||
protected final PluginConfiguration config;
|
|
||||||
|
|
||||||
public MineSQLCore(MineSQLPlatform platform) {
|
|
||||||
instance = this;
|
|
||||||
this.platform = platform;
|
|
||||||
|
|
||||||
getLogger().info("加载配置文件...");
|
|
||||||
this.configProvider = YAMLConfigFactory.from(new File(platform.getPluginFolder(), "config.yml")).build();
|
|
||||||
this.config = new PluginConfiguration();
|
|
||||||
this.configProvider.initialize(this.config);
|
|
||||||
|
|
||||||
getLogger().info("初始化MineSQL API...");
|
|
||||||
MineSQL.initializeAPI(this);
|
|
||||||
|
|
||||||
getLogger().info("初始化注册池...");
|
|
||||||
this.registry = createRegistry();
|
|
||||||
|
|
||||||
Map<String, Properties> dbProperties = readProperties();
|
|
||||||
Map<String, SQLSourceConfig> dbConfigurations = readConfigurations();
|
|
||||||
|
|
||||||
if (dbProperties.isEmpty() && dbConfigurations.isEmpty()) {
|
|
||||||
getLogger().warning("未检测到任何数据库配置,将不会预创建任何SQLManager。");
|
|
||||||
return;
|
|
||||||
}
|
|
||||||
|
|
||||||
dbProperties.forEach((id, properties) -> {
|
|
||||||
try {
|
|
||||||
getLogger().info("正在初始化数据库 #" + id + " ...");
|
|
||||||
SQLManagerImpl sqlManager = create(id, properties);
|
|
||||||
this.registry.getManagers().put(id, sqlManager);
|
|
||||||
getLogger().info("完成成初始化数据库 #" + id + " 。");
|
|
||||||
} catch (Exception ex) {
|
|
||||||
getLogger().severe("初始化SQLManager(#" + id + ") 出错,请检查配置文件: " + ex.getMessage());
|
|
||||||
ex.printStackTrace();
|
|
||||||
}
|
|
||||||
});
|
|
||||||
|
|
||||||
dbConfigurations.forEach((id, configuration) -> {
|
|
||||||
try {
|
|
||||||
getLogger().info("正在初始化数据库 #" + id + " ...");
|
|
||||||
SQLManagerImpl sqlManager = create(id, configuration);
|
|
||||||
this.registry.getManagers().put(id, sqlManager);
|
|
||||||
getLogger().info("完成初始化数据库 #" + id + " 。");
|
|
||||||
} catch (Exception ex) {
|
|
||||||
getLogger().severe("初始化SQLManager(#" + id + ") 出错,请检查配置文件: " + ex.getMessage());
|
|
||||||
ex.printStackTrace();
|
|
||||||
}
|
|
||||||
});
|
|
||||||
}
|
|
||||||
|
|
||||||
public MineSQLPlatform getPlatform() {
|
|
||||||
return platform;
|
|
||||||
}
|
|
||||||
|
|
||||||
public static MineSQLCore getInstance() {
|
|
||||||
return instance;
|
|
||||||
}
|
|
||||||
|
|
||||||
@Override
|
|
||||||
public @NotNull MineSQLRegistry getRegistry() {
|
|
||||||
return this.registry;
|
|
||||||
}
|
|
||||||
|
|
||||||
@Override
|
|
||||||
public @NotNull MineSQLRegistry createRegistry() {
|
|
||||||
return new MineSQLRegistry();
|
|
||||||
}
|
|
||||||
|
|
||||||
@Override
|
|
||||||
public @NotNull SQLManagerImpl create(@NotNull String name, @NotNull SQLSourceConfig conf) throws Exception {
|
|
||||||
BeeDataSourceConfig config = new BeeDataSourceConfig();
|
|
||||||
config.setDriverClassName(conf.getDriverClassName());
|
|
||||||
config.setJdbcUrl(conf.getJdbcURL());
|
|
||||||
Optional.ofNullable(conf.getUsername()).ifPresent(config::setUsername);
|
|
||||||
Optional.ofNullable(conf.getPassword()).ifPresent(config::setPassword);
|
|
||||||
|
|
||||||
Optional.ofNullable(conf.getSettings().getPoolName()).ifPresent(config::setPoolName);
|
|
||||||
Optional.ofNullable(conf.getSettings().getMaxPoolSize()).ifPresent(config::setMaxActive);
|
|
||||||
Optional.ofNullable(conf.getSettings().getMaxActive()).ifPresent(config::setMaxActive);
|
|
||||||
|
|
||||||
Optional.ofNullable(conf.getSettings().getIdleTimeout()).ifPresent(config::setIdleTimeout);
|
|
||||||
Optional.ofNullable(conf.getSettings().getMaxWaitTime()).ifPresent(config::setMaxWait);
|
|
||||||
Optional.ofNullable(conf.getSettings().getMaxHoldTime()).ifPresent(config::setHoldTimeout);
|
|
||||||
|
|
||||||
Optional.ofNullable(conf.getSettings().getAutoCommit()).ifPresent(config::setDefaultAutoCommit);
|
|
||||||
Optional.ofNullable(conf.getSettings().getReadOnly()).ifPresent(config::setDefaultReadOnly);
|
|
||||||
Optional.ofNullable(conf.getSettings().getSchema()).ifPresent(config::setDefaultSchema);
|
|
||||||
|
|
||||||
Optional.ofNullable(conf.getSettings().getValidationSQL()).ifPresent(config::setAliveTestSql);
|
|
||||||
Optional.ofNullable(conf.getSettings().getValidationTimeout()).ifPresent(config::setAliveTestTimeout);
|
|
||||||
Optional.ofNullable(conf.getSettings().getValidationInterval()).ifPresent(config::setTimerCheckInterval);
|
|
||||||
|
|
||||||
SQLManagerImpl manager = create(name, config);
|
|
||||||
if (conf.getInitializer() != null) {
|
|
||||||
conf.getInitializer().accept(manager);
|
|
||||||
}
|
|
||||||
|
|
||||||
return manager;
|
|
||||||
}
|
|
||||||
|
|
||||||
@Override
|
|
||||||
public @NotNull SQLManagerImpl create(@NotNull String name, @NotNull Properties properties) {
|
|
||||||
return create(name, new BeeDataSourceConfig(properties));
|
|
||||||
}
|
|
||||||
|
|
||||||
@Override
|
|
||||||
public @NotNull SQLManagerImpl create(@NotNull String name, @NotNull DataSource source) {
|
|
||||||
return new SQLManagerImpl(source, name);
|
|
||||||
}
|
|
||||||
|
|
||||||
public @NotNull SQLManagerImpl create(@NotNull String name, @NotNull BeeDataSourceConfig configuration) {
|
|
||||||
return create(name, (DataSource) new BeeDataSource(configuration));
|
|
||||||
}
|
|
||||||
|
|
||||||
@Override
|
|
||||||
public void shutdown(SQLManager manager, @Nullable Consumer<Map<UUID, SQLQuery>> activeQueries) {
|
|
||||||
if (activeQueries != null) activeQueries.accept(manager.getActiveQuery());
|
|
||||||
|
|
||||||
if (manager.getDataSource() instanceof BeeDataSource) {
|
|
||||||
BeeDataSource dataSource = (BeeDataSource) manager.getDataSource();
|
|
||||||
dataSource.close(); //Close bee connection pool
|
|
||||||
}
|
|
||||||
}
|
|
||||||
|
|
||||||
@Override
|
|
||||||
public void createTables(@NotNull SQLTablesRoot tablesRoot) throws SQLException {
|
|
||||||
for (Field field : tablesRoot.getClass().getDeclaredFields()) {
|
|
||||||
initializeTableField(tablesRoot, field);
|
|
||||||
}
|
|
||||||
}
|
|
||||||
|
|
||||||
@Override
|
|
||||||
public void createTables(@NotNull Class<? extends SQLTablesRoot> clazz) throws SQLException {
|
|
||||||
initializeTableClass(clazz);
|
|
||||||
}
|
|
||||||
|
|
||||||
protected void initializeTableClass(@NotNull Class<?> clazz) throws SQLException {
|
|
||||||
if (!SQLTablesRoot.class.isAssignableFrom(clazz)) return;
|
|
||||||
|
|
||||||
for (Field field : clazz.getDeclaredFields()) {
|
|
||||||
initializeTableField(clazz, field);
|
|
||||||
}
|
|
||||||
|
|
||||||
for (Class<?> subClass : clazz.getDeclaredClasses()) {
|
|
||||||
initializeTableClass(subClass);
|
|
||||||
}
|
|
||||||
|
|
||||||
}
|
|
||||||
|
|
||||||
protected void initializeTableField(@NotNull Object source, @NotNull Field field) throws SQLException {
|
|
||||||
try {
|
|
||||||
field.setAccessible(true);
|
|
||||||
Object object = field.get(source);
|
|
||||||
|
|
||||||
if (object instanceof SimpleSQLTable) {
|
|
||||||
((SimpleSQLTable) object).create();
|
|
||||||
} else if (source instanceof SQLTablesRoot && object instanceof SQLTablesRoot) {
|
|
||||||
createTables((SQLTablesRoot) object);
|
|
||||||
} else if (source instanceof Class<?> && object instanceof Class<?>) {
|
|
||||||
// 当且仅当 源字段与字段 均为静态类时,才对目标字段进行下一步初始化加载。
|
|
||||||
initializeTableClass((Class<?>) object);
|
|
||||||
}
|
|
||||||
} catch (IllegalAccessException ignored) {
|
|
||||||
}
|
|
||||||
}
|
|
||||||
|
|
||||||
public void shutdownAll() {
|
|
||||||
this.registry.getManagers().forEach((k, manager) -> {
|
|
||||||
getLogger().info(" 正在关闭数据库 " + k + "...");
|
|
||||||
shutdown(manager, activeQueries -> {
|
|
||||||
if (activeQueries.isEmpty()) return;
|
|
||||||
getLogger().info(" 数据库 " + k + " 仍有 " + activeQueries.size() + " 条活动查询");
|
|
||||||
if (manager.getDataSource() instanceof BeeDataSource
|
|
||||||
&& getConfig().SETTINGS.FORCE_CLOSE.getNotNull()) {
|
|
||||||
getLogger().info(" 将强制关闭全部活跃链接...");
|
|
||||||
BeeDataSource dataSource = (BeeDataSource) manager.getDataSource();
|
|
||||||
dataSource.close(); //Close bee connection pool
|
|
||||||
}
|
|
||||||
});
|
|
||||||
});
|
|
||||||
this.registry.getManagers().clear();
|
|
||||||
}
|
|
||||||
|
|
||||||
@Override
|
|
||||||
public @NotNull File getPluginFolder() {
|
|
||||||
return getPlatform().getPluginFolder();
|
|
||||||
}
|
|
||||||
|
|
||||||
@Override
|
|
||||||
public @NotNull Logger getLogger() {
|
|
||||||
return getPlatform().getLogger();
|
|
||||||
}
|
|
||||||
|
|
||||||
public PluginConfiguration getConfig() {
|
|
||||||
return config;
|
|
||||||
}
|
|
||||||
|
|
||||||
public ConfigurationHolder<?> getConfigProvider() {
|
|
||||||
return configProvider;
|
|
||||||
}
|
|
||||||
|
|
||||||
public @NotNull Map<String, SQLSourceConfig> readConfigurations() {
|
|
||||||
SQLSourceGroup group = getConfig().SOURCES.getNotNull();
|
|
||||||
Map<String, SQLSourceConfig> sources = new LinkedHashMap<>();
|
|
||||||
group.getSources().entrySet().stream()
|
|
||||||
.filter(entry -> !entry.getKey().startsWith("example-"))
|
|
||||||
.forEach(entry -> sources.put(entry.getKey(), entry.getValue().createSource()));
|
|
||||||
return sources;
|
|
||||||
}
|
|
||||||
|
|
||||||
public @NotNull Map<String, Properties> readProperties() {
|
|
||||||
if (!getConfig().PROPERTIES.ENABLE.getNotNull()) return new HashMap<>();
|
|
||||||
|
|
||||||
String propertiesFolder = getConfig().PROPERTIES.FOLDER.get();
|
|
||||||
if (propertiesFolder == null || propertiesFolder.length() == 0) return new HashMap<>();
|
|
||||||
|
|
||||||
File file = new File(getPluginFolder(), propertiesFolder);
|
|
||||||
if (!file.exists() || !file.isDirectory()) {
|
|
||||||
if ((propertiesFolder.equals("db-properties/") || propertiesFolder.equals("db-properties"))) {
|
|
||||||
try {
|
|
||||||
JarResourceUtils.copyFolderFromJar(
|
|
||||||
"db-properties", getPluginFolder(),
|
|
||||||
JarResourceUtils.CopyOption.COPY_IF_NOT_EXIST
|
|
||||||
);
|
|
||||||
} catch (Exception ex) {
|
|
||||||
getLogger().severe("初始化properties示例文件失败:" + ex.getMessage());
|
|
||||||
}
|
|
||||||
} else {
|
|
||||||
file.mkdirs();
|
|
||||||
}
|
|
||||||
}
|
|
||||||
|
|
||||||
return DBPropertiesUtil.readFromFolder(file);
|
|
||||||
}
|
|
||||||
|
|
||||||
@SuppressWarnings("deprecation")
|
|
||||||
protected void initializeCommands(CommandManager<?, ?, ?, ?, ?, ?> commandManager) {
|
|
||||||
commandManager.enableUnstableAPI("help");
|
|
||||||
commandManager.setHelpFormatter(new MineSQLHelpFormatter(commandManager));
|
|
||||||
commandManager.getLocales().setDefaultLocale(Locales.SIMPLIFIED_CHINESE);
|
|
||||||
commandManager.getCommandContexts().registerContext(SQLManager.class, c -> {
|
|
||||||
String name = c.popFirstArg();
|
|
||||||
try {
|
|
||||||
return getRegistry().getNotNull(name);
|
|
||||||
} catch (NullPointerException exception) {
|
|
||||||
throw new InvalidCommandArgument("不存在名为 " + name + " 的数据库管理器。");
|
|
||||||
}
|
|
||||||
});
|
|
||||||
commandManager.getCommandCompletions().registerCompletion("sql-managers", c -> {
|
|
||||||
if (c.getIssuer().isPlayer()) return Collections.emptyList();
|
|
||||||
else return getRegistry().list().keySet();
|
|
||||||
});
|
|
||||||
commandManager.registerCommand(new MineSQLCommand(this));
|
|
||||||
}
|
|
||||||
|
|
||||||
public void checkUpdate(String currentVersion) {
|
|
||||||
Logger logger = getLogger();
|
|
||||||
|
|
||||||
Integer behindVersions = GithubReleases4J.getVersionBehind(References.REPO_OWNER, References.REPO_NAME, currentVersion);
|
|
||||||
String downloadURL = GithubReleases4J.getReleasesURL(References.REPO_OWNER, References.REPO_NAME);
|
|
||||||
if (behindVersions == null) {
|
|
||||||
logger.severe("检查更新失败,请您定期查看插件是否更新,避免安全问题。");
|
|
||||||
logger.severe("下载地址 " + downloadURL);
|
|
||||||
} else if (behindVersions < 0) {
|
|
||||||
logger.severe("检查更新失败! 当前版本未知,请您使用原生版本以避免安全问题。");
|
|
||||||
logger.severe("最新版下载地址 " + downloadURL);
|
|
||||||
} else if (behindVersions > 0) {
|
|
||||||
logger.warning("发现新版本! 目前已落后 " + behindVersions + " 个版本。");
|
|
||||||
logger.warning("最新版下载地址 " + downloadURL);
|
|
||||||
} else {
|
|
||||||
logger.info("检查完成,当前已是最新版本。");
|
|
||||||
}
|
|
||||||
}
|
|
||||||
|
|
||||||
|
|
||||||
}
|
|
||||||
@@ -1,18 +0,0 @@
|
|||||||
package cc.carm.plugin.minesql;
|
|
||||||
|
|
||||||
import co.aikar.commands.CommandManager;
|
|
||||||
import org.jetbrains.annotations.NotNull;
|
|
||||||
import org.jetbrains.annotations.Nullable;
|
|
||||||
|
|
||||||
import java.io.File;
|
|
||||||
import java.util.logging.Logger;
|
|
||||||
|
|
||||||
public interface MineSQLPlatform {
|
|
||||||
|
|
||||||
@NotNull File getPluginFolder();
|
|
||||||
|
|
||||||
@NotNull Logger getLogger();
|
|
||||||
|
|
||||||
@Nullable CommandManager<?, ?, ?, ?, ?, ?> getCommandManager();
|
|
||||||
|
|
||||||
}
|
|
||||||
@@ -1,50 +0,0 @@
|
|||||||
package cc.carm.plugin.minesql;
|
|
||||||
|
|
||||||
import cc.carm.lib.easysql.api.SQLManager;
|
|
||||||
import cc.carm.plugin.minesql.api.SQLRegistry;
|
|
||||||
import org.jetbrains.annotations.NotNull;
|
|
||||||
import org.jetbrains.annotations.Nullable;
|
|
||||||
import org.jetbrains.annotations.Unmodifiable;
|
|
||||||
|
|
||||||
import java.util.Collections;
|
|
||||||
import java.util.HashMap;
|
|
||||||
import java.util.Map;
|
|
||||||
import java.util.Optional;
|
|
||||||
|
|
||||||
public class MineSQLRegistry implements SQLRegistry {
|
|
||||||
|
|
||||||
private final HashMap<String, SQLManager> managers = new HashMap<>();
|
|
||||||
|
|
||||||
protected HashMap<String, SQLManager> getManagers() {
|
|
||||||
return managers;
|
|
||||||
}
|
|
||||||
|
|
||||||
@Override
|
|
||||||
public @NotNull Optional<@Nullable SQLManager> getOptional(@Nullable String id) {
|
|
||||||
if (id != null) return Optional.of(this.managers.get(id));
|
|
||||||
else if (managers.isEmpty()) return Optional.empty();
|
|
||||||
else return Optional.ofNullable(managers.values().iterator().next());
|
|
||||||
}
|
|
||||||
|
|
||||||
@Override
|
|
||||||
@Unmodifiable
|
|
||||||
public @NotNull Map<String, SQLManager> list() {
|
|
||||||
return Collections.unmodifiableMap(this.managers);
|
|
||||||
}
|
|
||||||
|
|
||||||
@Override
|
|
||||||
public void register(@NotNull String name, @NotNull SQLManager sqlManager) throws IllegalStateException {
|
|
||||||
if (this.managers.containsKey(name)) {
|
|
||||||
throw new IllegalStateException("已存在ID为 " + name + " 的SQLManager实例。");
|
|
||||||
}
|
|
||||||
this.managers.put(name, sqlManager);
|
|
||||||
}
|
|
||||||
|
|
||||||
@Override
|
|
||||||
public @NotNull SQLManager unregister(@NotNull String name) throws NullPointerException {
|
|
||||||
SQLManager manager = this.managers.remove(name);
|
|
||||||
if (manager == null) throw new NullPointerException("不存在ID为 " + name + " 的SQLManager实例。");
|
|
||||||
return manager;
|
|
||||||
}
|
|
||||||
|
|
||||||
}
|
|
||||||
@@ -1,103 +0,0 @@
|
|||||||
package cc.carm.plugin.minesql.command;
|
|
||||||
|
|
||||||
import cc.carm.lib.easysql.api.SQLManager;
|
|
||||||
import cc.carm.lib.easysql.api.SQLQuery;
|
|
||||||
import cc.carm.plugin.minesql.MineSQLCore;
|
|
||||||
import cc.carm.plugin.minesql.lib.PluginLibraries;
|
|
||||||
import cc.carm.plugin.minesql.util.VersionReader;
|
|
||||||
import co.aikar.commands.BaseCommand;
|
|
||||||
import co.aikar.commands.CommandHelp;
|
|
||||||
import co.aikar.commands.CommandIssuer;
|
|
||||||
import co.aikar.commands.annotation.*;
|
|
||||||
|
|
||||||
import java.util.Map;
|
|
||||||
import java.util.UUID;
|
|
||||||
|
|
||||||
|
|
||||||
@SuppressWarnings("unused")
|
|
||||||
@CommandAlias("MineSQL")
|
|
||||||
@Description("MineSQL的主指令,用于开发者进行调试,只允许后台执行。")
|
|
||||||
public class MineSQLCommand extends BaseCommand {
|
|
||||||
|
|
||||||
protected final MineSQLCore core;
|
|
||||||
|
|
||||||
public MineSQLCommand(MineSQLCore core) {
|
|
||||||
this.core = core;
|
|
||||||
}
|
|
||||||
|
|
||||||
@HelpCommand
|
|
||||||
@Syntax("&9[页码或子指令名称]")
|
|
||||||
@Description("查看指定数据源的统计信息与当前仍未关闭的查询。")
|
|
||||||
public void help(CommandIssuer issuer, CommandHelp help) {
|
|
||||||
if (issuer.isPlayer()) {
|
|
||||||
issuer.sendMessage("§c只有后台执行才能使用此命令。");
|
|
||||||
return;
|
|
||||||
}
|
|
||||||
help.showHelp();
|
|
||||||
}
|
|
||||||
|
|
||||||
@Subcommand("version")
|
|
||||||
@Description("查看当前插件版本与核心库(EasySQL)版本。")
|
|
||||||
public void version(CommandIssuer issuer) {
|
|
||||||
if (issuer.isPlayer()) {
|
|
||||||
issuer.sendMessage("§c只有后台执行才能使用此命令。");
|
|
||||||
return;
|
|
||||||
}
|
|
||||||
VersionReader reader = PluginLibraries.READER;
|
|
||||||
String pluginVersion = reader.get("plugin", null);
|
|
||||||
if (pluginVersion == null) {
|
|
||||||
issuer.sendMessage("§c无法获取当前版本信息,请保证使用原生版本以避免安全问题。");
|
|
||||||
return;
|
|
||||||
}
|
|
||||||
issuer.sendMessage("§r当前插件版本为 §b" + pluginVersion + "§r。 §7(基于 EasySQL &3" + reader.get("api") + "&7)");
|
|
||||||
issuer.sendMessage("§8 - &f连接池依赖 BeeCP §9" + reader.get("beecp"));
|
|
||||||
issuer.sendMessage("§8 - &f数据库驱动 MySQL §9" + PluginLibraries.MYSQL_DRIVER.getVersion());
|
|
||||||
issuer.sendMessage("§8 - &f数据库驱动 MariaDB §9" + PluginLibraries.MARIADB_DRIVER.getVersion());
|
|
||||||
issuer.sendMessage("§8 - &f数据库驱动 h2-database §9" + PluginLibraries.H2_DRIVER.getVersion());
|
|
||||||
|
|
||||||
issuer.sendMessage("§r正在检查插件更新,请稍候...");
|
|
||||||
core.checkUpdate(pluginVersion);
|
|
||||||
}
|
|
||||||
|
|
||||||
@Subcommand("list")
|
|
||||||
@Description("列出当前所有的数据源管理器与相关信息。")
|
|
||||||
public void list(CommandIssuer issuer) {
|
|
||||||
if (issuer.isPlayer()) {
|
|
||||||
issuer.sendMessage("§c只有后台执行才能使用此命令。");
|
|
||||||
return;
|
|
||||||
}
|
|
||||||
Map<String, ? extends SQLManager> runningManagers = MineSQLCore.getInstance().getRegistry().list();
|
|
||||||
if (runningManagers.isEmpty()) {
|
|
||||||
issuer.sendMessage("§r当前无正在运行的数据库管理器。");
|
|
||||||
} else {
|
|
||||||
issuer.sendMessage("§r当前有 §b" + runningManagers.size() + " §r个正在运行的数据库管理器:");
|
|
||||||
runningManagers.forEach(
|
|
||||||
(name, manager) -> issuer.sendMessage("- " + name + " (" + manager.getActiveQuery().size() + " running)")
|
|
||||||
);
|
|
||||||
}
|
|
||||||
|
|
||||||
}
|
|
||||||
|
|
||||||
@Subcommand("info")
|
|
||||||
@CommandCompletion("@sql-managers")
|
|
||||||
@Syntax("&9<数据源名称>")
|
|
||||||
@Description("查看指定数据源的统计信息与当前仍未关闭的查询。")
|
|
||||||
public void info(CommandIssuer issuer,
|
|
||||||
@Syntax("&9数据源名称") @Description("数据源管理器名称,一般在配置文件中指定。") SQLManager manager) {
|
|
||||||
if (issuer.isPlayer()) {
|
|
||||||
issuer.sendMessage("§c只有后台执行才能使用此命令。");
|
|
||||||
return;
|
|
||||||
}
|
|
||||||
Map<UUID, SQLQuery> activeQueries = manager.getActiveQuery();
|
|
||||||
if (activeQueries.isEmpty()) {
|
|
||||||
issuer.sendMessage("§r当前暂无活跃查询。");
|
|
||||||
} else {
|
|
||||||
issuer.sendMessage("§r当前有 §b" + activeQueries.size() + " §r个活跃查询:");
|
|
||||||
activeQueries.forEach((uuid, query) -> {
|
|
||||||
issuer.sendMessage("§8#§b " + uuid.toString());
|
|
||||||
issuer.sendMessage("§8-§f " + query.getSQLContent());
|
|
||||||
});
|
|
||||||
}
|
|
||||||
}
|
|
||||||
|
|
||||||
}
|
|
||||||
@@ -1,67 +0,0 @@
|
|||||||
package cc.carm.plugin.minesql.command;
|
|
||||||
|
|
||||||
import co.aikar.commands.*;
|
|
||||||
|
|
||||||
public class MineSQLHelpFormatter extends CommandHelpFormatter {
|
|
||||||
|
|
||||||
public MineSQLHelpFormatter(CommandManager manager) {
|
|
||||||
super(manager);
|
|
||||||
}
|
|
||||||
|
|
||||||
@Override
|
|
||||||
public void printHelpHeader(CommandHelp help, CommandIssuer issuer) {
|
|
||||||
issuer.sendMessage("§3§lMineSQL §7指令帮助");
|
|
||||||
}
|
|
||||||
|
|
||||||
@Override
|
|
||||||
public void printHelpCommand(CommandHelp help, CommandIssuer issuer, HelpEntry entry) {
|
|
||||||
issuer.sendMessage("§8# §f" + entry.getCommand() + " §r" + entry.getParameterSyntax());
|
|
||||||
if (!entry.getDescription().isEmpty()) {
|
|
||||||
issuer.sendMessage("§8- §7" + entry.getDescription());
|
|
||||||
}
|
|
||||||
}
|
|
||||||
|
|
||||||
@Override
|
|
||||||
public void printHelpFooter(CommandHelp help, CommandIssuer issuer) {
|
|
||||||
}
|
|
||||||
|
|
||||||
@Override
|
|
||||||
public void printSearchHeader(CommandHelp help, CommandIssuer issuer) {
|
|
||||||
issuer.sendMessage("§3§lMineSQL §7指令帮助查询");
|
|
||||||
}
|
|
||||||
|
|
||||||
@Override
|
|
||||||
public void printSearchEntry(CommandHelp help, CommandIssuer issuer, HelpEntry entry) {
|
|
||||||
printHelpCommand(help, issuer, entry);
|
|
||||||
}
|
|
||||||
|
|
||||||
@Override
|
|
||||||
public void printSearchFooter(CommandHelp help, CommandIssuer issuer) {
|
|
||||||
}
|
|
||||||
|
|
||||||
@Override
|
|
||||||
public void printDetailedHelpHeader(CommandHelp help, CommandIssuer issuer, HelpEntry entry) {
|
|
||||||
issuer.sendMessage("§3§lMineSQL §7指令帮助 §8(§f" + entry.getCommand() + "§8)");
|
|
||||||
}
|
|
||||||
|
|
||||||
@Override
|
|
||||||
public void printDetailedHelpCommand(CommandHelp help, CommandIssuer issuer, HelpEntry entry) {
|
|
||||||
printHelpCommand(help, issuer, entry);
|
|
||||||
}
|
|
||||||
|
|
||||||
@Override
|
|
||||||
public void printDetailedParameter(CommandHelp help, CommandIssuer issuer, HelpEntry entry, CommandParameter param) {
|
|
||||||
if (param.getDescription() != null) {
|
|
||||||
if (param.getSyntax() != null) {
|
|
||||||
issuer.sendMessage("§8@§r" + param.getSyntax() + "§7 §f" + param.getDescription());
|
|
||||||
} else {
|
|
||||||
issuer.sendMessage("§8@§f" + param.getName() + "§7 §f" + param.getDescription());
|
|
||||||
}
|
|
||||||
}
|
|
||||||
}
|
|
||||||
|
|
||||||
@Override
|
|
||||||
public void printDetailedHelpFooter(CommandHelp help, CommandIssuer issuer, HelpEntry entry) {
|
|
||||||
}
|
|
||||||
|
|
||||||
}
|
|
||||||
@@ -1,72 +0,0 @@
|
|||||||
package cc.carm.plugin.minesql.conf;
|
|
||||||
|
|
||||||
import cc.carm.lib.configuration.Configuration;
|
|
||||||
import cc.carm.lib.configuration.annotation.ConfigPath;
|
|
||||||
import cc.carm.lib.configuration.annotation.HeaderComments;
|
|
||||||
import cc.carm.lib.configuration.value.standard.ConfiguredValue;
|
|
||||||
|
|
||||||
@ConfigPath(root = true)
|
|
||||||
public class PluginConfiguration implements Configuration {
|
|
||||||
|
|
||||||
@HeaderComments("排错模式,一般留给开发者检查问题,平常使用无需开启。")
|
|
||||||
public final ConfiguredValue<Boolean> DEBUG = ConfiguredValue.of(Boolean.class, false);
|
|
||||||
|
|
||||||
@HeaderComments({"",
|
|
||||||
"统计数据设定",
|
|
||||||
"该选项用于帮助开发者统计插件版本与使用情况,且绝不会影响性能与使用体验。",
|
|
||||||
"当然,您也可以选择在这里关闭,或在plugins/bStats下的配置文件中关闭所有插件的统计信息。"
|
|
||||||
})
|
|
||||||
public final ConfiguredValue<Boolean> METRICS = ConfiguredValue.of(Boolean.class, true);
|
|
||||||
|
|
||||||
@HeaderComments({"",
|
|
||||||
"检查更新设定",
|
|
||||||
"该选项用于插件判断是否要检查更新,若您不希望插件检查更新并提示您,可以选择关闭。",
|
|
||||||
"检查更新为异步操作,绝不会影响性能与使用体验。"
|
|
||||||
})
|
|
||||||
public final ConfiguredValue<Boolean> UPDATE_CHECKER = ConfiguredValue.of(Boolean.class, true);
|
|
||||||
|
|
||||||
@HeaderComments({"插件注册池配置"})
|
|
||||||
public final SettingsConfig SETTINGS = new SettingsConfig();
|
|
||||||
|
|
||||||
@HeaderComments({"",
|
|
||||||
"Properties 数据库配置文件配置",
|
|
||||||
"相关配置介绍(BeeCP) https://github.com/Chris2018998/BeeCP/wiki/Configuration--List#配置列表"
|
|
||||||
})
|
|
||||||
public final PropertiesConfig PROPERTIES = new PropertiesConfig();
|
|
||||||
|
|
||||||
@HeaderComments({"",
|
|
||||||
"数据库源配置",
|
|
||||||
"目前支持的驱动类型(type)有 mariadb、mysql、h2-file(文件数据库) 与 h2-mem(内存临时数据库)。",
|
|
||||||
"详细配置介绍请查看 https://github.com/CarmJos/MineSQL/.doc/README.md"
|
|
||||||
})
|
|
||||||
public final ConfiguredValue<SQLSourceGroup> SOURCES = ConfiguredValue.builderOf(SQLSourceGroup.class)
|
|
||||||
.fromSection()
|
|
||||||
.parse((w, sec) -> SQLSourceGroup.parse(sec))
|
|
||||||
.serialize(SQLSourceGroup::serialize)
|
|
||||||
.defaults(SQLSourceGroup.defaults())
|
|
||||||
.build();
|
|
||||||
|
|
||||||
public static class PropertiesConfig implements Configuration {
|
|
||||||
|
|
||||||
@HeaderComments({"该选项用于启用 Properties 配置读取。", "若您不希望插件启用 Properties 文件配置功能,可以选择关闭。"})
|
|
||||||
public ConfiguredValue<Boolean> ENABLE = ConfiguredValue.of(Boolean.class, true);
|
|
||||||
|
|
||||||
@HeaderComments({
|
|
||||||
"文件夹路径,将读取该文件夹下的所有 .properties 文件,并以文件名为数据管理器名称。",
|
|
||||||
"读取时,将排除以 “.” 开头的文件与非 .properties 文件。",
|
|
||||||
"默认为 \"db-properties/\" 相对路径,指向“plugins/MineSQL/db-properties/”;",
|
|
||||||
"该选项也支持绝对路径,但使用绝对路径时,请务必注意权限问题。"
|
|
||||||
})
|
|
||||||
public ConfiguredValue<String> FOLDER = ConfiguredValue.of(String.class, "db-properties/");
|
|
||||||
|
|
||||||
}
|
|
||||||
|
|
||||||
public static class SettingsConfig implements Configuration {
|
|
||||||
|
|
||||||
@HeaderComments({"在插件卸载时是否强制关闭活跃链接"})
|
|
||||||
public ConfiguredValue<Boolean> FORCE_CLOSE = ConfiguredValue.of(Boolean.class, true);
|
|
||||||
|
|
||||||
}
|
|
||||||
|
|
||||||
|
|
||||||
}
|
|
||||||
@@ -1,100 +0,0 @@
|
|||||||
package cc.carm.plugin.minesql.conf;
|
|
||||||
|
|
||||||
import cc.carm.lib.configuration.source.section.ConfigureSection;
|
|
||||||
import cc.carm.plugin.minesql.MineSQL;
|
|
||||||
import cc.carm.plugin.minesql.api.SQLDriverType;
|
|
||||||
import cc.carm.plugin.minesql.api.conf.SQLDriverConfig;
|
|
||||||
import cc.carm.plugin.minesql.api.conf.drivers.H2MemConfig;
|
|
||||||
import cc.carm.plugin.minesql.api.conf.impl.FileBasedConfig;
|
|
||||||
import cc.carm.plugin.minesql.api.conf.impl.RemoteAuthConfig;
|
|
||||||
import org.jetbrains.annotations.NotNull;
|
|
||||||
import org.jetbrains.annotations.Nullable;
|
|
||||||
|
|
||||||
import java.util.Collections;
|
|
||||||
import java.util.LinkedHashMap;
|
|
||||||
import java.util.Map;
|
|
||||||
|
|
||||||
public class SQLSourceGroup {
|
|
||||||
|
|
||||||
protected final LinkedHashMap<String, SQLDriverConfig> sources;
|
|
||||||
|
|
||||||
public SQLSourceGroup(LinkedHashMap<String, SQLDriverConfig> sources) {
|
|
||||||
this.sources = sources;
|
|
||||||
}
|
|
||||||
|
|
||||||
public Map<String, SQLDriverConfig> getSources() {
|
|
||||||
return Collections.unmodifiableMap(sources);
|
|
||||||
}
|
|
||||||
|
|
||||||
public @NotNull Map<String, Object> serialize() {
|
|
||||||
Map<String, Object> data = new LinkedHashMap<>();
|
|
||||||
this.sources.forEach((k, v) -> data.put(k, v.serialize()));
|
|
||||||
return data;
|
|
||||||
}
|
|
||||||
|
|
||||||
public static @NotNull SQLSourceGroup defaults() {
|
|
||||||
LinkedHashMap<String, SQLDriverConfig> configs = new LinkedHashMap<>();
|
|
||||||
configs.put("example-mysql", new RemoteAuthConfig(
|
|
||||||
SQLDriverType.MARIADB, "127.0.0.1", 3306,
|
|
||||||
"minecraft", "minecraft", "minecraft",
|
|
||||||
"?sslMode=false"
|
|
||||||
));
|
|
||||||
configs.put("example-h2-file", new FileBasedConfig(SQLDriverType.H2_FILE, "test"));
|
|
||||||
configs.put("example-h2-mem", new H2MemConfig("temp"));
|
|
||||||
return new SQLSourceGroup(configs);
|
|
||||||
}
|
|
||||||
|
|
||||||
public static @NotNull SQLSourceGroup parse(ConfigureSection rootSection) {
|
|
||||||
LinkedHashMap<String, SQLDriverConfig> configs = new LinkedHashMap<>();
|
|
||||||
for (String name : rootSection.getKeys(false)) {
|
|
||||||
if (!rootSection.isSection(name)) continue;
|
|
||||||
ConfigureSection section = rootSection.getSection(name);
|
|
||||||
if (section == null) continue;
|
|
||||||
SQLDriverConfig conf = parse(name, section);
|
|
||||||
if (conf != null) configs.put(name, conf);
|
|
||||||
}
|
|
||||||
return new SQLSourceGroup(configs);
|
|
||||||
}
|
|
||||||
|
|
||||||
public static @Nullable SQLDriverConfig parse(String name, ConfigureSection section) {
|
|
||||||
@Nullable String driverString = section.getString("type");
|
|
||||||
@Nullable SQLDriverType driverType = SQLDriverType.parse(driverString);
|
|
||||||
if (driverType == null) {
|
|
||||||
MineSQL.getLogger().severe("驱动类型 " + driverString + " 不存在于预设中," + " 请检查配置文件 sources." + name + "。");
|
|
||||||
return null;
|
|
||||||
}
|
|
||||||
|
|
||||||
switch (driverType) {
|
|
||||||
case MYSQL:
|
|
||||||
case MARIADB: {
|
|
||||||
String host = section.getString("host");
|
|
||||||
int port = section.getInt("port", 0);
|
|
||||||
String database = section.getString("database");
|
|
||||||
if (host == null || database == null || !(port > 0 && port <= 65535)) {
|
|
||||||
MineSQL.getLogger().severe("数据库连接配置有误," + " 请检查配置文件 sources." + name + "。");
|
|
||||||
return null;
|
|
||||||
}
|
|
||||||
|
|
||||||
String username = section.getString("username");
|
|
||||||
String password = section.getString("password");
|
|
||||||
String extra = section.getString("extra");
|
|
||||||
return new RemoteAuthConfig(driverType, host, port, database, username, password, extra);
|
|
||||||
}
|
|
||||||
case H2_MEM: {
|
|
||||||
return new H2MemConfig(section.getString("database"));
|
|
||||||
}
|
|
||||||
case H2_FILE: {
|
|
||||||
String filePath = section.getString("file");
|
|
||||||
if (filePath == null) {
|
|
||||||
MineSQL.getLogger().severe("数据库文件地址配置有误," + " 请检查配置文件 sources." + name + "。");
|
|
||||||
return null;
|
|
||||||
}
|
|
||||||
return new FileBasedConfig(SQLDriverType.H2_FILE, filePath);
|
|
||||||
}
|
|
||||||
}
|
|
||||||
|
|
||||||
return null;
|
|
||||||
}
|
|
||||||
|
|
||||||
|
|
||||||
}
|
|
||||||
@@ -1,27 +0,0 @@
|
|||||||
package cc.carm.plugin.minesql.lib;
|
|
||||||
|
|
||||||
import cc.carm.plugin.minesql.util.VersionReader;
|
|
||||||
import org.jetbrains.annotations.NotNull;
|
|
||||||
|
|
||||||
public enum PluginLibraries {
|
|
||||||
|
|
||||||
BEECP("com.github.chris2018998", "beecp"),
|
|
||||||
H2_DRIVER("com.h2database", "h2"),
|
|
||||||
MYSQL_DRIVER("com.mysql", "mysql-connector-j"),
|
|
||||||
MARIADB_DRIVER("org.mariadb.jdbc", "mariadb-java-client");
|
|
||||||
|
|
||||||
public static final VersionReader READER = new VersionReader();
|
|
||||||
|
|
||||||
private final @NotNull String groupID;
|
|
||||||
private final @NotNull String artifactID;
|
|
||||||
|
|
||||||
PluginLibraries(@NotNull String groupID, @NotNull String artifactID) {
|
|
||||||
this.groupID = groupID;
|
|
||||||
this.artifactID = artifactID;
|
|
||||||
}
|
|
||||||
|
|
||||||
public @NotNull String getVersion() {
|
|
||||||
return READER.get(name().toLowerCase().replace('_', '-'));
|
|
||||||
}
|
|
||||||
|
|
||||||
}
|
|
||||||
@@ -1,43 +0,0 @@
|
|||||||
package cc.carm.plugin.minesql.util;
|
|
||||||
|
|
||||||
import org.jetbrains.annotations.NotNull;
|
|
||||||
|
|
||||||
import java.io.File;
|
|
||||||
import java.io.FileInputStream;
|
|
||||||
import java.io.IOException;
|
|
||||||
import java.io.InputStream;
|
|
||||||
import java.util.HashMap;
|
|
||||||
import java.util.Map;
|
|
||||||
import java.util.Properties;
|
|
||||||
|
|
||||||
public class DBPropertiesUtil {
|
|
||||||
|
|
||||||
public static Map<String, Properties> readFromFolder(File propertiesFolder) {
|
|
||||||
Map<String, Properties> propertiesMap = new HashMap<>();
|
|
||||||
if (!propertiesFolder.exists() || !propertiesFolder.isDirectory()) return propertiesMap;
|
|
||||||
|
|
||||||
File[] files = propertiesFolder.listFiles();
|
|
||||||
if (files == null) return propertiesMap;
|
|
||||||
for (File file : files) {
|
|
||||||
if (!validateName(file.getName())) continue;
|
|
||||||
String name = file.getName().substring(0, file.getName().lastIndexOf("."));
|
|
||||||
try (InputStream is = new FileInputStream(file)) {
|
|
||||||
propertiesMap.put(name, read(is));
|
|
||||||
} catch (IOException ignored) {
|
|
||||||
}
|
|
||||||
}
|
|
||||||
|
|
||||||
return propertiesMap;
|
|
||||||
}
|
|
||||||
|
|
||||||
public static @NotNull Properties read(InputStream stream) throws IOException {
|
|
||||||
Properties properties = new Properties();
|
|
||||||
properties.load(stream);
|
|
||||||
return properties;
|
|
||||||
}
|
|
||||||
|
|
||||||
public static boolean validateName(String name) {
|
|
||||||
return !name.contains(" ") && !name.startsWith(".") && name.endsWith(".properties");
|
|
||||||
}
|
|
||||||
|
|
||||||
}
|
|
||||||
@@ -1,39 +0,0 @@
|
|||||||
package cc.carm.plugin.minesql.util;
|
|
||||||
|
|
||||||
import org.jetbrains.annotations.Contract;
|
|
||||||
import org.jetbrains.annotations.NotNull;
|
|
||||||
import org.jetbrains.annotations.Nullable;
|
|
||||||
|
|
||||||
import java.io.InputStream;
|
|
||||||
import java.util.Properties;
|
|
||||||
|
|
||||||
public class VersionReader {
|
|
||||||
|
|
||||||
String versionsFileName;
|
|
||||||
|
|
||||||
|
|
||||||
public VersionReader() {
|
|
||||||
this("versions.properties");
|
|
||||||
}
|
|
||||||
|
|
||||||
public VersionReader(String versionsFileName) {
|
|
||||||
this.versionsFileName = versionsFileName;
|
|
||||||
}
|
|
||||||
|
|
||||||
public synchronized @NotNull String get(@NotNull String artifactID) {
|
|
||||||
return get(artifactID, "unknown");
|
|
||||||
}
|
|
||||||
|
|
||||||
@Contract("_,!null->!null")
|
|
||||||
public synchronized @Nullable String get(@NotNull String artifactID,
|
|
||||||
@Nullable String defaultValue) {
|
|
||||||
try (InputStream is = this.getClass().getResourceAsStream("/" + versionsFileName)) {
|
|
||||||
Properties p = new Properties();
|
|
||||||
p.load(is);
|
|
||||||
return p.getProperty(artifactID, defaultValue);
|
|
||||||
} catch (Exception ignore) {
|
|
||||||
}
|
|
||||||
return defaultValue;
|
|
||||||
}
|
|
||||||
|
|
||||||
}
|
|
||||||
@@ -1,6 +0,0 @@
|
|||||||
&d __ ____ &f________ __
|
|
||||||
&d / |/ (_)__ ___ &f/ __/ __ \ / /
|
|
||||||
&d / /|_/ / / _ \/ -_)&f\ \/ /_/ / / /__
|
|
||||||
&d/_/ /_/_/_//_/\__/&f___/\___\_\/____/
|
|
||||||
&8# &dMine&fSQL &8&o(EasySQL-Plugin) &7v&f${project.version}
|
|
||||||
&8- &7查看更多信息请访问项目主页&f https://github.com/CarmJos/MineSQL
|
|
||||||
@@ -1,41 +0,0 @@
|
|||||||
# suppress inspection "UnusedProperty" for whole file
|
|
||||||
#
|
|
||||||
# Copyright (c) 2016-2021 Daniel Ennis (Aikar) - MIT License
|
|
||||||
#
|
|
||||||
# Permission is hereby granted, free of charge, to any person obtaining
|
|
||||||
# a copy of this software and associated documentation files (the
|
|
||||||
# "Software"), to deal in the Software without restriction, including
|
|
||||||
# without limitation the rights to use, copy, modify, merge, publish,
|
|
||||||
# distribute, sublicense, and/or sell copies of the Software, and to
|
|
||||||
# permit persons to whom the Software is furnished to do so, subject to
|
|
||||||
# the following conditions:
|
|
||||||
#
|
|
||||||
# The above copyright notice and this permission notice shall be
|
|
||||||
# included in all copies or substantial portions of the Software.
|
|
||||||
#
|
|
||||||
# THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
|
|
||||||
# EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
|
|
||||||
# MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
|
|
||||||
# NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
|
|
||||||
# LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
|
|
||||||
# OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
|
|
||||||
# WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
|
|
||||||
#
|
|
||||||
acf-core.permission_denied=很抱歉,你没有执行此命令的权限。
|
|
||||||
acf-core.permission_denied_parameter=很抱歉,你没有执行此命令的权限。
|
|
||||||
acf-core.error_generic_logged=很抱歉,插件产生了内部错误。问题已输出在游戏日志中。
|
|
||||||
acf-core.unknown_command=§r您输入了未知的指令,输入 §b/EasySQL help §r获得指令帮助。
|
|
||||||
acf-core.invalid_syntax=§r指令用法 §b{command} {syntax} §r。
|
|
||||||
acf-core.error_prefix=在执行指令时出现了一个错误:\n{message}
|
|
||||||
acf-core.error_performing_command=很抱歉,指令执行中出现了错误。
|
|
||||||
acf-core.info_message=§r{message}
|
|
||||||
acf-core.please_specify_one_of=错误:请输入 <c2>{valid}</c2> 中的某一个。
|
|
||||||
acf-core.must_be_a_number=错误:{num} 必须是数字。
|
|
||||||
acf-core.must_be_min_length=错误:至少需要输入 {min} 个字符。
|
|
||||||
acf-core.must_be_max_length=错误:最多需要输入 {max} 个字符。
|
|
||||||
acf-core.please_specify_at_most=错误:请输入一个不大于 {max} 的值。
|
|
||||||
acf-core.please_specify_at_least=错误:请输入一个不小于 {min} 的值。
|
|
||||||
acf-core.not_allowed_on_console=错误:控制台不能执行此命令。
|
|
||||||
acf-core.could_not_find_player=错误:找不到名叫 <c2>{search}</c2> 的玩家。
|
|
||||||
acf-core.no_command_matched_search=§r抱歉,没有匹配 §b{search} §r的指令。
|
|
||||||
acf-core.help_no_results=§r抱歉,没有相关的指令帮助。
|
|
||||||
@@ -1,39 +0,0 @@
|
|||||||
# suppress inspection "UnusedProperty" for whole file
|
|
||||||
#
|
|
||||||
# Copyright (c) 2016-2021 Daniel Ennis (Aikar) - MIT License
|
|
||||||
#
|
|
||||||
# Permission is hereby granted, free of charge, to any person obtaining
|
|
||||||
# a copy of this software and associated documentation files (the
|
|
||||||
# "Software"), to deal in the Software without restriction, including
|
|
||||||
# without limitation the rights to use, copy, modify, merge, publish,
|
|
||||||
# distribute, sublicense, and/or sell copies of the Software, and to
|
|
||||||
# permit persons to whom the Software is furnished to do so, subject to
|
|
||||||
# the following conditions:
|
|
||||||
#
|
|
||||||
# The above copyright notice and this permission notice shall be
|
|
||||||
# included in all copies or substantial portions of the Software.
|
|
||||||
#
|
|
||||||
# THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND,
|
|
||||||
# EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF
|
|
||||||
# MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
|
|
||||||
# NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE
|
|
||||||
# LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION
|
|
||||||
# OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION
|
|
||||||
# WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
|
|
||||||
#
|
|
||||||
|
|
||||||
acf-minecraft.invalid_world = 错误:该世界不存在。
|
|
||||||
acf-minecraft.you_must_be_holding_item = 错误:你的主手上必须持有物品。
|
|
||||||
acf-minecraft.player_is_vanished_confirm = \
|
|
||||||
警告:<c2>{vanished}</c2> 已被隐藏。不要暴露他们的身份!\n\
|
|
||||||
如果你确认这么做,请在他们的名字后面加上 <c2>:confirm</c2> 。\n\
|
|
||||||
例如:<c2>{vanished}:confirm</c2>
|
|
||||||
acf-minecraft.username_too_short = 错误:名字太短,请至少输入三个字符。
|
|
||||||
acf-minecraft.is_not_a_valid_name = 错误:<c2>{name}</c2> 不是一个可以用的名字。
|
|
||||||
acf-minecraft.multiple_players_match = 错误:<c2>{search}</c2> 的搜索结果过多<c3>(共计{all}人)</c3>,请再详细一点。
|
|
||||||
acf-minecraft.no_player_found_server = 没有搜索到匹配 <c2>{search}</c2> 的在线玩家。
|
|
||||||
acf-minecraft.no_player_found_offline = 没有搜索到匹配 <c2>{search}</c2> 的在线/离线玩家。
|
|
||||||
acf-minecraft.no_player_found = 没有搜索到匹配 <c2>{search}</c2> 的玩家。
|
|
||||||
acf-minecraft.location_please_specify_world = 错误:请指明世界。例如:<c2>world:x,y,z</c2>。
|
|
||||||
acf-minecraft.location_please_specify_xyz = 错误:请指明坐标x,y和z。例如:<c2>world:x,y,z</c2>。
|
|
||||||
acf-minecraft.location_console_not_relative = 错误:控制台不能使用相对坐标来指明位置。
|
|
||||||
@@ -1,63 +0,0 @@
|
|||||||
# suppress inspection "UnusedProperty" for whole file
|
|
||||||
|
|
||||||
# 该功能一般用于专业开发者使用,若您不了解该功能,请尽量使用config.yml中提供的配置方式,简单便捷,能够满足大多数需求。
|
|
||||||
# 更多帮助详见 BeeCP项目地址 https://github.com/Chris2018998/BeeCP
|
|
||||||
|
|
||||||
#JDBC 用户名
|
|
||||||
username=root
|
|
||||||
#JDBC 密码
|
|
||||||
password=root
|
|
||||||
# JDBC连接URL
|
|
||||||
jdbcUrl=jdbc:mysql://localhost/test
|
|
||||||
# JDBC驱动类名
|
|
||||||
driverClassName=com.mysql.cj.jdbc.Driver
|
|
||||||
# 连接有效性测试SQL语句
|
|
||||||
connectionTestSQL=select 1 from dual
|
|
||||||
# 池名,如果未赋值则会自动产生一个
|
|
||||||
poolName=Pool1
|
|
||||||
# 是否使用公平模式 (竞争模式=false)
|
|
||||||
fairMode=false
|
|
||||||
# 连接池初始大小
|
|
||||||
initialSize=1
|
|
||||||
# 连接池最大个数
|
|
||||||
maxActive=10
|
|
||||||
# 信号量许可大小 min(最大连接数/2,CPU核心数)
|
|
||||||
borrowSemaphoreSize=4
|
|
||||||
# 连接借用等待最大时间(毫秒)
|
|
||||||
maxWait=8000
|
|
||||||
# 连接闲置最大时间(毫秒)
|
|
||||||
idleTimeout=18000
|
|
||||||
# 连接被持有不用最大允许时间(毫秒)
|
|
||||||
holdTimeout=30000
|
|
||||||
# 连接有效性测试SQL语句
|
|
||||||
validTestTimeout=3
|
|
||||||
# 连接测试的间隔时间(毫秒)
|
|
||||||
validAssumeTime=500
|
|
||||||
# 闲置扫描线程间隔时间(毫秒)
|
|
||||||
timerCheckInterval=30000
|
|
||||||
# 在结束时是否直接关闭使用中连接
|
|
||||||
forceCloseUsingOnClear=true
|
|
||||||
# 延迟清理的时候时间(毫秒)
|
|
||||||
delayTimeForNextClear=3000
|
|
||||||
|
|
||||||
# JMX监控支持开关
|
|
||||||
enableJmx=false
|
|
||||||
|
|
||||||
# Catalog默认值
|
|
||||||
defaultCatalog=test1
|
|
||||||
# Schema默认值
|
|
||||||
defaultSchema=test2
|
|
||||||
# ReadOnly默认值
|
|
||||||
defaultReadOnly=true
|
|
||||||
# 自动提交默认值
|
|
||||||
defaultAutoCommit=true
|
|
||||||
|
|
||||||
# 事物隔离代码,未设置时则从第一个连接上读取
|
|
||||||
defaultTransactionIsolationCode=1
|
|
||||||
defaultTransactionIsolationName=TRANSACTION_READ_UNCOMMITTED
|
|
||||||
|
|
||||||
# 额外链接配置
|
|
||||||
connectProperties=cachePrepStmts=true
|
|
||||||
connectProperties.count=2
|
|
||||||
connectProperties.1=prepStmtCacheSize=50
|
|
||||||
connectProperties.2=prepStmtCacheSqlLimit=2048&useServerPrepStmts=true
|
|
||||||
@@ -1,11 +0,0 @@
|
|||||||
# suppress inspection "SpellCheckingInspection" for whole file
|
|
||||||
|
|
||||||
plugin=${project.version}
|
|
||||||
api=${deps.easysql.version}
|
|
||||||
|
|
||||||
beecp=${deps.beecp.version}
|
|
||||||
|
|
||||||
mysql-driver=${deps.mysql-driver.version}
|
|
||||||
mariadb-driver=${deps.mariadb-driver.version}
|
|
||||||
h2-driver=${deps.h2-driver.version}
|
|
||||||
|
|
||||||
@@ -1,9 +0,0 @@
|
|||||||
package cc.carm.plugin.minesql;
|
|
||||||
|
|
||||||
public interface References {
|
|
||||||
|
|
||||||
String REPO_OWNER = "CarmJos";
|
|
||||||
String REPO_NAME = "MineSQL";
|
|
||||||
String VERSION = "${project.version}";
|
|
||||||
|
|
||||||
}
|
|
||||||
@@ -1,111 +0,0 @@
|
|||||||
<?xml version="1.0" encoding="UTF-8"?>
|
|
||||||
<project xmlns="http://maven.apache.org/POM/4.0.0"
|
|
||||||
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
|
|
||||||
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
|
|
||||||
<parent>
|
|
||||||
<artifactId>minesql-parent</artifactId>
|
|
||||||
<groupId>cc.carm.plugin</groupId>
|
|
||||||
<version>1.4.3</version>
|
|
||||||
<relativePath>../../pom.xml</relativePath>
|
|
||||||
</parent>
|
|
||||||
<modelVersion>4.0.0</modelVersion>
|
|
||||||
|
|
||||||
<properties>
|
|
||||||
<maven.compiler.source>${project.jdk.version}</maven.compiler.source>
|
|
||||||
<maven.compiler.target>${project.jdk.version}</maven.compiler.target>
|
|
||||||
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
|
|
||||||
<maven.compiler.encoding>UTF-8</maven.compiler.encoding>
|
|
||||||
<maven.javadoc.skip>true</maven.javadoc.skip>
|
|
||||||
<maven.deploy.skip>true</maven.deploy.skip>
|
|
||||||
</properties>
|
|
||||||
|
|
||||||
<artifactId>minesql-platform-bukkit</artifactId>
|
|
||||||
<packaging>jar</packaging>
|
|
||||||
|
|
||||||
<name>MineSQL-Bukkit</name>
|
|
||||||
<description>轻松(用)SQL的独立运行库Bukkit版本插件。</description>
|
|
||||||
<url>https://github.com/CarmJos/MineSQL</url>
|
|
||||||
|
|
||||||
<developers>
|
|
||||||
<developer>
|
|
||||||
<id>CarmJos</id>
|
|
||||||
<name>Carm Jos</name>
|
|
||||||
<email>carm@carm.cc</email>
|
|
||||||
<url>https://www.carm.cc</url>
|
|
||||||
<roles>
|
|
||||||
<role>Main Developer</role>
|
|
||||||
<role>Designer</role>
|
|
||||||
</roles>
|
|
||||||
</developer>
|
|
||||||
</developers>
|
|
||||||
|
|
||||||
<licenses>
|
|
||||||
<license>
|
|
||||||
<name>GNU General Public License v3.0</name>
|
|
||||||
<url>https://opensource.org/licenses/GPL-3.0</url>
|
|
||||||
</license>
|
|
||||||
</licenses>
|
|
||||||
|
|
||||||
<issueManagement>
|
|
||||||
<system>GitHub Issues</system>
|
|
||||||
<url>https://github.com/CarmJos/MineSQL/issues</url>
|
|
||||||
</issueManagement>
|
|
||||||
|
|
||||||
<ciManagement>
|
|
||||||
<system>GitHub Actions</system>
|
|
||||||
<url>https://github.com/CarmJos/MineSQL/actions/workflows/maven.yml</url>
|
|
||||||
</ciManagement>
|
|
||||||
|
|
||||||
<dependencies>
|
|
||||||
|
|
||||||
<dependency>
|
|
||||||
<groupId>${project.parent.groupId}</groupId>
|
|
||||||
<artifactId>minesql-core</artifactId>
|
|
||||||
<version>${project.parent.version}</version>
|
|
||||||
<scope>compile</scope>
|
|
||||||
</dependency>
|
|
||||||
|
|
||||||
<dependency>
|
|
||||||
<groupId>cc.carm.lib</groupId>
|
|
||||||
<artifactId>easyplugin-main</artifactId>
|
|
||||||
<version>${deps.easyplugin.version}</version>
|
|
||||||
<scope>compile</scope>
|
|
||||||
</dependency>
|
|
||||||
|
|
||||||
<dependency>
|
|
||||||
<groupId>org.spigotmc</groupId>
|
|
||||||
<artifactId>spigot-api</artifactId>
|
|
||||||
<version>1.19-R0.1-20220725.090125-47</version>
|
|
||||||
<scope>provided</scope>
|
|
||||||
</dependency>
|
|
||||||
|
|
||||||
<dependency>
|
|
||||||
<groupId>org.bstats</groupId>
|
|
||||||
<artifactId>bstats-bukkit</artifactId>
|
|
||||||
<version>${deps.bstats.version}</version>
|
|
||||||
<scope>compile</scope>
|
|
||||||
</dependency>
|
|
||||||
|
|
||||||
<dependency>
|
|
||||||
<groupId>co.aikar</groupId>
|
|
||||||
<artifactId>acf-paper</artifactId>
|
|
||||||
<version>${deps.acf.version}</version>
|
|
||||||
<scope>compile</scope>
|
|
||||||
</dependency>
|
|
||||||
|
|
||||||
</dependencies>
|
|
||||||
|
|
||||||
<build>
|
|
||||||
<plugins>
|
|
||||||
<plugin>
|
|
||||||
<groupId>org.apache.maven.plugins</groupId>
|
|
||||||
<artifactId>maven-compiler-plugin</artifactId>
|
|
||||||
</plugin>
|
|
||||||
<plugin>
|
|
||||||
<groupId>org.apache.maven.plugins</groupId>
|
|
||||||
<artifactId>maven-jar-plugin</artifactId>
|
|
||||||
</plugin>
|
|
||||||
</plugins>
|
|
||||||
</build>
|
|
||||||
|
|
||||||
</project>
|
|
||||||
@@ -1,86 +0,0 @@
|
|||||||
package cc.carm.plugin.minesql;
|
|
||||||
|
|
||||||
import cc.carm.lib.easyplugin.EasyPlugin;
|
|
||||||
import cc.carm.plugin.minesql.conf.PluginConfiguration;
|
|
||||||
import co.aikar.commands.CommandManager;
|
|
||||||
import co.aikar.commands.PaperCommandManager;
|
|
||||||
import org.bstats.bukkit.Metrics;
|
|
||||||
import org.bstats.charts.SimplePie;
|
|
||||||
import org.jetbrains.annotations.NotNull;
|
|
||||||
|
|
||||||
import java.io.File;
|
|
||||||
|
|
||||||
public class MineSQLBukkit extends EasyPlugin implements MineSQLPlatform {
|
|
||||||
|
|
||||||
protected static MineSQLBukkit instance;
|
|
||||||
|
|
||||||
protected MineSQLCore core;
|
|
||||||
protected PaperCommandManager commandManager;
|
|
||||||
|
|
||||||
@Override
|
|
||||||
protected void load() {
|
|
||||||
MineSQLBukkit.instance = this;
|
|
||||||
|
|
||||||
log("加载基础核心...");
|
|
||||||
this.core = new MineSQLCore(this);
|
|
||||||
}
|
|
||||||
|
|
||||||
@Override
|
|
||||||
protected boolean initialize() {
|
|
||||||
log("初始化指令管理器...");
|
|
||||||
this.commandManager = new PaperCommandManager(this);
|
|
||||||
|
|
||||||
log("注册相关指令...");
|
|
||||||
this.core.initializeCommands(getCommandManager());
|
|
||||||
|
|
||||||
if (getConfiguration().METRICS.getNotNull()) {
|
|
||||||
log("启用统计数据...");
|
|
||||||
Metrics metrics = new Metrics(this, 14075);
|
|
||||||
metrics.addCustomChart(new SimplePie("update_check",
|
|
||||||
() -> getConfiguration().UPDATE_CHECKER.getNotNull() ? "ENABLED" : "DISABLED")
|
|
||||||
);
|
|
||||||
metrics.addCustomChart(new SimplePie("properties_configuration",
|
|
||||||
() -> getConfiguration().PROPERTIES.ENABLE.getNotNull() ? "ENABLED" : "DISABLED")
|
|
||||||
);
|
|
||||||
}
|
|
||||||
|
|
||||||
if (getConfiguration().UPDATE_CHECKER.getNotNull()) {
|
|
||||||
log("开始检查更新,可能需要一小段时间...");
|
|
||||||
log(" 如不希望检查更新,可在配置文件中关闭。");
|
|
||||||
getScheduler().runAsync(() -> this.core.checkUpdate(getDescription().getVersion()));
|
|
||||||
} else {
|
|
||||||
log("已禁用检查更新,跳过。");
|
|
||||||
}
|
|
||||||
|
|
||||||
return true;
|
|
||||||
}
|
|
||||||
|
|
||||||
@Override
|
|
||||||
protected void shutdown() {
|
|
||||||
log("终止全部数据库连接...");
|
|
||||||
this.core.shutdownAll();
|
|
||||||
}
|
|
||||||
|
|
||||||
@Override
|
|
||||||
public boolean isDebugging() {
|
|
||||||
return getConfiguration().DEBUG.getNotNull();
|
|
||||||
}
|
|
||||||
|
|
||||||
public static @NotNull MineSQLBukkit getInstance() {
|
|
||||||
return MineSQLBukkit.instance;
|
|
||||||
}
|
|
||||||
|
|
||||||
public @NotNull PluginConfiguration getConfiguration() {
|
|
||||||
return this.core.getConfig();
|
|
||||||
}
|
|
||||||
|
|
||||||
public @NotNull CommandManager<?, ?, ?, ?, ?, ?> getCommandManager() {
|
|
||||||
return commandManager;
|
|
||||||
}
|
|
||||||
|
|
||||||
@Override
|
|
||||||
public @NotNull File getPluginFolder() {
|
|
||||||
return getDataFolder();
|
|
||||||
}
|
|
||||||
|
|
||||||
}
|
|
||||||
@@ -1,14 +0,0 @@
|
|||||||
main: cc.carm.plugin.minesql.MineSQLBukkit
|
|
||||||
version: ${project.version}
|
|
||||||
|
|
||||||
prefix: MineSQL
|
|
||||||
name: MineSQL
|
|
||||||
load: STARTUP
|
|
||||||
|
|
||||||
website: ${project.url}
|
|
||||||
description: ${project.description}
|
|
||||||
authors:
|
|
||||||
- CarmJos
|
|
||||||
- GhostChu
|
|
||||||
|
|
||||||
api-version: 1.13
|
|
||||||
@@ -1,104 +0,0 @@
|
|||||||
<?xml version="1.0" encoding="UTF-8"?>
|
|
||||||
<project xmlns="http://maven.apache.org/POM/4.0.0"
|
|
||||||
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
|
|
||||||
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
|
|
||||||
<parent>
|
|
||||||
<artifactId>minesql-parent</artifactId>
|
|
||||||
<groupId>cc.carm.plugin</groupId>
|
|
||||||
<version>1.4.3</version>
|
|
||||||
<relativePath>../../pom.xml</relativePath>
|
|
||||||
</parent>
|
|
||||||
<modelVersion>4.0.0</modelVersion>
|
|
||||||
|
|
||||||
<properties>
|
|
||||||
<maven.compiler.source>${project.jdk.version}</maven.compiler.source>
|
|
||||||
<maven.compiler.target>${project.jdk.version}</maven.compiler.target>
|
|
||||||
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
|
|
||||||
<maven.compiler.encoding>UTF-8</maven.compiler.encoding>
|
|
||||||
<maven.javadoc.skip>true</maven.javadoc.skip>
|
|
||||||
<maven.deploy.skip>true</maven.deploy.skip>
|
|
||||||
</properties>
|
|
||||||
|
|
||||||
<artifactId>minesql-platform-bungee</artifactId>
|
|
||||||
<packaging>jar</packaging>
|
|
||||||
|
|
||||||
<name>MineSQL-Bungee</name>
|
|
||||||
<description>轻松(用)SQL的独立运行库Bungee版本插件。</description>
|
|
||||||
<url>https://github.com/CarmJos/MineSQL</url>
|
|
||||||
|
|
||||||
<developers>
|
|
||||||
<developer>
|
|
||||||
<id>CarmJos</id>
|
|
||||||
<name>Carm Jos</name>
|
|
||||||
<email>carm@carm.cc</email>
|
|
||||||
<url>https://www.carm.cc</url>
|
|
||||||
<roles>
|
|
||||||
<role>Main Developer</role>
|
|
||||||
<role>Designer</role>
|
|
||||||
</roles>
|
|
||||||
</developer>
|
|
||||||
</developers>
|
|
||||||
|
|
||||||
<licenses>
|
|
||||||
<license>
|
|
||||||
<name>GNU General Public License v3.0</name>
|
|
||||||
<url>https://opensource.org/licenses/GPL-3.0</url>
|
|
||||||
</license>
|
|
||||||
</licenses>
|
|
||||||
|
|
||||||
<issueManagement>
|
|
||||||
<system>GitHub Issues</system>
|
|
||||||
<url>https://github.com/CarmJos/MineSQL/issues</url>
|
|
||||||
</issueManagement>
|
|
||||||
|
|
||||||
<ciManagement>
|
|
||||||
<system>GitHub Actions</system>
|
|
||||||
<url>https://github.com/CarmJos/MineSQL/actions/workflows/maven.yml</url>
|
|
||||||
</ciManagement>
|
|
||||||
|
|
||||||
<dependencies>
|
|
||||||
|
|
||||||
<dependency>
|
|
||||||
<groupId>${project.parent.groupId}</groupId>
|
|
||||||
<artifactId>minesql-core</artifactId>
|
|
||||||
<version>${project.parent.version}</version>
|
|
||||||
<scope>compile</scope>
|
|
||||||
</dependency>
|
|
||||||
|
|
||||||
<dependency>
|
|
||||||
<groupId>io.github.waterfallmc</groupId>
|
|
||||||
<artifactId>waterfall-api</artifactId>
|
|
||||||
<version>1.21-R0.5-SNAPSHOT</version>
|
|
||||||
<scope>provided</scope>
|
|
||||||
</dependency>
|
|
||||||
|
|
||||||
<dependency>
|
|
||||||
<groupId>org.bstats</groupId>
|
|
||||||
<artifactId>bstats-bungeecord</artifactId>
|
|
||||||
<version>${deps.bstats.version}</version>
|
|
||||||
<scope>compile</scope>
|
|
||||||
</dependency>
|
|
||||||
|
|
||||||
<dependency>
|
|
||||||
<groupId>co.aikar</groupId>
|
|
||||||
<artifactId>acf-bungee</artifactId>
|
|
||||||
<version>${deps.acf.version}</version>
|
|
||||||
<scope>compile</scope>
|
|
||||||
</dependency>
|
|
||||||
|
|
||||||
</dependencies>
|
|
||||||
|
|
||||||
<build>
|
|
||||||
<plugins>
|
|
||||||
<plugin>
|
|
||||||
<groupId>org.apache.maven.plugins</groupId>
|
|
||||||
<artifactId>maven-compiler-plugin</artifactId>
|
|
||||||
</plugin>
|
|
||||||
<plugin>
|
|
||||||
<groupId>org.apache.maven.plugins</groupId>
|
|
||||||
<artifactId>maven-jar-plugin</artifactId>
|
|
||||||
</plugin>
|
|
||||||
</plugins>
|
|
||||||
</build>
|
|
||||||
|
|
||||||
</project>
|
|
||||||
@@ -1,102 +0,0 @@
|
|||||||
package cc.carm.plugin.minesql;
|
|
||||||
|
|
||||||
import cc.carm.lib.easyplugin.utils.ColorParser;
|
|
||||||
import cc.carm.lib.easyplugin.utils.JarResourceUtils;
|
|
||||||
import cc.carm.plugin.minesql.conf.PluginConfiguration;
|
|
||||||
import co.aikar.commands.BungeeCommandManager;
|
|
||||||
import co.aikar.commands.CommandManager;
|
|
||||||
import net.md_5.bungee.api.ProxyServer;
|
|
||||||
import net.md_5.bungee.api.plugin.Plugin;
|
|
||||||
import org.bstats.bungeecord.Metrics;
|
|
||||||
import org.bstats.charts.SimplePie;
|
|
||||||
import org.jetbrains.annotations.NotNull;
|
|
||||||
|
|
||||||
import java.io.File;
|
|
||||||
import java.util.Arrays;
|
|
||||||
import java.util.Optional;
|
|
||||||
import java.util.logging.Logger;
|
|
||||||
|
|
||||||
public class MineSQLBungee extends Plugin implements MineSQLPlatform {
|
|
||||||
|
|
||||||
protected static MineSQLBungee instance;
|
|
||||||
|
|
||||||
protected MineSQLCore core;
|
|
||||||
protected BungeeCommandManager commandManager;
|
|
||||||
|
|
||||||
@Override
|
|
||||||
public void onLoad() {
|
|
||||||
MineSQLBungee.instance = this;
|
|
||||||
|
|
||||||
getLogger().info("加载基础核心...");
|
|
||||||
this.core = new MineSQLCore(this);
|
|
||||||
}
|
|
||||||
|
|
||||||
@Override
|
|
||||||
public void onEnable() {
|
|
||||||
outputInfo();
|
|
||||||
getLogger().info("初始化指令管理器...");
|
|
||||||
this.commandManager = new BungeeCommandManager(this);
|
|
||||||
|
|
||||||
getLogger().info("注册相关指令...");
|
|
||||||
this.core.initializeCommands(getCommandManager());
|
|
||||||
|
|
||||||
if (getConfiguration().METRICS.getNotNull()) {
|
|
||||||
getLogger().info("启用统计数据...");
|
|
||||||
Metrics metrics = new Metrics(this, 14076);
|
|
||||||
metrics.addCustomChart(new SimplePie("update_check",
|
|
||||||
() -> getConfiguration().UPDATE_CHECKER.getNotNull() ? "ENABLED" : "DISABLED")
|
|
||||||
);
|
|
||||||
metrics.addCustomChart(new SimplePie("properties_configuration",
|
|
||||||
() -> getConfiguration().PROPERTIES.ENABLE.getNotNull() ? "ENABLED" : "DISABLED")
|
|
||||||
);
|
|
||||||
}
|
|
||||||
|
|
||||||
if (getConfiguration().UPDATE_CHECKER.getNotNull()) {
|
|
||||||
getLogger().info("开始检查更新,可能需要一小段时间...");
|
|
||||||
getLogger().info(" 如不希望检查更新,可在配置文件中关闭。");
|
|
||||||
ProxyServer.getInstance().getScheduler().runAsync(
|
|
||||||
this, () -> this.core.checkUpdate(getDescription().getVersion())
|
|
||||||
);
|
|
||||||
} else {
|
|
||||||
getLogger().info("已禁用检查更新,跳过。");
|
|
||||||
}
|
|
||||||
}
|
|
||||||
|
|
||||||
@Override
|
|
||||||
public void onDisable() {
|
|
||||||
outputInfo();
|
|
||||||
getLogger().info("终止全部数据库连接...");
|
|
||||||
this.core.shutdownAll();
|
|
||||||
}
|
|
||||||
|
|
||||||
public static MineSQLBungee getInstance() {
|
|
||||||
return instance;
|
|
||||||
}
|
|
||||||
|
|
||||||
@Override
|
|
||||||
public @NotNull Logger getLogger() {
|
|
||||||
return super.getLogger();
|
|
||||||
}
|
|
||||||
|
|
||||||
public @NotNull PluginConfiguration getConfiguration() {
|
|
||||||
return this.core.getConfig();
|
|
||||||
}
|
|
||||||
|
|
||||||
@Override
|
|
||||||
public @NotNull File getPluginFolder() {
|
|
||||||
return getDataFolder();
|
|
||||||
}
|
|
||||||
|
|
||||||
@Override
|
|
||||||
public @NotNull CommandManager<?, ?, ?, ?, ?, ?> getCommandManager() {
|
|
||||||
return this.commandManager;
|
|
||||||
}
|
|
||||||
|
|
||||||
@SuppressWarnings("deprecation")
|
|
||||||
public void outputInfo() {
|
|
||||||
Optional.ofNullable(JarResourceUtils.readResource(this.getResourceAsStream("PLUGIN_INFO")))
|
|
||||||
.map(v -> ColorParser.parse(Arrays.asList(v)))
|
|
||||||
.ifPresent(list -> list.forEach(s -> ProxyServer.getInstance().getConsole().sendMessage(s)));
|
|
||||||
}
|
|
||||||
|
|
||||||
}
|
|
||||||
@@ -1,8 +0,0 @@
|
|||||||
main: cc.carm.plugin.minesql.MineSQLBungee
|
|
||||||
name: MineSQL
|
|
||||||
version: ${project.version}
|
|
||||||
|
|
||||||
website: ${project.url}
|
|
||||||
description: ${project.description}
|
|
||||||
|
|
||||||
author: "CarmJos"
|
|
||||||
@@ -1,115 +0,0 @@
|
|||||||
<?xml version="1.0" encoding="UTF-8"?>
|
|
||||||
<project xmlns="http://maven.apache.org/POM/4.0.0"
|
|
||||||
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
|
|
||||||
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
|
|
||||||
<parent>
|
|
||||||
<artifactId>minesql-parent</artifactId>
|
|
||||||
<groupId>cc.carm.plugin</groupId>
|
|
||||||
<version>1.4.3</version>
|
|
||||||
<relativePath>../../pom.xml</relativePath>
|
|
||||||
</parent>
|
|
||||||
<modelVersion>4.0.0</modelVersion>
|
|
||||||
|
|
||||||
<properties>
|
|
||||||
<maven.compiler.source>${project.jdk.version}</maven.compiler.source>
|
|
||||||
<maven.compiler.target>${project.jdk.version}</maven.compiler.target>
|
|
||||||
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
|
|
||||||
<maven.compiler.encoding>UTF-8</maven.compiler.encoding>
|
|
||||||
<maven.javadoc.skip>true</maven.javadoc.skip>
|
|
||||||
<maven.deploy.skip>true</maven.deploy.skip>
|
|
||||||
</properties>
|
|
||||||
|
|
||||||
<artifactId>minesql-platform-velocity</artifactId>
|
|
||||||
<packaging>jar</packaging>
|
|
||||||
|
|
||||||
<name>MineSQL-Velocity</name>
|
|
||||||
<description>轻松(用)SQL的独立运行库Velocity版本插件。</description>
|
|
||||||
<url>https://github.com/CarmJos/MineSQL</url>
|
|
||||||
|
|
||||||
<developers>
|
|
||||||
<developer>
|
|
||||||
<id>CarmJos</id>
|
|
||||||
<name>Carm Jos</name>
|
|
||||||
<email>carm@carm.cc</email>
|
|
||||||
<url>https://www.carm.cc</url>
|
|
||||||
<roles>
|
|
||||||
<role>Main Developer</role>
|
|
||||||
<role>Designer</role>
|
|
||||||
</roles>
|
|
||||||
</developer>
|
|
||||||
</developers>
|
|
||||||
|
|
||||||
<licenses>
|
|
||||||
<license>
|
|
||||||
<name>GNU General Public License v3.0</name>
|
|
||||||
<url>https://opensource.org/licenses/GPL-3.0</url>
|
|
||||||
</license>
|
|
||||||
</licenses>
|
|
||||||
|
|
||||||
<issueManagement>
|
|
||||||
<system>GitHub Issues</system>
|
|
||||||
<url>https://github.com/CarmJos/MineSQL/issues</url>
|
|
||||||
</issueManagement>
|
|
||||||
|
|
||||||
<ciManagement>
|
|
||||||
<system>GitHub Actions</system>
|
|
||||||
<url>https://github.com/CarmJos/MineSQL/actions/workflows/maven.yml</url>
|
|
||||||
</ciManagement>
|
|
||||||
|
|
||||||
<repositories>
|
|
||||||
<repository>
|
|
||||||
<id>velocity</id>
|
|
||||||
<name>Velocity</name>
|
|
||||||
<url>https://nexus.velocitypowered.com/repository/maven-public/</url>
|
|
||||||
</repository>
|
|
||||||
</repositories>
|
|
||||||
|
|
||||||
<dependencies>
|
|
||||||
|
|
||||||
<!--suppress VulnerableLibrariesLocal -->
|
|
||||||
<dependency>
|
|
||||||
<groupId>com.velocitypowered</groupId>
|
|
||||||
<artifactId>velocity-api</artifactId>
|
|
||||||
<version>3.1.1</version>
|
|
||||||
<scope>provided</scope>
|
|
||||||
</dependency>
|
|
||||||
|
|
||||||
<!--suppress VulnerableLibrariesLocal -->
|
|
||||||
<dependency>
|
|
||||||
<groupId>${project.parent.groupId}</groupId>
|
|
||||||
<artifactId>minesql-core</artifactId>
|
|
||||||
<version>${project.parent.version}</version>
|
|
||||||
<scope>compile</scope>
|
|
||||||
</dependency>
|
|
||||||
|
|
||||||
<dependency>
|
|
||||||
<groupId>org.bstats</groupId>
|
|
||||||
<artifactId>bstats-velocity</artifactId>
|
|
||||||
<version>${deps.bstats.version}</version>
|
|
||||||
<scope>compile</scope>
|
|
||||||
</dependency>
|
|
||||||
|
|
||||||
<dependency>
|
|
||||||
<groupId>co.aikar</groupId>
|
|
||||||
<artifactId>acf-velocity</artifactId>
|
|
||||||
<version>${deps.acf.version}</version>
|
|
||||||
<scope>compile</scope>
|
|
||||||
</dependency>
|
|
||||||
|
|
||||||
</dependencies>
|
|
||||||
|
|
||||||
|
|
||||||
<build>
|
|
||||||
<plugins>
|
|
||||||
<plugin>
|
|
||||||
<groupId>org.apache.maven.plugins</groupId>
|
|
||||||
<artifactId>maven-compiler-plugin</artifactId>
|
|
||||||
</plugin>
|
|
||||||
<plugin>
|
|
||||||
<groupId>org.apache.maven.plugins</groupId>
|
|
||||||
<artifactId>maven-jar-plugin</artifactId>
|
|
||||||
</plugin>
|
|
||||||
</plugins>
|
|
||||||
</build>
|
|
||||||
|
|
||||||
</project>
|
|
||||||
@@ -1,119 +0,0 @@
|
|||||||
package cc.carm.plugin.minesql;
|
|
||||||
|
|
||||||
import cc.carm.plugin.minesql.conf.PluginConfiguration;
|
|
||||||
import co.aikar.commands.CommandManager;
|
|
||||||
import co.aikar.commands.VelocityCommandManager;
|
|
||||||
import com.google.inject.Inject;
|
|
||||||
import com.velocitypowered.api.event.PostOrder;
|
|
||||||
import com.velocitypowered.api.event.Subscribe;
|
|
||||||
import com.velocitypowered.api.event.proxy.ProxyInitializeEvent;
|
|
||||||
import com.velocitypowered.api.event.proxy.ProxyShutdownEvent;
|
|
||||||
import com.velocitypowered.api.plugin.Plugin;
|
|
||||||
import com.velocitypowered.api.plugin.PluginContainer;
|
|
||||||
import com.velocitypowered.api.plugin.PluginDescription;
|
|
||||||
import com.velocitypowered.api.plugin.annotation.DataDirectory;
|
|
||||||
import com.velocitypowered.api.proxy.ProxyServer;
|
|
||||||
import org.bstats.charts.SimplePie;
|
|
||||||
import org.bstats.velocity.Metrics;
|
|
||||||
import org.jetbrains.annotations.NotNull;
|
|
||||||
|
|
||||||
import java.io.File;
|
|
||||||
import java.nio.file.Path;
|
|
||||||
import java.util.logging.Logger;
|
|
||||||
|
|
||||||
|
|
||||||
@Plugin(id = "minesql", name = "MineSQL (EasySQL-Plugin)",
|
|
||||||
version = References.VERSION,
|
|
||||||
description = "EasySQL Plugin For Velocity",
|
|
||||||
url = "https://github.com/CarmJos/MineSQL",
|
|
||||||
authors = {"CarmJos", "GhostChu"}
|
|
||||||
)
|
|
||||||
public class MineSQLVelocity implements MineSQLPlatform {
|
|
||||||
|
|
||||||
private final ProxyServer server;
|
|
||||||
private final Logger logger;
|
|
||||||
private final File dataFolder;
|
|
||||||
|
|
||||||
private final Metrics.Factory metricsFactory;
|
|
||||||
|
|
||||||
protected MineSQLCore core;
|
|
||||||
protected VelocityCommandManager commandManager;
|
|
||||||
|
|
||||||
@Inject
|
|
||||||
public MineSQLVelocity(ProxyServer server, Logger logger,
|
|
||||||
@DataDirectory Path dataDirectory,
|
|
||||||
Metrics.Factory metricsFactory) {
|
|
||||||
this.server = server;
|
|
||||||
this.logger = logger;
|
|
||||||
this.dataFolder = dataDirectory.toFile();
|
|
||||||
this.metricsFactory = metricsFactory;
|
|
||||||
|
|
||||||
getLogger().info("加载基础核心...");
|
|
||||||
this.core = new MineSQLCore(this);
|
|
||||||
}
|
|
||||||
|
|
||||||
@Subscribe(order = PostOrder.FIRST)
|
|
||||||
public void onInitialize(ProxyInitializeEvent event) {
|
|
||||||
|
|
||||||
|
|
||||||
getLogger().info("初始化指令管理器...");
|
|
||||||
this.commandManager = new VelocityCommandManager(server, this);
|
|
||||||
|
|
||||||
getLogger().info("注册相关指令...");
|
|
||||||
this.core.initializeCommands(getCommandManager());
|
|
||||||
|
|
||||||
if (getConfiguration().METRICS.getNotNull()) {
|
|
||||||
getLogger().info("启用统计数据...");
|
|
||||||
Metrics metrics = this.metricsFactory.make(this, 14078);
|
|
||||||
metrics.addCustomChart(new SimplePie("update_check",
|
|
||||||
() -> getConfiguration().UPDATE_CHECKER.getNotNull() ? "ENABLED" : "DISABLED")
|
|
||||||
);
|
|
||||||
metrics.addCustomChart(new SimplePie("properties_configuration",
|
|
||||||
() -> getConfiguration().PROPERTIES.ENABLE.getNotNull() ? "ENABLED" : "DISABLED")
|
|
||||||
);
|
|
||||||
}
|
|
||||||
|
|
||||||
if (getConfiguration().UPDATE_CHECKER.getNotNull()) {
|
|
||||||
getLogger().info("开始检查更新,可能需要一小段时间...");
|
|
||||||
getLogger().info(" 如不希望检查更新,可在配置文件中关闭。");
|
|
||||||
server.getScheduler().buildTask(this, () -> this.core.checkUpdate(getVersion())).schedule();
|
|
||||||
} else {
|
|
||||||
getLogger().info("已禁用检查更新,跳过。");
|
|
||||||
}
|
|
||||||
|
|
||||||
}
|
|
||||||
|
|
||||||
@Subscribe(order = PostOrder.LAST)
|
|
||||||
public void onShutdown(ProxyShutdownEvent event) {
|
|
||||||
getLogger().info("终止全部数据库连接...");
|
|
||||||
this.core.shutdownAll();
|
|
||||||
}
|
|
||||||
|
|
||||||
public ProxyServer getServer() {
|
|
||||||
return server;
|
|
||||||
}
|
|
||||||
|
|
||||||
public @NotNull Logger getLogger() {
|
|
||||||
return logger;
|
|
||||||
}
|
|
||||||
|
|
||||||
public String getVersion() {
|
|
||||||
return this.server.getPluginManager().getPlugin("minesql")
|
|
||||||
.map(PluginContainer::getDescription)
|
|
||||||
.flatMap(PluginDescription::getVersion).orElse("1.0.0");
|
|
||||||
}
|
|
||||||
|
|
||||||
@Override
|
|
||||||
public @NotNull File getPluginFolder() {
|
|
||||||
return this.dataFolder;
|
|
||||||
}
|
|
||||||
|
|
||||||
@Override
|
|
||||||
public @NotNull CommandManager<?, ?, ?, ?, ?, ?> getCommandManager() {
|
|
||||||
return commandManager;
|
|
||||||
}
|
|
||||||
|
|
||||||
public @NotNull PluginConfiguration getConfiguration() {
|
|
||||||
return this.core.getConfig();
|
|
||||||
}
|
|
||||||
}
|
|
||||||
-143
@@ -1,143 +0,0 @@
|
|||||||
<?xml version="1.0" encoding="UTF-8"?>
|
|
||||||
<project xmlns="http://maven.apache.org/POM/4.0.0"
|
|
||||||
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
|
|
||||||
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
|
|
||||||
<parent>
|
|
||||||
<artifactId>minesql-parent</artifactId>
|
|
||||||
<groupId>cc.carm.plugin</groupId>
|
|
||||||
<version>1.4.3</version>
|
|
||||||
</parent>
|
|
||||||
<modelVersion>4.0.0</modelVersion>
|
|
||||||
<properties>
|
|
||||||
<maven.compiler.source>${project.jdk.version}</maven.compiler.source>
|
|
||||||
<maven.compiler.target>${project.jdk.version}</maven.compiler.target>
|
|
||||||
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
|
|
||||||
<maven.compiler.encoding>UTF-8</maven.compiler.encoding>
|
|
||||||
<maven.javadoc.skip>true</maven.javadoc.skip>
|
|
||||||
<maven.deploy.skip>true</maven.deploy.skip>
|
|
||||||
</properties>
|
|
||||||
<artifactId>minesql-plugin</artifactId>
|
|
||||||
|
|
||||||
<dependencies>
|
|
||||||
|
|
||||||
<dependency>
|
|
||||||
<groupId>${project.parent.groupId}</groupId>
|
|
||||||
<artifactId>minesql-platform-bukkit</artifactId>
|
|
||||||
<version>${project.parent.version}</version>
|
|
||||||
<scope>compile</scope>
|
|
||||||
</dependency>
|
|
||||||
|
|
||||||
<dependency>
|
|
||||||
<groupId>${project.parent.groupId}</groupId>
|
|
||||||
<artifactId>minesql-platform-bungee</artifactId>
|
|
||||||
<version>${project.parent.version}</version>
|
|
||||||
<scope>compile</scope>
|
|
||||||
</dependency>
|
|
||||||
|
|
||||||
<dependency>
|
|
||||||
<groupId>${project.parent.groupId}</groupId>
|
|
||||||
<artifactId>minesql-platform-velocity</artifactId>
|
|
||||||
<version>${project.parent.version}</version>
|
|
||||||
<scope>compile</scope>
|
|
||||||
</dependency>
|
|
||||||
|
|
||||||
</dependencies>
|
|
||||||
|
|
||||||
<build>
|
|
||||||
<plugins>
|
|
||||||
<plugin>
|
|
||||||
<groupId>org.apache.maven.plugins</groupId>
|
|
||||||
<artifactId>maven-compiler-plugin</artifactId>
|
|
||||||
</plugin>
|
|
||||||
<plugin>
|
|
||||||
<groupId>org.apache.maven.plugins</groupId>
|
|
||||||
<artifactId>maven-jar-plugin</artifactId>
|
|
||||||
</plugin>
|
|
||||||
<plugin>
|
|
||||||
<groupId>org.apache.maven.plugins</groupId>
|
|
||||||
<artifactId>maven-shade-plugin</artifactId>
|
|
||||||
<version>3.6.1</version>
|
|
||||||
<executions>
|
|
||||||
<execution>
|
|
||||||
<phase>package</phase>
|
|
||||||
<goals>
|
|
||||||
<goal>shade</goal>
|
|
||||||
</goals>
|
|
||||||
</execution>
|
|
||||||
</executions>
|
|
||||||
|
|
||||||
<configuration>
|
|
||||||
<finalName>${project.parent.name}-${project.parent.version}</finalName>
|
|
||||||
<outputDirectory>${project.parent.basedir}/.asset/</outputDirectory>
|
|
||||||
<createDependencyReducedPom>false</createDependencyReducedPom>
|
|
||||||
<relocations>
|
|
||||||
<relocation>
|
|
||||||
<pattern>org.bstats</pattern>
|
|
||||||
<shadedPattern>${code.package}.lib.bstats</shadedPattern>
|
|
||||||
</relocation>
|
|
||||||
<relocation>
|
|
||||||
<pattern>org.json</pattern>
|
|
||||||
<shadedPattern>${code.package}.lib.json</shadedPattern>
|
|
||||||
</relocation>
|
|
||||||
<relocation>
|
|
||||||
<pattern>cc.carm.lib.easyplugin</pattern>
|
|
||||||
<shadedPattern>${code.package}.lib.easyplugin</shadedPattern>
|
|
||||||
</relocation>
|
|
||||||
<relocation>
|
|
||||||
<pattern>cc.carm.lib.githubreleases4j</pattern>
|
|
||||||
<shadedPattern>${code.package}.lib.githubreleases4j</shadedPattern>
|
|
||||||
</relocation>
|
|
||||||
<relocation>
|
|
||||||
<pattern>cc.carm.lib.configuration</pattern>
|
|
||||||
<shadedPattern>${code.package}.lib.configuration</shadedPattern>
|
|
||||||
</relocation>
|
|
||||||
<relocation>
|
|
||||||
<pattern>org.bspfsystems.yamlconfiguration</pattern>
|
|
||||||
<shadedPattern>${code.package}.lib.configuration.yaml</shadedPattern>
|
|
||||||
</relocation>
|
|
||||||
<relocation>
|
|
||||||
<pattern>org.yaml.snakeyaml</pattern>
|
|
||||||
<shadedPattern>${code.package}.lib.yaml</shadedPattern> <!-- Replace this -->
|
|
||||||
</relocation>
|
|
||||||
|
|
||||||
<relocation>
|
|
||||||
<pattern>co.aikar.commands</pattern>
|
|
||||||
<shadedPattern>${code.package}.lib.acf</shadedPattern> <!-- Replace this -->
|
|
||||||
</relocation>
|
|
||||||
<relocation>
|
|
||||||
<pattern>co.aikar.locales</pattern>
|
|
||||||
<shadedPattern>${code.package}.lib.locales</shadedPattern> <!-- Replace this -->
|
|
||||||
</relocation>
|
|
||||||
|
|
||||||
<relocation>
|
|
||||||
<pattern>net.byteflux.libby</pattern>
|
|
||||||
<shadedPattern>${code.package}.lib.libby</shadedPattern>
|
|
||||||
</relocation>
|
|
||||||
|
|
||||||
</relocations>
|
|
||||||
<filters>
|
|
||||||
<filter>
|
|
||||||
<artifact>co.aikar:*</artifact>
|
|
||||||
<excludes>
|
|
||||||
<exclude>META-INF/MANIFEST.MF</exclude>
|
|
||||||
<exclude>META-INF/*.txt</exclude>
|
|
||||||
<exclude>acf-core*.properties</exclude>
|
|
||||||
<exclude>acf-minecraft*.properties</exclude>
|
|
||||||
</excludes>
|
|
||||||
</filter>
|
|
||||||
<filter>
|
|
||||||
<artifact>*:*</artifact>
|
|
||||||
<excludes>
|
|
||||||
<exclude>META-INF/MANIFEST.MF</exclude>
|
|
||||||
<exclude>META-INF/*.txt</exclude>
|
|
||||||
<exclude>LICENSE</exclude>
|
|
||||||
<exclude>README</exclude>
|
|
||||||
</excludes>
|
|
||||||
</filter>
|
|
||||||
</filters>
|
|
||||||
</configuration>
|
|
||||||
</plugin>
|
|
||||||
</plugins>
|
|
||||||
</build>
|
|
||||||
|
|
||||||
</project>
|
|
||||||
@@ -1,13 +0,0 @@
|
|||||||
{
|
|
||||||
"$schema": "https://docs.renovatebot.com/renovate-schema.json",
|
|
||||||
"extends": [
|
|
||||||
"config:recommended"
|
|
||||||
],
|
|
||||||
"packageRules": [
|
|
||||||
{
|
|
||||||
"matchUpdateTypes": ["minor", "patch"],
|
|
||||||
"matchCurrentVersion": "!/^0/",
|
|
||||||
"automerge": true
|
|
||||||
}
|
|
||||||
]
|
|
||||||
}
|
|
||||||
Reference in New Issue
Block a user