New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Check for and create indexes independently of tables. #4

Open

bokov opened this issue Mar 16, 2017 · 0 comments

Labels

Contributor

bokov commented Mar 16, 2017

Right now, indexes get created...

chinotype/chi2/chinotype.py

Line 357 in eebf0fe

create index {0}_idx

chinotype/chi2/chinotype.py

Line 387 in eebf0fe

create index {0}_pn_idx on {0} (pn)

chinotype/chi2/chinotype.py

Line 391 in eebf0fe

create index {0}_ccd_idx on {0} (ccd)

chinotype/chi2/chinotype.py

Line 434 in eebf0fe

create index {0}_idx

chinotype/chi2/chinotype.py

Line 440 in eebf0fe

create index {0}_pfx_idx

chinotype/chi2/chinotype.py

Line 446 in eebf0fe

create index {0}_tl_idx

chinotype/chi2/chinotype.py

Line 474 in eebf0fe

sql = '''create index {0}_idx on {0} (c_name)'''.format(chischemes)

...only if the parent tables do not exist. But if they do already exist, it continues to use the existing ones and no indexes are created. Each of the above should be a separate exception.

bokov added the enhancement label

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment