Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import datetime
- import psycopg2
- conn = psycopg2.connect(database="emp", user="postgres",
- password="12345", host="127.0.0.1", port="5432")
- cur = conn.cursor()
- emp_name = str(input("Enter new employee name: "))
- while True:
- gender = str(input("Type your gender: "))
- if gender == 'M' or gender == 'F':
- break
- hire_date = input("Enter hire date(YYYY-MM-DD): ")
- year, month, day = map(int, hire_date.split('-'))
- hiredate = datetime.date(year, month, day)
- deptid = str(int(input("Enter department ID: ")))
- salary = str(int(input("Enter your salary: ")))
- cur.execute("INSERT INTO employee(emp_name, gender, hire_date,
- deptid, salary) VALUES (%s, %s, %s, %s, %s)",
- (emp_name, gender, hire_date, deptid, salary))
- cur.execute("SELECT * FROM employee")
- rows = cur.fetchall()
- print('n'.join(str(row) for row in rows))
- print("Created successfully!")
- conn.commit()
- conn.close()
Add Comment
Please, Sign In to add comment