Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Meteor.startup(function () {
- var Request = Npm.require('tedious').Request;
- var Fiber = Npm.require('fibers');
- arrTest = new Meteor.EnvironmentVariable;
- function insrtInto (dataInfo) {
- //var finer = Fiber.current;
- //finer.run (function (){
- // console.log('running.........');
- // console.log (AccountSummary.find().count());
- /// console.log(dataInfo);
- //return 'yes'
- /// })
- // var results = Fiber.yield();
- // return results ;
- };
- function executeStatement() {
- //arrry = [];
- // Fiber ( function () {
- request = new Request("select * from AccountSummary", function(err, rowCount, rows) {
- if (err) {
- console.log(err);
- } else {
- console.log(rowCount + ' rows');
- //arrTest.withValue(rows);
- // Fiber(function(){
- // insrtInto ( rows);
- // }).run();
- // for (var iter = 0; iter < rows.length;iter++ );
- }
- });
- // }).run();
- request.on('row', function(columns) {
- columns.forEach(function(column) {
- console.log(column.value);
- });
- });
- // request.on('done', function(rowCount, more, rows) {
- // console.log("am done");
- // console.log(rows);
- // console.log("///end");
- // });
- connection.execSql(request);
- //return arrry;
- }
- var Connection = Npm.require('tedious').Connection;
- var config = {
- userName: 'xxxx',
- password: 'xxxxx',
- server: 'xxx.xxx.xxx.xxx',
- // If you're on Windows Azure, you will need this:
- options: {encrypt: true,
- //rowCollectionOnDone:true,
- rowCollectionOnRequestCompletion: true,
- debug: {
- packet: true,
- data: true,
- payload: true,
- token: false,
- log: true
- }
- }
- };
- var connection = new Connection(config);
- connection.on('connect', function(err) {
- // If no error, then good to go...
- // var rere = Meteor.bindEnvironment ( function ()
- // {
- executeStatement();
- // }, function (e)
- // {
- // console.log ("error");
- // throw e;
- // }
- // );
- // AccountSummary.find().count();
- //console.log(rere);
- // errr = err;
- }
- );
- });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement