-
Notifications
You must be signed in to change notification settings - Fork 9
/
TsvUtils.py
113 lines (93 loc) · 3.73 KB
/
TsvUtils.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
"""
Reading and writing TSV files that are TTL-compatible
CC-BY 2022 Fabian M. Suchanek
"""
import gzip
import os
import sys
import datetime
import evaluator
import Prefixes
TEST=False
# Buffer sizes
kilo=1024
mega=1024*kilo
giga=1024*mega
BUFFER=1*giga
##########################################################################
# Reading lines of a file
##########################################################################
def linesOfFile(file, message=None):
""" Iterator over the lines of a GZ or text file, with progress bar """
if message:
print(message,"...", end="", flush=True)
totalNumberOfDots=60-len(message) if message else 0
coveredSize=0
printedDots=0
fileSize=os.path.getsize(file)
isGZ=file.endswith(".gz")
if isGZ:
fileSize*=20
with (gzip.open(file, mode='rt', encoding='UTF-8') if isGZ else open(file, mode='rt', encoding='UTF-8', buffering=BUFFER)) as input:
for line in input:
coveredSize+=len(line)
while message and (coveredSize / fileSize * totalNumberOfDots > printedDots):
print(".", end="", flush=True)
printedDots+=1
yield line
while message and (coveredSize / (fileSize+1) * totalNumberOfDots > printedDots):
print(".", end="", flush=True)
printedDots+=1
if message:
print("done")
##########################################################################
# TSV files
##########################################################################
def tsvTuples(file, message=None):
""" Iterates over the tuples in a TSV file """
for line in linesOfFile(file, message):
if not line.startswith("#") and not line.startswith("@"):
yield line.rstrip().split("\t")
class TsvFileWriter(object):
""" To be used in a WITH...AS clause to write facts to TSV files"""
def __init__(self, file_name):
self.file_name = file_name
def __enter__(self):
self.file = open(self.file_name, "tw", encoding="utf=8", buffering=BUFFER)
for p in Prefixes.prefixes:
self.file.write("@prefix "+p+": <"+Prefixes.prefixes[p]+"> .\n")
return self
def write(self, *args):
self.writeTuple(args)
def writeTuple(self, args):
for i in range(0,len(args)-1):
self.file.write(args[i] if args[i] else '')
self.file.write("\t")
self.file.write(args[-1] if args[-1] else '')
self.file.write("\n")
def writeFact(self, subject, predicate, object):
self.write(subject, predicate, object, ".")
def __exit__(self, *exceptions):
self.file.close()
##########################################################################
# Timing
##########################################################################
class Timer(object):
""" To be used in a WITH...AS clause to print time"""
def __init__(self, message):
self.startTime=datetime.datetime.now().replace(microsecond=0)
print(message,"...")
print(" Current time:", self.startTime)
def __enter__(self):
return self
def __exit__(self, *exceptions):
currentTime=datetime.datetime.now().replace(microsecond=0)
print(" Current time:", currentTime)
print(f"done ({currentTime-self.startTime})")
if TEST and __name__ == '__main__':
print("Test run of TsvFile...")
with TsvFileWriter("test-data/tsvUtils/test-output.tsv") as out:
for line in tsvTuples("test-data/tsvUtils/test-input.tsv"):
out.writeFact(line[0], line[1], line[2])
print("done")
evaluator.compare("test-data/tsvUtils/test-output.tsv", "test-data/tsvUtils/test-input.tsv")