Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- const { Connection, Request } = require("tedious");
- // Create connection to database
- const config = {
- authentication: {
- options: {
- userName: "Admin123", // update me
- password: "Kutafon123" // update me
- },
- type: "default"
- },
- server: "testappdbsrv1.database.windows.net", // update me
- options: {
- database: "AppData", //update me
- encrypt: true
- }
- };
- const connection = new Connection(config);
- // Attempt to connect and execute queries if connection goes through
- connection.on("connect", err => {
- if (err) {
- console.error(err.message);
- } else {
- queryDatabase();
- }
- });
- function queryDatabase() {
- console.log("Reading rows from the Table...");
- // Read all rows from table
- const request = new Request(
- `SELECT TOP (1000) [USER_NAME]
- ,[USER_PASSWORD]
- FROM [dbo].[app_users]`,
- (err, rowCount) => {
- if (err) {
- console.error(err.message);
- } else {
- console.log(`${rowCount} row(s) returned`);
- }
- }
- );
- request.on("row", columns => {
- columns.forEach(column => {
- console.log("%s\t%s", column.metadata.colName, column.value);
- });
- });
- connection.execSql(request);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement