Document geoJSON anomalies encountered

[SanjanaSogimatt]

Issue Title

Error Handling: Invalid Input Syntax for Integer During SubDistrict and Village Data Insertion

Description

While inserting SubDistrict and Village data into the GeoIP application using Prisma's $executeRawUnsafe() method, multiple errors occurred due to invalid input syntax for type integer and syntax errors in raw SQL queries. These errors resulted in failed data insertion for several entries.

Affected Entries:

SubDistricts:

• Kachchh
• Mirpur
• Muzaffarabad
• Punch
• Leh
• Kolasib
• Lawngtlai

Villages:

• Khiri
• Itahri
• Shortt's Island

Error Details:

Invalid Input Syntax for Integer (22P02):

• The raw query failed due to invalid input syntax for type integer, likely caused by an empty string or incorrect data type being passed where an integer was expected.
• Error message: ERROR: invalid input syntax for type integer: " "

Syntax Errors in SQL (42601):

• Raw SQL queries failed due to syntax errors, indicating issues with the formatting of the SQL statements, possibly near keywords or special characters.

• Specific errors:

ERROR: syntax error at or near "N"
ERROR: syntax error at or near "Bungtlang"
ERROR: syntax error at or near "{"
ERROR: syntax error at or near "s"

Expected Behavior:
Data should be inserted successfully without syntax errors.
The script should properly handle or validate inputs to avoid invalid syntax for integers.

Tech Stack:
Prisma Client Version: 5.17.0
Language: TypeScript
Environment: Node.js

Category
Bug Report