mysql2-types-generator - npm Package Compare versions

Comparing version 1.0.5 to 1.0.6

package.json

 {
   "name": "mysql2-types-generator",
   "repository": "matvejs16/mysql2-types-generator",
-  "version": "1.0.5",
+  "version": "1.0.6",
   "description": "",
@@ -6,0 +6,0 @@ "main": "dist/index.js",

README.md

 # Package to create MySQL database types
 ## Install this package
 ```bash
-npm i mysql2-handler
 npm i mysql2-types-generator
@@ -10,2 +9,3 @@ ```
 ```javascript
+// No need to install mysql2 or mysql2-handler packages, they are dependencies of this package for capability reasons
 const DB = require('mysql2-handler');
@@ -18,5 +18,5 @@ // OR
 ```javascript
-const { generateDatabaseTSFile } = require('mysql2-types-generator')
+const generateDatabaseTSFile = require('mysql2-types-generator')
 // OR
-import { generateDatabaseTSFile } from 'mysql2-types-generator'
+import generateDatabaseTSFile from 'mysql2-types-generator'
 ```
@@ -23,0 +23,0 @@

src/index.ts

@@ -14,3 +14,3 @@ import { FieldPacket, RowDataPacket } from "mysql2"
 	console.log(`[${chalk.cyan("DB")} ${chalk.cyan("Types")}] Generating DBTypes file...`)
-	const [tables]: [RowDataPacket[], FieldPacket[]] = await DBInstance.Handle_Promise.query(`SHOW TABLES FROM ${DBName}`)
+	const [tables]: [RowDataPacket[], FieldPacket[]] = await DBInstance.Handle_Promise.query(`SHOW TABLES FROM \`${DBName}\``)
 	const tableNames = tables.map((table: any) => {
@@ -23,3 +23,3 @@ const tableName = table[Object.keys(table)[0]]
 	for (const tableName of tableNames) {
-		const [tableFields]: [RowDataPacket[], FieldPacket[]] = await DBInstance.Handle_Promise.query(`SHOW COLUMNS FROM ${DBName}.${tableName}`)
+		const [tableFields]: [RowDataPacket[], FieldPacket[]] = await DBInstance.Handle_Promise.query(`SHOW COLUMNS FROM \`${DBName}\`.\`${tableName}\``)
 
@@ -26,0 +26,0 @@ const fields = tableFields.map((field: any) => {

No alert changes

Improved metrics

Total package byte prevSize

44293

increased by0.23%

No dependency changes