aboutsummaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
Diffstat (limited to 'db')
-rw-r--r--db/migrate/20210122050635_add_section_icon.rb5
-rw-r--r--db/schema.rb3
-rw-r--r--db/seeds.rb82
3 files changed, 89 insertions, 1 deletions
diff --git a/db/migrate/20210122050635_add_section_icon.rb b/db/migrate/20210122050635_add_section_icon.rb
new file mode 100644
index 0000000..a89c201
--- /dev/null
+++ b/db/migrate/20210122050635_add_section_icon.rb
@@ -0,0 +1,5 @@
+class AddSectionIcon < ActiveRecord::Migration[6.1]
+ def change
+ add_column :sections, :icon_name, :string, limit: 32, default: 'fa-neuter'
+ end
+end
diff --git a/db/schema.rb b/db/schema.rb
index c97f290..60a2c99 100644
--- a/db/schema.rb
+++ b/db/schema.rb
@@ -10,7 +10,7 @@
#
# It's strongly recommended that you check this file into your version control system.
-ActiveRecord::Schema.define(version: 2021_01_21_192039) do
+ActiveRecord::Schema.define(version: 2021_01_22_050635) do
# These are extensions that must be enabled in order to support this database
enable_extension "plpgsql"
@@ -124,6 +124,7 @@ ActiveRecord::Schema.define(version: 2021_01_21_192039) do
t.datetime "created_at", precision: 6, null: false
t.datetime "updated_at", precision: 6, null: false
t.integer "dewey_id"
+ t.string "icon_name", limit: 32, default: "circle"
t.index ["category_id"], name: "index_sections_on_category_id"
t.index ["dewey_id"], name: "index_sections_on_dewey_id", unique: true
end
diff --git a/db/seeds.rb b/db/seeds.rb
index 6252ebf..60cebe2 100644
--- a/db/seeds.rb
+++ b/db/seeds.rb
@@ -53,3 +53,85 @@ end
if Map.count == 0
Map.create(uuid: "1a42651e-3fe8-4e83-bfcd-f14bb8d0c713", latitude: 50.8503396, longitude: 4.3517103, zoom: 13, taxonomy_id: 1)
end
+
+# TODO: Fix section icons
+# This thing below was a start with maki icons but we need more...
+# And fork-awesome is missing some as well, so we need to create them.
+=begin
+if Section.first.icon_name == 'circle'
+ {
+ # cat-30
+ 148: 'fa-campsite',
+ 158: 'hospital',
+ 130: 'landmark-JP',
+ 198: 'shelter',
+ 150: 'lodging',
+ 149: 'playground',
+ 165: 'residential-community',
+ 131: 'home',
+ 168: 'residential-community',
+ 164: 'residential-community',
+ 114: 'home',
+ # cat-31
+ 170: 'convenience',
+ 180: 'sushi',
+ 155: 'garden',
+ 135: 'shop',
+ 115: 'drinking-water',
+ 154: 'restaurant',
+ 118: 'restaurant',
+ 28: 'recycling',
+ 27: 'garden-center',
+ 185: 'farm',
+ 182: 'fast-food',
+ 123: 'beer',
+ # cat-32
+ 210: 'square',
+ 156: 'clothing-store',
+ 46: 'gift',
+ 144: 'waterfall',
+ 104: 'clothing-store',
+ 207: 'toilet',
+ # cat-33
+ 18: 'hospital',
+ 145: 'doctor',
+ 157: 'doctor',
+ 192: 'shelter',
+ 199: 'defibrillator',
+ 190: 'shelter',
+ 143: 'heart',
+ 208: 'hospital',
+ 191: 'heart',
+ # cat-34
+ 699: 'shop',
+ 138: 'logging',
+ 136: 'recycling',
+ 50: 'library',
+ 132: 'garden-center',
+ 42: 'hardware',
+ 113: 'building',
+ 206: 'clothing-store',
+ 47: 'recycling',
+ 205: 'recycling',
+ 120: 'shop',
+ # cat-35
+ 128: 'garden-center',
+ 121: 'waste-basket',
+ 116: 'garden',
+ 133: 'park',
+ 194: 'natural',
+ 129: 'picnic-site',
+ 125: 'recycle',
+ 127: 'natural',
+ # cat-36
+ 102: 'ranger-station',
+ 19: 'town',
+ 17: 'skateboard',
+ 14: ''
+
+
+ }.each do |id, name|
+ Section.find_by(dewey_id: id).update(icon_name: name)
+ end
+end
+=end