Skip to content

0x0F-python-object_relational_mapping

Directory actions

More options

Directory actions

More options

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
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
 
 
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
 
 
5-filter_cities.py
5-filter_cities.py
 
 
6-model_state.py
6-model_state.py
 
 
6-model_state.sql
6-model_state.sql
 
 
7-model_state_fetch_all.py
7-model_state_fetch_all.py
 
 
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
 
 
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

Description

What you should learn from this project:

  • Why Python programming is awesome (don’t forget to tweet today, with the hashtag #pythoniscool :))
  • 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

0. Get all states

  • Write a script that lists all states from the database hbtn_0e_0_usa:

1. Filter states

  • Write a script that lists all states with a name starting with N (upper N) from the database hbtn_0e_0_usa:

2. Filter states by user input

  • Write a script that takes in an argument and displays all values in the states table of hbtn_0e_0_usa where name matches the argument.

3. SQL Injection...

  • Wait, do you remember the previous task? Did you test "Arizona'; TRUNCATE TABLE states ; SELECT * FROM states WHERE name = '" as an input?

4. Cities by states

  • Write a script that lists all cities from the database hbtn_0e_4_usa

5. All cities by state

  • Write a script that takes in the name of a state as an argument and lists all cities of that state, using the database hbtn_0e_4_usa

6. First state model

7. All states via SQLAlchemy

  • Write a script that lists all State objects from the database hbtn_0e_6_usa

8. First state

  • Write a script that prints the first State object from the database hbtn_0e_6_usa

9. Contains a

  • Write a script that lists all State objects that contain the letter a from the database hbtn_0e_6_usa

10. Get a state

  • Write a script that prints the State object with the name passed as argument from the database hbtn_0e_6_usa

11. Add a new state

  • Write a script that adds the State object “Louisiana” to the database hbtn_0e_6_usa

12. Update a state

  • Write a script that changes the name of a State object from the database hbtn_0e_6_usa

13. Delete states

  • Write a script that deletes all State objects with a name containing the letter a from the database hbtn_0e_6_usa

14. Cities in state

  • Write a Python file similar to model_state.py named model_city.py that contains the class definition of a City.

Author