{"id":764,"date":"2023-12-08T23:59:23","date_gmt":"2023-12-08T14:59:23","guid":{"rendered":"https:\/\/web.cloudfree.jp\/journal\/?p=764"},"modified":"2023-12-14T06:44:26","modified_gmt":"2023-12-13T21:44:26","slug":"wordpress%e3%83%ad%e3%83%bc%e3%82%ab%e3%83%ab%e7%92%b0%e5%a2%83%e3%82%921click%e3%81%a7%e6%9b%b4%e6%96%b04-5","status":"publish","type":"post","link":"https:\/\/web.cloudfree.jp\/journal\/wordpress%e3%83%ad%e3%83%bc%e3%82%ab%e3%83%ab%e7%92%b0%e5%a2%83%e3%82%921click%e3%81%a7%e6%9b%b4%e6%96%b04-5\/","title":{"rendered":"WordPress\u30ed\u30fc\u30ab\u30eb\u74b0\u5883\u30921Click\u3067\u66f4\u65b0(4\/5)"},"content":{"rendered":"

WordPress\u30ed\u30fc\u30ab\u30eb\u74b0\u5883\u30921Click\u3067\u66f4\u65b0(4\/5)<\/h3>\n\n\n

2023-12-08 \u8a18\u8f09
\u6982\u8981 : Selenium WebDriver\u3067Search-Replace-DB-master\u3092\u64cd\u4f5c\u3057\u3066\u30b5\u30a4\u30c8URL\u3092\u7f6e\u63db
\u95a2\u9023\u8a18\u4e8b\uff1a(1\/5)<\/a>, (2\/5)<\/a>, (3\/5)<\/a>, (5\/5)<\/a>
Keyword : WordPress, Selenium WebDriver, VBA, Search-Replace-DB-master,<\/p>\n\n\n\n

(\u524d\u56de<\/a>\u306e\u3064\u3065\u304d\u3088\u308a)
MariaDB\u306b\u30a4\u30f3\u30dd\u30fc\u30c8\u3057\u305f\u30c7\u30fc\u30bf\u306f\u3001\u30b5\u30a4\u30c8 cfsid.cloudfree.jp \u3067\u52d5\u4f5c\u3059\u308b\u30c7\u30fc\u30bf\u306b\u306a\u3063\u3066\u3044\u307e\u3059\u306e\u3067\u3001\u30b5\u30a4\u30c8URL\u3092 localhost\u306eApache\u306e\u8a2d\u5b9a\u306b\u3042\u308f\u305b\u3066\u6587\u5b57\u5217\u7f6e\u63db\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002
\u6614(?)\u306a\u3089\u3001\u30a4\u30f3\u30dd\u30fc\u30c8\u3059\u308b\u524d\u306b\u30c6\u30ad\u30b9\u30c8\u30a8\u30c7\u30a3\u30bf\u3067\u4e00\u62ec\u7f6e\u63db\u304b\u3051\u308c\u3070\u3088\u304b\u3063\u305f\u306e\u3067\u3059\u304c\u3001\u4eca\u306fObject\u3092\u30b7\u30ea\u30a2\u30e9\u30a4\u30ba\u3055\u305b\u305f\u57cb\u3081\u8fbc\u307f\u30c7\u30fc\u30bf\u304c\u6df7\u3058\u3063\u3066\u3044\u308b\u306e\u3067\u3001String\u30c7\u30fc\u30bf\u3092\u5909\u66f4\u3057\u305f\u5834\u5408\u306f\u305d\u306e\u6587\u5b57\u6570\u3082\u5909\u66f4\u3057\u3066\u304a\u304b\u306a\u3044\u3068\u6574\u5408\u6027\u304c\u306a\u304f\u306a\u308a\u307e\u3059\u3002
\u4eca\u306b\u306a\u3063\u3066\u6c17\u3065\u3044\u305f\u306e\u3067\u3059\u304c\u3001\u30b7\u30f3\u30fb\u30af\u30e9\u30a6\u30c9\u3067\u306e\u30b5\u30a4\u30c8URL\u3068\u3001\u30ed\u30fc\u30ab\u30ebApache\u3067\u306e\u30b5\u30a4\u30c8URL\u306e\u6587\u5b57\u6570\u3092\u3042\u308f\u305b\u3066\u304a\u3051\u3070\u300c\u30c6\u30ad\u30b9\u30c8\u30a8\u30c7\u30a3\u30bf\u3067\u4e00\u62ec\u7f6e\u63db\u300d\u6280\u304c\u4f7f\u3048\u308b\u3093\u3067\u3059\u306d\u3002\u30ed\u30fc\u30ab\u30ebApache\u5074\u306f\u3053\u308c\u3068\u3044\u3063\u3066\u5236\u7d04\u304c\u306a\u3044\u304b\u3089\u3001\u4eca\u304b\u3089\u3067\u3082\u6587\u5b57\u6570\u5408\u308f\u305b\u3057\u3066\u697d\u3061\u3093\u3059\u308b\u306e\u306f\u3067\u304d\u307e\u3059\u3051\u3069\u3001\u307e\u3041\u3053\u306e\u3042\u305f\u308a\u3001\u3064\u3044\u3067\u306e\u5b66\u7fd2\u8ab2\u984c\u306e\u591a\u3044\u3068\u3053\u308d\u3067\u3059\u306e\u3067\u3001\u9003\u3052\u305a\u306b\u6b63\u653b\u6cd5\u3067\u3059\u3059\u3081\u308b\u3053\u3068\u306b\u3057\u307e\u3059\u3002

ADODB\u3067MariaDB\u306b\u63a5\u7d9a\u3057\u3066\u3001\u81ea\u5206\u3067\u691c\u7d22\uff06\u7f6e\u63db\u3057\u3088\u3046\u3068\u30c8\u30e9\u30a4\u3057\u3066\u307e\u3057\u305f\u304c\u3001\u5b8c\u6210\u307e\u3067\u3082\u3046\u5c11\u3057\u6642\u9593\u304c\u304b\u304b\u308a\u305d\u3046\u306a\u306e\u3067\u3001\u3053\u3053\u3067\u306f\u5b9a\u756a\u30c4\u30fc\u30eb\u300cSearch-Replace-DB-master\u300d\u3092\u4f7f\u3046\u65b9\u6cd5\u3092\u66f8\u3044\u3066\u304a\u304d\u307e\u3059\u3002

\u524d\u63d0\u3068\u3057\u3066 SearchReplaceDB \u304c\u4ee5\u4e0b\u306b\u30bb\u30c3\u30c8\u30a2\u30c3\u30d7\u3055\u308c\u3066\u3044\u308b\u3068\u3057\u307e\u3059\u3002
htdocs\\Search-Replace-DB-master\/index.php
\u3042\u3068VBA\u306bSelenium WebDriver\u306e\u30bb\u30c3\u30c8\u30a2\u30c3\u30d7\u3002
\u305d\u3057\u3066Chrome\u3068\u305d\u306e\u30d0\u30fc\u30b8\u30e7\u30f3\u306b\u5fdc\u3058\u305fDriver\u306e\u30bb\u30c3\u30c8\u30a2\u30c3\u30d7\u3002

\u51e6\u7406\u306e\u6d41\u308c\u3068\u3057\u3066\u306f
Step1. Search-Replace-DB-master\u306e\u6700\u65b0\u30d0\u30fc\u30b8\u30e7\u30f3\u5229\u7528\u30c1\u30a7\u30c3\u30af
Step2. \u9805\u76ee\u3078\u306e\u5024\u306e\u8a2d\u5b9a
Step3. \u63a5\u7d9a\u30c6\u30b9\u30c8\u30fb\u7f6e\u63db\u306esubmit

htdocs\u306e\u30d1\u30b9\u7b49\u306f\u74b0\u5883\u306b\u3042\u308f\u305b\u3066\u8aad\u307f\u304b\u3048\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n\n\n\n

  'Selenium WebDriver\n  Dim sb As New Selenium.ChromeDriver '\u53c2\u7167:Selenium Type Library\n  Dim By As New Selenium.By\n\n  sb.Start "chrome"\n  sb.Get "https:\/\/github.com\/interconnectit\/Search-Replace-DB"\n  Do Until sb.IsElementPresent(By.XPath("\/\/h1[@tabindex=""-1""]"))\n    sb.Wait 300\n  Loop\n  \n  'Git\u306e\u6700\u65b0\u30d0\u30fc\u30b8\u30e7\u30f3\n  Dim sVersionGit As String\n  sVersionGit = sb.FindElementByXPath("\/\/h1[@tabindex=""-1""]").text\n  '\u5229\u7528\u30d0\u30fc\u30b8\u30e7\u30f3\n  Dim sVersionUse As String\n  Dim adoFile As New ADODB.Stream\n  adoFile.Charset = "utf-8"\n  Call adoFile.Open\n  Call adoFile.LoadFromFile("C:\\pgm\\Apache24\\htdocs\\Search-Replace-DB-master\\README.md")\n  GetFile = adoFile.ReadText\n  adoFile.Close\n  sVersionUse = Left(Mid(s, InStr(s, "# ") + Len("# ")), InStr(s, vbLf) - 1)\n  If sVersionGit <> sVersionUse Then\n    'Update\u5fc5\u8981\n    MsgBox "Update to " & sVersionGit\n  End If  <\/code><\/pre><\/div>\n\n\n\n
Github\u306e\u6700\u65b0\u30d0\u30fc\u30b8\u30e7\u30f3\u3068\u5229\u7528\u30d0\u30fc\u30b8\u30e7\u30f3\u304c\u9055\u3046\u5834\u5408\u3001MsgBox\u3067\u305d\u306e\u65e8\u901a\u77e5\u3057\u307e\u3059\u3002\u901a\u77e5\u3059\u308b\u3060\u3051\u3067\u7d9a\u884c\u3002

\u30ed\u30fc\u30ab\u30eb\u306eSearch-Replace-DB\u753b\u9762\u3092\u958b\u3044\u3066\u3001\u9805\u76ee\u3092\u5165\u529b\u3002
TestConnection\u3092\u901a\u3057\u3066\u3001DryRun\u306f\u3068\u3070\u3057\u3066\u3001Replace\u5b9f\u884c\u3002
\u30a2\u30e9\u30fc\u30c8\u304c\u51fa\u308b\u306e\u3067OK\u3057\u305f\u3089\u3001\u305d\u3053\u304b\u3089\uff15\u79d2\u306e\u30ab\u30a6\u30f3\u30c8\u30c0\u30a6\u30f3\u3002
\u305d\u3057\u3066\u7f6e\u63db\u304c\u7d42\u308f\u308c\u3070\u5b8c\u4e86\u3002
\u5b8c\u4e86\u306f\u3001Stop\u30dc\u30bf\u30f3\u304c\u6d88\u3048\u308b\u306e\u3092\u30c1\u30a7\u30c3\u30af\u3002<\/p>\n\n\n\n
  sb.Get "https:\/\/localhost\/Search-Replace-DB-master\/index.php"\n  sb.Wait 300\n  '\u9805\u76ee\u306b\u5024\u3092\u8a2d\u5b9a\n  sb.FindElementByXPath("\/\/input[@id=""search-0""]").SendKeys "cfsid.cloudfree.jp"\n  sb.FindElementByXPath("\/\/input[@id=""replace-0""]").SendKeys "localhost\/cloudfree"\n  sb.FindElementByXPath("\/\/input[@id=""name""]").SendKeys "cfsid_mywordpress"\n  sb.FindElementByXPath("\/\/input[@id=""user""]").SendKeys "cfsid_dbuser"\n  sb.FindElementByXPath("\/\/input[@id=""pass""]").SendKeys "password"\n\n  'submit [Test connection]\n  sb.FindElementByXPath("\/\/input[@name=""submit[update]""]").Click\n  Do Until sb.IsElementPresent(By.XPath("\/\/div[@class=""successful-connection"" and @style=""""]"))\n    sb.Wait 300\n  Loop\n\n  'submit [Search And Replace]\n  sb.FindElementByXPath("\/\/input[@name=""submit[liverun]""]").Click\n  sb.Wait 2000\n  'Accept OK\n  sb.SwitchToAlert.Accept\n\n  '(\u30ab\u30a6\u30f3\u30c8\u30c0\u30a6\u30f35\u79d2)\u2192Stop\u30dc\u30bf\u30f3\u8868\u793a\u2192(\u51e6\u7406\u4e2d)\u2192Stop\u30dc\u30bf\u30f3\u6d88\u3048\u308b\u2192(\u51e6\u7406\u5b8c\u4e86)\n  Do Until sb.IsElementPresent(By.XPath("\/\/input[@name=""submit[stop]""]"))\n    sb.Wait 300\n  Loop\n  Do While sb.IsElementPresent(By.XPath("\/\/input[@name=""submit[stop]""]"))\n    sb.Wait 300\n  Loop\n\n  '\u5b8c\u4e86\n  sb.Close<\/code><\/pre><\/div>\n\n\n\n
\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u4f5c\u696d\u306f\u3053\u308c\u3067\u5b8c\u4e86\u3002
\u6b8b\u3059\u4f5c\u696d\u306f\u30d5\u30a1\u30a4\u30eb\u306e\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3067\u3059\u3002
(\u3064\u3065\u304f<\/a>)<\/p>\n","protected":false},"excerpt":{"rendered":"
Selenium WebDriver\u3067Search-Replace-DB-master\u3092\u64cd\u4f5c\u3057\u3066\u30b5\u30a4\u30c8URL\u3092\u7f6e\u63db\u3002<\/p>\n","protected":false},"author":1,"featured_media":758,"comment_status":"open","ping_status":"closed","sticky":false,"template":"wp-custom-template-x24-index","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[51,96,12,56,24],"_links":{"self":[{"href":"https:\/\/web.cloudfree.jp\/journal\/wp-json\/wp\/v2\/posts\/764"}],"collection":[{"href":"https:\/\/web.cloudfree.jp\/journal\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/web.cloudfree.jp\/journal\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/web.cloudfree.jp\/journal\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/web.cloudfree.jp\/journal\/wp-json\/wp\/v2\/comments?post=764"}],"version-history":[{"count":0,"href":"https:\/\/web.cloudfree.jp\/journal\/wp-json\/wp\/v2\/posts\/764\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/web.cloudfree.jp\/journal\/wp-json\/wp\/v2\/media\/758"}],"wp:attachment":[{"href":"https:\/\/web.cloudfree.jp\/journal\/wp-json\/wp\/v2\/media?parent=764"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/web.cloudfree.jp\/journal\/wp-json\/wp\/v2\/categories?post=764"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/web.cloudfree.jp\/journal\/wp-json\/wp\/v2\/tags?post=764"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}