FilesExpand file tree

develop

/

create_table.py

Copy path

Blame

More file actions

Blame

More file actions

Latest commit

 

History

History

History

26 lines (20 loc) · 617 Bytes

develop

/

create_table.py

Copy path

Top

File metadata and controls

• Code
• Blame

26 lines (20 loc) · 617 Bytes

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

from engine_factory import CdmEngineFactory

from cdm6_tables import metadata

from sqlalchemy.sql import select

import datetime

cdm = CdmEngineFactory()

engine = cdm.engine

metadata.create_all(engine)

metadata.reflect(bind=engine)

for table in reversed(metadata.sorted_tables):

print(table)

Cohort = cdm.base.cohort

session = cdm.session

session.add(Cohort(cohort_definition_id=2, subject_id=100,

cohort_end_date=datetime.datetime.now(),

cohort_start_date=datetime.datetime.now()))

session.commit()

s = select([Cohort])

result = session.execute(s)

for row in result:

print(row)