const coll = database.collection("events");

const event = {
  type: "event",
  name: "Conference",
  createdAt: new Date().toISOString(), // store ISO date string
};

const doc = coll.createDocument(event);
await coll.save(doc);

interface TasksSchema {
    title: string;
    details: {
        location: string;
        duration: number;
        attendees: string[];
    };
    metadata: {
        createdBy: string;
        department: string;
        tags: string[];
    };
};

interface DBSchema {
    tasks: TasksSchema;
}

const config: DatabaseConfig<DBSchema> = {
    name: "mydb",
    version: 1,
    collections: {
        tasks: {}
    }
};

const database = await Database.open(config);
const tasks = database.collections.tasks;

// Create document with nested objects
const doc = tasks.createDocument(null, {
    title: "Project Meeting",
    details: {
        location: "Conference Room A",
        duration: 60,
        attendees: ["Alice", "Bob", "Charlie"]
    },
    metadata: {
        createdBy: "admin",
        department: "Engineering",
        tags: ["important", "recurring"]
    }
});

await tasks.save(doc);

// Access nested properties (note in TypeScript you should use a schema instead)
const meeting = await tasks.getDocument(meta(doc).id);
if (meeting) {
    console.log(`Location: ${meeting.details.location}`);
    console.log(`Duration: ${meeting.details.duration} minutes`);
    console.log(`Created by: ${meeting.metadata.createdBy}`);

    // Modify nested objects
    meeting.details.location = "Conference Room B";
    meeting.metadata.tags.push("urgent");
    await tasks.save(meeting);
}

// Working with arrays

    interface ProjectsSchema {
        name: string;
        team: string[];
        milestones: string[];
        tags: string[];
    };

    interface DBSchema {
        projects: ProjectsSchema;
    }

    const config: DatabaseConfig<DBSchema> = {
        name: "mydb",
        version: 1,
        collections: {
            projects: {}
        }
    };

    const database = await Database.open(config);
    const projects = database.collections.projects;

    // Create document with arrays
    const project = projects.createDocument(null, {
        name: "Mobile App Development",
        team: ["Alice", "Bob", "Charlie"],
        milestones: [
            "Requirements gathering",
            "Design phase",
            "Development",
            "Testing",
            "Deployment"
        ],
        tags: ["mobile", "javascript", "react"]
    });

    await projects.save(project);

    // Access array elements
    const savedProject = await projects.getDocument(meta(project).id);
    if (savedProject) {
        console.log(`First team member: ${savedProject.team[0]}`);
        console.log(`Total milestones: ${savedProject.milestones.length}`);

        // Modify arrays
        savedProject.team.push("Diana");  // Add team member
        savedProject.milestones[2] = "Development (In Progress)";  // Update milestone
        savedProject.tags = savedProject.tags.filter((tag: string) => tag !== "mobile");  // Remove tag

        await projects.save(savedProject);
    }

// Get a document from the collection
const users = database.getCollection("users");
const doc = await users.getDocument(DocID("user-123"));

if (doc) {
// Convert document to JSON string
    const jsonString = JSON.stringify(doc);
    console.log('Document as JSON:', jsonString);

    // Parse JSON string back to object
    const parsedDoc = JSON.parse(jsonString) as CBLDocument;
    console.log('Parsed document:', parsedDoc);

    // You can also stringify with formatting
    const prettyJson = JSON.stringify(doc, null, 2);
    console.log('Pretty JSON:\n', prettyJson);
}

// Execute a query
const query = database.createQuery(`
    SELECT users.* FROM users
    WHERE role = 'admin'
`);

const results = await query.execute();

// Convert results to JSON string
const jsonResults = JSON.stringify(results, null, 2);
console.log('Query results as JSON:', jsonResults);

// Parse JSON back to object
const parsedResults = JSON.parse(jsonResults) as JSONObject[];

// Save query results as documents in Couchbase Lite
const exports = database.getCollection("exports");

for (const row of parsedResults) {
    const userData = row.users;  // Extract user data

    // Create and save as new document
    const exportDoc = exports.createDocument(null, {
        type: 'user_export',
        exportedAt: new Date().toISOString(),
        userData: userData
    });

    await exports.save(exportDoc);
}

console.log('Query results saved as documents');