diff options
author | Sunil Shetye | 2021-09-09 19:36:46 +0530 |
---|---|---|
committer | Sunil Shetye | 2021-10-01 11:37:01 +0530 |
commit | d31883516907754e1ff5f4851f9195054b3135e0 (patch) | |
tree | 4cb0ef6d7f1d1e0c6e240201dcdb7ae9a02c9d89 | |
parent | 30d1ee4d017d6a26d3d303b81e4286360bce0a5d (diff) | |
download | Common-Interface-Project-d31883516907754e1ff5f4851f9195054b3135e0.tar.gz Common-Interface-Project-d31883516907754e1ff5f4851f9195054b3135e0.tar.bz2 Common-Interface-Project-d31883516907754e1ff5f4851f9195054b3135e0.zip |
rename .csv as .tsv
-rw-r--r-- | data/blockprefixes.tsv (renamed from data/blockprefixes.csv) | 0 | ||||
-rw-r--r-- | data/blocks-ports.tsv (renamed from data/blocks-ports.csv) | 0 | ||||
-rw-r--r-- | data/categories-blocks.tsv (renamed from data/categories-blocks.csv) | 0 | ||||
-rw-r--r-- | data/categories.tsv (renamed from data/categories.csv) | 0 | ||||
-rw-r--r-- | data/datatypes.tsv (renamed from data/datatypes.csv) | 0 | ||||
-rw-r--r-- | data/getsize.tsv (renamed from data/getsize.csv) | 0 | ||||
-rw-r--r-- | data/main-category-blocks.tsv (renamed from data/main-category-blocks.csv) | 0 | ||||
-rw-r--r-- | inittable.sql | 18 | ||||
-rw-r--r-- | scripts/blocks-ports-old.tsv (renamed from scripts/blocks-ports-old.csv) | 0 | ||||
-rw-r--r-- | scripts/data-categories-blocks.tsv (renamed from scripts/data-categories-blocks.csv) | 0 | ||||
-rwxr-xr-x | scripts/pinscript.awk | 4 | ||||
-rwxr-xr-x | scripts/pinscript.sh | 2 | ||||
-rwxr-xr-x | scripts/unique.awk | 4 | ||||
-rwxr-xr-x | scripts/unique.sh | 2 |
14 files changed, 15 insertions, 15 deletions
diff --git a/data/blockprefixes.csv b/data/blockprefixes.tsv index b56ff061..b56ff061 100644 --- a/data/blockprefixes.csv +++ b/data/blockprefixes.tsv diff --git a/data/blocks-ports.csv b/data/blocks-ports.tsv index 12976639..12976639 100644 --- a/data/blocks-ports.csv +++ b/data/blocks-ports.tsv diff --git a/data/categories-blocks.csv b/data/categories-blocks.tsv index 11852fb4..11852fb4 100644 --- a/data/categories-blocks.csv +++ b/data/categories-blocks.tsv diff --git a/data/categories.csv b/data/categories.tsv index 7abba9f8..7abba9f8 100644 --- a/data/categories.csv +++ b/data/categories.tsv diff --git a/data/datatypes.csv b/data/datatypes.tsv index 27fcfc6c..27fcfc6c 100644 --- a/data/datatypes.csv +++ b/data/datatypes.tsv diff --git a/data/getsize.csv b/data/getsize.tsv index e715a800..e715a800 100644 --- a/data/getsize.csv +++ b/data/getsize.tsv diff --git a/data/main-category-blocks.csv b/data/main-category-blocks.tsv index 98aaca7b..98aaca7b 100644 --- a/data/main-category-blocks.csv +++ b/data/main-category-blocks.tsv diff --git a/inittable.sql b/inittable.sql index 0b316d1a..9b8d7966 100644 --- a/inittable.sql +++ b/inittable.sql @@ -24,20 +24,20 @@ INSERT INTO xcosblocks_blocktype (name) VALUES (@blocktype_name); SELECT id INTO @blocktype_id FROM xcosblocks_blocktype WHERE name = @blocktype_name; -LOAD DATA LOCAL INFILE 'data/datatypes.csv' +LOAD DATA LOCAL INFILE 'data/datatypes.tsv' INTO TABLE xcosblocks_parameterdatatype FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n' (id, name, @tmp1); -LOAD DATA LOCAL INFILE 'data/categories.csv' +LOAD DATA LOCAL INFILE 'data/categories.tsv' INTO TABLE xcosblocks_category FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n' (id, name, sort_order, @tmp1) SET blocktype_id = @blocktype_id; -LOAD DATA LOCAL INFILE 'data/blockprefixes.csv' +LOAD DATA LOCAL INFILE 'data/blockprefixes.tsv' INTO TABLE xcosblocks_blockprefix FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n' @@ -85,7 +85,7 @@ LOAD DATA LOCAL INFILE 'data/blockprefixes.csv' @p040_key, @p040, @p040_type, p040_value_initial, @p041_key, @p041, @p041_type, p041_value_initial); -LOAD DATA LOCAL INFILE 'data/blockprefixes.csv' +LOAD DATA LOCAL INFILE 'data/blockprefixes.tsv' INTO TABLE xcosblocks_blockprefixparameter FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n' @@ -176,7 +176,7 @@ LOAD DATA LOCAL INFILE 'data/blockprefixes.csv' p040_type_id = (SELECT id FROM xcosblocks_parameterdatatype WHERE name = @p040_type), p041_type_id = (SELECT id FROM xcosblocks_parameterdatatype WHERE name = @p041_type); -LOAD DATA LOCAL INFILE 'data/main-category-blocks.csv' +LOAD DATA LOCAL INFILE 'data/main-category-blocks.tsv' INTO TABLE xcosblocks_block FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n' @@ -228,7 +228,7 @@ LOAD DATA LOCAL INFILE 'data/main-category-blocks.csv' blockprefix_id = (SELECT id FROM xcosblocks_blockprefix WHERE name = @blockprefix_name), main_category_id = (SELECT id from xcosblocks_category WHERE blocktype_id = @blocktype_id AND name = @main_category_name); -LOAD DATA LOCAL INFILE 'data/main-category-blocks.csv' +LOAD DATA LOCAL INFILE 'data/main-category-blocks.tsv' INTO TABLE xcosblocks_blockparameter FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n' @@ -319,7 +319,7 @@ LOAD DATA LOCAL INFILE 'data/main-category-blocks.csv' p040_type_id = (SELECT id FROM xcosblocks_parameterdatatype WHERE name = @p040_type), p041_type_id = (SELECT id FROM xcosblocks_parameterdatatype WHERE name = @p041_type); -LOAD DATA LOCAL INFILE 'data/categories-blocks.csv' +LOAD DATA LOCAL INFILE 'data/categories-blocks.tsv' INTO TABLE xcosblocks_block_categories FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n' @@ -327,7 +327,7 @@ LOAD DATA LOCAL INFILE 'data/categories-blocks.csv' SET block_id = (SELECT xcosblocks_block.id FROM xcosblocks_block JOIN xcosblocks_category ON main_category_id = xcosblocks_category.id WHERE xcosblocks_block.name = @block_name AND blocktype_id = @blocktype_id AND xcosblocks_category.name = @main_category_name), category_id = (SELECT id from xcosblocks_category WHERE blocktype_id = @blocktype_id AND name = @category_name); -LOAD DATA LOCAL INFILE 'data/blocks-ports.csv' +LOAD DATA LOCAL INFILE 'data/blocks-ports.tsv' INTO TABLE xcosblocks_blockport FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n' @@ -340,7 +340,7 @@ CREATE TEMPORARY TABLE tmp_xcosblocks_block ( block_height int NOT NULL ); -LOAD DATA LOCAL INFILE 'data/getsize.csv' +LOAD DATA LOCAL INFILE 'data/getsize.tsv' INTO TABLE tmp_xcosblocks_block FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n' diff --git a/scripts/blocks-ports-old.csv b/scripts/blocks-ports-old.tsv index 281331da..281331da 100644 --- a/scripts/blocks-ports-old.csv +++ b/scripts/blocks-ports-old.tsv diff --git a/scripts/data-categories-blocks.csv b/scripts/data-categories-blocks.tsv index 00f0b91f..00f0b91f 100644 --- a/scripts/data-categories-blocks.csv +++ b/scripts/data-categories-blocks.tsv diff --git a/scripts/pinscript.awk b/scripts/pinscript.awk index 4132e319..f7daff54 100755 --- a/scripts/pinscript.awk +++ b/scripts/pinscript.awk @@ -5,8 +5,8 @@ BEGIN { OFS = "\t"; BLOCKPORTSCSVFORMAT = "%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\t%s\n"; STDERR = "/dev/stderr"; - BLOCKPORTSCSV = "data/blocks-ports.csv"; - GETSIZECSV = "data/getsize.csv"; + BLOCKPORTSCSV = "data/blocks-ports.tsv"; + GETSIZECSV = "data/getsize.tsv"; blockportid = 0; port_part = 1; diff --git a/scripts/pinscript.sh b/scripts/pinscript.sh index 6439e67d..95f365c4 100755 --- a/scripts/pinscript.sh +++ b/scripts/pinscript.sh @@ -1,3 +1,3 @@ #!/bin/bash -./scripts/pinscript.awk scripts/blocks-ports-old.csv +./scripts/pinscript.awk scripts/blocks-ports-old.tsv diff --git a/scripts/unique.awk b/scripts/unique.awk index 06d8f260..8009e2b0 100755 --- a/scripts/unique.awk +++ b/scripts/unique.awk @@ -1,8 +1,8 @@ #!/usr/bin/awk -f BEGIN { - MAIN_CATEGORY_BLOCKS_CSV = "data/main-category-blocks.csv"; - CATEGORIES_BLOCKS_CSV = "data/categories-blocks.csv"; + MAIN_CATEGORY_BLOCKS_CSV = "data/main-category-blocks.tsv"; + CATEGORIES_BLOCKS_CSV = "data/categories-blocks.tsv"; FS = "\t"; OFS = "\t"; split("", blocks); diff --git a/scripts/unique.sh b/scripts/unique.sh index ed3f7e81..b23a83aa 100755 --- a/scripts/unique.sh +++ b/scripts/unique.sh @@ -1,3 +1,3 @@ #!/bin/bash -./scripts/unique.awk scripts/data-categories-blocks.csv +./scripts/unique.awk scripts/data-categories-blocks.tsv |