Styjun

i'm making a basic app following clean architecture to learn it, and i'm not sure about how implementing model insertion when an order in insertion is needed.

I have "Event", "Artist", "Advert" entity.
- Event have one or more artist.
- Artist have one or more Event.
- Advert have one Event and/or artist.

I get data from a Json file online then my adapter map the data for my model of my data layer.
Now i have the data that i need to insert but for example when i insert an advert that reference an artist i need the artist to be inserted first so the foreign key of advert can reference the artist and my question is :
if i want to insert or upsert all the data at the same moment how respect the insertion order to avoid foreign key error?

My app shows a list of advert as the first view. I manage to do it by having a insertTask in my artistRepository (in domain layer) that call Insert method of my advertRepository in onPostExecute but it surely is the wrong way since i call method of a repo from another repo.

public class upsertFromServerAsync extends AsyncTask<Void, Void, JsonResponse> 
 //My mapper
 JsonResponse myResponse;

 @Override
 protected JsonResponse doInBackground(Void... voids) 

 retrofit = RetrofitClient.getInstance();
 apiService = retrofit.create(ApiService.class);
 Call<JsonResponse> call = apiService.getJsonFromServer("yh4ra");

 try 
 //Getting my data
 myResponse = call.execute().body();

 //Inserting events
 List<Event> events = myResponse.getEvents();
 for (Event event : events) 
 upsertEvent(event);
 

 //Inserting artists
 List<Artist> artists = myResponse.getArtists();
 for (Artist artist : artists) 
 upsertArtist(artist);
 

 catch (IOException e) 
 e.printStackTrace();
 

 return myResponse;
 

 @Override
 protected void onPostExecute(JsonResponse myResponse) 
 super.onPostExecute(myResponse);

 AsyncTask.execute(() -> 
 List<Advert> advertsFromJson = jsonAdapter.getAdvertsFromJson(myResponse);

 for (Advert advert : advertsFromJson) 
 Log.d("test", advert.getArtistName() + "");
 upsertAdvert(advert);
 
 );


 
 

this solution is a mess, i ended up having an upsertArtist and upsertAdvert method in my EventRepo. What is the good way for achieving this following the clean arch?
Maybe i need to use an interactor that can call several repo to upsert my model?
Thanks