t.eduLevel = function(){
mysql.live.getConnection(function(err, conn){
if( err ){
t.emit('find_error', {error: err.toString()});
}else{
var strSQL = "SELECT * FROM edu_level";
conn.query(strSQL, function(err, rows){
if( err ){
t.emit('find_error', {error: err.toString()});
}else{
t.emit('find_success', rows);
}
});
}
});
}
t.state = function(){
mysql.live.getConnection(function(err, conn){
if( err ){
t.emit('find_error', {error: err.toString()});
}else{
var strSQL = "SELECT * FROM state WHERE country_id=127";
conn.query(strSQL, function(err, rows){
if( err ){
t.emit('find_error', {error: err.toString()});
}else{
t.emit('find_success', rows);
}
});
}
});
}
t.jobRole = function(){
mysql.live.getConnection(function(err, conn){
if( err ){
t.emit('find_error', {error: err.toString()});
}else{
var strSQL = "SELECT * FROM job_role WHERE id >= 200";
conn.query(strSQL, function(err, rows){
if( err ){
t.emit('find_error', {error: err.toString()});
}else{
t.emit('find_success', rows);
}
});
}
});
}
t.city = function(state){
mysql.live.getConnection(function(err, conn){
if( err ){
t.emit('find_error', {error: err.toString()});
}else{
var param = [];
var strSQL = "SELECT * FROM city WHERE state_id=?";
param.push(state);
conn.query(strSQL, param, function(err, rows){
if( err ){
t.emit('find_error', {error: err.toString()});
}else{
t.emit('find_success', rows);
}
});
}
});
}