Can't set up local development environment with SQLite

[mikeconley]

Hello,

I want to contribute to this project, but I'm having a hard time setting up my development environment; particularly, it looks like some of the migrations don't work with SQLite. For example, running upgrade 177b55430b61 -> 1aaef862b2da, I get:

sqlalchemy.exc.OperationalError: (OperationalError) Cannot add a NOT NULL column with default value NULL u'ALTER TABLE stream ADD COLUMN channel VARCHAR(25) NOT NULL' ()

If SQLite support isn't in the cards, which database backend should I be using instead to contribute?

[elimohl]

I think you can just run db.create_all() and then set alembic_version to last revision in your database.

[paked]

Just going to interject as someone who has tried and failed at setting up a WPC Site development environment: Is there a specific script to just do this? And if there is, could it be placed somewhere a bit more obvious (ie, root directory)?

This is the kind of thing that could be added to the README file.

On Sun, Feb 22, 2015 at 9:19 PM, Elizaveta Logacheva < notifications@github.com> wrote:

I think you can just run db.create_all() and then set alembic_version to last revision in your database.

— Reply to this email directly or view it on GitHub https://github.com/eleweek/WatchPeopleCode/issues/10#issuecomment-75428687 .

[eleweek]

No, there is no script. You could just launch python shell, type from app import * and then do db.create_all()

[elimohl]

I think REAME resolved it. If you still has problem with databse, you can comment about it.

[mikeconley]

Yes agreed - thank you.