I hereby claim:
- I am ladekjaer on github.
- I am ladekjaer (https://keybase.io/ladekjaer) on keybase.
- I have a public key ASCGlNnekeQZ54BYOTz5Q_-8CAyd95EinHGFbhxjTNSKMwo
To claim this, I am signing this object:
I hereby claim:
To claim this, I am signing this object:
var fs = require('fs') | |
var crypto = require('crypto') | |
var sqlite3 = require('sqlite3').verbose() | |
var db = new sqlite3.Database('./sqlite.db') | |
function getFiles(directory) { | |
var current = fs.readdirSync(directory) | |
for (var i in current) { | |
var file = directory + '/' + current[i] | |
if (fs.statSync(file).isDirectory()) { |
CREATE VIEW dbo.customerlist AS | |
SELECT | |
CU.CustomerID | |
, CU.TPID | |
, CU.CustomerName | |
, S.StatusName | |
, CA.CampaignName | |
, CU.Adress | |
, CU.Postalcode | |
, CU.City |
CREATE VIEW dbo.customerlist as | |
SELECT | |
dbo.customers.CustomerID | |
, dbo.customers.TPID | |
, dbo.customers.CustomerName | |
, dbo.status.StatusName | |
, dbo.campaigns.CampaignName | |
, dbo.customers.Adress | |
, dbo.customers.Postalcode | |
, dbo.customers.City |