Skip to content
This repository has been archived by the owner on Jan 21, 2018. It is now read-only.

PR: Uniform Create Table Syntax #29

Closed
jooohhn opened this issue Sep 2, 2017 · 0 comments
Closed

PR: Uniform Create Table Syntax #29

jooohhn opened this issue Sep 2, 2017 · 0 comments

Comments

@jooohhn
Copy link

jooohhn commented Sep 2, 2017

Summary

SELECT sql FROM sqlite_master WHERE name='${table}'; returns the sqlite statement used to create table. However, the format/syntax isn't the same for all instances as it is determined by the user/client and sqlite allows multiply different syntaxes for creating tables/columns/constraints.

There should be an adapter/function that takes any sqlite create table statement and returns a consistent format that falcon-core can work with

Example

Editing with db-browser will force an sqlite table's creation statement to look like this, regardless of initial format/syntax

image

@jooohhn jooohhn self-assigned this Sep 2, 2017
@jooohhn jooohhn mentioned this issue Sep 3, 2017
5 tasks
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Projects
None yet
Development

No branches or pull requests

2 participants