0.9.19 • Published 9 months ago

@l-v-yonsama/multi-platform-database-drivers v0.9.19

Weekly downloads
-
License
MIT
Repository
github
Last release
9 months ago

Prepare

cd ./docker

docker-compose -f unit-test.yml build

docker-compose -f unit-test.yml up -d
yarn add @l-v-yonsama/multi-platform-database-drivers
OR
npm i @l-v-yonsama/multi-platform-database-drivers
import {
  DBDriverResolver,
  RDSBaseDriver,
  ResultSetDataBuilder,
  ConnectionSetting,
  DBType,
} from "@l-v-yonsama/multi-platform-database-drivers";

const connectOption: ConnectionSetting = {
  host: '127.0.0.1',
  port: 6001,
  user: 'testuser',
  password: 'testpass',
  database: 'testdb',
  dbType: DBType.MySQL,
  name: 'mysql',
};

(async (): Promise<void> => {
  const { ok, message, result } =
    await DBDriverResolver.getInstance().workflow<RDSBaseDriver>(
      connectOption,
      async (driver) => {
        const dbs = await driver.getInfomationSchemas();
        const table = dbs[0].getSchema({ isDefault: true }).children[0];
        return await driver.requestSql({
          sql: 'SELECT * FROM ' + table.name,
        });
      },
    );

  console.log('ok', ok);
  console.log('message', message);
  console.log(result);

  console.log(
    ResultSetDataBuilder.from(result).toMarkdown({
      withType: true,
      withComment: true,
    }),
  );
})();
ok true
message
{
  created: 2023-07-29T00:03:17.230Z,
  keys: [
    {
      name: 'DEPTNO',
      type: 14,
      comment: '部門番号',
      width: undefined,
      required: true
    },
    {
      name: 'DNAME',
      type: 4,
      comment: '部門名',
      width: undefined,
      required: false
    },
    {
      name: 'LOC',
      type: 4,
      comment: 'ロケーション',
      width: undefined,
      required: false
    }
  ],
  rows: [
    { meta: {}, values: [Object] },
    { meta: {}, values: [Object] },
    { meta: {}, values: [Object] },
    { meta: {}, values: [Object] }
  ],
  meta: {
    connectionName: 'mysql',
    comment: '部門',
    tableName: 'DEPT',
    compareKeys: [ [Object] ],
    type: 'select',
    editable: undefined
  },
  sqlStatement: 'SELECT * FROM DEPT',
  queryConditions: undefined
}
| DEPTNO | DNAME | LOC |
| :---: | :---: | :---: |
| 部門番号 | 部門名 | ロケーション |
| INTEGER | VARCHAR | VARCHAR |
| 10 | ACCOUNTING | NEW YORK |
| 20 | RESEARCH | DALLAS |
| 30 | SALES | CHICAGO |
| 40 | OPERATIONS | BOSTON |
0.9.19

9 months ago

0.9.18

9 months ago

0.9.7

9 months ago

0.9.17

9 months ago

0.9.4

9 months ago

0.8.7

10 months ago

0.9.3

10 months ago

0.8.33

10 months ago

0.8.32

10 months ago

0.9.0

10 months ago

0.8.22

10 months ago

0.8.21

10 months ago

0.8.20

10 months ago

0.8.12

10 months ago

0.8.14

10 months ago

0.8.13

10 months ago

0.8.16

10 months ago

0.8.15

10 months ago

0.7.2

10 months ago

0.7.1

11 months ago

0.6.3

11 months ago

0.6.2

11 months ago

0.6.5

11 months ago

0.6.4

11 months ago

0.5.10

11 months ago

0.4.9

12 months ago

0.4.8

12 months ago

0.5.12

11 months ago

0.3.5

1 year ago

0.3.2

1 year ago

0.3.3

1 year ago

0.5.7

12 months ago

0.5.9

12 months ago

0.4.10

12 months ago

0.4.13

12 months ago

0.4.11

12 months ago

0.4.12

12 months ago

0.4.4

1 year ago

0.4.7

1 year ago

0.4.6

1 year ago

0.4.1

1 year ago

0.4.0

1 year ago

0.4.3

1 year ago

0.5.6

12 months ago

0.5.5

12 months ago

0.2.7

1 year ago

0.2.6

1 year ago

0.6.1

11 months ago

0.6.0

11 months ago

0.1.249

1 year ago

0.1.248

1 year ago

0.1.247

1 year ago

0.1.246

1 year ago

0.1.245

1 year ago

0.1.244

1 year ago

0.1.243

1 year ago

0.1.242

1 year ago

0.1.239

1 year ago

0.1.241

1 year ago

0.1.240

1 year ago

0.1.230

1 year ago

0.1.227

1 year ago

0.1.226

1 year ago

0.1.225

1 year ago

0.1.224

1 year ago

0.1.223

2 years ago

0.1.222

2 years ago

0.1.221

2 years ago

0.1.220

2 years ago

0.1.198

2 years ago

0.1.197

2 years ago

0.1.199

2 years ago

0.1.132

2 years ago

0.1.158

2 years ago

0.1.157

2 years ago

0.1.159

2 years ago

0.1.153

2 years ago

0.1.206

2 years ago

0.1.205

2 years ago

0.1.208

2 years ago

0.1.207

2 years ago

0.1.202

2 years ago

0.1.169

2 years ago

0.1.201

2 years ago

0.1.168

2 years ago

0.1.204

2 years ago

0.1.203

2 years ago

0.1.165

2 years ago

0.1.200

2 years ago

0.1.167

2 years ago

0.1.166

2 years ago

0.1.163

2 years ago

0.1.209

2 years ago

0.1.217

2 years ago

0.1.219

2 years ago

0.1.213

2 years ago

0.1.212

2 years ago

0.1.179

2 years ago

0.1.214

2 years ago

0.1.176

2 years ago

0.1.175

2 years ago

0.1.211

2 years ago

0.1.178

2 years ago

0.1.210

2 years ago

0.1.177

2 years ago

0.1.172

2 years ago

0.1.171

2 years ago

0.1.173

2 years ago

0.1.181

2 years ago

0.1.180

2 years ago

0.1.187

2 years ago

0.1.186

2 years ago

0.1.189

2 years ago

0.1.188

2 years ago

0.1.182

2 years ago

0.1.185

2 years ago

0.1.184

2 years ago

0.1.131

2 years ago

0.1.130

2 years ago

0.1.96

2 years ago

0.1.52

2 years ago

0.1.97

2 years ago

0.1.54

2 years ago

0.1.55

2 years ago

0.1.57

2 years ago

0.1.58

2 years ago

0.1.94

2 years ago

0.1.95

2 years ago

0.1.51

2 years ago

0.1.118

2 years ago

0.1.119

2 years ago

0.1.116

2 years ago

0.1.115

2 years ago

0.1.110

2 years ago

0.1.111

2 years ago

0.1.88

2 years ago

0.1.127

2 years ago

0.1.121

2 years ago

0.1.120

2 years ago

0.1.109

2 years ago

0.1.108

2 years ago

0.1.103

2 years ago

0.1.102

2 years ago

0.1.105

2 years ago

0.1.101

2 years ago

0.1.100

2 years ago

0.1.50

2 years ago

0.1.49

2 years ago

0.1.48

2 years ago

0.1.47

2 years ago

0.1.46

2 years ago

0.1.45

2 years ago

0.1.44

2 years ago

0.1.43

2 years ago

0.1.42

2 years ago

0.1.41

2 years ago

0.1.40

2 years ago

0.1.39

2 years ago

0.1.38

2 years ago

0.1.37

2 years ago

0.1.36

2 years ago

0.1.35

2 years ago

0.1.34

2 years ago

0.1.33

2 years ago

0.1.32

2 years ago

0.1.31

2 years ago

0.1.30

2 years ago

0.1.29

2 years ago

0.1.28

2 years ago

0.1.26

2 years ago

0.1.24

2 years ago

0.1.23

2 years ago

0.1.22

2 years ago

0.1.21

2 years ago

0.1.20

2 years ago

0.1.19

2 years ago

0.1.18

2 years ago

0.1.17

2 years ago

0.1.16

2 years ago

0.1.15

2 years ago

0.1.13

2 years ago

0.1.12

2 years ago

0.1.11

2 years ago

0.1.10

2 years ago

0.1.9

2 years ago

0.1.8

2 years ago

0.1.7

2 years ago

0.1.6

2 years ago

0.1.5

2 years ago

0.1.2

2 years ago

0.1.1

2 years ago