admin 发布的文章

PowerDesigner 自动转为小写

作者: admin
时间: 2025-08-19
分类: 默认分类,PgSQL
评论

Tools > Model Options > Naming Convention

PowerDesigner显示Comment注释

作者: admin
时间: 2025-08-07
分类: 默认分类,数据库
评论

PowerDesigner->Tools->Execute Commands->Edit/Run Scripts
将代码Copy进去执行就可以了

将Comment中的字符COPY至Name中

Option   Explicit 
ValidationMode   =   True 
InteractiveMode   =   im_Batch
 
Dim   mdl   '   the   current   model
 
'   get   the   current   active   model 
Set   mdl   =   ActiveModel 
If   (mdl   Is   Nothing)   Then 
  MsgBox   "There   is   no   current   Model " 
ElseIf   Not   mdl.IsKindOf(PdPDM.cls_Model)   Then 
  MsgBox   "The   current   model   is   not   an   Physical   Data   model. " 
Else 
  ProcessFolder   mdl 
End   If
 
Private   sub   ProcessFolder(folder) 
On Error Resume Next
  Dim   Tab   'running table 
  for   each   Tab   in   folder.tables 
if   not   tab.isShortcut   then 
  tab.name   =   tab.comment
  Dim   col   '   running   column 
  for   each   col   in   tab.columns 
  if col.comment="" then
  else
col.name=   col.comment 
  end if
  next 
end   if 
  next
 
  Dim   view   'running   view 
  for   each   view   in   folder.Views 
if   not   view.isShortcut   then 
  view.name   =   view.comment 
end   if 
  next
 
  '   go   into   the   sub-packages 
  Dim   f   '   running   folder 
  For   Each   f   In   folder.Packages 
if   not   f.IsShortcut   then 
  ProcessFolder   f 
end   if 
  Next 
end   sub

将Name中的字符COPY至Comment中

Option   Explicit 
ValidationMode   =   True 
InteractiveMode   =   im_Batch
 
Dim   mdl   '   the   current   model
 
'   get   the   current   active   model 
Set   mdl   =   ActiveModel 
If   (mdl   Is   Nothing)   Then 
      MsgBox   "There   is   no   current   Model " 
ElseIf   Not   mdl.IsKindOf(PdPDM.cls_Model)   Then 
      MsgBox   "The   current   model   is   not   an   Physical   Data   model. " 
Else 
      ProcessFolder   mdl 
End   If
 
'   This   routine   copy   name   into   comment   for   each   table,   each   column   and   each   view 
'   of   the   current   folder 
Private   sub   ProcessFolder(folder) 
      Dim   Tab   'running     table 
      for   each   Tab   in   folder.tables 
            if   not   tab.isShortcut   then 
                  tab.comment   =   tab.name 
                  Dim   col   '   running   column 
                  for   each   col   in   tab.columns 
                            col.comment=   col.name 
                  next 
            end   if 
      next
 
      Dim   view   'running   view 
      for   each   view   in   folder.Views 
            if   not   view.isShortcut   then 
                  view.comment   =   view.name 
            end   if 
      next
 
      '   go   into   the   sub-packages 
      Dim   f   '   running   folder 
      For   Each   f   In   folder.Packages 
            if   not   f.IsShortcut   then 
                  ProcessFolder   f 
            end   if 
      Next 
end   sub

将每个表的Code附加到Name前面，格式为：原Code + 空格 + 原Name

Option Explicit
ValidationMode = True
InteractiveMode = im_Batch

Dim mdl ' the current model

' get the current active model
Set mdl = ActiveModel
If (mdl Is Nothing) Then
  MsgBox "There is no current Model"
ElseIf Not mdl.IsKindOf(PdPDM.cls_Model) Then
  MsgBox "The current model is not an Physical Data model."
Else
  ProcessFolder mdl
End If

Private Sub ProcessFolder(folder)
On Error Resume Next
  Dim tab ' running table
  For Each tab In folder.tables
    If Not tab.isShortcut Then
      ' 将Code附加到Name前
      tab.name = tab.code & " " & tab.name
    End If
  Next
  
  ' 递归处理子包
  Dim f ' running folder
  For Each f In folder.Packages
    If Not f.IsShortcut Then
      ProcessFolder f
    End If
  Next
End Sub

网管系统zabbix安装部署

作者: admin
时间: 2024-07-09
分类: 运维
评论

一、服务器安装


mkdir /data/zabbix -p
mkdir /data/mysql -p
echo "version: '3.8'
services:
  mysql:
    container_name: mysql
    image: mysql:8.0
    restart: unless-stopped
    environment:
      TZ: Asia/Shanghai
      MYSQL_DATABASE: zabbix
      MYSQL_USER: zabbix
      MYSQL_PASSWORD: zabbix_pwd
      MYSQL_ROOT_PASSWORD: 123456
    network_mode: "host"
    volumes:
      - ./data:/var/lib/mysql
      - ./logs:/var/log/mysql
      - ./conf.d:/etc/mysql/conf.d
      - ./my.cnf:/etc/my.cnf
    command: --character-set-server=utf8 --collation-server=utf8_bin --default-authentication-plugin=mysql_native_password">/data/mysql/docker-compose.yml

echo "[mysqld]
#绑定IP
bind-address = 0.0.0.0
# 设置3306端口
port=3306

#修改为北京时间
default-time-zone=+8:00

# 服务端使用的字符集默认为utf8mb4
character-set-server=utf8mb4
init_connect='SET NAMES utf8mb4'

# 创建新表时将使用的默认存储引擎
default-storage-engine=INNODB

# 默认使用“mysql_native_password”插件认证
#mysql_native_password
default_authentication_plugin=mysql_native_password

[mysql]
# 设置mysql客户端默认字符集
default-character-set=utf8mb4

[client]
# 设置mysql客户端连接服务端时默认使用的端口
port=3306
default-character-set=utf8mb4">/data/mysql/my.cnf

echo "docker-compose down && docker-compose up -d && docker logs -f mysql" >/data/mysql/restart.sh

echo "version: '3.5'
services:
  zabbix-server:
    image: zabbix/zabbix-server-mysql:latest
    container_name: zabbix-server
    environment:
      TZ: Asia/Shanghai
      DB_SERVER_HOST: 192.168.100.1
      MYSQL_USER: root
      MYSQL_PASSWORD: 123456
      MYSQL_DATABASE: zabbix
      StartConnectors: 3
      StartIPMIPollers: 1
      StartJavaPollers: 1
      StartSNMPTrapper: 1
      StartVMwareCollectors: 1
    ports:
      - "10051:10051"
    networks:
      - mynetwork
  zabbix-web:
    image: zabbix/zabbix-web-nginx-mysql:latest
    container_name: zabbix-web
    environment:
      TZ: Asia/Shanghai
      ZBX_SERVER_HOST: zabbix-server
      DB_SERVER_HOST: 192.168.100.1
      MYSQL_USER: root
      MYSQL_PASSWORD: 123456
      MYSQL_DATABASE: zabbix
    ports:
      - "8080:8080"
      - "8443:8443"
    networks:
      - mynetwork
networks:
  mynetwork:
    external: true
">/data/zabbix/docker-compose.yml

二、客户端安装

#centos8
sudo rpm -Uvh  https://repo.zabbix.com/zabbix/7.0/centos/8/x86_64/zabbix-agent-7.0.0-release1.el8.x86_64.rpm

#centos9
sudo rpm -Uvh  https://repo.zabbix.com/zabbix/7.0/centos/9/x86_64/zabbix-agent-7.0.0-release1.el9.x86_64.rpm

sudo systemctl status zabbix-agent
#如果未安装成功
sudo dnf install zabbix-agent

#修改文件
sudo vi /etc/sysctl.conf
fs.inotify.max_queued_events=1048576
fs.inotify.max_user_instances=1048576
fs.inotify.max_user_watches=1048576
sudo sysctl -p

三、配置

vi /etc/zabbix/zabbix_agentd.conf
#或者
vi /etc/zabbix_agentd.conf

Server=192.168.232.170
StartAgents=3
ServerActive=192.168.232.170
Hostname=dev-test

sudo systemctl enable zabbix-agent
sudo systemctl start zabbix-agent && sudo systemctl status zabbix-agent && tail -f /var/log/zabbix/zabbix_agentd.log

#查看运行日志
tail -f /var/log/zabbix/zabbix_agentd.log

jumpserver项目nginx配置

作者: admin
时间: 2023-08-27
分类: 运维
评论

server
{
  server_name   login.xxx.cn;
  include  /common/all_xxx.cn.conf;
  location / {
    root    /;
    proxy_buffering off;
    proxy_request_buffering off;
    proxy_http_version 1.1;
    proxy_set_header Host $host;
    proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
    proxy_set_header Upgrade $http_upgrade;
    proxy_set_header Connection $http_connection;

    proxy_ignore_client_abort on;
    proxy_connect_timeout 600;
    proxy_send_timeout 600;
    proxy_read_timeout 600;
    send_timeout 6000;
    proxy_pass    http://192.168.100.1:8081/;
  }
}

欢迎使用 Typecho

作者: admin
时间: 2022-11-15
分类: 默认分类
1 条评论

如果您看到这篇文章,表示您的 blog 已经安装成功.

admin 发布的文章

PowerDesigner 自动转为小写

PowerDesigner显示Comment注释

将Comment中的字符COPY至Name中

将Name中的字符COPY至Comment中

将每个表的Code附加到Name前面，格式为：原Code + 空格 + 原Name

网管系统zabbix安装部署

一、服务器安装

二、客户端安装

三、配置

jumpserver项目nginx配置

欢迎使用 Typecho

最新文章

最近回复

分类

归档

其它