DEV Community: Mohammad T. Khan

Getting Started with SQLAlchemy

Mohammad T. Khan — Mon, 05 Aug 2024 17:32:00 +0000

What is SQLAlchemy?

Think of SQLAlchemy as your friendly neighborhood guide to databases. It lets you chat with your databases using Python instead of complex SQL queries. It’s like translating a foreign language into your mother tongue!.

Key Features

SQLAlchemy has two main features:

Core: Direct database interaction using SQL expressions. This is like the engine of a car, powering direct interactions with your database using SQL.

ORM (Object-Relational Mapping): Maps Python classes to database tables for simpler database manipulation.

Setting Up Your Environment

First, install SQLAlchemy with pip:

pip install sqlalchemy

Crafting Your First Model

Models are blueprints of your database tables. Here’s a simple User model to get you started:

from sqlalchemy import create_engine, Column, Integer, String
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker

Base = declarative_base()

class User(Base):
    __tablename__ = 'users'
    id = Column(Integer, primary_key=True)
    name = Column(String)
    age = Column(Integer)

engine = create_engine('sqlite:///mydatabase.db')
Base.metadata.create_all(engine)
Session = sessionmaker(bind=engine)
session = Session()

Adding and Finding Users

Here's how to add a new user and find existing ones with ease:

# Adding a new user
new_user = User(name='John Doe', age=28)
session.add(new_user)
session.commit()

# Querying users
users = session.query(User).all()
for user in users:
    print(user.name, user.age)

Why SQLAlchemy Rocks

Using SQLAlchemy can feel like having a magic wand for your database tasks because:

It cuts down on complex SQL code.
It keeps your code clean and readable.
It works with different database types seamlessly.

Conclusion

SQLAlchemy is a fantastic tool for Python developers looking to interact with databases efficiently. It's both powerful and flexible, making database tasks simpler and your code cleaner.

How to Set Up a Flask Environment

Mohammad T. Khan — Sat, 20 Jul 2024 08:46:53 +0000

Introduction

Flask is a lightweight and versatile web framework for Python that makes it easy to create web applications. Whether you're building a simple web page or a complex, database-driven website, Flask provides the tools you need while keeping the core functionality minimal. This allows you to scale your application as needed without unnecessary overhead

Setting Up Your Flask Environment
Before we start coding, we need to set up our development environment. Here are the steps

1. Install Python
Make sure you have Python installed on your machine. You can download it from the official Python website here.

2. Install Flask
Use pip, the Python package installer, to install Flask. Open your terminal or command prompt and run:

pip install Flask

3. Create a Project Directory
Create a directory for your Flask project and navigate into it:

mkdir flask_app
cd flask_app

4. Create a Virtual Environment
It's a good practice to use a virtual environment for your projects. This keeps your project dependencies isolated. Run the following commands to create and activate a virtual environment:

python -m venv venv
source venv/bin/activate 
#or
venv\Scripts\activate

Creating Your First Flask Application
Now that our environment is set up, let's create a simple Flask application.

1. Create the Application File
Inside your project directory, create a file named app.py. This file will contain our Flask application code.

2. Write Your Flask Application
Open app.py in your text editor and add the following code:

from flask import Flask

app = Flask(__name__)

@app.route('/')
def home():
    return "Hello, Flask!"

if __name__ == '__main__':
    app.run(debug=True)

3. Run Your Application
Save the file and run the application by executing the following command in your terminal:

python app.py

If everything is set up correctly, you should see output indicating that the Flask server is running. Open your web browser and go to http://127.0.0.1:5000/. You should see "Hello, Flask!" displayed on the page.

Conclusion
In this post, we've introduced Flask, a lightweight web framework for Python. We covered the basics of setting up a Flask project and creating a simple web application. Flask's simplicity and flexibility make it an excellent choice for both beginners and experienced developers.

Python Lists Unpacked: Your Everyday Guide to Using Lists

Mohammad T. Khan — Sat, 06 Jul 2024 16:42:07 +0000

Today, I intend to share one of Python’s most simple yet powerful tools: lists.
Whether you’re just starting your coding journey or you've been coding in Python for a while, understanding lists and how to wield them can make your life a whole lot easier

What Exactly Are Python Lists?

Just as you are with your shopping list, think of yourself at a food market. You’ve got fruits, vegetables, snacks, and maybe some indulgent treats (of course, we all want something like this, don’t we?). In Python, a list is doing the same job. It's a collection of things, which are stored in one place, they are there and can - as a result - be added or removed. Here is an example of what it looks like:

my_shopping_list = ['apples', 'bananas', 'carrots', 'doughnuts']

Isn’t it simple? But don’t be deceived by their simplicity – lists can perform miracles.

Making and Extracting Lists

Everything is very easy where you’ve made a list. You should just take those things that should be on your list and include them in square brackets; the list is yours in a second. A list can be generated like this:

my_friends = ['Alice', 'Bob', 'Charlie']

Now, let’s say you want to know who is at the top of your friends’ list. To access any element within a list we use its index number. Mind that Python starts indexing from zero so that the first element would be indexed 0:

first_friend = my_friends[0] # This will be ‘Alice’

Adding and Removing Elements

Have a new pal? No worries. Use the append() method to add them at the end of the list:

my_friends.append('Diana')

Oh no, made an error? Do you have to eliminate someone from this list? It’s possible to remove any value from a list through remove():

my_friends.remove('Bob')

Alternatively, when you want to pop off an item at the end, simply use pop():

last_friend = my_friends.pop() # Removes and returns 'Diana' (if she was the last)

Why Use Lists?

Lists aren’t limited to merely saving a bunch of names or things. They are vital for Python data handling. Data iteration, object differentiation or mere programming organization can be facilitated using lists.

They also are what leads us to more complex data structures like arrays (in libraries like NumPy). These are necessary for data analysis and scientific computing.

Conclusion

In brief, there is flexibility in using python lists for programming in different ways as they’re simple and helpful tools. Beginning with managing little variable collections up to working on large datasets, mastering all that lists stand will help significantly on your coding journey.