sqlite query using string as parameter in python

sqlite query using string as parameter in python

import sqlite3 conector = sqlite3.connect(“database.db”) cursor = conector.cursor() string = “Some interesting stuff” cursor.execute(“SELECT * FROM table WHERE item = ?”, [string]) Here is what the above code is Doing: 1. Connect to the database. 2. Create a cursor object. 3. Create a string variable. 4. Execute a query that uses the string variable. The…

compare string camelcase and lowercase javascript

compare string camelcase and lowercase javascript

var text = ‘helloThereMister’; var result = text.replace( /([A-Z])/g, ” $1″ ); var finalResult = result.charAt(0).toUpperCase() + result.slice(1); console.log(finalResult); Here is what the above code is Doing: 1. We’re using the replace() method to replace all capital letters with a space and the capital letter. 2. We’re using the charAt() method to get the first…

add jquery angular

add jquery angular

declare var $:any; Here is what the above code is Doing: 1. We are importing the Component decorator from the @angular/core library. 2. We are importing the OnInit interface from the @angular/core library. 3. We are importing the Router service from the @angular/router library. 4. We are importing the AuthenticationService service from the ./authentication.service.ts file….