Exemplo n.º 1
0
# session.add(dep_fn)
wh = Employee(
    emp_name='王贺',
    gender='male',
    birth_date='1993-1-1',
    phone='17788990022',
    email='*****@*****.**',
    dep_id=1
)
lj = Employee(
    emp_name='李俊',
    gender='male',
    birth_date='1995-10-1',
    phone='13355667788',
    email='*****@*****.**',
    dep_id=4
)
zzh = Employee(
    emp_name='赵子浩',
    gender='male',
    birth_date='1999-5-4',
    phone='13556789987',
    email='*****@*****.**',
    dep_id=4
)
# session.add_all([wh, lj, zzh])
wh20181001 = Salary(emp_id=1, date='2018-10-01', basic=15000, awards=5000)
session.add(wh20181001)
session.commit()
session.close()
Exemplo n.º 2
0
#!/usr/bin/env python3
# -*- coding:utf-8 -*-
from dbconn import Departments, Session, Employees, Salary

session = Session()  #创建session会话
dev = Departments(dep_name='development')
print(dev.dep_name)
print(dev.dep_id)
dev = Departments(dep_name="人事部", dep_id=2)
session.add(dev)  #添加一个
ops = Departments(dep_name="运维部")
finance = Departments(dep_name="财务部")

session.add_all([ops, finance])  #添加多个
session.commit()
#print(dev.dep_id)
session.close()
Exemplo n.º 3
0
dep_dev = Department(dep_name='development')
dep_hr = Department(dep_name='人事部')
dep_op = Department(dep_name='运维部')
# session.add_all([dep_hr,dep_op])
#session.add(dep_dev)
my = Employee(emp_name='马云',
              gender='malse',
              birth_date='1991-01-02',
              phone='15988663322',
              email='*****@*****.**',
              dep_id=3)
mht = Employee(emp_name='马化腾',
               gender='malse',
               birth_date='1991-05-02',
               phone='15988776655',
               email='*****@*****.**',
               dep_id=3)
lyh = Employee(emp_name='李彦宏',
               gender='malse',
               birth_date='1991-06-02',
               phone='15999886655',
               email='*****@*****.**',
               dep_id=3)

my201810 = Salary(emp_id=1, date='2018-10-01', basic=15000, awards=5000)
session.add(my201810)

#session.add_all([my,mht,lyh])
session.commit()
session.close()
Exemplo n.º 4
0
#!/usr/bin/env python3
# _*_coding:utf8_*_
from dbconn import Departments, Session

hr = Departments(dep_id=1, dep_name='hr')
ops = Departments(dep_id=2, dep_name='operations')
dev = Departments(dep_id=3, dep_name='development')
finance = Departments(dep_id=4, dep_name='财务部')
deps = [ops, dev]
print(hr.dep_id, hr.dep_name)

session = Session()
session.add(hr)
session.add_all(deps)
session.add(finance)
session.commit()
session.close()
Exemplo n.º 5
0
from dbconn import Session, Salary

aug2018 = Salary(date='2018-8-10', emp_id=1, basic=10000, awards=2000)
session = Session()
session.add(aug2018)
session.commit()
session.close()
Exemplo n.º 6
0
               email='*****@*****.**',
               dep_id=2)
ds = Employees(emp_id=5,
               name='德斯',
               gender='男',
               phone='18923745193',
               email='*****@*****.**',
               dep_id=2)
nd = Employees(emp_id=6,
               name='牛顿',
               gender='女',
               phone='10438201348',
               email='*****@*****.**',
               dep_id=4)
te = Employees(emp_id=7,
               name='test',
               gender='fale',
               phone='12345678910',
               email='*****@*****.**',
               dep_id=1)
emps1 = [kellon, moly]
emps2 = [kn, ds, nd]

session = Session()
session.add(te)
session.add(xl)
session.add_all(emps1)
session.add_all(emps2)
session.commit()
session.close()
Exemplo n.º 7
0
#SQLAlchemy
#向表中添加内容

from dbconn import Session, Departments, Employees, Salary

hr = Departments(dep_name='hr')  ##向表Departments添加hr
print(hr.dep_id)  # 此时还没有在数据库中创建记录,所以是None
print(hr.dep_name)
session = Session()  # 建立到数据库的会话连接
session.add(hr)  # 真正向数据库写入记录

# op=Departments(dep_id=2,dep_name='运维部')
# session=Session()
# session.add(op)

# dev=Departments(dep_id=3,dep_name='开发部')
# qa=Departments(dep_id=4,dep_name='测试部')
# session=Session()
# session.add_all([dev,qa])

##向employees表添加内容
bob = Employees(emp_id=1,
                emp_name='Bob',
                gender='male',
                birth_date='1995-08-23',
                email='*****@*****.**',
                dep_id='1')
john = Employees(emp_id=2,
                 emp_name='John',
                 gender='male',
                 birth_date='1992-06-2',
Exemplo n.º 8
0
from dbconn import Department, Student, Session

session = Session()
dep_hr = Department(dep_name='人事部')
dep_op = Department(dep_name='运维部')
dep_fn = Department(dep_id=3, dep_name='财务部')
session.add(dep_fn)
# session.add_all([dep_hr,dep_op])

session.commit()
session.close()
Exemplo n.º 9
0
from dbconn import Departments, Session

session = Session()

hr = Departments(dep_id=1, dep_name='人事部')
ops = Departments(dep_id=2, dep_name='运维部')
dev = Departments(dep_id=3, dep_name='开发部')
devops = Departments(dep_id=4, dep_name='DEVOPS')
finance = Departments(dep_id=5, dep_name='财务部')
deps = [ops, dev, devops, finance]
session.add(hr)
session.add_all(deps)
session.commit()
session.close()