Adam J. Weigold aweigold

CTO & Founder @irulast

estysdesu / create_constraint_if_not_exists.sql

Last active September 13, 2023 00:17

[PostgreSQL: create constraint if not exists] not sure of sql compatibility with other engines #postgres #constraint #sql

	// vim: syntax=sql

	CREATE OR REPLACE FUNCTION create_constraint_if_not_exists (t_name text, c_name text, constraint_sql text)
	RETURNS void
	AS
	$BODY$
	BEGIN
	-- Look for our constraint
	IF NOT EXISTS (SELECT constraint_name
	FROM information_schema.constraint_column_usage

SlyDen / Application.java

Created March 7, 2014 09:41

Sample of Spring Boot config with custom setting for embedded Tomcat And OAuth ... imports are skiped. https://github.com/joshlong/the-spring-rest-stack/blob/master/code/web/oauth/src/main/java/com/jl/crm/web/Application.java

	@ComponentScan
	@Import(ServiceConfiguration.class)
	@EnableHypermediaSupport(type = EnableHypermediaSupport.HypermediaType.HAL)
	@EnableAutoConfiguration
	public class Application extends SpringBootServletInitializer {
	private static Class<Application> applicationClass = Application.class;

	public static void main(String[] args) {
	SpringApplication.run(applicationClass);
	}