Tutorial by Examples: ti

In C, there are two unary operators - '++' and '--' that are very common source of confusion. The operator ++ is called the increment operator and the operator -- is called the decrement operator. Both of them can be used used in either prefix form or postfix form. The syntax for prefix form for ++ ...

CREATE CERTIFICATE My_New_Cert FROM FILE = 'D:\Temp\CertTest\certificateDER.cer' GO Create the certificate SELECT EncryptByCert(Cert_ID('My_New_Cert'), 'This text will get encrypted') encryption_test Usually, you would encrypt with a symmetric key, that key would get encrypted by the asym...

USE TDE CREATE DATABASE ENCRYPTION KEY WITH ALGORITHM = AES_256 ENCRYPTION BY SERVER CERTIFICATE My_New_Cert GO ALTER DATABASE TDE SET ENCRYPTION ON GO This uses 'Transparent Data Encryption' (TDE)

-- Create the key and protect it with the cert CREATE SYMMETRIC KEY My_Sym_Key WITH ALGORITHM = AES_256 ENCRYPTION BY CERTIFICATE My_New_Cert; GO -- open the key OPEN SYMMETRIC KEY My_Sym_Key DECRYPTION BY CERTIFICATE My_New_Cert; -- Encrypt SELECT EncryptByKey(Key_GUID('SSN_Key_01'),...

Odoo (formerly known as OpenERP and before that, TinyERP) is a suite of open core enterprise management applications. Targeting companies of all sizes, the application suite covers all business needs, from Website/Ecommerce down to manufacturing, inventory and accounting, all seamlessly integrated. ...

This function gets existing item form cache, and if the item don't exist in cache, it will fetch item based on the valueFetchFactory function. public static TValue GetExistingOrAdd<TValue>(string key, double minutesForExpiration, Func<TValue> valueFetchFactory) { ...

Given these sample data: IDSTATUSSTATUS_TIMESTATUS_BY1ONE2016-09-28-19.47.52.501398USER_13ONE2016-09-28-19.47.52.501511USER_21THREE2016-09-28-19.47.52.501517USER_33TWO2016-09-28-19.47.52.501521USER_23THREE2016-09-28-19.47.52.501524USER_4 Items identified by ID values must move from STATUS 'ONE' to...

SASS's optional arguments let you use a parameter only if you specify its value; otherwise, it will be ignored. Let's take an example of the following mixin: @mixin galerie-thumbnail ($img-height:14em, $img-width: null) { width: $img-width; height: $img-height; outline: 1px solid li...

Transformations can be applied to elements by adding a transform attribute: <circle cx="0" cy="0" r="50" transform="translate(50,50)"/> Or to groups of elements enclosed in <g> tags: <g transform="translate(50,50)"> <circle...

Translate translate moves graphics along specified vectors: <circle cx="0" cy="0" r="50" transform="translate(50,50)"/> The first value is the x translation, and the second the y. If the y is omitted, it will default to 0. Scale scale resizes elem...

Deferred execution enables combining different operations to build the final query, before evaluating the values: var list = new List<int>() {1,1,2,3,5,8}; var query = list.Select(x => x + 1); If we execute the query at this point: foreach (var x in query) { Console.Write($"...

With deferred execution, if the data to be queried is changed, the query object uses the data at the time of execution, not at the time of definition. var data = new List<int>() {2, 4, 6, 8}; var query = data.Select(x => x * x); If we execute the query at this point with an immediate m...

By Creating Custom Progress Dialog class, the dialog can be used to show in UI instance, without recreating the dialog. First Create a Custom Progress Dialog Class. CustomProgress.java public class CustomProgress { public static CustomProgress customProgress = null; private Dialog m...

All instances (objects) of an entity class can be loaded from the underlying database table as follows (akin to retrieving all rows from the table): Iterable<Foo> foos = fooRepository.findAll(); The findAll method is provided by the CrudRepository interface. It returns an Iterable instead ...

A particular instance of an entity class can be loaded as follows: Foo foo = fooRepository.findOne(id); The findOne method is provided by the CrudRepository interface. It expects an identifier that uniquely identifies an entity instance (for instance, a primary key in a database table). The Java...

All instances of an entity class with one of the class attributes matching a specified value can be retrieved as follows: public interface FooRepository extends CrudRepository<Foo, Long> { List<Foo> findAllByName(String name); } Invoking the findAllByName method results in the JP...

node_redis, as you may have guessed, is the Redis client for Node.js. You can install it via npm using the following command. npm install redis Once you have installed node_redis module you are good to go. Let’s create a simple file, app.js, and see how to connect with Redis from Node.js. app...

Checking the Existence of Keys Sometimes you may need to check if a key already exists and proceed accordingly. To do so you can use exists() function as shown below: client.exists('key', function(err, reply) { if (reply === 1) { console.log('exists'); } else { cons...

ICU(International Components for Unicode) can be installed as a library for the following languages: Java: ICU4J C/C++: ICU4C Python: pyICU Perl: Wrappers for ICU (PICU) C#: ICU-dotnet Erlang: icu4e Ruby: ffi-icu Haskell: text-icu Lua: ICU4Lua Here is a series of installion steps for a...

Here i am going to explain the ajax custom pagination in cakephp 3.2. This one is easier to use and understandable. Do this code inside any function and any controller you need. Make an ajax call for the pagination <script type="text/javascript"> $(document).ready(function ()...