{"action":"created","issue":{"url":"https://api.github.com/repos/SEAPUNK/grater/issues/1","repository_url":"https://api.github.com/repos/SEAPUNK/grater","labels_url":"https://api.github.com/repos/SEAPUNK/grater/issues/1/labels{/name}","comments_url":"https://api.github.com/repos/SEAPUNK/grater/issues/1/comments","events_url":"https://api.github.com/repos/SEAPUNK/grater/issues/1/events","html_url":"https://github.com/SEAPUNK/grater/issues/1","id":177270433,"number":1,"title":"ideas","user":{"login":"SEAPUNK","id":4400726,"avatar_url":"https://avatars.githubusercontent.com/u/4400726?v=3","gravatar_id":"","url":"https://api.github.com/users/SEAPUNK","html_url":"https://github.com/SEAPUNK","followers_url":"https://api.github.com/users/SEAPUNK/followers","following_url":"https://api.github.com/users/SEAPUNK/following{/other_user}","gists_url":"https://api.github.com/users/SEAPUNK/gists{/gist_id}","starred_url":"https://api.github.com/users/SEAPUNK/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SEAPUNK/subscriptions","organizations_url":"https://api.github.com/users/SEAPUNK/orgs","repos_url":"https://api.github.com/users/SEAPUNK/repos","events_url":"https://api.github.com/users/SEAPUNK/events{/privacy}","received_events_url":"https://api.github.com/users/SEAPUNK/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2016-09-15T19:45:39Z","updated_at":"2016-09-15T19:53:54Z","closed_at":null,"body":"database initialization:\r\n\r\n1. `/schema.sql` or `/schema/` directory (schema .sql files are executed in alphabetic order)\r\n2. `/seeds.sql` or `/seeds/` directory (alphabetic order)\r\n\r\nmigrations:\r\n\r\n- `/migrations/` folder, format is `TIMESTAMP_NAME.sql`\r\n + `TIMESTAMP` is the current UTC time, in `YYYYMMDDHHMMSS`, like Rails' ActiveMigration\r\n + `TIMESTAMP` is also essentially the id of the migration, so there cannot be multiple migrations with the same timestamp\r\n + `NAME` is the description of the migration (no format in particular)\r\n- schema migrations are kept track of in `schema_migrations` table of the database\r\n- `grater migrate [TIMESTAMP]` - migrates schemas. runs all migrations that have not been run (load schema_migrations folder). if timestamp is provided, then that specific migration is run (and error thrown if grater notices that the migration has been run before, saying you gotta run it with `--force`)\r\n"},"comment":{"url":"https://api.github.com/repos/SEAPUNK/grater/issues/comments/247434509","html_url":"https://github.com/SEAPUNK/grater/issues/1#issuecomment-247434509","issue_url":"https://api.github.com/repos/SEAPUNK/grater/issues/1","id":247434509,"user":{"login":"SEAPUNK","id":4400726,"avatar_url":"https://avatars.githubusercontent.com/u/4400726?v=3","gravatar_id":"","url":"https://api.github.com/users/SEAPUNK","html_url":"https://github.com/SEAPUNK","followers_url":"https://api.github.com/users/SEAPUNK/followers","following_url":"https://api.github.com/users/SEAPUNK/following{/other_user}","gists_url":"https://api.github.com/users/SEAPUNK/gists{/gist_id}","starred_url":"https://api.github.com/users/SEAPUNK/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/SEAPUNK/subscriptions","organizations_url":"https://api.github.com/users/SEAPUNK/orgs","repos_url":"https://api.github.com/users/SEAPUNK/repos","events_url":"https://api.github.com/users/SEAPUNK/events{/privacy}","received_events_url":"https://api.github.com/users/SEAPUNK/received_events","type":"User","site_admin":false},"created_at":"2016-09-15T19:53:54Z","updated_at":"2016-09-15T19:53:54Z","body":"A: **do not do anything**\r\n\r\nhave multiple commands to resolve this:\r\n\r\n- `grater init new` - creates the new database with the new schema and seeds (if database exists, require the `--drop-existing` flag)\r\n- `grater init fresh` - just creates the schema_migrations table, and populates it with the current migrations, to indicate that the current database is already completely migrated\r\n- `grater init stale` - creates the schema_migrations table, and then runs migrations. `--interactive` indicates that the user wants to choose which migrations to run, mark as completed without running, or skip.\r\n"}}
{"actor":{"display_login":"SEAPUNK"}}