Add migrationsHEADmaster

6 files changed, 41 insertions, 1 deletions

diff --git a/app/controllers/sessions_controller.py b/app/controllers/sessions_controller.py
index dc0a3eb..8d30f86 100644
--- a/app/controllers/sessions_controller.py
+++ b/app/controllers/sessions_controller.py
@@ -1,5 +1,7 @@
 from flask import Blueprint
 from app.controllers import sessions_blueprint
+from app.database.models.user import User
+
 
 @sessions_blueprint.route('/')
 def hello():
diff --git a/app/database/models/__init__.py b/app/database/models/__init__.py
new file mode 100644
index 0000000..8b13789
--- /dev/null
+++ b/app/database/models/__init__.py
@@ -0,0 +1 @@
+
diff --git a/app/models/user.py b/app/database/models/user.py
index a76fb2e..a04e185 100644
--- a/app/models/user.py
+++ b/app/database/models/user.py
@@ -2,6 +2,7 @@ from sqlalchemy import BigInteger, String, Date
 from sqlalchemy.orm import mapped_column
 from app.database import db
 
+
 class User(db.Model):
     __tablename__ = 'users'
 
diff --git a/app/models/__init__.py b/app/models/__init__.py
deleted file mode 100644
index e69de29..0000000
--- a/app/models/__init__.py
+++ /dev/null
diff --git a/main.py b/main.py
index 86375f9..0f2ec16 100644
--- a/main.py
+++ b/main.py
@@ -7,6 +7,6 @@ app = Flask(__name__)
 app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///database.db'
 migrate = Migrate(app, db)
 db.init_app(app)
+
 # Blueprints registration
 app.register_blueprint(sessions_blueprint)
-
diff --git a/migrations/versions/31bf24732e3d_add_users.py b/migrations/versions/31bf24732e3d_add_users.py
new file mode 100644
index 0000000..34383d9
--- /dev/null
+++ b/migrations/versions/31bf24732e3d_add_users.py
@@ -0,0 +1,36 @@
+"""Add Users
+
+Revision ID: 31bf24732e3d
+Revises: 
+Create Date: 2023-12-21 19:20:51.840838
+
+"""
+from alembic import op
+import sqlalchemy as sa
+
+
+# revision identifiers, used by Alembic.
+revision = '31bf24732e3d'
+down_revision = None
+branch_labels = None
+depends_on = None
+
+
+def upgrade():
+    # ### commands auto generated by Alembic - please adjust! ###
+    op.create_table('users',
+    sa.Column('id', sa.BigInteger(), nullable=False),
+    sa.Column('email', sa.String(), nullable=False),
+    sa.Column('first_name', sa.String(), nullable=False),
+    sa.Column('last_name', sa.String(), nullable=False),
+    sa.Column('role', sa.String(length=10), nullable=False),
+    sa.Column('created_at', sa.Date(), nullable=False),
+    sa.PrimaryKeyConstraint('id')
+    )
+    # ### end Alembic commands ###
+
+
+def downgrade():
+    # ### commands auto generated by Alembic - please adjust! ###
+    op.drop_table('users')
+    # ### end Alembic commands ###