Affecto.IdentityManagement.Store.PostgreSql.Migrations.RolePermissionMigration.AddPermissionIfNotExists C# (CSharp) Method

        protected void AddPermissionIfNotExists(string permissionId, string permissionName)
        {
            string sql = "INSERT INTO {0} (id, name)"
                + " SELECT '{1}', '{2}'"
                + " WHERE NOT EXISTS (SELECT id FROM {0} WHERE id = '{1}');";

            Sql(string.Format(sql, FormatTableNameWithSchemaNameAndQuotes("permission"), permissionId, permissionName));
        }