Tutorial by Examples: ble

To get a list of available serial ports use python -m serial.tools.list_ports at a command prompt or from serial.tools import list_ports list_ports.comports() # Outputs list of available serial ports from the Python shell.

Temporary tables could be very useful to keep temporary data. Temporary tables option is available in MySQL version 3.23 and above. Temporary table will be automatically destroyed when the session ends or connection is closed. The user can also drop temporary table. Same temporary table name can b...

Drop Temporary Table is used to delete the temporary table which you are created in your current session. DROP TEMPORARY TABLE tempTable1 DROP TEMPORARY TABLE IF EXISTS tempTable1 Use IF EXISTS to prevent an error occurring for tables that may not exist

Consider this example: public class ThreadTest implements Runnable { private boolean stop = false; public void run() { long counter = 0; while (!stop) { counter = counter + 1; } System.out.println("Counted " + counter);...

local t1, t2, t3, t4 = {}, {}, {}, {} -- Create 4 tables local maintab = {t1, t2} -- Regular table, strong references to t1 and t2 local weaktab = setmetatable({t1, t2, t3, t4}, {__mode = 'v'}) -- table with weak references. t1, t2, t3, t4 = nil, nil, nil, nil -- No more "strong" refe...

If you want to have a table organized in column-store format instead of row store, add INDEX cci CLUSTERED COLUMNSTORE in definition of table: DROP TABLE IF EXISTS Product GO CREATE TABLE Product ( ProductID int, Name nvarchar(50) NOT NULL, Color nvarchar(15), Size nvarchar(5)...

CREATE CLUSTERED COLUMNSTORE INDEX enables you to organize a table in column format: DROP TABLE IF EXISTS Product GO CREATE TABLE Product ( Name nvarchar(50) NOT NULL, Color nvarchar(15), Size nvarchar(5) NULL, Price money NOT NULL, Quantity int ) GO CREATE CLUSTERED C...

In this example, we'll create the following table using iText 5: We need the PdfPTable and PdfPCell class to achieve this: public void createPdf(String dest) throws IOException, DocumentException { Document document = new Document(); PdfWriter.getInstance(document, new FileOutputStream...

In this example, we'll create the following table using iText 7: We'll need the Table and Cell class to achieve this: public void createPdf(String dest) throws IOException { PdfDocument pdf = new PdfDocument(new PdfWriter(dest)); try (Document document = new Document(pdf)) { T...

Executable JAR files are the simplest way to assemble Java code into a single file that can be executed. *(Editorial Note: Creation of JAR files should be covered by a separate Topic.) * Assuming that you have an executable JAR file with pathname <jar-path>, you should be able to run it as f...

An NSPredicate can use substitution variables to allow values to be bound on the fly. Objective-C NSPredicate *template = [NSPredicate predicateWithFormat: @"self BEGINSWITH $letter"]; NSDictionary *variables = @{ @"letter": @"r" }; NSPredicate *beginsWithR = [templ...

In Julia, as in many other languages, it is possible to interpolate by inserting values defined by variables into strings. For a simple example: n = 2 julia> MyString = "there are $n ducks" "there are 2 ducks" We can use other types than numeric, e.g. Result = false j...

php bin/magento

This example covers common errors with using the 'java' command. "Command not found" If you get an error message like: java: command not found when trying to run the java command, this means that there is no java command on your shell's command search path. The cause could be: yo...

In InnoDB, having a long PRIMARY KEY (either a single column with a lengthy value, or several columns that form a long composite value) wastes a lot of disk space. The primary key value for a row is duplicated in all the secondary index records that point to the same row. Create an AUTO_INCREME...

val isOfAllowedAge = { user: User -> user.age > MINIMUM_AGE } val allowedUsers = users.filter(isOfAllowedAge)

Assume having a method returning IEnumerable<T>, f.e. private IEnumerable<T> GetData() { try { // return results from database } catch(Exception exception) { throw; } } Creates an Observable and starts a method asynchronously. Sel...

Build on the previous example by creating even more dynamic and powerful layouts with tablet .col-sm-* classes. <div class="row"> <div class="col-xs-12 col-sm-6 col-md-8">.col-xs-12 .col-sm-6 .col-md-8</div> <div class="col-xs-6 col-md-4">...

In addition to prebuilt grid classes for fast layouts, Bootstrap includes Less variables and mixins for quickly generating your own simple, semantic layouts. Variables Variables determine the number of columns, the gutter width, and the media query point at which to begin floating columns. We use ...

requests uses specific environment variables automatically for proxy detection. HTTP_PROXY will define the proxy URL to use for HTTP connections HTTPS_PROXY will define the proxy URL to use for HTTPS connections Once these environment variables are set, the Python code does not need to pass a...