From 0ab2e5ba2b0631b28b5b1405559237b3913c878f Mon Sep 17 00:00:00 2001 From: Dawid Rycerz Date: Sun, 23 Mar 2025 17:11:39 +0100 Subject: feat: initialize Phoenix application for weather alerts This commit sets up the initial Silmataivas project structure, including: Phoenix web framework configuration, database models for users and locations, weather polling service, notification system, Docker and deployment configurations, CI/CD pipeline setup --- priv/repo/migrations/.formatter.exs | 4 ++++ priv/repo/migrations/20250323093704_create_users.exs | 13 +++++++++++++ priv/repo/migrations/20250323093713_create_locations.exs | 15 +++++++++++++++ priv/repo/migrations/20250326104054_add_role_to_users.exs | 9 +++++++++ 4 files changed, 41 insertions(+) create mode 100644 priv/repo/migrations/.formatter.exs create mode 100644 priv/repo/migrations/20250323093704_create_users.exs create mode 100644 priv/repo/migrations/20250323093713_create_locations.exs create mode 100644 priv/repo/migrations/20250326104054_add_role_to_users.exs (limited to 'priv/repo/migrations') diff --git a/priv/repo/migrations/.formatter.exs b/priv/repo/migrations/.formatter.exs new file mode 100644 index 0000000..49f9151 --- /dev/null +++ b/priv/repo/migrations/.formatter.exs @@ -0,0 +1,4 @@ +[ + import_deps: [:ecto_sql], + inputs: ["*.exs"] +] diff --git a/priv/repo/migrations/20250323093704_create_users.exs b/priv/repo/migrations/20250323093704_create_users.exs new file mode 100644 index 0000000..c418326 --- /dev/null +++ b/priv/repo/migrations/20250323093704_create_users.exs @@ -0,0 +1,13 @@ +defmodule Silmataivas.Repo.Migrations.CreateUsers do + use Ecto.Migration + + def change do + create table(:users) do + add :user_id, :string + + timestamps(type: :utc_datetime) + end + + create unique_index(:users, [:user_id]) + end +end diff --git a/priv/repo/migrations/20250323093713_create_locations.exs b/priv/repo/migrations/20250323093713_create_locations.exs new file mode 100644 index 0000000..9373024 --- /dev/null +++ b/priv/repo/migrations/20250323093713_create_locations.exs @@ -0,0 +1,15 @@ +defmodule Silmataivas.Repo.Migrations.CreateLocations do + use Ecto.Migration + + def change do + create table(:locations) do + add :latitude, :float + add :longitude, :float + add :user_id, references(:users, on_delete: :nothing) + + timestamps(type: :utc_datetime) + end + + create index(:locations, [:user_id]) + end +end diff --git a/priv/repo/migrations/20250326104054_add_role_to_users.exs b/priv/repo/migrations/20250326104054_add_role_to_users.exs new file mode 100644 index 0000000..786b46f --- /dev/null +++ b/priv/repo/migrations/20250326104054_add_role_to_users.exs @@ -0,0 +1,9 @@ +defmodule Silmataivas.Repo.Migrations.AddRoleToUsers do + use Ecto.Migration + + def change do + alter table(:users) do + add :role, :string, default: "user" + end + end +end -- cgit v1.2.3