[API-04] Voters API (CRUD for voters, search, filter)

{
  "cost": {
    "input_tokens": 25,
    "estimated_usd": 0.111255,
    "output_tokens": 7412
  },
  "model": "claude-sonnet-4-20250514",
  "status": "success",
  "transport": "anthropic_api",
  "latency_ms": 76426,
  "response_text": "I'll create a comprehensive Voters API with full CRUD operations, search, and filtering capabilities.\n\n## Voters API Implementation\n\n### 1. Database Schema\n\n```sql\n-- Create voters table\nCREATE TABLE voters (\n    id SERIAL PRIMARY KEY,\n    voter_id VARCHAR(20) UNIQUE NOT NULL,\n    first_name VARCHAR(100) NOT NULL,\n    last_name VARCHAR(100) NOT NULL,\n    email VARCHAR(255) UNIQUE,\n    phone VARCHAR(20),\n    date_of_birth DATE NOT NULL,\n    gender VARCHAR(10),\n    address TEXT,\n    city VARCHAR(100),\n    state VARCHAR(50),\n    zip_code VARCHAR(10),\n    registration_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n    status VARCHAR(20) DEFAULT 'active',\n    precinct_id INTEGER,\n    party_affiliation VARCHAR(50),\n    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n    updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP\n);\n\n-- Create indexes for better search performance\nCREATE INDEX idx_voters_name ON voters(first_name, last_name);\nCREATE INDEX idx_voters_email ON voters(email);\nCREATE INDEX idx_voters_status ON voters(status);\nCREATE INDEX idx_voters_city ON voters(city);\nCREATE INDEX idx_voters_state ON voters(state);\nCREATE INDEX idx_voters_precinct ON voters(precinct_id);\nCREATE INDEX idx_voters_party ON voters(party_affiliation);\nCREATE INDEX idx_voters_registration_date ON voters(registration_date);\n```\n\n### 2. Data Models\n\n```javascript\n// models/Voter.js\nconst { DataTypes } = require('sequelize');\nconst sequelize = require('../config/database');\n\nconst Voter = sequelize.define('Voter', {\n    id: {\n        type: DataTypes.INTEGER,\n        primaryKey: true,\n        autoIncrement: true\n    },\n    voterId: {\n        type: DataTypes.STRING(20),\n        allowNull: false,\n        unique: true,\n        field: 'voter_id'\n    },\n    firstName: {\n        type: DataTypes.STRING(100),\n        allowNull: false,\n        field: 'first_name'\n    },\n    lastName: {\n        type: DataTypes.STRING(100),\n        allowNull: false,\n        field: 'last_name'\n    },\n    email: {\n        type: DataTypes.STRING(255),\n        unique: true,\n        validate: {\n            isEmail: true\n        }\n    },\n    phone: {\n        type: DataTypes.STRING(20)\n    },\n    dateOfBirth: {\n        type: DataTypes.DATEONLY,\n        allowNull: false,\n        field: 'date_of_birth'\n    },\n    gender: {\n        type: DataTypes.STRING(10),\n        validate: {\n            isIn: [['male', 'female', 'other', 'prefer_not_to_say']]\n        }\n    },\n    address: {\n        type: DataTypes.TEXT\n    },\n    city: {\n        type: DataTypes.STRING(100)\n    },\n    state: {\n        type: DataTypes.STRING(50)\n    },\n    zipCode: {\n        type: DataTypes.STRING(10),\n        field: 'zip_code'\n    },\n    registrationDate: {\n        type: DataTypes.DATE,\n        defaultValue: DataTypes.NOW,\n        field: 'registration_date'\n    },\n    status: {\n        type: DataTypes.STRING(20),\n        defaultValue: 'active',\n        validate: {\n            isIn: [['active', 'inactive', 'suspended', 'pending']]\n        }\n    },\n    precinctId: {\n        type: DataTypes.INTEGER,\n        field: 'precinct_id'\n    },\n    partyAffiliation: {\n        type: DataTypes.STRING(50),\n        field: 'party_affiliation'\n    }\n}, {\n    tableName: 'voters',\n    timestamps: true,\n    underscored: true\n});\n\nmodule.exports = Voter;\n```\n\n### 3. Voter Controller\n\n```javascript\n// controllers/voterController.js\nconst Voter = require('../models/Voter');\nconst { Op } = require('sequelize');\nconst { validationResult } = require('express-validator');\n\nclass VoterController {\n    // Create a new voter\n    async createVoter(req, res) {\n        try {\n            const errors = validationResult(req);\n            if (!errors.isEmpty()) {\n                return res.status(400).json({\n                    success: false,\n                    errors: errors.array()\n                });\n            }\n\n            const voter = await Voter.create(req.body);\n            \n            res.status(201).json({\n                success: true,\n                message: 'Voter created successfully',\n                data: voter\n            });\n        } catch (error) {\n            if (error.name === 'SequelizeUniqueConstraintError') {\n                return res.status(409).json({\n                    success: false,\n                    message: 'Voter ID or email already exists'\n                });\n            }\n            \n            res.status(500).json({\n                success: false,\n                message: 'Error creating voter',\n                error: error.message\n            });\n        }\n    }\n\n    // Get all voters with search and filter\n    async getVoters(req, res) {\n        try {\n            const {\n                page = 1,\n                limit = 10,\n                search,\n                status,\n                city,\n                state,\n                partyAffiliation,\n                precinctId,\n                minAge,\n                maxAge,\n                gender,\n                sortBy = 'createdAt',\n                sortOrder = 'DESC'\n            } = req.query;\n\n            const offset = (page - 1) * limit;\n            const whereClause = {};\n\n            // Search functionality\n            if (search) {\n                whereClause[Op.or] = [\n                    { firstName: { [Op.iLike]: `%${search}%` } },\n                    { lastName: { [Op.iLike]: `%${search}%` } },\n                    { email: { [Op.iLike]: `%${search}%` } },\n                    { voterId: { [Op.iLike]: `%${search}%` } }\n                ];\n            }\n\n            // Filter by status\n            if (status) {\n                whereClause.status = status;\n            }\n\n            // Filter by location\n            if (city) {\n                whereClause.city = { [Op.iLike]: `%${city}%` };\n            }\n\n            if (state) {\n                whereClause.state = state;\n            }\n\n            // Filter by party affiliation\n            if (partyAffiliation) {\n                whereClause.partyAffiliation = partyAffiliation;\n            }\n\n            // Filter by precinct\n            if (precinctId) {\n                whereClause.precinctId = precinctId;\n            }\n\n            // Filter by gender\n            if (gender) {\n                whereClause.gender = gender;\n            }\n\n            // Age filtering\n            if (minAge || maxAge) {\n                const currentDate = new Date();\n                if (minAge) {\n                    const maxBirthDate = new Date(currentDate.getFullYear() - minAge, \n                                                 currentDate.getMonth(), \n                                                 currentDate.getDate());\n                    whereClause.dateOfBirth = { [Op.lte]: maxBirthDate };\n                }\n                if (maxAge) {\n                    const minBirthDate = new Date(currentDate.getFullYear() - maxAge - 1, \n                                                 currentDate.getMonth(), \n                                                 currentDate.getDate());\n                    whereClause.dateOfBirth = { \n                        ...whereClause.dateOfBirth,\n                        [Op.gte]: minBirthDate \n                    };\n                }\n            }\n\n            const { count, rows: voters } = await Voter.findAndCountAll({\n                where: whereClause,\n                limit: parseInt(limit),\n                offset: parseInt(offset),\n                order: [[sortBy, sortOrder.toUpperCase()]],\n                attributes: { exclude: ['createdAt', 'updatedAt'] }\n            });\n\n            const totalPages = Math.ceil(count / limit);\n\n            res.json({\n                success: true,\n                data: {\n                    voters,\n                    pagination: {\n                        currentPage: parseInt(page),\n                        totalPages,\n                        totalRecords: count,\n                        limit: parseInt(limit),\n                        hasNext: page < totalPages,\n                        hasPrev: page > 1\n                    }\n                }\n            });\n        } catch (error) {\n            res.status(500).json({\n                success: false,\n                message: 'Error fetching voters',\n                error: error.message\n            });\n        }\n    }\n\n    // Get voter by ID\n    async getVoterById(req, res) {\n        try {\n            const { id } = req.params;\n            const voter = await Voter.findByPk(id);\n\n            if (!voter) {\n                return res.status(404).json({\n                    success: false,\n                    message: 'Voter not found'\n                });\n            }\n\n            res.json({\n                success: true,\n                data: voter\n            });\n        } catch (error) {\n            res.status(500).json({\n                success: false,\n                message: 'Error fetching voter',\n                error: error.message\n            });\n        }\n    }\n\n    // Get voter by voter ID\n    async getVoterByVoterId(req, res) {\n        try {\n            const { voterId } = req.params;\n            const voter = await Voter.findOne({ where: { voterId } });\n\n            if (!voter) {\n                return res.status(404).json({\n                    success: false,\n                    message: 'Voter not found'\n                });\n            }\n\n            res.json({\n                success: true,\n                data: voter\n            });\n        } catch (error) {\n            res.status(500).json({\n                success: false,\n                message: 'Error fetching voter',\n                error: error.message\n            });\n        }\n    }\n\n    // Update voter\n    async updateVoter(req, res) {\n        try {\n            const errors = validationResult(req);\n            if (!errors.isEmpty()) {\n                return res.status(400).json({\n                    success: false,\n                    errors: errors.array()\n                });\n            }\n\n            const { id } = req.params;\n            const voter = await Voter.findByPk(id);\n\n            if (!voter) {\n                return res.status(404).json({\n                    success: false,\n                    message: 'Voter not found'\n                });\n            }\n\n            await voter.update(req.body);\n\n            res.json({\n                success: true,\n                message: 'Voter updated successfully',\n                data: voter\n            });\n        } catch (error) {\n            if (error.name === 'SequelizeUniqueConstraintError') {\n                return res.status(409).json({\n                    success: false,\n                    message: 'Voter ID or email already exists'\n                });\n            }\n\n            res.status(500).json({\n                success: false,\n                message: 'Error updating voter',\n                error: error.message\n            });\n        }\n    }\n\n    // Delete voter (soft delete by changing status)\n    async deleteVoter(req, res) {\n        try {\n            const { id } = req.params;\n            const voter = await Voter.findByPk(id);\n\n            if (!voter) {\n                return res.status(404).json({\n                    success: false,\n                    message: 'Voter not found'\n                });\n            }\n\n            // Soft delete by changing status\n            await voter.update({ status: 'inactive' });\n\n            res.json({\n                success: true,\n                message: 'Voter deactivated successfully'\n            });\n        } catch (error) {\n            res.status(500).json({\n                success: false,\n                message: 'Error deleting voter',\n                error: error.message\n            });\n        }\n    }\n\n    // Permanently delete voter\n    async permanentDeleteVoter(req, res) {\n        try {\n            const { id } = req.params;\n            const voter = await Voter.findByPk(id);\n\n            if (!voter) {\n                return res.status(404).json({\n                    success: false,\n                    message: 'Voter not found'\n                });\n            }\n\n            await voter.destroy();\n\n            res.json({\n                success: true,\n                message: 'Voter permanently deleted'\n            });\n        } catch (error) {\n            res.status(500).json({\n                success: false,\n                message: 'Error permanently deleting voter',\n                error: error.message\n            });\n        }\n    }\n\n    // Bulk operations\n    async bulkCreateVoters(req, res) {\n        try {\n            const { voters } = req.body;\n\n            if (!Array.isArray(voters) || voters.length === 0) {\n                return res.status(400).json({\n                    success: false,\n                    message: 'Voters array is required'\n                });\n            }\n\n            const createdVoters = await Voter.bulkCreate(voters, {\n                validate: true,\n                ignoreDuplicates: false\n            });\n\n            res.status(201).json({\n                success: true,\n                message: `${createdVoters.length} voters created successfully`,\n                data: createdVoters\n            });\n        } catch (error) {\n            res.status(500).json({\n                success: false,\n                message: 'Error creating voters',\n                error: error.message\n            });\n        }\n    }\n\n    // Get voter statistics\n    async getVoterStatistics(req, res) {\n        try {\n            const totalVoters = await Voter.count();\n            const activeVoters = await Voter.count({ where: { status: 'active' } });\n            \n            // Group by party affiliation\n            const partyStats = await Voter.findAll({\n                attributes: [\n                    'partyAffiliation',\n                    [sequelize.fn('COUNT', sequelize.col('id')), 'count']\n                ],\n                group: ['partyAffiliation'],\n                raw: true\n            });\n\n            // Group by state\n            const stateStats = await Voter.findAll({\n                attributes: [\n                    'state',\n                    [sequelize.fn('COUNT', sequelize.col('id')), 'count']\n                ],\n                group: ['state'],\n                order: [[sequelize.fn('COUNT', sequelize.col('id')), 'DESC']],\n                raw: true\n            });\n\n            // Age distribution\n            const currentYear = new Date().getFullYear();\n            const ageGroups = await Voter.findAll({\n                attributes: [\n                    [sequelize.fn('CASE',\n                        sequelize.literal(`WHEN ${currentYear} - EXTRACT(YEAR FROM date_of_birth) BETWEEN 18 AND 29 THEN '18-29'`),\n                        sequelize.literal(`WHEN ${currentYear} - EXTRACT(YEAR FROM date_of_birth) BETWEEN 30 AND 44 THEN '30-44'`),\n                        sequelize.literal(`WHEN ${currentYear} - EXTRACT(YEAR FROM date_of_birth) BETWEEN 45 AND 64 THEN '45-64'`),\n                        sequelize.literal(`ELSE '65+'`)), 'ageGroup'],\n                    [sequelize.fn('COUNT', sequelize.col('id')), 'count']\n                ],\n                group: ['ageGroup'],\n                raw: true\n            });\n\n            res.json({\n                success: true,\n                data: {\n                    summary: {\n                        totalVoters,\n                        activeVoters,\n                        inactiveVoters: totalVoters - activeVoters\n                    },\n                    partyDistribution: partyStats,\n                    stateDistribution: stateStats,\n                    ageDistribution: ageGroups\n                }\n            });\n        } catch (error) {\n            res.status(500).json({\n                success: false,\n                message: 'Error fetching voter statistics',\n                error: error.message\n            });\n        }\n    }\n}\n\nmodule.exports = new VoterController();\n```\n\n### 4. Validation Middleware\n\n```javascript\n// middleware/voterValidation.js\nconst { body, query } = require('express-validator');\n\nconst voterValidationRules = () => {\n    return [\n        body('voterId')\n            .notEmpty()\n            .withMessage('Voter ID is required')\n            .isLength({ max: 20 })\n            .withMessage('Voter ID must be less than 20 characters'),\n        \n        body('firstName')\n            .notEmpty()\n            .withMessage('First name is required')\n            .isLength({ max: 100 })\n            .withMessage('First name must be less than 100 characters'),\n        \n        body('lastName')\n            .notEmpty()\n            .withMessage('Last name is required')\n            .isLength({ max: 100 })\n            .withMessage('Last name must be less than 100 characters'),\n        \n        body('email')\n            .optional()\n            .isEmail()\n            .withMessage('Must be a valid email address'),\n        \n        body('phone')\n            .optional()\n            .isMobilePhone()\n            .withMessage('Must be a valid phone number'),\n        \n        body('dateOfBirth')\n            .isDate()\n            .withMessage('Must be a valid date')\n            .custom((value) => {\n                const birthDate = new Date(value);\n                const today = new Date();\n                const age = today.getFullYear() - birthDate.getFullYear();\n                \n                if (age < 18) {\n                    throw new Error('Voter must be at least 18 years old');\n                }\n                return true;\n            }),\n        \n        body('gender')\n            .optional()\n            .isIn(['male', 'female', 'other', 'prefer_not_to_say'])\n            .withMessage('Invalid gender value'),\n        \n        body('status')\n            .optional()\n            .isIn(['active', 'inactive', 'suspended', 'pending'])\n            .withMessage('Invalid status value'),\n        \n        body('zipCode')\n            .optional()\n            .matches(/^\\d{5}(-\\d{4})?$/)\n            .withMessage('Invalid ZIP code format')\n    ];\n};\n\nconst voterQueryValidation = () => {\n    return [\n        query('page')\n            .optional()\n            .isInt({ min: 1 })\n            .withMessage('Page must be a positive integer'),\n        \n        query('limit')\n            .optional()\n            .isInt({ min: 1, max: 100 })\n            .withMessage('Limit must be between 1 and 100'),\n        \n        query('minAge')\n            .optional()\n            .isInt({ min: 18, max: 120 })\n            .withMessage('Minimum age must be between 18 and 120'),\n        \n        query('maxAge')\n            .optional()\n            .isInt({ min: 18, max: 120 })\n            .withMessage('Maximum age must be between 18 and 120'),\n        \n        query('sortBy')\n            .optional()\n            .isIn(['firstName', 'lastName', 'registrationDate', 'createdAt'])\n            .withMessage('Invalid sort field'),\n        \n        query('sortOrder')\n            .optional()\n            .isIn(['ASC', 'DESC', 'asc', 'desc'])\n            .withMessage('Sort order must be ASC or DESC')\n    ];\n};\n\nmodule.exports = {\n    voterValidationRules,\n    voterQueryValidation\n};\n```\n\n### 5. Routes\n\n```javascript\n// routes/voters.js\nconst express = require('express');\nconst router = express.Router();\nconst voterController = require('../controllers/voterController');\nconst { voterValidationRules, voterQueryValidation } = require('../middleware/voterValidation');\nconst auth = require('../middleware/auth');\nconst rateLimit = require('../middleware/rateLimit');\n\n// Apply authentication and rate limiting to all routes\nrouter.use(auth);\nrouter.use(rateLimit);\n\n// GET /api/voters - Get all voters with search and filter\nrouter.get('/', voterQueryValidation(), voterController.getVoters);\n\n// GET /api/voters/statistics - Get voter statistics\nrouter.get('/statistics', voterController.getVoterStatistics);\n\n// GET /api/voters/:id - Get voter by ID\nrouter.get('/:id', voterController.getVoterById);\n\n// GET /api/voters/voter-id/:voterId - Get voter by voter ID\nrouter.get('/voter-id/:voterId', voterController.getVoterByVoterId);\n\n// POST /api/voters - Create new voter\nrouter.post('/', voterValidationRules(), voterController.createVoter);\n\n// POST /api/voters/bulk - Bulk create voters\nrouter.post('/bulk', voterController.bulkCreateVoters);\n\n// PUT /api/voters/:id - Update voter\nrouter.put('/:id', voterValidationRules(), voterController.updateVoter);\n\n// DELETE /api/voters/:id - Soft delete voter\nrouter.delete('/:id', voterController.deleteVoter);\n\n// DELETE /api/voters/:id/permanent - Permanently delete voter\nrouter.delete('/:id/permanent', voterController.permanentDeleteVoter);\n\nmodule.exports = router;\n```\n\n### 6. Advanced Search Service\n\n```javascript\n// services/voterSearchService.js\nconst Voter = require('../models/Voter');\nconst { Op } = require('sequelize');\n\nclass VoterSearchService {\n    async advancedSearch(searchParams) {\n        const {\n            fullName,\n            address,\n            ageRange,\n            registrationDateRange,\n            multipleStates,\n            excludeStatus\n        } = searchParams;\n\n        const whereClause = {};\n\n        // Full name search (first name + last name)\n        if (fullName) {\n            const names = fullName.trim().split(' ');\n            if (names.length === 1) {\n                whereClause[Op.or] = [\n                    { firstName: { [Op.iLike]: `%${names[0]}%` } },\n                    { lastName: { [Op.iLike]: `%${names[0]}%` } }\n                ];\n            } else if (names.length >= 2) {\n                whereClause[Op.and] = [\n                    { firstName: { [Op.iLike]: `%${names[0]}%` } },\n                    { lastName: { [Op.iLike]: `%${names[names.length - 1]}%` } }\n                ];\n            }\n        }\n\n        // Address search\n        if (address) {\n            whereClause[Op.or] = [\n                { address: { [Op.iLike]: `%${address}%` } },\n                { city: { [Op.iLike]: `%${address}%` } },\n                { state: { [Op.iLike]: `%${address}%` } },\n                { zipCode: { [Op.iLike]: `%${address}%` } }\n            ];\n        }\n\n        // Age range\n        if (ageRange) {\n            const currentDate = new Date();\n            const { min, max } = ageRange;\n            \n            if (min || max) {\n                const dateConstraints = {};\n                if (min) {\n                    const maxBirthDate = new Date(currentDate.getFullYear() - min, \n                                                 currentDate.getMonth(), \n                                                 currentDate.getDate());\n                    dateConstraints[Op.lte] = maxBirthDate;\n                }\n                if (max) {\n                    const minBirthDate = new Date(currentDate.getFullYear() - max - 1, \n                                                 currentDate.getMonth(), \n                                                 currentDate.getDate());\n                    dateConstraints[Op.gte] = minBirthDate;\n                }\n                whereClause.dateOfBirth = dateConstraints;\n            }\n        }\n\n        // Registration date range\n        if (registrationDateRange) {\n            const { startDate, endDate } = registrationDateRange;\n            const dateConstraints = {};\n            \n            if (startDate) dateConstraints[Op.gte] = new Date(startDate);\n            if (endDate) dateConstraints[Op.lte] = new Date(endDate);\n            \n            if (Object.keys(dateConstraints).length > 0) {\n                whereClause.registrationDate = dateConstraints;\n            }\n        }\n\n        // Multiple states\n        if (multipleStates && Array.isArray(multipleStates)) {\n            whereClause.state = { [Op.in]: multipleStates };\n        }\n\n        // Exclude certain statuses\n        if (excludeStatus && Array.isArray(excludeStatus)) {\n            whereClause.status = { [Op.notIn]: excludeStatus };\n        }\n\n        return whereClause;\n    }\n\n    async searchSimilarVoters(voterData) {\n        const { firstName, lastName, dateOfBirth, address } = voterData;\n        \n        const similarVoters = await Voter.findAll({\n            where: {\n                [Op.or]: [\n                    // Exact name match\n                    {\n                        [Op.and]: [\n                            { firstName: { [Op.iLike]: firstName } },\n                            { lastName: { [Op.iLike]: lastName } }\n                        ]\n                    },\n                    // Similar name with same birth date\n                    {\n                        [Op.and]: [\n                            {\n                                [Op.or]: [\n                                    { firstName: { [Op.iLike]: `%${firstName}%` } },\n                                    { lastName: { [Op.iLike]: `%${lastName}%` } }\n                                ]\n                            },\n                            { dateOfBirth }\n                        ]\n                    },\n                    // Same address\n                    address ? { address: { [Op.iLike]: `%${address}%` } } : null\n                ].filter(Boolean)\n            },\n            limit: 10\n        });\n\n        return similarVoters;\n    }\n\n    async getVotersByLocation(lat, lng, radiusKm = 10) {\n        // This would require PostGIS extension for PostgreSQL\n        // For now, implementing a basic city/state search\n        const voters = await Voter.findAll({\n            // This is a simplified version - in production you'd use geographic queries\n            order: [['city', 'ASC'], ['state', 'ASC']],\n            limit: 100\n        });\n\n        return voters;\n    }\n}\n\nmodule.exports = new VoterSearchService();\n```\n\n### 7. Usage Examples\n\n```javascript\n// Example API calls\n\n// 1. Get all voters with pagination\nGET /api/voters?page=1&limit=20\n\n// 2. Search voters by name\nGET /api/voters?search=John\n\n// 3. Filter by multiple criteria\nGET /api/voters?status=active&state=California&partyAffiliation=Democratic&minAge=25&maxAge=65\n\n// 4. Create a new voter\nPOST /api/voters\n{\n    \"voterId\": \"CA123456789\",\n    \"firstName\": \"John\",\n    \"lastName\": \"Doe\",\n    \"email\": \"john.doe@email.com\",\n    \"phone\": \"+1234567890\",\n    \"dateOfBirth\": \"1985-06-15\",\n    \"gender\": \"male\",\n    \"address\": \"123 Main St\",\n    \"city\": \"Los Angeles\",\n    \"state\": \"California\",\n    \"zipCode\": \"90210\",\n    \"partyAffiliation\": \"Independent\"\n}\n\n// 5. Bulk create voters\nPOST /api/voters/bulk\n{\n    \"voters\": [\n        {\n            \"voterId\": \"CA123456790\",\n            \"firstName\": \"Jane\",\n            \"lastName\": \"Smith\",\n            // ... other fields\n        },\n        {\n            \"voterId\": \"CA123456791\",\n            \"firstName\": \"Bob\",\n            \"lastName\": \"Johnson\",\n            // ... other fields\n        }\n    ]\n}\n\n// 6. Update voter\nPUT /api/voters/1\n{\n    \"email\": \"newemail@example.com\",\n    \"phone\": \"+1987654321\"\n}\n\n// 7. Get voter statistics\nGET /api/voters/statistics\n\n// 8. Advanced filtering with sorting\nGET /api/voters?city=Los Angeles&sortBy=lastName&sortOrder=ASC&limit=50\n```\n\nThis comprehensive Voters API provides:\n\n1. **Full CRUD Operations**: Create, read, update, and delete voters\n2. **Advanced Search**: Search by name, email, voter ID, and other fields\n3. **Flexible Filtering**: Filter by status, location, party affiliation, age, etc.\n4. **Pagination**: Efficient pagination for large datasets\n5. **Bulk Operations**: Bulk create multiple voters\n6. **Statistics**: Get voter demographics and statistics\n7. **Data Validation**: Comprehensive input validation\n8. **Soft Delete**: Option for soft delete (deactivation) or permanent deletion\n9. **Performance Optimization**: Database indexes for faster queries\n10. **Security**: Authentication and rate limiting middleware\n\nThe API is designed to handle large volumes of voter data efficiently while maintaining security and data integrity."
}