Skip to content

Instantly share code, notes, and snippets.

View ladekjaer's full-sized avatar

Rasmus Ladekjær Pedersen ladekjaer

View GitHub Profile

Keybase proof

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:

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