wg_alldatainsert.py 5.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175
  1. from sync_amz_data.tasks.datainsert.mysql_datainsert_portfolios import Portfolios
  2. from sync_amz_data.tasks.datainsert.SP.mysql_datainsert_spcampaign import SpCampaign
  3. from sync_amz_data.tasks.datainsert.SP.mysql_datainsert_spgroup import SpGroup
  4. from sync_amz_data.tasks.datainsert.SP.mysql_datainsert_spkeyword import SpKeyword
  5. from sync_amz_data.tasks.datainsert.SP.mysql_datainsert_sp_budget_recommendation import SpBudgetRecommendation
  6. from sync_amz_data.tasks.datainsert.SP.mysql_datainsert_spads import SpAds
  7. from sync_amz_data.tasks.datainsert.SP.mysql_datainsert_sp_targetsbid_recommendations import SpTargetsBidRecommendations
  8. from sync_amz_data.tasks.datainsert.SP.mysql_datainsert_sptarget import SpTargets
  9. from sync_amz_data.tasks.datainsert.SP.mysql_datainsert_sp_targetsbid_recommendations_v2 import SpTargetsBidRecommendationsV2
  10. from sync_amz_data.tasks.datainsert.SP.mysql_datainsert_spnegativekeyword import SpNegativeKeyword
  11. from sync_amz_data.tasks.datainsert.SP.mysql_datainsert_spnegativetarget import SpNegativeTarget
  12. from sync_amz_data.tasks.datainsert.SB.mysql_datainsert_sbcampaign import SbCampaign
  13. from sync_amz_data.tasks.datainsert.SB.mysql_datainsert_sbgroup import SbGroup
  14. from sync_amz_data.tasks.datainsert.SB.mysql_datainsert_sbkeyword_v3 import SbKeyword
  15. from sync_amz_data.tasks.datainsert.SB.mysql_datainsert_sbads import SbAds
  16. from sync_amz_data.tasks.datainsert.SB.mysql_datainsert_sb_keywordsbid_recommendations_v3 import SbkeywordsBidRecommendations
  17. from sync_amz_data.tasks.datainsert.SB.mysql_datainsert_sbtarget_v3 import SbTargets
  18. from sync_amz_data.tasks.datainsert.SB.mysql_datainsert_sbtargetbid_recommendations_v3 import SbtargetsBidRecommendations
  19. from sync_amz_data.tasks.datainsert.SB.mysql_datainsert_sbnegativekeyword import SbNegtiveKeyword
  20. from sync_amz_data.tasks.datainsert.SB.mysql_datainsert_sbthemetargeting_v3 import SbThemeTargeting
  21. from sync_amz_data.tasks.datainsert.mysql_datainsert_assets import Assets
  22. from sync_amz_data.tasks.datainsert.categories_updata import Categories
  23. from sync_amz_data.tasks.datainsert.pl_update import ProductLineDetail
  24. import time
  25. def protime(start_time):
  26. end_time = time.time()
  27. run_time = end_time - start_time
  28. minutes = int(run_time / 60)
  29. seconds = int(run_time % 60)
  30. print(f'程序运行时间: {minutes} 分钟 {seconds} 秒')
  31. time.sleep(5)
  32. start_time = time.time()
  33. cg = Categories(profile_id="3006125408623189")
  34. cgo = cg.updata_create()
  35. print("Categories", cgo)
  36. protime(start_time)
  37. start_time = time.time()
  38. pf = Portfolios("3006125408623189")
  39. pfo = pf.updata_create()
  40. print("Portfolios", pfo)
  41. protime(start_time)
  42. start_time = time.time()
  43. spc = SpCampaign(profile_id="3006125408623189")
  44. spco = spc.updata_create()
  45. print("SpCampaign", spco)
  46. protime(start_time)
  47. start_time = time.time()
  48. spg = SpGroup(profile_id="3006125408623189")
  49. spgo = spg.updata_create()
  50. print("SpGroup", spgo)
  51. protime(start_time)
  52. start_time = time.time()
  53. spk = SpKeyword(profile_id="3006125408623189")
  54. spko = spk.updata_create()
  55. print("SpKeyword", spko)
  56. protime(start_time)
  57. start_time = time.time()
  58. spt = SpTargets(profile_id="3006125408623189")
  59. spto = spt.updata_create()
  60. print("SpTargets", spto)
  61. protime(start_time)
  62. start_time = time.time()
  63. spa = SpAds(profile_id="3006125408623189")
  64. spao = spa.updata_create()
  65. print("SpAds", spao)
  66. protime(start_time)
  67. start_time = time.time()
  68. spbr = SpBudgetRecommendation(profile_id="3006125408623189")
  69. spbro = spbr.updata_create()
  70. print("SpBudgetRecommendation", spbro)
  71. protime(start_time)
  72. start_time = time.time()
  73. sptb = SpTargetsBidRecommendations(profile_id="3006125408623189")
  74. sptbo = sptb.updata_create()
  75. print("SpTargetsBidRecommendations", sptbo)
  76. protime(start_time)
  77. start_time = time.time()
  78. sptbv2 = SpTargetsBidRecommendationsV2(profile_id="3006125408623189")
  79. sptbv2o = sptbv2.updata_create()
  80. print("SpTargetsBidRecommendationsV2", sptbv2o)
  81. protime(start_time)
  82. start_time = time.time()
  83. spnt = SpNegativeTarget(profile_id="3006125408623189")
  84. spnto = spnt.updata_create()
  85. print('SpNegativeTarget', spnto)
  86. protime(start_time)
  87. start_time = time.time()
  88. spnk = SpNegativeKeyword(profile_id="3006125408623189")
  89. spnko = spnk.updata_create()
  90. print('SpNegativeKeyword', spnko)
  91. protime(start_time)
  92. start_time = time.time()
  93. sbc = SbCampaign(profile_id="3006125408623189")
  94. sbco = sbc.updata_create()
  95. print("SbCampaign", sbco)
  96. protime(start_time)
  97. start_time = time.time()
  98. sbg = SbGroup(profile_id="3006125408623189")
  99. sbgo = sbg.updata_create()
  100. print("SbGroup", sbgo)
  101. protime(start_time)
  102. start_time = time.time()
  103. sbk = SbKeyword(profile_id="3006125408623189")
  104. sbko = sbk.updata_create()
  105. print("SbKeyword", sbko)
  106. protime(start_time)
  107. start_time = time.time()
  108. sba = SbAds(profile_id="3006125408623189")
  109. sbao = sba.updata_create()
  110. print("SbAds", sbao)
  111. protime(start_time)
  112. start_time = time.time()
  113. sbkbr = SbkeywordsBidRecommendations(profile_id="3006125408623189")
  114. sbkbro = sbkbr.updata_create()
  115. print("SbkeywordsBidRecommendations", sbkbro)
  116. protime(start_time)
  117. start_time = time.time()
  118. sbt = SbTargets(profile_id="3006125408623189")
  119. sbto = sbt.updata_create()
  120. print("SbTargets", sbto)
  121. protime(start_time)
  122. start_time = time.time()
  123. sbtbr = SbtargetsBidRecommendations(profile_id="3006125408623189")
  124. sbtbro = sbtbr.updata_create()
  125. print("SbtargetsBidRecommendations", sbtbro)
  126. protime(start_time)
  127. start_time = time.time()
  128. Sbnk = SbNegtiveKeyword(profile_id="3006125408623189")
  129. Sbnko = Sbnk.updata_create()
  130. print("SbNegtiveKeyword", Sbnko)
  131. protime(start_time)
  132. start_time = time.time()
  133. Sbtt = SbThemeTargeting(profile_id="3006125408623189")
  134. Sbtto = Sbtt.updata_create()
  135. print("SbThemeTargeting", Sbtto)
  136. protime(start_time)
  137. start_time = time.time()
  138. ass = Assets(profile_id="3006125408623189")
  139. asso = ass.updata_create()
  140. print("Assets", asso)
  141. protime(start_time)
  142. start_time = time.time()
  143. plu = ProductLineDetail(profile_id="3006125408623189")
  144. pluo = plu.updata_create()
  145. print("PlUpdate", pluo)
  146. protime(start_time)