8:00 – 3:00 SR

• Still no admin
• Given that I’m using FizzBuzz for the coding side of the SWE interview, I though I should put together a test for the database portion of the interview:
  • Create three tables:
    • One for names and salaries,
    • One for roles,
    • One that assigns a particular person to one or more roles.
  • Create a query that prints the name strings with their role strings. Extra points if it’s a view.
  • Create a query that sums the salaries.
  • Create a query that sums the salaries for a given role.

    DROP TABLE IF EXISTS test_people;
    CREATE TABLE test_people (
    	id_index 		INT AUTO_INCREMENT PRIMARY KEY NOT NULL,
    	name			varchar(255),
    	salary			BIGINT
    );
    
    insert into test_people (name, salary) values
    ('Sophia',10000000000),
    ('Emma',1000000000),
    ('Olivia',100000000),
    ('Isabella', 10000000),
    ('Jackson',1000000),
    ('Aiden',100000),
    ('Liam',10000),
    ('Noah', 1000),
    ('Charlotte', 100),
    ('Caden', 10),
    ('Harper', 1);
    
    DROP TABLE IF EXISTS test_roles;
    CREATE TABLE test_roles (
    	id_index 		INT AUTO_INCREMENT PRIMARY KEY NOT NULL,
    	role			varchar(255)
    );
    
    insert into test_roles (role) values
    ('Minion'),
    ('Worker'),
    ('Manager'),
    ('CEO'),
    ('Evil Overlord');
    
    DROP TABLE IF EXISTS test_assignments;
    CREATE TABLE test_assignments (
    	person_id 	INT,
    	role_id		INT
    );
    insert into test_assignments (person_id, role_id) values
    (1, 5),
    (2, 4),
    (3, 3),
    (4, 2),
    (5, 1),
    (6, 1),
    (7, 1),
    (8, 1);
    
    drop view IF EXISTS test_join;
    create view test_join as
    select p.name, r.role, p.salary
    	from test_assignments a
    	inner join test_people p on a.person_id = p.id_index
    	inner join test_roles r on a.role_id = r.id_index;
    
    select * from test_join;
    select sum(salary) from test_join where role = "Minion";
    
    DROP TABLE IF EXISTS test_people;
    DROP TABLE IF EXISTS test_roles;
    DROP TABLE IF EXISTS test_assignments;
    drop view IF EXISTS test_join;

• Add the ability to save a network and then start saving one!
• Since the mysqldump file doesn’t work on my server, spit the current schema file into three sections:
  • Table creation (incorporate DROP TABLE IF EXISTS table_name) – done
  • View creation – done
  • Tests – done
• Using the linkFn() in ngFlyoutPanel to call getNetworks() on the load of the directive. Wasn’t sure that it would work, but it does. In Chrome, FF, and IE yet..
• Uploaded to the main server. Works there, too!