FazBrowse GitHub Viewer | Trending | | Home

Tools: [Download Repo ZIP] [View Raw Code] [Original HTTPS Page]

httpsms/tests/seed.sql at main · iwillcodeu/httpsms · GitHub

38 lines (35 loc) · 1 KB

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

-- Seed test data for integration tests

-- Run AFTER GORM has migrated the schema (i.e., after API starts)

-- Test user

INSERT INTO users (id, email, api_key, timezone, subscription_name, created_at, updated_at)

VALUES (

'test-user-id',

'test@httpsms.com',

'test-user-api-key',

'UTC',

'pro-monthly',

NOW(),

NOW()

) ON CONFLICT (id) DO NOTHING;

-- Test user for API key rotation tests (isolated to avoid mutating the shared test user)

INSERT INTO users (id, email, api_key, timezone, subscription_name, created_at, updated_at)

VALUES (

'rotate-test-user-id',

'rotate-test@httpsms.com',

'rotate-test-api-key',

'UTC',

'pro-monthly',

NOW(),

NOW()

) ON CONFLICT (id) DO NOTHING;

-- System user (for event queue auth)

INSERT INTO users (id, email, api_key, timezone, subscription_name, created_at, updated_at)

VALUES (

'system-user-id',

'system@httpsms.com',

'system-user-api-key',

'UTC',

'pro-monthly',

NOW(),

NOW()

) ON CONFLICT (id) DO NOTHING;

Back | FazBrowse Home | New Git URL