Slide 1

Slide 1 text

Winter Hung / LINE SHOPPING Data-Driven Testing For LINE SHOPPING 

Slide 2

Slide 2 text

Agenda › LINE SHOPPING Introduction › How to Use Real Data Integration Testing › What is Data-Driven Testing › Which Benefits are Data-Driven Testing › Conclusion 

Slide 3

Slide 3 text

LINE SHOPPING Introduction 

Slide 4

Slide 4 text

LINE SHOPPING E-Commerce Aggregation Center 

Slide 5

Slide 5 text

LINE SHOPPING Different Types of Costs Transaction fee COST PER SALE CPS  Number of clicks COST PER CLICK CPC Effective activities COST PER ACTION CPA Assist partners COST PER LEAD CPL

Slide 6

Slide 6 text

LINE SHOPPING Real Data of Search 

Slide 7

Slide 7 text

› Personalized recommendation › User has favorites store › Have Business browsing history › Start sending schedule every day Official Account Push 

Slide 8

Slide 8 text

Data-Driven Decision Linear Regression in Machine Learning Let’s predict Initializing the regression model Visualize the training and testing set Importing the dataset 

Slide 9

Slide 9 text

Data-Driven Decision Linear Regression in Machine Learning Test Set The testing set should be 5% to 30% of the dataset Training Set Our training model which will implement the Linear Regression. 

Slide 10

Slide 10 text

For KR How to Use Real Data Integration Testing 

Slide 11

Slide 11 text

LINE SHOPPING Search Features Product Store Content Price Comparison 

Slide 12

Slide 12 text

LINE SHOPPING SEARCH SYSTEM ARCHITECTURE  External Service 3FBM%BUB 3FBM%BUB 3FBM%BUB %BUB 'FFET Data Operation LINE Commerce Platform MongoDB OBS 1SPEVDU  $BUFHPSZ LINE SHOPPING SEARCH NAVER 4FBSDI  3FDPNNFOEBUJPO 
  
 4JNJMBS

Slide 13

Slide 13 text

LINE Commerce Platform  Application Layer LINE Shopping Front-APP LINE SHOPPING My-APP Domain Layer Product Domain Seller Domain Order Domain LCP

Slide 14

Slide 14 text

LINE SHOPPING SEARCH MOCK SERVER  MOCK SERVER 3FBM%BUB 5FTU%BUB %BUB 'FFET Data Operation LINE Commerce Platform MongoDB OBS 1SPEVDU  $BUFHPSZ LINE SHOPPING SEARCH NAVER 4FBSDI  3FDPNNFOEBUJPO 
  
 4JNJMBS

Slide 15

Slide 15 text

OBS Open Broadcast Services OBS is a media platform for LINE and LINE-family services, The platform comes with object storage by default Image presentation system › Creating a thumbnail › Transcoding videos and audiosArial › Analyzing media using advanced VISION-AI technology (OCR, Adult image filter, object detection) 

Slide 16

Slide 16 text

Mock-Server Easy Mocking Any System Easily recreate all types of responses Start working against a service API Isolate the system-under-test to ensure tests 

Slide 17

Slide 17 text

What is Data-Driven Testing DDT 

Slide 18

Slide 18 text

Data-Driven Testing SYSTEM ARCHITECTURE MYSQL 704'*-& %"5"%3*7&/ 4$3*15 "DUVBM3FTVMU GORM Compare Order Count

Slide 19

Slide 19 text

GORM Golang Object Relational Mapping Distributed applications of the GORM ORM in computer science is a programming technique for converting data between incompatible type systems in OOP languages. This creates, in effect, a “virtual object database” that can be used from within the programming language.LINE SHOPPING needs to verify data and consistent tests in MySQL 

Slide 20

Slide 20 text

OVERVIEW GIN + GORM + MYSQL  MYSQL $MJFOU (*/ (03. $MJFOU $MJFOU RESTFUL WEB SERVICE

Slide 21

Slide 21 text

GIN Golang Web Framework › Excellent performance › Native net/http package › Fast httprouter › Well-designed middleware › Excellent data binding 

Slide 22

Slide 22 text

OVERVIEW Code Folder Structure (03. .PEFMT $PO fi H $POUSPMMFST )FMQFST 3PVUFST Schema.go Model.go Database.go Controller.go Response.go Routers.go

Slide 23

Slide 23 text

GORM PROMETHEUS SYSTEM ARCHITECTURE  (03.#&5"5"3(&5 (03.45"(&5"3(&5 (03.130%5"3(&5 NFUSJDT NFUSJDT NFUSJDT

Slide 24

Slide 24 text

VOS Verda Object Storage VOS (Verda Object Storage) is an object storage service with comes with an S3 compatible Object Storage API. The S3 API is a de facto standard object storage API for AWS S3, which means we can utilize open-source software based on S3 API for VOS without changing our source code. We can use the S3 SDK to manage VOS objects. 

Slide 25

Slide 25 text

DDS Data Driven Script  ASSERTION MYSQL GORM REPORT Function TEST DATA

Slide 26

Slide 26 text

Benefits Which Benefits are Data-Driven Testing 

Slide 27

Slide 27 text

TIME Data verify of spend time more than 4x faster  MYSQL GORM & Jenkins SERVER MYSQL WORK BENCH SERVER 1 min 15 sec

Slide 28

Slide 28 text

1 2 3 4 5 6 7 8 9 10 11 0 350 700 1050 1400 Partner A Partner B Partner C Partner D Partner E Partner F Orders Count CPS REPORT  Month FAIL ORDERS COUNT

Slide 29

Slide 29 text

Coverage Health Check of Search AVG New Stores 102 AVG GMV Rate 15% AVG Fail Rate 0.16 

Slide 30

Slide 30 text

0 75000 150000 225000 300000 5 6 7 8 9 10 Partner A Partner B Partner C Partner D Partner E Partner F Order Counts TOP6  Month

Slide 31

Slide 31 text

3% 20% 23% 5% 29% 20% Partner A Partner B Partner C Partner D Partner E Partner F 8% 9% 11% 12% 14% 46% Partner A Partner B Partner C Partner D Partner E Partner F 80 / 20 DDT Observe  80% 20%

Slide 32

Slide 32 text

Conclusion › It is an ideal option to use realistic information › It allows multiple sets of data values during Health Check › Data-driven is a test automation methodology  › 80/20 is very suitable for quality control

Slide 33

Slide 33 text

Thank you