Matt Dalesio dalmat36

dalmat36 / GroovyInsertPersonOutputIdParameter.groovy

Last active August 29, 2015 14:25

Insert a person with Groovy and return the ID as an output parameter

	import groovy.sql.Sql;

	import java.sql.Connection
	import java.sql.DriverManager;
	import java.sql.SQLException;
	import java.util.Properties;



	class GroovyInsertPersonOutputIdParameter {

dalmat36 / GroovySQLTesting.groovy

Created July 9, 2015 20:42

Simple SQL Insert / Select with Groovy

	import groovy.sql.Sql;

	import java.sql.Connection
	import java.sql.DriverManager;
	import java.sql.SQLException;
	import java.util.Properties;


	class GroovySQLTesting {

dalmat36 / CopyDataToNewTable.sql

Created June 26, 2015 14:27

This SQL snippet copies data from one table to a new table in a different database

	select * into [new_database]..tbl_MY_TABLE
	from [old_database]..tbl_MY_TABLE

dalmat36 / MorphiaGettingStartedEmployees.java

Last active August 29, 2015 14:21

This is the employee class required to do the examples at http://mongodb.github.io/morphia/1.0/getting-started/quick-tour/

	package com.mattdalesio.morphiaTesting;

	import java.util.ArrayList;
	import java.util.List;

	import org.bson.types.ObjectId;
	import org.mongodb.morphia.annotations.*;

	@Entity("employees")
	@Indexes(

dalmat36 / MorphiaGettingStartedMain.java

Last active August 29, 2015 14:21

This gist is the example code required to perform the examples shown on http://mongodb.github.io/morphia/1.0/getting-started/quick-tour/

	package com.mattdalesio.morphiaTesting;

	import java.util.List;

	import org.mongodb.morphia.Datastore;
	import org.mongodb.morphia.Morphia;
	import org.mongodb.morphia.query.Query;
	import org.mongodb.morphia.query.UpdateOperations;
	import org.mongodb.morphia.query.UpdateResults;

dalmat36 / IntroHibernate-Basic Mapping- Saving Data-User

Created May 11, 2015 19:11

dalmat36 / Intro Hibernate-Basic Mapping- Saving Data-ProteinTracker

Last active August 29, 2015 14:20

Introduction to Hibernate Basic Mapping Saving some data

	package hibernate;

	import org.hibernate.Session;

	public class ProteinTracker {

	public static void main(String[] args) {
	Session session = hibernateUtils.getSessionFactory().openSession();
	session.beginTransaction();

dalmat36 / Intro to Hibernate Session

Last active August 29, 2015 14:20

Creating the session for Hibernate ORM (newer version with StandardServiceRegistryBuilder)

	package hibernate;

	import org.hibernate.SessionFactory;
	import org.hibernate.boot.registry.StandardServiceRegistryBuilder;
	import org.hibernate.cfg.Configuration;
	import org.hibernate.service.ServiceRegistry;



	public class hibernateUtils {

dalmat36 / Atomic Updates 76jCKfW2Mr8

Created May 6, 2015 15:07

Webinar: Introduction to using MongoDB and Spring Data on Cloud Foundry

	comment = {"author": "fred",
	"date": new Date(),
	"text": "Best Movie Ever"}
	db.posts.update({"_id": ObjectId("554a2380df506c53b1a78647")}, {$push:{"comments": comment}});

dalmat36 / Conditional Query Operators 76jCKfW2Mr8

Created May 6, 2015 14:55

Webinar: Introduction to using MongoDB and Spring Data on Cloud Foundry

	//find posts with any tags
	db.posts.find({tags:{$exists:true}}).pretty()

	//find posts matching a regular expression
	db.posts.find({author:/^rog*/i}).pretty()

	//count posts by author
	db.posts.find({author: 'roger'}).count()