Skip to content

Latest commit

 

History

History

0x0F-python-object_relational_mapping

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
.0-select_states.py.swp
.0-select_states.py.swp
 
 
.2-my_filter_states.py.swp
.2-my_filter_states.py.swp
 
 
0-select_states.py
0-select_states.py
 
 
0-select_states.sql
0-select_states.sql
 
 
1-filter_states.py
1-filter_states.py
 
 
10-model_state_my_get.py
10-model_state_my_get.py
 
 
100-relationship_states_cities.py
100-relationship_states_cities.py
 
 
100-relationship_states_cities.sql
100-relationship_states_cities.sql
 
 
101-relationship_states_cities_list.py
101-relationship_states_cities_list.py
 
 
101-relationship_states_cities_list.sql
101-relationship_states_cities_list.sql
 
 
102-relationship_cities_states_list.py
102-relationship_cities_states_list.py
 
 
11-model_state_insert.py
11-model_state_insert.py
 
 
12-model_state_update_id_2.py
12-model_state_update_id_2.py
 
 
13-model_state_delete_a.py
13-model_state_delete_a.py
 
 
14-model_city_fetch_by_state.py
14-model_city_fetch_by_state.py
 
 
14-model_city_fetch_by_state.sql
14-model_city_fetch_by_state.sql
 
 
2-my_filter_states.py
2-my_filter_states.py
 
 
3-my_safe_filter_states.py
3-my_safe_filter_states.py
 
 
4-cities_by_state.py
4-cities_by_state.py
 
 
4-cities_by_state.sql
4-cities_by_state.sql
 
 
5-filter_cities.py
5-filter_cities.py
 
 
6-model_state.sql
6-model_state.sql
 
 
7-model_state_fetch_all.py
7-model_state_fetch_all.py
 
 
7-model_state_fetch_all.sql
7-model_state_fetch_all.sql
 
 
8-model_state_fetch_first.py
8-model_state_fetch_first.py
 
 
9-model_state_filter_a.py
9-model_state_filter_a.py
 
 
README.md
README.md
 
 
helper.sh
helper.sh
 
 
model_city.py
model_city.py
 
 
model_state.py
model_state.py
 
 
relationship_city.py
relationship_city.py
 
 
relationship_state.py
relationship_state.py
 
 

README.md

0x0F. Python - Object-relational mapping

Learning objectives for this project:

  • Why Python programming is awesome
  • How to connect to a MySQL database from a Python script
  • How to SELECT rows in a MySQL table from a Python script
  • How to INSERT rows in a MySQL table from a Python script
  • What ORM means
  • How to map a Python Class to a MySQL table
  • How to create a Python Virtual Environment