-
Notifications
You must be signed in to change notification settings - Fork 29
Changes to export PostHistory and Comments data files to PostGres database #2
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.
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
Conversation
) | ||
|
||
parser.add_argument( '-p', '--password' | ||
, help = 'Password for the database.' | ||
, default = None | ||
, default = 'fibinse' |
There was a problem hiding this comment.
Choose a reason for hiding this comment
The reason will be displayed to describe this comment to others. Learn more.
Ouch.
There was a problem hiding this comment.
Choose a reason for hiding this comment
The reason will be displayed to describe this comment to others. Learn more.
Thanks for the enhancements!
I am going to merge most parts of it (after minor fixes) and am leaving behind a comment on a change which may be submitted as a separate PR.
Thanks again!
FROM accepted_answer_id | ||
) | ||
|
||
AND p.acceptedanswerid=h.postid; |
There was a problem hiding this comment.
Choose a reason for hiding this comment
The reason will be displayed to describe this comment to others. Learn more.
This feels a bit too ad-hoc to be part of the default tables to be created. Perhaps this could be put in optional_post.sql
?
There was a problem hiding this comment.
Choose a reason for hiding this comment
The reason will be displayed to describe this comment to others. Learn more.
If you think it is still valuable, create a new PR with a short comment about its importance and change the names of the fields to conform with the other tables. It is unfortunate that the names are case insensitive, but it is better to be consistent now rather than making the user guess the field names per table.
@@ -0,0 +1,9 @@ | |||
DROP TABLE IF EXISTS Tags CASCADE; |
There was a problem hiding this comment.
Choose a reason for hiding this comment
The reason will be displayed to describe this comment to others. Learn more.
This is a typo, it should be Comments
instead. I'll fix it before merging it.
Sorry for not getting to it earlier. I'm about to merge it in with some minor changes. |
No description provided.