stdavis

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Main]') AND type in (N'U'))
DROP TABLE [Main]
GO
 
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Related]') AND type in (N'U'))
DROP TABLE [Related]
GO
 
CREATE TABLE [Main](
	[id] [int] NOT NULL,

stdavis

USE [UGSWaterChemistry]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

DROP TABLE [dbo].[Results]

stdavis

// #1
array.forEach(criteria, lang.hitch(this, function(crit) {
    if (crit && crit.ingredients) {
        filter = this._formSqlInQueryFromArray(crit.ingredients);
        filters.push( crit.field + ' IN (' + filter + ')');
    }
}));

// #2
array.forEach(criteria, function(crit) {

stdavis

/*global define,location */
/*jslint sloppy:true */
/*
 | Copyright 2014 Esri
 |
 | Licensed under the Apache License, Version 2.0 (the "License");
 | you may not use this file except in compliance with the License.
 | You may obtain a copy of the License at
 |
 |    http://www.apache.org/licenses/LICENSE-2.0

stdavis

SELECT OBJECTID from Stations WHERE
  StationId IN (SELECT StationId from Results WHERE ParamGroup = 'Inorganics, Major, Non-metals') AND
  StationId IN (SELECT StationId from Results WHERE ParamGroup = 'Organics, pesticide') AND
  StationId IN (SELECT StationId from Results WHERE ParamGroup = 'Physical')

stdavis

StationId IN (SELECT StationId from Results WHERE ParamGroup = 'Inorganics, Major, Non-metals') AND
StationId IN (SELECT StationId from Results WHERE ParamGroup = 'Organics, pesticide') AND
StationId IN (SELECT StationId from Results WHERE ParamGroup = 'Physical')

stdavis

var config = {
    publishServices: {
        options: {
            // Any service props defined here are applied to all services.
            minInstancesPerNode: 1,
            maxInstancesPerNode: 3,

            // This will also be a place to hold task-specific options.
            server: {
                username: 'hello',

stdavis

# Update OGM Well and Bottom HoleData
# 7-19-11
# Scott Davis - stdavis@utah.gov
# Bert Granberg - bgranberg@utah.gov
#
# Updated by Scott 6-3-13

import arcpy, os, itertools
from agrc import logging, email, arcpy_helpers

stdavis

language: node_js
node_js:
  - '0.10'
before_install:
  - npm install -g grunt-cli
  - npm install -g bower
  - npm install
  - bower install
notifications:
  email:

stdavis

require([
    // imports go here
], function (
    // import parameters go here
    ) {
    // code goes here
    function init() {
        ...
    }
});