Data/product_dummy.py at main · SpringMarket/Data · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
from faker import Faker
import random
import pandas as pd
import config
import numpy as np
from product_name_provider import ProductProvider
from sqlalchemy import create_engine
import sqlalchemy as db
from datetime import datetime,timedelta

fake = Faker('ko_KR') # locale 정보 설정

num = 500000

# 상품 번호
# productId = [i for i in range(1500001, 1500001+num)]
# productId = [i for i in range(500001, 1000001)]
productId = [i for i in range(8000001, 8000001+num)]

# 카테고리 id
categoryId = []
title = []
photo = []

# 아우터
photo1 = ['https://gloryoneteam.s3.ap-northeast-2.amazonaws.com/%EC%95%84%EC%9A%B0%ED%84%B01.jpg',
          'https://gloryoneteam.s3.ap-northeast-2.amazonaws.com/%EC%95%84%EC%9A%B0%ED%84%B02.jpg',
          'https://gloryoneteam.s3.ap-northeast-2.amazonaws.com/%EC%95%84%EC%9A%B0%ED%84%B03.jpg',
          'https://gloryoneteam.s3.ap-northeast-2.amazonaws.com/%EC%95%84%EC%9A%B0%ED%84%B04.jpg',
          'https://gloryoneteam.s3.ap-northeast-2.amazonaws.com/%EC%95%84%EC%9A%B0%ED%84%B05.jpg'
          ]
# 상의
photo2 = ['https://gloryoneteam.s3.ap-northeast-2.amazonaws.com/%EC%83%81%EC%9D%981.jpg',
          'https://gloryoneteam.s3.ap-northeast-2.amazonaws.com/%EC%83%81%EC%9D%982.jpg',
          'https://gloryoneteam.s3.ap-northeast-2.amazonaws.com/%EC%83%81%EC%9D%983.jpg',
          'https://gloryoneteam.s3.ap-northeast-2.amazonaws.com/%EC%83%81%EC%9D%984.jpg',
          'https://gloryoneteam.s3.ap-northeast-2.amazonaws.com/%EC%83%81%EC%9D%985.jpg'
          ]

# 하의
photo3 = ['https://gloryoneteam.s3.ap-northeast-2.amazonaws.com/%EB%B0%94%EC%A7%801.jpg',
          'https://gloryoneteam.s3.ap-northeast-2.amazonaws.com/%EB%B0%94%EC%A7%802.jpg',
          'https://gloryoneteam.s3.ap-northeast-2.amazonaws.com/%EB%B0%94%EC%A7%803.jpg',
          'https://gloryoneteam.s3.ap-northeast-2.amazonaws.com/%EB%B0%94%EC%A7%804.jpg',
          'https://gloryoneteam.s3.ap-northeast-2.amazonaws.com/%EB%B0%94%EC%A7%805.jpg',
          ]

# 신발
photo4 = ['https://gloryoneteam.s3.ap-northeast-2.amazonaws.com/%EC%8B%A0%EB%B0%9C1.jpg',
          'https://gloryoneteam.s3.ap-northeast-2.amazonaws.com/%EC%8B%A0%EB%B0%9C2.jpg',
          'https://gloryoneteam.s3.ap-northeast-2.amazonaws.com/%EC%8B%A0%EB%B0%9C3.jpg',
          'https://gloryoneteam.s3.ap-northeast-2.amazonaws.com/%EC%8B%A0%EB%B0%9C4.jpg',
          'https://gloryoneteam.s3.ap-northeast-2.amazonaws.com/%EC%8B%A0%EB%B0%9C5.jpg'
         ]
# 원피스
photo5 = ['https://gloryoneteam.s3.ap-northeast-2.amazonaws.com/%EC%9B%90%ED%94%BC%EC%8A%A41.jpg',
          'https://gloryoneteam.s3.ap-northeast-2.amazonaws.com/%EC%9B%90%ED%94%BC%EC%8A%A42.jpg',
          'https://gloryoneteam.s3.ap-northeast-2.amazonaws.com/%EC%9B%90%ED%94%BC%EC%8A%A43.jpg',
          'https://gloryoneteam.s3.ap-northeast-2.amazonaws.com/%EC%9B%90%ED%94%BC%EC%8A%A44.jpg',
          'https://gloryoneteam.s3.ap-northeast-2.amazonaws.com/%EC%9B%90%ED%94%BC%EC%8A%A45.jpg']


# 상품 이름

for i in range(num):
    fake.add_provider(ProductProvider)
    id = random.randint(1,5)
    categoryId.append(id)
    if id == 1:
        title.append(fake.product_name('아우터'))
        photo.append(random.choice(photo1))
    elif id == 2:
        title.append(fake.product_name('상의'))
        photo.append(random.choice(photo2))
    elif id == 3:
        title.append(fake.product_name('하의'))
        photo.append(random.choice(photo3))
    elif id == 4:
        title.append(fake.product_name('신발'))
        photo.append(random.choice(photo4))
    elif id == 5:
        title.append(fake.product_name('원피스'))
        photo.append(random.choice(photo5))


# 상품 내용
content = [fake.sentence() for i in range(num)]

# 상품 가격
price = [int(str(random.randint(1,50))+'0000') for i in range(num)]


# 0~50만건 datetime(2017,1,1,0,0,0) ~ 2017년 2월까지
# 50만건 ~ 100만건 datetime(2017,3,1,0,0,0) ~ 2017년 4월까지
# 100만건 ~ 150만건 datetime(2017,5,1,0,0,0) ~ 2017년 6월까지
# 150만건 ~ 200만건 datetime(2017,7,1,0,0,0) ~ 2017년 8월까지
# 200만건 ~ 250만건 datetime(2017,9,1,0,0,0) ~ 2017년 10월까지
# 250만건 ~ 300만건 datetime(2017,11,1,0,0,0) ~ 2017년 12월까지
# 300만건 ~ 350만건 datetime(2018,1,1,0,0,0) ~ 2018년 2월까지
# 350만건 ~ 400만건 datetime(2018,3,1,0,0,0) ~ 2018년 4월까지
# 400만건 ~ 450만건 datetime(2018,5,1,0,0,0) ~ 2018년 6월까지
# 450만건 ~ 500만건 datetime(2018,7,1,0,0,0) ~ 2018년 6월까지
# 500만건 ~ 550만건 datetime(2018,9,1,0,0,0) ~ 2018년 6월까지

time1 = datetime(2017,1,1,0,0,0)
createdTime = [0 for i in range(num)]
for i in range(num):
    createdTime[i] = time1+timedelta(seconds=10)
    time1 = createdTime[i]

print(createdTime[0],createdTime[num-1])

#createdTime = [fake.date_time_between(start_date = '-6y', end_date = '-3y') for i in range(num)]

# 상품 재고
stock = [int(abs(np.random.normal(0,1)*100)) for i in range(num)]

# 상품 조회수
view = [(-1)*int(abs(np.random.standard_t(1)*1000))for i in range(num)]

df = pd.DataFrame()
df['product_id'] = productId
df['title'] = title
df['content'] = content
df['photo'] = photo
df['price'] = price
df['stock'] = stock
df['view'] = view
df['created_time'] = createdTime
df['category_id'] = categoryId
df['product_info_id'] = productId


records = df.to_dict(orient='records')

port = config.port
username = config.username
password = config.password
host = config.host
dbname = config.dbname

engine = create_engine(f"mysql://{username}:{password}@{host}:{port}/{dbname}?charset=utf8mb4")

with engine.connect() as conn:
    metadata = db.MetaData()
    table = db.Table('product', metadata, autoload=True, autoload_with=engine)
    query = db.insert(table).values(records)
    result_proxy = conn.execute(query)