Clone content to new tenant (first pass)

[CrispinF]

A 'Clone site' tool to allow an admin to clone the current tenant site to a new (existing) tenant.
In due course we will make this part of a cloudscribe Core tenant clone tool, which creates the new tenant, but at this stage we will start with just the SImpleContent part and assume the new tenant has been created already.
Allow this tool to be plugged into navigation.xml, with its own view to ask for the destination site alias (NB).
Assume destination tenant is empty of SimpleContent data (as it certainly will be when this is called from a Core tool).
Do clone Content Settings.
Do clone Blog.
Do not clone content history - this doesn't belong in the destination.
Do not clone users, roles, policies, etc.

[SimonAnnetts]

Notes to self:

Projects that have been altered and need version bump:

• cloudscribe.Core.SimpleContent (6.0.1)
• cloudscribe.Core.SimpleContent.CompiledViews.Bootstrap5 (6.0.1)
• cloudscribe.SimpleContent.Models (6.0.1)
• cloudscribe.SimpleContent.Storage.EFCore.Common (6.0.3)
• cloudscribe.SimpleContent.Storage.NoDb (6.0.1)

I'm actually going to update everything that has a project reference to one of the above or one of the below as I can't work out the dependency chain!

• cloudscribe.ContentUtils - no references
• cloudscribe.Core.SimpleContent (6.0.1)
• cloudscribe.Core.SimpleContent.CompiledViews.Bootstrap5 (6.0.1)
• cloudscribe.MetaWeblog -no references
• cloudscribe.SimpleContent.CompiledViews.Bootstrap5 (6.0.3)
• cloudscribe.SimpleContent.ContentTemplates.Bootstrap5 (6.0.2)
• cloudscribe.SimpleContent.MetaWeblog (6.0.1)
• cloudscribe.SimpleContent.Models (6.0.1)
• cloudscribe.SimpleContent.Security.SimpleAuth -not in solution!
• cloudscribe.SimpleContent.Storage.EFCore.Common (6.0.3)
• cloudscribe.SimpleContent.Storage.EFCore.MSSQL (6.0.3)
• cloudscribe.SimpleContent.Storage.EFCore.MySQL (6.0.2)
• cloudscribe.SimpleContent.Storage.EFCore.pgsql (6.0.3)
• cloudscribe.SimpleContent.Storage.EFCore.PostgreSql (6.0.4)
• cloudscribe.SimpleContent.Storage.EFCore.SQLite (6.0.2)
• cloudscribe.SimpleContent.Storage.NoDb (6.0.1)
• cloudscribe.SimpleContent.Syndication (6.0.1)
• cloudscribe.SimpleContent.Web (6.0.4)

[SimonAnnetts]

An extra entry for navigation.xml between Privacy Settings and Content Settings:

        <NavNode key="ContentCloning"
                 controller="ContentCloning"
                 action="Index"
                 text="Content Cloning"
                 iconCssClass="fas fa-copy"
                 preservedRouteParameters="siteId"
                 componentVisibility="breadcrumbs,childtree,parenttree"
                 authorizationPolicy="AdminPolicy"
                 excludeFromSearchSiteMap="true">
          <Children></Children>
        </NavNode>

[SimonAnnetts]

All uploaded to nuget.org

[SimonAnnetts]

Tested with NoDb and Postgres in new cloudscribe projects from the template.

[JimKerslake]

Bug:

the re-parenting after a clone is going wrong and dumping too many pages at root level -
because it is assuming (wrongly) that the ParentSlug field in the source pages will always be correct - not true.

If the slug of a parent page is subsequently changed via the UI, its children just retain the old incorrect ParentSlug value (probably a bug in itself - unless there is some more complex reason for that...)
(Also, for some unknown reason manually editing a ParentSlug value via the UI fails to persist the change... mysterious.)

So parentage needs to be established via Guids not slugs.

I've got a candidate fix now - just needs testing etc.

[JimKerslake]

Also adding in a second change - cloning into a clean new site will now clear the navigation cache so that all the new pages show up in the nav immediately (otherwise the cache is pretty persistent, it seems).

cloudscribe.Core.SimpleContent.6.0.5.nupkg

[JimKerslake]

Don't close yet - when used in a client site (insights) it failed to clone a sub-set of the pages, for some reason.
(Violation of primary key error)
Needs more investigation on a backup of the database for that project.