LegendarySpork9 / Hunter-Industries-API

File Store for the Assistant API
Other
0 stars 0 forks source link

Populate Tables #6

Open LegendarySpork9 opened 6 months ago

LegendarySpork9 commented 6 months ago

Add the relevant data to the relevant tables in the Hunter Industries Server.

LegendarySpork9 commented 6 months ago

UAT tables populated.

image

INSERT INTO [dbo].[Authorisation] ([Phrase])
VALUES (
    'Do or do not. There is no try.'
)

INSERT INTO [dbo].[Deletion] ([Value])
VALUES 
    ('True'),
    ('False')

INSERT INTO [dbo].[Version] ([Value])
VALUES (
    '0.0.0'
)

INSERT INTO [dbo].[Location] ([HostName],[IPAddress])
VALUES (
    'The-Beast','192.168.1.203'
)

INSERT INTO [dbo].[User] ([Name])
VALUES (
    'Toby Hunter'
)

INSERT INTO [dbo].[Assistant_Information] ([LocationID],[DeletionStatusID],[VersionID],[UserID],[Name],[IDNumber])
VALUES (
    1,2,1,1,'Gideon','GDN 3027-4'
)

INSERT INTO [dbo].[Endpoint] ([Value])
VALUES
    ('https://hunter-industries.co.uk/api/auth/token'),
    ('https://hunter-industries.co.uk/api/audithistory'),
    ('https://hunter-industries.co.uk/api/assistant/config'),
    ('https://hunter-industries.co.uk/api/assistant/Version'),
    ('https://hunter-industries.co.uk/api/assistant/Deletion'),
    ('https://hunter-industries.co.uk/api/assistant/Location')

INSERT INTO [dbo].[Methods] ([Value])
VALUES 
    ('GET'),
    ('POST'),
    ('PATCH')