FastAPI-ML-API---Sentiment-Analysis/scripts.sql at main · javsan77/FastAPI-ML-API---Sentiment-Analysis · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
CREATE TABLE dbo.Users (
    Id INT IDENTITY(1,1) PRIMARY KEY,
    Name NVARCHAR(100) NOT NULL,
    Email NVARCHAR(150) NOT NULL,
    CreatedAt DATETIME NOT NULL DEFAULT GETDATE()
);
GO

---------------------

ALTER TABLE fastapi_user_api.dbo.Users
ADD PasswordHash nvarchar(255) NOT NULL;


-----------------------

CREATE PROCEDURE dbo.usp_user_create
    @name NVARCHAR(100),
    @email NVARCHAR(150),
    @password_hash NVARCHAR(255)
AS
BEGIN
    SET NOCOUNT ON;

    INSERT INTO Users (Name, Email, CreatedAt, PasswordHash)
    VALUES (@name, @email, GETDATE(),@password_hash);

    SELECT SCOPE_IDENTITY() AS UserId;
END;
GO

---------------------

CREATE PROCEDURE dbo.usp_user_list
AS
BEGIN
    SET NOCOUNT ON;

    SELECT
        Id,
        Name,
        Email,
        CreatedAt
    FROM dbo.Users
    ORDER BY Id DESC;
END;
GO


----------------------

CREATE PROCEDURE dbo.usp_user_get_by_id
    @Id INT
AS
BEGIN
    SET NOCOUNT ON;

    SELECT
        Id,
        Name,
        Email,
        CreatedAt
    FROM dbo.Users
    WHERE Id = @Id;
END;
GO

----------------------

USE fastapi_user_api;
GO

CREATE PROCEDURE dbo.usp_user_get_by_email
    @Email NVARCHAR(150)
AS
BEGIN
    SET NOCOUNT ON;

    SELECT
        Id,
        Name,
        Email,
        PasswordHash,
        CreatedAt
    FROM dbo.Users
    WHERE Email = @Email;
END;
GO