simonw/db-to-sqlite

Oracle number columns become integer in sqlite

Open

#17 opened on Jul 11, 2019

View on GitHub
 (1 comment) (0 reactions) (0 assignees)Python (34 forks)github user discovery
bughelp wanted

Repository metrics

Stars
 (495 stars)
PR merge metrics
 (PR metrics pending)

Description

The database I'm working with has several columns set as number in Oracle. This utility creates the fields as integer in sqlite. It works if I remove the two fields that are number fields from my query. Otherwise it runs up until it encounters a noninteger number and then errors out with "Error binding parameter 64 - probably unsupported type" Additionally, I'm currently only including 6 fields in my select query, I don't know why it has 64 or more parameters.

Contributor guide

Research direction
Inspect the code where Oracle number columns are mapped to SQLite types and ensure proper handling of non integer numbers.
Tech stack
python
Domain
backend
Issue type
Bug
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
2
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-3 hours
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Clear
Prerequisites
PythonSQLiteOracle basics
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
65