def uploadFileToGoogleDrive(fileName, localFilePath):\n ext = os.path.splitext(localFilePath.lower())[1][1:]\n if ext == "jpg":\n ext = "jpeg"\n mimeType = "image\/" + ext\n\n service = getGoogleService()\n file_metadata = {"name": fileName, "mimeType": mimeType, "parents": [<<your_parents>>] } \n media = MediaFileUpload(localFilePath, mimetype=mimeType, resumable=True) \n file = service.files().create(body=file_metadata, media_body=media, fields='id').execute()\n\n\ndef getGoogleService():\n scope = ['https:\/\/www.googleapis.com\/auth\/drive.file'] \n keyFile = 'service-account-key.json'\n credentials = ServiceAccountCredentials.from_json_keyfile_name(keyFile, scopes=scope)\n\n return build("drive", "v3", credentials=credentials, cache_discovery=False)\n<\/code><\/pre><\/div>\n\n\n\n<\/p>\n\n\n\n
<<table_name>>\u3068<<column_names>>\u306b\u306f\u4fdd\u5b58\u3057\u305f\u3044DynamoDB\u306e\u30c6\u30fc\u30d6\u30eb\u60c5\u5831\u3092\u5165\u529b\u3057\u307e\u3059\u3002<\/p>\n\n\n\n
import boto3\nfrom boto3.session import Session\nfrom googleapiclient.discovery import build \nfrom googleapiclient.http import MediaFileUpload \nfrom oauth2client.service_account import ServiceAccountCredentials \nimport csv\nimport json\nimport os\nimport ast\nimport datetime\n\nimport logging\nlogger = logging.getLogger()\nlogger.setLevel(logging.INFO)\n\ndef lambda_handler(event, context):\n session = Session()\n dynamo = session.client("dynamodb")\n \n table_names = [<<table_name>>]\n labels_list = [[<<column_names>>]]\n \n dt_now = datetime.datetime.now()\n \n for table_name, labels in zip (table_names, labels_list):\n get_data = get_all_data(dynamo, table_name)\n\n with open('\/tmp\/upload.csv', 'w', encoding='utf_8_sig') as f:\n writer = csv.DictWriter(f, fieldnames=labels)\n writer.writeheader()\n for elem in get_data:\n keys = elem.keys()\n values = elem.values()\n values_list = []\n \n for v in values:\n dic = ast.literal_eval(str(v))\n \n if type(list(dic.values())[0]) is list:\n lis = [list(dic.values())[0][0]['N'], list(dic.values())[0][1]['N'], list(dic.values())[0][2]['N']]\n values_list.append(lis)\n \n else:\n print(list(dic.values())[0])\n values_list.append(list(dic.values())[0])\n \n d = dict(zip(keys,values_list))\n writer.writerow(d)\n \n uploadFileToGoogleDrive(f'{table_name}_{dt_now.year}_{dt_now.month}_{dt_now.day}.csv', '\/tmp\/upload.csv')\n \n return<\/code><\/pre><\/div>\n\n\n\n<\/p>\n\n\n\n
\u7d50\u679c<\/h4>\n\n\n\n
\u7121\u4e8b\u3001google drive\u306b\u30a2\u30c3\u30d7\u30ed\u30fc\u30c9\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u307e\u3057\u305f\u3002<\/p>\n\n\n\n![\"\"](\"https:\/\/is-ai.jp\/wp-content\/uploads\/2022\/03\/3658183c591bcfe057d463406397ffab-1024x604.png\")
<\/figure>\n\n\n\n\u304a\u308f\u308a\u306b<\/h4>\n\n\n\n
\u4ee5\u4e0a\u3067\u4efb\u610f\u306e\u30c6\u30fc\u30d6\u30eb\u30c7\u30fc\u30bf\u3092csv\u5f62\u5f0f\u3067google drive\u306b\u51fa\u529b\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3057\u305f\u3002\u30c7\u30fc\u30bf\u306e\u5171\u6709\u306f\u5fc5\u8981\u306a\u5de5\u7a0b\u3060\u3068\u601d\u3046\u306e\u3067\u3001\u4eca\u5f8c\u3082\u51fa\u756a\u304c\u3042\u308b\u304b\u3082\u3057\u308c\u307e\u305b\u3093\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"
\u306f\u3058\u3081\u306b dynamoDB\u306e\u7d50\u679c\u3092\u5b9a\u671f\u7684\u306b\u78ba\u8a8d\u3057\u305f\u3044\u3002\u3068\u3044\u3046\u8981\u671b\u304c\u3042\u308a\u3001\u305d\u306e\u5b9f\u88c5\u3092\u884c\u3044\u307e\u3057\u305f\u3002\u57fa\u672c\u7684\u306a\u65b9\u91dd\u306fAWS Lambda\u3067\u5b9a\u671f\u5b9f\u884c\u3092\u884c\u3044\u3001dynamoDB\u5185\u306e\u30c7\u30fc\u30bf\u3092csv\u5f62\u5f0f\u306b\u4fdd\u5b58\u3057\u3066\u3001google drive\u2026<\/p>\n","protected":false},"author":1,"featured_media":233,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[10],"tags":[20,21,7],"_links":{"self":[{"href":"https:\/\/is-ai.jp\/index.php?rest_route=\/wp\/v2\/posts\/232"}],"collection":[{"href":"https:\/\/is-ai.jp\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/is-ai.jp\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/is-ai.jp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/is-ai.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=232"}],"version-history":[{"count":5,"href":"https:\/\/is-ai.jp\/index.php?rest_route=\/wp\/v2\/posts\/232\/revisions"}],"predecessor-version":[{"id":239,"href":"https:\/\/is-ai.jp\/index.php?rest_route=\/wp\/v2\/posts\/232\/revisions\/239"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/is-ai.jp\/index.php?rest_route=\/wp\/v2\/media\/233"}],"wp:attachment":[{"href":"https:\/\/is-ai.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=232"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/is-ai.jp\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=232"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/is-ai.jp\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=232"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}