# Programs & Examples On #Conjunctive normal form

In Boolean logic, a formula is in conjunctive normal form (CNF) if it is a conjunction of clauses, where a clause is a disjunction of literals, where a literal and its complement cannot appear in the same clause.

### Disable autocomplete via CSS

I just use `'new-password'` instead `'off'` on autocomplete.

and I also have try using this code and works (at least on my end), I use WP and GravityForm for your information

``````\$('input').attr('autocomplete','new-password');
``````

### Efficient way to apply multiple filters to pandas DataFrame or Series

Since pandas 0.22 update, comparison options are available like:

• gt (greater than)
• lt (lesser than)
• eq (equals to)
• ne (not equals to)
• ge (greater than or equals to)

and many more. These functions return boolean array. Let's see how we can use them:

``````# sample data
df = pd.DataFrame({'col1': [0, 1, 2,3,4,5], 'col2': [10, 11, 12,13,14,15]})

# get values from col1 greater than or equals to 1
df.loc[df['col1'].ge(1),'col1']

1    1
2    2
3    3
4    4
5    5

# where co11 values is better 0 and 2
df.loc[df['col1'].between(0,2)]

col1 col2
0   0   10
1   1   11
2   2   12

# where col1 > 1
df.loc[df['col1'].gt(1)]

col1 col2
2   2   12
3   3   13
4   4   14
5   5   15
``````

### SQL SELECT from multiple tables

``````SELECT
pid,
cid,
pname,
name1,
null
FROM
product p
INNER JOIN
customer1 c ON p.cid = c.cid
UNION
SELECT
pid,
cid,
pname,
null,
name2
FROM
product p
INNER JOIN
customer2 c ON p.cid = c.cid
``````

### default web page width - 1024px or 980px?

If it isn't I could see things heading that way.

I'm working on redoing the website for the company I work for and the designer they hired used a 960px width layout. There is also a 960px grid system that seems to be getting quite popular (http://960.gs/).

I've been out of web stuff for a few years but from what I've read catching up on things it seems 960/980 is about right. For mobile ~320px sticks in my mind, by which 960 is divisible. 960 is also evenly divisible by 2, 3, 4, 5, and 6.

### Extract file basename without path and extension in bash

The basename command has two different invocations; in one, you specify just the path, in which case it gives you the last component, while in the other you also give a suffix that it will remove. So, you can simplify your example code by using the second invocation of basename. Also, be careful to correctly quote things:

```fbname=\$(basename "\$1" .txt)
echo "\$fbname"
```

### How to set viewport meta for iPhone that handles rotation properly?

``````<meta name="viewport" content="width=device-width, minimum-scale=1, maximum-scale=1">
``````

suport all iphones, all ipads, all androids.

### Network usage top/htop on Linux

jnettop is another candidate.

edit: it only shows the streams, not the owner processes.

### Cannot create a connection to data source Error (rsErrorOpeningConnection) in SSRS

I had a similar problem, and being the newbie that I am it took me a while to figure out but I learned the user must have a login in SSMS. I created the logins with the following parameters:

• Under Server Roles - check sysadmin
• Under User Mapping - I selected the database and the report server. For each I checked datareader and datawriter
• Under Securables - I checked anything that would allow the user to connect to the database and view anything
• I also found that one of the existing logins had denydatareader and denydatawriter checked. Once I removed these it worked.

I'm not saying this is the best way to do it, just what worked for me. Hope this helps

### Convert Date/Time for given Timezone - java

For me, the simplest way to do that is:

``````Calendar calendar = Calendar.getInstance();
calendar.setTime(new Date());
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd hh:mm:ss");

//Here you say to java the initial timezone. This is the secret
sdf.setTimeZone(TimeZone.getTimeZone("UTC"));
//Will print in UTC
System.out.println(sdf.format(calendar.getTime()));

//Here you set to your timezone
sdf.setTimeZone(TimeZone.getDefault());
//Will print on your default Timezone
System.out.println(sdf.format(calendar.getTime()));
``````

### Select DataFrame rows between two dates

I feel the best option will be to use the direct checks rather than using loc function:

``````df = df[(df['date'] > '2000-6-1') & (df['date'] <= '2000-6-10')]
``````

It works for me.

Major issue with loc function with a slice is that the limits should be present in the actual values, if not this will result in KeyError.

### The AWS Access Key Id does not exist in our records

If you have an AWS Educate account and you get this problem:

An error occurred (InvalidAccessKeyId) when calling the ListBuckets operation: The AWS Access Key Id you provided does not exist in our records".

The solution is here:

1. Go to your `C:/` drive and search for `.aws` folder inside your main folder in windows.

2. Inside that folder you get the "credentials" file and open it with notepad.

3. Paste the whole key credential from AWS account to the same notepad and save it.

4. Now you are ready to use you AWS Educate account.

### Merging dataframes on index with pandas

You can do this with `merge`:

``````df_merged = df1.merge(df2, how='outer', left_index=True, right_index=True)
``````

The keyword argument `how='outer'` keeps all indices from both frames, filling in missing indices with `NaN`. The `left_index` and `right_index` keyword arguments have the merge be done on the indices. If you get all `NaN` in a column after doing a merge, another troubleshooting step is to verify that your indices have the same `dtypes`.

The `merge` code above produces the following output for me:

``````                V1    V2
A 2012-01-01  12.0  15.0
2012-02-01  14.0   NaN
2012-03-01   NaN  21.0
B 2012-01-01  15.0  24.0
2012-02-01   8.0   9.0
C 2012-01-01  17.0   NaN
2012-02-01   9.0   NaN
D 2012-01-01   NaN   7.0
2012-02-01   NaN  16.0
``````

### Exception of type 'System.OutOfMemoryException' was thrown.

I just restarted Visual Studio and did IISRESET which solved the problem.

### Change application's starting activity

Go to AndroidManifest.xml in the root folder of your project and change the Activity name which you want to execute first.

Example:

``````<activity android:name=".put your started activity name here"
android:label="@string/app_name">
<intent-filter>
<action android:name="android.intent.action.MAIN" />
<category android:name="android.intent.category.LAUNCHER" />
</intent-filter>
</activity>
``````

### Find out which remote branch a local branch is tracking

``````\$ git remote --verbose
``````

(or)

``````\$ git remote --v
``````

(or)

``````\$ git remote -vv
``````

(or) To Know about the remote branch in details and Head branch

``````\$ git remote show origin
``````

``````\$ git remote show origin | grep master
master tracked
master merges with remote master
master pushes to master (up to date)
``````

### 'No database provider has been configured for this DbContext' on SignInManager.PasswordSignInAsync

Override constructor of DbContext Try this :-

``````public DataContext(DbContextOptions<DataContext> option):base(option) {}
``````

### How to center-justify the last line of text in CSS?

You can use the `text-align-last` property

``````.center-justified {
text-align: justify;
text-align-last: center;
}
``````

Here is a compatibility table : https://developer.mozilla.org/en-US/docs/Web/CSS/text-align-last#Browser_compatibility.

Works in all browsers except for Safari (both Mac and iOS), including Internet Explorer.

Also in Internet Explorer, only works with `text-align: justify` (no other values of `text-align`) and `start` and `end` are not supported.

### What are MVP and MVC and what is the difference?

I have used both MVP and MVC and although we as developers tend to focus on the technical differences of both patterns the point for MVP in IMHO is much more related to ease of adoption than anything else.

If I’m working in a team that already as a good background on web forms development style it’s far easier to introduce MVP than MVC. I would say that MVP in this scenario is a quick win.

My experience tells me that moving a team from web forms to MVP and then from MVP to MVC is relatively easy; moving from web forms to MVC is more difficult.

I leave here a link to a series of articles a friend of mine has published about MVP and MVC.

http://www.qsoft.be/post/Building-the-MVP-StoreFront-Gutthrie-style.aspx

### Show special characters in Unix while using 'less' Command

For `less` use `-u` to display carriage returns (`^M`) and backspaces (`^H`), or `-U` to show the previous and tabs (`^I`) for example:

``````\$ awk 'BEGIN{print "foo\bbar\tbaz\r\n"}' | less -U
foo^Hbar^Ibaz^M

(END)
``````

Without the `-U` switch the output would be:

``````fobar   baz

(END)
``````

See `man less` for more exact description on the features.

### Get unique values from arraylist in java

``````    public static List getUniqueValues(List input) {
}
``````

dont forget to implement your equals method first

### Android - Center TextView Horizontally in LinearLayout

Use `android:gravity="center"` in `TextView` instead of `layout_gravity`.

### Scanner doesn't read whole sentence - difference between next() and nextLine() of scanner class

We can easily done using scan.nextLine .It will read the rest of the input till the end. Then assign it to your variable. Entire sentence can be printed easily . Here is the example for your better understanding.

``````    String s = "HackerRank ";

Scanner scan = new Scanner(System.in);

String s2;

scan.nextLine(); // read the rest of the line of input (newline character after the double token).
s2 = scan.nextLine();

/* Concatenate and print the String variables on a new line integer variables on a new line;

System.out.println(s + s2);

scan.close();
``````

} }

### javascript remove "disabled" attribute from html input

Set the element's `disabled` property to false:

``````document.getElementById('my-input-id').disabled = false;
``````

If you're using jQuery, the equivalent would be:

``````\$('#my-input-id').prop('disabled', false);
``````

For several input fields, you may access them by class instead:

``````var inputs = document.getElementsByClassName('my-input-class');
for(var i = 0; i < inputs.length; i++) {
inputs[i].disabled = false;
}
``````

Where `document` could be replaced with a form, for instance, to find only the elements inside that form. You could also use `getElementsByTagName('input')` to get all input elements. In your `for` iteration, you'd then have to check that `inputs[i].type == 'text'`.

### Unclosed Character Literal error

String y = "hello";

would work (note the double quotes).

char y = 'h'; this will work for chars (note the single quotes)

but the type is the key: '' (single quotes) for one char, "" (double quotes) for string.

### How to Install Windows Phone 8 SDK on Windows 7

Here is a link from developer.nokia.com wiki pages, which explains how to install Windows Phone 8 SDK on a Virtual Machine with Working Emulator

AFAIK, it is not possible to directly install WP8 SDK in Windows 7, because WP8 sdk is VS 2012 supported and also its emulator works on a Hyper-V (which is integrated into the Windows 8).

### How to automatically convert strongly typed enum into int?

#### TLDR;

There are no implicit conversions from the values of a scoped enumerator [AKA: "strong enum"] to integral types, although `static_cast` may be used to obtain the numeric value of the enumerator.

Source: https://en.cppreference.com/w/cpp/language/enum --> under the section "Scoped enumerations".

#### Going further

In C++ there are two types of enums:

1. "regular", "weak", "weakly typed", or "C-style" enums, and
2. "scoped", "strong", "strongly typed", "enum class", or "C++-style" enums.

"Scoped" enums, or "strong" enums, give two additional "features" beyond what "regular" enums give you. Scoped enums:

1. don't allow implicit casting from the enum type to an integer type (so you can't do what you want to do implicitly!), and
2. they "scope" the enum so that you have to access the enum through its enum type name.

Example of an enum class:

``````// enum class (AKA: "strong" or "scoped" enum)
enum class my_enum
{
A = 0,
B,
C,
};

my_enum e = my_enum::A; // scoped through `my_enum::`
e = my_enum::B;

// NOT ALLOWED!:
//   error: cannot convert ‘my_enum’ to ‘int’ in initialization
// int i = e;

// But this works fine:
int i = static_cast<int>(e);
``````

The first "feature" may actually be something you don't want, in which case you just need to use a regular C-style enum instead! And the nice thing is: you can still "scope" or "namespace" the enum, as has been done in C for decades, by simply prepending its name with the enum type name, like this:

Example of a regular enum:

``````// regular enum (AKA: "weak" or "C-style" enum)
enum my_enum
{
MY_ENUM_A = 0,
MY_ENUM_B,
MY_ENUM_C,
};

my_enum e = MY_ENUM_A; // scoped through `MY_ENUM_`
e = MY_ENUM_B;

// This works fine!
int i = e;
``````

Notice you still get the benefit of "scoping" simply by adding the `MY_ENUM_` "scope" to the front of each enum!

Test the above code here: https://onlinegdb.com/SJQ7uthcP.

### Sum a list of numbers in Python

This question has been answered here

``````a = [1,2,3,4]
sum(a)
``````

sum(a) returns 10

### Check if option is selected with jQuery, if not select a default

You guys are doing way too much for selecting. Just select by value:

``````\$("#mySelect").val( 3 );
``````

### XAMPP - Port 80 in use by "Unable to open process" with PID 4! 12

In windows 10, to free up port 80:

in my case, I open "Services" from "Search Windows" (on the left corner on screen), then stop all of SQL server services MSSQLSERVER and it works again

### How do I specify "close existing connections" in sql script

You can disconnect everyone and roll back their transactions with:

``````alter database [MyDatbase] set single_user with rollback immediate
``````

After that, you can safely drop the database :)

### Verifying that a string contains only letters in C#

Recently, I made performance improvements for a function that checks letters in a string with the help of this page.

I figured out that the Solutions with regex are 30 times slower than the ones with the Char.IsLetterOrDigit check.

We were not sure that those Letters or Digits include and we were in need of only Latin characters so implemented our function based on the decompiled version of Char.IsLetterOrDigit function.

Here is our solution:

``````internal static bool CheckAllowedChars(char uc)
{
switch (uc)
{
case '-':
case '.':
case 'A':
case 'B':
case 'C':
case 'D':
case 'E':
case 'F':
case 'G':
case 'H':
case 'I':
case 'J':
case 'K':
case 'L':
case 'M':
case 'N':
case 'O':
case 'P':
case 'Q':
case 'R':
case 'S':
case 'T':
case 'U':
case 'V':
case 'W':
case 'X':
case 'Y':
case 'Z':
case '0':
case '1':
case '2':
case '3':
case '4':
case '5':
case '6':
case '7':
case '8':
case '9':
return true;
default:
return false;
}
}
``````

And the usage is like this:

`````` if( logicalId.All(c => CheckAllowedChars(c)))
{ // Do your stuff here.. }
``````

### What is a "callback" in C and how are they implemented?

Here is an example of callbacks in C.

Let's say you want to write some code that allows registering callbacks to be called when some event occurs.

First define the type of function used for the callback:

``````typedef void (*event_cb_t)(const struct event *evt, void *userdata);
``````

Now, define a function that is used to register a callback:

``````int event_cb_register(event_cb_t cb, void *userdata);
``````

This is what code would look like that registers a callback:

``````static void my_event_cb(const struct event *evt, void *data)
{
/* do stuff and things with the event */
}

...
event_cb_register(my_event_cb, &my_custom_data);
...
``````

In the internals of the event dispatcher, the callback may be stored in a struct that looks something like this:

``````struct event_cb {
event_cb_t cb;
void *data;
};
``````

This is what the code looks like that executes a callback.

``````struct event_cb *callback;

...

/* Get the event_cb that you want to execute */

callback->cb(event, callback->data);
``````

### Is there a way to include commas in CSV columns without breaking the formatting?

I faced the same problem and quoting the `,` did not help. Eventually, I replaced the `,` with `+`, finished the processing, saved the output into an outfile and replaced the `+` with `,`. This may seem ugly but it worked for me.

### Vue.js toggle class on click

for nuxt link and bootstrap v5 navbar-nav, I used a child component

``````             <nuxt-link
to=""
:title="item.title"
aria-current="page"
role="button"
data-toggle="dropdown"
>
{{ item.label }}

data() {
return {
}
},
``````

### java.lang.RuntimeException: Failure delivering result ResultInfo{who=null, request=1888, result=0, data=null} to activity

Adding this first conditional should work:

``````protected void onActivityResult(int requestCode, int resultCode, Intent data) {
if(resultCode != RESULT_CANCELED){
if (requestCode == CAMERA_REQUEST) {
Bitmap photo = (Bitmap) data.getExtras().get("data");
imageView.setImageBitmap(photo);
}
}
}
``````

### How can I calculate an md5 checksum of a directory?

For the sake of completeness, there's md5deep(1); it's not directly applicable due to *.py filter requirement but should do fine together with find(1).

### How to use an environment variable inside a quoted string in Bash

The following script works for me for multiple values of `\$COLUMNS`. I wonder if you are not setting `COLUMNS` prior to this call?

``````#!/bin/bash
COLUMNS=30
svn diff \$@ --diff-cmd /usr/bin/diff -x "-y -w -p -W \$COLUMNS"
``````

Can you echo `\$COLUMNS` inside your script to see if it set correctly?

### How large should my recv buffer be when calling recv in the socket library

16kb is about right; if you're using gigabit ethernet, each packet could be 9kb in size.

### How to find the logs on android studio?

In windows version

you can find the log in the bottom of the IDE, click the "Gradle Console", and then choose the "Android Monitor". You will see a Droplistbox control which shows "Verbose" as a default value.

If you use `log.v()` . Verbose option is okay. if you use `log.d()`, just change it to Debug.

So when you run your emulator, you can catch your log from this window.

### How to initialize std::vector from C-style array?

`std::vector<double>::assign` is the way to go, because it's little code. But how does it work, actually? Doesnt't it resize and then copy? In MS implementation of STL I am using it does exactly so.

I'm afraid there's no faster way to implement (re)initializing your `std::vector`.

### How to do "If Clicked Else .."

The way to do it would be with a boolean at a higher scope:

``````var hasBeenClicked = false;
jQuery('#id').click(function () {
hasBeenClicked = true;
});

if (hasBeenClicked) {
// The link has been clicked.
} else {
// The link has not been clicked.
}
``````

### In DB2 Display a table's definition

Right-click the table in DB2 Control Center and chose Generate DDL... That will give you everything you need and more.

### SQL "IF", "BEGIN", "END", "END IF"?

If this is MS Sql Server then what you have should work fine... In fact, technically, you don;t need the Begin & End at all, snce there's only one statement in the begin-End Block... (I assume @Classes is a table variable ?)

``````If @Term = 3
INSERT INTO @Classes
SELECT                  XXXXXX
FROM XXXX blah blah blah
-- -----------------------------

-- This next should always run, if the first code did not throw an exception...
INSERT INTO @Classes
SELECT XXXXXXXX
FROM XXXXXX (more code)
``````

### ORACLE: Updating multiple columns at once

I guess the issue here is that you are updating INV_DISCOUNT and the INV_TOTAL uses the INV_DISCOUNT. so that is the issue here. You can use returning clause of update statement to use the new INV_DISCOUNT and use it to update INV_TOTAL.

this is a generic example let me know if this explains the point i mentioned

``````CREATE OR REPLACE PROCEDURE SingleRowUpdateReturn
IS
empName VARCHAR2(50);
empSalary NUMBER(7,2);
BEGIN
UPDATE emp
SET sal = sal + 1000
WHERE empno = 7499
RETURNING ename, sal
INTO empName, empSalary;

DBMS_OUTPUT.put_line('Name of Employee: ' || empName);
DBMS_OUTPUT.put_line('New Salary: ' || empSalary);
END;
``````

### CMake not able to find OpenSSL library

I had the same problem (openssl) and this worked for me on Ubuntu 14.04.1 LTS. The solution is the same up to Ubuntu 18.04 (tested).

``````sudo apt-get install libssl-dev
``````

### How to embed a PDF?

I recommend using PDFObject for PDF plugin detection.

This will only allow you to display alternate content if the user's browser isn't capable of displaying the PDF directly though. For example, the PDF will display fine in Chrome for most users, but they will need a plugin like Adobe Reader installed if they're using Firefox or Internet Explorer.

### Generating statistics from Git repository

Beside GitStats (git history statistics generator) mentioned by xyld, written in Python and requiring Gnuplot for graphs, there is also

### AttributeError: 'dict' object has no attribute 'predictors'

``````#Try without dot notation
sample_dict = {'name': 'John', 'age': 29}
print(sample_dict['name']) # John
print(sample_dict['age']) # 29
``````

### Import existing Gradle Git project into Eclipse

You can do the following steps:

1. Install the Buildship Gradle Integration using the Eclipse Marketplace. Simply type Buildship and click on search item. Now click on Install.

2. Click on File -> Import ? Existing Gradle Project.

3. Navigate to project root directory.

Might be it will take some time for the first time to import Gradle project. So please be patient on it.

Here is the example in which you can easily find the way to use Post,GET method and use the same way to add other curd operations as well..

``````#libraries to include

import os
from app import app, mongo
import logger
ROOT_PATH = os.environ.get('ROOT_PATH')<br>
@app.route('/get/questions/', methods=['GET', 'POST','DELETE', 'PATCH'])
def question():
# request.args is to get urls arguments

if request.method == 'GET':
start = request.args.get('start', default=0, type=int)
limit_url = request.args.get('limit', default=20, type=int)
questions = mongo.db.questions.find().limit(limit_url).skip(start);
data = [doc for doc in questions]
return jsonify(isError= False,
message= "Success",
statusCode= 200,
data= data), 200

# request.form to get form parameter

if request.method == 'POST':
average_time = request.form.get('average_time')
choices = request.form.get('choices')
created_by = request.form.get('created_by')
difficulty_level = request.form.get('difficulty_level')
question = request.form.get('question')
topics = request.form.get('topics')

##Do something like insert in DB or Render somewhere etc. it's up to you....... :)
``````

### How to compare two date values with jQuery

If you are also using jQuery ui, in particular datepicker, you can use `\$.datepicker.parseDate(format, string)` to turn your date strings into a JavaScript `Date` object, which you can then compare using the standard `<` and `>`

### How to use gitignore command in git

on my mac i found this file `.gitignore_global` ..it was in my home directory hidden so do a `ls -altr` to see it.

I added eclipse files i wanted git to ignore. the contents looks like this:

`````` *~
.DS_Store
.project
.settings
.classpath
``````

### How to Create a circular progressbar in Android which rotates on it?

With the Material Components Library you can use the `CircularProgressIndicator`:

Something like:

``````<com.google.android.material.progressindicator.CircularProgressIndicator
app:indicatorColor="@color/...."
app:trackColor="@color/...."
``````

You can use these attributes:

• `circularRadius`: defines the radius of the circular progress indicator
• `trackColor`: the color used for the progress track. If not defined, it will be set to the `indicatorColor` and apply the `android:disabledAlpha` from the theme.
• `indicatorColor`: the single color used for the indicator in determinate/indeterminate mode. By default it uses theme primary color

Use `progressIndicator.setProgressCompat((int) value, true);` to update the value in the indicator.

Note: it requires at least the version `1.3.0-alpha04`.

### PostgreSQL INSERT ON CONFLICT UPDATE (upsert) use all excluded values

Postgres hasn't implemented an equivalent to `INSERT OR REPLACE`. From the `ON CONFLICT` docs (emphasis mine):

It can be either DO NOTHING, or a DO UPDATE clause specifying the exact details of the UPDATE action to be performed in case of a conflict.

Though it doesn't give you shorthand for replacement, `ON CONFLICT DO UPDATE` applies more generally, since it lets you set new values based on preexisting data. For example:

``````INSERT INTO users (id, level)
VALUES (1, 0)
ON CONFLICT (id) DO UPDATE
SET level = users.level + 1;
``````

### Setting a timeout for socket operations

You don't set a timeout for the socket, you set a timeout for the operations you perform on that socket.

For example `socket.connect(otherAddress, timeout)`

Or `socket.setSoTimeout(timeout)` for setting a timeout on `read()` operations.

### How to check radio button is checked using JQuery?

``````<input type="radio" id="radio_1" class="radioButtons" name="radioButton" value="1">
``````

to check on click,

``````\$('.radioButtons').click(function(){
//logic here
}
});
``````

### Converting a string to JSON object

``````var obj = jQuery.parseJSON('{"name":"John"}');
``````

http://api.jquery.com/jQuery.parseJSON/

### How do you follow an HTTP Redirect in Node.js?

Possibly a little bit of a necromancing post here, but...

here's a function that follows up to 10 redirects, and detects infinite redirect loops. also parses result into JSON

Note - uses a callback helper (shown at the end of this post)

( TLDR; full working demo in context here or remixed-version here)

``````function getJSON(url,cb){

var callback=errBack(cb);
//var callback=errBack(cb,undefined,false);//replace previous line with this to turn off logging

if (typeof url!=='string') {
return callback.error("getJSON:expecting url as string");
}

if (typeof cb!=='function') {
return callback.error("getJSON:expecting cb as function");
}

var redirs = [url],
fetch = function(u){
callback.info("hitting:"+u);
https.get(u, function(res){
var body = [];
callback.info({statusCode:res.statusCode});
if ([301,302].indexOf(res.statusCode)>=0) {
if (redirs.length>10) {
return callback.error("excessive 301/302 redirects detected");
} else {
} else {
return callback.error("301/302 redirect loop detected");
}
}
} else {
res.on('data', function(chunk){
body.push(chunk);
callback.info({onData:{chunkSize:chunk.length,chunks:body.length}});
});
res.on('end', function(){
try {
// convert to a single buffer
var json = Buffer.concat(body);
console.info({onEnd:{chunks:body.length,bodyLength:body.length}});

// parse the buffer as json
return callback.result(JSON.parse(json),json);
} catch (err) {

console.error("exception in getJSON.fetch:",err.message||err);

if (json.length>32) {
console.error("json==>|"+json.toString('utf-8').substr(0,32)+"|<=== ... (+"+(json.length-32)+" more bytes of json)");
} else {
console.error("json==>|"+json.toString('utf-8')+"|<=== json");
}

return callback.error(err,undefined,json);
}
});
}
});
};
fetch(url);
}
``````

Note - uses a callback helper (shown below)

you can paste this into the node console and it should run as is.

( or for full working demo in context see here )

``````var

fs      = require('fs'),
https   = require('https');

function errBack (cb,THIS,logger) {

var
self,
EB=function(fn,r,e){
if (logger===false) {
fn.log=fn.info=fn.warn=fn.errlog=function(){};
} else {
fn.log        = logger?logger.log   : console.log.bind(console);
fn.info       = logger?logger.info  : console.info.bind(console);
fn.warn       = logger?logger.warn  : console.warn.bind(console);
fn.errlog     = logger?logger.error : console.error.bind(console);
}
fn.result=r;
fn.error=e;
return (self=fn);
};

if (typeof cb==='function') {
return EB(

logger===false // optimization when not logging - don't log errors
?   function(err){
if (err) {
cb (err);
return true;
}
return false;
}

:  function(err){
if (err) {
self.errlog(err);
cb (err);
return true;
}
return false;
},

function () {
return cb.apply (THIS,Array.prototype.concat.apply([undefined],arguments));
},
function (err) {
return cb.apply (THIS,Array.prototype.concat.apply([typeof err==='string'?new Error(err):err],arguments));
}
);
} else {

return EB(

function(err){
if (err) {
if (typeof err ==='object' && err instanceof Error) {
throw err;
} else {
throw new Error(err);
}
return true;//redundant due to throw, but anyway.
}
return false;
},

logger===false
? self.log //optimization :resolves to noop when logger==false
: function () {
self.info("ignoring returned arguments:",Array.prototype.concat.apply([],arguments));
},

function (err) {
throw typeof err==='string'?new Error(err):err;
}
);
}
}

function getJSON(url,cb){

var callback=errBack(cb);

if (typeof url!=='string') {
return callback.error("getJSON:expecting url as string");
}

if (typeof cb!=='function') {
return callback.error("getJSON:expecting cb as function");
}

var redirs = [url],
fetch = function(u){
callback.info("hitting:"+u);
https.get(u, function(res){
var body = [];
callback.info({statusCode:res.statusCode});
if ([301,302].indexOf(res.statusCode)>=0) {
if (redirs.length>10) {
return callback.error("excessive 302 redirects detected");
} else {
} else {
return callback.error("302 redirect loop detected");
}
}
} else {
res.on('data', function(chunk){
body.push(chunk);
console.info({onData:{chunkSize:chunk.length,chunks:body.length}});
});
res.on('end', function(){
try {
// convert to a single buffer
var json = Buffer.concat(body);
callback.info({onEnd:{chunks:body.length,bodyLength:body.length}});

// parse the buffer as json
return callback.result(JSON.parse(json),json);
} catch (err) {
// read with "bypass refetch" option
console.error("exception in getJSON.fetch:",err.message||err);

if (json.length>32) {
console.error("json==>|"+json.toString('utf-8').substr(0,32)+"|<=== ... (+"+(json.length-32)+" more bytes of json)");
} else {
console.error("json==>|"+json.toString('utf-8')+"|<=== json");
}

return callback.error(err,undefined,json);
}
});
}
});
};
fetch(url);
}

var TLD_url = "https://gitcdn.xyz/repo/umpirsky/tld-list/master/data/en/tld.json";
var TLD_cache = "./tld.json";
var TLD_refresh_msec = 15 * 24 * 60 * 60 * 1000;
var TLD_last_msec;
var TLD_default_filter=function(dom){return dom.substr(0,3)!="xn-"};

function getTLDs(cb,filter_func){

if (typeof cb!=='function') return TLDs;

var
CB_WRAP=function(tlds){
return cb(
filter_func===false
? cb(tlds)
: tlds.filter(
typeof filter_func==='function'
? filter_func
: TLD_default_filter)
);
},
check_mtime = function(mtime) {
if (Date.now()-mtime > TLD_refresh_msec) {
return fetch();
}
if (TLDs) return CB_WRAP (TLDs);
};

fetch = function(){

getJSON(TLD_url,function(err,data){
if (err) {
console.log("exception in getTLDs.fetch:",err.message||err);
} else {
TLDs=Object.keys(data);

fs.writeFile(TLD_cache,JSON.stringify(TLDs),function(err){
if (err) {
// ignore save error, we have the data
CB_WRAP(TLDs);
} else {
// get mmtime for the file we just made
fs.stat(TLD_cache,function(err,stats){
if (!err && stats) {
TLD_last_msec = stats.mtimeMs;
}
CB_WRAP(TLDs);
});
}
});
}
});
};

try {
if (err) {

if (bypassFetch) {
// after a http errror, we fallback to hardcoded basic list of tlds
// if the disk file is not readable

throw err;
}
// if the disk read failed, get the data from the CDN server instead
return fetch();
}

TLDs=JSON.parse(json);
if (bypassFetch) {
// we need to update stats here as fetch called us directly
// instead of being called by check_mtime
return fs.stat(TLD_cache,function(err,stats){
if (err) return fetch();
TLD_last_msec =stats.mtimeMs;
return CB_WRAP(TLDs);
});
}

} catch (e){
// after JSON error, if we aren't in an http fail situation, refetch from cdn server
if (!bypassFetch) {
return fetch();
}

// after a http,disk,or json parse error, we fallback to hardcoded basic list of tlds

TLDs=TLDs_fallback;
}

return CB_WRAP(TLDs);
});
};

if (TLD_last_msec) {
return check_mtime(TLD_last_msec);
} else {
fs.stat(TLD_cache,function(err,stats){
if (err) return fetch();
TLD_last_msec =stats.mtimeMs;
return check_mtime(TLD_last_msec);
});
}
}

getTLDs(console.log.bind(console));
``````

### What is a good regular expression to match a URL?

``````(https?:\/\/(?:www\.|(?!www))[a-zA-Z0-9][a-zA-Z0-9-]+[a-zA-Z0-9]\.[^\s]{2,}|www\.[a-zA-Z0-9][a-zA-Z0-9-]+[a-zA-Z0-9]\.[^\s]{2,}|https?:\/\/(?:www\.|(?!www))[a-zA-Z0-9]+\.[^\s]{2,}|www\.[a-zA-Z0-9]+\.[^\s]{2,})
``````

Will match the following cases

• `http://www.foufos.gr`
• `https://www.foufos.gr`
• `http://foufos.gr`
• `http://www.foufos.gr/kino`
• `http://werer.gr`
• `www.foufos.gr`
• `www.mp3.com`
• `www.t.co`
• `http://t.co`
• `http://www.t.co`
• `https://www.t.co`
• `www.aa.com`
• `http://aa.com`
• `http://www.aa.com`
• `https://www.aa.com`

Will NOT match the following

• `www.foufos`
• `www.foufos-.gr`
• `www.-foufos.gr`
• `foufos.gr`
• `http://www.foufos`
• `http://foufos`
• `www.mp3#.com`

_x000D_
_x000D_
``````var expression = /(https?:\/\/(?:www\.|(?!www))[a-zA-Z0-9][a-zA-Z0-9-]+[a-zA-Z0-9]\.[^\s]{2,}|www\.[a-zA-Z0-9][a-zA-Z0-9-]+[a-zA-Z0-9]\.[^\s]{2,}|https?:\/\/(?:www\.|(?!www))[a-zA-Z0-9]+\.[^\s]{2,}|www\.[a-zA-Z0-9]+\.[^\s]{2,})/gi;_x000D_
var regex = new RegExp(expression);_x000D_
_x000D_
var check = [_x000D_
'http://www.foufos.gr',_x000D_
'https://www.foufos.gr',_x000D_
'http://foufos.gr',_x000D_
'http://www.foufos.gr/kino',_x000D_
'http://werer.gr',_x000D_
'www.foufos.gr',_x000D_
'www.mp3.com',_x000D_
'www.t.co',_x000D_
'http://t.co',_x000D_
'http://www.t.co',_x000D_
'https://www.t.co',_x000D_
'www.aa.com',_x000D_
'http://aa.com',_x000D_
'http://www.aa.com',_x000D_
'https://www.aa.com',_x000D_
'www.foufos',_x000D_
'www.foufos-.gr',_x000D_
'www.-foufos.gr',_x000D_
'foufos.gr',_x000D_
'http://www.foufos',_x000D_
'http://foufos',_x000D_
'www.mp3#.com'_x000D_
];_x000D_
_x000D_
check.forEach(function(entry) {_x000D_
if (entry.match(regex)) {_x000D_
\$("#output").append( "<div >Success: " + entry + "</div>" );_x000D_
} else {_x000D_
\$("#output").append( "<div>Fail: " + entry + "</div>" );_x000D_
}_x000D_
});``````
_x000D_
``````<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>_x000D_
<div id="output"></div>``````
_x000D_
_x000D_
_x000D_

Check it in rubular - NEW version

Check it in rubular - old version

### Is there a standard sign function (signum, sgn) in C/C++?

No, it doesn't exist in c++, like in matlab. I use a macro in my programs for this.

``````#define sign(a) ( ( (a) < 0 )  ?  -1   : ( (a) > 0 ) )
``````

### Format number as percent in MS SQL Server

took the challenge to solve this issue. comment number 5 (M.Ali) asked for --"The required answer is 97.36 % (not 0.97 %) .." so for that i'm attaching a photo who compare between post number 3 (sqluser) to my solution. (i'm using the postgre_sql on a mac)

### How to compare timestamp dates with date-only parameter in MySQL?

Use

``````SELECT * FROM table WHERE DATE(2012-05-05 00:00:00) = '2012-05-05'
``````

### SQL Server - An expression of non-boolean type specified in a context where a condition is expected, near 'RETURN'

An expression of non-boolean type specified in a context where a condition is expected

I also got this error when I forgot to add ON condition when specifying my join clause.

### How to set combobox default value?

You can do something like this:

``````    public myform()
{
InitializeComponent(); // this will be called in ComboBox ComboBox = new System.Windows.Forms.ComboBox();
}

private void Form1_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'myDataSet.someTable' table. You can move, or remove it, as needed.
comboBox1.SelectedItem = null;
comboBox1.SelectedText = "--select--";
}
``````

### How to check if an integer is within a range?

I don't think you'll get a better way than your function.

It is clean, easy to follow and understand, and returns the result of the condition (no `return (...) ? true : false` mess).

### A Simple, 2d cross-platform graphics library for c or c++?

[In no particular order.] However, if you have any other requirements, let us know. BTW: I am not just posting results of a Google query here, I have used all of these (and SDL -- wrote my first few games in SDL :) and I'd say without a set of requirements, it's very difficult to choose among the ones listed.

### ImageMagick security policy 'PDF' blocking conversion

For me on my archlinux system the line was already uncommented. I had to replace "none" by "read | write " to make it work.

### Query to get only numbers from a string

First create this `UDF`

``````CREATE FUNCTION dbo.udf_GetNumeric
(
@strAlphaNumeric VARCHAR(256)
)
RETURNS VARCHAR(256)
AS
BEGIN
DECLARE @intAlpha INT
SET @intAlpha = PATINDEX('%[^0-9]%', @strAlphaNumeric)
BEGIN
WHILE @intAlpha > 0
BEGIN
SET @strAlphaNumeric = STUFF(@strAlphaNumeric, @intAlpha, 1, '' )
SET @intAlpha = PATINDEX('%[^0-9]%', @strAlphaNumeric )
END
END
RETURN ISNULL(@strAlphaNumeric,0)
END
GO
``````

Now use the `function` as

``````SELECT dbo.udf_GetNumeric(column_name)
from table_name
``````

SQL FIDDLE

I hope this solved your problem.

Reference

### How can I indent multiple lines in Xcode?

Since I didn't see an update to this question for the current version of Xcode, I thought I'd add that in Xcode 9.3, Tab works for indenting selected line(s) of text as well as moving from one autocomplete field to another.

### TypeError: \$(...).modal is not a function with bootstrap Modal

For me, I had `//= require jquery` after `//= require bootstrap`. Once I moved jquery before bootstrap, everything worked.

### Counting unique / distinct values by group in a data frame

This should do the trick:

``````ddply(myvec,~name,summarise,number_of_distinct_orders=length(unique(order_no)))
``````

This requires package plyr.

### Handling onchange event in HTML.DropDownList Razor MVC

#### Description

You can use another overload of the `DropDownList` method. Pick the one you need and pass in a object with your html attributes.

#### Sample

``````@Html.DropDownList("CategoryID", null, new { @onchange="location = this.value;" })
``````

### AngularJS : Difference between the \$observe and \$watch methods

\$observe() is a method on the Attributes object, and as such, it can only be used to observe/watch the value change of a DOM attribute. It is only used/called inside directives. Use \$observe when you need to observe/watch a DOM attribute that contains interpolation (i.e., {{}}'s).
E.g., `attr1="Name: {{name}}"`, then in a directive: `attrs.\$observe('attr1', ...)`.
(If you try `scope.\$watch(attrs.attr1, ...)` it won't work because of the {{}}s -- you'll get `undefined`.) Use \$watch for everything else.

\$watch() is more complicated. It can observe/watch an "expression", where the expression can be either a function or a string. If the expression is a string, it is \$parse'd (i.e., evaluated as an Angular expression) into a function. (It is this function that is called every digest cycle.) The string expression can not contain {{}}'s. \$watch is a method on the Scope object, so it can be used/called wherever you have access to a scope object, hence in

• a controller -- any controller -- one created via ng-view, ng-controller, or a directive controller

Because strings are evaluated as Angular expressions, \$watch is often used when you want to observe/watch a model/scope property. E.g., `attr1="myModel.some_prop"`, then in a controller or link function: `scope.\$watch('myModel.some_prop', ...)` or `scope.\$watch(attrs.attr1, ...)` (or `scope.\$watch(attrs['attr1'], ...)`).
(If you try `attrs.\$observe('attr1')` you'll get the string `myModel.some_prop`, which is probably not what you want.)

As discussed in comments on @PrimosK's answer, all \$observes and \$watches are checked every digest cycle.

Directives with isolate scopes are more complicated. If the '@' syntax is used, you can \$observe or \$watch a DOM attribute that contains interpolation (i.e., {{}}'s). (The reason it works with \$watch is because the '@' syntax does the interpolation for us, hence \$watch sees a string without {{}}'s.) To make it easier to remember which to use when, I suggest using \$observe for this case also.

To help test all of this, I wrote a Plunker that defines two directives. One (`d1`) does not create a new scope, the other (`d2`) creates an isolate scope. Each directive has the same six attributes. Each attribute is both \$observe'd and \$watch'ed.

``````<div d1 attr1="{{prop1}}-test" attr2="prop2" attr3="33" attr4="'a_string'"
attr5="a_string" attr6="{{1+aNumber}}"></div>
``````

Look at the console log to see the differences between \$observe and \$watch in the linking function. Then click the link and see which \$observes and \$watches are triggered by the property changes made by the click handler.

Notice that when the link function runs, any attributes that contain {{}}'s are not evaluated yet (so if you try to examine the attributes, you'll get `undefined`). The only way to see the interpolated values is to use \$observe (or \$watch if using an isolate scope with '@'). Therefore, getting the values of these attributes is an asynchronous operation. (And this is why we need the \$observe and \$watch functions.)

Sometimes you don't need \$observe or \$watch. E.g., if your attribute contains a number or a boolean (not a string), just evaluate it once: `attr1="22"`, then in, say, your linking function: `var count = scope.\$eval(attrs.attr1)`. If it is just a constant string – `attr1="my string"` – then just use `attrs.attr1` in your directive (no need for \$eval()).

### href around input type submit

Why would you want to put a submit button inside an anchor? You are either trying to submit a form or go to a different page. Which one is it?

Either submit the form:

``````<input type="submit" class="button_active" value="1" />
``````

Or go to another page:

``````<input type="button" class="button_active" onclick="location.href='1.html';" />
``````

### Mipmaps vs. drawable folders

The mipmap folders are for placing your app/launcher icons (which are shown on the homescreen) in only. Any other drawable assets you use should be placed in the relevant drawable folders as before.

It’s best practice to place your app icons in mipmap- folders (not the drawable- folders) because they are used at resolutions different from the device’s current density.

When referencing the mipmap- folders ensure you are using the following reference:

``````android:icon="@mipmap/ic_launcher"
``````

The reason they use a different density is that some launchers actually display the icons larger than they were intended. Because of this, they use the next size up.

### Mercurial — revert back to old version and continue from there

The answers above were most useful and I learned a lot. However, for my needs the succinct answer is:

``````hg revert --all --rev \${1}

hg commit -m "Restoring branch \${1} as default"
``````

where `\${1}` is the number of the revision or the name of the branch. These two lines are actually part of a bash script, but they work fine on their own if you want to do it manually.

This is useful if you need to add a hot fix to a release branch, but need to build from default (until we get our CI tools right and able to build from branches and later do away with release branches as well).

### How to change Status Bar text color in iOS

The easiest way to do this from Xcode (without any coding) is:

• Add `View controller-based status bar appearance` to your Info.plist and set the value to `NO`.
• Now, go to your project target and inside `Deployment Info` you'll find an option for `Status Bar Style`. Set the value of this option to `Light`.

You'll have the `White` status bar.

### How do you get/set media volume (not ringtone volume) in Android?

If you happen to have a volume bar that you want to adjust –similar to what you see on iPhone's iPod app– here's how.

``````    @Override
public boolean onKeyDown(int keyCode, KeyEvent event) {

switch (keyCode) {
case KeyEvent.KEYCODE_VOLUME_UP:
//Raise the Volume Bar on the Screen
volumeControl.setProgress( audioManager.getStreamVolume(AudioManager.STREAM_MUSIC)
return true;
case KeyEvent.KEYCODE_VOLUME_DOWN:
//Lower the VOlume Bar on the Screen
volumeControl.setProgress(audioManager
.getStreamVolume(AudioManager.STREAM_MUSIC)
return true;
default:
return false;
}
``````

### css divide width 100% to 3 column

Using this fiddle, you can play around with the `width` of each div. I've tried in both Chrome and IE and I notice a difference in width between `33%` and `33.3%`. I also notice a very small difference between `33.3%` and `33.33%`. I don't notice any difference further than this.

The difference between `33.33%` and the theoretical `33.333...%` is a mere `0.00333...%`.

For arguments sake, say my screen width is `1960px`; a fairly high but common resolution. The difference between these two widths is still only `0.065333...px`.

So, further than two decimal places, the difference in precision is negligible.

### How to build a Debian/Ubuntu package from source?

How can I check if I have listed all the dependencies correctly?

The `pbuilder` is an excellent tool for checking both build dependencies and dependencies by setting up a clean base system within a chroot environment. By compiling the package within pbuilder, you can easily check the build dependencies, and by testing it within a pbuilder environment, you can check the dependencies.

### What are the differences between Deferred, Promise and Future in JavaScript?

These answers, including the selected answer, are good for introducing promises conceptually, but lacking in specifics of what exactly the differences are in the terminology that arises when using libraries implementing them (and there are important differences).

Since it is still an evolving spec, the answer currently comes from attempting to survey both references (like wikipedia) and implementations (like jQuery):

• Deferred: Never described in popular references, 1 2 3 4 but commonly used by implementations as the arbiter of promise resolution (implementing `resolve` and `reject`). 5 6 7

Sometimes deferreds are also promises (implementing `then`), 5 6 other times it's seen as more pure to have the Deferred only capable of resolution, and forcing the user to access the promise for using `then`. 7

• Promise: The most all-encompasing word for the strategy under discussion.

A proxy object storing the result of a target function whose synchronicity we would like to abstract, plus exposing a `then` function accepting another target function and returning a new promise. 2

Example from CommonJS:

``````> asyncComputeTheAnswerToEverything()
.then(printResult);
44
``````

Always described in popular references, although never specified as to whose responsibility resolution falls to. 1 2 3 4

Always present in popular implementations, and never given resolution abilites. 5 6 7

• Future: a seemingly deprecated term found in some popular references 1 and at least one popular implementation, 8 but seemingly being phased out of discussion in preference for the term 'promise' 3 and not always mentioned in popular introductions to the topic. 9

However, at least one library uses the term generically for abstracting synchronicity and error handling, while not providing `then` functionality. 10 It's unclear if avoiding the term 'promise' was intentional, but probably a good choice since promises are built around 'thenables.' 2

### How to use goto statement correctly

The Java keyword list specifies the goto keyword, but it is marked as "not used".

This was probably done in case it were to be added to a later version of Java.

If goto weren't on the list, and it were added to the language later on, existing code that used the word goto as an identifier (variable name, method name, etcetera) would break. But because goto is a keyword, such code will not even compile in the present, and it remains possible to make it actually do something later on, without breaking existing code.

### converting Java bitmap to byte array

Your byte array is too small. Each pixel takes up 4 bytes, not just 1, so multiply your size * 4 so that the array is big enough.

### How to read specific lines from a file (by line number)?

``````f=open('filename')
print lines[25]
print lines[29]
``````

or:

``````lines=[25, 29]
i=0
f=open('filename')
for line in f:
if i in lines:
print i
i+=1
``````

There is a more elegant solution for extracting many lines: linecache (courtesy of "python: how to jump to a particular line in a huge text file?", a previous stackoverflow.com question).

Quoting the python documentation linked above:

``````>>> import linecache
>>> linecache.getline('/etc/passwd', 4)
'sys:x:3:3:sys:/dev:/bin/sh\n'
``````

Change the `4` to your desired line number, and you're on. Note that 4 would bring the fifth line as the count is zero-based.

If the file might be very large, and cause problems when read into memory, it might be a good idea to take @Alok's advice and use enumerate().

To Conclude:

• Use `fileobject.readlines()` or `for line in fileobject` as a quick solution for small files.
• Use `linecache` for a more elegant solution, which will be quite fast for reading many files, possible repeatedly.
• Take @Alok's advice and use `enumerate()` for files which could be very large, and won't fit into memory. Note that using this method might slow because the file is read sequentially.

### How to read a value from the Windows registry

This console app will list all the values and their data from a registry key for most of the potential registry values. There's some weird ones not often used. If you need to support all of them, expand from this example while referencing this Registry Value Type documentation.

Let this be the registry key content you can import from a `.reg` file format:

``````Windows Registry Editor Version 5.00

"String_Value"="hello, world!"
"Binary_Value"=hex:01,01,01,01
"Dword value"=dword:00001224
"QWord val"=hex(b):24,22,12,00,00,00,00,00
"multi-line val"=hex(7):4c,00,69,00,6e,00,65,00,20,00,30,00,00,00,4c,00,69,00,\
6e,00,65,00,20,00,31,00,00,00,4c,00,69,00,6e,00,65,00,20,00,32,00,00,00,00,\
00
"expanded_val"=hex(2):25,00,55,00,53,00,45,00,52,00,50,00,52,00,4f,00,46,00,49,\
00,4c,00,45,00,25,00,5c,00,6e,00,65,00,77,00,5f,00,73,00,74,00,75,00,66,00,\
66,00,00,00
``````

The console app itself:

``````#include <Windows.h>
#include <iostream>
#include <string>
#include <locale>
#include <vector>
#include <iomanip>

int wmain()
{
const auto hKey = HKEY_CURRENT_USER;
auto openedKey = HKEY();
auto status = RegOpenKeyEx(hKey, lpSubKey, 0, KEY_READ, &openedKey);

if (status == ERROR_SUCCESS) {
auto valueCount = static_cast<DWORD>(0);
auto maxNameLength = static_cast<DWORD>(0);
auto maxValueLength = static_cast<DWORD>(0);
status = RegQueryInfoKey(openedKey, NULL, NULL, NULL, NULL, NULL, NULL,
&valueCount, &maxNameLength, &maxValueLength, NULL, NULL);

if (status == ERROR_SUCCESS) {
DWORD type = 0;
DWORD index = 0;
std::vector<wchar_t> valueName = std::vector<wchar_t>(maxNameLength + 1);
std::vector<BYTE> dataBuffer = std::vector<BYTE>(maxValueLength);

for (DWORD index = 0; index < valueCount; index++) {
DWORD charCountValueName = static_cast<DWORD>(valueName.size());
DWORD charBytesData = static_cast<DWORD>(dataBuffer.size());
status = RegEnumValue(openedKey, index, valueName.data(), &charCountValueName,
NULL, &type, dataBuffer.data(), &charBytesData);

if (type == REG_SZ) {
const auto reg_string = reinterpret_cast<wchar_t*>(dataBuffer.data());
std::wcout << L"Type: REG_SZ" << std::endl;
std::wcout << L"\tName: " << valueName.data() << std::endl;
std::wcout << L"\tData : " << reg_string << std::endl;
}
else if (type == REG_EXPAND_SZ) {
const auto casted = reinterpret_cast<wchar_t*>(dataBuffer.data());
TCHAR buffer[32000];
ExpandEnvironmentStrings(casted, buffer, 32000);
std::wcout << L"Type: REG_EXPAND_SZ" << std::endl;
std::wcout << L"\tName: " << valueName.data() << std::endl;
std::wcout << L"\tData: " << buffer << std::endl;
}
else if (type == REG_MULTI_SZ) {
std::vector<std::wstring> lines;
const auto str = reinterpret_cast<wchar_t*>(dataBuffer.data());
auto line = str;
lines.emplace_back(line);
for (auto i = 0; i < charBytesData / sizeof(wchar_t) - 1; i++) {
const auto c = str[i];
if (c == 0) {
line = str + i + 1;
const auto new_line = reinterpret_cast<wchar_t*>(line);
if (wcsnlen_s(new_line, 1024) > 0)
lines.emplace_back(new_line);
}
}
std::wcout << L"Type: REG_MULTI_SZ" << std::endl;
std::wcout << L"\tName: " << valueName.data() << std::endl;
std::wcout << L"\tData: " << std::endl;
for (size_t i = 0; i < lines.size(); i++) {
std::wcout << L"\t\tLine[" << i + 1 << L"]: " << lines[i] << std::endl;
}
}
if (type == REG_DWORD) {
const auto dword_value = reinterpret_cast<unsigned long*>(dataBuffer.data());
std::wcout << L"Type: REG_DWORD" << std::endl;
std::wcout << L"\tName: " << valueName.data() << std::endl;
std::wcout << L"\tData : " << std::to_wstring(*dword_value) << std::endl;
}
else if (type == REG_QWORD) {
const auto qword_value = reinterpret_cast<unsigned long long*>(dataBuffer.data());
std::wcout << L"Type: REG_DWORD" << std::endl;
std::wcout << L"\tName: " << valueName.data() << std::endl;
std::wcout << L"\tData : " << std::to_wstring(*qword_value) << std::endl;
}
else if (type == REG_BINARY) {
std::vector<uint16_t> bins;
for (auto i = 0; i < charBytesData; i++) {
bins.push_back(static_cast<uint16_t>(dataBuffer[i]));
}
std::wcout << L"Type: REG_BINARY" << std::endl;
std::wcout << L"\tName: " << valueName.data() << std::endl;
std::wcout << L"\tData:";
for (size_t i = 0; i < bins.size(); i++) {
std::wcout << L" " << std::uppercase << std::hex << \
std::setw(2) << std::setfill(L'0') << std::to_wstring(bins[i]);
}
std::wcout << std::endl;
}
}
}
}

RegCloseKey(openedKey);
return 0;
}
``````

Expected console output:

``````Type: REG_SZ
Name: String_Value
Data : hello, world!
Type: REG_BINARY
Name: Binary_Value
Data: 01 01 01 01
Type: REG_DWORD
Name: Dword value
Data : 4644
Type: REG_DWORD
Name: QWord val
Data : 1188388
Type: REG_MULTI_SZ
Name: multi-line val
Data:
Line[1]: Line 0
Line[2]: Line 1
Line[3]: Line 2
Type: REG_EXPAND_SZ
Name: expanded_val
Data: C:\Users\user name\new_stuff
``````

### "detached entity passed to persist error" with JPA/EJB code

Let's say you have two entities `Album` and `Photo`. Album contains many photos, so it's a one to many relationship.

Album class

``````@Entity
public class Album {
@Id
@GeneratedValue(strategy=GenerationType.AUTO)
Integer albumId;

String albumName;

Set<Photo> photos = new HashSet<Photo>();
}
``````

Photo class

``````@Entity
public class Photo{
@Id
@GeneratedValue(strategy=GenerationType.AUTO)
Integer photo_id;

String photoName;

@ManyToOne(targetEntity=Album.class)
@JoinColumn(name="album_id")
Album album;

}
``````

What you have to do before persist or merge is to set the Album reference in each photos.

``````        Album myAlbum = new Album();
Photo photo1 = new Photo();
Photo photo2 = new Photo();

photo1.setAlbum(myAlbum);
photo2.setAlbum(myAlbum);
``````

That is how to attach the related entity before you persist or merge.

### Redirecting to authentication dialog - "An error occurred. Please try again later"

I had put the restriction on the app that only United States residence could use the app. I was working from Canada at the time this error message appeared. After removing the restriction everything worked.

### Get the selected option id with jQuery

Th easiest way to this is var id = \$(this).val(); from inside an event like on change.

### What is log4j's default log file dumping path

By default, `Log4j` logs to standard output and that means you should be able to see log messages on your Eclipse's console view. To log to a file you need to use a `FileAppender` explicitly by defining it in a `log4j.properties` file in your classpath.

Create the following `log4j.properties` file in your classpath. This allows you to log your message to both a file as well as your console.

``````log4j.rootLogger=debug, stdout, file

log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout

# Pattern to output the caller's file name and line number.
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] (%F:%L) - %m%n

log4j.appender.file=org.apache.log4j.FileAppender
log4j.appender.file.File=example.log
log4j.appender.file.layout=org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern=%p %t %c - %m%n
``````

Note: The above creates an example.log in your current working directory (i.e. Eclipse's project directory) so that the same log4j.properties could work with different projects without overwriting each other's logs.

### Visually managing MongoDB documents and collections

MongoVue is the best I found till now, it has great features like database or collection copy and text mode viewing for records which is extremely useful

### ORACLE IIF Statement

Oracle doesn't provide such IIF Function. Instead, try using one of the following alternatives:

``````SELECT DECODE(EMP_ID, 1, 'True', 'False') from Employee
``````
``````SELECT CASE WHEN EMP_ID = 1 THEN 'True' ELSE 'False' END from Employee
``````

### How to remove gem from Ruby on Rails application?

``````gem dependency devise --pipe | cut -d \  -f 1 | xargs gem uninstall -a
``````

(this assumes that you're not using bundler - but I guess you're not since removing from your bundle gemspec would solve the problem)

### how to use JSON.stringify and json_decode() properly

I don't how this works, but it worked.

``````\$post_data = json_decode(json_encode(\$_POST['request_key']));
``````

### Linking a qtDesigner .ui file to python/pyqt?

http://talk.maemo.org/archive/index.php/t-43663.html

I'll briefly describe the actions to create and change .ui file to .py file, taken from that article.

2. From "New Form" window, create "Main Window"
3. From "Display Widgets" towards the bottom of your "Widget Box Menu" on the left hand side
add a "Label Widget". (Click Drag and Drop)
4. Double click on the newly added Label Widget to change its name to "Hello World"
5. at this point you can use Control + R hotkey to see how it will look.
6. Add buttons or text or other widgets by drag and drop if you want.
7. Now save your form.. File->Save As-> "Hello World.ui" (Control + S will also bring up
the "Save As" option) Keep note of the directory where you saved your "Hello World" .ui
file. (I saved mine in (C:) for convenience)

The file is created and saved, now we will Generate the Python code from it using pyuic!

2. Now "cd" into the directory where you saved your "Hello World.ui" For me i just had to "cd\" and was at my "C:>" prompt, where my "Hello World.ui" was saved to.
3. When you get to the directory where your file is stored type the following.
4. pyuic4 -x helloworld.ui -o helloworld.py
5. Congratulations!! You now have a python Qt4 GUI application!!
6. Double click your helloworld.py file to run it. ( I use pyscripter and upon double click
it opens in pyscripter, then i "run" the file from there)

Hope this helps someone.

### Apache2: 'AH01630: client denied by server configuration'

Because this thread is the first thing that pops up when searching for the error mentioned I would like to add another possible cause for this error: you may have `mod_evasive` active and the client seeing this error simply has crossed the limits configured in your `mod_evasive.conf`

This is especially a cause worth investigating if you are suddenly getting this error for a client that had no problems before and nothing else has changed.

(if `mod_evasive` is the cause then the error will go away by itself if the client just temporarily stops trying to access the site; however it may be a sign that you have configured too tight limits)

### Convert Text to Uppercase while typing in Text box

I had the same problem with Visual Studio 2008 and solved adding the following event handler to the textbox:

``````        private void textBox1_KeyPress(object sender, KeyPressEventArgs e)
{
if ((e.KeyChar >= 'a') && (e.KeyChar <= 'z'))
{
int iPos = textBox1.SelectionStart;
int iLen = textBox1.SelectionLength;
textBox1.Text = textBox1.Text.Remove(iPos, iLen).Insert(iPos, Char.ToUpper(e.KeyChar).ToString());
textBox1.SelectionStart = iPos + 1;
e.Handled = true;
}
}
``````

It works even if you type a lowercase character in a textbox where some characters are selected. I don't know if the code works with a Multiline textbox.

### C# testing to see if a string is an integer?

This function will tell you if your string contains ONLY the characters 0123456789.

``````private bool IsInt(string sVal)
{
foreach (char c in sVal)
{
int iN = (int)c;
if ((iN > 57) || (iN < 48))
return false;
}
return true;
}
``````

This is different from int.TryParse() which will tell you if your string COULD BE an integer.
eg. " 123\r\n" will return TRUE from int.TryParse() but FALSE from the above function.

...Just depends on the question you need to answer.

### Adding a newline into a string in C#

You can add a new line character after the @ symbol like so:

``````string newString = oldString.Replace("@", "@\n");
``````

You can also use the `NewLine` property in the `Environment` Class (I think it is Environment).

### Storage permission error in Marshmallow

``````if (ActivityCompat.shouldShowRequestPermissionRationale(getActivity(),
Manifest.permission.WRITE_EXTERNAL_STORAGE)) {
Log.d(TAG, "Permission granted");
} else {
ActivityCompat.requestPermissions(getActivity(),
new String[]{Manifest.permission.WRITE_EXTERNAL_STORAGE},
100);
}

fab.setOnClickListener(v -> {
Bitmap b = BitmapFactory.decodeResource(getResources(), R.drawable.refer_pic);
Intent share = new Intent(Intent.ACTION_SEND);
share.setType("image/*");
ByteArrayOutputStream bytes = new ByteArrayOutputStream();
b.compress(Bitmap.CompressFormat.JPEG, 100, bytes);
String path = MediaStore.Images.Media.insertImage(requireActivity().getContentResolver(),
b, "Title", null);
Uri imageUri = Uri.parse(path);
share.putExtra(Intent.EXTRA_STREAM, imageUri);
share.putExtra(Intent.EXTRA_TEXT, "Here is text");
startActivity(Intent.createChooser(share, "Share via"));
});
``````

### What is the difference between #include <filename> and #include "filename"?

The `#include <filename>` is used when a system file is being referred to. That is a header file that can be found at system default locations like `/usr/include` or `/usr/local/include`. For your own files that needs to be included in another program you have to use the `#include "filename"` syntax.

### How good is Java's UUID.randomUUID?

At a former employer we had a unique column that contained a random uuid. We got a collision the first week after it was deployed. Sure, the odds are low but they aren't zero. That is why Log4j 2 contains UuidUtil.getTimeBasedUuid. It will generate a UUID that is unique for 8,925 years so long as you don't generate more than 10,000 UUIDs/millisecond on a single server.

### Export to xls using angularjs

If you load your data into ng-grid, you can use the CSV export plugin. The plugin creates a button with the grid data as csv inside an href tag.

http://angular-ui.github.io/ng-grid/

https://github.com/angular-ui/ng-grid/blob/2.x/plugins/ng-grid-csv-export.js

Updating links as the library got renamed:

Library page: http://ui-grid.info/

Documentation on csv export : http://ui-grid.info/docs/#/tutorial/206_exporting_data

### SQL: Group by minimum value in one field while selecting distinct rows

``````SELECT mt.*
FROM MyTable mt INNER JOIN
(
SELECT id, MIN(record_date) AS MinDate
FROM MyTable
GROUP BY id
) t ON mt.id = t.id AND mt.record_date = t.MinDate
``````

This gets the minimum date per ID, and then gets the values based on those values. The only time you would have duplicates is if there are duplicate minimum record_dates for the same ID.

### Header div stays at top, vertical scrolling div below with scrollbar only attached to that div

HTML:

``````?<div class="header">This is the header</div>
<div class="content">This is the content</div>?????????????????????????????????
``````

CSS:

``````?.header
{
height:50px;
}
.content
{
position:absolute;
top: 50px;
left:0px;
right:0px;
bottom:0px;
overflow-y:scroll;
}?
``````

### SQL: How To Select Earliest Row

Simply use `min()`

``````SELECT company, workflow, MIN(date)
FROM workflowTable
GROUP BY company, workflow
``````

### HTML table needs spacing between columns, not rows

If you can use inline styling, you can set the left and right padding on each `td`.. Or you use an extra `td` between columns and set a number of non-breaking spaces as @rene kindly suggested.

http://jsfiddle.net/u5mN4/

http://jsfiddle.net/u5mN4/1/

Both are pretty ugly ;p css ftw

### How to change the pop-up position of the jQuery DatePicker control

A very simple jquery function.

``````\$(".datepicker").focus(function(event){
var dim = \$(this).offset();
\$("#ui-datepicker-div").offset({
top     :   dim.top - 180,
left    :   dim.left + 150
});
});
``````

### How do you Change a Package's Log Level using Log4j?

Which app server are you using? Each one puts its logging config in a different place, though most nowadays use Commons-Logging as a wrapper around either Log4J or java.util.logging.

Using Tomcat as an example, this document explains your options for configuring logging using either option. In either case you need to find or create a config file that defines the log level for each package and each place the logging system will output log info (typically console, file, or db).

In the case of log4j this would be the log4j.properties file, and if you follow the directions in the link above your file will start out looking like:

``````log4j.rootLogger=DEBUG, R
log4j.appender.R=org.apache.log4j.RollingFileAppender
log4j.appender.R.File=\${catalina.home}/logs/tomcat.log
log4j.appender.R.MaxFileSize=10MB
log4j.appender.R.MaxBackupIndex=10
log4j.appender.R.layout=org.apache.log4j.PatternLayout
log4j.appender.R.layout.ConversionPattern=%p %t %c - %m%n
``````

Simplest would be to change the line:

``````log4j.rootLogger=DEBUG, R
``````

To something like:

``````log4j.rootLogger=WARN, R
``````

But if you still want your own DEBUG level output from your own classes add a line that says:

``````log4j.category.com.mypackage=DEBUG
``````

### Convert a String to int?

You can use the `FromStr` trait's `from_str` method, which is implemented for `i32`:

``````let my_num = i32::from_str("9").unwrap_or(0);
``````

### Disable scrolling in all mobile devices

cgvector answer didn't work for me, but this did:

``````document.body.addEventListener('touchstart', function(e){ e.preventDefault(); });
``````

I wouldn't leave it just like that, a smarter logic is needed to select when to prevent the scrolling, but this is a good start.

Taken from here: Disable scrolling in an iPhone web application?

### How to remove an item from an array in AngularJS scope?

``````array.splice(array.pop(item));
``````

### Value Change Listener to JTextField

You can use even "MouseExited" to control. example:

`````` private void jtSoMauMouseExited(java.awt.event.MouseEvent evt) {
try {
if (Integer.parseInt(jtSoMau.getText()) > 1) {
//auto update field
SoMau = Integer.parseInt(jtSoMau.getText());
int result = SoMau / 5;

jtSoBlockQuan.setText(String.valueOf(result));
}
} catch (Exception e) {

}

}
``````

### How to use SearchView in Toolbar Android

If you would like to setup the search facility inside your `Fragment`, just add these few lines:

Step 1 - Add the search field to you `toolbar`:

``````<item
android:id="@+id/action_search"
app:showAsAction="always|collapseActionView"
app:actionViewClass="android.support.v7.widget.SearchView"
android:title="Search"/>
``````

Step 2 - Add the logic to your `onCreateOptionsMenu()`

``````import android.support.v7.widget.SearchView; // not the default !

@Override

searchView.setOnQueryTextListener(new SearchView.OnQueryTextListener() {
@Override
public boolean onQueryTextSubmit(String query) {
// Toast like print
UserFeedback.show( "SearchOnQueryTextSubmit: " + query);
if( ! searchView.isIconified()) {
searchView.setIconified(true);
}
return false;
}
@Override
public boolean onQueryTextChange(String s) {
// UserFeedback.show( "SearchOnQueryTextChanged: " + s);
return false;
}
});
return true;
}
``````

### JSON ValueError: Expecting property name: line 1 column 2 (char 1)

used ast, example

``````In [15]: a = "[{'start_city': '1', 'end_city': 'aaa', 'number': 1},\
...:      {'start_city': '2', 'end_city': 'bbb', 'number': 1},\
...:      {'start_city': '3', 'end_city': 'ccc', 'number': 1}]"
In [16]: import ast
In [17]: ast.literal_eval(a)
Out[17]:
[{'end_city': 'aaa', 'number': 1, 'start_city': '1'},
{'end_city': 'bbb', 'number': 1, 'start_city': '2'},
{'end_city': 'ccc', 'number': 1, 'start_city': '3'}]
``````

### Write to text file without overwriting in Java

Here is a simple example of how it works, best practice to put a try\catch into it but for basic use this should do the trick. For this you have a string and file path and apply thus to the FileWriter and the BufferedWriter. This will write "Hello World"(Data variable) and then make a new line. each time this is run it will add the Data variable to the next line.

``````import java.io.BufferedWriter;
import java.io.File;
import java.io.FileWriter;

String Data = "Hello World";
File file = new File("C:/Users/stuff.txt");
FileWriter fw = new FileWriter(file,true);
BufferedWriter bw = new BufferedWriter(fw);
bw.write(Data);
bw.newLine();
bw.close();
``````

### How to deep watch an array in angularjs?

If you're going to watch only one array, you can simply use this bit of code:

``````\$scope.\$watch('columns', function() {
// some value in the array has changed
}, true); // watching properties
``````

example

But this will not work with multiple arrays:

``````\$scope.\$watch('columns + ANOTHER_ARRAY', function() {
// will never be called when things change in columns or ANOTHER_ARRAY
}, true);
``````

example

To handle this situation, I usually convert the multiple arrays I want to watch into JSON:

``````\$scope.\$watch(function() {
return angular.toJson([\$scope.columns, \$scope.ANOTHER_ARRAY, ... ]);
},
function() {
// some value in some array has changed
}
``````

example

As @jssebastian pointed out in the comments, `JSON.stringify` may be preferable to `angular.toJson` as it can handle members that start with '\$' and possible other cases as well.

### Negation in Python

The negation operator in Python is `not`. Therefore just replace your `!` with `not`.

``````if not os.path.exists("/usr/share/sounds/blues") :
proc = subprocess.Popen(["mkdir", "/usr/share/sounds/blues"])
proc.wait()
``````

For your specific example (as Neil said in the comments), you don't have to use the `subprocess` module, you can simply use `os.mkdir()` to get the result you need, with added exception handling goodness.

Example:

``````blues_sounds_path = "/usr/share/sounds/blues"
if not os.path.exists(blues_sounds_path):
try:
os.mkdir(blues_sounds_path)
except OSError:
# Handle the case where the directory could not be created.
``````

### Static class initializer in PHP

Actually, I use a public static method `__init__()` on my static classes that require initialization (or at least need to execute some code). Then, in my autoloader, when it loads a class it checks `is_callable(\$class, '__init__')`. If it is, it calls that method. Quick, simple and effective...

CORS can become a headache, if we do not correctly understand its functioning. I use them in PHP and they work without problems. reference here

``````header("Access-Control-Allow-Origin: *");
header("Access-Control-Allow-Methods: PUT, POST, GET, OPTIONS, DELETE");
``````

### Full Page <iframe>

``````iframe {
width: 100%;
height: 100vh;
}
``````

### Is there a way to create interfaces in ES6 / Node 4?

there are packages that can simulate interfaces .

you can use es6-interface

### How do I set Tomcat Manager Application User Name and Password for NetBeans?

Well if you are using Netbeans in Linux, then you should look for the tomcat-user.xml in

``````/home/Username/.netbeans/8.0/apache-tomcat-8.0.3.0_base/conf
``````

(its called Catalina Base and is often hidden) instead of the Apache installation directory.

open tomcat-user.xml inside that folder, uncomment the user and roles and add/replace the following line.

``````    <user username="tomcat" password="tomcat" roles="tomcat,admin,admin-gui,manager,manager-gui"/>
``````

restart the server . That's all

### React proptype array with shape

This was my solution to protect against an empty array as well:

``````import React, { Component } from 'react';
import { arrayOf, shape, string, number } from 'prop-types';

ReactComponent.propTypes = {
arrayWithShape: (props, propName, componentName) => {
const arrayWithShape = props[propName]
PropTypes.checkPropTypes({ arrayWithShape:
arrayOf(
shape({
color: string.isRequired,
fontSize: number.isRequired,
}).isRequired
).isRequired
}, {arrayWithShape}, 'prop', componentName);
if(arrayWithShape.length < 1){
return new Error(`\${propName} is empty`)
}
}
}
``````

### Update Rows in SSIS OLEDB Destination

Steps to do update:

1. Drag OLEDB Command [instead of oledb destination]
2. Go to properties window
3. Under Custom properties select SQLCOMMAND and insert update command ex:

UPDATE table1 SET col1 = ?, col2 = ? where id = ?

4. map columns in exact order from source to output as in update command

### Java String to Date object of the format "yyyy-mm-dd HH:mm:ss"

For future reference:

`````` yyyy => 4 digit year
MM   => 2 digit month (you must type MM in ALL CAPS)
dd   => 2 digit "day of the month"

HH   => 2-digit "hour in day" (0 to 23)
mm   => 2-digit minute (you must type mm in lowercase)
ss   => 2-digit seconds
SSS  => milliseconds
``````

So "yyyy-MM-dd HH:mm:ss" returns "2018-01-05 09:49:32"

But "MMM dd, yyyy hh:mm a" returns "Jan 05, 2018 09:49 am"

The so-called examples at https://docs.oracle.com/javase/7/docs/api/java/text/SimpleDateFormat.html show only output. They do not tell you what formats to use!

### Get filename in batch for loop

If you want to remain both filename (only) and extension, you may use `%~nxF`:

`FOR /R C:\Directory %F in (*.*) do echo %~nxF`

### Best way to convert strings to symbols in hash

Starting on Psych 3.0 you can add the symbolize_names: option

```Psych.load("---\n foo: bar") # => {"foo"=>"bar"}```

```Psych.load("---\n foo: bar", symbolize_names: true) # => {:foo=>"bar"}```

Note: if you have a lower Psych version than 3.0 `symbolize_names:` will be silently ignored.

My Ubuntu 18.04 includes it out of the box with ruby 2.5.1p57

### Scroll Position of div with "overflow: auto"

You need to use the `scrollTop` property.

`document.getElementById('box').scrollTop`

### Git - What is the difference between push.default "matching" and "simple"

From GIT documentation: Git Docs

Below gives the full information. In short, `simple` will only push the `current working branch` and even then only if it also has the same name on the remote. This is a very good setting for beginners and will become the default in `GIT 2.0`

Whereas `matching` will push all branches locally that have the same name on the remote. (Without regard to your current working branch ). This means potentially many different branches will be pushed, including those that you might not even want to share.

In my personal usage, I generally use a different option: `current` which pushes the current working branch, (because I always branch for any changes). But for a beginner I'd suggest `simple`

push.default
Defines the action git push should take if no refspec is explicitly given. Different values are well-suited for specific workflows; for instance, in a purely central workflow (i.e. the fetch source is equal to the push destination), upstream is probably what you want. Possible values are:

nothing - do not push anything (error out) unless a refspec is explicitly given. This is primarily meant for people who want to avoid mistakes by always being explicit.

current - push the current branch to update a branch with the same name on the receiving end. Works in both central and non-central workflows.

upstream - push the current branch back to the branch whose changes are usually integrated into the current branch (which is called @{upstream}). This mode only makes sense if you are pushing to the same repository you would normally pull from (i.e. central workflow).

simple - in centralized workflow, work like upstream with an added safety to refuse to push if the upstream branch's name is different from the local one.

When pushing to a remote that is different from the remote you normally pull from, work as current. This is the safest option and is suited for beginners.

This mode will become the default in Git 2.0.

matching - push all branches having the same name on both ends. This makes the repository you are pushing to remember the set of branches that will be pushed out (e.g. if you always push maint and master there and no other branches, the repository you push to will have these two branches, and your local maint and master will be pushed there).

To use this mode effectively, you have to make sure all the branches you would push out are ready to be pushed out before running git push, as the whole point of this mode is to allow you to push all of the branches in one go. If you usually finish work on only one branch and push out the result, while other branches are unfinished, this mode is not for you. Also this mode is not suitable for pushing into a shared central repository, as other people may add new branches there, or update the tip of existing branches outside your control.

This is currently the default, but Git 2.0 will change the default to simple.

### Plotting dates on the x-axis with Python's matplotlib

You can do this more simply using `plot()` instead of `plot_date()`.

First, convert your strings to instances of Python `datetime.date`:

``````import datetime as dt

dates = ['01/02/1991','01/03/1991','01/04/1991']
x = [dt.datetime.strptime(d,'%m/%d/%Y').date() for d in dates]
y = range(len(x)) # many thanks to Kyss Tao for setting me straight here
``````

Then plot:

``````import matplotlib.pyplot as plt
import matplotlib.dates as mdates

plt.gca().xaxis.set_major_formatter(mdates.DateFormatter('%m/%d/%Y'))
plt.gca().xaxis.set_major_locator(mdates.DayLocator())
plt.plot(x,y)
plt.gcf().autofmt_xdate()
``````

Result:

### Age from birthdate in python

import datetime

``````def age(date_of_birth):
if date_of_birth > datetime.date.today().replace(year = date_of_birth.year):
return datetime.date.today().year - date_of_birth.year - 1
else:
return datetime.date.today().year - date_of_birth.year
``````

``````import datetime

def age(self):
if self.birthdate > datetime.date.today().replace(year = self.birthdate.year):
return datetime.date.today().year - self.birthdate.year - 1
else:
return datetime.date.today().year - self.birthdate.year
``````

### Get all non-unique values (i.e.: duplicate/more than one occurrence) in an array

You could sort the array and then run through it and then see if the next (or previous) index is the same as the current. Assuming your sort algorithm is good, this should be less than O(n2):

_x000D_
_x000D_
``````const findDuplicates = (arr) => {_x000D_
let sorted_arr = arr.slice().sort(); // You can define the comparing function here. _x000D_
// JS by default uses a crappy string compare._x000D_
// (we use slice to clone the array so the_x000D_
// original array won't be modified)_x000D_
let results = [];_x000D_
for (let i = 0; i < sorted_arr.length - 1; i++) {_x000D_
if (sorted_arr[i + 1] == sorted_arr[i]) {_x000D_
results.push(sorted_arr[i]);_x000D_
}_x000D_
}_x000D_
return results;_x000D_
}_x000D_
_x000D_
let duplicatedArray = [9, 9, 111, 2, 3, 4, 4, 5, 7];_x000D_
console.log(`The duplicates in \${duplicatedArray} are \${findDuplicates(duplicatedArray)}`);``````
_x000D_
_x000D_
_x000D_

In case, if you are to return as a function for duplicates. This is for similar type of case.

### How to add noise (Gaussian/salt and pepper etc) to image in Python with OpenCV

The Function adds gaussian , salt-pepper , poisson and speckle noise in an image

``````Parameters
----------
image : ndarray
Input image data. Will be converted to float.
mode : str
One of the following strings, selecting the type of noise to add:

'poisson'   Poisson-distributed noise generated from the data.
's&p'       Replaces random pixels with 0 or 1.
'speckle'   Multiplicative noise using out = image + n*image,where
n is uniform noise with specified mean & variance.

import numpy as np
import os
import cv2
def noisy(noise_typ,image):
if noise_typ == "gauss":
row,col,ch= image.shape
mean = 0
var = 0.1
sigma = var**0.5
gauss = np.random.normal(mean,sigma,(row,col,ch))
gauss = gauss.reshape(row,col,ch)
noisy = image + gauss
return noisy
elif noise_typ == "s&p":
row,col,ch = image.shape
s_vs_p = 0.5
amount = 0.004
out = np.copy(image)
# Salt mode
num_salt = np.ceil(amount * image.size * s_vs_p)
coords = [np.random.randint(0, i - 1, int(num_salt))
for i in image.shape]
out[coords] = 1

# Pepper mode
num_pepper = np.ceil(amount* image.size * (1. - s_vs_p))
coords = [np.random.randint(0, i - 1, int(num_pepper))
for i in image.shape]
out[coords] = 0
return out
elif noise_typ == "poisson":
vals = len(np.unique(image))
vals = 2 ** np.ceil(np.log2(vals))
noisy = np.random.poisson(image * vals) / float(vals)
return noisy
elif noise_typ =="speckle":
row,col,ch = image.shape
gauss = np.random.randn(row,col,ch)
gauss = gauss.reshape(row,col,ch)
noisy = image + image * gauss
return noisy
``````

### .htaccess redirect http to https

Adding the following to the top of the .htaccess

``````RewriteEngine On
RewriteCond %{ENV:HTTPS} !=on
RewriteRule ^.*\$ https://%{SERVER_NAME}%{REQUEST_URI} [R,L]
``````

### Check if element is in the list (contains)

They really should add a wrapper. Like this:

``````namespace std
{
template<class _container,
class _Ty> inline
bool contains(_container _C, const _Ty& _Val)
{return std::find(_C.begin(), _C.end(), _Val) != _C.end(); }
};
...
if( std::contains(my_container, what_to_find) )
{

}
``````

### How to upload images into MySQL database using PHP code

Firstly, you should check if your image column is BLOB type!

I don't know anything about your SQL table, but if I'll try to make my own as an example.

We got fields `id` (int), `image` (blob) and `image_name` (varchar(64)).

So the code should look like this (assume ID is always '1' and let's use this mysql_query):

``````\$image = addslashes(file_get_contents(\$_FILES['image']['tmp_name'])); //SQL Injection defence!
\$sql = "INSERT INTO `product_images` (`id`, `image`, `image_name`) VALUES ('1', '{\$image}', '{\$image_name}')";
if (!mysql_query(\$sql)) { // Error handling
echo "Something went wrong! :(";
}
``````

You are doing it wrong in many ways. Don't use mysql functions - they are deprecated! Use PDO or MySQLi. You should also think about storing files locations on disk. Using MySQL for storing images is thought to be Bad Idea™. Handling SQL table with big data like images can be problematic.

Also your HTML form is out of standards. It should look like this:

``````<form action="insert_product.php" method="POST" enctype="multipart/form-data">
<label>File: </label><input type="file" name="image" />
<input type="submit" />
</form>
``````

Sidenote:

When dealing with files and storing them as a BLOB, the data must be escaped using `mysql_real_escape_string()`, otherwise it will result in a syntax error.

### Nested jQuery.each() - continue/break

return true not work

return false working

``````found = false;
query = "foo";

\$('.items').each(function()
{
if(\$(this).text() == query)
{
found = true;
return false;
}
});
``````

### Visual Studio replace tab with 4 spaces?

If you don't see the formatting option, you can do Tools->Import and Export settings to import the missing one.

### Running AMP (apache mysql php) on Android

Use this app : Servers Ultimate
With this app can run any server you can imagine on your android device (php, mysql, ftp, dhcp, ...) your phone will be a real server, just install the app click on (+) sign to add server, if the server is not installed the app will ask to download the package. You can access your server via LAN or WAN easily.

### SQL Server 2000: How to exit a stored procedure?

i figured out why `RETURN` is not unconditionally returning from the stored procedure. The error i'm seeing is while the stored procedure is being compiled - not when it's being executed.

Consider an imaginary stored procedure:

``````CREATE PROCEDURE dbo.foo AS

INSERT INTO ExistingTable
``````

Even though this stord proedure contains an error (maybe it's because the objects have a differnet number of columns, maybe there is a timestamp column in the table, maybe the stored procedure doesn't exist), you can still save it. You can save it because you're referencing a linked server.

But when you actually execute the stored procedure, SQL Server then compiles it, and generates a query plan.

My error is not happening on line 114, it is on line 114. SQL Server cannot compile the stored procedure, that's why it's failing.

And that's why `RETURN` does not return, because it hasn't even started yet.

### Environment Specific application.properties file in Spring Boot application

My Point , IN this arent way asking developer to create all environment related in single go, resulting in risk of exposing Production Configuration to end developer

as per 12-Factor, shouldnt be enviornment specific reside in Enviornment only .

How do we do for CI CD

• Build Spring one time and promote to aother environment, in that case, if we have spring jar has all environment, it iwll security risk, having all environment variable in GIT

### I want to calculate the distance between two points in Java

You could also you Point2D Java API class:

`public static double distance(double x1, double y1, double x2, double y2)`

Example:

``````double distance = Point2D.distance(3.0, 4.0, 5.0, 6.0);
System.out.println("The distance between the points is " + distance);
``````

### Detecting superfluous #includes in C/C++?

You can write a quick script that erases a single #include directive, compiles the projects, and logs the name in the #include and the file it was removed from in the case that no compilation errors occurred.

Let it run during the night, and the next day you will have a 100% correct list of include files you can remove.

Sometimes brute-force just works :-)

edit: and sometimes it doesn't :-). Here's a bit of information from the comments:

1. Sometimes you can remove two header files separately, but not both together. A solution is to remove the header files during the run and not bring them back. This will find a list of files you can safely remove, although there might a solution with more files to remove which this algorithm won't find. (it's a greedy search over the space of include files to remove. It will only find a local maximum)
2. There may be subtle changes in behavior if you have some macros redefined differently depending on some #ifdefs. I think these are very rare cases, and the Unit Tests which are part of the build should catch these changes.

### Can't append <script> element

This works:

``````\$('body').append(\$("<script>alert('Hi!');<\/script>")[0]);
``````

It seems like jQuery is doing something clever with scripts so you need to append the html element rather than jQuery object.

### Showing percentages above bars on Excel column graph

Either

1. Use a line series to show the %
2. Update the data labels above the bars to link back directly to other cells

Method 2 by step

• right-click the data lable
• goto the edit bar and type in a refence to a cell (C4 in this example)
• this changes the data lable from the defulat value (2000) to a linked cell with the 15%

### What does it mean to bind a multicast (UDP) socket?

Correction for What does it mean to bind a multicast (udp) socket? as long as it partially true at the following quote:

The "bind" operation is basically saying, "use this local UDP port for sending and receiving data. In other words, it allocates that UDP port for exclusive use for your application

There is one exception. Multiple applications can share the same port for listening (usually it has practical value for multicast datagrams), if the `SO_REUSEADDR` option applied. For example

``````int sock = socket(AF_INET, SOCK_DGRAM, IPPROTO_UDP); // create UDP socket somehow
...
int set_option_on = 1;
// it is important to do "reuse address" before bind, not after
int res = setsockopt(sock, SOL_SOCKET, SO_REUSEADDR, (char*) &set_option_on,
sizeof(set_option_on));
``````

If several processes did such "reuse binding", then every UDP datagram received on that shared port will be delivered to each of the processes (providing natural joint with multicasts traffic).

Here are further details regarding what happens in a few cases:

1. attempt of any bind ("exclusive" or "reuse") to free port will be successful

2. attempt to "exclusive binding" will fail if the port is already "reuse-binded"

3. attempt to "reuse binding" will fail if some process keeps "exclusive binding"

### form with no action and where enter does not reload page

Simply add this event to your text field. It will prevent a submission on pressing Enter, and you're free to add a submit button or call form.submit() as required:

``````onKeyPress="if (event.which == 13) return false;"
``````

For example:

``````<input id="txt" type="text" onKeyPress="if (event.which == 13) return false;"></input>
``````

For pip

``````pip install pymysql
``````

For pip3 you should use

``````python3 -m pip install PyMySQL
``````

Then, edit the init.py file in your project origin directory (the same as settings.py). Add:

``````import pymysql

pymysql.install_as_MySQLdb()
``````

### Altering column size in SQL Server

``````ALTER TABLE [table_name] ALTER COLUMN [column_name] varchar(150)
``````

### S3 Static Website Hosting Route All Paths to Index.html

If you landed here looking for solution that works with React Router and AWS Amplify Console - you already know that you can't use CloudFront redirection rules directly since Amplify Console does not expose CloudFront Distribution for the app.

Solution, however, is very simple - you just need to add a redirect/rewrite rule in Amplify Console like this:

### How to import Swagger APIs into Postman?

The accepted answer is correct but I will rewrite complete steps for `java`.

I am currently using `Swagger V2` with `Spring Boot 2` and it's straightforward 3 step process.

Step 1: Add required dependencies in `pom.xml` file. The second dependency is optional use it only if you need `Swagger UI`.

``````        <!-- https://mvnrepository.com/artifact/io.springfox/springfox-swagger2 -->
<dependency>
<groupId>io.springfox</groupId>
<artifactId>springfox-swagger2</artifactId>
<version>2.9.2</version>
</dependency>
<!-- https://mvnrepository.com/artifact/io.springfox/springfox-swagger-ui -->
<dependency>
<groupId>io.springfox</groupId>
<artifactId>springfox-swagger-ui</artifactId>
<version>2.9.2</version>
</dependency>
``````

``````@Configuration
@EnableSwagger2
public class SwaggerConfig {

public static final Contact DEFAULT_CONTACT = new Contact("Usama Amjad", "https://stackoverflow.com/users/4704510/usamaamjad", "[email protected]");
public static final ApiInfo DEFAULT_API_INFO = new ApiInfo("Article API", "Article API documentation sample", "1.0", "urn:tos",

@Bean
public Docket api() {
Set<String> producesAndConsumes = new HashSet<>();
return new Docket(DocumentationType.SWAGGER_2)
.apiInfo(DEFAULT_API_INFO)
.produces(producesAndConsumes)
.consumes(producesAndConsumes);

}
}
``````

Step 3: Setup complete and now you need to document APIs in `controllers`

``````    @ApiOperation(value = "Returns a list Articles for a given Author", response = Article.class, responseContainer = "List")
@ApiResponses(value = { @ApiResponse(code = 200, message = "Success"),
@ApiResponse(code = 404, message = "The resource you were trying to reach is not found") })
@GetMapping(path = "/articles/users/{userId}")
public List<Article> getArticlesByUser() {
}
``````

Usage:

You can access your Documentation from `http://localhost:8080/v2/api-docs` just copy it and paste in Postman to import collection.

Optional Swagger UI: You can also use standalone UI without any other rest client via `http://localhost:8080/swagger-ui.html` and it's pretty good, you can host your documentation without any hassle.

### What is the difference between char, nchar, varchar, and nvarchar in SQL Server?

• nchar is fixed-length and can hold unicode characters. it uses two bytes storage per character.

• varchar is of variable length and cannot hold unicode characters. it uses one byte storage per character.

### Redirect from asp.net web api post action

Sure:

``````public HttpResponseMessage Post()
{
// ... do the job

// now redirect
var response = Request.CreateResponse(HttpStatusCode.Moved);
return response;
}
``````

### finding the type of an element using jQuery

It is worth noting that @Marius's second answer could be used as pure Javascript solution.

``````document.getElementById('elementId').tagName
``````

### The project description file (.project) for my project is missing

Martin Encountered the same issue with a Minecraft Mod project when I changed the Main folder location. Normally I would open the project like this

This is how my path looked when I started the project

I got the same "The project description file (.project) for my project is missing." Error.

I later found the .project file in the main folder like this.

This is the location where I found the .project file

I found that going eclipse to "File->Open Project from File System or Archive" and navigate to your main project folder with the .project file solved the problem.

This is my first post in here hoping it can help you out, Martin.

### SQLAlchemy create_all() does not create tables

This is probably not the main reason why the `create_all()` method call doesn't work for people, but for me, the cobbled together instructions from various tutorials have it such that I was creating my db in a request context, meaning I have something like:

``````# lib/db.py

def get_db():
if 'db' not in g:
g.db = SQLAlchemy(current_app)
return g.db
``````

I also have a separate cli command that also does the create_all:

``````# tasks/db.py
from lib.db import get_db

@current_app.cli.command('init-db')
def init_db():
db = get_db()
db.create_all()
``````

I also am using a application factory.

When the cli command is run, a new app context is used, which means a new db is used. Furthermore, in this world, an import model in the init_db method does not do anything, because it may be that your model file was already loaded(and associated with a separate db).

The fix that I came around to was to make sure that the db was a single global reference:

``````# lib/db.py

db = None
def get_db():
global db
if not db:
db = SQLAlchemy(current_app)
return db
``````

I have not dug deep enough into flask, sqlalchemy, or flask-sqlalchemy to understand if this means that requests to the db from multiple threads are safe, but if you're reading this you're likely stuck in the baby stages of understanding these concepts too.

### How to get a variable value if variable name is stored as string?

``````###############################################################################
# Summary: Returns the value of a variable given it's name as a string.
# Required Positional Argument:
#   variable_name - The name of the variable to return the value of
# Returns: The value if variable exists; otherwise, empty string ("").
###############################################################################
get_value_of()
{
variable_name=\$1
variable_value=""
if set | grep -q "^\$variable_name="; then
eval variable_value="\\$\$variable_name"
fi
echo "\$variable_value"
}

test=123
get_value_of test
# 123
test="\\$(echo \"something nasty\")"
get_value_of test
# \$(echo "something nasty")
``````

### Get name of currently executing test in JUnit 4

You can achieve this using `Slf4j` and `TestWatcher`

``````private static Logger _log = LoggerFactory.getLogger(SampleTest.class.getName());

@Rule
public TestWatcher watchman = new TestWatcher() {
@Override
public void starting(final Description method) {
_log.info("being run..." + method.getMethodName());
}
};
``````

### How to force a SQL Server 2008 database to go Offline

Go offline

``````USE master
GO
ALTER DATABASE YourDatabaseName
SET OFFLINE WITH ROLLBACK IMMEDIATE
GO
``````

Go online

``````USE master
GO
ALTER DATABASE YourDatabaseName
SET ONLINE
GO
``````

### Error: "dictionary update sequence element #0 has length 1; 2 is required" on Django 1.4

I faced the above mentioned problem when I forgot to pass a keyword argument name to url() function.

Code with error

`````` url(r"^testing/\$", views.testing, "testing")
``````

Code without error

``````url(r"^testing/\$", views.testing, name="testing")
``````

So finally I removed the above error in this way. It might be something different in your case. So check your url patterns in urls.py.

### How to disable right-click context-menu in JavaScript

Capture the `onContextMenu` event, and return false in the event handler.

You can also capture the click event and check which mouse button fired the event with `event.button`, in some browsers anyway.

### Error Message : Cannot find or open the PDB file

Working with VS 2013. Try the following Tools -> Options -> Debugging -> Output Window -> Module Load Messages -> Off It will disable the display of modules loaded.

### Aligning a button to the center

For me it worked using flexbox, which is in my opinion the cleanest solution.

Add a css class around the parent div / element with :

``````.parent {
display: flex;
}
``````

and for the button use:

``````.button {
justify-content: center;
}
``````

You should use a parent div, otherwise the button doesn't 'know' what the middle of the page / element is.

If this is not working, try :

``````#wrapper {
display:flex;
justify-content: center;
}
``````

### Store mysql query output into a shell variable

``````myvariable=\$(mysql -u user -p'password' -s -N <<QUERY_INPUT
use databaseName;
SELECT fieldName FROM tablename WHERE filedName='fieldValue';
QUERY_INPUT
)
echo "myvariable=\$myvariable"
``````

### How to check if curl is enabled or disabled

Hope this helps.

``````<?php
function _iscurl() {
return function_exists('curl_version');
}
?>
``````

### how to check the version of jar file?

I'm late this but you can try the following two methods

using these needed classes

``````import java.util.jar.Attributes;
import java.util.jar.Manifest;
``````

These methods let me access the jar attributes. I like being backwards compatible and use the latest. So I used this

``````public Attributes detectClassBuildInfoAttributes(Class sourceClass) throws MalformedURLException, IOException {
String className = sourceClass.getSimpleName() + ".class";
String classPath = sourceClass.getResource(className).toString();
if (!classPath.startsWith("jar")) {
// Class not from JAR
return null;
}
String manifestPath = classPath.substring(0, classPath.lastIndexOf("!") + 1) +
"/META-INF/MANIFEST.MF";
Manifest manifest = new Manifest(new URL(manifestPath).openStream());
return manifest.getEntries().get("Build-Info");
}

public String retrieveClassInfoAttribute(Class sourceClass, String attributeName) throws MalformedURLException, IOException {
Attributes version_attr = detectClassBuildInfoAttributes(sourceClass);

String attribute = version_attr.getValue(attributeName);

return attribute;
}
``````

This works well when you are using maven and need pom details for known classes. Hope this helps.

### How to use doxygen to create UML class diagrams from C++ source

Doxygen creates inheritance diagrams but I dont think it will create an entire class hierachy. It does allow you to use the GraphViz tool. If you use the Doxygen GUI frontend tool you will find the relevant options in `Step2: -> Wizard tab -> Diagrams`. The DOT relation options are under the Expert Tab.

### How to add an image to the "drawable" folder in Android Studio?

You need to use a third party plugin like AndroidIcons Drawable Import to install this. Goto Android Studio > Prefrences > Plugins > and browse for AndroidIcons Drawable You can do things like

1. AndroidIcons Drawable Import
2. Material Icons Drawable Import
3. Scaled Drawable
4. Multisource-Drawable

Restart android studio. If you do not have the drawables folder created, create it by importing any image as -"Action Bar and Tab Icons" & "Notification Icons",. Then right clink on the file explorer and you can see 4 options in the new tab. Use any one according to your need.

### Error message "Strict standards: Only variables should be passed by reference"

`\$instance->find()` returns a reference to a variable.

You get the report when you are trying to use this reference as an argument to a function, without storing it in a variable first.

This helps preventing memory leaks and will probably become an error in the next PHP versions.

Your second code block would throw an error if it wrote like (note the `&` in the function signature):

``````function &get_arr(){
return array(1, 2);
}
\$el = array_shift(get_arr());
``````

So a quick (and not so nice) fix would be:

``````\$el = array_shift(\$tmp = \$instance->find(..));
``````

Basically, you do an assignment to a temporary variable first and send the variable as an argument.

### Emulator error: This AVD's configuration is missing a kernel file

My story, Eclipse wanted a file called "`kernel-ranchu`" in the system image folder ( `/path/to/android-sdk-macosx/system-images/android-25/google_apis/arm64-v8a` ).

emulator: ERROR: This AVD's configuration is missing a kernel file! Please ensure the file "kernel-ranchu" is in the same location as your system image.

emulator: ERROR: ANDROID_SDK_ROOT is undefined

In that system image folder there was a file called "`kernel-qemu`". I just renamed it as "`kernel-ranchu`" and it worked...

### How to set array length in c# dynamically

Typically, arrays require constants to initialize their size. You could sweep over nvPairs once to get the length, then "dynamically" create an array using a variable for length like this.

``````InputProperty[] ip = (InputProperty[])Array.CreateInstance(typeof(InputProperty), length);
``````

I wouldn't recommend it, though. Just stick with the

``````List<InputProperty> ip = ...
...
update.Items = ip.ToArray();
``````

solution. It's not that much less performant, and way better looking.

### Python sockets error TypeError: a bytes-like object is required, not 'str' with send function

You can change the send line to this:

``````c.send(b'Thank you for connecting')
``````

The `b` makes it bytes instead.

### How to specify credentials when connecting to boto3 S3?

This is older but placing this here for my reference too. boto3.resource is just implementing the default Session, you can pass through boto3.resource session details.

``````Help on function resource in module boto3:

resource(*args, **kwargs)
Create a resource service client by name using the default session.

See :py:meth:`boto3.session.Session.resource`.
``````

https://github.com/boto/boto3/blob/86392b5ca26da57ce6a776365a52d3cab8487d60/boto3/session.py#L265

you can see that it just takes the same arguments as Boto3.Session

``````import boto3
S3 = boto3.resource('s3', region_name='us-west-2', aws_access_key_id=settings.AWS_SERVER_PUBLIC_KEY, aws_secret_access_key=settings.AWS_SERVER_SECRET_KEY)
S3.Object( bucket_name, key_name ).delete()
``````

### disable Bootstrap's Collapse open/close animation

Maybe not a direct answer to the question, but a recent addition to the official documentation describes how jQuery can be used to disable transitions entirely just by:

``````\$.support.transition = false
``````

Setting the `.collapsing` CSS transitions to none as mentioned in the accepted answer removed the animation. But this — in Firefox and Chromium for me — creates an unwanted visual issue on collapse of the navbar.

For instance, visit the Bootstrap navbar example and add the CSS from the accepted answer:

``````.collapsing {
-webkit-transition: none;
transition: none;
}
``````

What I currently see is when the navbar collapses, the bottom border of the navbar momentarily becomes two pixels instead of one, then disconcertingly jumps back to one. Using jQuery, this artifact doesn't appear.

### Exception thrown in catch and finally clause

Exceptions in the finally block supersede exceptions in the catch block.

If the catch block completes abruptly for reason R, then the finally block is executed. Then there is a choice:

• If the finally block completes normally, then the try statement completes abruptly for reason R.

• If the finally block completes abruptly for reason S, then the try statement completes abruptly for reason S (and reason R is discarded).

### Element-wise addition of 2 lists?

It's simpler to use `numpy` from my opinion:

``````import numpy as np
list1=[1,2,3]
list2=[4,5,6]
``````

Results:

For detailed parameter information, check here: numpy.add

### Remove Primary Key in MySQL

First modify the column to remove the auto_increment field like this: alter table user_customer_permission modify column id int;

Next, drop the primary key. alter table user_customer_permission drop primary key;

### How to get RegistrationID using GCM in android

In response to your first question: Yes, you have to run a server app to send the messages, as well as a client app to receive them.

In response to your second question: Yes, every application needs its own API key. This key is for your server app, not the client.

### Passing a callback function to another class

You have to first declare delegate's type because delegates are strongly typed:

``````public void MyCallbackDelegate( string str );

public void DoRequest(string request, MyCallbackDelegate callback)
{
// do stuff....
callback("asdf");
}
``````

### How to get current time and date in Android

Try this code it display current date and time

`````` Date date = new Date(System.currentTimeMillis());
SimpleDateFormat dateFormat = new SimpleDateFormat("hh:mm aa",
Locale.ENGLISH);
String var = dateFormat.format(date));
``````

### JQuery or JavaScript: How determine if shift key being pressed while clicking anchor tag hyperlink?

I had a similar problem, trying to capture a 'shift+click' but since I was using a third party control with a callback rather than the standard `click` handler, I didn't have access to the event object and its associated `e.shiftKey`.

I ended up handling the mouse down event to record the shift-ness and then using it later in my callback.

``````    var shiftHeld = false;
\$('#control').on('mousedown', function (e) { shiftHeld = e.shiftKey });
``````

Posted just in case someone else ends up here searching for a solution to this problem.

### How can we stop a running java process through Windows cmd?

It is rather messy but you need to do something like the following:

``````START "do something window" dir
FOR /F "tokens=2" %I in ('TASKLIST /NH /FI "WINDOWTITLE eq do something window"' ) DO SET PID=%I
ECHO %PID%
``````

(This kind of thing is much easier if you have a UNIX / LINUX system ... or if you run Cygwin or similar on Windows.)

### How can I mock the JavaScript window object using Jest?

In your Jest configuration, add setupFilesAfterEnv: ["./setupTests.js"], create that file, and add the code you want to run before the tests:

``````// setupTests.js
window.crypto = {
.....
};
``````

Reference: setupFilesAfterEnv [array]

### How can I use MS Visual Studio for Android Development?

I suppose you can open Java files in Visual Studio and just use the command line tools directly. I don't think you'd get syntax highlighting or autocompletion though.

Eclipse is really not all that different from Visual Studio, and there are a lot of tools that are designed to make Android development more comfortable that work from within Eclipse.

### How to convert an object to a byte array in C#

Take a look at Serialization, a technique to "convert" an entire object to a byte stream. You may send it to the network or write it into a file and then restore it back to an object later.

### Docker: adding a file from a parent directory

Directory structure :

``````setup/
|__docker/DockerFile
|__target/scripts/<myscripts.sh>
src/
|__<my source files>
``````

Docker file entry:

``````RUN mkdir -p /home/vagrant/dockerws/chatServerInstaller/scripts/
RUN mkdir -p /home/vagrant/dockerws/chatServerInstaller/src/
WORKDIR /home/vagrant/dockerws/chatServerInstaller

#Copy all the required files from host's file system to the container file system.
COPY setup/target/scripts/install_x.sh scripts/
COPY setup/target/scripts/install_y.sh scripts/
COPY src/ src/
``````

Command used to build the docker image

``````docker build -t test:latest -f setup/docker/Dockerfile .
``````

### How to debug a stored procedure in Toad?

Open a PL/SQL object in the Editor.

Click on the main toolbar or select Session | Toggle Compiling with Debug. This enables debugging.

Compile the object on the database.

Select one of the following options on the Execute toolbar to begin debugging: Execute PL/SQL with debugger () Step over Step into Run to cursor

### Eliminate extra separators below UITableView

You can remove separator of empty rows by just adding minor height of footer

``````func tableView(_ tableView: UITableView, heightForFooterInSection section: Int) -> CGFloat {
return 0.01
}
``````

### In WPF, what are the differences between the x:Name and Name attributes?

`x:Name` means: create a field in the code behind to hold a reference to this object.

`Name` means: set the name property of this object.

### How can I remove 3 characters at the end of a string in php?

Just do:

``````echo substr(\$string, 0, -3);
``````

You don't need to use a `strlen` call, since, as noted in the substr docs:

If length is given and is negative, then that many characters will be omitted from the end of string

### How do you reverse a string in place in JavaScript?

``````function reverse_string(string)
{
var string;

var len = string.length;

var stringExp = string.split('');
var i;
for (i = len-1; i >=0;i--)
{
var result = document.write(stringExp[i]);
}

return result;
}

reverse_string("This is a reversed string");
``````

//outputs: gnirts desrever a si sihT

### Dictionary of dictionaries in Python?

Using `collections.defaultdict` is a big time-saver when you're building dicts and don't know beforehand which keys you're going to have.

Here it's used twice: for the resulting dict, and for each of the values in the dict.

``````import collections

def aggregate_names(errors):
result = collections.defaultdict(lambda: collections.defaultdict(list))
for real_name, false_name, location in errors:
result[real_name][false_name].append(location)
return result
``````

``````dictionary = aggregate_names(previousFunction(string))
``````

Or to test:

``````EXAMPLES = [
('Jim', 'Jam', 100),
('Fred', 'Frod', 200),
print aggregate_names(EXAMPLES)
``````

### Using wire or reg with input or output in Verilog

basically reg is used to store values.For example if you want a counter(which will count and thus will have some value for each count),we will use a reg. On the other hand,if we just have a plain signal with 2 values 0 and 1,we will declare it as wire.Wire can't hold values.So assigning values to wire leads to problems....

### How do I compute the intersection point of two lines?

Here is a solution using the Shapely library. Shapely is often used for GIS work, but is built to be useful for computational geometry. I changed your inputs from lists to tuples.

# Problem

``````# Given these endpoints
#line 1
A = (X, Y)
B = (X, Y)

#line 2
C = (X, Y)
D = (X, Y)

# Compute this:
point_of_intersection = (X, Y)
``````

# Solution

``````import shapely
from shapely.geometry import LineString, Point

line1 = LineString([A, B])
line2 = LineString([C, D])

int_pt = line1.intersection(line2)
point_of_intersection = int_pt.x, int_pt.y

print(point_of_intersection)
``````

### What is the difference between "INNER JOIN" and "OUTER JOIN"?

In simple words :

Inner join -> Take ONLY common records from parent and child tables WHERE primary key of Parent table matches Foreign key in Child table.

Left join ->

pseudo code

``````1.Take All records from left Table
2.for(each record in right table,) {
if(Records from left & right table matching on primary & foreign key){
use their values as it is as result of join at the right side for 2nd table.
} else {
put value NULL values in that particular record as result of join at the right side for 2nd table.
}
}
``````

Right join : Exactly opposite of left join . Put name of table in LEFT JOIN at right side in Right join , you get same output as LEFT JOIN.

Outer join : Show all records in Both tables `No matter what`. If records in Left table are not matching to right table based on Primary , Forieign key , use NULL value as result of join .

Example :

Lets assume now for 2 tables

`1.employees , 2.phone_numbers_employees`

``````employees : id , name

phone_numbers_employees : id , phone_num , emp_id
``````

Here , employees table is Master table , phone_numbers_employees is child table(it contains `emp_id` as foreign key which connects `employee.id` so its child table.)

Inner joins

Take the records of 2 tables ONLY IF Primary key of employees table(its id) matches Foreign key of Child table phone_numbers_employees(emp_id).

So query would be :

``````SELECT e.id , e.name , p.phone_num FROM employees AS e INNER JOIN phone_numbers_employees AS p ON e.id = p.emp_id;
``````

Here take only matching rows on primary key = foreign key as explained above.Here non matching rows on primary key = foreign key are skipped as result of join.

Left joins :

Left join retains all rows of the left table, regardless of whether there is a row that matches on the right table.

``````SELECT e.id , e.name , p.phone_num FROM employees AS e LEFT JOIN phone_numbers_employees AS p ON e.id = p.emp_id;
``````

Outer joins :

``````SELECT e.id , e.name , p.phone_num FROM employees AS e OUTER JOIN phone_numbers_employees AS p ON e.id = p.emp_id;
``````

Diagramatically it looks like :

### How do I create a new user in a SQL Azure database?

I followed the answers here but when I tried to connect with my new user, I got an error message stating `"The server principal 'newuser' is not able to access the database 'master' under the current security context"`.

I had to also create a new user in the master table to successfully log in with SSMS.

``````USE [master]
GO
GO
CREATE USER [newuser] FOR LOGIN [newuser] WITH DEFAULT_SCHEMA=[dbo]
GO

USE [MyDatabase]
CREATE USER newuser FOR LOGIN newuser WITH DEFAULT_SCHEMA = dbo
GO
GO
``````

### Open Windows Explorer and select a file

Check out this snippet:

``````Private Sub openDialog()
Dim fd As Office.FileDialog

Set fd = Application.FileDialog(msoFileDialogFilePicker)

With fd

.AllowMultiSelect = False

' Set the title of the dialog box.
.Title = "Please select the file."

' Clear out the current filters, and add our own.
.Filters.Clear

' Show the dialog box. If the .Show method returns True, the
' user picked at least one file. If the .Show method returns
' False, the user clicked Cancel.
If .Show = True Then
txtFileName = .SelectedItems(1) 'replace txtFileName with your textbox

End If
End With
End Sub
``````

I think this is what you are asking for.

### How do I search for an object by its ObjectId in the mongo console?

If you're using Node.js:

In that req.user is ObjectId format.

``````var mongoose = require("mongoose");
var ObjectId = mongoose.Schema.Types.ObjectId;

function getUsers(req, res)
.then(data => {
res.send(data);})g
}
exports.getUsers = getUsers;
``````