ImportFromMembers.java

Go to the documentation of this file.

/*
 * Turró i Cutiller Foundation. License notice.
 * Copyright (C) 2022 Lluis Turró Cutiller <http://www.turro.org/>
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Affero General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * GNU Affero General Public License for more details.
 *
 * You should have received a copy of the GNU Affero General Public License
 * along with this program.  If not, see <http://www.gnu.org/licenses/>.
 */
 
package org.turro.importer;
 
import java.util.HashSet;
import java.util.List;
import java.util.Set;
import org.turro.alliance.db.AlliancePU;
import org.turro.alliance.db.entities.AxCenter;
import org.turro.alliance.db.entities.AxChallenge;
import org.turro.alliance.db.entities.AxContact;
import org.turro.alliance.db.entities.AxDescriptor;
import org.turro.alliance.db.entities.AxParticipation;
import org.turro.alliance.db.entities.AxProject;
import org.turro.alliance.db.entities.AxProjectGrant;
import org.turro.alliance.db.entities.AxResponse;
import org.turro.alliance.db.entities.AxStudent;
import org.turro.alliance.db.entities.AxTag;
import org.turro.alliance.service.AxConstants;
import org.turro.alliance.service.AxClient;
import org.turro.jpa.Dao;
import org.turro.json.Jsons;
import org.turro.log.WebLoggers;
import org.turro.sql.SqlClause;
import org.turro.tags.Tags;
import org.turro.ws.WsMember;
import org.turro.ws.service.server.Clients;
 
public class ImportFromMembers {
 
  public static void connect() {
    Clients.getMembers(AxClient.CLIENT_SERVICE).forEach(member -> {
      if(Clients.checkClientService(member.getMemberDomain(), member.getService())) {
        connect(member);
      }
    });          
  }
  
  public static void connect(WsMember member) {
    try {
      ImportFromMembers ifm = new ImportFromMembers();
      ifm.removeContactsFromMember(member);
      ifm.importContactsFromJson(member, Clients.getData(member, AxConstants.USERS));
      ifm.removeProjectsFromMember(member);
      ifm.removeParticipationsFromMember(member);
      ifm.removeDescriptorsFromMember(member);
      ifm.importProjectsFromJson(member, Clients.getData(member, AxConstants.PROJECTS));
      ifm.removeProjectGrantsFromMember(member);
      ifm.importProjectGrantsFromJson(member, Clients.getData(member, AxConstants.PROJECT_GRANTS));
      ifm.removeCentersFromMember(member);
      ifm.importCentersFromJson(member, Clients.getData(member, AxConstants.CENTERS));
      ifm.removeStudentsFromMember(member);
      ifm.importStudentsFromJson(member, Clients.getData(member, AxConstants.STUDENTS));
      ifm.removeChallengesFromMember(member);
      ifm.importChallengesFromJson(member, Clients.getData(member, AxConstants.CHALLENGES));
      ifm.removeTagsFromMember(member);
      ifm.importTagsFromJson(member, Clients.getData(member, AxConstants.TAGS));
    } catch(Exception ex) {
      WebLoggers.severe(ImportFromMembers.class).message(member.getMemberDomain()).exception(ex).log();
    }
  }
  
  public void importContactsFromJson(WsMember member, Jsons json) {
    json.getStructure().asArray().forEach(contact -> {
      getDao().saveEntity(AxContact.fromJson(contact));
    });
  }
 
  public void importProjectsFromJson(WsMember member, Jsons json) {
    json.getStructure().asArray().forEach(project -> {
      AxProject tmp = AxProject.fromJson(project);
      Set<AxDescriptor> descriptors = new HashSet<>();
      descriptors.addAll(tmp.getDescriptors());
      tmp.setDescriptors(null);
      getDao().saveEntity(tmp);
      for(AxDescriptor descriptor : descriptors) {
        getDao().persistObject(descriptor);
      }
    });
  }
 
  public void importProjectGrantsFromJson(WsMember member, Jsons json) {
    json.getStructure().asArray().forEach(projectGrant -> {
      AxProjectGrant tmp = AxProjectGrant.fromJson(projectGrant);
      getDao().saveEntity(tmp);
    });
  }
 
  public void importCentersFromJson(WsMember member, Jsons json) {
    json.getStructure().asArray().forEach(center -> {
      AxCenter tmp = AxCenter.fromJson(center);
      getDao().saveEntity(tmp);
    });
  }
 
  public void importStudentsFromJson(WsMember member, Jsons json) {
    json.getStructure().asArray().forEach(student -> {
      AxStudent tmp = AxStudent.fromJson(student);
      getDao().saveEntity(tmp);
    });
  }
 
  public void importChallengesFromJson(WsMember member, Jsons json) {
    json.getStructure().asArray().forEach(challenge -> {
      AxChallenge tmp = AxChallenge.fromJson(challenge);
      Set<AxResponse> responses = new HashSet<>();
      responses.addAll(tmp.getResponses());
      tmp.setResponses(null);
      getDao().saveEntity(tmp);
      for(AxResponse response : responses) {
        getDao().persistObject(response);
      }
    });
  }
 
  public void importTagsFromJson(WsMember member, Jsons json) {
    json.getStructure().asArray().forEach(tag -> {
      AxTag axt = AxTag.fromJson(tag);
      Tags.addTag(axt.getEntityRoot() + axt.stringifyId(), axt.getTagName());
    });
  }
 
  public void importContactsFromRegister(WsMember member, List<ImporterRegister> data) {
    for(ImporterRegister register : data) {
      getDao().saveEntity(AxContact.from(member.getMemberId(), register));
    }
  }
 
  public void importProjectsFromRegister(WsMember member, List<ImporterRegister> data) {
    for(ImporterRegister register : data) {
      getDao().saveEntity(AxProject.from(member.getMemberId(), register));
    }
  }
 
  public void importParticipationsFromRegister(WsMember member, List<ImporterRegister> data) {
    for(ImporterRegister register : data) {
      getDao().saveEntity(AxParticipation.from(member.getMemberId(), register));
    }
  }
 
  public void importTagsFromRegister(WsMember member, List<ImporterRegister> data) {
    for(ImporterRegister register : data) {
      AxTag axt = AxTag.from(member.getMemberId(), register);
      Tags.addTag(axt.getEntityRoot() + axt.stringifyId(), axt.getTagName());
    }
  }
 
  public void removeContactsFromMember(WsMember member) {
    SqlClause.delete("AxContact")
            .where().equal("contactId.memberId", member.getMemberId())
            .dao(getDao())
            .execute();
  }
  
  public void removeProjectsFromMember(WsMember member) {
    SqlClause.delete("AxProject")
            .where().equal("projectId.memberId", member.getMemberId())
            .dao(getDao())
            .execute();
  }
  
  public void removeParticipationsFromMember(WsMember member) {
    SqlClause.delete("AxParticipation")
            .where().equal("relation.mainMemberId", member.getMemberId())
            .or().equal("relation.relatedMemberId", member.getMemberId())
            .dao(getDao())
            .execute();
  }
  
  public void removeDescriptorsFromMember(WsMember member) {
    SqlClause.delete("AxDescriptor")
            .where().equal("memberId", member.getMemberId())
            .dao(getDao())
            .execute();
  }
  
  public void removeProjectGrantsFromMember(WsMember member) {
    SqlClause.delete("AxProjectGrant")
            .where().equal("projectGrantId.memberId", member.getMemberId())
            .dao(getDao())
            .execute();
  }
  
  public void removeCentersFromMember(WsMember member) {
    SqlClause.delete("AxCenter")
            .where().equal("centerId.memberId", member.getMemberId())
            .dao(getDao())
            .execute();
  }
  
  public void removeStudentsFromMember(WsMember member) {
    SqlClause.delete("AxStudent")
            .where().equal("studentId.memberId", member.getMemberId())
            .dao(getDao())
            .execute();
  }
  
  public void removeChallengesFromMember(WsMember member) {
    SqlClause.delete("AxChallenge")
            .where().equal("challengeId.memberId", member.getMemberId())
            .dao(getDao())
            .execute();
    SqlClause.delete("AxResponse")
            .where().equal("relation.mainMemberId", member.getMemberId())
            .or().equal("relation.relatedMemberId", member.getMemberId())
            .dao(getDao())
            .execute();
  }
  
  public void removeTagsFromMember(WsMember member) {
    Tags.removeMemberTags(member.getMemberId());
  }
  
  /* Dao */
  
  private Dao _dao;
  
  private Dao getDao() {
    if(_dao == null) {
      _dao = new AlliancePU();
    }
    return _dao;
  }
 
}