Please review the general instructions for preparing assignments.
In this assignment, you will build a simple RPC server that supports access to an in-memory spreadsheet running on a single machine. This will provide the basic capability that we will build upon over several assignments to work up to a fully distributed, scalable spreadsheet. The focus of this assignment will be on the remote procedure call (RPC) interface to the system.
For this first assignment, the server will simply keep a spreadsheet in memory and need only support a single client at a time. You will be adding more complexity in later assignments, one at a time.
Your spreadsheet server should support the following five operations:
insert( row, col, value ) -> Inserts the given value at a numeric row and column, overriding any existing value.
lookup( row, col ) -> Returns the value stored at that row and column.
remove( row, col ) -> Removes the value from that location.
size() -> Returns the maximum row and column values currently in use.
query( row, col, width, height ) -> Returns a rectangular subset of the spreadsheet.
Across the calls, rows and columns are integers, and values can be any Python values convertible to JSON. (e.g. strings, integers, booleans, dictionaries, lists)
You should design an appropriate set of JSON messages to represent a request and response for each operation. You can define this however you like, as long as it is consistent and works correctly. For example, a request to insert an item might look like this:
{
"method" : "insert",
"row" : 5,
"column" : 16,
"value" : { "weight":100, "animal":"zebra" }
}
In a similar way, the server should return a brief JSON message to indicate the result of the operation. Keep in mind that both the client and server should be able to distinguish between a successful operation, a failed operation, and a completely invalid request. You should have return messages to corresponding to each of these cases.
Take care: Each of the RPC operations may fail under normal use. For example, the user might attempt to remove a cell that is not present in the table.
If that happens, the server should not crash with an exception, but rather should return a suitable message to the client, so that the client can return an appropriate value or raise an exception to its caller. There should be no way in which the client can cause the server to crash.
To ensure some degree of consistency across the projects, please break your project down into several files with the following names. (It’s ok if you have additional files as well.)
SpreadSheet.py should contain the basic implementation of each of the five operations performed on a simple data structure in memory, and forms part of the server.SpreadSheetServer.py should contain the server-side RPC main program. It should accept a port number on the command line, create a listening TCP socket, accept incoming connections, decode messages coming from the client, invoke the proper operation, and then return the result to the client. This program should never exit of its own accord: use Control-C to kill it when you no longer need it.SpreadSheetClient.py should contain the client-side RPC operations. It should provide a method to connect to a server host and port, and a client-stub for each of the four spreadsheet operations that sends a message and waits for the response.TestBasics.py and TestPerf.py will accept a server name and port number on the command line, and then make use of SpreadSheetClient.py to connect to the indicated server and perform various tests.SpreadSheetServer.py should be started by giving a single argument – a port number –
on the command line. The server should attempt to listen on the port (if available)
and fail otherwise. If the port number zero is given, then the server should
listen on any available port. Either way, it should display the port it is listening on:
python3 SpreadSheetServer.py 9328
Listening on port 9328
python3 SpreadSheetServer.py 0
Listening on port 10475
Then, each of the test programs should accept a host name and port number that they will connect to. For example:
python3 TestBasics.py student10.cse.nd.edu 10475
Write two test programs to exercise your service:
TestBasics.py should exercise all of the RPC operations in various ways and evaluate them for correctness. For example, if you insert a value into the spreadsheet, you should be able to use lookup to get the same value back. If a value is removed from the table, then further lookups should fail, and so forth. Make sure that you test each of the ways each call can succeed or fail. Don’t proceed to the next step until you are sure all the details are right here.
TestPerf.py should time a sequence of operations in four stages: insert a large number of items in the table, lookup a large number of items, query the table in bulk, and finally remove all the items. Measure the throughput (ops/sec) obtained for each operation, and invert it to get the average latency of each operation.
Please review the general instructions for submitting assignments.
Turn in all of your source code, along with a lab report titled REPORT that describes the following in detail: