Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit14048bb

Browse files
committed
updated
1 parent667b971 commit14048bb

File tree

6 files changed

+27
-130
lines changed

6 files changed

+27
-130
lines changed

‎.env‎

Lines changed: 2 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -15,8 +15,8 @@ VERIFICATION_SECRET=my-email-verification-secret
1515

1616
EMAIL_HOST=smtp.mailtrap.io
1717
EMAIL_PORT=587
18-
EMAIL_USERNAME=4aeca0c9318dd2
19-
EMAIL_PASSWORD=a987a0e0eac00d
18+
EMAIL_USERNAME=90cf952fb44469
19+
EMAIL_PASSWORD=0524531956c552
2020
EMAIL_FROM=admin@admin.com
2121

2222
JWT_PRIVATE_KEY=LS0tLS1CRUdJTiBSU0EgUFJJVkFURSBLRVktLS0tLQpNSUlCT2dJQkFBSkJBSSs3QnZUS0FWdHVQYzEzbEFkVk94TlVmcWxzMm1SVmlQWlJyVFpjd3l4RVhVRGpNaFZuCi9KVHRsd3h2a281T0pBQ1k3dVE0T09wODdiM3NOU3ZNd2xNQ0F3RUFBUUpBYm5LaENOQ0dOSFZGaHJPQ0RCU0IKdmZ2ckRWUzVpZXAwd2h2SGlBUEdjeWV6bjd0U2RweUZ0NEU0QTNXT3VQOXhqenNjTFZyb1pzRmVMUWlqT1JhUwp3UUloQU84MWl2b21iVGhjRkltTFZPbU16Vk52TGxWTW02WE5iS3B4bGh4TlpUTmhBaUVBbWRISlpGM3haWFE0Cm15QnNCeEhLQ3JqOTF6bVFxU0E4bHUvT1ZNTDNSak1DSVFEbDJxOUdtN0lMbS85b0EyaCtXdnZabGxZUlJPR3oKT21lV2lEclR5MUxaUVFJZ2ZGYUlaUWxMU0tkWjJvdXF4MHdwOWVEejBEWklLVzVWaSt6czdMZHRDdUVDSUVGYwo3d21VZ3pPblpzbnU1clBsTDJjZldLTGhFbWwrUVFzOCtkMFBGdXlnCi0tLS0tRU5EIFJTQSBQUklWQVRFIEtFWS0tLS0t

‎alembic/versions/15770e820938_created_users_table.py‎

Lines changed: 0 additions & 40 deletions
This file was deleted.

‎alembic/versions/1c7984990e1d_created_posts_table.py‎

Lines changed: 0 additions & 39 deletions
This file was deleted.

‎alembic/versions/39256113e8e5_added_verification_code.py‎

Lines changed: 0 additions & 43 deletions
This file was deleted.

‎alembic/versions/4917da928a79_added_post_table.py‎renamed to ‎alembic/versions/61055af0da89_added_crud_entities.py‎

Lines changed: 22 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -1,23 +1,38 @@
1-
"""added post table
1+
"""added-crud-entities
22
3-
Revision ID:4917da928a79
4-
Revises:39256113e8e5
5-
Create Date: 2022-07-14 09:05:17.444518
3+
Revision ID:61055af0da89
4+
Revises:
5+
Create Date: 2022-08-26 20:52:17.830383
66
77
"""
88
fromalembicimportop
99
importsqlalchemyassa
1010
fromsqlalchemy.dialectsimportpostgresql
1111

1212
# revision identifiers, used by Alembic.
13-
revision='4917da928a79'
14-
down_revision='39256113e8e5'
13+
revision='61055af0da89'
14+
down_revision=None
1515
branch_labels=None
1616
depends_on=None
1717

1818

1919
defupgrade()->None:
2020
# ### commands auto generated by Alembic - please adjust! ###
21+
op.create_table('users',
22+
sa.Column('id',postgresql.UUID(as_uuid=True),nullable=False),
23+
sa.Column('name',sa.String(),nullable=False),
24+
sa.Column('email',sa.String(),nullable=False),
25+
sa.Column('password',sa.String(),nullable=False),
26+
sa.Column('photo',sa.String(),nullable=True),
27+
sa.Column('verified',sa.Boolean(),server_default='False',nullable=False),
28+
sa.Column('verification_code',sa.String(),nullable=True),
29+
sa.Column('role',sa.String(),server_default='user',nullable=False),
30+
sa.Column('created_at',sa.TIMESTAMP(timezone=True),server_default=sa.text('now()'),nullable=False),
31+
sa.Column('updated_at',sa.TIMESTAMP(timezone=True),server_default=sa.text('now()'),nullable=False),
32+
sa.PrimaryKeyConstraint('id'),
33+
sa.UniqueConstraint('email'),
34+
sa.UniqueConstraint('verification_code')
35+
)
2136
op.create_table('posts',
2237
sa.Column('id',postgresql.UUID(as_uuid=True),nullable=False),
2338
sa.Column('user_id',postgresql.UUID(as_uuid=True),nullable=False),
@@ -36,4 +51,5 @@ def upgrade() -> None:
3651
defdowngrade()->None:
3752
# ### commands auto generated by Alembic - please adjust! ###
3853
op.drop_table('posts')
54+
op.drop_table('users')
3955
# ### end Alembic commands ###

‎app/routers/auth.py‎

Lines changed: 3 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -150,6 +150,9 @@ def verify_me(token: str, db: Session = Depends(get_db)):
150150
db.commit()
151151
user=user_query.first()
152152
ifnotuser:
153+
raiseHTTPException(
154+
status_code=status.HTTP_403_FORBIDDEN,detail="Invalid code or user doesn't exist")
155+
ifuser.verified:
153156
raiseHTTPException(
154157
status_code=status.HTTP_403_FORBIDDEN,detail='Email can only be verified once')
155158
user_query.update(

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp