-
Notifications
You must be signed in to change notification settings - Fork 0
/
backdate_for_test.py
39 lines (31 loc) · 1.21 KB
/
backdate_for_test.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
from pathlib import Path
import re
def get_files(extensions):
all_files = []
for ext in extensions:
all_files.extend(Path.cwd().glob(ext))
return(all_files)
def loop_through_axvw_and_js(prod_dir, to_replace, replace_with):
file_paths = get_files(['*.axvw', '*.js'])
for file_path in file_paths:
print(file_path.name)
with open(file_path, "r") as f:
axvw_text = f.read()
prod_text = re.sub(to_replace, replace_with, axvw_text)
with open(prod_dir / file_path.name, "w") as f:
f.write(prod_text)
return
def loop_through_axvw(prod_dir, to_replace, replace_with):
for file_path in prod_dir.glob('*.axvw'):
print(file_path.name)
with open(file_path, "r") as f:
axvw_text = f.read()
# print(axvw_text[0:20])
prod_text = re.sub(to_replace, replace_with, axvw_text)
with open(prod_dir / file_path.name, "w") as f:
f.write(prod_text)
if __name__ == '__main__':
prod_dir = Path.cwd() / "kpis_dashboard"
to_replace = re.escape("DateAdd(year, -2, getDate())")
replace_with = r"DateAdd(month, -1, getDate())"
loop_through_axvw(prod_dir, to_replace, replace_with)