[B! python][aws] bananapenguinã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

bananapenguin id:bananapenguin

pythonã¨awsã«é–¢ã™ã‚‹bananapenguinã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

Lambda x MySQLã§ãƒ‡ãƒ¼ã‚¿ã‚’æ›´æ–°ã—ã¦ã‚‚ã‚¯ã‚¨ãƒªçµæžœãŒå¤‰ã‚ã‚‰ãªã„ï¼ˆã‚ãƒ£ãƒƒã‚·ãƒ¥ã•ã‚Œã¦ã„ã‚‹ã‚ˆã†ãªæŒ¯ã‚‹èˆžã„ã‚’ã™ã‚‹ï¼‰ - Qiita
å•é¡Œ è¡¨é¡Œã®é€šã‚Šã ãŒã€Lambda x MySQL(RDS)ã§ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’å¤‰æ›´ã—ã¦ã‚‚ã€Lambdaä¸Šã§DBã«å¯¾ã™ã‚‹SELECTçµæžœãŒå¤‰ã‚ã‚‰ãªã„ã¨ã„ã†å•é¡ŒãŒèµ·ããŸã€‚ãã®å ´ã—ã®ãŽã¨ã—ã¦Lambdaã®ã‚³ãƒ¼ãƒ‰ã‚’å¤‰æ›´ã™ã‚‹ã¨ãƒ‡ãƒ¼ã‚¿å¤‰æ›´ãŒåæ˜ ã•ã‚Œã‚‹ãŸã‚ã€ãã®æ–¹æ³•ã§é‹ç”¨ã‚’ã—ã¦ã„ã‚‹ç’°å¢ƒã ã£ãŸï¼ˆã¾ãŸã¯ã€å°‘ã—æ™‚é–“ã‚’ç©ºã‘ã¦å†ã‚¯ã‚¨ãƒªãƒ¼ã—ã¦ã„ãŸï¼‰ã€‚å•é¡Œã®è§£æ¶ˆæ³•ãŒã‚ã‹ã£ãŸã®ã§è¼‰ã›ã¦ãŠãã€‚ãŸã ã—åŽŸå› ã¯ã‚ˆãã‚ã‹ã£ã¦ã„ãªã„ã€‚ è§£æ¶ˆæ–¹æ³• StackOverflowã§åŒæ§˜ã®ç¾è±¡ã§å›°ã£ã¦ã„ã‚‹äººãŒã„ã¦ã€å›žç”ã®é€šã‚Šã€Connectionç¢ºç«‹æ™‚ã« autocommit=True ã¨ã™ã‚‹ã“ã¨ã§å•é¡Œã‚’è§£æ¶ˆã§ããŸã€‚ã¾ãŸã¯å„SELECTå¾Œã«commitã—ã¦ã‚‚è§£æ¶ˆã§ãã‚‹ã‹ã¨æ€ã†ã€‚ stackoverflow: why is an aws lambda python call to a mysql rds being cached ä»¥ä¸‹ã¯pymysq
bananapenguin 2023/02/27
Lambda

aws

python

mysql
ãƒªãƒ³ã‚¯
Pillowï¼ˆPythonãƒ©ã‚¤ãƒ–ãƒ©ãƒªï¼‰ã‚’ä½¿ã£ã¦S3ã«æ ¼ç´ã•ã‚ŒãŸç”»åƒã‚’åœ§ç¸®ã—ã¦ã¿ã‚‹ | DevelopersIO
ã¯ã˜ã‚ã« ã“ã‚“ã«ã¡ã¯ã€‚å¤§é˜ªã‚ªãƒ•ã‚£ã‚¹ã®æž—ã§ã™ã€‚ Pillowã¨ã„ã†ç”»åƒå‡¦ç†ã®Pythonãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’ä½¿ã£ã¦S3ã«æ ¼ç´ã•ã‚ŒãŸç”»åƒãƒ‡ãƒ¼ã‚¿ã‚’åœ§ç¸®ã™ã‚‹å‡¦ç†ã‚’è©¦ã™æ©Ÿä¼šãŒã‚ã‚Šã¾ã—ãŸã®ã§å†…å®¹ã‚’ã¾ã¨ã‚ã¦ãŠããŸã„ã¨æ€ã„ã¾ã™ã€‚ ã‚„ã£ã¦ã¿ãŸ ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã®æº–å‚™ åŸºæœ¬çš„ãªé€²ã‚æ–¹ã¨ã—ã¦ã¯ä¸‹è¨˜ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã‚’å‚è€ƒã«ã—ã¦ã„ãã¾ã™ã€‚ä¸‹è¨˜ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã®ä¾‹ã§ã¯pandasã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹æ–¹æ³•ã§ã™ãŒã€æµã‚Œã‚„æ‰‹é †ãªã©ã¯ã»ã¼æµç”¨ã—ã¦Pillowã®æº–å‚™ã‚’é€²ã‚ã¦ã¿ãŸã„ã¨æ€ã„ã¾ã™ã€‚ æ‰‹é †ã«å¾“ã„ã€ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã«ä½¿ã†pipã‚³ãƒžãƒ³ãƒ‰ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ãŒ19.3.0ä»¥é™ã§ã‚ã‚‹ã“ã¨ã‚’ç¢ºèªã—ã¾ã™ã€‚ $ pip --version pip 22.2.2 from /home/hayashi/.local/lib/python3.9/site-packages/pip (python 3.9) 19.3.0ã‚ˆã‚Šå¤ã„ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã®å ´åˆã€æ¬¡ã®ã‚³ãƒžãƒ³ãƒ‰ã‚’å®Ÿè¡Œ
bananapenguin 2023/02/21
python

ç”»åƒ

Lambda

aws
ãƒªãƒ³ã‚¯
ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«æ¸ˆã¿ãƒã‚¤ãƒŠãƒªã‚’å«ã‚€ Python ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã‚’ Lambda ã«è¿½åŠ ã™ã‚‹
pip ã‚’ä½¿ç”¨ã—ã¦ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«æ¸ˆã¿ã‚³ãƒ¼ãƒ‰ã‚’å«ã‚€ Python ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸã‚‰ã€AWS Lambda é–¢æ•°ã‹ã‚‰ã€Œãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’ã‚¤ãƒ³ãƒãƒ¼ãƒˆã§ãã¾ã›ã‚“ã€ã¨ã„ã†ã‚¨ãƒ©ãƒ¼ãŒè¿”ã•ã‚Œã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ ç°¡å˜ãªèª¬æ˜Ž NumPy ã‚„ pandas ãªã©ã®ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«æ¸ˆã¿ã‚³ãƒ¼ãƒ‰ã‚’å«ã‚€ Python ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã¯ã€ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ã¯å¿…ãšã—ã‚‚ Lambda ãƒ©ãƒ³ã‚¿ã‚¤ãƒ ã¨äº’æ›æ€§ãŒã‚ã‚‹ã¨ã¯é™ã‚Šã¾ã›ã‚“ã€‚pip ã‚’ä½¿ç”¨ã—ã¦ã€ã“ã†ã—ãŸãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã¨ã€ãã®ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã§ã¯ã€ãƒãƒ¼ã‚«ãƒ«ãƒžã‚·ãƒ³ã®ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£å‘ã‘ã«ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«åãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ã¦ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«ã—ã¾ã™ã€‚Linux ã‚ªãƒšãƒ¬ãƒ¼ãƒ†ã‚£ãƒ³ã‚°ã‚·ã‚¹ãƒ†ãƒ (OS) ã‚’ä½¿ç”¨ã—ã¦ã„ãªã„å ´åˆã«ãã†ã™ã‚‹ã¨ã€ãƒ‡ãƒ—ãƒã‚¤ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã«ã¯ Lambda Python ãƒ©ãƒ³ã‚¿ã‚¤ãƒ ã¨ã®äº’æ›æ€§ãŒãªããªã‚Šã¾ã™ã€‚ ãƒ‡ãƒ—ãƒã‚¤ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã¾ãŸã¯ãƒ¬ã‚¤ãƒ¤ãƒ¼ã‚’ Linux ä»¥å¤–ã® OS ä¸Šã® La
bananapenguin 2023/02/21
programming

é–‹ç™º

aws

python
ãƒªãƒ³ã‚¯
[AWS Lambda] Pythonã§å¤–éƒ¨ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«(Pillow)ã‚’ä½¿ã† - Qiita
AWS Lambdaã§å¤–éƒ¨ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’è¿½åŠ ã™ã‚‹æ–¹æ³•ã‚’æƒ…å ±ã¾ã¨ã‚ãŸ AWS Lambdaã ã¨ä½¿ãˆãªã„ãƒ©ã‚¤ãƒ–ãƒ©ãƒª(ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«)ãŒã‚ã‚Šã¾ã™ãã€‚è¿½åŠ ãŒå¿…è¦ãªå ´é¢ãŒã‚ã‚Šã¾ã™ã®ã§å¤–éƒ¨ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã®è¿½åŠ ã«ã¤ã„ã¦ã¾ã¨ã‚ã¾ã™ã€‚ ä»Šå›žLambdaã§S3ã«ã‚¢ãƒƒãƒ—ã•ã‚ŒãŸç”»åƒã„ã˜ã‚ŠãŸã„ã®ã§ã§Pillowä½¿ãŠã†ã¨ã—ã¾ã—ãŸã€‚ ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’zipã§ã‚¢ãƒƒãƒ—ã™ã‚Œã°ã„ã„ã®ã¯çŸ¥ã£ã¦ã„ãŸã®ã§pip installã§ãƒ‡ãƒ¼ã‚¿å–å¾—ã§ããŸã‚‰zipã«ã—ã¦OKã§ã—ã‚‡ï¼ ã¨æ€ã£ã¦ãƒ†ã‚¹ãƒˆã‚’å®Ÿè¡Œã—ãŸã‚‰ [ERROR] Runtime.ImportModuleError: Unable to import module 'lambda_function': No module named 'PIL' ã¨ã‚¨ãƒ©ãƒ¼ã€‚pip installã ã¨ç„¡ç†ãªã®ã“ã‚Œ...ã©ã†ã™ã‚‹ã®ã“ã‚Œ...ã¿ãŸã„ã«ãªã£ãŸlambdaåˆå¿ƒè€…ã®ç§ã€‚ èª¿ã¹ã¦ã¿ã‚‹ã¨æ–¹æ³•ãŒä½•å€‹ã‹ã‚ã£ã¦ã€è½ã¨ã—ç©´
bananapenguin 2023/02/20
Lambda

aws

python

é–‹ç™º
ãƒªãƒ³ã‚¯
ã€AWSã€‘Lambdaã§pipã—ãŸã„ã¨æ€ã£ãŸã¨ãã«ã™ã¹ãã“ã¨ - Qiita
ã¯ã˜ã‚ã« Lambdaé–¢æ•°ã‚’ Python ã§æ›¸ã„ã¦ã„ã‚‹ã¨ã€Lambdaé–¢æ•°å†…ã§ã‚µãƒ¼ãƒ‰ãƒ‘ãƒ¼ãƒ†ã‚£ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’ä½¿ã„ãŸããªã‚‹ã¨ããŒã‚ã‚Šã¾ã™ã€‚ã—ã‹ã—ã€Lambda ã§ã¯ pip ã‚’ä½¿ã£ã¦ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã“ã¨ã¯ã§ãã¾ã›ã‚“ã€‚ä»Šå›žã¯ãã‚“ãªçŠ¶æ³ã§å½¹ã«ç«‹ã¤æ–¹æ³•ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ å…·ä½“çš„ã«ã¯ Lambda ã«ç”¨æ„ã•ã‚Œã¦ã„ã‚‹ãƒ•ã‚¡ã‚¤ãƒ«ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰æ©Ÿèƒ½ã‚’ä½¿ã„ã¾ã™ã€‚ã¤ã¾ã‚Šãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã™ã‚‹ã¨ãã«ã‚µãƒ¼ãƒ‰ãƒ‘ãƒ¼ãƒ†ã‚£ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã™ã‚‹ã“ã¨ã§ã€Lambdaé–¢æ•°å†…ã‹ã‚‰ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚’ä½¿ãˆã‚‹ã‚ˆã†ã«ã—ã¾ã™ã€‚ ä»Šå›žã¯ Python ã® HTTPãƒ©ã‚¤ãƒ–ãƒ©ãƒªã§ã‚ã‚‹ requestsã‚’ä½¿ã£ã¦ã¿ã‚ˆã†ã¨æ€ã„ã¾ã™ã€‚ é–¢é€£è¨˜äº‹ Lambdaé–¢æ•°ã®åŸºæœ¬çš„ãªä½œæˆæ–¹æ³•ã¯ä»¥ä¸‹ã®è¨˜äº‹ã‚’å‚è€ƒã«ã—ã¦ãã ã•ã„ã€‚ AWSã®API Gatewayã¨Lambdaã‚’ä½¿ã£ã¦Rest APIã‚’æ›¸ã„ã¦ã¿ãŸ æ‰‹é † ãƒãƒ¼ã‚«ãƒ«ã§ä½œæ¥ç”¨ãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã‚’ä½œæˆã™ã‚‹
bananapenguin 2022/06/08
Lambda

programming

aws

python
ãƒªãƒ³ã‚¯
ã€AWS Lambdaã€‘python ã§ VPC mysql ã«æŽ¥ç¶šã™ã‚‹ã€macã€‘ - Qiita
#config file credentials for rds mysql instance db_username = "æŽ¥ç¶šã—ãŸã„DBãƒ¦ãƒ¼ã‚¶å" db_password = "æŽ¥ç¶šã—ãŸã„DBãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰" db_name = "æŽ¥ç¶šã—ãŸã„DBå" import sys import logging import rds_config import pymysql #rds settings rds_host = "xx.rds.amazon aws.com" name = rds_config.db_username password = rds_config.db_password db_name = rds_config.db_name logger = logging.getLogger() logger.setLevel(logging.INFO) try: conn = pym
bananapenguin 2022/02/20
programming

Python

development

é–‹ç™º

AWS
ãƒªãƒ³ã‚¯
1