Twig已经提供了从一系列目录而不是一个目录中加载模板的选项。
DECLARE @temp AS TABLE(
[action] NVARCHAR(20),[GlobalId] BIGINT,[Personnumber] NVARCHAR(100),[Firstname] NVARCHAR(100),[Lastname] NVARCHAR(100)
);
;WITH person AS
(
SELECT top 1
t.[Personnumber],t.[Firstname],t.[Lastname]
FROM [temp].[RawRoles] t
WHERE t.Personnumber NOT IN
(
SELECT i.Account FROM [security].[Accounts] i
)
)
MERGE [security].[Identities] AS tar
USING person AS src
ON 0 = 1 -- all rows from src need to be inserted,ive already filtered out using CTE Query.
WHEN NOT MATCHED THEN
INSERT
(
[Created],[Updated]
)
VALUES
(
GETUTCDATE(),GETUTCDATE()
)
OUTPUT $action,inserted.GlobalId,src.[Personnumber],src.[Firstname],src.[Lastname] INTO @temp;
SELECT * FROM @temp
此外,在将加载程序传递到环境对象之前,您可以添加自定义名称空间的路径,即:
$loader = new \Twig\Loader\FilesystemLoader([$templateDir1,$templateDir2]);
然后您可以像这样使用名称空间:
$loader->addPath($templateDir,'admin');
https://twig.symfony.com/doc/3.x/api.html#built-in-loaders
本文链接:https://www.f2er.com/3006925.html