过滤实体表

filtered_entity_list.txt

账簿
账簿科目
银行
银行账户
银行类别
单据类型
交易类型
币种
组织
部门
费用项目
费用项目类型
项目
项目类型
客户分类
客户
供应商分类
供应商
用户
凭证类型

output.txt

mysql> select id, displayName from md_entity where displayName in ("账簿",
    -> "账簿科目",
    -> "银行",
    -> "银行账户",
    -> "银行类别",
    -> "单据类型",
    -> "交易类型",
    -> "币种",
    -> "组织",
    -> "部门",
    -> "费用项目",
    -> "费用项目类型",
    -> "项目",
    -> "项目类型",
    -> "客户分类",
    -> "客户",
    -> "供应商分类",
    -> "供应商",
    -> "用户",
    -> "凭证类型");
+--------------------------------------+--------------------+
| id                                   | displayName        |
+--------------------------------------+--------------------+
| G001ZM0000BASEDOCACCBOOK000000000000 | 账簿               |
| G001ZM0000BASEDOCACCSUBJECT000000000 | 账簿科目           |
| G001ZM0000BASEDOCBANK000000000000000 | 银行               |
| G001ZM0000BASEDOCBANKACCOUNT00000000 | 银行账户           |
| G001ZM0000BASEDOCBANKCLASS0000000000 | 银行类别           |
| G001ZM0000BASEDOCBILLTYPE00000000000 | 单据类型           |
| G001ZM0000BASEDOCCURRENCY00000000000 | 币种               |
| G001ZM0000BASEDOCDEPT000000000000000 | 部门               |
| G001ZM0000BASEDOCFEEITEM000000000000 | 费用项目           |
| G001ZM0000BASEDOCFEEITEMCLASS0000000 | 费用项目类型       |
| G001ZM0000BASEDOCORG0000000000000000 | 组织               |
| G001ZM0000BASEDOCPROJECT000000000000 | 项目               |
| G001ZM0000BASEDOCPROJECTCLASS0000000 | 项目类型           |
| G001ZM0000BASEDOCTRADER0001000000000 | 供应商             |
| G001ZM0000BASEDOCTRADER0040000000000 | 客户               |
| G001ZM0000BASEDOCTRADERCLASS10000000 | 客户分类           |
| G001ZM0000BASEDOCTRADERCLASS20000000 | 供应商分类         |
| G001ZM0000BASEDOCTRADETYPE0000000000 | 交易类型           |
| G001ZM0000BASEDOCUSER000000000000000 | 用户               |
| G001ZM0000BASEDOCVOUCHERTYPE00000000 | 凭证类型           |
+--------------------------------------+--------------------+
20 rows in set (0.01 sec)

sed.sh

sed 's/.*/"&",/' filtered_entity_list.txt