using TIMESTAMP in the created_at column fails with sqlite database

[ondiekelijah]

Congratulations on a job well done; that is an incredible series.

I recently run into an issue when using the TIMESTAMP with SQLite database.

Here's a brief of what's up.

With this ;

created_at = Column(TIMESTAMP(timezone=True), nullable=False, server_default=text('now()')

An exception is raised.

    def do_execute(self, cursor, statement, parameters, context=None):
>       cursor.execute(statement, parameters)
E       sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) near "(": syntax error
E       [SQL: 
E       CREATE TABLE posts (
E               id INTEGER NOT NULL, 
E               title VARCHAR NOT NULL, 
E               content VARCHAR NOT NULL, 
E               published BOOLEAN DEFAULT 'TRUE' NOT NULL, 
E               created_at TIMESTAMP DEFAULT now() NOT NULL, 
E               PRIMARY KEY (id)
E       )
E       
E       ]
E       (Background on this error at: https://sqlalche.me/e/14/e3q8)

However, modifying the column to use DateTime works for both;

created_at = Column(DateTime(timezone=True), default=func.now())

Is there any chance that a fix for this will be available?

[mvarrone]

Hello! I see a problem. I think you are missing a ) at the end of the line.

It should be like this:

created_at = Column(TIMESTAMP(timezone=True),
                    nullable=False, server_default=text('now()'))

[jonathanbouchet]

I had the same issue but found a discussion there

Also I'm using SQLAlchemy==2.0.25 so that's different from the version Sanjeev has in his requirements.

from sqlalchemy import Column, Integer, String, Boolean, ForeignKey, DateTime
from sqlalchemy.sql import func
created_at = Column(DateTime(timezone=True), server_default=func.now())