55d64b9ade73afd06cc3c38be2eaf7ab25007e94
[mediacube.git] /
1 package user.jobengine.server.steps;\r
2 \r
3 import java.io.OutputStream;\r
4 import java.net.InetAddress;\r
5 import java.net.URI;\r
6 import java.util.Calendar;\r
7 import java.util.Date;\r
8 import java.util.List;\r
9 \r
10 import org.apache.commons.lang.StringUtils;\r
11 import org.apache.commons.net.ftp.FTP;\r
12 import org.apache.commons.net.ftp.FTPClient;\r
13 import org.apache.commons.net.ftp.FTPReply;\r
14 import org.apache.logging.log4j.LogManager;\r
15 import org.apache.logging.log4j.Logger;\r
16 import org.apache.logging.log4j.Marker;\r
17 \r
18 import com.ibm.nosql.json.api.BasicDBObject;\r
19 import com.ibm.nosql.json.api.DB;\r
20 import com.ibm.nosql.json.api.DBCollection;\r
21 import com.ibm.nosql.json.api.DBCursor;\r
22 import com.ibm.nosql.json.api.DBObject;\r
23 \r
24 import user.commons.CalendarUtils;\r
25 import user.commons.ListUtils;\r
26 import user.commons.StoreUri;\r
27 import user.commons.nosql.NoSQLUtils;\r
28 import user.commons.octopus.IOctopusAPI;\r
29 import user.commons.octopus.OctopusAPI;\r
30 import user.commons.remotestore.FtpDirectoryLister;\r
31 import user.commons.remotestore.RemoteStoreProtocol;\r
32 import user.jobengine.db.IItemManager;\r
33 import user.jobengine.server.IJobEngine;\r
34 import user.jobengine.server.IJobRuntime;\r
35 import user.jobengine.server.steps.MetadataTypeDetector.MetadataType;\r
36 \r
37 public class CopyForArchiveNEXIOMaterialsStep extends JobStep {\r
38         private static final String SCHEDULED_FORMAT = "yyyy.MM.dd HH:mm";\r
39         private static final Logger logger = LogManager.getLogger();\r
40         private static final String UTF_8 = "utf-8";\r
41         private static final String JSON_EXT = ".json";\r
42         private static final String XML_EXT = ".xml";\r
43         private static final String DURATION = "duration";\r
44         private static final String MXFEXT = ".MXF";\r
45         private static final String NEXIOCLIPS = "nexioclips";\r
46         private static final String LONGNAMEID = "longnameid";\r
47         private static final String ARCHIVEDRUNDOWNS = "archivedrundowns";\r
48         private static final String ID = "id";\r
49         private static final String MEDIATYPE = "Hír bejátszó";\r
50         private OctopusAPI octopusAPI;\r
51         private IItemManager manager;\r
52 \r
53         private DB db;\r
54         private FTPClient sourceFtp;\r
55         private FTPClient targetFtp;\r
56         private StoreUri sourceUri;\r
57         private StoreUri targetUri;\r
58         private int nexioKillDateDays;\r
59         private String nexioAgency;\r
60         private Marker systemMarker;\r
61 \r
62         private int check(int value, String name) {\r
63                 if (value == 0) {\r
64                         logger.error(systemMarker, "A folyamat '{}' bemeneti paramétere 0.", name);\r
65                         throw new NullPointerException(String.format("System is not configured properly, missing '%s' input parameter.", name));\r
66                 }\r
67                 return value;\r
68         }\r
69 \r
70         private String check(String value, String name) {\r
71                 if (value == null) {\r
72                         logger.error(systemMarker, "A folyamat '{}' bemeneti paramétere üres.", name);\r
73                         throw new NullPointerException(String.format("System is not configured properly, missing '%s' input parameter.", name));\r
74                 }\r
75                 return value;\r
76         }\r
77 \r
78         private void copy(RundownArchive rundownArchive) throws Exception {\r
79                 for (StoryArchive storyArchive : rundownArchive.getStoryArchives()) {\r
80                         for (FileArchive fileArchive : storyArchive.getFileArchives()) {\r
81                                 try {\r
82                                         copyFile(fileArchive, rundownArchive, storyArchive);\r
83                                 } catch (Exception e) {\r
84                                         logger.error(systemMarker, "A '{}' clip archiválása sikertelen. A rendszer üzenete: {}", fileArchive.getFileName(), e.getMessage());\r
85                                 }\r
86                         }\r
87                 }\r
88         }\r
89 \r
90         private void copyFile(FileArchive fileArchive, RundownArchive rundownArchive, StoryArchive storyArchive) throws Exception {\r
91                 String origFileName = fileArchive.getFileName();\r
92                 String fileName = String.format("%s-%s", origFileName, rundownArchive.getItemHouseId());\r
93                 String videoFileName = fileName + MXFEXT;\r
94 \r
95                 //A mar letezo mozikat nem archivaljuk le ujra, csak a metaadatot\r
96                 long existingMediaId = ItemManagerExtensions.getExistingRundownMedia(manager, origFileName);\r
97                 if (existingMediaId == 0)\r
98                         transferFile(origFileName + MXFEXT, videoFileName);\r
99                 else\r
100                         transferChunk(videoFileName);\r
101 \r
102                 BasicDBObject metadata = createMetadata(rundownArchive, storyArchive, fileArchive, existingMediaId);\r
103                 transferMetadata(videoFileName, metadata);\r
104                 createSourceKillDateFile(rundownArchive, origFileName);\r
105         }\r
106 \r
107         private BasicDBObject createMetadata(RundownArchive rundownArchive, StoryArchive storyArchive, FileArchive fileArchive, long existingMediaId) {\r
108                 BasicDBObject result = new BasicDBObject();\r
109                 result.put("itemHouseId", rundownArchive.getItemHouseId());\r
110                 result.put("itemTitle", rundownArchive.getItemTitle());\r
111                 result.put("itemDescription", rundownArchive.getItemDesc());\r
112                 result.put("userName", "mediacube");\r
113                 result.put("mediaHouseId", storyArchive.getMediaHouseId());\r
114                 result.put("mediaTitle", storyArchive.getMediaTitle());\r
115                 result.put("mediaDescription", storyArchive.getMediaDesc());\r
116                 result.put("mediaType", MEDIATYPE);\r
117                 result.put("duration", fileArchive.getDuration());\r
118                 result.put("existingMediaId", existingMediaId);\r
119                 return result;\r
120         }\r
121 \r
122         private void createSourceKillDateFile(RundownArchive rundownArchive, String fileName) throws Exception {\r
123                 logger.info("Create killdate/agency for {}", fileName);\r
124                 OutputStream outStream = null;\r
125                 try {\r
126                         sourceFtp = ((FtpDirectoryLister) sourceUri.getLister()).connect();\r
127                         Calendar killDate = CalendarUtils.createCalendar(rundownArchive.getScheduleDate());\r
128                         killDate.add(Calendar.DAY_OF_YEAR, nexioKillDateDays);\r
129                         byte[] killDateFile = EscortFiles.createNEXIOKillDateFile(fileName, killDate.getTime(), null, nexioAgency);\r
130                         outStream = sourceFtp.storeFileStream(fileName + XML_EXT);\r
131                         if (outStream == null) {\r
132                                 throw new NullPointerException("Can not open: " + fileName + XML_EXT + " Reply:" + sourceFtp.getReplyString());\r
133                         }\r
134                         outStream.write(killDateFile);\r
135                         outStream.flush();\r
136                 } catch (Exception e) {\r
137                         logger.catching(e);\r
138                         throw e;\r
139                 } finally {\r
140                         if (outStream != null)\r
141                                 outStream.close();\r
142                         sourceUri.cleanUp();\r
143                 }\r
144         }\r
145 \r
146         @StepEntry\r
147         public Object[] execute(int nexioPort, String nexioUserName, String nexioPassword, String archiveFtp, String archiveUserName, String archivePassword,\r
148                         int daysBeforeNow, int nexioKillDateDays, String nexioAgency, IJobEngine jobEngine, IJobRuntime jobRuntime) throws Exception {\r
149                 systemMarker = jobRuntime.getMarker();\r
150                 setAndCheck(nexioPort, nexioUserName, nexioPassword, archiveFtp, archiveUserName, archivePassword, nexioKillDateDays, nexioAgency, jobEngine);\r
151                 octopusAPI = new OctopusAPI();\r
152                 Calendar scheduledDate = Calendar.getInstance();\r
153                 scheduledDate.add(Calendar.DAY_OF_YEAR, -1 * daysBeforeNow);\r
154                 List<DBObject> rundowns = octopusAPI.getRundowns(scheduledDate.getTime());\r
155                 if (rundowns == null) {\r
156                         logger.warn(systemMarker, "Nem található adástükör a {} napra.", CalendarUtils.toDateString(scheduledDate));\r
157                         return null;\r
158                 }\r
159 \r
160                 processRundowns(rundowns);\r
161                 return null;\r
162         }\r
163 \r
164         //      private String getVersionedFileName(String fileName, String extension) throws Exception {\r
165         //              String result = fileName;\r
166         //              try {\r
167         //                      targetFtp = ((FtpDirectoryLister) targetUri.getLister()).connect();\r
168         //                      FTPFile[] listFiles = targetFtp.listFiles();\r
169         //                      List<String> fileNames = new ArrayList<>();\r
170         //                      for (FTPFile ftpFile : listFiles) {\r
171         //                              fileNames.add(ftpFile.getName());\r
172         //                      }\r
173         //                      while (fileNames.contains(result + extension)) {\r
174         //\r
175         //                      }\r
176         //\r
177         //              } catch (Exception e) {\r
178         //                      logger.catching(e);\r
179         //                      throw e;\r
180         //              } finally {\r
181         //                      targetUri.cleanUp();\r
182         //              }\r
183         //              return result;\r
184         //      }\r
185 \r
186         private FileArchive processMosObject(BasicDBObject rundown, BasicDBObject story, BasicDBObject mosObject) throws Exception {\r
187                 String mosID = mosObject.getString(IOctopusAPI.OBJ_ID);\r
188                 if (MetadataTypeDetector.GuessMetadataType(mosID) != MetadataType.OctopusPlaceholder) {\r
189                         logger.trace("Skipping MOS object {}", mosID);\r
190                         return null;\r
191                 }\r
192                 DBCollection clips = db.getCollection(NEXIOCLIPS);\r
193                 BasicDBObject clip = (BasicDBObject) clips.findOne(new BasicDBObject(LONGNAMEID, mosID));\r
194                 if (clip == null) {\r
195                         logger.debug("File NOT exists: {}", mosID);\r
196                         return null;\r
197                         //throw new Exception(String.format("File NOT exists %s", mosID));\r
198                 } else {\r
199                         logger.debug("File exists: {}", mosID);\r
200                 }\r
201                 long duration = NoSQLUtils.asLong(clip, DURATION);\r
202 \r
203                 if (duration == 0) {\r
204                         logger.debug("File exists with 0 length: {}", mosID);\r
205                         return null;\r
206                 }\r
207                 return new FileArchive(mosID, duration);\r
208         }\r
209 \r
210         private RundownArchive processRundow(DBObject r) throws Exception {\r
211                 BasicDBObject rundown = (BasicDBObject) r;\r
212                 long rundownID = rundown.getLong(ID);\r
213                 logger.info("Processing rundown {} {}", rundownID, rundown.getString(IOctopusAPI.NAME));\r
214                 List<DBObject> stories = octopusAPI.getRundownFullStories(rundownID);\r
215                 if (stories == null)\r
216                         return null;\r
217                 RundownArchive result = new RundownArchive();\r
218 \r
219                 long id = NoSQLUtils.asLong(rundown, IOctopusAPI.ID);\r
220                 if (id == 0)\r
221                         return null;\r
222                 String name = NoSQLUtils.asString(NoSQLUtils.asDBObject(rundown, IOctopusAPI.RUNDOWN_TYPE), IOctopusAPI.NAME);\r
223                 if (StringUtils.isBlank(name))\r
224                         return null;\r
225                 String channel = NoSQLUtils.asString(NoSQLUtils.asDBObject(rundown, IOctopusAPI.CHANNEL), IOctopusAPI.NAME);\r
226                 Date scheduledStart = rundown.getDate(IOctopusAPI.SCHEDULED_START);\r
227                 if (scheduledStart == null)\r
228                         return null;\r
229                 String start = CalendarUtils.toString(CalendarUtils.createCalendar(scheduledStart), SCHEDULED_FORMAT);\r
230                 result.setScheduleDate(scheduledStart);\r
231                 result.setItemHouseId(String.valueOf(id));\r
232                 result.setItemTitle(String.format("%s %s %s", start, name, channel));\r
233 \r
234                 for (DBObject s : stories) {\r
235                         StoryArchive storyArchive = processStory(rundown, s);\r
236                         if (storyArchive == null)\r
237                                 continue;\r
238                         result.addStoryArchive(storyArchive);\r
239                 }\r
240                 return result;\r
241         }\r
242 \r
243         private void processRundowns(List<DBObject> rundowns) {\r
244 \r
245                 //TODO kiveni publikálás előtt\r
246                 //db.getCollection(ARCHIVEDRUNDOWNS).drop();\r
247                 List<BasicDBObject> archivedRundowns = queryArchivedRundowns();\r
248 \r
249                 int index = 1;\r
250 \r
251                 for (DBObject r : rundowns) {\r
252                         BasicDBObject rundown = (BasicDBObject) r;\r
253                         setProgress(index * 100 / rundowns.size());\r
254                         long rundownID = NoSQLUtils.asLong(rundown, IOctopusAPI.ID);\r
255                         String rundownName = NoSQLUtils.asString(rundown, IOctopusAPI.NAME);\r
256                         try {\r
257                                 BasicDBObject currentRundownID = new BasicDBObject(IOctopusAPI.ID, rundownID);\r
258                                 if (archivedRundowns != null && archivedRundowns.contains(currentRundownID)) {\r
259                                         logger.info("Skipping archived rundown {} {}", rundownID, rundownName);\r
260                                         continue;\r
261                                 }\r
262 \r
263                                 RundownArchive rundownArchive = processRundow(r);\r
264                                 if (rundownArchive == null || rundownArchive.isEmpty()) {\r
265                                         logger.info("Skipping rundown {} {}", rundownID, rundownName);\r
266                                         continue;\r
267                                 }\r
268 \r
269                                 logger.info("Saving rundown {} {}", rundownID, rundownName);\r
270                                 copy(rundownArchive);\r
271 \r
272                                 db.getCollection(ARCHIVEDRUNDOWNS).save(currentRundownID);\r
273                         } catch (Exception e) {\r
274                                 logger.catching(e);\r
275                                 logger.error(systemMarker,\r
276                                                 String.format("A %s %s tükör archiválása nem lehetséges, mert a annak ellenőrzése hibát jelzett. A rendszer üzenete: %s", rundownID,\r
277                                                                 rundownName, e.getMessage()));\r
278                         }\r
279                         index++;\r
280                 }\r
281 \r
282         }\r
283 \r
284         private StoryArchive processStory(BasicDBObject rundown, DBObject s) throws Exception {\r
285                 BasicDBObject story = (BasicDBObject) s;\r
286                 String parentStoryID = story.getString(IOctopusAPI.PARENT_STORY_ID);\r
287                 if (StringUtils.isBlank(parentStoryID)) {\r
288                         logger.warn("Story parentStoryID is null: {}", story.toPrettyString(null));\r
289                         return null;\r
290                 } else\r
291                         logger.debug("Processing story {}", parentStoryID);\r
292                 List<BasicDBObject> mosObjects = NoSQLUtils.asList(story, IOctopusAPI.MOS_OBJECTS);\r
293                 if (mosObjects == null)\r
294                         return null;\r
295                 StoryArchive storyArchive = null;\r
296                 for (BasicDBObject mosObject : mosObjects) {\r
297                         FileArchive fileArchive = processMosObject(rundown, story, mosObject);\r
298                         if (fileArchive == null)\r
299                                 continue;\r
300                         if (storyArchive == null) {\r
301                                 storyArchive = new StoryArchive();\r
302                                 storyArchive.setMediaHouseId(parentStoryID);\r
303                                 storyArchive.setMediaTitle(story.getString(IOctopusAPI.NAME));\r
304                                 storyArchive.setMediaDesc(story.getString(IOctopusAPI.SCRIPT_CONTENT));\r
305 \r
306                         }\r
307                         storyArchive.addFileArchive(fileArchive);\r
308                 }\r
309                 return storyArchive;\r
310 \r
311         }\r
312 \r
313         private List<BasicDBObject> queryArchivedRundowns() {\r
314                 List<BasicDBObject> result = null;\r
315                 DBCollection collection = db.getCollection(ARCHIVEDRUNDOWNS);\r
316                 DBCursor find = collection.find(new BasicDBObject(), new BasicDBObject(IOctopusAPI._ID, 0).append(IOctopusAPI.ID, 1));\r
317                 if (find.hasNext())\r
318                         result = ListUtils.cast(find.toArray());\r
319                 return result;\r
320         }\r
321 \r
322         private void setAndCheck(int nexioPort, String nexioUserName, String nexioPassword, String archiveFtp, String archiveUserName, String archivePassword,\r
323                         int nexioKillDateDays, String nexioAgency, IJobEngine jobEngine) throws Exception {\r
324                 db = NoSQLUtils.getNoSQLDB();\r
325                 if (db == null) {\r
326                         logger.error(systemMarker, "Az NoSQL adatkezelő réteg nem elérhető.");\r
327                         throw new NullPointerException("Internal error, missing NoSQL DB reference.");\r
328                 }\r
329 \r
330                 if (jobEngine == null) {\r
331                         logger.error(systemMarker, "Az folyamatkezelő réteg nem elérhető.");\r
332                         throw new NullPointerException("Internal error, missing JobEngine reference.");\r
333                 }\r
334                 manager = jobEngine.getItemManager();\r
335                 if (manager == null) {\r
336                         logger.error(systemMarker, "Az adatbáziskezelő réteg nem elérhető.");\r
337                         throw new NullPointerException("Internal error, missing ItemManager reference.");\r
338                 }\r
339                 String nexioHost = System.getProperty("nexio.host");\r
340                 if (StringUtils.isBlank(nexioHost)) {\r
341                         logger.error(systemMarker, "A 'nexio.host' rendszer paraméter nem található.");\r
342                         throw new NullPointerException("System is not configured properly, 'jobengine.selenio.address' startup parameter missing.");\r
343                 }\r
344                 check(nexioPort, "nexioPort");\r
345                 check(nexioUserName, "nexioUserName");\r
346                 check(nexioPassword, "nexioPassword");\r
347 \r
348                 check(nexioKillDateDays, "nexioKillDateDays");\r
349                 this.nexioKillDateDays = nexioKillDateDays;\r
350                 check(nexioAgency, "nexioAgency");\r
351                 this.nexioAgency = nexioAgency;\r
352 \r
353                 sourceUri = manager.createStoreUri(RemoteStoreProtocol.FTP, nexioHost);\r
354                 sourceUri.setPortNumber(nexioPort);\r
355                 sourceUri.setUserName(nexioUserName);\r
356                 sourceUri.setPassword(nexioPassword);\r
357                 if (sourceUri == null) {\r
358                         logger.error(systemMarker, "A forrás nem elérhető.");\r
359                         throw new NullPointerException("Internal error, missing 'sourceUri'.");\r
360                 }\r
361 \r
362                 check(archiveFtp, "archiveFtp");\r
363                 check(archiveUserName, "archiveUserName");\r
364                 check(archivePassword, "archivePassword");\r
365 \r
366                 targetUri = manager.createStoreUri(new URI(archiveFtp));\r
367                 targetUri.setUserName(archiveUserName);\r
368                 targetUri.setPassword(archivePassword);\r
369                 if (targetUri == null) {\r
370                         logger.error(systemMarker, "A cél nem elérhető.");\r
371                         throw new NullPointerException("Internal error, missing 'targetUri'.");\r
372                 }\r
373 \r
374         }\r
375 \r
376         private void transferChunk(String fileName) throws Exception {\r
377                 logger.info("Transfer chunk {}", fileName);\r
378                 OutputStream outStream = null;\r
379                 try {\r
380                         targetFtp = ((FtpDirectoryLister) targetUri.getLister()).connect();\r
381                         outStream = targetFtp.storeFileStream(fileName);\r
382                         if (outStream == null) {\r
383                                 throw new NullPointerException("Can not open: " + fileName + MXFEXT + " Reply:" + targetFtp.getReplyString());\r
384                         }\r
385                 } catch (Exception e) {\r
386                         logger.catching(e);\r
387                         throw e;\r
388                 } finally {\r
389                         if (outStream != null)\r
390                                 outStream.close();\r
391                         targetUri.cleanUp();\r
392                 }\r
393         }\r
394 \r
395         private void transferFile(String sourceFileName, String targetFileName) throws Exception {\r
396                 int reply = 0;\r
397                 logger.info("Transfer clip {}", sourceFileName);\r
398                 try {\r
399                         sourceFtp = ((FtpDirectoryLister) sourceUri.getLister()).connect();\r
400                         targetFtp = ((FtpDirectoryLister) targetUri.getLister()).connect();\r
401                         if (!targetFtp.enterRemotePassiveMode())\r
402                                 throw new Exception("!PASV");\r
403 \r
404                         reply = sourceFtp.port(InetAddress.getByName(targetFtp.getPassiveHost()), targetFtp.getPassivePort());\r
405                         if (!FTPReply.isPositiveCompletion(reply))\r
406                                 throw new Exception("PORT parancs válasza: " + sourceFtp.getReplyString());\r
407 \r
408                         if (!sourceFtp.setFileType(FTP.BINARY_FILE_TYPE))\r
409                                 throw new Exception("!SOURCE TYPE");\r
410 \r
411                         reply = sourceFtp.retr(sourceFileName);\r
412                         if (!FTPReply.isPositivePreliminary(reply))\r
413                                 throw new Exception("RETR parancs válasza: " + sourceFtp.getReplyString());\r
414 \r
415                         if (!targetFtp.setFileType(FTP.BINARY_FILE_TYPE))\r
416                                 throw new Exception("!TARGET TYPE");\r
417 \r
418                         reply = targetFtp.stor(targetFileName);\r
419                         if (!FTPReply.isPositivePreliminary(reply))\r
420                                 throw new Exception("STOR parancs válasza: " + sourceFtp.getReplyString());\r
421 \r
422                         while (true) {\r
423                                 reply = sourceFtp.stat();\r
424                                 if (!FTPReply.isPositiveCompletion(reply))\r
425                                         throw new Exception("STAT parancs válasza: " + sourceFtp.getReplyString());\r
426 \r
427                                 logger.info("Status: {}", sourceFtp.getReplyString());\r
428                                 if (reply == 226) {\r
429                                         break;\r
430                                 }\r
431                                 Thread.sleep(1000);\r
432                         }\r
433                 } catch (Exception e) {\r
434                         logger.catching(e);\r
435                         throw e;\r
436                 } finally {\r
437                         sourceUri.cleanUp();\r
438                         targetUri.cleanUp();\r
439                 }\r
440 \r
441         }\r
442 \r
443         private void transferMetadata(String fileName, BasicDBObject metadata) throws Exception {\r
444                 logger.info("Transfer metadata {}", fileName);\r
445                 OutputStream outStream = null;\r
446                 try {\r
447                         targetFtp = ((FtpDirectoryLister) targetUri.getLister()).connect();\r
448                         if (!targetFtp.changeWorkingDirectory(EscortFiles.STATUSFOLDER)) {\r
449                                 targetFtp.makeDirectory(EscortFiles.STATUSFOLDER);\r
450                                 if (!targetFtp.changeWorkingDirectory(EscortFiles.STATUSFOLDER))\r
451                                         throw new Exception("!STATUSFOLDER");\r
452                         }\r
453 \r
454                         outStream = targetFtp.storeFileStream(fileName + JSON_EXT);\r
455                         if (outStream == null) {\r
456                                 throw new NullPointerException("Can not open: " + fileName + JSON_EXT + " Reply:" + targetFtp.getReplyString());\r
457                         }\r
458                         outStream.write(metadata.toString().getBytes(UTF_8));\r
459                         outStream.flush();\r
460                         //targetFtp.changeToParentDirectory();\r
461                 } catch (Exception e) {\r
462                         logger.catching(e);\r
463                         throw e;\r
464                 } finally {\r
465                         if (outStream != null)\r
466                                 outStream.close();\r
467                         targetUri.cleanUp();\r
468                 }\r
469         }\r
470 \r
471 }\r