def check_Doc(self, item):
filename = get_file_original_name(item.file)
unit = filename[0:3]
partner = "?"
mat = filename[4]
doctype = filename[6:9]
serial = filename[10:15]
session = db.session
doc = models.Document
document = session.query(doc).filter(doc.unit == unit,
doc.materialclass == mat,
doc.doctype == doctype,
doc.serial == serial).first()
if document:
return document.id
else:
document = doc(unit=unit,
materialclass=mat,
doctype=doctype,
serial=serial,
partner=partner)
session.add(document)
session.flush()
return document.id
def file_name(self):
return get_file_original_name(str(self.dataset_attachment_file))
def filename(self):
return get_file_original_name(self.cs_file)
def file_name(self):
return get_file_original_name(str(self.file))
def file_name(self):
return get_file_original_name(str(self.file))
def file_name(self):
return '<a href="' + url_for('Emelem.download', filename=str(self.file)) + '">' + get_file_original_name(str(self.file)) + '</a>'
def comments(item):
print('file processed:', str(item.file))
file = open(UPLOAD_FOLDER + item.file, mode='rb')
print('file processed:', file)
#file = open('/Users/dp/py3/saybapco/saybapco/comments/019-C-GAD-10010-001-RAP-CS REPLY.xlsx', mode='rb')
#filename = '019-C-GAD-10010-001-RAP-CS REPLY.xlsx'
filename = get_file_original_name(item.file)
unit = filename[0:3]
#partner = filename[4]
mat = filename[4]
doctype = filename[6:9]
serial = filename[10:15]
wb = openpyxl.load_workbook(file)
ws = wb.active
session = db.session
comments = models.Comments
session.query(comments).filter(
comments.document_id == item.document_id).delete()
#session.commit()
for row in ws.iter_rows(min_row=2):
if row[3].value is not None:
try:
print(filename)
print(' ')
print(unit, mat, doctype, serial)
#print(row[2].value)
#print(sanetext(row[3].value))
style = sanetext(row[1].value)
author = sanetext(row[2].value)
comment = sanetext(row[3].value)
reply = sanetext(row[4].value)
included = sanetext(row[5].value)
closed = sanetext(row[6].value)
print(style, author)
print(comment)
print(reply)
print(included, closed)
if closed == 'Y':
closed = True
else:
closed = False
if included == 'Y':
included = True
else:
included = False
comm = comments(style=style,
author=author,
comment=comment,
reply=reply,
included=included,
closed=closed,
document_id=item.document_id,
revision_id=item.id)
session.add(comm)
except:
print('something is None')
pass
session.commit()
return 'done'
def image_name(self):
return get_file_original_name(str(self.image))
def file_name(self):
if self.file is None:
return ""
return get_file_original_name(str(self.file))