Ttgjyuk

Should I outline or discovery write my stories?

WiFi Thermostat, No C Terminal on Furnace

Argument list too long when zipping large list of certain files in a folder

How much character growth crosses the line into breaking the character

What is this called? Old film camera viewer?

How to bake one texture for one mesh with multiple textures blender 2.8

Is there a name for this algorithm to calculate the concentration of a mixture of two solutions containing the same solute?

If a character has darkvision, can they see through an area of nonmagical darkness filled with lightly obscuring gas?

Where does the bonus feat in the cleric starting package come from?

Is it safe to use olive oil to clean the ear wax?

What should you do if you miss a job interview (deliberately)?

Longest common substring in linear time

Yosemite Fire Rings - What to Expect?

GraphicsGrid with a Label for each Column and Row

Fear of getting stuck on one programming language / technology that is not used in my country

Drawing ramified coverings with tikz

Is the U.S. Code copyrighted by the Government?

Why does the Sun have different day lengths, but not the gas giants?

Can I sign legal documents with a smiley face?

What was the exact wording from Ivanhoe of this advice on how to free yourself from slavery?

How to explain what's wrong with this application of the chain rule?

Offered money to buy a house, seller is asking for more to cover gap between their listing and mortgage owed

What should you do when eye contact makes your subordinate uncomfortable?

How do I color the graph in datavisualization?

Loopback 3.0 MySQL discoverSchemas not returning data

How to I move MySQL data files onto different partition?MySQL Data Modeling on netbookHow can I load XML data into a MySQL database?Move mysql data dir to TrueCrypt volumeLoading data into mysql databaseFirewall blocking mySQL portMysql data provider for TORAError Changing MYSQL Data Directoryhow to extract data from a mysqlCan not insert data mysql using python with pymysql

0

I am having an issue when trying to obtain data from a MySQL database using LoopBack when I createModel. I am not getting any database back but there's data in the table. I get the following return [] which is an empty bracket.

Below is the code.

async function discover()

const options = relations: true;
dSource = loopback.createDataSource('sqlData', 
 "host": "000.000.000.000",
 "port": 3306,
 "database": "devDatabase",
 "username": "application",
 "password": "password123",
 "name": "sqlData",
 "connector": "mysql"
);

console.log('Position 1');

//var model_test = await dSource.discoverSchemas('app_alerts', options);

model_test = "app_alerts":"name":"AppAlerts","options":"idInjection":false,"mysql":"schema":"apiAuthoCustomerDB-Dev","table":"app_alerts","relations":,"properties":"alertId":"type":"Number","required":true,"length":null,"precision":10,"scale":0,"id":1,"mysql":"columnName":"alert_id","dataType":"int","dataLength":null,"dataPrecision":10,"dataScale":0,"nullable":"N","alert":"type":"String","required":false,"length":45,"precision":null,"scale":null,"mysql":"columnName":"alert","dataType":"varchar","dataLength":45,"dataPrecision":null,"dataScale":null,"nullable":"Y"

console.log('Position 2');

var modelSchemas = dSource.createModel('app_alerts', model_test);

console.log('Position 3');

modelSchemas.find(function(err, user) 
 console.log('Position 4');
 console.log(user);
);

discover();

mysql nodejs

share|improve this question

asked 10 mins ago

MatthewMatthew

1

New contributor

Matthew is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

I am having an issue when trying to obtain data from a MySQL database using LoopBack when I createModel. I am not getting any database back but there's data in the table. I get the following return [] which is an empty bracket.

Below is the code.

async function discover()

const options = relations: true;
dSource = loopback.createDataSource('sqlData', 
 "host": "000.000.000.000",
 "port": 3306,
 "database": "devDatabase",
 "username": "application",
 "password": "password123",
 "name": "sqlData",
 "connector": "mysql"
);

console.log('Position 1');

//var model_test = await dSource.discoverSchemas('app_alerts', options);

model_test = "app_alerts":"name":"AppAlerts","options":"idInjection":false,"mysql":"schema":"apiAuthoCustomerDB-Dev","table":"app_alerts","relations":,"properties":"alertId":"type":"Number","required":true,"length":null,"precision":10,"scale":0,"id":1,"mysql":"columnName":"alert_id","dataType":"int","dataLength":null,"dataPrecision":10,"dataScale":0,"nullable":"N","alert":"type":"String","required":false,"length":45,"precision":null,"scale":null,"mysql":"columnName":"alert","dataType":"varchar","dataLength":45,"dataPrecision":null,"dataScale":null,"nullable":"Y"

console.log('Position 2');

var modelSchemas = dSource.createModel('app_alerts', model_test);

console.log('Position 3');

modelSchemas.find(function(err, user) 
 console.log('Position 4');
 console.log(user);
);

discover();

mysql nodejs

share|improve this question

asked 10 mins ago

MatthewMatthew

1

New contributor

Matthew is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

I am having an issue when trying to obtain data from a MySQL database using LoopBack when I createModel. I am not getting any database back but there's data in the table. I get the following return [] which is an empty bracket.

Below is the code.

async function discover()

const options = relations: true;
dSource = loopback.createDataSource('sqlData', 
 "host": "000.000.000.000",
 "port": 3306,
 "database": "devDatabase",
 "username": "application",
 "password": "password123",
 "name": "sqlData",
 "connector": "mysql"
);

console.log('Position 1');

//var model_test = await dSource.discoverSchemas('app_alerts', options);

model_test = "app_alerts":"name":"AppAlerts","options":"idInjection":false,"mysql":"schema":"apiAuthoCustomerDB-Dev","table":"app_alerts","relations":,"properties":"alertId":"type":"Number","required":true,"length":null,"precision":10,"scale":0,"id":1,"mysql":"columnName":"alert_id","dataType":"int","dataLength":null,"dataPrecision":10,"dataScale":0,"nullable":"N","alert":"type":"String","required":false,"length":45,"precision":null,"scale":null,"mysql":"columnName":"alert","dataType":"varchar","dataLength":45,"dataPrecision":null,"dataScale":null,"nullable":"Y"

console.log('Position 2');

var modelSchemas = dSource.createModel('app_alerts', model_test);

console.log('Position 3');

modelSchemas.find(function(err, user) 
 console.log('Position 4');
 console.log(user);
);

discover();

mysql nodejs

share|improve this question

asked 10 mins ago

MatthewMatthew

1

New contributor

Matthew is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

const options = relations: true;
dSource = loopback.createDataSource('sqlData', 
 "host": "000.000.000.000",
 "port": 3306,
 "database": "devDatabase",
 "username": "application",
 "password": "password123",
 "name": "sqlData",
 "connector": "mysql"
);

console.log('Position 1');

//var model_test = await dSource.discoverSchemas('app_alerts', options);

model_test = "app_alerts":"name":"AppAlerts","options":"idInjection":false,"mysql":"schema":"apiAuthoCustomerDB-Dev","table":"app_alerts","relations":,"properties":"alertId":"type":"Number","required":true,"length":null,"precision":10,"scale":0,"id":1,"mysql":"columnName":"alert_id","dataType":"int","dataLength":null,"dataPrecision":10,"dataScale":0,"nullable":"N","alert":"type":"String","required":false,"length":45,"precision":null,"scale":null,"mysql":"columnName":"alert","dataType":"varchar","dataLength":45,"dataPrecision":null,"dataScale":null,"nullable":"Y"

console.log('Position 2');

var modelSchemas = dSource.createModel('app_alerts', model_test);

console.log('Position 3');

modelSchemas.find(function(err, user) 
 console.log('Position 4');
 console.log(user);
);

share|improve this question

asked 10 mins ago

MatthewMatthew

1

New contributor

Matthew is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this question

asked 10 mins ago

MatthewMatthew

1

New contributor

Matthew is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 10 mins ago

MatthewMatthew

1

New contributor

Matthew is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 10 mins ago

MatthewMatthew

1