将SqlAlchemy集成到Django项目中的最佳方法

python manage.py startapp myapp

pip install sqlalchemy

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

Base = declarative_base()

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

engine = create_engine('postgresql://username:password@localhost/dbname')
Base.metadata.create_all(engine)

session = scoped_session(sessionmaker(bind=engine))

from django.http import HttpResponse
from .models import User, session

def add_user(request):
    # Add a new user to the database
    new_user = User(name='John Doe', age=30)
    session.add(new_user)
    session.commit()
    return HttpResponse('User added successfully')

INSTALLED_APPS = [
    # ...
    'myapp',
]

from django.urls import path
from . import views

urlpatterns = [
    # ...
    path('add_user/', views.add_user, name='add_user'),
]