create-sample-projects.sql

-- Create project statuses first
INSERT INTO public."project_status" ("id", "symbol", "name", "description") VALUES
(1, 'pending', 'Pending', 'Project is pending review'),
(2, 'rejected', 'Rejected', 'Project has been rejected'),
(3, 'cancelled', 'Cancelled', 'Project has been cancelled'),
(4, 'draft', 'Draft', 'Project is in draft mode'),
(5, 'active', 'Active', 'Project is active and accepting donations')
ON CONFLICT ("id") DO NOTHING;

-- Create sample projects for development
-- First, ensure we have a user to be admin
INSERT INTO public."user" (
    "firstName", "lastName", "name", "walletAddress", 
    "avatar", "url", "isEmailVerified", "createdAt", "updatedAt",
    "loginType", "totalDonated", "totalReceived"
) VALUES (
    'Demo', 'User', 'Demo User', '0x1234567890123456789012345678901234567890',
    'https://example.com/avatar.jpg', 'https://example.com',
    true, NOW(), NOW(),
    'wallet', 0, 0
) ON CONFLICT ("walletAddress") DO NOTHING;

-- Get the user ID (we'll use ID 1 assuming it exists or was just created)
-- Create sample projects with statusId = 5 (active)
INSERT INTO public."project" (
    "title", "slug", "description", "descriptionSummary",
    "website", "creationDate", "updatedAt", "image",
    "walletAddress", "verified", "statusId", "adminUserId",
    "totalDonations", "totalReactions", "listed", "isGivbackEligible",
    "reviewStatus", "giveBacks", "qualityScore", "totalTraceDonations",
    "totalProjectUpdates", "sumDonationValueUsdForActiveQfRound",
    "countUniqueDonorsForActiveQfRound", "countUniqueDonors",
    "activeCausesCount", "slugHistory"
) VALUES 
(
    'Sample Environmental Project', 'sample-environmental-project',
    'A project focused on environmental conservation and sustainability.',
    'Environmental conservation project',
    'https://example.com/env-project', NOW(), NOW(),
    'https://example.com/env-project.jpg',
    '0x1111111111111111111111111111111111111111', true, 5, 1,
    1000.0, 25, true, true, 'Listed', false, 80, 0,
    0, 0, 0, 1, 0, ARRAY['sample-environmental-project']
),
(
    'Education Initiative', 'education-initiative',
    'Supporting education in underserved communities around the world.',
    'Education support project',
    'https://example.com/edu-project', NOW(), NOW(),
    'https://example.com/edu-project.jpg',
    '0x2222222222222222222222222222222222222222', true, 5, 1,
    2500.0, 50, true, true, 'Listed', false, 85, 0,
    0, 0, 0, 1, 0, ARRAY['education-initiative']
),
(
    'Healthcare Access Program', 'healthcare-access-program',
    'Providing healthcare access to remote and underserved areas.',
    'Healthcare access initiative',
    'https://example.com/health-project', NOW(), NOW(),
    'https://example.com/health-project.jpg',
    '0x3333333333333333333333333333333333333333', false, 5, 1,
    750.0, 15, true, false, 'Listed', false, 75, 0,
    0, 0, 0, 1, 0, ARRAY['healthcare-access-program']
),
(
    'Technology for Good', 'technology-for-good',
    'Using technology to solve social problems and improve lives.',
    'Technology solutions for social impact',
    'https://example.com/tech-project', NOW(), NOW(),
    'https://example.com/tech-project.jpg',
    '0x4444444444444444444444444444444444444444', true, 5, 1,
    3200.0, 80, true, true, 'Listed', false, 90, 0,
    0, 0, 0, 1, 0, ARRAY['technology-for-good']
),
(
    'Community Development Fund', 'community-development-fund',
    'Supporting local community development projects and initiatives.',
    'Community development support',
    'https://example.com/community-project', NOW(), NOW(),
    'https://example.com/community-project.jpg',
    '0x5555555555555555555555555555555555555555', false, 5, 1,
    500.0, 10, true, false, 'Listed', false, 70, 0,
    0, 0, 0, 1, 0, ARRAY['community-development-fund']
) ON CONFLICT ("slug") DO NOTHING;

-- Refresh the materialized view
REFRESH MATERIALIZED VIEW public.project_instant_power_view;

-- Create sample projects for testing
-- This script adds sample projects to the database

-- First, let's check if we have any projects
SELECT COUNT(*) as total_projects FROM project;

-- Insert sample projects if database is empty
INSERT INTO project (
    title, 
    slug, 
    description, 
    "descriptionSummary",
    image,
    "creationDate",
    "updatedAt",
    "adminUserId",
    "statusId",
    "isActive",
    verified,
    listed,
    "reviewStatus",
    "totalDonations",
    "totalReactions",
    "totalProjectUpdates",
    "qualityScore",
    "slugHistory"
) VALUES 
(
    'Technology for Good Initiative',
    'technology-for-good',
    'A comprehensive project focused on leveraging technology to solve social and environmental challenges. We develop innovative solutions that bridge the gap between cutting-edge technology and real-world problems.',
    'Leveraging technology to solve social and environmental challenges through innovative solutions.',
    'https://example.com/tech-project.jpg',
    NOW(),
    NOW(),
    1, -- Assuming admin user ID 1 exists
    5, -- Active status
    true,
    false,
    true,
    'Listed',
    0,
    0,
    0,
    80,
    ARRAY['technology-for-good']
),
(
    'Environmental Conservation Project',
    'sample-environmental-project',
    'Dedicated to protecting and restoring natural ecosystems through community-driven conservation efforts and sustainable practices.',
    'Community-driven environmental conservation and ecosystem restoration.',
    'https://example.com/env-project.jpg',
    NOW(),
    NOW(),
    1,
    5,
    true,
    false,
    true,
    'Listed',
    0,
    0,
    0,
    75,
    ARRAY['sample-environmental-project']
),
(
    'Education Access Initiative',
    'education-access-initiative',
    'Providing quality education resources and opportunities to underserved communities worldwide through digital platforms and local partnerships.',
    'Quality education resources for underserved communities worldwide.',
    'https://example.com/edu-project.jpg',
    NOW(),
    NOW(),
    1,
    5,
    true,
    false,
    true,
    'Listed',
    0,
    0,
    0,
    85,
    ARRAY['education-access-initiative']
);

-- Verify the projects were created
SELECT id, title, slug, "isActive", verified, listed FROM project WHERE slug IN ('technology-for-good', 'sample-environmental-project', 'education-access-initiative');

-- Show total project count
SELECT COUNT(*) as total_projects_after_insert FROM project;