NoMongo: Create an equivalent sample database for importation by the setup script

[palisadoes]

Is your feature request related to a problem? Please describe.

1. To make development easier, we need to recreate a sample database for the develop-postgres branch for use by the setup script
2. This was a feature in the develop branch
3. You will need to coordinate with the person assigned this issue
   1. NoMongo: Create a .env file setup script #2840
4. As much as possible, duplicate the following from the sample mongodb database:
   1. Users
   2. Posts
   3. Organizations
   4. Events
      1. The new API doesn't support recurring events yet. Create individual repeated events for 2025.
      2. The monthly, weekly, daily calendar for 2025 must match that of the develop branch implementation.
5. You will need to add the user information ton INSTALLATION.md

Describe the solution you'd like

• See above

Describe alternatives you've considered

• N/A

Approach to be followed (optional)

• See above

Additional context

• N/A

Potential internship candidates

Please read this if you are planning to apply for a Palisadoes Foundation internship

• Student Internship Programs talawa#359

[VanshikaSabharwal]

I want to work on this issue @palisadoes . Please approve this PR PalisadoesFoundation/switchmap-ng#248 if everything is fine. So that i can get this issue and start working.

[swaparup36]

Looks interesting. Hello @palisadoes, I want to start contribution to this repo with this issue. Can you please assign it to me?

[Aryan4884]

@Cioppolo14 I would like to work on this.Please assign.

[swaparup36]

@palisadoes I am done with the loadSampledata script. Now could you please tell me do I need to use the exact data that is in develop branch and change it accordingly with the schema here? Or I can create some sample data by myself?

[palisadoes]

Here are some steps:

1. Look at the test data in the develop branch and create the equivalents in develop-postgres.
2. Names, addresses, emails, passwords must match as much as possible, especially those in the INSTALLATION.md file of develop
3. Recurring events are not supported yet in the current branch, so you'll need to create at least 5 years worth of repeated meetings to give the impression of recurrence. (This could be automated after you create the first month of events)

The original data in develop was created manually in the Admin UI after which a database dump was done and added to the repo.

Make sure your script is in Typescript. We'll need to use it in creating as setup script.

• NoMongo: Create a setup script for the develop-postgres branch #2688

[github-actions]

This issue did not get any activity in the past 10 days and will be closed in 180 days if no update occurs. Please check if the develop branch has fixed it and report again or close the issue.

[palisadoes]

Unassigning inactivity

[VanshikaSabharwal]

@palisadoes can i work on this issue

[gurramkarthiknetha]

i want to work on this issue . please assign this issue to me

[Cioppolo14]

@VanshikaSabharwal Our policy is to assign no more than two issues to each contributor across all repositories. This way everyone gets a chance to participate in the projects. We sometimes give exceptions for more urgent cases and sometimes we lose track, but the policy stands. You have reached your limit, please wait until your existing issues are closed before requesting more issues. You could unassign yourself from one of the other issues too.

[palisadoes]

1. @gurramkarthiknetha we are now exclusively working on develop-postgres PRs. It is safe to start.
2. You'll need to work with @prayanshchh who has started work on a setup script

[prayanshchh]

@gurramkarthiknetha I will implement and fix most of the stuff for setup script EOD, we have talked on slack before, ping me when you get the time

[gurramkarthiknetha]

@gurramkarthiknetha I will implement and fix most of the stuff for setup script EOD, we have talked on slack before, ping me when you get the time

Thank you for your response! I’ll reach out to you on Slack.

[palisadoes]

@gurramkarthiknetha

If you are having difficulty logging in using the develop-postgres branch with Talawa Admin, this PR should fix your issues. Try downloading it running it as a new local branch.

You can use this to start populating the database

PalisadoesFoundation/talawa-admin#3477

[palisadoes]

Have you been able to make any progress? This is a priority issue

[bandhan-majumder]

hi @gurramkarthiknetha is there any blocker you are facing? I will be happy to assist. Let me know here or on slack.

[gurramkarthiknetha]

#3096

i added a commit top of @prayanshchh

[palisadoes]

Please coordinate with @rahulch07 on getting a DB dump from his PR for the setup script

• Refactor Admin Login: MongoDB → PostgreSQL talawa-admin#3477

[IITI-tushar]

@palisadoes If it's okay can I collaborate with @prayanshchh and will try to fix this as soon as possible...

[gautam-divyanshu]

This is a priority issue; we need to get this done by EOD. It's causing too many delays. I will try to do this.

@prayanshchh , you first focus on the setup script, then this; we need that also ASAP.

[prayanshchh]

This is a priority issue; we need to get this done by EOD. It's causing too many delays. I will try to do this.

@prayanshchh , you first focus on the setup script, then this; we need that also ASAP.

alright then

[gurramkarthiknetha]

@gautam-divyanshu @palisadoes shall i work on this i completed almost

[gautam-divyanshu]

@gurramkarthiknetha Are you able to run this script inside the Docker?

[gautam-divyanshu]

test this script, I am also trying.

[gurramkarthiknetha]

@gurramkarthiknetha Are you able to run this script inside the Docker?

ya

[gurramkarthiknetha]

[gautam-divyanshu]

connect on slack

[palisadoes]

@gautam-divyanshu We'll also need to update the documentation to match

[gautam-divyanshu]

Sure, but the script is not working right now; I am trying to figure it out.

[palisadoes]

1. One option would be to create a small test DB using the API and try to import it
2. The original test data was created using the Web UI then dumping the result to JSON files

[gurramkarthiknetha]

@palisadoes please assign this issue to me now i have made few changes in loadSampleData.ts file and everyone can successfully import it now

[gautam-divyanshu]

@gurramkarthiknetha create a pr.

[gurramkarthiknetha]

@gurramkarthiknetha create a pr.

sure

[gautam-divyanshu]

@gurramkarthiknetha

JSON files must be in sample_data directory.

[gurramkarthiknetha]

@gurramkarthiknetha

JSON files must be in sample_data directory.

ok i will update it

[gautam-divyanshu]

@gurramkarthiknetha we need a github action also to test the script, I will import the dot env in my PR only with github action,

Thanks.

[palisadoes]

Why do we have 2 PRs for the same issue? One by the person who assigned the issue to someone else.

This is getting out of hand.

@gautam-divyanshu I've assigned this to you too finish up.

I've had to make too many exceptions to our policies recently to get these basic features functional and end showstopper bugs.

This will soon stop.

[palisadoes]

Closing as complete