backend/sql/data_test.sql

   1 INSERT INTO [User] ([id], [email], [name], [password], [creation_datetime], [validation_token])
   2 VALUES (
   3     1,
   4     'paul@atreides.com',
   5     'Paul',
   6     '$argon2id$v=19$m=4096,t=3,p=1$1vtXcacYjUHZxMrN6b2Xng$wW8Z59MIoMcsIljnjHmxn3EBcc5ymEySZPUVXHlRxcY',
   7     0,
   8     NULL
   9 );
  10
  11 INSERT INTO [User] ([id], [email], [name], [password], [creation_datetime], [validation_token])
  12 VALUES (
  13     2,
  14     'alia@atreides.com',
  15     'Alia',
  16     '$argon2id$v=19$m=4096,t=3,p=1$1vtXcacYjUHZxMrN6b2Xng$wW8Z59MIoMcsIljnjHmxn3EBcc5ymEySZPUVXHlRxcY',
  17     0,
  18     NULL
  19 );
  20
  21 INSERT INTO [Recipe] ([user_id], [title])
  22 VALUES (1, 'Croissant au jambon');
  23
  24 INSERT INTO [Recipe] ([user_id], [title])
  25 VALUES (1, 'Gratin de thon aux olives');
  26
  27 INSERT INTO [Recipe] ([user_id], [title])
  28 VALUES (1, 'Saumon en croute');
  29
  30 INSERT INTO [Recipe] ([user_id], [title])
  31 VALUES (2, 'Ouiche lorraine');