💭 Column INSERT/UPDATE Defaults — SQLAlchemy 1.4 Documentation
==============================================================

!https://docs.sqlalchemy.org/en/14/core/defaults.html#server-invoked-ddl-explicit-default-expressions

Date: July 28, 2023

Column INSERT/UPDATE Defaults
 —
 SQLAlchemy 1.4 Documentation
 docs.sqlalchemy.org [1]

sqlalchemy server_defaults end up as defaults in the database when new values are inserted.

``` python
t = Table(
 "test",
 metadata_obj,
 Column("abc", String(20), server_default="abc"),
 Column("created_at", DateTime, server_default=func.sysdate()),
 Column("index_value", Integer, server_default=text("0")),
)

```

``` sql
CREATE TABLE test (
 abc varchar(20) default 'abc',
 created_at datetime default sysdate,
 index_value integer default 0
)
```

!!! note

 This post is a thought [2]. It's a short note that I make
 about someone else's content online #thoughts [3]

References:
[1]: https://docs.sqlalchemy.org/en/14/core/defaults.html#server-invoked-ddl-explicit-default-expressions
[2]: /thoughts/
[3]: /tags/thoughts/