$ {your_location}/google-cloud-sdk/install.sh
Welcome to the Google Cloud CLI!
To help improve the quality of this product, we collect anonymized usage data
and anonymized stacktraces when crashes are encountered; additional information
is available at <https://cloud.google.com/sdk/usage-statistics>. This data is
handled in accordance with our privacy policy
<https://cloud.google.com/terms/cloud-privacy-notice>. You may choose to opt in this
collection now (by choosing 'Y' at the below prompt), or at any time in the
future by running the following command:
gcloud config set disable_usage_reporting false
Do you want to help improve the Google Cloud CLI (y/N)? y
Your current Google Cloud CLI version is: 471.0.0
The latest available version is: 472.0.0
┌────────────────────────────────────────────────────────────────────────────────────────────────────────────────────┐
│ Components │
├──────────────────┬──────────────────────────────────────────────────────┬──────────────────────────────┬───────────┤
│ Status │ Name │ ID │ Size │
├──────────────────┼──────────────────────────────────────────────────────┼──────────────────────────────┼───────────┤
│ Update Available │ BigQuery Command Line Tool │ bq │ 1.7 MiB │
│ Update Available │ Google Cloud CLI Core Libraries │ core │ 18.4 MiB │
│ Not Installed │ App Engine Go Extensions │ app-engine-go │ 4.5 MiB │
│ Not Installed │ Appctl │ appctl │ 18.5 MiB │
│ Not Installed │ Artifact Registry Go Module Package Helper │ package-go-module │ < 1 MiB │
│ Not Installed │ Cloud Bigtable Command Line Tool │ cbt │ 16.7 MiB │
│ Not Installed │ Cloud Bigtable Emulator │ bigtable │ 7.0 MiB │
│ Not Installed │ Cloud Datastore Emulator │ cloud-datastore-emulator │ 36.2 MiB │
│ Not Installed │ Cloud Firestore Emulator │ cloud-firestore-emulator │ 44.8 MiB │
│ Not Installed │ Cloud Pub/Sub Emulator │ pubsub-emulator │ 63.3 MiB │
│ Not Installed │ Cloud Run Proxy │ cloud-run-proxy │ 11.3 MiB │
│ Not Installed │ Cloud SQL Proxy v2 │ cloud-sql-proxy │ 13.2 MiB │
│ Not Installed │ Google Container Registry's Docker credential helper │ docker-credential-gcr │ │
│ Not Installed │ Kustomize │ kustomize │ 7.4 MiB │
│ Not Installed │ Log Streaming │ log-streaming │ 11.9 MiB │
│ Not Installed │ Minikube │ minikube │ 33.6 MiB │
│ Not Installed │ Nomos CLI │ nomos │ 28.6 MiB │
│ Not Installed │ On-Demand Scanning API extraction helper │ local-extract │ 13.7 MiB │
│ Not Installed │ Skaffold │ skaffold │ 22.8 MiB │
│ Not Installed │ Terraform Tools │ terraform-tools │ 63.6 MiB │
│ Not Installed │ anthos-auth │ anthos-auth │ 20.7 MiB │
│ Not Installed │ config-connector │ config-connector │ 55.6 MiB │
│ Not Installed │ enterprise-certificate-proxy │ enterprise-certificate-proxy │ 8.3 MiB │
│ Not Installed │ gcloud Alpha Commands │ alpha │ < 1 MiB │
│ Not Installed │ gcloud Beta Commands │ beta │ < 1 MiB │
│ Not Installed │ gcloud app Java Extensions │ app-engine-java │ 126.2 MiB │
│ Not Installed │ gcloud app PHP Extensions │ app-engine-php │ 21.9 MiB │
│ Not Installed │ gcloud app Python Extensions │ app-engine-python │ 5.0 MiB │
│ Not Installed │ gcloud app Python Extensions (Extra Libraries) │ app-engine-python-extras │ < 1 MiB │
│ Not Installed │ gke-gcloud-auth-plugin │ gke-gcloud-auth-plugin │ 7.4 MiB │
│ Not Installed │ kpt │ kpt │ 14.4 MiB │
│ Not Installed │ kubectl │ kubectl │ < 1 MiB │
│ Not Installed │ kubectl-oidc │ kubectl-oidc │ 20.7 MiB │
│ Not Installed │ pkg │ pkg │ │
│ Installed │ Cloud Storage Command Line Tool │ gsutil │ 11.3 MiB │
│ Installed │ Google Cloud CRC32C Hash Tool │ gcloud-crc32c │ 1.2 MiB │
└──────────────────┴──────────────────────────────────────────────────────┴──────────────────────────────┴───────────┘
To install or remove components at your current SDK version [471.0.0], run:
$ gcloud components install COMPONENT_ID
$ gcloud components remove COMPONENT_ID
To update your SDK installation to the latest version [472.0.0], run:
$ gcloud components update
Modify profile to update your $PATH and enable shell command completion?
Do you want to continue (Y/n)? y
The Google Cloud SDK installer will now prompt you to update an rc file to bring
the Google Cloud CLIs into your environment.
Enter a path to an rc file to update, or leave blank to use
[/Users/evan/.bash_profile]:
Backing up [/Users/evan/.bash_profile] to [/Users/evan/.bash_profile.backup].
[/Users/evan/.bash_profile] has been updated.
==> Start a new shell for the changes to take effect.
Google Cloud CLI works best with Python 3.11 and certain modules.
Download and run Python 3.11 installer? (Y/n)? Y
Running Python 3.11 installer, you may be prompted for sudo password...
Password: # your_password
installer: Package name is Python
installer: Upgrading at base path /
installer: The upgrade was successful.
Setting up virtual environment
Creating virtualenv...
Installing modules...
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 89.7/89.7 kB 4.6 MB/s eta 0:00:00
Installing build dependencies ... done
Getting requirements to build wheel ... done
Preparing metadata (pyproject.toml) ... done
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 59.0/59.0 kB 5.9 MB/s eta 0:00:00
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 10.0/10.0 MB 33.9 MB/s eta 0:00:00
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 163.8/163.8 kB 16.1 MB/s eta 0:00:00
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 5.3/5.3 MB 42.0 MB/s eta 0:00:00
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 176.7/176.7 kB 15.4 MB/s eta 0:00:00
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 117.6/117.6 kB 10.4 MB/s eta 0:00:00
Building wheel for crcmod (pyproject.toml) ... done
Updates are available for some Google Cloud CLI components. To install them,
please run:
$ gcloud components update
Virtual env enabled.
For more information on how to get started, please visit:
https://cloud.google.com/sdk/docs/quickstarts
gcloud init 을 실행한다.$ ./google-cloud-sdk/bin/gcloud init
Welcome! This command will take you through the configuration of gcloud.
Your current configuration has been set to: [default]
You can skip diagnostics next time by using the following flag:
gcloud init --skip-diagnostics
Network diagnostic detects and fixes local network connection issues.
Checking network connection...done.
Reachability Check passed.
Network diagnostic passed (1/1 checks passed).
You must log in to continue. Would you like to log in (Y/n)? Y
Your browser has been opened to visit:
https://accounts.google.com/o/oauth2/....S256
You are logged in as: [your_email@gmail.com].
Pick cloud project to use:
[1] chickenbot-a185e
[2] encoded-phalanx-420600
[3] streamlit-gitaction-403105
[4] streamlit-project-416601
[5] Enter a project ID
[6] Create a new project
Please enter numeric choice or text value (must exactly match list item): 2
Welcome to the Google Cloud CLI! Run "gcloud -h" to get the list of available commands.
---
Welcome! This command will take you through the configuration of gcloud.
Settings from your current configuration [default] are:
accessibility:
screen_reader: 'True'
compute:
region: asia-northeast3
zone: asia-northeast3-a
core:
account: your_existing@gmail.com
disable_usage_reporting: 'False'
project: mulcampfp
Pick configuration to use:
[1] Re-initialize this configuration [default] with new settings
[2] Create a new configuration
Please enter your numeric choice: 2
[mulcamp-project-abc] 프로젝트를 입력한다.Enter configuration name. Names start with a lower case letter and contain only lower case letters a-z, digits 0-9, and
hyphens '-': mulcamp-project-abc
Your current configuration has been set to: [mulcamp-project-abc]
You can skip diagnostics next time by using the following flag:
gcloud init --skip-diagnostics
Network diagnostic detects and fixes local network connection issues.
Checking network connection...done.
Reachability Check passed.
Network diagnostic passed (1/1 checks passed).
Choose the account you would like to use to perform operations for this configuration:
[1] your_email@gmail.com
[2] Log in with a new account
Please enter your numeric choice: 1
$ ssh-keygen -t rsa -b 4096 -C "your@gmail.com"
$ cat .ssh/id_rsa.pub
ssh-rsa AAAAB3...Q== your@gmail.com
mkdir -p ~/miniconda3
wget https://repo.anaconda.com/miniconda/Miniconda3-latest-Linux-x86_64.sh -O ~/miniconda3/miniconda.sh
bash ~/miniconda3/miniconda.sh -b -u -p ~/miniconda3
rm -rf ~/miniconda3/miniconda.sh
~/miniconda3/bin/conda init bash
~/miniconda3/bin/conda init zsh
pip install django
django-admin --version
5.0.4
django-admin startproject mysite
$ python manage.py makemigrations
$ python manage.py migrate
Operations to perform:
Apply all migrations: admin, auth, contenttypes, sessions
Running migrations:
Applying contenttypes.0001_initial... OK
Applying auth.0001_initial... OK
Applying admin.0001_initial... OK
Applying admin.0002_logentry_remove_auto_add... OK
Applying admin.0003_logentry_add_action_flag_choices... OK
Applying contenttypes.0002_remove_content_type_name... OK
Applying auth.0002_alter_permission_name_max_length... OK
Applying auth.0003_alter_user_email_max_length... OK
Applying auth.0004_alter_user_username_opts... OK
Applying auth.0005_alter_user_last_login_null... OK
Applying auth.0006_require_contenttypes_0002... OK
Applying auth.0007_alter_validators_add_error_messages... OK
Applying auth.0008_alter_user_username_max_length... OK
Applying auth.0009_alter_user_last_name_max_length... OK
Applying auth.0010_alter_group_name_max_length... OK
Applying auth.0011_update_proxy_permissions... OK
Applying auth.0012_alter_user_first_name_max_length... OK
Applying sessions.0001_initial... OK
$ python manage.py runserver
...
April 18, 2024 - 05:13:47
Django version 5.0.4, using settings 'mysite.settings'
Starting development server at http://127.0.0.1:8000/
Quit the server with CONTROL-C.
https://dlcdn.apache.org/spark/spark-3.5.1/spark-3.5.1-bin-hadoop3.tgz
pip install mysql-connector mysql-connector-python pymysql SQLAlchemy seaborn pandas
# 파일명 : db.py
import mysql.connector
import pandas as pd
import seaborn as sns
mydb = mysql.connector.connect(
host = "localhost",
user = "root",
passwd = "evan",
database = "muldb"
)
print(mydb)
iris_df = sns.load_dataset('iris')
my_cursor = mydb.cursor()
create_table_query = """
CREATE TABLE IF NOT EXISTS iris (
id INT AUTO_INCREMENT PRIMARY KEY,
sepal_length FLOAT,
sepal_width FLOAT,
petal_length FLOAT,
petal_width FLOAT,
species VARCHAR(255)
);
"""
my_cursor.execute(create_table_query)
insert_query = """
INSERT INTO iris (sepal_length, sepal_width, petal_length, petal_width, species)
VALUES (%s, %s, %s, %s, %s)
"""
data = [tuple(x) for x in iris_df.to_numpy()]
for row in data:
my_cursor.execute(insert_query, row)
# DB Commit
mydb.commit()
# 종료
my_cursor.close()
mydb.close()
$ python db.py
<mysql.connector.connection_cext.CMySQLConnection object at 0x0000025FFC155BD0>
import mysql.connector
mydb = mysql.connector.connect(
host = "localhost",
user = "root",
passwd = "evan",
database = "mulcampdb"
)
print(mydb)
my_cursor = mydb.cursor()
query = """
SELECT * FROM users;
"""
my_cursor.execute(query)
result = my_cursor.fetchall()
for row in result:
print(row)
print("완료")
$ python database.py
<mysql.connector.connection_cext.CMySQLConnection object at 0x000001FE5A985F10>
('Evan', 'Evan@gmail.com', 30, 1)
('Evan', 'Evan@gmail.com', 30, 2)
('Mary', 'Mary@gmail.com', 20, 3)
('Sara', 'Sara@gmail.com', 25, 4)
완료
$ pip install pandas
import mysql.connector
import pandas as pd
mydb = mysql.connector.connect(
host = "localhost",
user = "root",
passwd = "evan",
database = "mulcampdb"
)
print(mydb)
my_cursor = mydb.cursor(dictionary=True)
query = """
SELECT * FROM users;
"""
my_cursor.execute(query)
result = my_cursor.fetchall()
for row in result:
print(row)
df = pd.DataFrame(result)
print(df)
print("완료")
$ python database.py
<mysql.connector.connection_cext.CMySQLConnection object at 0x000002C4C47D5490>
{'name': 'Evan', 'email': 'Evan@gmail.com', 'age': 30, 'user_id': 1}
{'name': 'Evan', 'email': 'Evan@gmail.com', 'age': 30, 'user_id': 2}
{'name': 'Mary', 'email': 'Mary@gmail.com', 'age': 20, 'user_id': 3}
{'name': 'Sara', 'email': 'Sara@gmail.com', 'age': 25, 'user_id': 4}
name email age user_id
0 Evan Evan@gmail.com 30 1
1 Evan Evan@gmail.com 30 2
2 Mary Mary@gmail.com 20 3
3 Sara Sara@gmail.com 25 4
완료
dictionary=True는 조회 결과를 Dictionary 형태로 받기 위한 설정이다.my_cursor = mydb.cursor(dictionary=True)
result = my_cursor.fetchall()
df = pd.DataFrame(result)
print(df)
import mysql.connector
mydb = mysql.connector.connect(
host = "localhost",
user = "root",
passwd = "evan",
database = "mulcampdb"
)
print(mydb)
my_cursor = mydb.cursor()
query = """
CREATE TABLE users (
name VARCHAR(255)
, email VARCHAR(255)
, age INTEGER(10)
, user_id INTEGER AUTO_INCREMENT PRIMARY KEY
);
"""
my_cursor.execute(query)
my_cursor.execute("SHOW TABLES;")
for table in my_cursor:
print(table[0])
$ python database.py
<mysql.connector.connection_cext.CMySQLConnection object at 0x0000028942314F90>
users
$ pip install mysql-connector mysql-connector-python
import mysql.connector
mydb = mysql.connector.connect(
host = "localhost",
user = "root",
passwd = "evan"
)
print(mydb)
$ python database.py
<mysql.connector.connection_cext.CMySQLConnection object at 0x000002BF4E606090>
(venv)
Schema를 생성한다.import mysql.connector
mydb = mysql.connector.connect(
host = "localhost",
user = "root",
passwd = "evan"
)
print(mydb)
my_cursor = mydb.cursor()
query = """
CREATE DATABASE mulcampdb
"""
my_cursor.execute(query)
print("완료")
$ python database.py
<mysql.connector.connection_cext.CMySQLConnection object at 0x0000020BB6504F50>
완료
