/Python/Sqlalchemy function for default value for column

Sqlalchemy function for default value for column

def mydefault(context):
    return context.get_current_parameters()['counter'] + 12

t = Table('mytable', meta,
    Column('counter', Integer),
    Column('counter_plus_twelve', Integer, default=mydefault, onupdate=mydefault)
)

Source: docs.sqlalchemy.org

Sqlalchemy function for default value for column

# a function which counts upwards
i = 0
def mydefault():
    global i
    i += 1
    return i

t = Table("mytable", meta,
    Column('id', Integer, primary_key=True, default=mydefault),
)

Source: docs.sqlalchemy.org

Similar codes

0 vote137 views1 answer
Python list iterate in 1 line
Python
4 votes122 views1 answer
Python code to drop columns from dataframe
Python
0 vote134 views1 answer
Python function guts
Python
1 vote168 views1 answer
Python print unicode character
Python
21 votes136 views5 answers
Python tkinter set minimum window size
Python
0 vote132 views1 answer
How to fill an array with consecutive numbers python
Python
0 vote121 views1 answer
Pyqt5 date-edity
Python
0 vote136 views1 answer
Python script that turns bluetooth on
Python
0 vote125 views1 answer
How to leave a function python
Python
4 votes127 views2 answers
Python join array of ints
Python