@l-v-yonsama/multi-platform-database-drivers v0.1.248
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 |
26 days ago
29 days ago
1 month ago
1 month ago
2 months ago
2 months ago
3 months ago
3 months ago
3 months ago
3 months ago
3 months ago
3 months ago
3 months ago
3 months ago
3 months ago
4 months ago
4 months ago
5 months ago
5 months ago
7 months ago
7 months ago
7 months ago
10 months ago
10 months ago
10 months ago
10 months ago
10 months ago
6 months ago
6 months ago
6 months ago
6 months ago
7 months ago
9 months ago
7 months ago
9 months ago
6 months ago
7 months ago
10 months ago
7 months ago
9 months ago
10 months ago
10 months ago
6 months ago
6 months ago
5 months ago
6 months ago
6 months ago
8 months ago
6 months ago
9 months ago
9 months ago
6 months ago
8 months ago
6 months ago
9 months ago
9 months ago
9 months ago
9 months ago
8 months ago
8 months ago
7 months ago
7 months ago
7 months ago
7 months ago
8 months ago
8 months ago
8 months ago
10 months ago
10 months ago
12 months ago
1 year ago
12 months ago
1 year ago
1 year ago
12 months ago
12 months ago
12 months ago
12 months ago
1 year ago
11 months ago
11 months ago
11 months ago
11 months ago
11 months ago
11 months ago
12 months ago
11 months ago
11 months ago
11 months ago
11 months ago
11 months ago
11 months ago
11 months ago
11 months ago
12 months ago
12 months ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago
1 year ago