DEV Community: Jessica Papa

Getting Started with Creating a Database Table in Flask-SQLAlchemy

Jessica Papa — Tue, 29 Aug 2023 20:35:08 +0000

Flask-SQLAlchemy is a powerful tool that allows developers to seamlessly integrate a relational database into their Flask applications. Whether you're building a simple web app or a complex project, understanding how to create a database table using Flask-SQLAlchemy is a fundamental skill. In this beginner's guide, we'll walk you through the process step by step.

Prerequisites:

Before diving into creating a database table using Flask-SQLAlchemy, make sure you have the following set up:

Basic understanding of Python and Flask.

Flask and SQLAlchemy installed in your Python environment.
A database engine (like SQLite, MySQL, or PostgreSQL) configured for your Flask app.
Now, let's get started!

Step 1: Set Up Your Flask App:

Begin by creating a Flask application if you haven't already. Make sure to configure your app to use SQLAlchemy for database operations.

Here's a basic example:

from flask import Flask
from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI'] = 'sqlite:///mydatabase.db'  # Change this to your database URI
db = SQLAlchemy(app)

Step 2: Define a Model:

In SQLAlchemy, a model represents a table in your database. Define a model class by creating a Python class that inherits from db.Model. Each attribute in the class will correspond to a column in the table. Here's an example of a simple model:

class User(db.Model):
    id = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(80), unique=True, nullable=False)
    email = db.Column(db.String(120), unique=True, nullable=False)

    def __repr__(self):
        return f'<User {self.username}>'

Step 3: Creating the Table:

Once you've defined your model, it's time to create the corresponding table in the database. To do this, open a Python shell or create a script and run the following commands:

from your_app_module import db, User

Update with your actual module and model names
Create the tables

db.create_all()

This will create the necessary table(s) based on your defined models.

Step 4: Interact with the Database:

With the table created, you can now interact with the database using your model. For example, to add a new user to the User table:

new_user = User(username='john_doe', email='john@example.com')
db.session.add(new_user)
db.session.commit()

Step 5: Querying Data:

You can also perform queries on the table using SQLAlchemy's query API. Here's an example of how to retrieve all users:

all_users = User.query.all()
for user in all_users:
    print(user.username, user.email)

Conclusion:

Congratulations! You've successfully created a database table using Flask-SQLAlchemy and performed basic operations on it. This is just the beginning – Flask-SQLAlchemy offers many more advanced features for handling database relationships, migrations, and more.

As you continue to develop your Flask applications, you'll find that SQLAlchemy is a versatile and essential tool for working with databases.

An Introduction to CSS: Customizing with index.css and Classes

Jessica Papa — Wed, 09 Aug 2023 03:05:45 +0000

Cascading Style Sheets (CSS) are crucial for controlling the visual appearance of your HTML content. With CSS, you can style your website, change layouts, and make it look attractive. In this guide, we'll cover the basics of CSS, including using an index.css component and customizing styles with classes.

CSS operates as a separate layer from your HTML content, allowing you to maintain a clear separation between structure and presentation. To begin, create an index.css file within your project directory. This file will serve as the main stylesheet for your website.

Linking CSS to HTML

To apply the styles defined in your index.css file to your HTML, you need to link the two together.

Insert the following line within the

section of your HTML file:

<link rel="stylesheet" href="index.css">

This tells the browser to fetch and apply the styles from your index.css file.

Styling by Class

One of the fundamental concepts in CSS is the use of classes to target specific elements for styling.

Classes allow you to apply the same set of styles to multiple elements without duplicating code. Let's walk through an example.

Suppose you have the following HTML structure:

DOCTYPE html>
<html>
<head>
    <link rel="stylesheet" href="index.css">
</head>
<body>
    <h1 class="header">Welcome to My Website</h1>
    <p class="content">This is a brief introduction to CSS.</p>
</body>
</html>

In your index.css file, you can define styles for the .header and .content classes:

/* index.css */

.header {
    font-size: 24px;
    color: #333;
    text-align: center;
}

.content {
    font-size: 16px;
    color: #666;
    line-height: 1.5;
}

In this example, the .header class applies larger text and a centered alignment, while the .content class provides a smaller font size, a different color, and adjusted line spacing.

CSS is a powerful tool that enhances the visual appeal of your website. By using an index.css file and styling elements through classes, you can maintain a clean separation of concerns in your web development projects. This introductory guide provides a glimpse into the world of CSS, but there's much more to explore as you dive deeper into the art of web styling. Start experimenting with your own styles and classes to create beautifully designed web pages.

Happy coding!

“Making a list, checking it twice……cause man these are confusing”: ‘twas the night before list comprehensions....

Jessica Papa — Wed, 26 Jul 2023 14:20:17 +0000

So, the day before my code challenge do-over, I was having a hard time wrapping my head around Python and object relationships. I was really hoping for that magical moment when it would all just click. During our practice challenge, I totally thought I blew it, but then when we went over it, something just clicked in my brain and suddenly I got it!

So, I had this moment where everything just made sense, but honestly, I'm still struggling with this issue. But, I figured writing about it would not only help me, but maybe others going through the same thing too. Life can be a crazy ride, am I right?

Let's dig a little deeper into this topic!

Of course, we know our comfy friend the for loop, it's safe and easier to understand when you're first learning Python!

Example:

the_list = []
        for concert in Concert.all:
            if concert.venue == self:
                the_list.append( concert )
         return the_list

Code breakdown:

the_list = []: This creates an empty list called the_list that will be used to store the concerts related with the venue.

for concert in Concert.all: Concert.all is a list (or iterable) that has all available concerts. The loop iterates through each concert in this list.

if concert.venue == self: This line checks if the venue of the current concert matches the given self, where self is referring to the venue object within the context of a method or class.

the_list.append(concert): If the venue matches, the concert is appended to the the_list.

After the loop is completed, the function returns the_list, which contains all the concerts associated with the given venue.

Yay, for loops!

So, have you ever heard of list comprehensions? They're actually a really handy tool in Python that can make your code a lot more efficient when working with lists.

Basically, you can use them to create a new list by applying an expression to each item in an existing list (or other iterable). This makes your code shorter and easier to read - pretty cool, right?

Example:

return [c for c in Concert.all if c.venue == self]

Code breakdown:

return: This indicates that the function will return a list.

c for c in Concert.all: This is the list comprehension syntax. The first c represents the whole concert instance that will go in your new list. The second c iterates through each c (concert) in Concert.all, which contains all available concerts.

if c.venue == self: The list comprehension includes c in the result only if the venue attribute of the c (concert) matches the value of self.

selfis referring to the venue object within the context of a method or class, representing the current venue.

I gotta give a shoutout to my teacher Adam for helping me have that "a-ha" moment cause this breakdown really helped me understand!

Remember:

When that imposter syndrome hits, think back on how far you have come!

Did you know what you know now a week ago?!

YOU CAN AND YOU ARE DOING THIS! BE KIND TO YOURSELF!

Happy coding!

Making The Switch And Understanding The Syntax: JavaScript VS Python

Jessica Papa — Thu, 06 Jul 2023 18:09:32 +0000

Hey there, everyone! I just wanted to update you all on my boot camp progress. I made it to the third phase, but I gotta say, it's been a real challenge. I was starting to feel pretty confident with JavaScript and JSX, but now we're learning a whole new language!

So which language am I learning now you ask? Why Python of course! Python is a programming language popular among beginners and professionals. It was created to be easy to read and write, making it a great choice for people new to programming.

Let's start with the basics!

JavaScript: console.log is a method for debugging and logging with more flexibility in terms of concatenation and formatting.

Python: print is a built-in function with automatic spacing and newline characters.

Both print in Python and console.log in JavaScript are used for displaying output, but they have slight differences in syntax and behavior.

Variable Declarations:

JavaScript: Use the let, or const keywords to declare variables.

Python: Variables are created when assigned a value. No declaration is needed.

Indentation:

JavaScript: Indentation is not significant for code blocks. Curly braces {} are used to define blocks.

Python: Indentation is crucial for code structure. It uses consistent indentation, typically four spaces, to define blocks.

Function Syntax:

JavaScript: Functions can be defined using the function keyword or as arrow functions (() => {}).

Python: Functions are defined using the def keyword, followed by the function name and parentheses.

Conditional Statements:

JavaScript: Uses if, else if, and else for conditional branching.

Python: Same conditional keywords are used (if, elif, else) but without parentheses, and a colon:is placed at the end of each line.

These are just a few examples, Happy Coding everyone!!

Embracing Change: My Journey from Veterinary and Dental Assistant to Software Engineer

Jessica Papa — Mon, 26 Jun 2023 18:03:45 +0000

Change is inevitable, and sometimes it is true that life presents us with unexpected opportunities that lead us down completely different paths. My name is Jessica, and for the past decade, I’ve worked as a vet assistant while also spending some time dental assisting. I learned a lot in both professions, and enjoyed them both. However as time passed, my priorities shifted. I realized a goal of mine was to build a sustainable life with my future wife. Unfortunately, I discovered that my career growth and financial prospects in my current fields had reached a plateau. It was during this time that a friend’s decision to become a software engineer interested me. This set me on an unexpected path. In this blog post, I will share my journey from a vet and dental assistant to an aspiring software engineer.

Discovering the Possibilities:
My friend Marissa had successfully completed a bootcamp for software engineering career, and I began to pick her brain about it. I realized that her professional growth and income were not the only factors that interested me. Memories of my teenage years, when I unknowingly coded HTML and CSS to customize my MySpace page (yes, it was that long ago! LOL). It sparked the idea that this could possibly be the right path for me as well.

Taking the Leap:
A complete career change can be super intimidating, so it took me two years of fighting my self doubt to finally go for it. Fueled by the desire for personal and professional growth, I built up the courage to enroll in a software engineering program. Going from working as a vet/dental assistant to being a student in an intensive program was not easy, but I was determined to try something new and grow in a field that seemed foreign to me.

The importance of teamwork:
While the decision to change careers was not easy, I am grateful for the opportunity and being able to connect with new people. Having a good support system within your classmates who are also learning a new path has been so crucial in my learning process. I am super grateful to have them my "sweet angel babies" along this journey.
Don't be afraid to ask questions and remind yourself that we are all learning something new, so try not to be hard on yourself!!

Conclusion:
Life is a journey of self-discovery. My transition from a vet and dental assistant to an aspiring software engineer has been filled with SO MANY highs and lows but, it has taught me the importance of embracing change, even when it seems scary.

Remember, it’s never too late to pursue your dreams and embark on a new path!