sqlalchemy操作sqlite_sqlalchemy sqlite

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

engine = create_engine("sqlite:///test.db")
Session = sessionmaker()
Session.configure(bind=engine)
session = Session()

Base= declarative_base(engine)

class Test(Base):
    __tablename__ = 'test'
    id = Column(Integer, autoincrement=True, primary_key=True)
    name = Column(String(50))
    age = Column(String(50))
    create_time = Column(DateTime, default=datetime.now)


del_list = [Test.__table__,
                ]


# Base.metadata.drop_all(tables=del_list)
Base.metadata.create_all(tables=del_list)

item_dict = {
    'name': 'lucy',
    'age': 20
}
item = Test(**item_dict)
session.add(item)
session.commit()
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34

效果图