Skip to content

Latest commit

History

History

README.md

nodejs-pg-age

Example

Initialize on make connection

import{types,Client,QueryResultRow}from"pg";import{setAGETypes}from"../src";constconfig={user: 'postgres',host: '127.0.0.1',database: 'postgres',password: 'postgres',port: 25432,}constclient=newClient(config);awaitclient.connect();awaitsetAGETypes(client,types);awaitclient.query(`SELECT create_graph('age-first-time');`);

Query

awaitclient?.query(` SELECT * from cypher('age-first-time', $$ CREATE (a:Part {part_num: '123'}), (b:Part {part_num: '345'}), (c:Part {part_num: '456'}), (d:Part {part_num: '789'}) $$) as (a agtype);`)constresults: QueryResultRow=awaitclient?.query<QueryResultRow>(` SELECT * from cypher('age-first-time', $$ MATCH (a) RETURN a $$) as (a agtype);`)!

For more information about Apache AGE