how to define DateTime in python sqlalchemy with Mariadb?

Question

I am new to python .

I tried to make table on mariadb with python.

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:[email protected]/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()

it goes error

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

How can I use Datetime type ( '2021-10-21 22:31:12' ) with sqlalchemy ?

balderman · Accepted Answer · 2021-05-22 20:25:48Z

2

change

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

to

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

answered May 22, 2021 at 20:25

balderman

24k8 gold badges39 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

bingglex Over a year ago

Thanks. I got sense.

Collectives™ on Stack Overflow

how to define DateTime in python sqlalchemy with Mariadb?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related