#kwskrb #112 発表資料
PyCon JP 2022発表のプロトタイプ
Python͍ͷͨΊͷεϙʔπσʔλղੳͷ͖΄Μβ൛ʢ͘͠༧ࠂฤʣPyCon JP 2022ͷຊ൪લʹͪΐͬͱ͓ͯ͠Έ·ͨ͠.Shinichi [email protected] 2022/09/28 kawasaki.rb #112
View Slide
Onboardingʢ͜ͷࢿྉɾൃදͷҐஔ͚ͮʣ• PythonͱSparkͱύϒϦοΫΫϥυʢGoogle CloudʣͰ ඦGBҎ্ͷσʔλΛ͍͍ײ͡ʹॲཧͯ͠ѻ͓͏ͥʂ, ͱ͍͏.• PyCon JP 2022ʮPython͍ͷͨΊͷεϙʔπσʔλղੳͷ͖΄Μʯ ͰΔલʹͪΐͬͱ͚͓ͩ൸࿐͘͢࡞ͨ͠ͷͰ͢.• ݱ࣌Ͱͷ൛Ͱ, ຊ൪Ͱ༰͕มΘΔՄೳੑ͕͋Γ·͢.
Who am ɹ?ʢ͓લ୭Α?ʣ• Shinichi [email protected]• ֎ࢿITίϯαϧاۀϚωʔδϟʔ• ࣄΫϥυαʔϏεΛѻ͏ΤϯδχΞ. ʢͷνʔϜΛవΊΔϚωʔδϟʔʣ• ࠷ۙެࢲͱʹGoogle CloudΛ͏ਓ.• झຯͱ࣮ӹΛ݉Ͷͯݸਓ։ൃͯ͠·͢🍺#Python #GoogleCloud #Baseball#DataScience #SABRmetrics
ຊͷελʔςΟϯάϝϯόʔ• ϝδϟʔϦʔάͷϏοάσʔλͰ༡΅͏ ※PyConʹ͢• PythonͱGoogle CloudͰ࡞ΔαʔόϨεͰ͍͍ײ͡ͳσʔλج൫• PySpark + DataprocͰ࣮ݱ͢ΔαʔόϨεͳσʔλॲཧ• ࠓͷϝδϟʔϦʔάΛσʔλͰৼΓฦΔ ※PyConʹ͢
ࠓճѻ͏σʔλʮMLBͷϏοάσʔλʯ• ϝδϟʔϦʔάʮStatcastʯͱ͍͏γεςϜͰ৭ΜͳσʔλΛه͍ͯ͠·͢. ※ΧϝϥɾϨʔμʔͰه, Ұ෦౷ܭɾਓྗͰه• ྫ͑, ͜ͷลͷ࣮گͷݩωλͯ͢͜ͷʮStatcastʯͱ͍͏Ϗοάσʔλ͕ݩωλʹͳ͍ͬͯ·͢.• ΦΦλχαϯʂ˓߸ຊྥଧʂଧٿ180km/h, ඈڑ130m• ΦΦλχαϯʂ162km/hͷਅ͙ͬͰݟಀ͠ࡾৼʂʂʂ• ٿͷҰڍखҰ, ͯ͢ͷٿɾଧٿσʔλ͕ه͞ΕΔ.• ϨΪϡϥʔγʔζϯʢ30νʔϜɾ162ࢼ߹ʣͰ͓͓Αͦ70ʙ80ສٿલޙ. ϙετγʔζϯɾय़Ωϟϯϓσʔλ͋Δ.• σʔλ91ݸͷ߲ʢ!?ʣͰߏ͞ΕΔ, ϨΪϡϥʔγʔζϯͰ͓͓Αͦ400MBʙ600MB͙Β͍ͷσʔλ.• baseballsavant.mlb.com ͱ͍͏αΠτͰ୭ͰӾཡɾμϯϩʔυʢCSV ϑΥʔϚοτʣͰ͖·͢.
ϫΠʮຖຖࢼ߹ݟΔΈཉ͍͠ʯຖσʔλऩू -> BigQueryʹอଘ -> ՄࢹԽ, తͳج൫࡞ͬͪΌ͑ʂ
ͱ͍͏Θ͚Ͱ, ͪΐͬ͜ͱ࡞ͬͯΈ·ͨ͠.
PythonͱGoogle CloudͰ࡞ΔαʔόϨεͰ͍͍ײ͡ͳσʔλج൫ʢٿฤʣ
ΞʔΩςΫνϟͷશମ૾
ΞʔΩςΫνϟղઆʢ㲈ͩ͜ΘΓϙΠϯτʣ• ຖσʔλ֬ೝɾຖσʔλߋ৽Λ͍͍ײ͡ʹ࣮ݱ͢ΔͨΊ, ʮϑϧϚωʔδυͳαʔόϨεܥΫϥυαʔϏεʯΛશ໘తʹ׆༻ͯ͠ߏஙɾӡ༻.• ʮϑϧϚωʔδυͳαʔόϨεܥΫϥυαʔϏεʯ #ͱ• CLIίϯιʔϧͰϙνϙν͢Δ͚ͩͰͻͱ·্ཱ͕ͣͪΔ• Πϯϑϥɾαʔόʔͷϝϯςφϯε͕ෆཁʢࣗ͡Όͳͯ͘, ΫϥυαʔϏεଆ͕Δʣ• ΑΓ۩ମతʹ, ࣗͰK8sΫϥελVMΛݐͯͳͯ͘ྑ͍ʢωοτϫʔΫͷઃఆൃੜʣ• GitHub ActionsͷCI/CDͷύΠϓϥΠϯʹΈࠐΜͰσϓϩΠɾεέʔϧͰ͖ͨΓ جຊతʹʮ͚ͬͨͩ՝ۚʯʹͳΔͷͰ͓ࡒʹ༏͍͠👛
ϢʔεέʔεͱͬͨαʔϏε
μογϡϘʔυΞϓϦ• ΞϓϦຊମCloud RunͰϗεςΟϯά, API GatewayΛ௨ͯ͠όοΫΤϯυʢCloud FunctionsʣʹΞΫηε• Firestore͕ϝΠϯͷDB, CacheͷMemoryStoreʢRedisʣΛஔ͍͍ͯΔ• ͜͜ͰSparkʢPySparkʣొ͠·ͤΜ
σʔλऩू&BigQueryอଘ• σʔλݩαΠτʢBaseball Savantʣ͔Βఆظతʹσʔλऩू͢ΔΫϩʔϥʔʢCloud Functionsʣ࣮ߦ• ࣮ߦ݁ՌGoogle Cloud StorageʢGCSʣʹCSVͱͯ͠อଘ. ͜Ε͕ݯઘͷσʔλʢDatalakeʣ• GCS্ͷCSVΛαϚϦʔ͍͍ͯ͠ײ͡ʹͯ͠BigQueryʹอଘ͢ΔPySparkεΫϦϓτΛDataproc Serverless্Ͱ࣮ߦ
FirestoreೖʢDatabaseʹσʔλҠૹʣ• BigQueryσʔλΛμογϡϘʔυ༻σʔλͷܗࣜʢJSONʣʹม͢ΔPySparkεΫϦϓτΛDataproc Serverless্Ͱ࣮ߦ• ࣮ߦ݁ՌʢGCS্ʹJSONܗࣜͰอଘʣΛFirestoreʹೖΕΔͨΊͷPythonεΫϦϓτΛ࣮ߦ• ͳ͓͍ͣΕखಈͰͷ࣮ߦʢཧ༝&ରԠࡦޙ΄Ͳʣ
PySpark + DataprocͰ࣮ݱ͢ΔαʔόϨεͳσʔλॲཧ※͕͜͜͜ͷτʔΫͷຊͱͳΓ·͢.
͜ͷͷείʔϓ
33.4ඵͰΘ͔ͬͨʢؾʹͳΔʣ🐯SparkͱPySpark
SparkͱPySpark• ʮେ͖͍σʔλΛ͍͍ײ͡ʹࢄͯ͠ॲཧ͢ΔʯͨΊͷFramework• ྺ࢙తͳͰ͍͑HadoopͷޙܧͰ, ར༻ࣄྫ݁ߏ͋Δ.• ϥΠϒϥϦɾAPIͷ࣮Java͕ͩ, ʮPySparkʯͱ͍͏ PythonͷInterface͕͋Δ.• DataFrame APIͱ͍͏, PandasͰ͓ೃછΈͷDataFrameͳInterface ͕͋Γ, ͜ΕΛϝΠϯʹ͏ͱ͍͍ײ͡ʹ͑Δ.
SparkʢͱPySparkʣͷ͍ํ• σʔληοτ• େݩͷσʔλRDDʢResilient Distributed DatasetʣͰߏɾཧ.• RDDΛ͍͍ײ͡ʹѻ͏Interfaceͱͯ͠DataFrame API͕ଘࡏ͢Δ.• DataFramePandasͬΆ͍͍ํ͕ग़དྷΔ.• ͍ํ• εΫϦϓτΛॻ͍ͯSparkڥ্Ͱ࣮ߦ.• Jupyter Lab, Zeppelin notebookͰΞυϗοΫʹ͏.
ڥΛͲ͜Ͱߏஙɾӡ༻͢Δ͔🤔ڥɾखஈ ߏஙͷखؒ ӡ༻͢͠͞ උߟΦϯϓϨϛεͰશͯࣗલߏஙɾӡ༻શͯࣗલͰઃఆ͢Δඞཁ͕͋ΔԿ͔ΒԿ·ͰࣗͰݟΔඞཁ͕͋ΔҰ൪େมͳύλʔϯຊ৬ͷΠϯϑϥΤϯδχΞͰ͖͍ͭࣄΫϥυ্ͷ7.,TʹࣗલͰߏஙɾӡ༻શͯࣗલͰઃఆ͢Δඞཁ͕͋Δ͋ΔఔΫϥυαʔϏεͷԸܙʹत͔ΕΔ4QBSLڥͷࣗલߏஙׂͱқ͕ߴ͍ΫϥυαʔϏεఏڙͷϚωʔδυαʔϏεΛ͏˞࠷ਪ͢Δํࣜ(6*Ͱϙνϙν͢Δ͘͠$-*"1*Ͱ͍͍ײ͡ʹ࣮ߦ$16ͷϦιʔεΛࢹঢ়گʹԠͯ͡ϝϯςφϯε࠷ָ͔ͭεϚʔτͳํ๏"84 (PPHMF$MPVEଞ֤ࣾαʔϏε༗
Google Cloudʹ͓͚ΔSparkӡ༻ͷબࢶڥɾखஈ ߏங ӡ༻ ͑Δػೳ උߟ($&PS(,&ʹڥΛ࡞ͬͯӡ༻ࣗલͰߏஙޙ4QBSLΛಋೖશͯࣗલͰӡ༻໘ΛݟΔඞཁ༗શͯͷػೳ݁ہͷॴ%BUBQSPDͰग़དྷΔ͜ͱͳͷͰ͓͢͢Ί͠ͳ͍%BUBQSPDHDMPVEίϚϯυ "1* ίϯιʔϧͷͲΕ͔Ͱߏங%BUBQSPD͕࡞ͬͨ(,&PS($&ڥΛࢹɾӡ༻શͯͷػೳ Ұ൪ඪ४తͳߏ%BUBQSPD4FSWFSMFTTHDMPVEίϚϯυ "1* ίϯιʔϧ্هͷͲΕ͔Ͱߏங࣮ߦதͷࢹͷΈڥॲཧޙʹࣗಈআόονॲཧͷΈରԠOPUFCPPL͑ͳ͍ఆظతͳόονॲཧ͜Ε͕Ұ൪͍͍
DataprocͱDataproc Serverless• Google CloudʹDataprocͱ͍͏SparkʢHadoopʣͷ ϚωʔδυαʔϏε͕ଘࡏ͢Δ.• ࠓ·ͰGCEGKEʢK8sʣͰʮϗετɾCluster͕ଘࡏʯલఏͷ ӡ༻͔͠Ͱ͖ͳ͔͕ͬͨ, ͍ͭ࠷ۙServerlessͱ͍͏બࢶ͕ര• ʮ11ճʯʮ30͓͖ʯΈ͍ͨͳόονӡ༻Ͱ͋Ε Serverless͕͑Δʂͨͩ͠notebookܥͷ࣮ߦʢJupyterͳͲʣະରԠ• Serverless͚ͬͨͩ՝ۚͳͷͰ͓ࡒʹ༏͍͠👛
PySparkΛͬͯͬͨλεΫΛհ• σʔλऩू&BigQueryͷσʔλೖ• μογϡϘʔυΞϓϦ༻DBʢFirestoreʣͷσʔλೖ
ʲ࠶ܝʳσʔλऩू&BigQueryอଘ• σʔλݩαΠτʢBaseball Savantʣ͔Βఆظతʹσʔλऩू͢ΔΫϩʔϥʔʢCloud Functionsʣ࣮ߦ• ࣮ߦ݁ՌGoogle Cloud StorageʢGCSʣʹCSVͱͯ͠อଘ. ͜Ε͕ݯઘͷσʔλʢDatalakeʣ• GCS্ͷCSVΛαϚϦʔ͍͍ͯ͠ײ͡ʹͯ͠BigQueryʹอଘ͢ΔPySparkεΫϦϓτΛDataproc Serverless্Ͱ࣮ߦ
σʔλऩूʢnot Sparkʣ• WebεΫϨΠϐϯάSparkͰ Δ͖͜ͱͰͳ͍.• λεΫΛrequests-htmlͰ࣮, Cloud FunctionsͰӡ༻ͯ͠ରॲ.• Cloud SchedulerͷCronઃఆͰ ఆظ࣮ߦ, GCSʹอଘ
CSVσʔλΛBigQueryʹೖ• Dataproc্ͰΔλεΫͱͯ͠ దͳൣғɾॲཧͷҰͭ• GCSͷύε͔ΒϑΝΠϧநग़ Spark SQLͰॲཧͯ͠BigQuery• DataFrameͱSQL͕Θ͔Ε ͍͍ײ͡ʹ࣮ɾӡ༻Մೳ
DataprocΛ͓͏• Google CloudͷυΩϡϝϯτɾαϯϓϧΛࣸܦ͠ͳ͕ΒΔͱྑ͖• https://cloud.google.com/dataproc• https://cloud.google.com/dataproc-serverless/docs• https://github.com/GoogleCloudDataproc/cloud-dataproc• Serverlessͷ߹, ࣄલʹVPC subnetΛ࡞Δඞཁ͋Γ• ࣍ϖʔδ͔Β, PySparkΛͬͯΔ߹ͷαϯϓϧΛগ͠հ• αϯϓϧίʔυType Hints࣮ͬͯͯ͠·͕͢ผʹແ͍͍ͯ͘Ͱ͢. ʢͲ͜ͷInterfaceͳͷ͔Θ͔Γ͘͢͢ΔͨΊ, ͑ͯType HintsΛͬͯॻ͍͍ͯ·͢ʣ.
ͻͱ·࣮ͣ1. SessionΛ࡞Δfrom pyspark.sql import SparkSession# BigQueryΛ͏&StringͷൣғΛ͛Δspark: SparkSession = SparkSession \.builder \.appName(‘app_yakiu')\.config('spark.jars', 'gs://spark-lib/bigquery/spark-bigquery-with-dependencies_2.12-0.25.2.jar') \.config('spark.sql.debug.maxToStringFields', 2000) \.getOrCreate()# ͜ΕDataprocಛ༗ͷఆٛ, ࣮ߦ࣌ͷtemporaryྖҬspark.conf.set('temporaryGcsBucket', 'GCSͷόέοτ໊')• దͳ.pyϑΝΠϧΛ࡞Δ• SparkSessionΛੜ͢Δ• ඞཁͳJARఆٛΛઃఆ BigQueryΛ͏࣌ JARͷࢦఆ͕ඞਢ
ͻͱ·࣮ͣ2. SchemaΛ࡞Δfrom pyspark.sql.types import StructType, StructField,DoubleType, DateType, StringType, LongType# schemaઃఆʢͪΐͬͱ͍ʣSTATCAST_SCHEMA: StructType = StructType([StructField("pitch_type", StringType(), False),StructField("game_date", DateType(), False),StructField("release_speed", DoubleType(), False),StructField("release_pos_x", DoubleType(), False),StructField("release_pos_z", DoubleType(), False),# ͗͢ΔͷͰলུʢ91߲͋ΔʣStructField("spin_axis", DoubleType(), False),StructField("delta_home_win_exp", DoubleType(), False),StructField("delta_run_exp", DoubleType(), False)])• CSVͷ߹SchemaΛ࡞Δ• ͜Ε͕ແ͍ͱҙਤ௨Γʹ ಈ͔ͳ͍• 91߲ͷSchema ؤுͬͯॻ͖·ͨ͠ྦ
ͻͱ·࣮ͣ3. CSVಡΈࠐΉfrom pyspark.sql import DataFrame as SparkDataFramefrom schema import STATCAST_SCHEMA # ઌ΄ͲͷεΩʔϚఆٛ# ࠷ॳʹੜͨ͠sparkηογϣϯ͔ΒreadؔΛCSV FormatࢦఆͰಈ͔͢def read_csv(date: str, filename: str, schema: StructType = None) ->SparkDataFrame:try:return spark.read \.format('csv') \.options(header="true", inferSchema="true") \.load(f'gs://your-bucket-name/path/{date}/{filename}', schema=schema)except AnalysisException:return None # type: ignoresdf: SparkDataFrame = read_csv('2022-10-15', 'batter.csv',schema=STATCAST_SCHEMA)• sparkηογϣϯͷreadΛ ͏, formatʹCSVΛࢦఆ• ϔομʔͱͯ͠ઌ΄Ͳͷ SchemaΛࢦఆ• GCSͷϑϧύεΛࢦఆ
ͻͱ·࣮ͣ4. BigQueryอଘfrom pyspark.sql import DataFrame as SparkDataFrame# BigQueryʹอଘ͢Δؔdef save_bigquery(sdf: SparkDataFrame, table_name: str) -> None:sdf.write\.mode('append') \.format('bigquery') \.option('project', 'your project name') \.option('table', f'dataset.{table_name}') \.option('temporaryGcsBucket', 'GCSͷόέοτ໊') \.option('createDisposition', 'CREATE_NEVER') \.save()# Spark DataFrameͱBigQueryͷςʔϒϧ໊Λࢦఆsave_bigquery(sdf, 'batting_data')• DataFrameͷwriteؔ• bigqueryΛࢦఆ• ྫطଘςʔϒϧͷ هॻ͖ࠐΈ
Dataproc ServerlessΛ࣮ͬͯߦ# ࣮ߦϑΝΠϧΛGCSʹΞοϓϩʔυgsutil -m cp -r app gs://your-gcs-bucket/script# bata optionΛ͚ͭΔͱαʔόϨε࣮ߦʹͳΓ·͢gcloud beta dataproc batches submit \--project your-project \--region asia-northeast1 pyspark \--batch hello-world gs://your-gcs-bucket/script/app/csv2bq_daily.py \--jars gs://spark-lib/bigquery/spark-bigquery-with-dependencies_2.12-0.25.2.jar \--subnet your-subnet \--py-files gs://your-gcs-bucket/script/app/environment.py,gs://your-gcs-bucket/script/app/query.py,gs://your-gcs-bucket/script/app/schema.py
ͬͯΈͨײ• ͻͱ·ͣ࡞Γ͍ͨͷ͕εϚʔτʹ࡞ΕͨͷͰྑ͔ͬͨ.• PySparkͷ࣮ͦͷͷDataprocͷํݴ͕গͳͯͦ͘͜ྑ͖.• ࣮ߦݖݶʢService Account & IAMʣσϑΥϧτͰ͍͍ײ͡ʹߦ͚ͨ.• BigQueryGCS࠷ॳ͔ΒϑϧͰ৮ΕΔ.• ͨͩ, ݖݶڧ͗͢Δઆ͋ΔͷͰ࣮ͷ࣌νϡʔχϯά͕ඞཁ͔.• ͋ΔఔSparkͱGoogle Cloudʹ׳ΕͯΔਓ͡Όͳ͍ͱΩπΠઆ? SparkΛॳΊͯ৮Γ·͢ʂͱ͍͏ํͪΐͬͱ֮ޛ͕ඞཁ͔͠Εͳ͍.
ʲ࠶ܝʳFirestoreೖʢDatabaseʹσʔλҠૹʣ• BigQueryσʔλΛμογϡϘʔυ༻σʔλͷܗࣜʢJSONʣʹม͢ΔPySparkεΫϦϓτΛDataproc Serverless্Ͱ࣮ߦ• ࣮ߦ݁ՌʢGCS্ʹJSONܗࣜͰอଘʣΛFirestoreʹೖΕΔͨΊͷPythonεΫϦϓτΛ࣮ߦ• ͳ͓͍ͣΕखಈͰͷ࣮ߦʢཧ༝&ରԠࡦޙ΄Ͳʣ
BigQuery͔ΒGCSʹϑΝΠϧग़ྗ for Dataproc• BigQueryͷσʔλΛSpark DataFrameʹ• Spark DataFrameΛϑΝΠϧग़ྗͪͳΈʹ࣮ߦํ๏ʢgcloud CLIʣมΘΒͳ͍ͷͰׂѪ͠·͢.
ͻͱ·࣮ͣ5. BigQueryಡࠐfrom pyspark.sql import SparkSessionfrom pyspark.sql import DataFrame as SparkDataFramefrom pyspark.sql.utils import AnalysisException# ͜͜ಉ͡spark: SparkSession = SparkSession \.builder \.appName('your app')\.config('spark.jars', 'gs://spark-lib/bigquery/spark-bigquery-with-dependencies_2.12-0.25.2.jar') \.config('spark.sql.debug.maxToStringFields', 2000) \.getOrCreate()spark.conf.set('temporaryGcsBucket', GCS_BUCKET)# ͜͜ͰViewಡΈऔΓΛ༗ޮԽ͠ͳ͍ͱΤϥʔʹͳΔͷͰҙspark.conf.set("viewsEnabled", "true")def read_bq() -> SparkDataFrame:"""Read Dashboard dataBigQuery View to SparkDataFrame"""try:df: SparkDataFrame = spark.read.format('bigquery') \.option('project', 'your project') \.option('table', f'your_project.view_baseball') \.load()return dfexcept AnalysisException:return None # type: ignoresdf: SparkDataFrame = read_bq()• อଘͱಉ͘͡BigQueryͷ JARΛࢦఆ• spark readͰBigQueryΛࢦఆ• BigQueryͷViewʹରͯ͠ ߦ͏߹, Φϓγϣϯ͕ඞཁ
ͻͱ·࣮ͣ6. GCSอଘfrom pyspark.sql import DataFrame as SparkDataFramedef save_json(sdf: SparkDataFrame) -> None:"""Save as JSON datasetSparkDataFrame to GCS Bucket"""sdf.write \.format("json") \.mode("overwrite") \.option("path", "gs://your-gcs-bucket/filepath/hoge") \.save()save_json(sdf)• DataFrameͷwriteؔ• jsonΛࢦఆ• ࠷ऴతͳύεΛࢦఆ
PySparkͱDataproc Serverless• ʮ͍͍ͨͱ͖͚ͩSparkΛ͏ʯͱ͍͏ϢʔεέʔεΛ࣮ݱՄೳ. ͜Ε͕αʔόϨεαʔϏεΛ͏͖࠷େͷཧ༝.• ࠓճͷΞϓϦέʔγϣϯͷσʔλαΠζʢ1Ͱ1GB͍͔ͳ͍ʣͩͱ Ըܙʹत͔Εͳ͍͕, ʮGB/ఔͷσʔλΛαΫοͱόονॲཧʯ Έ͍ͨͳϢʔεέʔεʹͳΔͱ݁ߏศརͳؾ͕͠·͢ʢલॲཧɾΫϨϯδϯά͢Δͱ͔ʣ.• ʮॲཧ͢Δͱ͖͚ͩಈ͔͢ʯͱ͍͏ײ͡ͷ͍ܰίʔυͳͷͰPySparkͱ૬ੑόπάϯ.• ͳ͓, ॲཧͷࣗಈԽͪΐͬͱบ͕͋Γ·͢, खஈ੍͕ݶ͞ΕΔʢͷͰखಈʹͨ͠ʣ. ࣗಈԽCloud ComposerʢAirflowʣͰΔͷ͕ࠓͷॴͷϕεϓϥͬΆ͍.
ࠓͷͷ·ͱΊ• PythonͰ͍͍ײ͡ʹσʔλॲཧΛ͢ΔͷʹPySparkྑ͍ͧ.• PySparkΫϥυͰಈ͔ͤ·͢, ࠓDataprocΛհ͠·ͨ͠.• αʔόϨεʹΫϥυΛ͑ΔΑ͏ʹͳΔͱ,৭ʑͱָ ͨͩ͠, ্༷ͷ੍ݶ͋ΔͷͰ༰ྔ༻๏Λਖ਼͘͠ཧղ͓ͯ͠͏.
Done.͝ਗ਼ௌ͋Γ͕ͱ͏͍͟͝·ͨ͠⽁
shinyorke
k1low
mii3king
weblyzard
yusuke0519
taishin
mitsuaki96
sakiengineer
trycycle
netmarkjp
oracle4engineer
tacck
shlominoach
samlambert
bluesmoon
addyosmani
brianwarren
jrom
aleyda
trallard
keavy
paulrobertlloyd
akosma
philhawksworth