BlupSheets Node
Node to Interact with blup sheet database.

BlupSheets Node

Blupsheet node is a powerful node that is used to interact with the BlupSheets database. BlupSheets is a powerful GUI-based database that is built from ground zero to work perfectly with blup. It is built on top of AWS so your data is highly secured and all your data is highly available, so you can load/save data into BlupSheets.
โ€‹
Blup sheet node is used to insert, update, get and delete data that is present in the blue sheet database, this node is built based on a powerful SQL query format.
There are 5 major buttons in the BlupSheets node let see them one by one and find out how and for what they are used.

1. Table button.

This button helps you to connect with the particular table in the BlupSheets database on which you want to perform operations.
To add a database table using this button click on the plus icon next to it a dialog box will appear with all the tables that are present in your database, to select any table click on it, as soon as you click you can see that the check box next to it got checked, you can also select multiple tables at one time.

2. Select button.

This button helps you to define the type of operation you want to do in the database, when you click on the select button it shows you a drop-down.
Where you can see a total of four options.
  • Select - this option helps you to get the value from the database.
  • Insert - this option helps you to insert data into the database table that you have selected.
  • Update - this option helps you to update existing data into the database.
  • Delete โ€“ this option helps you to delete existing data in your database.

3. Where button

This button helps you to select a particular column in the database, where you want to update /select/delete your data.
When you click on the plus icon you can see that a dialog box opens up which shows you several features like the column button, operator button, and argument button.
Column button - is used to select a column of the table on which you want to operate.
Operator button - is used to select the type of operator for example less than, greater, equal to, etc.

4. OrderBy button.

this button helps you to get data in a certain order. For example, you have data of students in your database and you want to order student data by department or course this can be done with this button. This is not a mandatory field and is only available when you are getting data from the table or when the select option is selected from dropdown].

5. Limit button.

This button helps you to limit the amount of data that you get from the BlupSheets database. For example-suppose, you have student data in your database and you only want to get data of any five students this can be done with this button.
This button is also not mandatory to provide and is only present if you have selected the select value in the dropdown. Since you know all the functionality of the BlupSheets node. Now let see how to perform the different operation in database. For this, we are going to add some dummy data to the BlupSheets database. From the above picture, you can see we have added some students to the database.
Since you know all the functionality of the BlupSheets node. Now let see how to perform the different operation in database. For this, we are going to add some dummy data to the BlupSheets database.

Getting data from blupSheet

Suppose you want to get the list of students whose marks are greater than 65%. Let see step by step all things that you need to do to achieve this functionality.
Step 1. Get blup sheet node from the arsenal in blup lightning.
Step 2. Click on add/plus icon next to the table in node. This will open a dialog box that shows you all, the tables that are present in your database then select the table from the database from which you want to get data [Note multiple tables and also be selected].
Step 3. After that click on add/plus icon next to select [second button in node] and select the column which you want to get as output for example in our case student name and student roll number.
Step 4. Now it's time to apply our condition in your case it is students whose marks are greater than 65% for what click on plus/add icon next to where [third button in node]. A dialog box will open where you have to put information like column operator and argument
For example - In your case the value of the column will be student marks, an operator will be greater than and the argument will be 65.
Voila, we are done with all the steps. But if you want more control over the data that you are getting you can use the order by and limit field.
For example - if you want to get student data by their marks and order by department like engineering, you can use the order by button for that juts click on plus/add button next to order and then select the column.
Similarly, if you want to get the only top 5 students then you can use the limit, just click on add/plus icon next to the limit and enter the 5.
Thatโ€™s it.

How to insert the data in the BlupSheets database.

To insert the data into the BlupSheets database you have to use the BlupSheets-node, the process is very similar to the getting of data from the database. Now let see step by step how to do it.
Step 1. Get the BlupSheets node from the arsenal in the blup lightning.
Step 2. select the table on which you want to insert data.
Step 3. Now from the select dropdown menu [second button in node], select the option called "insert".
Step 4. Click on the plus/add icon next to the insert option to select the column name and press ok.
Step 5. After the selection of columns name you can see that node points with tables, names appear on the left-hand side in the BlupSheets node.
Step 6. Now, the final step is to just provide values to this node point, you can provide a list of values with as many values as you like.
Voila, All the steps are done.

How to update data in the blupsheet database

To update data in the blupsheet database the process is very similar to insert, you need a blup sheet node for it. Let see all the steps.
Step 1. first get the blupsheet node from the arsenal panel on blup lightning.
Step 2. After that select the table on which you want to update data.
Step 3. In the select dropdown menu select the update option, that click on add/plus icon next to update, you can see that a dialog box will open up, which will show you all the columns present in the database, select any column name [multiple columns can be selected ].
Step 4. Now if you want to apply for some condition on your insertion logic you can do it with the where button.
To apply the condition, click on add icon next to the where button, it will show you a dialogue box where you have to select the column name, operator type and argument.
Voila, you are done with all the steps and let see the updated value.

How to delete data in the BlupSheets database.

To delete the data in your database the process is similar to updating the data.
Let see step by step how to implement it.
Step 1. Get the blupsheet node from the arsenal in blup lightning.
Step2. Select the table name from the table button in the node on which you want to perform the deletion
Step3. Next hop onto the select drop-down menu and select the delete option
Step 4. The last step is to apply conditions on where you want to dele6e the data, so click on add icon next to where and then select the column and, operator and provide an argument.
We are done with all the steps