Skip to main content

Simple way to connect Database using SQLAlchemy.

Project description


Simple way to connect Database using SQLAlchemy.

Project motivations

This repository makes use of trivial options in the creation of the database engine. My intention is to facilitate the connection to the database using SQLAlchemy, distributing this package that I created and use many years ago, I intend over time to add standard options for each type of database, making only you worry about connecting to the database.

Suggestions, improvements and contact, I am available at email: ''.

How to install?

You can install using the following command:

pip install SQLAlchemy-Easy-Connection

Simple usage example

from SQLAlchemyEasyConnection.EasyConnections import EasyConnection  # Using this package we use to connect into database
from SQLAlchemyEasyConnection import DatabaseTypes  # This file is easy way to get you SQL server name
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column, Integer, String

db_connection = EasyConnection()  # Instance
                                  database="C:\\temp\\sqltest.db")  # Create Connection to database

# Using declarative base
Base = declarative_base()

# This class is a simple example to create using SQLAlchemy
class User(Base):
    __tablename__ = "user"

    id_user = Column(Integer, primary_key=True)
    name = Column(String)
    email = Column(String)

Base.metadata.create_all(db_connection.get_engine)  # Create table

# Creating a new user using ORM
user = User() = "foo" = ""

# Add new User

print(user.id_user)  # see? This show new user ID after create a new user in table 'user'

Project details

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

SQLAlchemy-Easy-Connection-0.0.2-0.0.2.tar.gz (4.3 kB view hashes)

Uploaded source

Built Distribution

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page