$ su -
암호:
[root:/root]#su -l postgres
-bash-4.1$ psql postgres
psql (10.7)
도움말을 보려면 "help"를 입력하십시오.
postgres=# create database sqlgraphdb owner agraph;
CREATE DATABASE
postgres=# \q
-bash-4.1$ exit
logout
[root:/root]#exit
logout
$ psql -h localhost -U agraph sqlgraphdb
agraph 사용자의 암호:
psql (10.7)
도움말을 보려면 "help"를 입력하십시오.
sqlgraphdb=> \q
$
$ bin/gremlin.sh
3월 06, 2019 3:35:55 오후 java.util.prefs.FileSystemPreferences$1 run
정보: Created user preferences directory.
\,,,/
(o o)
-----oOOo-(3)-oOOo-----
plugin activated: tinkerpop.server
plugin activated: tinkerpop.utilities
plugin activated: tinkerpop.tinkergraph
gremlin> :install org.umlg sqlg-postgres 2.0.1
==>Conflicting module versions. Module [groovy-swing is loaded in version 2.4.16 and you are trying to load version 2.4.15
gremlin> :quit
$
https://github.com/blazegraph/tinkerpop3/issues/4#issuecomment-281932805
https://github.com/blazegraph/tinkerpop3/issues/4#issuecomment-281932805
$ mkdir temp
$ mv gremlin-console/lib/groovy-swing-2.4.16.jar temp/
$ mv gremlin-console/lib/groovy-jsr223-2.4.16-indy.jar temp/
$ mv gremlin-console/lib/groovy-xml-2.4.16.jar temp/
$ vi ~/.groovy/grapeConfig.xml
<ivysettings>
<settings defaultResolver="downloadGrapes"/>
<resolvers>
<chain name="downloadGrapes">
<filesystem name="cachedGrapes">
<ivy pattern="${user.home}/.groovy/grapes/[organisation]/[module]/ivy-[revision].xml"/>
<artifact pattern="${user.home}/.groovy/grapes/[organisation]/[module]/[type]s/[artifact]-[revision].[ext]"/>
</filesystem>
<ibiblio name="local" root="file:${user.home}/.m2/repository/" m2compatible="true"/>
<ibiblio name="codehaus" root="http://repository.codehaus.org/" m2compatible="true"/>
<ibiblio name="central" root="http://central.maven.org/maven2/" m2compatible="true"/>
<ibiblio name="jitpack" root="https://jitpack.io" m2compatible="true"/>
<ibiblio name="java.net2" root="http://download.java.net/maven/2/" m2compatible="true"/>
</chain>
</resolvers>
</ivysettings>
$ cd gremlin-console/
$ bin/gremlin.sh
\,,,/
(o o)
-----oOOo-(3)-oOOo-----
plugin activated: tinkerpop.server
plugin activated: tinkerpop.utilities
plugin activated: tinkerpop.tinkergraph
gremlin> :install org.umlg sqlg-postgres 2.0.1
==>a module with the name sqlg-postgres is already installed
gremlin> :plugin list
==>tinkerpop.server[active]
==>tinkerpop.gephi
==>tinkerpop.utilities[active]
==>tinkerpop.sugar
==>tinkerpop.credentials
==>sqlg.postgres
==>tinkerpop.tinkergraph[active]
gremlin> :plugin use sqlg.postgres
==>sqlg.postgres activated
gremlin> :quit
$
jdbc.url=jdbc:postgresql://localhost:5432/sqlgraphdb
jdbc.username=agraph
jdbc.password=********
</code></pre>
<!-- /wp:code -->
<!-- wp:code -->
<pre class="wp-block-code"><code>
$ bin/gremlin.sh
\,,,/
(o o)
-----oOOo-(3)-oOOo-----
plugin activated: tinkerpop.server
plugin activated: tinkerpop.utilities
plugin activated: sqlg.postgres
plugin activated: tinkerpop.tinkergraph
gremlin> graph = SqlgGraph.open('conf/sqlg.properties')
==>sqlggraph[SqlGraph] (jdbc:postgresql://localhost:5432/sqlgraphdb) (user = agraph)
gremlin> g = graph.traversal()
==>sqlggraphtraversalsource[sqlggraph[SqlGraph] (jdbc:postgresql://localhost:5432/sqlgraphdb) (user = agraph), standard]
gremlin> graph.io(GraphSONIo.build(GraphSONVersion.V3_0)).readGraph("data/grateful-dead.json")
==>null
gremlin> g.V().groupCount().by(label)
==>[song:584,artist:224]
gremlin> g.E().groupCount().by(label)
==>[followedBy:7047,sungBy:501,writtenBy:501]
gremlin> g.V().limit(1).properties()
==>vp[name->HEY BO DIDDLEY]
==>vp[songType->cover]
==>vp[performances->5]
gremlin> :quit
$