Created test data and dumped database

eagauss commented 3 months ago

There are three usernames / logins / passwords with verified phones and emails: Test Donor / donor+test.reshetniak@gmail.com / schemu8s Test Refugee / refugee+test.reshetniak@gmail.com / schemu8s trafalgargirls / trafalgargirls@gmail.com / donor-trafalgar

And test data as requested:

One conversation should have no messages exchanged by the users
One conversation should have an unread message that's been sent by the donor
One conversation should have an unread message that's been sent by the refugee
One conversation should relate to an item that has been deleted by the donor since the conversation started
One conversation should have several messages exchanged between the users over the span of a few different days

I ran commands: supabase start supabase db reset to re-seed the database with new data.

Everything seems to be fine apart from the broken userpics and product thumbnails.

To dump the database locally, I ran a command: supabase db dump -f supabase/seed.sql --data-only --local

netlify[bot] commented 3 months ago

Deploy Preview for cool-creponne-3e1272 ready!

Name	Link
Latest commit	1ffca2716b3991a0241b84ca963d80e05b8efeda
Latest deploy log	https://app.netlify.com/sites/cool-creponne-3e1272/deploys/669d9ebe7e38dc000846a34b
Deploy Preview	https://deploy-preview-263--cool-creponne-3e1272.netlify.app
Preview on mobile	Toggle QR Code... Use your smartphone camera to open QR code link.

To edit notification comments on pull requests, go to your Netlify site configuration.

camelPhonso commented 3 months ago

closes #168

Tagging this here as we've spotted after tests that this PR would close one additional Issue

github-actions[bot] commented 2 months ago

🤖 meep morp!

This PR is now marked as stale because there has been no activity for a while.

💡 Please guarantee this is still a relevant PR.

eagauss commented 2 months ago

@camelPhonso I have just created the trafalgargirls@gmail.com user.

Still had an error with pushing my commit, so I had to edit the seed.sql file in the branch via GitHub to bypass it.

camelPhonso commented 2 months ago

Thanks Emil - I've made a suggestion for the item entries so it's directly calling to the images now stored in staging and from my tests that works well.

The other thing is that in order to reproduce the actual user experience I have added on my local a few entries to the messages table. By making it look like this we can replicate the system messages our current features would introduce:

        (1, '2024-06-16 13:47:33.320940+00', 1, '1dc06b29-0b93-46d8-a33b-fb6f80ee5263', 'This is the start of your conversation.', false),
  (2, '2024-06-16 13:47:33.320944+00', 1, '48f9db70-05f7-4a04-a34d-75ae8267c90b', 'Unread to donor', false),
  (3, '2024-06-16 13:47:59.560080+00', 2, '1dc06b29-0b93-46d8-a33b-fb6f80ee5263', 'This is the start of your conversation.', true),
  (4, '2024-06-16 13:47:59.560082+00', 2, '48f9db70-05f7-4a04-a34d-75ae8267c90b', 'Hello!', true),
  (5, '2024-06-16 13:48:38.692718+00', 2, 'cab97c8e-6704-4bb2-b3e8-a9cdaaf1be85', 'Unread to refugee', false),
  (6, '2024-06-16 13:49:45.938565+00', 3, '1dc06b29-0b93-46d8-a33b-fb6f80ee5263', 'This is the start of your conversation.', true),
  (7, '2024-06-16 13:49:45.938566+00', 3, '48f9db70-05f7-4a04-a34d-75ae8267c90b', 'Can I have it please?', true),
  (8, '2024-06-16 13:49:45.938567+00', 3, '1dc06b29-0b93-46d8-a33b-fb6f80ee5263', 'This item is no longer available.', true),
  (9, '2024-06-16 13:50:10.337136+00', 3, 'cab97c8e-6704-4bb2-b3e8-a9cdaaf1be85', 'Sorry it''s deleted', false),
  (10, '2024-06-10 13:51:32+00', 4, '1dc06b29-0b93-46d8-a33b-fb6f80ee5263', 'This is the start of your conversation.', true),
  (11, '2024-06-10 13:51:33+00', 4, 'cab97c8e-6704-4bb2-b3e8-a9cdaaf1be85', 'Message 1 day 1', true),
  (12, '2024-06-12 13:52:11+00', 4, '48f9db70-05f7-4a04-a34d-75ae8267c90b', 'Message 2 day 2', true),
  (13, '2024-06-14 13:52:31+00', 4, 'cab97c8e-6704-4bb2-b3e8-a9cdaaf1be85', 'Message 3 day 3', true),
  (14, '2024-06-16 13:52:55.597471+00', 4, '48f9db70-05f7-4a04-a34d-75ae8267c90b', 'Message 4 day 4', true);

Hi Emil, could you just add these changes to the 'messages' table on the seed.js file as well?

One last thing is that we will need to update the BEFORE_YOUR_FIRST_ISSUE.md file telling people under the Running the app how to log in with the credentials you created.

eagauss commented 2 months ago

@camelPhonso Done! Please have a 👀

enBloc-org / kindly