{"id":62,"date":"2024-12-04T04:05:00","date_gmt":"2024-12-04T04:05:00","guid":{"rendered":"http:\/\/211.230.203.47\/wordpress\/?p=62"},"modified":"2024-12-04T04:05:00","modified_gmt":"2024-12-04T04:05:00","slug":"%ed%8c%8c%ec%9d%b4%ec%85%98%ec%9c%bc%eb%a1%9c-%ec%9b%b9%ed%94%84%eb%a1%9c%ea%b7%b8%eb%9e%a8%ec%9d%84-%eb%a7%8c%eb%93%a4%eb%95%8c-mysql-%ec%84%9c%eb%b2%84%ec%99%80-%ec%97%b0%ea%b2%b0%ed%95%98%eb%8a%94","status":"publish","type":"post","link":"https:\/\/www.soon7shop.kr\/wordpress\/?p=62","title":{"rendered":"\ud30c\uc774\uc158\uc73c\ub85c \uc6f9\ud504\ub85c\uadf8\ub7a8\uc744 \ub9cc\ub4e4\ub54c mysql \uc11c\ubc84\uc640 \uc5f0\uacb0\ud558\ub294 \ubc29\ubc95"},"content":{"rendered":"

Python\uc73c\ub85c \uc6f9 \ud504\ub85c\uadf8\ub7a8\uc744 \ub9cc\ub4e4 \ub54c MySQL \uc11c\ubc84\uc640 \uc5f0\uacb0\ud558\ub294 \uc77c\ubc18\uc801\uc778 \ubc29\ubc95\uc740 mysql-connector-python<\/code>\uacfc \uac19\uc740 MySQL \ucee4\ub125\ud130 \ub77c\uc774\ube0c\ub7ec\ub9ac\ub97c \uc0ac\uc6a9\ud558\ub294 \uac83\uc785\ub2c8\ub2e4. \uc5ec\uae30\uc11c\ub294 Python Flask \uc6f9 \ud504\ub808\uc784\uc6cc\ud06c\uc640 MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc5f0\uacb0\ud558\uc5ec \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\uc744 \uc548\ub0b4\ub4dc\ub9b4\uac8c\uc694.<\/p>\n

1. \ub77c\uc774\ube0c\ub7ec\ub9ac \uc124\uce58<\/h3>\n

\uba3c\uc800, mysql-connector-python<\/code> \ud328\ud0a4\uc9c0\ub97c \uc124\uce58\ud574\uc57c \ud569\ub2c8\ub2e4.<\/p>\n

\n
bash<\/div>\n
\n
\n
<\/div>\n<\/div>\n<\/div>\n
pip install mysql-connector-python Flask
\n<\/code><\/div>\n<\/div>\n

2. MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uc815<\/h3>\n

MySQL\uc5d0\uc11c \uc0ac\uc6a9\ud560 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \ud14c\uc774\ube14\uc744 \uc124\uc815\ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, mydatabase<\/code>\ub77c\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 users<\/code>\ub77c\ub294 \ud14c\uc774\ube14\uc744 \ub9cc\ub4e4\uace0 \uc2f6\ub2e4\uba74 \ub2e4\uc74c\uacfc \uac19\uc774 \uc124\uc815\ud569\ub2c8\ub2e4:<\/p>\n

\n
sql<\/div>\n
\n
\n
<\/div>\n<\/div>\n<\/div>\n
CREATE<\/span> DATABASE mydatabase;
\nUSE mydatabase;<\/p>\n

CREATE<\/span> TABLE<\/span> users (
\n id INT<\/span> AUTO_INCREMENT PRIMARY<\/span> KEY,
\n name VARCHAR<\/span>(100<\/span>),
\n email VARCHAR<\/span>(100<\/span>)
\n);
\n<\/code><\/div>\n<\/div>\n

3. Python\uc5d0\uc11c MySQL \uc5f0\uacb0 \uc124\uc815<\/h3>\n

Flask \uc560\ud50c\ub9ac\ucf00\uc774\uc158 \ud30c\uc77c\uc744 \uc0dd\uc131\ud558\uace0 MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc5f0\uacb0\ud574\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n

\n
python<\/div>\n
\n
<\/div>\n<\/div>\n
<\/code><\/code>from flask import Flask, request, jsonify
\nimport mysql.connector<\/p>\n

<\/code><\/code>app = Flask(__name__)<\/p>\n

<\/code><\/code># MySQL \uc5f0\uacb0 \uc124\uc815
\ndb = mysql.connector.connect(
\nhost=”localhost”, # MySQL \uc11c\ubc84 \ud638\uc2a4\ud2b8
\nuser=”root”, # MySQL \uc0ac\uc6a9\uc790
\npassword=”password”, # MySQL \ube44\ubc00\ubc88\ud638
\ndatabase=”mydatabase” # \uc5f0\uacb0\ud560 \ub370\uc774\ud130\ubca0\uc774\uc2a4
\n)<\/p>\n

<\/code><\/code># \ub370\uc774\ud130 \ucd94\uac00 API \uc608\uc81c
\n@app.route(‘\/add_user’, methods=[‘POST’])
\ndef add_user():
\ndata = request.json
\nname = data.get(‘name’)
\nemail = data.get(’email’)<\/p>\n

<\/code><\/code>cursor = db.cursor()
\nquery = “INSERT INTO users (name, email) VALUES (%s, %s)”
\nvalues = (name, email)
\ncursor.execute(query, values)
\ndb.commit()<\/p>\n

return jsonify({“message”: “User added successfully!”})<\/p>\n

<\/code><\/code># \ubaa8\ub4e0 \ub370\uc774\ud130 \uc870\ud68c API \uc608\uc81c
\n@app.route(‘\/users’, methods=[‘GET’])
\ndef get_users():
\ncursor = db.cursor(dictionary=True)
\ncursor.execute(“SELECT * FROM users”)
\nusers = cursor.fetchall()<\/p>\n

return jsonify(users)<\/p>\n

<\/code><\/code>if __name__ == ‘__main__’:
\napp.run(debug=True)<\/p>\n


\n<\/code><\/div>\n<\/div>\n

4. \uc2e4\ud589 \ubc0f \ud14c\uc2a4\ud2b8<\/h3>\n

\uc774\uc81c \uc11c\ubc84\ub97c \uc2e4\ud589\ud558\uace0 \ud14c\uc2a4\ud2b8\ud574\ubcf4\uc138\uc694:<\/p>\n

\n
bash<\/div>\n
\n
\n
<\/div>\n<\/div>\n<\/div>\n
python app.py
\n<\/code><\/div>\n<\/div>\n

http:\/\/localhost:5000\/add_user<\/code>\uc5d0 POST \uc694\uccad\uc744 \ubcf4\ub0b4\uc11c \uc0ac\uc6a9\uc790 \uc815\ubcf4\ub97c \ucd94\uac00\ud558\uac70\ub098, http:\/\/localhost:5000\/users<\/code>\ub85c GET \uc694\uccad\uc744 \ubcf4\ub0b4\uc11c \uc800\uc7a5\ub41c \uc0ac\uc6a9\uc790 \uc815\ubcf4\ub97c \uc870\ud68c\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n

\uc774 \uacfc\uc815\uc774 MySQL\uacfc \uc5f0\uacb0\ud558\uc5ec \ub370\uc774\ud130\ub97c \ucc98\ub9ac\ud558\ub294 \uae30\ubcf8\uc801\uc778 \uc6f9 \ud504\ub85c\uadf8\ub7a8 \uad6c\ucd95 \uacfc\uc815\uc785\ub2c8\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"

Python\uc73c\ub85c \uc6f9 \ud504\ub85c\uadf8\ub7a8\uc744 \ub9cc\ub4e4 \ub54c MySQL \uc11c\ubc84\uc640 \uc5f0\uacb0\ud558\ub294 \uc77c\ubc18\uc801\uc778 \ubc29\ubc95\uc740 mysql-connector-python\uacfc \uac19\uc740 MySQL \ucee4\ub125\ud130 \ub77c\uc774\ube0c\ub7ec\ub9ac\ub97c \uc0ac\uc6a9\ud558\ub294 \uac83\uc785\ub2c8\ub2e4. \uc5ec\uae30\uc11c\ub294 Python Flask \uc6f9 \ud504\ub808\uc784\uc6cc\ud06c\uc640 MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc5f0\uacb0\ud558\uc5ec \uc0ac\uc6a9\ud558\ub294 \ubc29\ubc95\uc744 \uc548\ub0b4\ub4dc\ub9b4\uac8c\uc694. 1. \ub77c\uc774\ube0c\ub7ec\ub9ac \uc124\uce58 \uba3c\uc800, mysql-connector-python \ud328\ud0a4\uc9c0\ub97c \uc124\uce58\ud574\uc57c \ud569\ub2c8\ub2e4. bash pip install mysql-connector-python Flask 2. MySQL \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc124\uc815 MySQL\uc5d0\uc11c \uc0ac\uc6a9\ud560 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 \ud14c\uc774\ube14\uc744 \uc124\uc815\ud569\ub2c8\ub2e4. \uc608\ub97c \ub4e4\uc5b4, mydatabase\ub77c\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc640 users\ub77c\ub294 … \ub354 \ubcf4\uae30 “\ud30c\uc774\uc158\uc73c\ub85c \uc6f9\ud504\ub85c\uadf8\ub7a8\uc744 \ub9cc\ub4e4\ub54c mysql \uc11c\ubc84\uc640 \uc5f0\uacb0\ud558\ub294 \ubc29\ubc95”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"class_list":["post-62","post","type-post","status-publish","format-standard","hentry","category-6"],"_links":{"self":[{"href":"https:\/\/www.soon7shop.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/62","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.soon7shop.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.soon7shop.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.soon7shop.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.soon7shop.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=62"}],"version-history":[{"count":1,"href":"https:\/\/www.soon7shop.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/62\/revisions"}],"predecessor-version":[{"id":63,"href":"https:\/\/www.soon7shop.kr\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/62\/revisions\/63"}],"wp:attachment":[{"href":"https:\/\/www.soon7shop.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=62"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.soon7shop.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=62"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.soon7shop.kr\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=62"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}