Podman\u3067Python\u7528\u30b3\u30f3\u30c6\u30ca\u3092\u4f5c\u6210\u3057\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9(MariaDB)\u7528\u30b3\u30f3\u30c6\u30ca\u306b\u63a5\u7d9a\u3055\u305b\u305f\u3044\u3002Python\u306f\u691c\u8a3c\u30fb\u30c6\u30b9\u30c8\u3067\u4f7f\u7528\u3059\u308b\u3060\u3051\u306a\u306e\u3067\u3001\u3067\u304d\u308b\u3060\u3051\u5c0f\u3055\u3081\u306e\u69cb\u6210\u304b\u3064\u30e1\u30e2\u30ea\u5272\u308a\u5f53\u3066\u3082\u5c11\u304f\u3066\u3082\u6e08\u3080\u3088\u3046\u306b\u30b3\u30f3\u30c6\u30ca\u3092\u7acb\u3066\u305f\u3044\u3002\u4ee5\u4e0b\u306b\u5bfe\u5fdc\u65b9\u6cd5\u3092\u30e1\u30e2\u3002<\/p>\n
<\/p>\n
\u4eca\u56de\u306fKAGOYA CLOUD VPS<\/a>\u306eCPU1\u30b3\u30a2 \/ \u30e1\u30e2\u30ea1GB\u30d7\u30e9\u30f3\u3067\u4f5c\u696d\u3057\u305f\u3002SSH\u63a5\u7d9a\u306f\u516c\u5f0f\u6848\u5185<\/a>\u306e\u901a\u308a\u4ee5\u4e0b\u3067\u30ed\u30b0\u30a4\u30f3\u3067\u304d\u308b\u3002<\/p>\n <\/p>\n \u30dc\u30ea\u30e5\u30fc\u30e0\u306e\u30db\u30b9\u30c8\u5074\u30d1\u30b9\u306f\u9069\u5b9c\u5909\u66f4\u3002<\/p>\n \u30b5\u30fc\u30d0\u306bSSH\u63a5\u7d9a\u3057\u3001\u4ee5\u4e0b\u306e\u901a\u308a\u9032\u3081\u308b\u3002<\/p>\n \u516c\u5f0f\u30b5\u30a4\u30c8\u306e\u30c6\u30b9\u30c8\u7528\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9<\/a>\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3057\u3066\u304a\u304f\u3002\u4eca\u56de\u306fWorld database\u3092\u30a4\u30f3\u30dd\u30fc\u30c8\u3057\u305f\u3002<\/p>\n \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306b\u63a5\u7d9a\u3057country_code=JPN\u306e\u30c7\u30fc\u30bf\u306eName\u30925\u4ef6\u8868\u793a\u3001\u30a8\u30e9\u30fc\u767a\u751f\u6642\u306f\u30bf\u30fc\u30df\u30ca\u30eb\u306b\u8868\u793a&\u30a8\u30e9\u30fc\u30ed\u30b0\u3092\u51fa\u529b\u3059\u308b\u3068\u3044\u3046\u3082\u306e\u3002\u63a5\u7d9a\u60c5\u5831\u306f\u9069\u5b9c\u5909\u66f4\u3002<\/p>\n \u4ee5\u4e0b\u306e\u901a\u308a\u6b63\u5e38\u306b\u8868\u793a\u3055\u308c\u305f\u3002<\/p>\n \u30c6\u30fc\u30d6\u30eb\u540d\u3092\u308f\u3056\u3068\u300cworlds\u300d\u306b\u66f8\u304d\u63db\u3048\u305f\u4e0a\u3067\u5b9f\u884c\u3059\u308b\u3068\u4ee5\u4e0b\u30a8\u30e9\u30fc\u8868\u793a\u3002<\/p>\n \u307e\u305f\u3001\u540c\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u5185\u306berror.log\u304c\u4f5c\u6210\u3055\u308c\u308b\u7b48\u3002<\/p>\n <\/p>\n \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u63a5\u7d9a\u6642\u306bIP\u30a2\u30c9\u30ec\u30b9\u6307\u5b9a\u3060\u3068\u554f\u984c\u306a\u304b\u3063\u305f\u304c\u3001\u30b3\u30f3\u30c6\u30ca\u540d\u6307\u5b9a\u306e\u5834\u5408\u306b\u30b3\u30f3\u30c6\u30ca\u540d\u306b\u30c9\u30c3\u30c8\u304c\u5165\u3063\u3066\u3044\u308b\u3068\u63a5\u7d9a\u30a8\u30e9\u30fc\u304c\u767a\u751f\u3057\u305f\u3002\u307e\u305f\u3001\u30b3\u30f3\u30c6\u30ca\u540d\u3092\u30c9\u30c3\u30c8\u306a\u3057\u306b\u5909\u66f4\u3059\u308b\u3068\u89e3\u6c7a\u3057\u305f\u3002<\/p>\n \u4eca\u56de\u4f7f\u7528\u3057\u305fPython\u30a4\u30e1\u30fc\u30b8\u306fAlpine Linux\u3068\u306a\u308b\u304c\u3001\u3053\u306eOS\u306eDNS\u540d\u524d\u89e3\u6c7a\u306f\u3061\u3087\u3063\u3068\u7279\u6b8a\u3063\u307d\u3044<\/a>\u3002<\/p>\n \u5c1a\u3001\u30c9\u30c3\u30c8\u4ee5\u5916\u306b\u30a2\u30f3\u30c0\u30fc\u30d0\u30fc\u3082\u3042\u307e\u308a\u3088\u308d\u3057\u304f\u306a\u3055\u305d\u3046<\/a>\u3002<\/p>\n \u305d\u306e\u305f\u3081\u30b3\u30f3\u30c6\u30ca\u540d\u306f\u534a\u89d2\u82f1\u6570\u5b57\uff08\u82f1\u5b57\u306f\u5c0f\u6587\u5b57\uff09\u3001\u534a\u89d2\u30cf\u30a4\u30d5\u30f3\u306e\u307f<\/strong>\u306b\u3059\u308b\u306e\u304c\u3088\u3055\u305d\u3046\u3002<\/p>\n <\/p>\n https:\/\/qiita.com\/corestate55\/items\/8cf2f713b10d0197c29e<\/a><\/p>\n\n
\u30db\u30b9\u30c8(VPS)\u5074<\/span><\/span><\/span><\/span><\/span><\/h3>\n
\n
\u30b3\u30f3\u30c6\u30ca\u5074<\/span><\/h3>\n
\n
\u5bfe\u5fdc\u65b9\u6cd5<\/span><\/h2>\n
Dockerfile<\/h3>\n
# \u8efd\u91cf\u306ePython\u30a4\u30e1\u30fc\u30b8\r\nFROM python:3.12-alpine\r\n\r\n# \u4f5c\u696d\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306e\u8a2d\u5b9a\r\nWORKDIR \/app\r\n\r\n# \u30e2\u30b8\u30e5\u30fc\u30eb\u306e\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\r\nRUN pip install --no-cache-dir pymysql\r\n\r\n# \u5f85\u6a5f\u72b6\u614b\u306e\u307e\u307e\u306b\u3059\u308b\u8a2d\u5b9a\r\nCMD [\"tail\", \"-f\", \"\/dev\/null\"]\r\n<\/pre>\n
docker-compose.yml<\/h3>\n
services:\r\n python3.12-container:\r\n image: python3.12\r\n container_name: python-container\r\n volumes:\r\n - \/path\/to\/python:\/app:z\r\n deploy:\r\n resources:\r\n limits:\r\n memory: 96m\r\n networks:\r\n - web-db-net\r\n\r\nnetworks:\r\n web-db-net:\r\n external: true\r\n<\/pre>\n
\u30d3\u30eb\u30c9\u3068\u30b3\u30f3\u30c6\u30ca\u8d77\u52d5<\/h3>\n
# Dockerfile\u3092\u8a2d\u7f6e\u3057\u305f\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u306b\u79fb\u52d5\r\ncd \/path\/to\r\n\r\n# \u30d3\u30eb\u30c9\r\npodman build -t python-container .\r\n\r\n# \u30b3\u30f3\u30c6\u30ca\u8d77\u52d5\r\npodman compose up -d<\/pre>\n
\uff08\u5fc5\u8981\u306b\u5fdc\u3058\u3066\uff09\u30c6\u30b9\u30c8\u7528\u30c7\u30fc\u30bf\u306e\u7528\u610f<\/h3>\n
\u5b9f\u884c\u3059\u308b\u30d5\u30a1\u30a4\u30eb\u306e\u4f5c\u6210\uff08test.py\uff09<\/h3>\n
import pymysql\r\nimport logging\r\nfrom datetime import datetime\r\nfrom zoneinfo import ZoneInfo\r\n\r\ndef jst_converter(*args):\r\n return datetime.now(ZoneInfo('Asia\/Tokyo')).timetuple()\r\n\r\nlogging.Formatter.converter = jst_converter\r\n\r\nlogging.basicConfig(\r\n filename=\"error.log\",\r\n level=logging.INFO,\r\n format=\"%(asctime)s - %(levelname)s - %(message)s\",\r\n datefmt=\"%Y-%m-%d %H:%M:%S\"\r\n)\r\n\r\nhost = 'db-container'\r\nuser = 'xxxxxxxxxx'\r\npassword = 'xxxxxxxxxx'\r\ndatabase = 'world'\r\n\r\nconnection = None\r\n\r\ntry:\r\n\r\n connection = pymysql.connect(\r\n host=host, \r\n user=user,\r\n password=password,\r\n database=database,\r\n charset='utf8mb4',\r\n cursorclass=pymysql.cursors.DictCursor\r\n )\r\n\r\n country_code = 'JPN'\r\n\r\n select_sql = '''\r\n SELECT * \r\n FROM city \r\n WHERE CountryCode = %s \r\n LIMIT 5;\r\n '''.strip()\r\n\r\n with connection.cursor() as cursor:\r\n cursor.execute(select_sql, [country_code])\r\n cities = cursor.fetchall()\r\n for city in cities:\r\n print(city.get('Name'))\r\nexcept pymysql.MySQLError as e:\r\n\r\n print(f'[error] {e}')\r\n logging.error('Database error', exc_info=True)\r\nfinally:\r\n if connection is not None:\r\n connection.close()\r\n<\/pre>\n\u30d5\u30a1\u30a4\u30eb\u306e\u5b9f\u884c<\/h3>\n
# podman exec -it python-container python test.py\r\nTokyo\r\nJokohama [Yokohama]\r\nOsaka\r\nNagoya\r\nSapporo<\/pre>\n
# podman exec -it python-container python test.py\r\n[error] (1049, \"Unknown database 'worlds'\")<\/pre>\n
\u88dc\u8db3<\/h2>\n
\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u7528\u30b3\u30f3\u30c6\u30ca\u306b\u63a5\u7d9a\u3067\u304d\u306a\u3044\u5834\u5408<\/h3>\n
\u53c2\u8003\u30b5\u30a4\u30c8<\/h2>\n