Tutorial by Examples: table

def foo(li=[]): li.append(1) print(li) foo([2]) # Out: [2, 1] foo([3]) # Out: [3, 1] This code behaves as expected, but what if we don't pass an argument? foo() # Out: [1] As expected... foo() # Out: [1, 1] Not as expected... This is because default arguments of function...

DataTables has the capability to enable or disable a number of its features, such as paging or searching. To choose these options, simply select them in your initialization: $(document).ready(function() { $('#tableid').DataTable( { "paging": false, //Turn off paging, all r...

DataTables comes with an extensive API which is used to manipulate or obtain information about the DataTables on a page. The API can be accessed in 3 ways: var table = $('#tableid').DataTable(); //DataTable() returns an API instance immediately var table = $('#tableid').dataTable().api(); //dataT...

In-place editing, while common, is a non-standard feature. A viable alternative would be to use an intermediate file to either store the original, or the output. sed 'sed commands' > file.out && mv file.out file # or mv file file.orig && sed 'sed commands' file.orig > file ...

In your Storyboard, add a UITableView object on your UIViewController and let it cover the entire view. Setup the UITableviewDataSource and UITableviewDelegate connections. Objective-C In your .h file NSMutableArray *arrayForBool; NSMutableArray *sectionTitleArray; In your .m file - (void)vi...

Suppose we want to get all product categories with total sales greater than 20. Here is a query without Common Table Expressions: SELECT category.description, sum(product.price) as total_sales FROM sale LEFT JOIN product on sale.product_id = product.id LEFT JOIN category on product.category_id ...

Suppose we want to query the "cheapest products" from the "top categories". Here is an example of query using Common Table Expressions -- all_sales: just a simple SELECT with all the needed JOINS WITH all_sales AS ( SELECT product.price as product_price, category.id a...

SELECT x, ... FROM ( SELECT y, ... FROM ... ) AS a JOIN tbl ON tbl.x = a.y WHERE ... This will evaluate the subquery into a temp table, then JOIN that to tbl. Prior to 5.6, there could not be an index on the temp table. So, this was potentially very inefficient: SELECT ... ...

One of the easiest ways to deploy Grails 3.x is to build an executable jar file that embeds a servlet container (Tomcat, Undertow, etc) with the application. Modify build.gradle: // Remove or comment out the war plugin: // apply plugin:"war" // Enable the executable jar: springBoot ...

ACID tables are supported since hive 0.14 version. Below table supports UPDATE/DELETE/INSERT Below configuration changes required in hive-site.xml. hive.support.concurrency = true hive.enforce.bucketing = true hive.exec.dynamic.partition.mode = nonstrict hive.txn.manager =org.apache.hadoop...

To use the Arduino IDE on Windows without needing to install it: Go to https://www.arduino.cc/en/Main/Software Click the "Windows ZIP file for non admin install" link Extract the archive to a folder Open the folder, and double click Arduino.exe

One of the most powerful capabilities in Excel is the use of Pivot Tables to sort and analyze data. Using VBA to create and manipulate the Pivots is easier if you understand the relationship of Pivot Tables to Pivot Caches and how to reference and use the different parts of the Tables. At its most ...

These excellent reference sources provide descriptions and illustrations of the various ranges in Pivot Tables. References Referencing Pivot Table Ranges in VBA - from Jon Peltier's Tech Blog Referencing an Excel Pivot Table Range using VBA - from globaliconnect Excel VBA

Two important things to note when adding fields to a Pivot Table are Orientation and Position. Sometimes a developer may assume where a field is placed, so it's always clearer to explicitly define these parameters. These actions only affect the given Pivot Table, not the Pivot Cache. Dim thisPivot ...

This example changes/sets several formats in the data range area (DataBodyRange) of the given Pivot Table. All formattable parameters in a standard Range are available. Formatting the data only affects the Pivot Table itself, not the Pivot Cache. NOTE: the property is named TableStyle2 because the ...

To import data from SQL Server to Hadoop: sqoop import --table TestTable --connect "jdbc:sqlserver://192.168.1.100:1433;database=Test_db" --username user --password password --split-by id --target-dir /user/test ...

This solution uses the ora:tokenize XQuery function that is available from Oracle 11. Sample Data: CREATE TABLE table_name ( id, list ) AS SELECT 1, 'a,b,c,d' FROM DUAL UNION ALL -- Multiple items in the list SELECT 2, 'e' FROM DUAL UNION ALL -- Single item in the list SELECT 3, NULL ...

This is a simple example to display read-only data that is tabular in nature using Qt's Model/View Framework. Specifically, the Qt Objects QAbstractTableModel (sub-classed in this example) and QTableView are used. Implementations of the methods rowCount(), columnCount(), data() and headerData() are...

ALTER TABLE table_name MOVE PARTITION partition_name TABLESPACE tablespace_name;

Using some setters, without setting all needed properties in the constructor(s) public final class Person { // example of a bad immutability private final String name; private final String surname; public Person(String name) { this.name = name; } public String ge...