Yudao Boot Mini

https://github.com/yudaocode/yudao-boot-mini
Admin
Yudao Boot Mini is a simplified, open-source rapid development platform based on Spring Boot,...
Tokens:1,353
Snippets:23
Trust Score:7.7
License:MIT
Update:4 months ago
Show doc for...
Tokens:
Raw
### Start SQL Server Docker Container and Initialize Schema

Source: https://github.com/yudaocode/yudao-boot-mini/blob/master/sql/tools/README.md

Quickly starts a SQL Server instance using Docker Compose. After starting, manually execute the schema initialization script. Ensure you are in the 'sql/tools' directory.

```Bash
docker compose up -d sqlserver
docker compose exec sqlserver bash /tmp/create_schema.sh
```

--------------------------------

### Start KingbaseES Docker Container and Initialize Schema

Source: https://github.com/yudaocode/yudao-boot-mini/blob/master/sql/tools/README.md

Quickly starts a KingbaseES database instance using Docker Compose. After starting, manually execute the schema initialization script. Ensure you are in the 'sql/tools' directory.

```Bash
docker compose up -d kingbase
docker compose exec kingbase bash -c 'ksql -U $DB_USER -d test -f /tmp/schema.sql'
```

--------------------------------

### Start MySQL Docker Container

Source: https://github.com/yudaocode/yudao-boot-mini/blob/master/sql/tools/README.md

Quickly starts a MySQL database instance using Docker Compose. Ensure you are in the 'sql/tools' directory.

```Bash
docker compose up -d mysql
```

--------------------------------

### Start DM Database Docker Container and Initialize Schema

Source: https://github.com/yudaocode/yudao-boot-mini/blob/master/sql/tools/README.md

Quickly starts a DM database instance using Docker Compose. After starting, manually execute the schema initialization script. Ensure you are in the 'sql/tools' directory.

```Bash
docker compose up -d dm8
docker compose exec dm8 bash -c '/opt/dmdbms/bin/disql SYSDBA/SYSDBA001 \`/tmp/schema.sql'
exit
```

--------------------------------

### Start PostgreSQL Docker Container

Source: https://github.com/yudaocode/yudao-boot-mini/blob/master/sql/tools/README.md

Quickly starts a PostgreSQL database instance using Docker Compose. Ensure you are in the 'sql/tools' directory.

```Bash
docker compose up -d postgres
```

--------------------------------

### Start OpenGauss Docker Container and Initialize Schema

Source: https://github.com/yudaocode/yudao-boot-mini/blob/master/sql/tools/README.md

Quickly starts an OpenGauss database instance using Docker Compose. After starting, manually execute the schema initialization script. Ensure you are in the 'sql/tools' directory.

```Bash
docker compose up -d opengauss
docker compose exec opengauss bash -c '/usr/local/opengauss/bin/gsql -U $GS_USERNAME -W $GS_PASSWORD -d postgres -f /tmp/schema.sql'
```

--------------------------------

### Start Oracle Docker Container (Apple Silicon)

Source: https://github.com/yudaocode/yudao-boot-mini/blob/master/sql/tools/README.md

Quickly starts an Oracle database instance using Docker Compose for MacBook Apple Silicon. Note that ORACLE_SID is 'FREE' for this version. Ensure you are in the 'sql/tools' directory.

```Bash
docker compose up -d oracle_m1
```

--------------------------------

### Start Oracle Docker Container (x86)

Source: https://github.com/yudaocode/yudao-boot-mini/blob/master/sql/tools/README.md

Quickly starts an Oracle database instance using Docker Compose for x86 architecture. Ensure you are in the 'sql/tools' directory.

```Bash
docker compose up -d oracle
```

--------------------------------

### Install simple-ddl-parser Dependency

Source: https://github.com/yudaocode/yudao-boot-mini/blob/master/sql/tools/README.md

Installs the 'simple-ddl-parser' Python library required for the database conversion script. Use pip3 if pip is not aliased.

```Bash
pip install simple-ddl-parser
# pip3 install simple-ddl-parser
```

--------------------------------

### Load KingbaseES Docker Image

Source: https://github.com/yudaocode/yudao-boot-mini/blob/master/sql/tools/README.md

Loads a KingbaseES Docker image from a tar file. Run this command in the directory containing the image tar file.

```Bash
docker load -i kdb_x86_64_V009R001C001B0025.tar
```

--------------------------------

### Load DM Database Docker Image

Source: https://github.com/yudaocode/yudao-boot-mini/blob/master/sql/tools/README.md

Loads a DM database Docker image from a tar file. Run this command in the directory containing the image tar file.

```Bash
docker load -i dm8_20240715_x86_rh6_rq_single.tar
```

--------------------------------

### Convert MySQL to PostgreSQL Script

Source: https://github.com/yudaocode/yudao-boot-mini/blob/master/sql/tools/README.md

Converts a MySQL database script to a PostgreSQL script using the convertor.py script. The output is printed to the console and can be redirected to a file. Ensure you are in the 'sql/tools/' directory.

```Bash
python3 convertor.py postgres
# python3 convertor.py postgres > tmp.sql
```

--------------------------------

### Destroy and Recreate PostgreSQL Docker Container and Volume

Source: https://github.com/yudaocode/yudao-boot-mini/blob/master/sql/tools/README.md

Stops a PostgreSQL Docker container and removes its associated data volume to create a clean database instance. Ensure you are in the 'sql/tools' directory.

```Bash
docker compose down postgres
docker volume rm ruoyi-vue-pro_postgres
```
Tokens:
Raw