Documents

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);
    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 * 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);

// 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');