Well not more infos in the command. Here again my updated JSON:
Author ETL:
{
"config": {
"log": "debug"
},
"extractor" : {
"jdbc": { "driver": "com.mysql.jdbc.Driver",
"url": "jdbc:mysql://localhost/test",
"userName": "root",
"userPassword": "",
"query": "select * from Author" }
},
"transformers" : [
{ log : { prefix: "BEFORE->" } },
{ "vertex": { "class": "Author"} },
{ log : { prefix: "AFTER->" } }
],
"loader" : {
"orientdb": {
"dbURL": "plocal:D:\Eclipse LaTeX\DB - orientdb\databases\Test6",
dbUser: "root",
dbPassword: "root",
dbAutoDropIfExists: false,
dbAutoCreate: true,
tx: false,
wal: false,
batchCommit: 1000,
dbType: "graph",
indexes: [{class:"Author", fields:["id:string"], type:
"UNIQUE_HASH_INDEX" }]
}
}
}
and output:
D:\Eclipse LaTeX\DB - orientdb\bin>oetl.bat backup\luca\Author.json
OrientDB etl v.1.7.8 (build @BUILD@) www.orientechnologies.com
BEGIN ETL PROCESSOR
BEFORE->{id:1,name:asdd}
AFTER->v(Author)[#11:0]
BEFORE->{id:2,name:aasdasd}
AFTER->v(Author)[#11:1]
END ETL PROCESSOR
+ extracted 3 records (29 records/sec) - 3 records -> loaded 2 vertices (19
vert
ices/sec) Total time: 3103ms [0 warnings, 0 errors]
and the Post/Edge ETL:
{
"config": {
"log": "debug"
},
"extractor" : {
"jdbc": { "driver": "com.mysql.jdbc.Driver",
"url": "jdbc:mysql://localhost/test",
"userName": "root",
"userPassword": "",
"query": "select * from Post" }
},
"transformers" : [
{ log : { prefix: "BEFORE->" } },
{ "vertex": { "class": "Post"} },
{ log : { prefix: "MIDDLE->" } },
{ "edge": { "class": "Wrote", "direction" : "in",
"joinFieldName": "author_id",
"lookup":"Author.id", "unresolvedLinkAction":"WARNING"} },
{ log : { prefix: "AFTER->" } }
],
"loader" : {
"orientdb": {
"dbURL": "plocal:D:\Eclipse LaTeX\DB - orientdb\databases\Test6",
dbUser: "root",
dbPassword: "root",
dbAutoDropIfExists: false,
dbAutoCreate: true,
tx: false,
wal: false,
batchCommit: 1000,
dbType: "graph",
indexes: [{class:"Post", fields:["id:string"], type:
"UNIQUE_HASH_INDEX" }]
}
}
}
and it's output:
D:\Eclipse LaTeX\DB - orientdb\bin>oetl.bat backup\luca\Post.json
OrientDB etl v.1.7.8 (build @BUILD@) www.orientechnologies.com
BEGIN ETL PROCESSOR
BEFORE->{title:jop es klappt,author_id:1,text:wdwd}
MIDDLE->v(Post)[#13:0]
AFTER->v(Post)[#13:0]
BEFORE->{title:aaaa,author_id:2,text:awfwaf}
MIDDLE->v(Post)[#13:1]
AFTER->v(Post)[#13:1]
END ETL PROCESSOR
+ extracted 3 records (0 records/sec) - 3 records -> loaded 2 vertices (0
vertic
es/sec) Total time: 947ms [0 warnings, 0 errors]
--
---
You received this message because you are subscribed to the Google Groups
"OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
