我有一个可用的postgres触发器,用于本地驱动器上的文件夹操作。我想将这些操作移动到网络驱动器,其中K是网络驱动器:
CREATE OR REPLACE FUNCTION "public"."_copy_folderstructure_ms_mus_dslam_kserver"()
RETURNS "pg_catalog"."trigger" AS $BODY$
import shutil
import os
import time
try:
if not os.path.exists("k:/SWBT/musbt_projects/" + TD["new"]["ff6ff"]):
os.makedirs("k:/SWBT/musbt_projects/" + TD["new"]["ff6ff"])
time.sleep(1)
os.makedirs("k:/SWBT/musbt_projects/" + TD["new"]["ff6ff"] + "/" + TD["new"]["f3410"])
time.sleep(1)
print("ok")
except:
print("fail")
try:
if (TD["new"]["created_at"] != TD["new"]["updated_at"]):
print("ok")
elif (TD["new"]["created_at"] == TD["new"]["updated_at"]):
shutil.copytree("k:/SWBT/musbt_projects/Templates/musnumber_pcpnumber","k:/SWBT/musbt_projects/" + TD["new"]["ff6ff"] + "/" + TD["new"]["f3410"])
time.sleep(1)
shutil.copy("k:/SWBT/musbt_projects/Templates/costing_sheet_templates" + "/" + TD["new"]["f4465"] + ".xls","k:/SWBT/musbt_projects/" + TD["new"]["ff6ff"] + "/" + TD["new"]["f3410"] + "/" + TD["new"]["f3410"] + "_cost.xls" )
except:
print("fail")
$BODY$
LANGUAGE plpython3u VOLATILE
COST 100
假设我以错误的方式使用网络路径,此代码不会生成任何错误或结果?(不过它是作为K驱动器安装的)我也尝试过使用//192.168.16.253/clients2
而不是k:/
任何帮助都将不胜感激
目前没有回答
相关问题 更多 >
编程相关推荐