Respan Dataset Explorer

\dt
                 List of relations
 Schema |        Name        | Type  |    Owner    
--------+--------------------+-------+-------------
 public | Constituency       | table | ujamaa_user
 public | County             | table | ujamaa_user
 public | Group              | table | ujamaa_user
 public | GroupMember        | table | ujamaa_user
 public | Proposal           | table | ujamaa_user
 public | User               | table | ujamaa_user
 public | _prisma_migrations | table | ujamaa_user
(7 rows)

Great! Your database has all the expected tables:

- `Constituency`
- `County`
- `Group`
- `GroupMember`
- `Proposal`
- `User`
- `_prisma_migrations` (Prisma’s internal migrations tracking)

---

### Next step: Inspect the content of key tables to verify seed data and integrity

Here are some handy SQL queries to check the data and relationships:

---

#### Check Counties and Constituencies

```sql
SELECT id, name FROM "County" ORDER BY name;
```

```sql
SELECT c.id, c.name AS constituency, co.name AS county
FROM "Constituency" c
JOIN "County" co ON c."countyId" = co.id
ORDER BY co.name, c.name;
```

---

#### Check Users (give a quick preview)

```sql
SELECT id, name, email, "walletAddress", county, constituency
FROM "User"
ORDER BY createdAt DESC
LIMIT 10;
```

---

#### Check Groups and Member Counts

```sql
SELECT g.id, g.name, g."county", g."constituency",
  (SELECT COUNT(*) FROM "GroupMember" gm WHERE gm."groupId" = g.id) AS "memberCount"
FROM "Group" g
ORDER BY g.name;
```

---

#### Check Proposals (latest 10)

```sql
SELECT id, title, "proposalType", funded, status, "locationScope", createdAt
FROM "Proposal"
ORDER BY createdAt DESC
LIMIT 10;
```

---

### How to run these

If inside psql CLI, just copy & paste the queries.

In GUI clients, open a query window and execute.

---

### What to look for

- You should see your seeded counties and constituencies listed correctly.

- Users, groups, and memberships should reflect what you expect.

- Proposals should include correct enum values and foreign key links.

---

Let me know if you find anything unexpected or want help interpreting the results!

counties and constituencies are there as well, however there are no groups or users

Thanks for the update! If **counties and constituencies are present but groups and users are missing**, this explains why tests involving groups or users fail due to foreign key or missing data issues.

---

### What this means:

- Your seed script for counties/constituencies ran successfully, but **the part that seeds users, groups, and memberships either did not run, failed, or was not executed**.

---

### How to fix this and verify:

#### 1. **Re-run or fix seed script to include users and groups**

- Double-check your seed script has complete code to seed `User`, `Group`, and `GroupMember` data **after** counties/constituencies.

- Make sure there are no unhandled errors or early exits in the seed script during user/group seeding.

---

#### 2. **Manually check users and groups existence in DB**

Run these queries to verify:

```sql
SELECT id, name, email, "walletAddress" FROM "User" LIMIT 5;
SELECT id, name, "walletAddress" FROM "Group" LIMIT 5;
SELECT * FROM "GroupMember" LIMIT 5;
```

If these return empty, your users and groups truly aren’t seeded.

---

#### 3. **Run just the users and groups part of seed script**

If you want to isolate, you can write and run a small script just to create sample users and groups, for example:

```ts
import { PrismaClient, GroupRole } from '@prisma/client';

const prisma = new PrismaClient();

async function seedUsersAndGroups() {
  const user1 = await prisma.user.create({
    data: {
      walletAddress: '0xuser1wallet',
      email: 'user1@example.com',
      name: 'User One',
      constituency: 'Westlands',
      county: 'Nairobi',
      industry: 'Tech',
      goodsServices: ['Development'],
    },
  });

  const group1 = await prisma.group.create({
    data: {
      name: 'Group One',
      walletAddress: '0xgroup1wallet',
      constituency: 'Westlands',
      county: 'Nairobi',
      industryFocus: 'Technology',
      productsServices: ['Software Dev'],
    },
  });

  await prisma.groupMember.create({
    data: {
      userId: user1.id,
      groupId: group1.id,
      role: GroupRole.ADMIN,
    },
  });

  console.log('Sample users and groups seeded.');
}

seedUsersAndGroups()
  .catch(console.error)
  .finally(() => prisma.$disconnect());
```

Then run it with:

```bash
npx ts-node --esm path/to/script.ts
```

---

#### 4. **Check logs when running your full seed**

- When you run the whole seed script, carefully watch for errors or messages indicating failures during user or group creation parts.

---

### Summary

- Your DB is missing users and groups—this is why tests fail due to FK constraints.

- You need to **ensure your seed script creates users and groups correctly and that it runs successfully.**

- You can test seed smaller chunks to isolate the issue.

---

If you want, I can:

- Help you review and fix your full seed script.

- Provide a minimal separate seed script for users and groups you can run independently.

- Guide on running and verifying seeding step-by-step.

---

Just let me know how you want to proceed!

Which of the following schools of thought for representing Buddha flourished between the first and fifth centuries, and was distinctly Greco-Roman style?
a.
Gandhara
c.
Amaravati
b.
Mathura
d.
Gupta
 

Please select the best answer from the choices provided

A
B
C
D
Mark this and return 

The correct answer is:

**a. Gandhara**

Gandhara school of art flourished between the 1st and 5th centuries CE and is known for its distinct Greco-Roman influence in representing Buddha and other Buddhist figures.

Which of the following is not true of art during the Gupta Period?
a.
Many of the sculptures were carved out of a mountainside.
b.
Murals were painted on prepared plaster surfaces, and colored with natural pigments.
c.
The Indian people believed the Buddha was reincarnated, so many of the paintings showed scenes from Buddha’s past lives.
d.
The art combined Hellenistic, Persian, and Native styles.
 

Please select the best answer from the choices provided

A
B
C
D
Mark this and return 

The correct answer is:

**d. The art combined Hellenistic, Persian, and Native styles.**

Explanation:  
During the Gupta period, Indian art primarily developed a classical Indian style that emphasized native traditions and ideals. While Hellenistic influences were significant earlier, especially in the Gandhara school, Gupta art is more distinctly Indian and less influenced by Persian or Hellenistic styles. The other statements (a, b, and c) about sculptures carved from mountainsides, murals on plaster, and depicting Buddha's past lives are true of Gupta period art.

What happened to the ancient peoples of the Indus Valley?
a.
They migrated to Greece and Rome during the Gupta period.
b.
They were wiped out by a Tsunami during the 4th century.
c.
They were annialated by the Guptas as they expanded their territories.
d.
They disappeared as though into thin air, and the cause remains unknown.
 

Please select the best answer from the choices provided

A
B
C
D
Mark this and return 

The correct answer is:

**d. They disappeared as though into thin air, and the cause remains unknown.**

Explanation:  
The ancient Indus Valley Civilization declined around 1900 BCE, and the exact reasons for its disappearance are still debated by historians and archaeologists. Possible theories include climate change, river shifts, or social upheaval, but there is no definitive answer. The other options (migration to Greece and Rome, tsunami, annihilation by the Guptas) are not supported by historical evidence.

In ancient Indus sculpture, people were represented _______________.
a.
by abstract forms
b.
realistically
c.
always along side Buddha
d.
as reincarnated animals
 

Please select the best answer from the choices provided

A
B
C
D
Mark this and return 

The correct answer is:

**a. by abstract forms**

Explanation:  
Ancient Indus Valley Civilization art often represented people in stylized or abstract forms rather than realistic depictions. The civilization's sculptures, seals, and figurines tend to emphasize symbolic or simplified human features rather than detailed realistic portrayals. Options involving Buddha or reincarnated animals are not relevant to the Indus Valley period.

A sculpture of a man sitting with his legs crossed, feet facing up. One hand is raised beside the shoulder, palm out. The other is placed on the knee. Two smaller figures stand behind the seated man and two smaller figures float above him.
This sculptural representation of Buddha is an example of the _____________ school of thought.
a.
Gandhara
c.
Amaravati
b.
Mathura
d.
Gupta
 	 	 	 
 

Please select the best answer from the choices provided


A
B
C
D
Mark this and return 

The correct answer is:

**b. Mathura**

Explanation:  
The description aligns with the **Mathura** school of art, which often depicted Buddha seated cross-legged with symbolic hand gestures (mudras), accompanied by attendant figures. Mathura sculptures typically had a more indigenous Indian style compared to Gandhara, which had stronger Greco-Roman influences. The Amaravati and Gupta schools have distinct styles as well, but the presence of smaller attendant figures and the described posture is characteristic of Mathura art.

Which of the following attributes were not common of Indus Valley stamp seals?
a.
The stamps were carved out pure limestone.
b.
They were used as marks of ownership/status.
c.
They were often engraved with animals, humans, fantastic creatures, or divinities.
d.
The stamps contain inscriptions along the top edge.
 

Please select the best answer from the choices provided

A
B
C
D
Mark this and return 

The correct answer is:

**a. The stamps were carved out pure limestone.**

Explanation:  
Indus Valley seals were typically made from **steatite** (a type of soapstone), not pure limestone. The other options (used as marks of ownership/status, engraved with animals and inscriptions) are true characteristics of Indus Valley stamp seals.

Which of the following is not true of Korean Maebyeong bottles?
a.
Korean potters used a celadon-high fired glaze of pale, bluish green hue to make Maebyong bottles.
b.
Korean pottery rivaled the best Chinese court ceramics.
c.
Maebyeong bottles were made of different materials and qualities so that everyone would be able to own one.
d.
Many examples were found in an artificial cave temple.
 	 
 

Please select the best answer from the choices provided


A
B
C
D
Mark this and return

The correct answer is:

**c. Maebyeong bottles were made of different materials and qualities so that everyone would be able to own one.**

Explanation:  
Maebyeong bottles were high-quality Korean ceramics typically made from fine materials and celadon glaze, often associated with the elite or court use. They were not mass-produced in different qualities for general ownership. The other statements about celadon glaze, rivaling Chinese ceramics, and findings in cave temples are true.

______________ is the overall energy of a work of art.
a.
Bone method
c.
Division of Spirit
b.
Spirited Resonance
d.
Calligraphy
 

Please select the best answer from the choices provided

A
B
C
D
Mark this and return

The correct answer is:

**b. Spirited Resonance**

Explanation:  
"Spirited Resonance" refers to the overall energy, vitality, or life force conveyed by a work of art, especially in traditional Chinese aesthetics.