monkeyhouse

View this code at http://livecoding.io/8061672

monkeyhouse

<link rel="import" href="../polymer/polymer.html">

<polymer-element name="my-element">

  <template>
    <style>    
      :host {
        position: absolute;
        width: 100%;
        height: 100%;

monkeyhouse

npm install selectize - save
npm install jquery -save 

add this to the aurelia.json file in the dependencies section of the vendor bundle 

"jquery",

{
            "name": "selectize",
            "path": "../node_modules/selectize/dist",

monkeyhouse

import {autoinject, bindable, bindingMode} from 'aurelia-framework';

/***
* created to : attach custom font-awesome class name to icon 
* renders font-awsome class named based on parameters extension and type 
* both parameters are required, always

*
* if you only need to bind a signle paremter, use the single value binding approach instead because its cleaner
* http://aurelia.io/hub.html#/doc/article/aurelia/templating/latest/templating-custom-attributes/4

monkeyhouse

<template>
    <!-- require icon here or in resources file-->  
   
    <!--  this attribute converts file extensions into the font awesome icon, not comprehensive
          basically copy pasta'd most of lookup table from elsewhere --> 
    
    <i class="fa fa-5x" icon="file-xls"></i>
</template>

monkeyhouse

steps to install fetch

npm install whatwg-fetch --save 
npm install aurelia-fetch-client --save

in aurelia.json, add thse to the vendor-bundle.js
"aurelia-fetch-client",
{
 "name": "whatwg-fetch",
 "path": "../node_modules/whatwg-fetch",

monkeyhouse

declare @db_to   varchar(100) = '[to].[dbo].' 
declare @db_from varchar(100) = '[from].[dbo].'
declare @tables varchar(1000) = 'TABLE1,TABLE2,TABLE3'

declare @copy_scripts table 
(
	id			   integer identity(1,1),
	table_name     varchar(200),
	copy_statement varchar(4000),
	id_insert_on   varchar(200),