wdis-db

Supported features

| DB\Feature | Select | Insert | Delete | Update | Create | Drop | Native | Meta Model | | ------------- | ------------- | ------------- | ------------- | ------------- | ------------- | ------------- | ------------- | ------------- | | SQlite | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | | MySql | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | | MariaDB | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | | PostegreSql | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | ✅ | | Oracle | ⚠️ | ⚠️ | ⚠️ | ⚠️ | ⚠️ | ⚠️ | ⚠️ | ⚠️ | | MS SQL | ⚠️ | ⚠️ | ⚠️ | ⚠️ | ⚠️ | ⚠️ | ⚠️ | ⚠️ | | CSV | ⚠️ | ⚠️ | ⚠️ | ⚠️ | ⚠️ | ⚠️ | ⚠️ | ⚠️ | | JSON | ⚠️ | ⚠️ | ⚠️ | ⚠️ | ⚠️ | ⚠️ | ⚠️ | ⚠️ | | XML | ⚠️ | ⚠️ | ⚠️ | ⚠️ | ⚠️ | ⚠️ | ⚠️ | ⚠️ | | Property | ⚠️ | ⚠️ | ⚠️ | ⚠️ | ⚠️ | ⚠️ | ⚠️ | ⚠️ |

Table legend

✅ Working - 🔜 In progress - ⚠️ Project Intention

Install

npm install @wdis/db

Or

yarn install @wdis/db

Example

// const { WdisDb } = require('@wdis/db');
import { ConfResource, WdisDb } from "@wdis/db";

const confResource: ConfResource = {
    resource: 'sqlite3',
    url: 'C:\\enviroment\\tmp\\wdis\\db\\sqlite3.db'
};

const wdisDb = new WdisDb(confResource);

let promiseList = wdisDb
    .model('user')
    .select('id','name','email')
    .list();

promiseList.then((userLst:any[]/*OR Type User[]*/)=>{
    console.log(JSON.stringify(userLst));
});

Other Examples

• Documentation
• Sqlite3 Select Examples
• MySql Select Examples

Contributing

Pull requests are welcome! If you see something you'd like to add, please do. For drastic changes, please open an issue first.