Fix your heart or die (Twin Peaks) inspired graphic Classic T-Shirt
$21.99
# 0x0F. Python – Object-relational mapping
## Learning Objectives
* 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
## Tasks
### 0. Get all states
Write a script that lists all states from the database hbtn_0e_0_usa:
* Your script should take 3 arguments: mysql username, mysql password and database name (no argument validation needed)
* You must use the module MySQLdb (import MySQLdb)
* Your script should connect to a MySQL server running on localhost at port 3306
* Results must be sorted in ascending order by states.id
* Results must be displayed as they are in the example below
* Your code should not be executed when imported
### 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:
* Your script should take 3 arguments: mysql username, mysql password and database name (no argument validation needed)
* You must use the module MySQLdb (import MySQLdb)
* Your script should connect to a MySQL server running on localhost at port 3306
* Results must be sorted in ascending order by states.id
* Results must be displayed as they are in the example below
* Your code should not be executed when imported
### 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.
* Your script should take 4 arguments: mysql username, mysql password, database name and state name searched (no argument validation needed)
* You must use the module MySQLdb (import MySQLdb)
* Your script should connect to a MySQL server running on localhost at port 3306
* You must use format to create the SQL query with the user input
* Results must be sorted in ascending order by states.id
* Results must be displayed as they are in the example below
* Your code should not be executed when imported
### 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?
What? It’s not working?
Anyway, let’s fix it.
Write a script that takes in arguments and displays all values in the states table of hbtn_0e_0_usa where name matches the argument. But this time, write one that is safe from MySQL injections!
* Your script should take 4 arguments: mysql username, mysql password, database name and state name searched (safe from MySQL injection)
* You must use the module MySQLdb (import MySQLdb)
* Your script should connect to a MySQL server running on localhost at port 3306
* Results must be sorted in ascending order by states.id
* Results must be displayed as they are in the example below
* Your code should not be executed when imported
### 4. Cities by states
Write a script that lists all cities from the database hbtn_0e_4_usa
* Your script should take 3 arguments: mysql username, mysql password and database name
* You must use the module MySQLdb (import MySQLdb)
* Your script should connect to a MySQL server running on localhost at port 3306
* Results must be sorted in ascending order by cities.id
* You can use only execute() once
* Results must be displayed as they are in the example below
* Your code should not be executed when imported
### 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
* Your script should take 4 arguments: mysql username, mysql password, database name and state name (SQL injection free!)
* You must use the module MySQLdb (import MySQLdb)
* Your script should connect to a MySQL server running on localhost at port 3306
* Results must be sorted in ascending order by cities.id
* You can use only execute() once
* Results must be displayed as they are in the example below
* Your code should not be executed when imported
### 6. First state model
Write a python file that contains the class definition of a State and an instance Base = declarative_base():
* State class:
* inherits from Base
* links to the MySQL table states
* class attribute id that represents a column of an auto-generated, unique integer, can’t be null and is a primary key
* class attribute name that represents a column of a string with maximum 128 characters and can’t be null
* You must use the module SQLAlchemy
* Your script should connect to a MySQL server running on localhost at port 3306
* WARNING: all classes who inherit from Base must be imported before calling Base.metadata.create_all(engine)
### 7. All states via SQLAlchemy
Write a script that lists all State objects from the database hbtn_0e_6_usa
* Your script should take 3 arguments: mysql username, mysql password and database name
* You must use the module SQLAlchemy
* You must import State and Base from model_state – from model_state import Base, State
* Your script should connect to a MySQL server running on localhost at port 3306
* Results must be sorted in ascending order by states.id
* Results must be displayed as they are in the example below
* Your code should not be executed when imported
### 8. First state
Write a script that prints the first State object from the database hbtn_0e_6_usa
* Your script should take 3 arguments: mysql username, mysql password and database name
* You must use the module SQLAlchemy
* You must import State and Base from model_state – from model_state import Base, State
* Your script should connect to a MySQL server running on localhost at port 3306
* The state you display must be the first in states.id
* You are not allowed to fetch all states from the database before displaying the result
* Results must be displayed as they are in the example below
* If the table states is empty, print Nothing followed by a new line
* Your code should not be executed when imported
### 9. Contains a
Write a script that lists all State objects that contain the letter a from the database hbtn_0e_6_usa
* Your script should take 3 arguments: mysql username, mysql password and database name
* You must use the module SQLAlchemy
* You must import State and Base from model_state – from model_state import Base, State
* Your script should connect to a MySQL server running on localhost at port 3306
* Results must be sorted in ascending order by states.id
* Results must be displayed as they are in the example below
* Your code should not be executed when imported
### 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
* Your script should take 4 arguments: mysql username, mysql password, database name and state name to search (SQL injection free)
* You must use the module SQLAlchemy
* You must import State and Base from model_state – from model_state import Base, State
* Your script should connect to a MySQL server running on localhost at port 3306
* You can assume you have one record with the state name to search
* Results must be displayed as they are in the example below
* If no state has the name you searched for, display Not found
* Your code should not be executed when imported
### 11. Add a new state
Write a script that adds the State object “Louisiana” to the database hbtn_0e_6_usa
* Your script should take 3 arguments: mysql username, mysql password and database name
* You must use the module SQLAlchemy
* You must import State and Base from model_state – from model_state import Base, State
* Your script should connect to a MySQL server running on localhost at port 3306
* Print the new states.id after creation
* Results must be displayed as they are in the example below
* Your code should not be executed when imported
### 12. Update a state
Write a script that changes the name of a State object from the database hbtn_0e_6_usa
* Your script should take 4 arguments: mysql username, mysql password, database name and state id to search
* You must use the module SQLAlchemy
* You must import State and Base from model_state – from model_state import Base, State
* Your script should connect to a MySQL server running on localhost at port 3306
* Change the name of the State where id = 2 to New Mexico
* Your code should not be executed when imported
### 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
* Your script should take 3 arguments: mysql username, mysql password and database name
* You must use the module SQLAlchemy
* You must import State and Base from model_state – from model_state import Base, State
* Your script should connect to a MySQL server running on localhost at port 3306
* Results must be displayed as they are in the example below
* Your code should not be executed when imported
### 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.
* City class:
* inherits from Base (imported from model_state)
* links to the MySQL table cities
* class attribute id that represents a column of an auto-generated, unique integer, can’t be null and is a primary key
* class attribute name that represents a column of a string with maximum 128 characters and can’t be null
* class attribute state_id that represents a column of an integer, can’t be null and is a foreign key to states.id
* You must use the module SQLAlchemy
* Next, write a script 14-model_city_fetch_by_state.py that prints all City objects from the database hbtn_0e_14_usa:
* Your script should take 3 arguments: mysql username, mysql password and database name
* You must use the module SQLAlchemy
* You must import State and Base from model_state – from model_state import Base, State
* Your script should connect to a MySQL server running on localhost at port 3306
* Results must be sorted in ascending order by cities.id
* Results must be displayed as they are in the example below (
* Your code should not be executed when imported
### 15. City relationship
Improve the file model_city.py and model_state.py, and save them as model_city.py and model_state.py:
* City class:
* No change
* State class:
* In addition to previous requirements, the class attribute cities must represent a relationship with the class City. If the State object is deleted, all linked City objects must be automatically deleted. Also, the reference from a City object to his State should be named state
* You must use the module SQLAlchemy
* Write a script that creates the State “California” with the City “San Francisco” from the database hbtn_0e_100_usa: (100-relationship_states_cities.py)
* Your script should take 3 arguments: mysql username, mysql password and database name
* You must use the module SQLAlchemy
* Your script should connect to a MySQL server running on localhost at port 3306
* You must use the cities relationship for all State objects
* Results must be displayed as they are in the example below
* Your code should not be executed when imported
### 16. List relationship
Write a script that lists all State objects, and corresponding City objects, contained in the database hbtn_0e_101_usa
Fix Your Heart or Die (Twin Peaks) Inspired Graphic Classic T-Shirt
Are you a die-hard Twin Peaks fan looking for the perfect way to showcase your love for the cult classic? Look no further than the Fix Your Heart or Die inspired graphic Classic T-Shirt. This stylish and comfortable tee features a bold design inspired by one of the most iconic lines from the show, making it a must-have for any fan of David Lynch’s masterpiece.
Product Introduction
The Fix Your Heart or Die T-Shirt is more than just a piece of clothing—it’s a statement. Whether you’re attending a fan convention, hanging out with friends, or just lounging at home, this tee lets you express your passion for Twin Peaks in a subtle yet impactful way. The design is printed on high-quality fabric, ensuring durability and comfort.
This shirt is part of our exclusive collection of pop culture-inspired apparel, designed for fans who want to wear their favorite references with pride. Pair it with jeans or a skirt for a casual yet stylish look.
Specifications and Key Features
Here’s what makes the Fix Your Heart or Die T-Shirt stand out:
- Material: 100% premium cotton for breathability and comfort
- Fit: Classic unisex fit, true to size
- Print: High-quality screen print that won’t fade or crack
- Design: Bold, eye-catching Twin Peaks-inspired graphic
- Care: Machine washable (cold recommended)
- Sizes: Available in S, M, L, XL, and XXL
For those who prefer a slightly looser fit, check out our oversized options in the same collection.
Benefits of Using the Product
Why should you add this tee to your wardrobe? Here are some compelling reasons:
- Show Your Fandom: This shirt is a conversation starter for fellow Twin Peaks enthusiasts.
- Comfortable Wear: Made from soft cotton, it’s perfect for all-day comfort.
- Durable Design: The high-quality print ensures long-lasting wear.
- Versatile Style: Dress it up or down for any casual occasion.
- Great Gift Idea: Ideal for birthdays, holidays, or fan gatherings.
If you love this design, you might also enjoy our other classic tees featuring witty pop culture references.
How to Use and Maintain
To keep your Fix Your Heart or Die T-Shirt looking fresh, follow these care tips:
- Washing: Turn the shirt inside out and wash in cold water to preserve the print.
- Drying: Air dry or tumble dry on low heat to prevent shrinkage.
- Ironing: If needed, iron on low heat and avoid direct contact with the graphic.
- Storage: Fold neatly to avoid stretching the fabric.
With proper care, your tee will remain vibrant and comfortable for years to come.
Customer Reviews
Here’s what fans are saying about the Fix Your Heart or Die T-Shirt:
“The print quality is amazing, and the fabric is so soft. I get compliments every time I wear it!” – Sarah M.
“Perfect fit and the design is spot-on. A must-have for any Twin Peaks fan!” – James L.
“I bought this as a gift, and my friend loved it. The shipping was fast too!” – Rachel T.
Comparison with Other Products
How does this tee stack up against similar products? Here’s a quick comparison:
| Feature | Fix Your Heart or Die T-Shirt | Other Pop Culture Tees |
|---|---|---|
| Material | 100% premium cotton | Blends or lower-quality cotton |
| Print Quality | High-resolution, fade-resistant | Prone to cracking or fading |
| Design Uniqueness | Exclusive Twin Peaks reference | Generic or overused designs |
| Price | Competitive for quality | Often overpriced for lower quality |
For more unique designs, browse our full collection of pop culture apparel.
Where to Buy
Ready to make this tee yours? Purchase the Fix Your Heart or Die T-Shirt exclusively at:
We offer fast shipping, easy returns, and secure checkout for a hassle-free shopping experience.
Frequently Asked Questions (FAQ)
Is this shirt unisex?
Yes! The Fix Your Heart or Die T-Shirt is designed with a classic unisex fit.
What sizes are available?
It comes in S, M, L, XL, and XXL. Check our size guide for measurements.
How long does shipping take?
Most orders ship within 1-2 business days and arrive in 3-7 days, depending on location.
Is the print durable?
Absolutely! The high-quality screen print is designed to last through many washes.
Do you offer international shipping?
Yes, we ship worldwide. Shipping costs and times vary by destination.
Call to Action (CTA)
Don’t miss out on this iconic Twin Peaks tee! Click below to order your Fix Your Heart or Die T-Shirt today and join the ranks of fans who wear their passion with pride.
For more pop culture-inspired apparel, explore our full collection and find your next favorite tee!
Be the first to review “Fix your heart or die (Twin Peaks) inspired graphic Classic T-Shirt”
Related products
New Arrivals
New Arrivals
New Arrivals
New Arrivals
New Arrivals
Reviews
There are no reviews yet.