limit、offset和切片
- limit:可以限制每次查询的时候只查询几条数据
- offset:可以限制查找数据的时候过滤掉前面多少条
- 切片:可以对Query对象使用切片操作,来获取想要的数据。
初始代码:
from sqlalchemy import create_engine
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import Column,Integer,String,DECIMAL,Boolean,Enum,DateTime,TEXT,ForeignKey
from sqlalchemy.orm import sessionmaker,relationship
HOSTNAME = '127.0.0.1'
DATABASE = 'class'
PORT = 3306
USERNAME = 'root'
PASSWORD = 'root'
DB_URL = 'mysql+pymysql://{}:{}@{}:{}/{}'.format(USERNAME,PASSWORD,HOSTNAME,PORT,DATABASE)
engine = create_engine(DB_URL)
Base = declarative_base(engine)
class Article(Base):
__tablename__ = 'article'
id = Column(Integer,primary_key=True,autoincrement=True)
title = Column(String(50))
__mapper_args__ = {
&