wg_alldatainsert.py 6.1 KB

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