|
| 1 | +-- Ensure api_keys and oauth2_provider_app_tokens have live data after |
| 2 | +-- migration 000371 deletes expired rows. |
| 3 | +INSERT INTO api_keys ( |
| 4 | +id, |
| 5 | +hashed_secret, |
| 6 | +user_id, |
| 7 | +last_used, |
| 8 | +expires_at, |
| 9 | +created_at, |
| 10 | +updated_at, |
| 11 | +login_type, |
| 12 | +lifetime_seconds, |
| 13 | +ip_address, |
| 14 | +token_name, |
| 15 | +scopes, |
| 16 | +allow_list |
| 17 | +) |
| 18 | +VALUES ( |
| 19 | +'fixture-api-key', |
| 20 | +'\xaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa', |
| 21 | +'30095c71-380b-457a-8995-97b8ee6e5307', |
| 22 | +NOW()- INTERVAL'1 hour', |
| 23 | +NOW()+ INTERVAL'30 days', |
| 24 | +NOW()- INTERVAL'1 day', |
| 25 | +NOW()- INTERVAL'1 day', |
| 26 | +'password', |
| 27 | +86400, |
| 28 | +'0.0.0.0', |
| 29 | +'fixture-api-key', |
| 30 | +ARRAY['workspace:read']::api_key_scope[], |
| 31 | +ARRAY['*:*'] |
| 32 | +) |
| 33 | +ON CONFLICT (id) DO NOTHING; |
| 34 | + |
| 35 | +INSERT INTO oauth2_provider_app_tokens ( |
| 36 | +id, |
| 37 | +created_at, |
| 38 | +expires_at, |
| 39 | +hash_prefix, |
| 40 | +refresh_hash, |
| 41 | +app_secret_id, |
| 42 | +api_key_id, |
| 43 | +audience, |
| 44 | +user_id |
| 45 | +) |
| 46 | +VALUES ( |
| 47 | +'9f92f3c9-811f-4f6f-9a1c-3f2eed1f9f15', |
| 48 | +NOW()- INTERVAL'30 minutes', |
| 49 | +NOW()+ INTERVAL'30 days', |
| 50 | +CAST('fixture-hash-prefix'ASbytea), |
| 51 | +CAST('fixture-refresh-hash'ASbytea), |
| 52 | +'b0eebc99-9c0b-4ef8-bb6d-6bb9bd380a11', |
| 53 | +'fixture-api-key', |
| 54 | +'https://coder.example.com', |
| 55 | +'30095c71-380b-457a-8995-97b8ee6e5307' |
| 56 | +) |
| 57 | +ON CONFLICT (id) DO NOTHING; |