diff options
| -rw-r--r-- | tools/koblingsplan/.gitignore | 1 | ||||
| -rw-r--r-- | tools/koblingsplan/README.adoc | 13 | ||||
| -rw-r--r-- | tools/koblingsplan/poetry.lock | 56 | ||||
| -rw-r--r-- | tools/koblingsplan/pyproject.toml | 16 | ||||
| -rw-r--r-- | tools/koblingsplan/script.py | 47 |
5 files changed, 133 insertions, 0 deletions
diff --git a/tools/koblingsplan/.gitignore b/tools/koblingsplan/.gitignore new file mode 100644 index 0000000..4f694a9 --- /dev/null +++ b/tools/koblingsplan/.gitignore @@ -0,0 +1 @@ +tg23-koblingsplan.csv diff --git a/tools/koblingsplan/README.adoc b/tools/koblingsplan/README.adoc new file mode 100644 index 0000000..cf7d54e --- /dev/null +++ b/tools/koblingsplan/README.adoc @@ -0,0 +1,13 @@ += Koblingsplan + +Stjal scriptet til Jonas fra Confluence og la det her. + +== Usage + +Depdencies are stored in `pyproject.toml` and can be used with e.g. poetry: + +Install dependencies: `poetry install` + +Run the script: `poetry run python script.py` + +or `poetry shell` to have a configured shell you can run python from. diff --git a/tools/koblingsplan/poetry.lock b/tools/koblingsplan/poetry.lock new file mode 100644 index 0000000..c375431 --- /dev/null +++ b/tools/koblingsplan/poetry.lock @@ -0,0 +1,56 @@ +# This file is automatically @generated by Poetry and should not be changed by hand. + +[[package]] +name = "pyyaml" +version = "6.0" +description = "YAML parser and emitter for Python" +category = "main" +optional = false +python-versions = ">=3.6" +files = [ + {file = "PyYAML-6.0-cp310-cp310-macosx_10_9_x86_64.whl", hash = "sha256:d4db7c7aef085872ef65a8fd7d6d09a14ae91f691dec3e87ee5ee0539d516f53"}, + {file = "PyYAML-6.0-cp310-cp310-macosx_11_0_arm64.whl", hash = "sha256:9df7ed3b3d2e0ecfe09e14741b857df43adb5a3ddadc919a2d94fbdf78fea53c"}, + {file = "PyYAML-6.0-cp310-cp310-manylinux_2_17_aarch64.manylinux2014_aarch64.whl", hash = "sha256:77f396e6ef4c73fdc33a9157446466f1cff553d979bd00ecb64385760c6babdc"}, + {file = "PyYAML-6.0-cp310-cp310-manylinux_2_17_s390x.manylinux2014_s390x.whl", hash = "sha256:a80a78046a72361de73f8f395f1f1e49f956c6be882eed58505a15f3e430962b"}, + {file = "PyYAML-6.0-cp310-cp310-manylinux_2_5_x86_64.manylinux1_x86_64.manylinux_2_12_x86_64.manylinux2010_x86_64.whl", hash = "sha256:f84fbc98b019fef2ee9a1cb3ce93e3187a6df0b2538a651bfb890254ba9f90b5"}, + {file = "PyYAML-6.0-cp310-cp310-win32.whl", hash = "sha256:2cd5df3de48857ed0544b34e2d40e9fac445930039f3cfe4bcc592a1f836d513"}, + {file = "PyYAML-6.0-cp310-cp310-win_amd64.whl", hash = "sha256:daf496c58a8c52083df09b80c860005194014c3698698d1a57cbcfa182142a3a"}, + {file = "PyYAML-6.0-cp311-cp311-macosx_10_9_x86_64.whl", hash = "sha256:d4b0ba9512519522b118090257be113b9468d804b19d63c71dbcf4a48fa32358"}, + {file = "PyYAML-6.0-cp311-cp311-macosx_11_0_arm64.whl", hash = "sha256:81957921f441d50af23654aa6c5e5eaf9b06aba7f0a19c18a538dc7ef291c5a1"}, + {file = "PyYAML-6.0-cp311-cp311-manylinux_2_17_aarch64.manylinux2014_aarch64.whl", hash = "sha256:afa17f5bc4d1b10afd4466fd3a44dc0e245382deca5b3c353d8b757f9e3ecb8d"}, + {file = "PyYAML-6.0-cp311-cp311-manylinux_2_17_s390x.manylinux2014_s390x.whl", hash = "sha256:dbad0e9d368bb989f4515da330b88a057617d16b6a8245084f1b05400f24609f"}, + {file = "PyYAML-6.0-cp311-cp311-manylinux_2_17_x86_64.manylinux2014_x86_64.whl", hash = "sha256:432557aa2c09802be39460360ddffd48156e30721f5e8d917f01d31694216782"}, + {file = "PyYAML-6.0-cp311-cp311-win32.whl", hash = "sha256:bfaef573a63ba8923503d27530362590ff4f576c626d86a9fed95822a8255fd7"}, + {file = "PyYAML-6.0-cp311-cp311-win_amd64.whl", hash = "sha256:01b45c0191e6d66c470b6cf1b9531a771a83c1c4208272ead47a3ae4f2f603bf"}, + {file = "PyYAML-6.0-cp36-cp36m-macosx_10_9_x86_64.whl", hash = "sha256:897b80890765f037df3403d22bab41627ca8811ae55e9a722fd0392850ec4d86"}, + {file = "PyYAML-6.0-cp36-cp36m-manylinux_2_17_aarch64.manylinux2014_aarch64.whl", hash = "sha256:50602afada6d6cbfad699b0c7bb50d5ccffa7e46a3d738092afddc1f9758427f"}, + {file = "PyYAML-6.0-cp36-cp36m-manylinux_2_17_s390x.manylinux2014_s390x.whl", hash = "sha256:48c346915c114f5fdb3ead70312bd042a953a8ce5c7106d5bfb1a5254e47da92"}, + {file = "PyYAML-6.0-cp36-cp36m-manylinux_2_5_x86_64.manylinux1_x86_64.manylinux_2_12_x86_64.manylinux2010_x86_64.whl", hash = "sha256:98c4d36e99714e55cfbaaee6dd5badbc9a1ec339ebfc3b1f52e293aee6bb71a4"}, + {file = "PyYAML-6.0-cp36-cp36m-win32.whl", hash = "sha256:0283c35a6a9fbf047493e3a0ce8d79ef5030852c51e9d911a27badfde0605293"}, + {file = "PyYAML-6.0-cp36-cp36m-win_amd64.whl", hash = "sha256:07751360502caac1c067a8132d150cf3d61339af5691fe9e87803040dbc5db57"}, + {file = "PyYAML-6.0-cp37-cp37m-macosx_10_9_x86_64.whl", hash = "sha256:819b3830a1543db06c4d4b865e70ded25be52a2e0631ccd2f6a47a2822f2fd7c"}, + {file = "PyYAML-6.0-cp37-cp37m-manylinux_2_17_aarch64.manylinux2014_aarch64.whl", hash = "sha256:473f9edb243cb1935ab5a084eb238d842fb8f404ed2193a915d1784b5a6b5fc0"}, + {file = "PyYAML-6.0-cp37-cp37m-manylinux_2_17_s390x.manylinux2014_s390x.whl", hash = "sha256:0ce82d761c532fe4ec3f87fc45688bdd3a4c1dc5e0b4a19814b9009a29baefd4"}, + {file = "PyYAML-6.0-cp37-cp37m-manylinux_2_5_x86_64.manylinux1_x86_64.manylinux_2_12_x86_64.manylinux2010_x86_64.whl", hash = "sha256:231710d57adfd809ef5d34183b8ed1eeae3f76459c18fb4a0b373ad56bedcdd9"}, + {file = "PyYAML-6.0-cp37-cp37m-win32.whl", hash = "sha256:c5687b8d43cf58545ade1fe3e055f70eac7a5a1a0bf42824308d868289a95737"}, + {file = "PyYAML-6.0-cp37-cp37m-win_amd64.whl", hash = "sha256:d15a181d1ecd0d4270dc32edb46f7cb7733c7c508857278d3d378d14d606db2d"}, + {file = "PyYAML-6.0-cp38-cp38-macosx_10_9_x86_64.whl", hash = "sha256:0b4624f379dab24d3725ffde76559cff63d9ec94e1736b556dacdfebe5ab6d4b"}, + {file = "PyYAML-6.0-cp38-cp38-manylinux_2_17_aarch64.manylinux2014_aarch64.whl", hash = "sha256:213c60cd50106436cc818accf5baa1aba61c0189ff610f64f4a3e8c6726218ba"}, + {file = "PyYAML-6.0-cp38-cp38-manylinux_2_17_s390x.manylinux2014_s390x.whl", hash = "sha256:9fa600030013c4de8165339db93d182b9431076eb98eb40ee068700c9c813e34"}, + {file = "PyYAML-6.0-cp38-cp38-manylinux_2_5_x86_64.manylinux1_x86_64.manylinux_2_12_x86_64.manylinux2010_x86_64.whl", hash = "sha256:277a0ef2981ca40581a47093e9e2d13b3f1fbbeffae064c1d21bfceba2030287"}, + {file = "PyYAML-6.0-cp38-cp38-win32.whl", hash = "sha256:d4eccecf9adf6fbcc6861a38015c2a64f38b9d94838ac1810a9023a0609e1b78"}, + {file = "PyYAML-6.0-cp38-cp38-win_amd64.whl", hash = "sha256:1e4747bc279b4f613a09eb64bba2ba602d8a6664c6ce6396a4d0cd413a50ce07"}, + {file = "PyYAML-6.0-cp39-cp39-macosx_10_9_x86_64.whl", hash = "sha256:055d937d65826939cb044fc8c9b08889e8c743fdc6a32b33e2390f66013e449b"}, + {file = "PyYAML-6.0-cp39-cp39-macosx_11_0_arm64.whl", hash = "sha256:e61ceaab6f49fb8bdfaa0f92c4b57bcfbea54c09277b1b4f7ac376bfb7a7c174"}, + {file = "PyYAML-6.0-cp39-cp39-manylinux_2_17_aarch64.manylinux2014_aarch64.whl", hash = "sha256:d67d839ede4ed1b28a4e8909735fc992a923cdb84e618544973d7dfc71540803"}, + {file = "PyYAML-6.0-cp39-cp39-manylinux_2_17_s390x.manylinux2014_s390x.whl", hash = "sha256:cba8c411ef271aa037d7357a2bc8f9ee8b58b9965831d9e51baf703280dc73d3"}, + {file = "PyYAML-6.0-cp39-cp39-manylinux_2_5_x86_64.manylinux1_x86_64.manylinux_2_12_x86_64.manylinux2010_x86_64.whl", hash = "sha256:40527857252b61eacd1d9af500c3337ba8deb8fc298940291486c465c8b46ec0"}, + {file = "PyYAML-6.0-cp39-cp39-win32.whl", hash = "sha256:b5b9eccad747aabaaffbc6064800670f0c297e52c12754eb1d976c57e4f74dcb"}, + {file = "PyYAML-6.0-cp39-cp39-win_amd64.whl", hash = "sha256:b3d267842bf12586ba6c734f89d1f5b871df0273157918b0ccefa29deb05c21c"}, + {file = "PyYAML-6.0.tar.gz", hash = "sha256:68fb519c14306fec9720a2a5b45bc9f0c8d1b9c72adf45c37baedfcd949c35a2"}, +] + +[metadata] +lock-version = "2.0" +python-versions = "^3.11" +content-hash = "849e6d6d7360f5ed35d66cb6fb3bd11ec904da8b76a61511a183d6a2e01a153b" diff --git a/tools/koblingsplan/pyproject.toml b/tools/koblingsplan/pyproject.toml new file mode 100644 index 0000000..7304a8a --- /dev/null +++ b/tools/koblingsplan/pyproject.toml @@ -0,0 +1,16 @@ +[tool.poetry] +name = "tg-cabling" +version = "0.1.0" +description = "" +authors = ["Håkon Solbjørg <hakon@solbj.org>"] +readme = "README.md" +packages = [{include = "tg_cabling"}] + +[tool.poetry.dependencies] +python = "^3.11" +pyyaml = "^6.0" + + +[build-system] +requires = ["poetry-core"] +build-backend = "poetry.core.masonry.api" diff --git a/tools/koblingsplan/script.py b/tools/koblingsplan/script.py new file mode 100644 index 0000000..3c4fa4b --- /dev/null +++ b/tools/koblingsplan/script.py @@ -0,0 +1,47 @@ +#!/usr/bin/env python3 + +''' + Parse the exported table of tg23-koblingsplan (copypaste via libreoffice -> save as csv (standard values everywhere)) into a sensible yaml file + Will handle merged cells (e.g. keep previous iterations value if current iteration is empty) +''' + +import csv +import yaml + +with open('tg23-koblingsplan.csv', newline='') as csvfile: + csv_data = csv.reader(csvfile, delimiter=',', quotechar='"') + + # for loop counter + i = 0 + + # Holds the data from the current iteration + current_iteration = {} + + # Holds all data. List of objects, each object represents a row in the table + dataset = [] + + for row in csv_data: + i += 1 + # skip first 2 lines, they only contain table headers + if i <= 2: + continue + + # To be able to access previous iteration fields, so we can handle merged cells + prev_iteration = current_iteration.copy() + + # The not-so-delicate blob of code for assigning data to object keys + current_iteration = {} + current_iteration['a_type'] = row[0] if len(row[0].strip()) > 0 else prev_iteration['a_type'] + current_iteration['a_model'] = row[1] if len(row[1].strip()) > 0 else prev_iteration['a_model'] + current_iteration['a_node'] = row[2] if len(row[2].strip()) > 0 else prev_iteration['a_node'] + current_iteration['a_interface'] = row[3] if len(row[3].strip()) > 0 else prev_iteration['a_interface'] + current_iteration['a_ae'] = row[4] if len(row[4].strip()) > 0 else prev_iteration['a_ae'] + current_iteration['b_type'] = row[5] if len(row[5].strip()) > 0 else prev_iteration['b_type'] + current_iteration['b_model'] = row[6] if len(row[6].strip()) > 0 else prev_iteration['b_model'] + current_iteration['b_node'] = row[7] if len(row[7].strip()) > 0 else prev_iteration['b_node'] + current_iteration['b_interface'] = row[8] if len(row[8].strip()) > 0 else prev_iteration['b_interface'] + current_iteration['b_ae'] = row[9] if len(row[9].strip()) > 0 else prev_iteration['b_ae'] + current_iteration['cable_type'] = row[10] if len(row[10].strip()) > 0 else prev_iteration['cable_type'] + dataset.append(current_iteration) + + print(yaml.dump(dataset, default_flow_style=False, sort_keys=False)) |