Skip to content

Instantly share code, notes, and snippets.

View vrySantosh's full-sized avatar
🎯
Focus is an art!

Santosh Guruju vrySantosh

🎯
Focus is an art!
22 followers · 92 following
View GitHub Profile
@vrySantosh
vrySantosh / gist:98d0e89d07422ca742e9bbd993f3737e
Last active October 12, 2020 07:25
Swift Closures
import UIKit
// External closure declaration
// Closure with arguments
let sampleClosure :(String) -> (String) = { value in
print(value)
return "sample closure return value"
}
@vrySantosh
vrySantosh / Catching SQL Server Exception
Last active July 20, 2020 10:23
StringBuilder errorMessages = new StringBuilder();
catch (SqlException ex)
{
for (int i = 0; i < ex.Errors.Count; i++)
{
errorMessages.Append("Index #" + i + "\n" +
"Message: " + ex.Errors[i].Message + "\n" +
"LineNumber: " + ex.Errors[i].LineNumber + "\n" +
"Source: " + ex.Errors[i].Source + "\n" +
"Procedure: " + ex.Errors[i].Procedure + "\n");
@vrySantosh
vrySantosh / Inner Join 3 tables
Created July 13, 2020 08:29
SELECT o.OrderID,
o.CustomerID,
o.ProductID,
o.Status,
c.Name as CName,
p.Name as PName,
p.PRICE
FROM Orders o
INNER JOIN Customers c
on o.CustomerID = c.CustomerID
@vrySantosh
vrySantosh / Create Tables Query - SE Bootcamp
Last active July 7, 2020 07:42
--CREATE SCHEMA AllYouNeed;
--CREATE TABLE Customers(
-- CustomerID INT IDENTITY(1,1),
-- Name VARCHAR(50) NOT NULL,
-- Email VARCHAR(50) NOT NULL,
-- CONSTRAINT PK_Customer PRIMARY KEY (CustomerID)
-- );
--CREATE TABLE Products(
@vrySantosh
vrySantosh / Delete Table Row HTML
Created July 6, 2020 00:40
<table id="dsTable">
<tbody>
<tr>
<td>Relationship Type</td>
<td>Date of Birth</td>
<td>Gender</td>
</tr>
<tr>
<td>Spouse</td>
@vrySantosh
vrySantosh / xcrun can't find Xcode path
Created September 26, 2017 07:53
sudo /usr/bin/xcode-select -switch /Applications/Xcode.app/Contents/Developer
@vrySantosh
vrySantosh / filter and filter_by in SQLAlchemy
Created September 14, 2017 10:08
It is a syntax sugar for faster query writing. Its implementation in pseudocode:
def filter_by(self, **kwargs):
return self.filter(sql.and_(**kwargs))
For AND you can simply write:
Users.query.filter_by(name='Joe', surname='Dodson')
btw
db.users.filter(or_(db.users.name=='Ryan', db.users.country=='England'))
@vrySantosh
vrySantosh / Flask - Pagination
Created September 6, 2017 04:10
from flask import Flask, abort, request, jsonify
from models import Event
app = Flask(__name__)
@app.route('/api/v2/events/page')
def view():
return jsonify(get_paginated_list(
Event,
'/api/v2/events/page',