Author: reschke
Date: Tue Oct 27 12:54:27 2015
New Revision: 1710804
URL: http://svn.apache.org/viewvc?rev=1710804&view=rev
Log:
OAK-3532: simple tool for dumping RDB tables (ported to 1.0)
Added:
jackrabbit/oak/branches/1.0/oak-core/src/main/java/org/apache/jackrabbit/oak/plugins/document/rdb/RDBExport.java
- copied, changed from r1709852,
jackrabbit/oak/trunk/oak-core/src/main/java/org/apache/jackrabbit/oak/plugins/document/rdb/RDBExport.java
Modified:
jackrabbit/oak/branches/1.0/ (props changed)
Propchange: jackrabbit/oak/branches/1.0/
------------------------------------------------------------------------------
--- svn:mergeinfo (original)
+++ svn:mergeinfo Tue Oct 27 12:54:27 2015
@@ -1,3 +1,3 @@
/jackrabbit/oak/branches/1.2:1695500,1700753,1709440
-/jackrabbit/oak/trunk:1584578,1584602,1584614,1584616,1584709,1584781,1584937,1585297,1585304-1585305,1585420,1585424,1585427,1585448,1585465,1585468,1585486,1585497,1585509,1585647,1585655-1585656,1585661,1585665-1585666,1585669-1585670,1585673,1585680,1585719,1585763,1585770,1585896,1585904,1585907,1585940,1585949,1585951,1585956,1585962-1585963,1586287,1586320,1586364,1586372,1586655,1586836,1587130,1587224,1587399,1587408,1587472,1587485,1587488,1587538,1587580,1587807,1588033,1588042,1588046,1588066,1588201,1589025,1589101,1589137,1589141,1589263,1589440,1589442,1589484,1589488,1589661,1589664,1589682,1589708,1589741,1589748,1589789,1589794,1589850,1589864,1590628,1590660,1590684,1590697,1590701,1590980,1590988,1591101,1591226,1591229,1591293,1591314,1591317,1591362,1591374,1591381,1591438,1591467,1591552,1591704,1591713,1591715,1591723,1591874,1592487,1592512,1592658,1592665,1592677,1592742,1592744,1592787,1592809,1592955,1593036,1593048,1593061,1593133,1593210-1593211,1593231
,1593245,1593250,1593294,1593304,1593317,1593342,1593554,1594158-1594164,1594166-1594167,1594169,1594237,1594800,1594808,1594835,1594888,1594987,1595147,1595186,1595457,1595856,1596241,1596474,1596534,1596844,1596889,1597569,1597795,1597854,1597860,1598292,1598302,1598352,1598369,1598595,1598631,1598696,1598732,1598797-1598798,1599160,1599299,1599332,1599416,1599434,1599671,1600088,1600935,1601309,1601388,1601578,1601649,1601676,1601757,1601768,1601814,1601833,1601838,1601853,1601878,1601888,1601922,1602156,1602170,1602174,1602179,1602183,1602201,1602207,1602227,1602256,1602261,1602342,1602796-1602797,1602800,1602809,1602853,1602872,1602914,1603155,1603307,1603401,1603441,1603748,1604166,1605030,1605036,1605038,1605292,1605447,1605526,1605670,1605725,1605831,1605852,1606077,1606079,1606087,1606638,1606641,1606644,1606708,1606711,1607031-1607032,1607077,1607127,1607141,1607152,1607185,1607196,1607331,1607362,1607366,1607392,1607526,1607557,1607664,1607737,1608560,1608731,1608783,1609
064,1609081,1609165,1609214,1609488,1610489,1610592,1610603,1610634,1610658,1610664,1611021,1611041,1611270,1611275,1611277,1611313,1611332,1611584,1612560,1612825,1612848,1612892,1612899,1612993,1613018,1613041,1614032,1614265,1614272,1614344-1614345,1614384-1614385,1614397,1614405-1614406,1614574,1614591,1614593,1614596,1614604,1614689,1614807,1614835,1614891,1615417-1615418,1616182,1616236,1616463,1616719,1617417,1617451,1617463,1617711,1618158,1618613,1618624,1618709,1619222,1619411,1619695,1619800,1619808,1619815,1619823-1619824,1620512,1620581,1620585,1620634,1620898,1620905,1621115,1621123-1621124,1621168,1621192,1621201,1621706,1621962,1622197,1622201,1622207,1622250,1622479,1623364,1623766,1623827,1623949,1623969,1623973,1624216,1624317,1624551,1624559,1624973,1624993-1624994,1625025,1625036,1625158,1625224,1625237,1625299,1625348,1625620,1625916,1625962-1625963,1626021,1626053,1626163,1626168,1626175,1626191,1626265,1626770,1627047,1627052,1627228,1627346,1627470,1627473,1
627479,1627503,1627586,1627590,1627715,1627731,1628180,1628198,1628262,1628447,1628608,1629629,1629688,1629840,1629858,1629917,1630055-1630057,1630156,1630299,1630338,1630773,1631283-1631284,1631333-1631334,1631617-1631619,1631630,1631699,1631704,1631711,1631967-1631969,1631986,1631990,1631999,1632002-1632003,1632017,1632258,1632264,1632270,1632293,1632303,1632592,1632605,1633315,1633327,1633389,1633559-1633560,1633562,1633567,1633571,1633598,1633608,1633641,1633687,1633697,1633768,1633783,1634505,1634513,1634774,1634779,1634781,1634792,1634803,1634814,1634816,1634838,1634841,1634852,1634864,1634896,1634898,1635044-1635045,1635060,1635077,1635089,1635102,1635108,1635178,1635218,1635387,1635435,1635518,1635563,1635586,1636336,1636348,1636505,1636585,1636799,1637368,1637382,1637413,1637651,1637815,1638779-1638783,1639260,1639577,1639622,1639963,1639966,1639973,1640134,1640143,1640523,1640555-1640556,1640694-1640695,1640715,1640722-1640723,1640728,1640863-1640872,1641340,1641346,164135
0,1641352,1641541,1641596-1641599,1641601,1641662,1641671,1641695,1641771,1641802,1641811,1641950,1642031,1642056,1642119,1642285,1642648,1642667,1642954,1642959,1643111,1643178,1643186,1643204,1643287,1643767,1643774,1643982,1644016,1644106,1644366,1644383,1644397-1644398,1644407,1644479,1644547,1644552,1644554,1644588,1644645,1644650,1644654,1644689,1644750,1645421,1645424,1645459,1645585,1645611,1645637,1645646,1645660-1645663,1645888,1645901,1645948,1645966,1645970-1645971,1646014,1646164,1646174,1646469,1646684,1646687,1646726-1646728,1646766,1646795,1646981,1649743,1649803,1650015,1650239,1650529,1650797,1651323,1651382,1651643,1651652,1651730,1651988-1651989,1651996,1652024,1652035,1652058-1652059,1652075,1652127,1652158,1652467,1652965,1652971,1652992,1653207,1653446,1653463,1653484,1653572,1653579,1653591,1653804,1653809,1653813,1653848-1653850,1653882,1654116,1654174,1654743,1654756,1654778,1655028,1655049,1655054-1655055,1655086,1655237,1655248,1655996,1656019,1656027,165
6033,1656303,1656394,1656400,1656425,1656427,1656432,1656453,1656628,1656678,1657128,1657132,1657163,1657188,1657265,1657511,1657766,1657804,1658470,1658977,1658983,1659285,1659483,1659527,1659550,1659578,1659765,1660100,1660154-1660155,1660383-1660384,1660409,1660426,1660676,1660870,1660872,1660897,1660903,1661069,1661122,1661146,1661158,1661226,1661630,1661643,1661645,1661988,1662313-1662315,1662323,1662381,1662450,1662456,1663241,1663275,1663288,1663448,1663526,1663528,1663565,1663578,1663614,1663666,1663705,1663730,1663753,1663854,1663927,1664038,1664184,1664228-1664229,1664231,1664381,1664569,1664947,1664987,1665184,1665257,1665271-1665272,1665274-1665275,1665436,1665604,1665634,1665758,1665835,1665892,1665897,1665910,1665918,1666100,1666102,1666177,1666218,1666220,1666351-1666352,1666381,1666384,1666426,1666491,1666787,1667062,1667184,1667293,1667462,1667498,1667502,1667573,1667590,1667696,1667782,1668160,1668275,1668624,1668641,1668645,1668649,1668665,1668671,1668683,1668688,
1668845,1669072,1669096,1669135,1669337,1669361,1669579,1669680,1669989,1670030,1670693,1670705,1671489,1671512,1671773,1671787,1671795,1672055,1672277,1672350,1672468,1672537,1672603,1672642,1672644,1672834-1672835,1673351,1673410,1673431,1673436,1673644,1673662-1673663,1673695,1673713,1673738,1673787,1673791,1674046,1674065,1674075,1674107,1674150,1674780,1675054,1675319,1675332,1675382,1675555,1675566,1676198,1676407,1676458,1676670,1676703,1677579,1677609,1677611,1677774,1677788,1677797,1677804,1677806,1677939,1677991,1678023,1678095-1678096,1678171,1678173,1678211,1678323,1678758,1678938,1678954,1679144,1679147,1679165,1679191,1679232,1679503,1679961,1680170,1680182,1680222,1680232,1680236,1680461,1680633,1680643,1680747,1680805-1680806,1680903,1681282,1681767,1681918,1681955,1682218,1682235,1682437,1682494,1682555,1682855,1682904,1683059,1683089,1683213,1683249,1683259,1683278,1683323,1683687,1683700,1684174,1684376,1684442,1684561,1684570,1684618,1684820,1684836,1684868,16850
23,1685075,1685370,1685552,1685589-1685590,1685840,1685964,1685977,1685989,1685999,1686023,1686032,1686097,1686229,1686234,1686253,1686414,1686780,1686854,1686857,1686971,1687053,1687175,1687196,1687198,1687220,1687239-1687240,1687301,1687441,1687553,1688090,1688179,1688349,1688421,1688436,1688453,1688622,1688636,1688817,1689003-1689004,1689008,1689577,1689581,1689623,1689774,1689810,1689828,1689831,1689833,1689903,1690017,1690043,1690047,1690057,1690247,1690249,1690634-1690637,1690650,1690669,1690674,1690941,1691139,1691159,1691167,1691183,1691188,1691210,1691307,1691331-1691333,1691345,1691384-1691385,1691401,1691509,1692065,1692133,1692156,1692250,1692274,1692363,1692382,1692478,1692955,1693030,1693209,1693421,1693525-1693526,1694007,1694393,1695050,1695122,1695280,1695299,1695540,1696194,1696242,1696285,1696578,1696759,1696916,1697363,1697373,1697410,1697582,1697589,1697616,1697672,1700191,1700231,1700397,1700506,1700571,1700727,1700749,1700769,1700775,1701619,1701733,1701743,17
01750,1701768,1701806,1701810,1701814,1701948,1701955,1701959,1701965,1702014,1702241,1702272,1702423,1702860,1702942,1702960,1703212,1703382,1703395,1703411,1703428,1703430,1703568,1703592,1703758,1703858,1703878,1704256,1704282,1704285,1704457,1704479,1704614,1704629,1704636,1704655,1704670,1704886,1705005,1705027,1705043,1705055,1705250,1705268,1705273,1705323,1705677,1705701,1705871,1706764,1706772,1707049,1707191,1707435,1708105,1708546,1708592,1709012,1710031,1710049,1710559,1710575,1710614,1710637
+/jackrabbit/oak/trunk:1584578,1584602,1584614,1584616,1584709,1584781,1584937,1585297,1585304-1585305,1585420,1585424,1585427,1585448,1585465,1585468,1585486,1585497,1585509,1585647,1585655-1585656,1585661,1585665-1585666,1585669-1585670,1585673,1585680,1585719,1585763,1585770,1585896,1585904,1585907,1585940,1585949,1585951,1585956,1585962-1585963,1586287,1586320,1586364,1586372,1586655,1586836,1587130,1587224,1587399,1587408,1587472,1587485,1587488,1587538,1587580,1587807,1588033,1588042,1588046,1588066,1588201,1589025,1589101,1589137,1589141,1589263,1589440,1589442,1589484,1589488,1589661,1589664,1589682,1589708,1589741,1589748,1589789,1589794,1589850,1589864,1590628,1590660,1590684,1590697,1590701,1590980,1590988,1591101,1591226,1591229,1591293,1591314,1591317,1591362,1591374,1591381,1591438,1591467,1591552,1591704,1591713,1591715,1591723,1591874,1592487,1592512,1592658,1592665,1592677,1592742,1592744,1592787,1592809,1592955,1593036,1593048,1593061,1593133,1593210-1593211,1593231
,1593245,1593250,1593294,1593304,1593317,1593342,1593554,1594158-1594164,1594166-1594167,1594169,1594237,1594800,1594808,1594835,1594888,1594987,1595147,1595186,1595457,1595856,1596241,1596474,1596534,1596844,1596889,1597569,1597795,1597854,1597860,1598292,1598302,1598352,1598369,1598595,1598631,1598696,1598732,1598797-1598798,1599160,1599299,1599332,1599416,1599434,1599671,1600088,1600935,1601309,1601388,1601578,1601649,1601676,1601757,1601768,1601814,1601833,1601838,1601853,1601878,1601888,1601922,1602156,1602170,1602174,1602179,1602183,1602201,1602207,1602227,1602256,1602261,1602342,1602796-1602797,1602800,1602809,1602853,1602872,1602914,1603155,1603307,1603401,1603441,1603748,1604166,1605030,1605036,1605038,1605292,1605447,1605526,1605670,1605725,1605831,1605852,1606077,1606079,1606087,1606638,1606641,1606644,1606708,1606711,1607031-1607032,1607077,1607127,1607141,1607152,1607185,1607196,1607331,1607362,1607366,1607392,1607526,1607557,1607664,1607737,1608560,1608731,1608783,1609
064,1609081,1609165,1609214,1609488,1610489,1610592,1610603,1610634,1610658,1610664,1611021,1611041,1611270,1611275,1611277,1611313,1611332,1611584,1612560,1612825,1612848,1612892,1612899,1612993,1613018,1613041,1614032,1614265,1614272,1614344-1614345,1614384-1614385,1614397,1614405-1614406,1614574,1614591,1614593,1614596,1614604,1614689,1614807,1614835,1614891,1615417-1615418,1616182,1616236,1616463,1616719,1617417,1617451,1617463,1617711,1618158,1618613,1618624,1618709,1619222,1619411,1619695,1619800,1619808,1619815,1619823-1619824,1620512,1620581,1620585,1620634,1620898,1620905,1621115,1621123-1621124,1621168,1621192,1621201,1621706,1621962,1622197,1622201,1622207,1622250,1622479,1623364,1623766,1623827,1623949,1623969,1623973,1624216,1624317,1624551,1624559,1624973,1624993-1624994,1625025,1625036,1625158,1625224,1625237,1625299,1625348,1625620,1625916,1625962-1625963,1626021,1626053,1626163,1626168,1626175,1626191,1626265,1626770,1627047,1627052,1627228,1627346,1627470,1627473,1
627479,1627503,1627586,1627590,1627715,1627731,1628180,1628198,1628262,1628447,1628608,1629629,1629688,1629840,1629858,1629917,1630055-1630057,1630156,1630299,1630338,1630773,1631283-1631284,1631333-1631334,1631617-1631619,1631630,1631699,1631704,1631711,1631967-1631969,1631986,1631990,1631999,1632002-1632003,1632017,1632258,1632264,1632270,1632293,1632303,1632592,1632605,1633315,1633327,1633389,1633559-1633560,1633562,1633567,1633571,1633598,1633608,1633641,1633687,1633697,1633768,1633783,1634505,1634513,1634774,1634779,1634781,1634792,1634803,1634814,1634816,1634838,1634841,1634852,1634864,1634896,1634898,1635044-1635045,1635060,1635077,1635089,1635102,1635108,1635178,1635218,1635387,1635435,1635518,1635563,1635586,1636336,1636348,1636505,1636585,1636799,1637368,1637382,1637413,1637651,1637815,1638779-1638783,1639260,1639577,1639622,1639963,1639966,1639973,1640134,1640143,1640523,1640555-1640556,1640694-1640695,1640715,1640722-1640723,1640728,1640863-1640872,1641340,1641346,164135
0,1641352,1641541,1641596-1641599,1641601,1641662,1641671,1641695,1641771,1641802,1641811,1641950,1642031,1642056,1642119,1642285,1642648,1642667,1642954,1642959,1643111,1643178,1643186,1643204,1643287,1643767,1643774,1643982,1644016,1644106,1644366,1644383,1644397-1644398,1644407,1644479,1644547,1644552,1644554,1644588,1644645,1644650,1644654,1644689,1644750,1645421,1645424,1645459,1645585,1645611,1645637,1645646,1645660-1645663,1645888,1645901,1645948,1645966,1645970-1645971,1646014,1646164,1646174,1646469,1646684,1646687,1646726-1646728,1646766,1646795,1646981,1649743,1649803,1650015,1650239,1650529,1650797,1651323,1651382,1651643,1651652,1651730,1651988-1651989,1651996,1652024,1652035,1652058-1652059,1652075,1652127,1652158,1652467,1652965,1652971,1652992,1653207,1653446,1653463,1653484,1653572,1653579,1653591,1653804,1653809,1653813,1653848-1653850,1653882,1654116,1654174,1654743,1654756,1654778,1655028,1655049,1655054-1655055,1655086,1655237,1655248,1655996,1656019,1656027,165
6033,1656303,1656394,1656400,1656425,1656427,1656432,1656453,1656628,1656678,1657128,1657132,1657163,1657188,1657265,1657511,1657766,1657804,1658470,1658977,1658983,1659285,1659483,1659527,1659550,1659578,1659765,1660100,1660154-1660155,1660383-1660384,1660409,1660426,1660676,1660870,1660872,1660897,1660903,1661069,1661122,1661146,1661158,1661226,1661630,1661643,1661645,1661988,1662313-1662315,1662323,1662381,1662450,1662456,1663241,1663275,1663288,1663448,1663526,1663528,1663565,1663578,1663614,1663666,1663705,1663730,1663753,1663854,1663927,1664038,1664184,1664228-1664229,1664231,1664381,1664569,1664947,1664987,1665184,1665257,1665271-1665272,1665274-1665275,1665436,1665604,1665634,1665758,1665835,1665892,1665897,1665910,1665918,1666100,1666102,1666177,1666218,1666220,1666351-1666352,1666381,1666384,1666426,1666491,1666787,1667062,1667184,1667293,1667462,1667498,1667502,1667573,1667590,1667696,1667782,1668160,1668275,1668624,1668641,1668645,1668649,1668665,1668671,1668683,1668688,
1668845,1669072,1669096,1669135,1669337,1669361,1669579,1669680,1669989,1670030,1670693,1670705,1671489,1671512,1671773,1671787,1671795,1672055,1672277,1672350,1672468,1672537,1672603,1672642,1672644,1672834-1672835,1673351,1673410,1673431,1673436,1673644,1673662-1673663,1673695,1673713,1673738,1673787,1673791,1674046,1674065,1674075,1674107,1674150,1674780,1675054,1675319,1675332,1675382,1675555,1675566,1676198,1676407,1676458,1676670,1676703,1677579,1677609,1677611,1677774,1677788,1677797,1677804,1677806,1677939,1677991,1678023,1678095-1678096,1678171,1678173,1678211,1678323,1678758,1678938,1678954,1679144,1679147,1679165,1679191,1679232,1679503,1679961,1680170,1680182,1680222,1680232,1680236,1680461,1680633,1680643,1680747,1680805-1680806,1680903,1681282,1681767,1681918,1681955,1682218,1682235,1682437,1682494,1682555,1682855,1682904,1683059,1683089,1683213,1683249,1683259,1683278,1683323,1683687,1683700,1684174,1684376,1684442,1684561,1684570,1684618,1684820,1684836,1684868,16850
23,1685075,1685370,1685552,1685589-1685590,1685840,1685964,1685977,1685989,1685999,1686023,1686032,1686097,1686229,1686234,1686253,1686414,1686780,1686854,1686857,1686971,1687053,1687175,1687196,1687198,1687220,1687239-1687240,1687301,1687441,1687553,1688090,1688179,1688349,1688421,1688436,1688453,1688622,1688636,1688817,1689003-1689004,1689008,1689577,1689581,1689623,1689774,1689810,1689828,1689831,1689833,1689903,1690017,1690043,1690047,1690057,1690247,1690249,1690634-1690637,1690650,1690669,1690674,1690941,1691139,1691159,1691167,1691183,1691188,1691210,1691307,1691331-1691333,1691345,1691384-1691385,1691401,1691509,1692065,1692133,1692156,1692250,1692274,1692363,1692382,1692478,1692955,1693030,1693209,1693421,1693525-1693526,1694007,1694393,1695050,1695122,1695280,1695299,1695540,1696194,1696242,1696285,1696578,1696759,1696916,1697363,1697373,1697410,1697582,1697589,1697616,1697672,1700191,1700231,1700397,1700506,1700571,1700727,1700749,1700769,1700775,1701619,1701733,1701743,17
01750,1701768,1701806,1701810,1701814,1701948,1701955,1701959,1701965,1702014,1702241,1702272,1702423,1702860,1702942,1702960,1703212,1703382,1703395,1703411,1703428,1703430,1703568,1703592,1703758,1703858,1703878,1704256,1704282,1704285,1704457,1704479,1704614,1704629,1704636,1704655,1704670,1704886,1705005,1705027,1705043,1705055,1705250,1705268,1705273,1705323,1705677,1705701,1705871,1706764,1706772,1707049,1707191,1707435,1708105,1708546,1708592,1709012,1709852,1709978,1710013,1710031,1710049,1710205,1710242,1710559,1710575,1710590,1710614,1710637
/jackrabbit/trunk:1345480
Copied:
jackrabbit/oak/branches/1.0/oak-core/src/main/java/org/apache/jackrabbit/oak/plugins/document/rdb/RDBExport.java
(from r1709852,
jackrabbit/oak/trunk/oak-core/src/main/java/org/apache/jackrabbit/oak/plugins/document/rdb/RDBExport.java)
URL:
http://svn.apache.org/viewvc/jackrabbit/oak/branches/1.0/oak-core/src/main/java/org/apache/jackrabbit/oak/plugins/document/rdb/RDBExport.java?p2=jackrabbit/oak/branches/1.0/oak-core/src/main/java/org/apache/jackrabbit/oak/plugins/document/rdb/RDBExport.java&p1=jackrabbit/oak/trunk/oak-core/src/main/java/org/apache/jackrabbit/oak/plugins/document/rdb/RDBExport.java&r1=1709852&r2=1710804&rev=1710804&view=diff
==============================================================================
---
jackrabbit/oak/trunk/oak-core/src/main/java/org/apache/jackrabbit/oak/plugins/document/rdb/RDBExport.java
(original)
+++
jackrabbit/oak/branches/1.0/oak-core/src/main/java/org/apache/jackrabbit/oak/plugins/document/rdb/RDBExport.java
Tue Oct 27 12:54:27 2015
@@ -16,39 +16,216 @@
*/
package org.apache.jackrabbit.oak.plugins.document.rdb;
+import java.io.BufferedReader;
+import java.io.File;
+import java.io.FileInputStream;
+import java.io.FileOutputStream;
+import java.io.IOException;
+import java.io.InputStream;
+import java.io.InputStreamReader;
+import java.io.OutputStream;
+import java.io.PrintStream;
+import java.nio.charset.Charset;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
+import java.sql.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;
+import java.sql.Types;
+import java.util.ArrayList;
import java.util.HashSet;
+import java.util.Set;
+import org.apache.commons.io.IOUtils;
+import org.apache.jackrabbit.oak.commons.json.JsopBuilder;
import org.apache.jackrabbit.oak.plugins.document.Collection;
+import org.apache.jackrabbit.oak.plugins.document.Document;
+import org.apache.jackrabbit.oak.plugins.document.DocumentStoreException;
import org.apache.jackrabbit.oak.plugins.document.NodeDocument;
import org.apache.jackrabbit.oak.plugins.document.memory.MemoryDocumentStore;
+import org.apache.jackrabbit.oak.util.OakVersion;
+/**
+ * Utility for dumping contents from {@link RDBDocumentStore}'s tables.
+ */
public class RDBExport {
- public static void main(String[] args) throws ClassNotFoundException,
SQLException {
- String url = null, user = null, pw = null, table = null, query = null;
- RDBDocumentSerializer ser = new RDBDocumentSerializer(new
MemoryDocumentStore(), new HashSet<String>());
+ private static final Charset UTF8 = Charset.forName("UTF-8");
+
+ public static void main(String[] args) throws ClassNotFoundException,
SQLException, IOException {
+ String url = null, user = null, pw = null, table = "nodes", query =
null, dumpfile = null, lobdir = null;
+ boolean asArray = false;
+ PrintStream out = System.out;
+ Set<String> excl = new HashSet<String>();
+ excl.add(Document.ID);
+ RDBDocumentSerializer ser = new RDBDocumentSerializer(new
MemoryDocumentStore(), excl);
+
+ String param = null;
try {
- url = args[0];
- user = args[1];
- pw = args[2];
- table = args[3];
- query = args.length >= 5 ? args[4] : null;
+ for (int i = 0; i < args.length; i++) {
+ param = args[i];
+ if ("-u".equals(param) || "--username".equals(param)) {
+ user = args[++i];
+ } else if ("-p".equals(param) || "--password".equals(param)) {
+ pw = args[++i];
+ } else if ("-c".equals(param) || "--collection".equals(param))
{
+ table = args[++i];
+ } else if ("-j".equals(param) || "--jdbc-url".equals(param)) {
+ url = args[++i];
+ } else if ("-q".equals(param) || "--query".equals(param)) {
+ query = args[++i];
+ } else if ("-o".equals(param) || "--out".equals(param)) {
+ OutputStream os = new FileOutputStream(args[++i]);
+ out = new PrintStream(os, true, "UTF-8");
+ } else if ("--from-db2-dump".equals(param)) {
+ dumpfile = args[++i];
+ } else if ("--lobdir".equals(param)) {
+ lobdir = args[++i];
+ } else if ("--jsonArray".equals(param)) {
+ asArray = true;
+ } else if ("--version".equals(param)) {
+ System.out.println(RDBExport.class.getName() + " version "
+ OakVersion.getVersion());
+ System.exit(0);
+ } else if ("--help".equals(param)) {
+ printHelp();
+ System.exit(0);
+ } else {
+ System.err.println(RDBExport.class.getName() + ": invalid
parameter " + args[i]);
+ printUsage();
+ System.exit(2);
+ }
+ }
} catch (IndexOutOfBoundsException ex) {
- System.err.println("Usage: ... " + RDBCreator.class.getName() + "
JDBC-URL username password table [query]");
+ System.err.println(RDBExport.class.getName() + ": value missing
for parameter " + param);
+ printUsage();
+ System.exit(2);
+ }
+
+ if (dumpfile != null && url != null) {
+ System.err.println(RDBExport.class.getName() + ": must use either
dump file or JDBC URL");
+ printUsage();
System.exit(2);
+ } else if (dumpfile != null) {
+ dumpFile(dumpfile, lobdir, asArray, out, ser);
+ } else {
+ dumpJDBC(url, user, pw, table, query, asArray, out, ser);
+ }
+
+ out.flush();
+ out.close();
+ }
+
+ private static void dumpFile(String filename, String lobdir, boolean
asArray, PrintStream out, RDBDocumentSerializer ser)
+ throws IOException {
+ File f = new File(filename);
+ File lobDirectory = lobdir == null ? new File(f.getParentFile(),
"lobdir") : new File(lobdir);
+ FileInputStream fis = new FileInputStream(f);
+ InputStreamReader ir = new InputStreamReader(fis, UTF8);
+ BufferedReader br = new BufferedReader(ir);
+
+ if (asArray) {
+ out.println("[");
+ }
+ boolean needComma = asArray;
+ String line = br.readLine();
+ while (line != null) {
+ ArrayList<String> fields = parseDel(line);
+ String id = fields.get(0);
+ String smodified = fields.get(1);
+ String shasbinary = fields.get(2);
+ String sdeletedonce = fields.get(3);
+ String smodcount = fields.get(4);
+ String scmodcount = fields.get(5);
+ String sdata = fields.get(7);
+ String sbdata = fields.get(8);
+
+ byte[] bytes = null;
+ if (sbdata.length() != 0) {
+ String lobfile = sbdata.replace("/", "");
+ int lastdot = lobfile.lastIndexOf('.');
+ String length = lobfile.substring(lastdot + 1);
+ lobfile = lobfile.substring(0, lastdot);
+ lastdot = lobfile.lastIndexOf('.');
+ String startpos = lobfile.substring(lastdot + 1);
+ lobfile = lobfile.substring(0, lastdot);
+ int s = Integer.valueOf(startpos);
+ int l = Integer.valueOf(length);
+ File lf = new File(lobDirectory, lobfile);
+ InputStream is = new FileInputStream(lf);
+ bytes = new byte[l];
+ IOUtils.skip(is, s);
+ IOUtils.read(is, bytes, 0, l);
+ IOUtils.closeQuietly(is);
+ }
+ try {
+ RDBRow row = new RDBRow(id, "1".equals(shasbinary),
"1".equals(sdeletedonce),
+ smodified.length() == 0 ? 0 :
Long.parseLong(smodified), Long.parseLong(smodcount),
+ Long.parseLong(scmodcount), sdata, bytes);
+ StringBuilder fulljson = dumpRow(ser, id, row);
+ if (asArray && needComma) {
+ fulljson.append(",");
+ }
+ out.println(fulljson);
+ needComma = true;
+ } catch (DocumentStoreException ex) {
+ System.err.println("Error: skipping line for ID " + id + "
because of " + ex.getMessage());
+ }
+ line = br.readLine();
+ }
+ br.close();
+ if (asArray) {
+ out.println("]");
+ }
+ }
+
+ private static ArrayList<String> parseDel(String line) {
+ ArrayList<String> result = new ArrayList<String>();
+
+ boolean inQuoted = false;
+ char quotechar = '"';
+ char fielddelim = ',';
+ StringBuilder value = new StringBuilder();
+ for (int i = 0; i < line.length(); i++) {
+ char c = line.charAt(i);
+ if (!inQuoted) {
+ if (c == fielddelim) {
+ result.add(value.toString());
+ value = new StringBuilder();
+ } else {
+ if (value.length() == 0 && c == quotechar) {
+ inQuoted = true;
+ } else {
+ value.append(c);
+ }
+ }
+ } else {
+ if (c == quotechar) {
+ if (i + 1 != line.length() && line.charAt(i + 1) ==
quotechar) {
+ // quoted quote char
+ value.append(c);
+ i += 1;
+ } else {
+ inQuoted = false;
+ }
+ } else {
+ value.append(c);
+ }
+ }
}
+ result.add(value.toString());
+
+ return result;
+ }
+ private static void dumpJDBC(String url, String user, String pw, String
table, String query, boolean asArray, PrintStream out,
+ RDBDocumentSerializer ser) throws SQLException {
String driver =
RDBJDBCTools.driverForDBType(RDBJDBCTools.jdbctype(url));
try {
Class.forName(driver);
} catch (ClassNotFoundException ex) {
- System.err.println("Attempt to load class " + driver + " failed.");
+ System.err.println(RDBExport.class.getName() + ":attempt to load
class " + driver + " failed:" + ex.getMessage());
}
Connection c = DriverManager.getConnection(url, user, pw);
c.setReadOnly(true);
@@ -59,21 +236,89 @@ public class RDBExport {
}
sql += " order by id";
ResultSet rs = stmt.executeQuery(sql);
+
+ if (asArray) {
+ out.println("[");
+ }
+ boolean needComma = asArray;
+ ResultSetMetaData rsm = null;
+ boolean idIsAscii = true;
while (rs.next()) {
- String id = rs.getString(1);
- long modified = rs.getLong(2);
- long modcount = rs.getLong(3);
- long cmodcount = rs.getLong(4);
- long hasBinary = rs.getLong(5);
- long deletedOnce = rs.getLong(6);
- String data = rs.getString(7);
- byte[] bdata = rs.getBytes(8);
+ if (rsm == null) {
+ rsm = rs.getMetaData();
+ idIsAscii = !isBinaryType(rsm.getColumnType(1));
+ }
+ String id = idIsAscii ? rs.getString("ID") : new
String(rs.getBytes("ID"), UTF8);
+ long modified = rs.getLong("MODIFIED");
+ long modcount = rs.getLong("MODCOUNT");
+ long cmodcount = rs.getLong("CMODCOUNT");
+ long hasBinary = rs.getLong("HASBINARY");
+ long deletedOnce = rs.getLong("DELETEDONCE");
+ String data = rs.getString("DATA");
+ byte[] bdata = rs.getBytes("BDATA");
+
RDBRow row = new RDBRow(id, hasBinary == 1, deletedOnce == 1,
modified, modcount, cmodcount, data, bdata);
- NodeDocument doc = ser.fromRow(Collection.NODES, row);
- System.out.println(ser.asString(doc));
+ StringBuilder fulljson = dumpRow(ser, id, row);
+ if (asArray && needComma && !rs.isLast()) {
+ fulljson.append(",");
+ }
+ out.println(fulljson);
+ needComma = true;
+ }
+ if (asArray) {
+ out.println("]");
}
+ out.close();
rs.close();
stmt.close();
c.close();
}
+
+ private static StringBuilder dumpRow(RDBDocumentSerializer ser, String id,
RDBRow row) {
+ NodeDocument doc = ser.fromRow(Collection.NODES, row);
+ String docjson = ser.asString(doc);
+ StringBuilder fulljson = new StringBuilder();
+ fulljson.append("{\"_id\":\"");
+ JsopBuilder.escape(id, fulljson);
+ fulljson.append("\",");
+ fulljson.append(docjson.substring(1));
+ return fulljson;
+ }
+
+ private static boolean isBinaryType(int sqlType) {
+ return sqlType == Types.VARBINARY || sqlType == Types.BINARY ||
sqlType == Types.LONGVARBINARY;
+ }
+
+ private static void printUsage() {
+ System.err.println("Usage: " + RDBExport.class.getName()
+ + " -j/--jdbc-url JDBC-URL [-u/--username username]
[-p/--password password] [-c/--collection table] [-q/--query query] [-o/--out
file] [--jsonArray]");
+ System.err.println(
+ "Usage: " + RDBExport.class.getName() + " --from-DB2-dump file
[--lobdir lobdir] [-o/--out file] [--jsonArray]");
+ System.err.println("Usage: " + RDBExport.class.getName() + "
--version");
+ System.err.println("Usage: " + RDBExport.class.getName() + " --help");
+ }
+
+ private static void printHelp() {
+ System.err.println("Export Apache OAK RDB data to JSON files");
+ System.err.println("");
+ System.err.println("Generic options:");
+ System.err.println(" --help produce this
help message");
+ System.err.println(" --version show version
information");
+ System.err.println("");
+ System.err.println("JDBC options:");
+ System.err.println(" -j/--jdbc-url JDBC-URL JDBC URL of
database to connect to");
+ System.err.println(" -u/--username username database
username");
+ System.err.println(" -p/--password password database
password");
+ System.err.println(" -c/--collection table table name
(defaults to 'nodes')");
+ System.err.println(" -q/--query query SQL where
clause (minus 'where')");
+ System.err.println("");
+ System.err.println("Dump file options:");
+ System.err.println(" --from-DB2-dump file name of DB2
DEL export file");
+ System.err.println(" --lobdir dir name of DB2
DEL export file LOB directory");
+ System.err.println(" (defaults to
./lobdir under the dump file)");
+ System.err.println("");
+ System.err.println("Output options:");
+ System.err.println(" -o/--out file Output to
name file (instead of stdout)");
+ System.err.println(" --jsonArray Output a JSON
array (instead of one JSON doc per line)");
+ }
}
