When assigning boats to scpecific slots I added a field to the timeslots table that is filled by an overlap finder method.
What complications can you foresee while doing this exercise? I think that the capacity at the test stage is 12 and not 8 as suggested. #POST /api/assignments - assign boat to timeslot
#Peek com api install#
do bundle install in the peek_api home directory.I didn't test more cases but I would love to do so to discuss in a meeting. Test Unit is testing routes (controllers). I decided to use Rspec and Test Unit for the sake of practice.
This way, AmountMonthAfter can also be calculated.This API was designed and developed to accomplish passport coding challenge.īuilt using Ruby on Rails-API with SQLite. When the second table is created, the first table tmp1Amounts is dropped using a Drop Table statement.įinally, a third pass is made through the data, but now with the months sorted in reverse order. By comparing the product on the current row with the product on the previous row, this condition can be validated. The If() function is needed since the AmountMonthBefore only should be calculated if the previous row contains the data for the same product but for the previous month. It orders the records first by product, then by month in ascending order. This is done by running a second pass through the data creating a new table tmp2Amounts. The initial table is sorted according to month, which means that the peek() function would in many cases return the amount for the wrong product. If(Product=Peek(Product),Peek(Amount)) as AmountMonthAfter If(Product=Peek(Product),Peek(Amount)) as AmountMonthBefore By using temporary tables and running multiple passes through the data, such problems can be avoided. Furthermore, the Peek() function cannot be used to reference data that has not yet been loaded. Example 4ĭata needs to be correctly sorted in order to get the correct results but, unfortunately, this is not always the case. Peek(Amount,2) returns the third value in the table: 7. By substituting this value, values of other rows in the table can be fetched: Using -1 as row_no means that the value from previous row will be used. In this example, the following three function calls are equivalent:
Here, the row_no and table_name parameters are omitted, so the default values are used. The field AmountMonthBefore will hold the amount from the previous month. To see the result, add the fields listed in the results column to a sheet in your app. If you want to access data further down in a table, you need to do it in two steps: first, load the entire table into a temporary table, and then re-sort it when using Peek().Īdd the example script to your app and run it. However, note that without specifying the table as the third argument table_name in these examples, the function references the current (in this case, internal) table. Peek('EmployeeCode',2, 'EmployeeDates') returns the third value, 103, in the table as the FirstCode. Substituting the value of the argument row_no returns the values of other rows in the table, as follows: LastCode = 106 because Peek('EmployeeCode',-1, 'EmployeeDates') returns the last value of EmployeeCode in the table EmployeeDates. FirstCode = 101 because Peek('EmployeeCode',0, 'EmployeeDates') returns the first value of EmployeeCode in the table EmployeeDates.
0 kommentar(er)
