# loopback-sql-create-model

> loopback project for creating models using sql server with one to one and one to many relationship

Latest version **1.0.0** (published 2016-05-27) · 0 weekly downloads

## Install

```sh
npm install loopback-sql-create-model
pnpm add loopback-sql-create-model
yarn add loopback-sql-create-model
bun add loopback-sql-create-model
```

## Health

**Score 15/100 (F)** — status: abandoned.

Positive: no vulnerabilities.

Warnings: low downloads; no types; no esm support.

Negative: abandoned; low maintenance score.

## Facts

| | |
|---|---|
| Version | 1.0.0 |
| Published | 2016-05-27 |
| First published | 2016-05-27 |
| Weekly downloads | 0 |
| TypeScript types | none |
| Module format | CommonJS |
| Dependencies | 12 |
| Known vulnerabilities | 0 (+1 in 1 direct dependencies) |
| Install scripts | no |
| Maintainers | savsharma2 |

## Links

- npm: https://www.npmjs.com/package/loopback-sql-create-model
- npm.io page: https://npm.io/package/loopback-sql-create-model

## Dependencies (12)

- [cors](https://npm.io/package/cors.md) ^2.5.2
- [grunt](https://npm.io/package/grunt.md) ^1.0.1
- [extend](https://npm.io/package/extend.md) ^3.0.0
- [helmet](https://npm.io/package/helmet.md) ^0.14.0
- [string](https://npm.io/package/string.md) ^3.3.1
- [loopback](https://npm.io/package/loopback.md) ^2.22.0
- [loopback-boot](https://npm.io/package/loopback-boot.md) ^2.6.5
- [serve-favicon](https://npm.io/package/serve-favicon.md) ^2.0.1
- [grunt-contrib-watch](https://npm.io/package/grunt-contrib-watch.md) ^1.0.0
- [loopback-connector-mssql](https://npm.io/package/loopback-connector-mssql.md) ^2.7.1
- [loopback-component-explorer](https://npm.io/package/loopback-component-explorer.md) ^2.1.0
- [loopback-datasource-juggler](https://npm.io/package/loopback-datasource-juggler.md) ^2.39.0

## Recent versions

- 1.0.0 (latest) — 2016-05-27

## README

# Loopback Model Creation

The project is generated using [LoopBack](http://loopback.io) and modified by [savsharma2](https://github.com/savsharma2)
to create models with [belongsTo](https://docs.strongloop.com/display/public/LB/BelongsTo+relations/) that is **One To One** and
[hasMany](https://docs.strongloop.com/display/public/LB/HasMany+relations) which is **One To Many** relationships.

## Installation

```
$ npm install
```

## Change in loopback discovery api

Problem statement can be viewed here (<http://stackoverflow.com/questions/37408747/strongloop-database-discovery-api-for-sql-server-giving-same-table-name-for-prim>).

```
file :- node_modules/loopback-connector-mssql\lib\discovery.js
```

```javascript
/*!
 * Retrieves a description of the foreign key columns that reference the given table's primary key columns (the foreign keys exported by a table).
 * They are ordered by fkTableOwner, fkTableName, and keySeq.
 * @param owner
 * @param table
 * @returns {string}
 */
function queryExportedForeignKeys(owner, table) {
  var sql = `SELECT
  fkOwner = sch.name ,fkName = obj.name,
  fkTableName =  tab1.name ,
  fkColumnName = col1.name,
  PK_Table =  tab2.name,
  PK_Column = col2.name
  FROM sys.foreign_key_columns fkc
  INNER JOIN sys.objects obj
      ON obj.object_id = fkc.constraint_object_id
    INNER JOIN sys.tables tab1
      ON tab1.object_id = fkc.parent_object_id
    INNER JOIN sys.schemas sch
      ON tab1.schema_id = sch.schema_id
    INNER JOIN sys.columns col1
      ON col1.column_id = parent_column_id AND col1.object_id = tab1.object_id
    INNER JOIN sys.tables tab2
      ON tab2.object_id = fkc.referenced_object_id
    INNER JOIN sys.columns col2
      ON col2.column_id = referenced_column_id AND col2.object_id = tab2.object_id`;

  if (table) {
    sql += ' and tab2.name=\'' + table + '\'';
  }

  return sql;
}


```

```javascript
/*!
 * Build the sql statement for querying foreign keys of a given table
 * @param owner
 * @param table
 * @returns {string}
 */
function queryForeignKeys(owner, table) {
  var sql = `SELECT  
     fkOwner = FK.table_schema ,
     fkName = FK.constraint_name,
     fkTableName = FK.TABLE_NAME,
     fkColumnName = CU.COLUMN_NAME,
     keySeq = CU.ordinal_position,
     PK_Table = PK.TABLE_NAME,
     PK_Column = PT.COLUMN_NAME
     FROM
     INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS C
     INNER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS FK
        ON C.CONSTRAINT_NAME = FK.CONSTRAINT_NAME
     INNER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS PK
        ON C.UNIQUE_CONSTRAINT_NAME = PK.CONSTRAINT_NAME
     INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE CU
        ON C.CONSTRAINT_NAME = CU.CONSTRAINT_NAME
     INNER JOIN (
          SELECT
              i1.TABLE_NAME,
              i2.COLUMN_NAME
          FROM
              INFORMATION_SCHEMA.TABLE_CONSTRAINTS i1
          INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE i2
              ON i1.CONSTRAINT_NAME = i2.CONSTRAINT_NAME
          WHERE
              i1.CONSTRAINT_TYPE = 'PRIMARY KEY'
         ) PT
     ON PT.TABLE_NAME = PK.TABLE_NAME`;

  if (table) {
    sql += ' AND  FK.TABLE_NAME =\'' + table + '\'';
  }
  return sql;
}

```

## Running Project

run
```
node .
```
and you are good to go. :+1:

---
_Source: https://npm.io/package/loopback-sql-create-model · Machine-readable twin of the npm.io package page. Health data is recomputed on every publish._
