Assigning sequence numbers in editable tables
Assigning sequence numbers in editable tables including receiving, by a table manager via a client computing system, an instruction to create a new row on an editable table in a cloud-based data warehouse, wherein the instruction comprises a column value and a row identifier of an adjacent row; calculating, by the table manager, a sequence value for a sequence column of the new row based on the row identifier of the adjacent row; and generating, by the table manager, a database statement instructing the cloud-based data warehouse to add the new row, including the column value and sequence value, to the editable table on the cloud-based data warehouse.
1. A method for assigning sequence numbers in editable tables, the method comprising:
receiving, by a table manager via a manipulation of a graphical user interface GUI) by a user of a client computing system, an instruction to create a new row on an editable table in a cloud-based data warehouse, wherein the cloud-based data warehouse does not natively support row ordering and wherein the instruction comprises a row identifier of an adjacent row;
calculating, by the table manager, a sequence value for a sequence column of the new row based on the row identifier of the adjacent row; and
updating, by the table manager, the editable table on the cloud-based data warehouse, including generating and transmitting, to the cloud-based data warehouse, a database query instructing the cloud-based data warehouse to add the new row to the editable table on the cloud-based data warehouse, wherein the database query comprises the column value and the sequence value, addition of the new row maintains ordering of other rows of the editable table, and the column value is stored in a column of the new row.
2. The method of claim 1 , further comprising: presenting, by the table manager, the editable table on the client computing system based on an order of sequence values for rows in the editable table.
3. The method of claim 2 , wherein presenting, by the table manager, the editable table on the client computing system based on the order of sequence values for rows in the editable table comprises hiding the sequence values from presentation on the client computing system.
4. The method of claim 1 , further comprising:
receiving, by the table manager via the client computing system, an instruction to move the new row, wherein the instruction comprises a row identifier of an updated adjacent row;
calculating, by the table manager, an updated sequence value for the sequence column of the new row based on the row identifier of the updated adjacent row; and
generating, by the table manager, a subsequent database query instructing the cloud-based data warehouse to update the new row with the updated sequence value.
5. The method of claim 1 , wherein calculating, by the table manager, the sequence value for the sequence column of the new row based on the row identifier of the adjacent row comprises inserting the sequence column with the sequence value into the new row.
6. The method of claim 1 , wherein calculating, by the table manager, the sequence value for the sequence column of the new row based on the row identifier of the adjacent row comprises:
retrieving a first sequence value from a first adjacent row;
retrieving a second sequence value from a second adjacent row; and
calculating the sequence value for the new row as a value between the first sequence value and the second sequence value.
7. The method of claim 1 , wherein generating the database query comprises adding the sequence column to existing rows in the editable table by joining the editable table to a companion table comprising the sequence column.
8. The method of claim 1 , wherein the row identifier in the instruction is generated based on a location in the editable table selected by a user of the client computing system.
9. The method of claim 1 , wherein at least a portion of the sequence values in the sequence column are values between two consecutive integers.
10. The method of claim 1 , wherein the database query is a structured query language query.
11. An apparatus for assigning sequence numbers in editable tables, the apparatus comprising a computer processor, a computer memory operatively coupled to the computer processor, the computer memory having disposed within it computer program instructions that, when executed by the computer processor, cause the apparatus to carry out the steps of:
receiving, by a table manager via a manipulation of a graphical user interface (GUI) by a user of a client computing system, an instruction to create a new row on an editable table in a cloud-based data warehouse, wherein the cloud-based data warehouse does not natively support row ordering and wherein the instruction comprises a row identifier of an adjacent row;
calculating a sequence value for a sequence column of the new row based on the row identifier of the adjacent row; and
updating, by the table manager, the editable table on the cloud-based data warehouse, including generating and transmitting, to the cloud-based data warehouse, a database query instructing the cloud-based data warehouse to add the new row to the editable table on the cloud-based data warehouse, wherein the database query comprises the column value and the sequence value, addition of the new row maintains ordering of other rows of the editable table, and the column value is stored in a column of the new row.
12. The apparatus of claim 11 , wherein the computer program instructions further cause the apparatus to carry out the step of: presenting the editable table on the client computing system based on an order of sequence values for rows in the editable table.
13. The apparatus of claim 12 , wherein presenting the editable table on the client computing system based on the order of sequence values for rows in the editable table comprises hiding the sequence values from presentation on the client computing system.
14. The apparatus of claim 11 , wherein the computer program instructions further cause the apparatus to carry out the steps of:
receiving, by the table manager via the client computing system, an instruction to move the new row, wherein the instruction comprises a row identifier of an updated adjacent row;
calculating, by the table manager, an updated sequence value for the sequence column of the new row based on the row identifier of the updated adjacent row; and
generating, by the table manager, a subsequent database query instructing the cloud-based data warehouse to update the new row with the updated sequence value.
15. The apparatus of claim 11 , wherein calculating the sequence value for the sequence column of the new row based on the row identifier of the adjacent row comprises inserting the sequence column with the sequence value into the new row.
16. The apparatus of claim 11 , wherein calculating the sequence value for the sequence column of the new row based on the row identifier of the adjacent row comprises:
retrieving a first sequence value from a first adjacent row;
retrieving a second sequence value from a second adjacent row; and
calculating the sequence value for the new row as a value between the first sequence value and the second sequence value.
17. The apparatus of claim 11 , wherein generating the database query comprises adding the sequence column to existing rows in the editable table by joining the editable table to a companion table comprising the sequence column.
18. The apparatus of claim 11 , wherein the row identifier in the instruction is generated based on a location in the editable table selected by a user of the client computing system.
19. The apparatus of claim 11 , wherein at least a portion of the sequence values in the sequence column are values between two consecutive integers, and wherein the row identifier of the adjacent row included in the instruction is a value of a column other than the sequence column.
20. A computer program product for assigning sequence numbers in editable tables, the computer program product comprising a non-transitory computer readable medium storing computer program instructions that, when executed, cause a computer to carry out the steps of:
receiving, by a table manager via a manipulation of a graphical user interface (GUI) by a user of a client computing system, an instruction to create a new row on an editable table in a cloud-based data warehouse, wherein the cloud-based data warehouse does not natively support row ordering and wherein the instruction comprises a row identifier of an adjacent row;
calculating, by the table manager, a sequence value for a sequence column of the new row based on the row identifier of the adjacent row; and
updating, by the table manager, the editable table on the cloud-based data warehouse, including generating and transmitting, to the cloud-based data warehouse, a database query instructing the cloud-based data warehouse to add the new row to the editable table on the cloud-based data warehouse, wherein the database query comprises the column value and the sequence value, addition of the new row maintains ordering of other rows of the editable table, and the column value is stored in a column of the new row.