Skip to content

Instantly share code, notes, and snippets.

@zero5100
Last active August 29, 2015 14:22
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save zero5100/0c574f393da246ae121e to your computer and use it in GitHub Desktop.
Save zero5100/0c574f393da246ae121e to your computer and use it in GitHub Desktop.
// Test when ran using the postgresql connector
// Create a new instance of the model
loopback:connector:postgresql SQL: INSERT INTO "public"."phone_cdr"("caller_name","caller_number","phone_number_dialed","call_start_date_gmt","call_status") VALUES($1,$2,$3,to_timestamp($4,'yyyy-mm-dd hh24:mi:ss.ms'),$5) RETURNING "id"
Parameters: ["test","1234567","7654321","2015-01-01T00:00:00.000Z","A"] +465ms
loopback:connector:postgresql {
"command": "INSERT",
"rowCount": 1,
"oid": 0,
"rows": [{
"id": 246
}],
"fields": [{
"name": "id",
"tableID": 16894,
"columnID": 1,
"dataTypeID": 23,
"dataTypeSize": 4,
"dataTypeModifier": -1,
"format": "text"
}],
"_parsers": [null],
"rowAsArray": false
} +4ms
// Value of returned model
{
callerName: 'test',
callerNumber: '1234567',
phoneNumberDialed: '7654321',
callStartDate: Wed Dec 31 2014 18:00:00 GMT-0600 (CST),
callStatus: 'A',
id: 246
}
// Perform a find by id to get the same model
loopback:connector:postgresql SQL: SELECT "id","caller_name","caller_number","phone_number_dialed","phone_number_answered","call_start_date_gmt","call_duration","call_status","call_type" FROM "public"."phone_cdr" WHERE "id"=$1 ORDER BY "id"
Parameters: [246] +3ms
loopback:connector:postgresql {
"command": "SELECT",
"rowCount": 1,
"oid": null,
"rows": [{
"id": 246,
"caller_name": "test",
"caller_number": "1234567",
"phone_number_dialed": "7654321",
"phone_number_answered": null,
"call_start_date_gmt": "2015-01-01T06:00:00.000Z",
"call_duration": null,
"call_status": "A",
"call_type": null
}],
"fields": [{
"name": "id",
"tableID": 16894,
"columnID": 1,
"dataTypeID": 23,
"dataTypeSize": 4,
"dataTypeModifier": -1,
"format": "text"
},
{
"name": "caller_name",
"tableID": 16894,
"columnID": 2,
"dataTypeID": 1043,
"dataTypeSize": -1,
"dataTypeModifier": 68,
"format": "text"
},
{
"name": "caller_number",
"tableID": 16894,
"columnID": 3,
"dataTypeID": 1043,
"dataTypeSize": -1,
"dataTypeModifier": 19,
"format": "text"
},
{
"name": "phone_number_dialed",
"tableID": 16894,
"columnID": 4,
"dataTypeID": 1043,
"dataTypeSize": -1,
"dataTypeModifier": 19,
"format": "text"
},
{
"name": "phone_number_answered",
"tableID": 16894,
"columnID": 5,
"dataTypeID": 1043,
"dataTypeSize": -1,
"dataTypeModifier": 19,
"format": "text"
},
{
"name": "call_start_date_gmt",
"tableID": 16894,
"columnID": 9,
"dataTypeID": 1114,
"dataTypeSize": 8,
"dataTypeModifier": -1,
"format": "text"
},
{
"name": "call_duration",
"tableID": 16894,
"columnID": 6,
"dataTypeID": 1043,
"dataTypeSize": -1,
"dataTypeModifier": 68,
"format": "text"
},
{
"name": "call_status",
"tableID": 16894,
"columnID": 7,
"dataTypeID": 1043,
"dataTypeSize": -1,
"dataTypeModifier": 14,
"format": "text"
},
{
"name": "call_type",
"tableID": 16894,
"columnID": 8,
"dataTypeID": 1043,
"dataTypeSize": -1,
"dataTypeModifier": 24,
"format": "text"
}],
"_parsers": [null,
null,
null,
null,
null,
null,
null,
null,
null],
"rowAsArray": false
} +4ms
// Same object that is returned
[ {
id: 246,
callerName: 'test',
callerNumber: '1234567',
phoneNumberDialed: '7654321',
phoneNumberAnswered: null,
callStartDate: Thu Jan 01 2015 00:00:00 GMT-0600 (CST),
callDuration: null,
callStatus: 'A',
callType: null
}]
// Same test ran with the memory connector instead of the postgresql connector
// Model that was created
{
callerName: 'test',
callerNumber: '1234567',
phoneNumberDialed: '7654321',
callStartDate: Wed Dec 31 2014 18:00:00 GMT-0600 (CST),
callStatus: 'A',
id: 1
}
// Result from the find
[ {
callerName: 'test',
callerNumber: '1234567',
phoneNumberDialed: '7654321',
callStartDate: Wed Dec 31 2014 18:00:00 GMT-0600 (CST),
callStatus: 'A',
id: 1
} ]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment