base on ActiveRecord stretch exercises # Active Record Exercises ## Introduction You'll find that this project has two Active Record "models" (classes): 1. Store 2. Employee This means that there is a `stores` table and an `employees` table in the database that it is using. Since we are using an ORM, we just use the two ruby classes and their instances to manage (CRUD) that data. We'll be modifying this database via Active Record only. The `setup.rb` file already defines the database structure so you _don't need_ to create anything in the database using SQL manually. That said, feel free to connect to your Postgres database using `psql` or pgAdmin so that you can see what's in the database. ## Instructions ### Setup 1. Create a new Postgres database. Use `psql postgres` to connect to the database server. Use `create database ar_exercises;` to create the database. 2. Take a look at the `establish_connection` method call in `setup.rb`. This will allow Active Record to connect to _your_ Postgres database. If you are using vagrant, you should not need to make any changes here. 3. Run `bundle install` to install the gems. 4. Run the first exercise file to make sure the database connection is working: `bundle exec ruby exercises/exercise_1.rb`. It should just output "Exercise 1" at the end, since you don't yet have any code in there. - Running without `bundle exec` may run the wrong version of ruby or it may use the correct version of ruby but with incorrect gem versions. - Using `bundle exec` for ruby scripts/apps is fairly common in the Ruby community. ### Running Exercises Complete the exercises by modifying the appropriate `exercises/exercise_*.rb` file and run the exercise using the `ruby` command. Example: bundle exec ruby exercises/exercise_1.rb Follow the instructions to work on the exercises within the `exercises` folder. Each exercise is to be completed in it's appropriate file. **IMPORTANT:** - Remember to `git commit` (and `git push`) at logical steps, like at the end of every exercise. - You do not need to / should not comment out your code in each exercise as you move on to the next one. The exercises in this assignment are meant to build on and continue from the previous ones. That's why you see them requiring the previous ones. - The setup ruby script actually drops and recreates the db tables with every run of the exercise. This is of course not practical in most real apps, because the data is usually meant to stay long term. You can work with the models with irb by running irb -r './setup.rb' ## Exercises ### Exercise 1: Create 3 stores 1. Use Active Record's `create` class method multiple times to create 3 stores in the database: - Burnaby (annual_revenue of 300000, carries men's and women's apparel) - Richmond (annual_revenue of 1260000 carries women's apparel only) - Gastown (annual_revenue of 190000 carries men's apparel only) 2. Output (`puts`) the number of the stores using ActiveRecord's `count` method, to ensure that there are three stores in the database. ### Exercise 2: Update the first store 1. Load the first store (with `id = 1`) from the database and assign it to an instance variable `@store1`. 2. Load the second store from the database and assign it to `@store2`. 3. Update the first store (`@store1`) instance in the database. (Change its name or something.) ### Exercise 3: Delete the third store 1. Load the third store (into `@store3`) as you did the other two before. 2. Using Active Record's `destroy` method, delete the store from the database. 3. Verify that the store has been deleted by again outputting (`puts`ing) the `count` (as you did in Exercise 1.) ### Exercise 4: Loading a subset of stores 1. Borrowing and modifying the code from Exercise one, create 3 more stores: - Surrey (annual_revenue of 224000, carries women's apparel only) - Whistler (annual_revenue of 1900000 carries men's apparel only) - Yaletown (annual_revenue of 430000 carries men's and women's apparel) 2. Using the `where` class method from Active Record, fetch (a collection of) only those stores that carry men's apparel. Assign the results to a variable `@mens_stores`. 3. Loop through each of these stores and output their name and annual revenue on each line. 4. Do another fetch but this time load stores that carry women's apparel and are generating less than $1M in annual revenue. ### Exercise 5: Calculations 1. Output the total revenue for the entire company (all stores), using Active Record's `.sum` calculation method. 2. On the next line, also output the average annual revenue for all stores. 3. Output the number of stores that are generating $1M or more in annual sales. **Hint:** Chain together `where` and `size` (or `count`) Active Record methods. ### Exercise 6: One-to-many association We haven't used the Employee class (and employees table) at all yet. If you look at this table's column structure, you'll find that it has a `store_id` (integer) column. This is a column that identifies which store each employee belongs to. It points to the `id` (integer) column of their store. Let's tell Active Record that these two tables are in fact related via the `store_id` column. 1. Add the following code _directly_ inside the Store model (class): `has_many :employees` 2. Add the following code directly inside the Employee model (class): `belongs_to :store` 3. Add some data into employees. Here's an example of one (note how it differs from how you create stores): `@store1.employees.create(first_name: "Khurram", last_name: "Virani", hourly_rate: 60)` 4. Go ahead and create some more employees using the create method. You can do this by making multiple calls to create (like you have before.) No need to assign the employees to variables though. Create them through the `@store#` instance variables that you defined in previous exercises. Create a bunch under `@store1` (Burnaby) and `@store2` (Richmond). Eg: `@store1.employees.create(...)`. ### Exercise 7: Validations for both models 1. Add validations to two models to enforce the following business rules: - Employees must always have a first name present - Employees must always have a last name present - Employees have a hourly_rate that is a number (integer) between 40 and 200 - Employees must always have a store that they belong to (can't have an employee that is not assigned a store) - Stores must always have a name that is a minimum of 3 characters - Stores have an annual_revenue that is a number (integer) that must be 0 or more - BONUS: Stores must carry at least one of the men's or women's apparel (hint: use a [custom validation method](http://guides.rubyonrails.org/active_record_validations.html#custom-methods) - **don't** use a `Validator` class) 2. Ask the user for a store name (store it in a variable) 3. Attempt to create a store with the inputted name but leave out the other fields (annual_revenue, mens_apparel, and womens_apparel) 4. Display the error messages provided back from ActiveRecord to the user (one on each line) after you attempt to save/create the record ", Assign "at most 3 tags" to the expected json: {"id":"4638","tags":[]} "only from the tags list I provide: [{"id":77,"name":"3d"},{"id":89,"name":"agent"},{"id":17,"name":"ai"},{"id":54,"name":"algorithm"},{"id":24,"name":"api"},{"id":44,"name":"authentication"},{"id":3,"name":"aws"},{"id":27,"name":"backend"},{"id":60,"name":"benchmark"},{"id":72,"name":"best-practices"},{"id":39,"name":"bitcoin"},{"id":37,"name":"blockchain"},{"id":1,"name":"blog"},{"id":45,"name":"bundler"},{"id":58,"name":"cache"},{"id":21,"name":"chat"},{"id":49,"name":"cicd"},{"id":4,"name":"cli"},{"id":64,"name":"cloud-native"},{"id":48,"name":"cms"},{"id":61,"name":"compiler"},{"id":68,"name":"containerization"},{"id":92,"name":"crm"},{"id":34,"name":"data"},{"id":47,"name":"database"},{"id":8,"name":"declarative-gui "},{"id":9,"name":"deploy-tool"},{"id":53,"name":"desktop-app"},{"id":6,"name":"dev-exp-lib"},{"id":59,"name":"dev-tool"},{"id":13,"name":"ecommerce"},{"id":26,"name":"editor"},{"id":66,"name":"emulator"},{"id":62,"name":"filesystem"},{"id":80,"name":"finance"},{"id":15,"name":"firmware"},{"id":73,"name":"for-fun"},{"id":2,"name":"framework"},{"id":11,"name":"frontend"},{"id":22,"name":"game"},{"id":81,"name":"game-engine "},{"id":23,"name":"graphql"},{"id":84,"name":"gui"},{"id":91,"name":"http"},{"id":5,"name":"http-client"},{"id":51,"name":"iac"},{"id":30,"name":"ide"},{"id":78,"name":"iot"},{"id":40,"name":"json"},{"id":83,"name":"julian"},{"id":38,"name":"k8s"},{"id":31,"name":"language"},{"id":10,"name":"learning-resource"},{"id":33,"name":"lib"},{"id":41,"name":"linter"},{"id":28,"name":"lms"},{"id":16,"name":"logging"},{"id":76,"name":"low-code"},{"id":90,"name":"message-queue"},{"id":42,"name":"mobile-app"},{"id":18,"name":"monitoring"},{"id":36,"name":"networking"},{"id":7,"name":"node-version"},{"id":55,"name":"nosql"},{"id":57,"name":"observability"},{"id":46,"name":"orm"},{"id":52,"name":"os"},{"id":14,"name":"parser"},{"id":74,"name":"react"},{"id":82,"name":"real-time"},{"id":56,"name":"robot"},{"id":65,"name":"runtime"},{"id":32,"name":"sdk"},{"id":71,"name":"search"},{"id":63,"name":"secrets"},{"id":25,"name":"security"},{"id":85,"name":"server"},{"id":86,"name":"serverless"},{"id":70,"name":"storage"},{"id":75,"name":"system-design"},{"id":79,"name":"terminal"},{"id":29,"name":"testing"},{"id":12,"name":"ui"},{"id":50,"name":"ux"},{"id":88,"name":"video"},{"id":20,"name":"web-app"},{"id":35,"name":"web-server"},{"id":43,"name":"webassembly"},{"id":69,"name":"workflow"},{"id":87,"name":"yaml"}]" returns me the "expected json"