neo4jでsandbox その8


概要

neo4jでsandboxやってみた。
fizzbuzz、やってみた。

データ投入


CREATE (p1:i {name:"1"}),
(p2:i {name:"2"}),
(p3:i {name:"3"}),
(p4:i {name:"4"}),
(p5:i {name:"5"}),
(p6:i {name:"6"}),
(p7:i {name:"7"}),
(p8:i {name:"8"}),
(p9:i {name:"9"}),
(p10:i {name:"10"}),
(p11:i {name:"11"}),
(p12:i {name:"12"}),
(p13:i {name:"13"}),
(p14:i {name:"14"}),
(p15:i {name:"15"}),
(p16:i {name:"16"}),
(p17:i {name:"17"}),
(p18:i {name:"18"}),
(p19:i {name:"19"}),
(p20:i {name:"20"}),
(p21:i {name:"21"}),
(p22:i {name:"22"}),
(p23:i {name:"23"}),
(p24:i {name:"24"}),
(p25:i {name:"25"}),
(p26:i {name:"26"}),
(p27:i {name:"27"}),
(p28:i {name:"28"}),
(p29:i {name:"29"}),
(p30:i {name:"30"}),
(p31:i {name:"31"}),
(p32:i {name:"32"}),
(p33:i {name:"33"}),
(p34:i {name:"34"}),
(p35:i {name:"35"}),
(p36:i {name:"36"}),
(p37:i {name:"37"}),
(p38:i {name:"38"}),
(p39:i {name:"39"}),
(p40:i {name:"40"}),
(p41:i {name:"41"}),
(p42:i {name:"42"}),
(p43:i {name:"43"}),
(p44:i {name:"44"}),
(p45:i {name:"45"}),
(p46:i {name:"46"}),
(p47:i {name:"47"}),
(p48:i {name:"48"}),
(p49:i {name:"49"}),
(p50:i {name:"50"}),
(p51:i {name:"51"}),
(p52:i {name:"52"}),
(p53:i {name:"53"}),
(p54:i {name:"54"}),
(p55:i {name:"55"}),
(p56:i {name:"56"}),
(p57:i {name:"57"}),
(p58:i {name:"58"}),
(p59:i {name:"59"}),
(p60:i {name:"60"}),
(p61:i {name:"61"}),
(p62:i {name:"62"}),
(p63:i {name:"63"}),
(p64:i {name:"64"}),
(p65:i {name:"65"}),
(p66:i {name:"66"}),
(p67:i {name:"67"}),
(p68:i {name:"68"}),
(p69:i {name:"69"}),
(p70:i {name:"70"}),
(p71:i {name:"71"}),
(p72:i {name:"72"}),
(p73:i {name:"73"}),
(p74:i {name:"74"}),
(p75:i {name:"75"}),
(p76:i {name:"76"}),
(p77:i {name:"77"}),
(p78:i {name:"78"}),
(p79:i {name:"79"}),
(p80:i {name:"80"}),
(p81:i {name:"81"}),
(p82:i {name:"82"}),
(p83:i {name:"83"}),
(p84:i {name:"84"}),
(p85:i {name:"85"}),
(p86:i {name:"86"}),
(p87:i {name:"87"}),
(p88:i {name:"88"}),
(p89:i {name:"89"}),
(p90:i {name:"90"}),
(p91:i {name:"91"}),
(p92:i {name:"92"}),
(p93:i {name:"93"}),
(p94:i {name:"94"}),
(p95:i {name:"95"}),
(p96:i {name:"96"}),
(p97:i {name:"97"}),
(p98:i {name:"98"}),
(p99:i {name:"99"}),
(pfizzbuzz:i {name:"fizzbuzz"}),
(pbuzz:i {name:"buzz"}),
(pfizz:i {name:"fizz"}),
(p1)-[:Ha]->(p1),
(p2)-[:Ha]->(p2),
(p3)-[:Ha]->(pfizz),
(p4)-[:Ha]->(p4),
(p5)-[:Ha]->(pbuzz),
(p6)-[:Ha]->(pfizz),
(p7)-[:Ha]->(p7),
(p8)-[:Ha]->(p8),
(p9)-[:Ha]->(pfizz),
(p10)-[:Ha]->(pbuzz),
(p11)-[:Ha]->(p11),
(p12)-[:Ha]->(pfizz),
(p13)-[:Ha]->(p13),
(p14)-[:Ha]->(p14),
(p15)-[:Ha]->(pfizzbuzz),
(p16)-[:Ha]->(p16),
(p17)-[:Ha]->(p17),
(p18)-[:Ha]->(pfizz),
(p19)-[:Ha]->(p19),
(p20)-[:Ha]->(pbuzz),
(p21)-[:Ha]->(pfizz),
(p22)-[:Ha]->(p22),
(p23)-[:Ha]->(p23),
(p24)-[:Ha]->(pfizz),
(p25)-[:Ha]->(pbuzz),
(p26)-[:Ha]->(p26),
(p27)-[:Ha]->(pfizz),
(p28)-[:Ha]->(p28),
(p29)-[:Ha]->(p29),
(p30)-[:Ha]->(pfizzbuzz),
(p31)-[:Ha]->(p31),
(p32)-[:Ha]->(p32),
(p33)-[:Ha]->(pfizz),
(p34)-[:Ha]->(p34),
(p35)-[:Ha]->(pbuzz),
(p36)-[:Ha]->(pfizz),
(p37)-[:Ha]->(p37),
(p38)-[:Ha]->(p38),
(p39)-[:Ha]->(pfizz),
(p40)-[:Ha]->(pbuzz),
(p41)-[:Ha]->(p41),
(p42)-[:Ha]->(pfizz),
(p43)-[:Ha]->(p43),
(p44)-[:Ha]->(p44),
(p45)-[:Ha]->(pfizzbuzz),
(p46)-[:Ha]->(p46),
(p47)-[:Ha]->(p47),
(p48)-[:Ha]->(pfizz),
(p49)-[:Ha]->(p49),
(p50)-[:Ha]->(pbuzz),
(p51)-[:Ha]->(pfizz),
(p52)-[:Ha]->(p52),
(p53)-[:Ha]->(p53),
(p54)-[:Ha]->(pfizz),
(p55)-[:Ha]->(pbuzz),
(p56)-[:Ha]->(p56),
(p57)-[:Ha]->(pfizz),
(p58)-[:Ha]->(p58),
(p59)-[:Ha]->(p59),
(p60)-[:Ha]->(pfizzbuzz),
(p61)-[:Ha]->(p61),
(p62)-[:Ha]->(p62),
(p63)-[:Ha]->(pfizz),
(p64)-[:Ha]->(p64),
(p65)-[:Ha]->(pbuzz),
(p66)-[:Ha]->(pfizz),
(p67)-[:Ha]->(p67),
(p68)-[:Ha]->(p68),
(p69)-[:Ha]->(pfizz),
(p70)-[:Ha]->(pbuzz),
(p71)-[:Ha]->(p71),
(p72)-[:Ha]->(pfizz),
(p73)-[:Ha]->(p73),
(p74)-[:Ha]->(p74),
(p75)-[:Ha]->(pfizzbuzz),
(p76)-[:Ha]->(p76),
(p77)-[:Ha]->(p77),
(p78)-[:Ha]->(pfizz),
(p79)-[:Ha]->(p79),
(p80)-[:Ha]->(pbuzz),
(p81)-[:Ha]->(pfizz),
(p82)-[:Ha]->(p82),
(p83)-[:Ha]->(p83),
(p84)-[:Ha]->(pfizz),
(p85)-[:Ha]->(pbuzz),
(p86)-[:Ha]->(p86),
(p87)-[:Ha]->(pfizz),
(p88)-[:Ha]->(p88),
(p89)-[:Ha]->(p89),
(p90)-[:Ha]->(pfizzbuzz),
(p91)-[:Ha]->(p91),
(p92)-[:Ha]->(p92),
(p93)-[:Ha]->(pfizz),
(p94)-[:Ha]->(p94),
(p95)-[:Ha]->(pbuzz),
(p96)-[:Ha]->(pfizz),
(p97)-[:Ha]->(p97),
(p98)-[:Ha]->(p98),
(p99)-[:Ha]->(pfizz)


写真

15のfizzbuzzを求める。

match (:i {name:"15"})-[:Ha]->(m) return m

以上。