Work diary in R&D Foundation Team

这是我在QAD正式上班的第三天，从今天起聊记一些工作上遇到的问题和解决方法吧，光阴似水不知道最后是否能否坚持。

---

7.23

Compile file.lst的文件结构

A /devl/apps/mfgpro/src/us/so/sosomtf3.i
A /devl/apps/mfgpro/src/us/so/sososhr4.i

或者

M /devl/apps/mfgpro/src/us/so/sosomtf3null.p
M /devl/apps/mfgpro/src/us/so/sososhr4null.i
M /devl/apps/mfgpro/xrc/us/so/sososhr4null.i

---

Register file.lst的文件结构

exclude .*
include src\/us\/so*
include src\/us\/bbi*
exclude src\/us\/so\/sosomtla.p

---

Checkin和Checkout的File.lst都直接输入文件名

如

us/po/xxpopomt.p
us/wo/woapixr.p
us/wo/wobkfl.p

---

 7.27

SQL语句关于case的注解

select p.name as program,
p.id as program_id,
case
when d.file_id is null then 0
else 1
end as locked,
d.file_lock_id as lock_id,

ifnull(l.lock_holder, '') as locker,
case l.lock_holder
when ? then 1
else 0
end as self_lock,

#如果l.lock_holder = ?（输入值），则将self_lock设为1，否则设为0
ifnull(l.lock_note, '') as notes,
d.own_datetime as lock_datetime
from files p
left join file_lock_owned d
on (p.id = d.file_id)
left join file_lock l
on (l.id = d.file_lock_id)
where p.name = ?
and l.lock_ticket = ?
and p.environment = ?

 

---

7.29

在linux下对zip和tar文件的解压

Zip： unzip file.zip -d destination_folder

TAR：tar -zxvf test123.tar.gz

 

---

7.30

Manpage的使用总结