Check EDMS File ExistanceΒΆ


You can find these scripts inside the folder pmis/STND_PMIS/test/console/example.
If you want to execute them, you can use the Jython Console from the devtool menu.

filename =>

from import File

serv = Beans.documentService
coreDao = ApplicationContext.get('coreDao')

list = sql('''
select distinct file_seq from comm_attch_file where REG_DATE > sysdate - 10;

if list.size() == 0:
    print 'Nothing found!'

for doc in list:

    param = HashMap()
    param.put('file_seq', str(doc['FILE_SEQ']))

    list = coreDao.getList('core.sql.commAttchFileDetail', param)
    for file in list:
        filepath = PmisConfig.get("edms.PathRoot") + str(file["FILEPATH"])
        f = File( filepath )
        if not f.exists():
            print(u''.join( file["title"] ).encode('utf-8'), doc['doc_id'], doc['DOC_TYPE'], doc['file_seq'], file['REG_DATE'])