Skip to content

Instantly share code, notes, and snippets.

@joniden
joniden / cities_mssql.sql
Last active October 19, 2020 09:03
Cities
CREATE TABLE Cities (
id INT NOT NULL IDENTITY(1, 1),
City varchar(255),
Region varchar(50) default NULL,
Country varchar(100) default NULL,
PRIMARY KEY (id)
)
INSERT INTO Cities (City,Region,Country) VALUES ('Medellín','Antioquia','Nauru'),('Ovalle','IV','Botswana'),('Peñaflor','RM','Grenada'),('Kashmore','SI','Sierra Leone'),('El Bosque','Metropolitana de Santiago','Mauritania'),('Berlin','Berlin','Zimbabwe'),('Castres','Midi-Pyrénées','Belarus'),('Makassar','South Sulawesi','Pitcairn Islands'),('Heist-aan-Zee','WV','Monaco'),('Mexico City','CDM','Kenya');
INSERT INTO Cities (City,Region,Country) VALUES ('Pinarbasi','Kayseri','Luxembourg'),('Murcia','Murcia','Peru'),('Warren','Michigan','Bhutan'),('Remscheid','NW','Cuba'),('Logan City','Queensland','Sao Tome and Principe'),('Noisy-le-Grand','Île-de-France','Puerto Rico'),('Huancayo','Junín','South Sudan'),('Kapuskasing','ON','Tajikistan'),('Waiheke Island','NI','Colombia'),('Ribeirão Preto','SP','Zimbabwe');
@joniden
joniden / insert1.sql
Last active October 19, 2022 08:37
Insert form 1
INSERT INTO form (question_id, answer)
VALUES
(1, 'YES'),
(1, 'NO'),
(1, 'YES'),
(1, 'NO'),
(1, 'YES'),
(1, 'NO'),
(2, 'YES'),
(2, 'NO'),
@joniden
joniden / contentView.swift
Created June 18, 2020 12:13
Help swiftui gethttpsdata
import SwiftUI
class ContentViewData: ObservableObject {
@Published var myTextFieldText: String = ""
func getdata() {
Network.getHttpsData()
}
}
struct ContentView: View {
@ObservedObject var contentViewData = ContentViewData()
@joniden
joniden / PinStackView.swift
Created May 27, 2020 06:10
OTP Pin code view, hidden text field and enter single digit in each text field
import SwiftUI
import Introspect
/**
Used like this:
PinStackView { pin, success in
self.passCodeFilled = success
}