常用指令
远程连接云主机
- ssh 用户名@IP
- password:
切换root权限:
- sudo su
切换powershell
- powershell
文件映射
mklink /j 代码编译路径 同步文件夹路径
docker常用指令
-
拉取镜像
docker pull elasticsearch:6.5.1
-
启动容器
docker run -it --name <container name> /bin/bash
-
进入容器
docker exec -it <container name> /bin/bash
-
修改配置文件
vi logstash.yml
-
使profile文件生效
source /etc/profile
-
yum安装
yum -y install wget
-
启动容器
docker run -d -i -t --name <container name> logstash:6.5.1
-
查找所有containers
docker ps -a
.net core 更新数据库##
-
添加migration
add-migration "init" -c ApplicationDbContext
-
更新数据库
update-database
aot编译前端
npm run-script build
查看数据库日志
- 查看数据库日志的工具:
- (在cmd窗口输入命令:D:\database\MySQL\bin\mysqlbinlog.exe D:\Database\data\mysql-bin-log.000002 > D:\aaa.txt)。
- 有个升级版的脚本可以把所有的数据库日志输出到一个文件中($/MCSF/Doc/Database&Dicom/Database/binlog.bat),需要修改输出路径后使用(路径前是>表示覆盖,是>>表示追加),运行时需要输入数据库日志路径。
联合查询语言
- sql查询:
SELECT patient.uid, patient.`patientid`,course.`coursename`, site.`name` FROM patient patient, course course , site site WHERE patient.`uid` = course.patientuid AND course.`uid` = site.`courseuid`
- ef查询:
var query = (from dgs in _dbWrapper.Entities.tmsdeliverybeamgroup_session
join dg in _dbWrapper.Entities.deliverybeamgroups on dgs.deliverybeamgroupuid equals dg.uid
join t in _dbWrapper.Entities.treatmentsessions on dgs.treatmentsessionuid equals t.uid
select new
{
BeamGroupUid = dg.uid,
TreatmentsessionUid =dgs.treatmentsessionuid,
} );
select where in 用法
SELECT * FROM patient WHERE uid IN (
SELECT patientuid FROM course WHERE uid IN (
SELECT courseuid FROM site WHERE uid IN (
SELECT siteuid FROM prescription WHERE uid IN (
SELECT prescriptionuid FROM deliverybeamgroup WHERE uid IN('xxxxxxxxxxxxx')))))
可以使用AOT来编译
“start”: “ng serve --prod --host 0.0.0.0 --port 10215 --open”,
编译dist文件
npm run build