Bulk copy of translations

General
1

I have a multilingial object “Article” ( 2 additional languages) and I want to select an unknown number of Articles and duplicate them. Even large numbers of selected Articles are not a problem with insertDataFromSelect(). (Thanks again @seb for the solution regarding the IDs!)

But what would be the best or most efficient way to handle the translations? I could of course use MultilingualPresideObjectService to select the translations one by one and insert them for the duplicated Article, but, that is terribly ineffective, especially if the source list is getting big. Even with as few as 1.000 Articles that would mean 3.000 queries.

Setting up a “insert-from-select” query is simple enough, but, I couldn’t find a method in MultilingualPresideObjectService that allows for something similar as insertDataFromSelect(). Using the (not multilingual) PresideObjectService() to address a translation object also isn’t possible, I think.

I could do a manual query, of course, but, I am quite reluctant to do so.
So what would be the best approach to this?

Thank you in advance!

2

Using the (not multilingual) PresideObjectService() to address a translation object also isn’t possible, I think.

This should be possible. Something like:

presideObjectService.insertDataFromSelect( 
      objectName = multilingualPresideObjectService.getTranslationObjectName( "my_object" )
    , ...
)

What I think is not possible is: getPresideObject( translationObjectName ).stuff().