Python Column Examples

Example #1

 class C:
     id = dqo.Column(int, primary_key=True)
     b = dqo.ForeignKey(B.id)

Example #2

 class Something:
     col1 = dqo.Column([str])

Example #3

class Something:
    id = dqo.Column(int, primary_key=True)
    col1 = dqo.Column(int)

Example #4

 class Something:
     col1 = dqo.Column(int, name='col2')

Example #5

 class Something:
     col1 = dqo.Column(datetime.datetime, default=dqo.sql.NOW())

Example #6

 class Something:
     col1 = dqo.Column(int, null=False)

Example #7

 class A:
     col1 = dqo.Column(int)

Example #8

 class B:
     id = dqo.Column(int, primary_key=True)
     a = dqo.ForeignKey(A.id, null=False)

Example #9

 class B:
     id = dqo.Column(int, primary_key=True)
     a = dqo.ForeignKey(A.id, fake=True)

Example #10

 class A:
     x = dqo.Column(int, primary_key=True)
     y = dqo.Column(int, primary_key=True)

Example #11

 class A:
     x = dqo.Column(int)
     y = dqo.Column(int)
     _pk1 = dqo.PrimaryKey(x)
     _pk2 = dqo.PrimaryKey(y)

Example #12

 class CompoundPK:
     k1 = dqo.Column(int)
     k2 = dqo.Column(int)
     _pk = dqo.PrimaryKey(k1, k2)

Example #13

 class Something2:
     col1 = dqo.Column(int)
     col2 = dqo.Column(str)
     col3 = dqo.Column(int, name='col4')

Example #14

 class Something:
     id = dqo.Column(int, primary_key=True)
     col1 = dqo.Column(int)
     col2 = dqo.Column(str)
     col3 = dqo.Column(int, name='col4')

Example #15

 class A:
     col1 = dqo.Column(int)
     col2 = dqo.Column(int)
     _idx = dqo.Index(col1, include=[col2])

Example #16

 class A:
     id = dqo.Column(int, primary_key=True)

Example #17

 class A:
     col1 = dqo.Column(int)
     _idx = dqo.Index(col1, name='woot')

Example #18

 class B:
     id = dqo.Column(int, primary_key=True)
     x = dqo.ForeignKey(A.id)
     y = dqo.ForeignKey(A.id)

Example #19

 class B:
     col1 = dqo.Column(int)

Example #20

 class Something:
     col1 = dqo.Column(int)

Example #21

 class A:
     col2 = dqo.Column(int, aka='col1')

Example #22

 class A:
     col1 = dqo.Column(int, index=True)

Example #23

 class Something:
     col1 = dqo.Column(int, default=1)

Example #24

 class A:
     col1 = dqo.Column(int, unique=True)

Example #25

 class Something:
     col1 = dqo.Column(datetime.datetime, tz=True)

Example #26

 class A:
     col1 = dqo.Column(int)
     col2 = dqo.Column(int)
     _idx = dqo.Index(col1, col2)

Example #27

 class A:
     part1 = dqo.Column(int)
     part2 = dqo.Column(int)
     _pk = dqo.PrimaryKey(part1, part2)

Example #28

 class A:
     col1 = dqo.Column(int)
     _idx = dqo.Index(col1, method='hash')

Example #29

File: test_postgres.py Project: keredson/dqo

 class Something:
     col1 = dqo.Column(int)
     col2 = dqo.Column(str)

Example #30

class Something2:
    id = dqo.Column(int, primary_key=True)
    col1 = dqo.Column(int, name='col2')