Tutorial by Examples: g

The engine is used to connect to different databases using a connection URL: from sqlalchemy import create_engine engine = create_engine('postgresql://user:pass@localhost/test') Note, however, that the engine does not actually establish a connection until it is first used. The engine automat...

You can open a connection (i.e. request one from the pool) using a context manager: with engine.connect() as conn: result = conn.execute('SELECT price FROM products') for row in result: print('Price:', row['price']) Or without, but it must be closed manually: conn = engine.co...

There are multiple ways to populate an array. Directly 'one-dimensional Dim arrayDirect1D(2) As String arrayDirect(0) = "A" arrayDirect(1) = "B" arrayDirect(2) = "C" 'multi-dimensional (in this case 3D) Dim arrayDirectMulti(1, 1, 2) arrayDirectMulti(0, 0, 0...

JSON data can also be read from files. Let's assume we have a file called data.json with the following content: [ { "Name" : "John Doe", "Standard" : 4 }, { "Name" : "Peter Parker", "Standard" : ...

Two-way Data-Binding supports the following attributes: ElementPropertiesAbsListViewandroid:selectedItemPositionCalendarViewandroid:dateCompoundButtonandroid:checkedDatePickerandroid:yearandroid:monthandroid:dayEditTextandroid:textNumberPickerandroid:valueRadioGroupandroid:checkedButtonRatingBarand...

Similar to int but accepts only positive integers (useful for pagination when there is a page parameter. Define: module.config(['$urlMatcherFactoryProvider', function($urlMatcherFactory) { $urlMatcherFactory.type('page', { decode: function(val) { return +val; }, encode: function(val) ...

In this code example, the char pointer p is initialized to the address of a string literal. Attempting to modify the string literal has undefined behavior. char *p = "hello world"; p[0] = 'H'; // Undefined behavior However, modifying a mutable array of char directly, or through a poin...

Smoothing, also known as blurring, is one of the most commonly used operation in Image Processing. The most common use of the smoothing operation is to reduce noise in the image for further processing. There are many algorithms to perform smoothing operation. We'll look at one of the most commonl...

The shape-margin CSS property adds a margin to shape-outside. CSS img:nth-of-type(1) { shape-outside: circle(80px at 50% 50%); shape-margin: 10px; float: left; width: 200px; } img:nth-of-type(2) { shape-outside: circle(80px at 50% 50%); shape-margin: 10px; float: right; w...

To fetch the latest version of an item in the current language: Sitecore.Context.Database.GetItem(new ID("{11111111-1111-1111-1111-111111111111}"));

If you need to get a specific language or version of an item, you can use these overloads of GetItem() Sitecore.Context.Database.GetItem("/sitecore/content/Sitecore", Language.Current, new Version(5));

To fetch the latest version of an item in the current language: Sitecore.Context.Database.GetItem("/sitecore/content/Sitecore")

let strings = "bananas,apples,pear".split(","); split returns an iterator. for s in strings { println!("{}", s) } And can be "collected" in a Vec with the Iterator::collect method. let strings: Vec<&str> = "bananas,apples,pear"....

Python has only limited support for parsing ISO 8601 timestamps. For strptime you need to know exactly what format it is in. As a complication the stringification of a datetime is an ISO 8601 timestamp, with space as a separator and 6 digit fraction: str(datetime.datetime(2016, 7, 22, 9, 25, 59, 55...

var wsHost = "http://my-sites-url.com/path/to/echo-web-socket-handler"; var ws = new WebSocket(wsHost); var buffer = new ArrayBuffer(5); // 5 byte buffer var bufferView = new DataView(buffer); bufferView.setFloat32(0, Math.PI); bufferView.setUint8(4, 127); ws.binaryType = 'arrayb...

This example adds a list of places with image and name by using an ArrayList of custom Place objects as dataset. Activity layout The layout of the activity / fragment or where the RecyclerView is used only has to contain the RecyclerView. There is no ScrollView or a specific layout needed. <?x...

There can be situations when you decide that one set of display objects should always be above another set of objects, for example, arrows over heads, explosions over something that just exploded, etc. To perform this as simple as possible, you need to designate and create a set of Sprites, arrange ...

Send-MailMessage -From [email protected] -Subject "Email Subject" -To [email protected] -SmtpServer smtp.com

$parameters = @{ From = '[email protected]' To = '[email protected]' Subject = 'Email Subject' Attachments = @('C:\files\samplefile1.txt','C:\files\samplefile2.txt') BCC = '[email protected]' Body = 'Email body' BodyAsHTML = $False CC = '[email protected]' Credential = Get-Crede...

To ensure encapsulation, member variables of a class should be private and only be accessible to public via public get/set access methods. It is a common practice to prefix private fields with _ public class Person { private var _name:String = ""; public function get name():S...