Comments (4)
continuing is not supported, you'd have to delete the existing table from sqlite and restart. one way to add would be to see how many rows are in the existing table and then use that as an OFFSET into the query from the source. I don't have plans to implement that but would welcome a pull request.
from cruzdb.
Thanks for the advice. One question though is that when I try to change the offset value in mirror.py I get a sqlalchemy.exc.OperationalError: (OperationalError) database is locked u'INSERT INTO.....
error. Do you have any guidance as to how to troubleshoot this.
from cruzdb.
you might need to do destination.rollback() after you get an error.
from cruzdb.
Thanks that worked perfectly. Will tidy up my code and send a pull request.
from cruzdb.
Related Issues (20)
- Misleading docstring for dataframe() HOT 2
- Helpers to handle canonical forms of genes HOT 6
- add ncbi link when annotating
- Other MySQL dialects (aside MySQLdb) are not supported HOT 4
- Figure out what needs to be done for Python 3 compatiblity HOT 8
- sqlalchemy needs to be added to requirements HOT 1
- Gene ABR Cruzdb shows 8 different entries in RefGene whereas RefGene in UCSC shows 5 HOT 1
- one exon missing HOT 2
- Installation Issue HOT 6
- list of tables HOT 1
- invalid syntax? HOT 6
- cruzdb issues when called within Python 3 HOT 1
- ImportError: cannot import name MapperExtension HOT 2
- unable to use package after install HOT 1
- Add as PyPI package HOT 1
- access to bioconductor's TxDb's
- protein sequence
- report which exon from annotate
- script to create knownGene with name
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from cruzdb.