Tutorial by Examples: me

For the following schema: {name: 'Tom', age: 28, marks: [50, 60, 70]} Update Tom's marks to 55 where marks are 50 (Use the positional operator $): db.people.update({name: "Tom", marks: 50}, {"$set": {"marks.$": 55}}) For the following schema: {name: 'Tom', age:...
After a statement was executed, a call to sqlite3_reset() brings it back into the original state so that it can be re-executed. Typically, while the statement itself stays the same, the parameters are changed: const char *sql = "INSERT INTO MyTable(ID, Name) VALUES (?, ?)"; sqlite3_stmt...
Employee Entity @Entity public class Employee { @TableGenerator(name = "employee_gen", table = "id_gen", pkColumnName = "gen_name", valueColumnName = "gen_val", allocationSize = 1) @Id @GeneratedValue(strategy = GenerationType.TABLE, generat...
Each table view must have a delegate and a data source. Delegate Methods None of the delegate methods are actually required, however you'll need to implement tableView:didSelectRowAtIndexPath: to handle touches on a table cell: And other methods are... // Display customization - (void)tableVi...
You can create a custom exception and throw them during the execution of your function. As a general practice you should only throw an exception when your function could not achieve its defined functionality. Private Function OpenDatabase(Byval Server as String, Byval User as String, Byval Pwd as S...
This example extends the basic example passing parameters in the route in order to use them in the controller To do so we need to: Configure the parameter position and name in the route name Inject $routeParams service in our Controller app.js angular.module('myApp', ['ngRoute']) .contro...
Select * from firm's_address; Select * from "firm's_address";
Say you have a table named table or you want to create a table with name which is also a keyword, You have to include the name table in pair of double quotes "table" Select * from table; Above query will fail with syntax error, where as below query will run fine. Select * from "tab...
package com.mcf7.spring.domain; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.boot.CommandLineRunner; import org.springframework.stereotype.Component; @Component public class DatabaseLoader implements CommandLineRunner { private final BookRep...
PHP Classes are powerful tool for improving code organization and minimizing naming collisions. At some point or another, the question of how to create an action hook for a class method inevitably arises. The $function_to_add argument is often shown as a string containing the function's name, howev...
With Ruby you can modify the structure of the program in execution time. One way to do it, is by defining methods dynamically using the method method_missing. Let's say that we want to be able to test if a number is greater than other number with the syntax 777.is_greater_than_123?. # open Numeric...
drop table table01; drop table table02; create table table01 ( code int, name varchar(50), old int ); create table table02 ( code int, name varchar(50), old int ); truncate table table01; insert into table01 values (1, 'A', 10); insert in...
[MetadataType(typeof(RoleMetaData))] public partial class ROLE { } public class RoleMetaData { [Display(Name = "Role")] public string ROLE_DESCRIPTION { get; set; } [Display(Name = "Username")] public string ROLE_USERNAME { get; set; } } If you us...
The main change needed is to switch use_global_stats to true. This switches to using the moving average. layer { bottom: 'layerx' top: 'layerx-bn' name: 'layerx-bn' type: 'BatchNorm' batch_norm_param { use_global_stats: true # use pre-calculated average and variance } param { lr_mult...
ASP.NET Core provides the status code pages middleware, that supports several different extension methods, but we are interesting in UseStatusCodePages and UseStatusCodePagesWithRedirects: UseStatusCodePages adds a StatusCodePages middleware with the given options that checks for responses with...
function myFunction { param( # If parameter 'a' is used, then 'c' is mandatory # If parameter 'b' is used, then 'c' is optional, but allowed # You can use parameter 'c' in combination with either 'a' or 'b' # 'a' and 'b' cannot be used together [p...
//define a short alias to avoid chubby method signatures using AppFunc = Func<IDictionary<string, object>, Task>; class RequestTimeMiddleware { private AppFunc _next; public RequestTimeMiddleware(AppFunc next) { _next = next; } public async Task...
We now know how to create a modal. But what if we want to pass some data from modal to our home page. To do so, let us look into an example with modal as Register page passing parameters to parent page. Register.html <ion-header> <ion-toolbar> <ion-title> Login ...
Passing parameters to a modal is similar to how we pass values to a NavController. To do so, we are altering our list in home.html to open a modal when clicking a list item and passing the required parameters as a second argument to the create method. Home.html <ion-list> <ion-item ...

Page 132 of 197