ibm_db2_sqlalchemy_quickstart_table_create_insert_select.py

1import sqlalchemy
2from sqlalchemy import create_engine
3from sqlalchemy import Table, Column, Integer, String, MetaData, ForeignKey
4
5# Connection string format: db2+ibm_db://user:password@host:port/database
6# For SSL: db2+ibm_db://user:password@host:port/database?security=SSL
7engine = create_engine("db2+ibm_db://username:password@hostname:50000/DATABASE")
8
9metadata = MetaData()
10users = Table('users', metadata,
11    Column('id', Integer, primary_key=True),
12    Column('name', String(50)),
13    Column('fullname', String(50)),
14)
15
16# Create the table in the database
17metadata.create_all(engine)
18
19# Insert data
20ins = users.insert().values(name='jack', fullname='Jack Jones')
21conn = engine.connect()
22result = conn.execute(ins)
23
24# Select data
25s = sqlalchemy.select(users)
26result = conn.execute(s)
27
28for row in result:
29    print(row)
30
31conn.close()