Change db field names from camelCase to under_score

[gaitonde]

Postgres requires double quotes around camel case tables/fields. Let's simplify by using the traditional underscore pattern for DB column names.

eg. use challenge_id instead of challengeId

Note: Current table names follow the underscore pattern - we should just continue to do so.

[indytechcook]

@gaitonde do we need to keep old data or can I assume we can just drop all tables?

[indytechcook]

cc @kbowerma on question above

[gaitonde]

I think we should drop old data. I thought we had a script to recreate some baseline data (that might need to be updated as well), but even if we don't, I'm fine w/ starting clean.

[indytechcook]

Challenge launched:

• https://www.topcoder.com/direct/contest/detail.action?projectId=30047131
• http://www.topcoder.com/challenge-details/30047131/?type=develop&noncache=true

Also include #269

[indytechcook]

@gaitonde what are you thoughts on changing the js variables and the API/swagger. I prefer we keep camelCase for API and js and only change the database. Do you have a preference?

[gaitonde]

Keep all js/API stuff the same - only change the db column names. I'll update the ticket description to be a little more clear.

[kbowerma]

My scripts use the api so they should be good. Give me a heads up before you truncate the tables

On Nov 10, 2014, at 8:53 PM, Dayal Gaitonde notifications@github.com wrote:

Keep all js/API stuff the same - only change the db column names. I'll update the ticket description.

—
Reply to this email directly or view it on GitHub.

[indytechcook]

So this isn't possible with the current version of Sequilze. The closes we came is here: topcoder-archive/appirio_tech-lc1-challenge-service#19. I'll have to run some follow up challenges