0.9.19 • Published 12 months ago

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

Weekly downloads
-
License
MIT
Repository
github
Last release
12 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

12 months ago

0.9.18

12 months ago

0.9.7

12 months ago

0.9.17

12 months ago

0.9.4

1 year ago

0.8.7

1 year ago

0.9.3

1 year ago

0.8.33

1 year ago

0.8.32

1 year ago

0.9.0

1 year ago

0.8.22

1 year ago

0.8.21

1 year ago

0.8.20

1 year ago

0.8.12

1 year ago

0.8.14

1 year ago

0.8.13

1 year ago

0.8.16

1 year ago

0.8.15

1 year ago

0.7.2

1 year ago

0.7.1

1 year ago

0.6.3

1 year ago

0.6.2

1 year ago

0.6.5

1 year ago

0.6.4

1 year ago

0.5.10

1 year ago

0.4.9

1 year ago

0.4.8

1 year ago

0.5.12

1 year ago

0.3.5

1 year ago

0.3.2

1 year ago

0.3.3

1 year ago

0.5.7

1 year ago

0.5.9

1 year ago

0.4.10

1 year ago

0.4.13

1 year ago

0.4.11

1 year ago

0.4.12

1 year 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

1 year ago

0.5.5

1 year ago

0.2.7

1 year ago

0.2.6

1 year ago

0.6.1

1 year ago

0.6.0

1 year ago

0.1.249

1 year ago

0.1.248

2 years ago

0.1.247

2 years ago

0.1.246

2 years ago

0.1.245

2 years ago

0.1.244

2 years ago

0.1.243

2 years ago

0.1.242

2 years ago

0.1.239

2 years ago

0.1.241

2 years ago

0.1.240

2 years ago

0.1.230

2 years ago

0.1.227

2 years ago

0.1.226

2 years ago

0.1.225

2 years ago

0.1.224

2 years 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

3 years ago

0.1.49

3 years ago

0.1.48

3 years ago

0.1.47

3 years ago

0.1.46

3 years ago

0.1.45

3 years ago

0.1.44

3 years ago

0.1.43

3 years ago

0.1.42

3 years ago

0.1.41

3 years ago

0.1.40

3 years ago

0.1.39

3 years ago

0.1.38

3 years ago

0.1.37

3 years ago

0.1.36

3 years ago

0.1.35

3 years ago

0.1.34

3 years ago

0.1.33

3 years ago

0.1.32

3 years ago

0.1.31

3 years ago

0.1.30

3 years ago

0.1.29

3 years ago

0.1.28

3 years ago

0.1.26

3 years ago

0.1.24

3 years ago

0.1.23

3 years ago

0.1.22

3 years ago

0.1.21

3 years ago

0.1.20

3 years ago

0.1.19

3 years ago

0.1.18

3 years ago

0.1.17

3 years ago

0.1.16

3 years ago

0.1.15

3 years ago

0.1.13

3 years ago

0.1.12

3 years ago

0.1.11

3 years ago

0.1.10

3 years ago

0.1.9

3 years ago

0.1.8

3 years ago

0.1.7

3 years ago

0.1.6

3 years ago

0.1.5

3 years ago

0.1.2

3 years ago

0.1.1

3 years ago