Accession loading issue

[bosborne]

I used the "prot" option when building the database, thinking that protein ids would be loaded, but:

sqlite> select count() from accession;
0
sqlite> select count() from taxa;
2244574
sqlite>

There's no information about proteins in the database. Why is this option called "prot" when only taxonomic data is loaded? The documentation should describe what these different "division" options mean. Or perhaps the "prot" option is not working? My commands:

taxadb download --outdir taxadb --type prot --quiet
taxadb create --input taxadb --dbname taxadb.sqlite --chunk 100 --division prot --quiet

[bosborne]

Same issue with "full":

sqlite> .tables
accession taxa
sqlite> select count() from accession;
0
sqlite> select count() from taxa;
2244856

taxadb download --outdir taxadb --type full --quiet
taxadb create --input taxadb --dbname taxadb.sqlite --chunk 100 --division full --fast --quiet

[bosborne]

These commands take hours to complete by the way, and logging seems to look right. It's as if there's no "commit" after the accession loading. But PeeWee is supposed to autocommit, yes?

[bosborne]

Now I've got it to work:

sqlite> select count() from accession;
832375605
sqlite> select count() from accession;
832375605

I'll put in a pull request, the code does an explicit "commit".