Method runExample

examples/java/bindings/BasicUsage.java:65–136

(String dbPath)

    }

    private static void runExample(String dbPath) {
        // 1. Open database
        System.out.println("1. Opening database...");
        try (GraphLite db = GraphLite.open(dbPath)) {
            System.out.println("   [OK] GraphLite version: " + GraphLite.version() + "\n");

            // 2. Create session
            System.out.println("2. Creating session...");
            String session = db.createSession("admin");
            System.out.println("   [OK] Session created: " + session.substring(0, 20) + "...\n");

            // 3. Create schema and graph
            System.out.println("3. Setting up schema and graph...");
            db.execute(session, "CREATE SCHEMA IF NOT EXISTS /example");
            db.execute(session, "SESSION SET SCHEMA /example");
            db.execute(session, "CREATE GRAPH IF NOT EXISTS social");
            db.execute(session, "SESSION SET GRAPH social");
            System.out.println("   [OK] Schema and graph created\n");

            // 4. Insert data
            System.out.println("4. Inserting data...");
            db.execute(session, "INSERT (:Person {name: 'Alice', age: 30})");
            db.execute(session, "INSERT (:Person {name: 'Bob', age: 25})");
            db.execute(session, "INSERT (:Person {name: 'Charlie', age: 35})");
            System.out.println("   [OK] Inserted 3 persons\n");

            // 5. Query data
            System.out.println("5. Querying: All persons' age and name)");
            QueryResult result = db.query(session,
                "MATCH (p:Person) RETURN p.name as name, p.age as age");
            System.out.println("   Found " + result.getRowCount() + " persons:");
            for (Map<String, Object> row : result.getRows()) {
                System.out.println("   - " + row.get("name") + ": " + row.get("age") + " years old");
            }
            System.out.println();

            // 6. Filter with WHERE
            System.out.println("6. Filtering: Persons older than 25 years in the ascending order of age");
            result = db.query(session,
                "MATCH (p:Person) WHERE p.age > 25 " +
                "RETURN p.name as name, p.age as age ORDER BY p.age ASC");
            System.out.println("   Found " + result.getRowCount() + " persons over 25:");
            for (Map<String, Object> row : result.getRows()) {
                System.out.println("   - " + row.get("name") + ": " + row.get("age") + " years old");
            }
            System.out.println();

            // 7. Aggregation
            System.out.println("7. Aggregation query...");
            result = db.query(session,
                "MATCH (p:Person) RETURN count(p) as total, avg(p.age) as avg_age");
            if (!result.isEmpty()) {
                Map<String, Object> row = result.first();
                System.out.println("   Total persons: " + row.get("total"));
                Object avgAge = row.get("avg_age");
                System.out.println("   Average age: " + (avgAge instanceof Number ? ((Number) avgAge).doubleValue() : avgAge));
            }
            System.out.println();