Exemplo n.º 1
0
  /**
   * Da der Export eines einzelnen Events besondere Handlungen erfordert, gibt es diese Methode.
   * Hinweis: zum Exportieren von Event-Listen ist diese Methode nicht geeignet, verwende exportTo()
   * stattdessen.
   *
   * <p>Es muessen folgende Daten exportiert werden: - Name des Events - Daten des Betreuers - Daten
   * jedes einzelnen Studenten (Teilnehmer) - Projekte - Termine
   *
   * @param fileName
   * @param data
   * @return
   */
  public static boolean exportEventTo(String fileName, Event event) {
    try {
      Database db = Workspace.getInstance().getDatabase();

      // Oeffne Datei zum Schreiben
      PrintWriter out = new PrintWriter(new OutputStreamWriter(new FileOutputStream(fileName)));

      // Allgemeine Infos des Events
      out.println("Veranstaltung " + event.getName());
      out.println(event.getDesc());
      out.println(event.getID());
      out.println();

      // Daten des Eventbetreuers
      out.println("Betreuer");
      out.print(event.getTutor().getID() + ", ");
      out.print(event.getTutor().getLastName() + ", ");
      out.print(event.getTutor().getFirstName());
      out.println();
      out.println();

      // Gruppen
      out.println("Gruppen");
      out.println("Gruppen-Nr., Beschreibung");
      ArrayList<Group> groups = db.getGroupsInEvent(event.getID());
      for (Group g : groups) {
        out.print(g.getID() + ",");
        out.print(g.getDesc().replace(",", "\\0x2C")); // Kommas ersetzen um csv zu sichern
        out.println();
      }
      out.println();

      // Teilnehmer
      out.println("Studenten");
      out.println("Matrikelnummer, Name, Vorname, Email, Gruppen-Nummer");
      ArrayList<Student> stds = db.getStudentsInEvent(event.getID());
      for (Student std : stds) {
        out.print(std.getMatNr() + ", ");
        out.print(std.getLastName() + ", ");
        out.print(std.getFirstName() + ", ");
        out.print(std.getEmail() + ",");
        Group eventGroup = db.getEventGroup(std, event.getID());
        out.print(eventGroup == null ? 0 : eventGroup.getID());
        out.println();
      }
      out.println();

      // Projekte der Veranstaltung
      out.println("Projekte");
      out.println("ID, Beschreibung, Start, Ende");
      ArrayList<Integer> pids = db.getProjectsInEvent(event.getID());

      for (int pid : pids) {
        String desc = db.getProjectDesc(pid).replace(",", "\\0x2C");
        Timestamp start = db.getProjectDate(pid);
        Timestamp end = db.getProjectDeadline(pid);
        if (end == null) end = new Timestamp(Long.MAX_VALUE);

        out.print(pid + ",");
        out.print(desc + ",");
        out.print(start.getTime() + ",");
        out.print(end.getTime());
        out.println();
      }
      out.println();

      // Noten fuer die Projekte
      out.println("Benotung");
      out.println("Projekt-ID, Matrikel-Nr., Note");

      for (Student std : stds) {
        ArrayList<ArrayList<Object>> notenInfo = db.getResults(std, "ProjectID");
        for (ArrayList<Object> o : notenInfo) {
          out.print(o.get(0) + ",");
          out.print(std.getMatNr() + ",");
          out.print(((String) o.get(2)).replace(",", "\\0x2C"));
          out.println();
        }
      }
      out.println();

      // Termine der Veranstaltung
      out.println("Termine");
      out.println("ID, Datum");
      ArrayList<Term> terms = db.getTermsInEvent(event.getID());

      for (Term term : terms) {
        out.print(term.getTermID() + ",");
        out.print(term.getDate().getTime());
        out.println();
      }
      out.println();

      // Datei abschliessen
      out.flush();
      out.close();

      return true;
    } catch (Exception e) {
      e.printStackTrace();
      return false;
    }
  }
Exemplo n.º 2
0
  /**
   * Importiert ein Event aus einer CSV-Datei.
   *
   * @param fileName
   * @return
   */
  public static Event importEventFrom(String fileName) {
    try {
      Database db = Workspace.getInstance().getDatabase();
      Event event = new Event();
      BufferedReader in = new BufferedReader(new InputStreamReader(new FileInputStream(fileName)));

      String line = in.readLine();
      if (!line.startsWith("Veranstaltung ")) return null;

      // Lese Name der Veranstaltung
      line = line.substring("Veranstaltung ".length());
      event.setName(line);

      // Lese Beschreibung
      line = in.readLine();
      event.setDesc(line);

      // Lese Event ID
      line = in.readLine();
      event.setID(Integer.parseInt(line.trim()));

      in.readLine(); // Ueberspringen

      // Lese Betreuer
      line = in.readLine();
      if (!line.equals("Betreuer")) return null;

      line = in.readLine();
      String[] lines = line.split(",");
      int id = Integer.parseInt(lines[0].trim());
      String lastName = lines[1].trim();
      String firstName = lines[2].trim();
      Tutor tutor = new Tutor(id, lastName, firstName);

      event.setTutor(tutor);
      in.readLine();

      // Event in die Datenbank schreiben.
      // Dies ist hier schon notwendig, da Term darauf verweist.
      Event oldEvent = Workspace.getInstance().getDatabase().getEvent(event.getID());
      if (oldEvent != null) {
        if (oldEvent.equals(event)) Workspace.getInstance().getDatabase().updateEvent(event);
        else {
          do event.setID(event.getID() + 1);
          while (Workspace.getInstance().getDatabase().getEvent(event.getID()) != null);
          Workspace.getInstance().getDatabase().addEvent(event);
        }
      } else Workspace.getInstance().getDatabase().addEvent(event);

      // Gruppen
      line = in.readLine();
      if (!line.equals("Gruppen")) return null;
      line = in.readLine(); // Spaltenueberschriften
      ArrayList<Group> groups = new ArrayList<Group>();
      for (; ; ) {
        line = in.readLine();
        if (line == null || line.equals("")) break;

        lines = line.split(","); // Gruppen-ID, Beschreibung
        groups.add(new Group(Integer.parseInt(lines[0]), lines[1].replace("\\0x2C", ",")));
      }

      // Teilnehmer
      line = in.readLine();
      if (!line.equals("Studenten")) return null;
      line = in.readLine(); // Spaltenueberschriften
      ArrayList<Student> students = new ArrayList<Student>();
      ArrayList<ArrayList<Integer>> studToGroup = new ArrayList<ArrayList<Integer>>();
      for (; ; ) {
        line = in.readLine();
        if (line == null || line.equals("")) break;

        lines = line.split(","); // Matrikelnummer, Name, Vorname, Email
        int matNr = Integer.parseInt(lines[0].trim());
        String name = lines[1].trim();
        String fname = lines[2].trim();
        String email = lines[3].trim();
        int gruppe = Integer.parseInt(lines[4].trim());

        students.add(new Student(name, fname, matNr, email));
        // Gruppenzuordnung
        ArrayList<Integer> innerStudToGroup = new ArrayList<Integer>();
        innerStudToGroup.add(matNr);
        innerStudToGroup.add(gruppe);

        studToGroup.add(innerStudToGroup);
      }

      // Projekte einlesen
      line = in.readLine();
      if (!line.equals("Projekte")) return null;
      line = in.readLine(); // ID, Beschreibung, Start, Ende

      ArrayList<Project> projects = new ArrayList<Project>();

      for (; ; ) {
        line = in.readLine();
        if (line == null || line.equals("")) break;

        lines = line.split(",");
        int pid = Integer.parseInt(lines[0].trim());
        String desc = lines[1].trim().replace("\\0x2C", ",");
        Timestamp start = new Timestamp(Long.parseLong(lines[2].trim()));
        Timestamp end = new Timestamp(Long.parseLong(lines[3].trim()));

        // Projekte muessen gespeichert werden, da eventuell
        // das Projekt noch nicht angelegt wurde
        projects.add(new Project(pid, desc, start, end));
      }

      // Benotung einlesen
      line = in.readLine();
      if (!line.equals("Benotung")) return null;
      line = in.readLine(); // Projekt-ID, Matrikel-Nr., Note

      ArrayList<ArrayList<Object>> results = new ArrayList<ArrayList<Object>>();

      for (; ; ) {
        line = in.readLine();
        if (line == null || line.equals("")) break;

        lines = line.split(",");

        ArrayList<Object> innerResults = new ArrayList<Object>();

        innerResults.add(Integer.parseInt(lines[0].trim())); // ProjectID
        innerResults.add(Integer.parseInt(lines[1].trim())); // Matr-Nr.
        innerResults.add(lines[2].trim().replace("\\0x2C", ",")); // Result

        results.add(innerResults);
      }

      // Termine einlesen
      line = in.readLine();
      if (!line.equals("Termine")) return null;
      line = in.readLine(); // Datum

      ArrayList<Term> terms = new ArrayList<Term>();

      for (; ; ) {
        line = in.readLine();
        if (line == null || line.equals("")) break;

        lines = line.split(",");
        terms.add(
            new Term(
                Integer.parseInt(lines[0].trim()),
                event.getID(),
                new Timestamp(Long.parseLong(lines[1].trim()))));
      }

      // Aenderungen in die Datenbank uebernehmen
      // Tutor
      Tutor oldTutor = Workspace.getInstance().getDatabase().getTutor(event.getTutor().getID());
      if (oldTutor != null) {
        if (oldTutor.equals(event.getTutor()))
          Workspace.getInstance().getDatabase().updateTutor(event.getTutor());
        else {
          do event.getTutor().setID(event.getTutor().getID() + 1);
          while (Workspace.getInstance().getDatabase().getTutor(event.getTutor().getID()) != null);
        }
      } else Workspace.getInstance().getDatabase().addTutor(event.getTutor());

      // Teilnehmer
      for (Student std : students) {
        try {
          db.addStudent(std);
        } catch (SQLException e) {
          System.out.println("Student " + std + " schon vorhanden.");
        }
        db.addStudentToEvent(std, event);
      }

      // Gruppen
      for (Group g : groups) {
        g.insertInEvent(event.getID());

        // Gruppenzuordnung
        for (ArrayList<Integer> innerStudToGroup : studToGroup) {
          int gNr = innerStudToGroup.get(1);
          if (g.getID() == gNr) g.add(db.getStudent(innerStudToGroup.get(0)));
        }
      }

      // Projekte
      for (Project p : projects) {
        try {
          db.addProjectToEvent(p, event);
        } catch (SQLException e) {
          // e.printStackTrace();
          e.printStackTrace();
          System.out.println("Projekt " + p.getDescription() + " existiert schon!");
        }
      }

      // Benotung
      for (ArrayList<Object> res : results) {
        try {
          int mNr = (Integer) res.get(1);
          int pID = (Integer) res.get(0);
          Student stud = null;

          for (Student st : students) {
            if (st.getMatNr() == mNr) stud = st;
          }
          if (stud != null) {
            db.addStudentToProject(stud, pID);
            db.setMark(mNr, pID, (String) res.get(2));
          }
          stud = null;
        } catch (SQLException e) {
          // setMark macht ein automatisches Update, falls Insert fehlschlaegt
          // Jegliche Exception muss also ein echter Datenbankfehler sein!
          e.printStackTrace();
        }
      }

      // Termine
      for (Term term : terms) {
        try {
          db.addTermToEvent(term, event);
        } catch (SQLException e) {
          System.out.println("Termin existiert schon!");
        }
      }

      // Workspace-Tree updaten
      Workspace.getInstance().updateTree("");

      return event;
    } catch (Exception e) {
      e.printStackTrace();
      return null;
    }
  }