Use external database from metasql module

Refs: metarhia/impress#1282 PR-URL: metarhia#54
SergeyMotorin · Nov 6, 2020 · 23fbb3e · 23fbb3e
1 parent 612687d
commit 23fbb3e
Show file tree

Hide file tree

Showing 4 changed files with 5 additions and 3 deletions.
diff --git a/application/api/example.1/citiesByCountry.js b/application/api/example.1/citiesByCountry.js
@@ -1,6 +1,6 @@
 async ({ countryId }) => {
   const fields = ['Id', 'Name'];
   const where = { countryId };
-  const data = await domain.database.example.select('City', fields, where);
+  const data = await domain.db.select('City', fields, where);
   return { result: 'success', data };
 };
diff --git a/application/api/example.1/countries.js b/application/api/example.1/countries.js
@@ -1,5 +1,5 @@
 async () => {
   const fields = ['Id', 'Name'];
-  const data = await domain.database.example.select('Country', fields);
+  const data = await domain.db.select('Country', fields);
   return { result: 'success', data };
 };
diff --git a/application/domain/database/start.js b/application/domain/database/start.js
@@ -1,4 +1,5 @@
 (async () => {
   console.debug('Connect to pg');
-  domain.database.example = new lib.pg.Database(config.database);
+  const options = { ...config.database, logger: console };
+  domain.db = new npm.metasql.Database(options);
 });
diff --git a/package.json b/package.json
@@ -55,6 +55,7 @@
   },
   "dependencies": {
     "impress": "^2.0.0-alpha.33",
+    "metasql": "^0.3.0-alpha.0",
     "pg": "^8.4.2"
   }
 }