如何使用Mariadb在python sqlalchemy中定义日期时间？

Question

我是python新手

我试图用python在mariadb上制作表格

import sqlalchemy
from sqlalchemy import create_engine

from sqlalchemy import MetaData
from sqlalchemy import Table, Column, Integer, String, MetaData
import datetime 


engine = create_engine("mariadb+pymysql://userid:password@127.0.0.1/mydatabase?charset=utf8mb4")

meta = MetaData()
table_accounts = Table(
    'accounts', meta, 
    Column ('id', Integer , primary_key = True ),
    Column ('coin', String ),
    Column ('amount', String ),
    Column ('created_at', Datetime, default=datetime.now ),
    Column ('updated_at', DateTime, default=datetime.now, onupdate=datetime.now ),
)

meta.create_all(engine)

conn = engine.connect()

它出错了

Column ('created_at', DateTime, default=datetime.now ),
NameError: name 'DateTime' is not defined

如何将Datetime类型（'2021-10-21 22:31:12'）与sqlalchemy一起使用

Answer 1

改变

from sqlalchemy import Table, Column, Integer, String, MetaData

到

from sqlalchemy import Table, Column, Integer, String, MetaData,DateTime