import random
import psycopg2

global names
global last_names

names = [ 'Abbott',  'Acevedo',  'Acosta',  'Adams',  'Adkins',  'Aguilar',  'Aguirre',  'Albert',  'Alexander',  'Alford',
  'Allen',  'Allison',  'Alston',  'Alvarado',  'Alvarez',  'Anderson',  'Andrews',  'Anthony',  'Armstrong',  'Arnold',
  'Ashley',  'Atkins',  'Atkinson',  'Austin',  'Avery',  'Avila',  'Ayala',  'Ayers',  'Bailey',  'Baird',  'Baker',
  'Baldwin',  'Ball',  'Ballard',  'Banks',  'Barber',  'Barker',  'Barlow',  'Barnes',  'Barnett',  'Barr',  'Barrera',
  'Barrett',  'Barron',  'Barry',  'Bartlett',  'Barton',  'Bass',  'Bates',  'Battle',  'Bauer',  'Baxter',  'Beach',  'Bean',
  'Beard',  'Beasley',  'Beck',  'Becker',  'Bell',  'Bender',  'Benjamin',  'Bennett',  'Benson',  'Bentley',  'Benton',  'Berg',
  'Berger',  'Bernard',  'Berry',  'Best',  'Bird',  'Bishop',  'Black',  'Blackburn',  'Blackwell',  'Blair',  'Blake',  'Blanchard',
  'Blankenship',  'Blevins',  'Bolton',  'Bond',  'Bonner',  'Booker',  'Boone',  'Booth',  'Bowen',  'Bowers',  'Bowman',  'Boyd',
  'Boyer',  'Boyle',  'Bradford',  'Bradley',  'Bradshaw',  'Brady',  'Branch',  'Bray',  'Brennan',  'Brewer',
  'Bridges',  'Briggs',  'Bright',  'Britt',  'Brock',  'Brooks',  'Brown',  'Browning',  'Bruce',  'Bryan',  'Bryant',  'Buchanan',
  'Buck',  'Buckley',  'Buckner',  'Bullock',  'Burch',  'Burgess',  'Burke',  'Burks',  'Burnett',  'Burns',  'Burris',  'Burt',  'Burton',
  'Bush',  'Butler',  'Byers',  'Byrd',  'Cabrera',  'Cain',  'Calderon',  'Caldwell',  'Calhoun',  'Callahan',  'Camacho',
  'Cameron',  'Campbell',  'Campos',  'Cannon',  'Cantrell',  'Cantu',]

last_names = ['Levine',  'Levy',  'Lewis',  'Lindsay',  'Lindsey',  'Little',  'Livingston',  'Lloyd',  'Logan',  'Long',  'Lopez',
  'Lott',  'Love',  'Lowe',  'Lowery',  'Lucas',  'Luna',  'Lynch',  'Lynn',  'Lyons',  'Macdonald',  'Macias',
  'Mack',  'Madden',  'Maddox',  'Maldonado',  'Malone',  'Mann',  'Manning',  'Marks',
  'Marquez',  'Marsh',  'Marshall',  'Martin',  'Martinez',  'Mason',  'Massey',  'Mathews',  'Mathis',  'Matthews',
  'Maxwell',  'May',  'Mayer',  'Maynard',  'Mayo',  'Mays',  'Mcbride',  'Mccall',  'Mccarthy',  'Mccarty',
  'Mcclain',  'Mcclure',  'Mcconnell',  'Mccormick',  'Mccoy',  'Mccray',  'Mccullough',  'Mcdaniel',
  'Mcdonald',  'Mcdowell',  'Mcfadden',  'Mcfarland',  'Mcgee',  'Mcgowan',  'Mcguire',  'Mcintosh',  'Mcintyre',  'Mckay',  'Mckee',
  'Mckenzie',  'Mckinney',  'Mcknight',  'Mclaughlin',  'Mclean',  'Mcleod',  'Mcmahon',  'Mcmillan',  'Mcneil',  'Mcpherson',  'Meadows',  'Medina',  'Mejia',  'Melendez',  'Melton',  'Mendez',  'Mendoza',  'Mercado',  'Mercer',
  'Merrill',  'Merritt',  'Meyer',  'Meyers',  'Michael',  'Middleton',  'Miles',  'Miller',  'Mills',  'Miranda',
  'Mitchell',  'Molina',  'Monroe',  'Montgomery',  'Montoya',  'Moody',  'Moon',  'Mooney',  'Moore',  'Morales',
  'Moran',  'Moreno',  'Morgan',  'Morin',  'Morris',  'Morrison',  'Morrow',  'Morse',  'Morton',
  'Moses',  'Mosley',  'Moss',  'Mueller',  'Mullen',  'Mullins',  'Munoz',  'Murphy',  'Murray',
  'Myers',  'Nash',  'Navarro']

try:
    conn = psycopg2.connect("dbname='postgres' user='postgres' host='localhost' password='test'")

except:
    print "I am unable to connect to the database"


class Employees:

    def __init__(self, id, name, last_name, manager_id):
        self.id = id
        self.name = name
        self.last_name = last_name
        self.manager_id = manager_id

    def save(self):
        cur = conn.cursor()
        cur.execute(" INSERT INTO employees (id, name, last_name, manager_id)"
                    " values (%s, %s, %s, %s)", (self.id, self.name, self.last_name, self.manager_id))
        conn.commit()


def employees():

    global names
    global last_names
    for i in xrange(10000):

        id = i + 1
        manager_id = id / 2

        # print 'id: {} imie: {} nazwisko: {} managerid: {}'.format(id, random.choice(names),
        #  random.choice(last_names), manager_id)
        w = Employees(id, random.choice(names), random.choice(last_names), manager_id)
        w.save()

employees()