{"action":"created","issue":{"url":"https://api.github.com/repos/sgeisler/test-redmine-issue-migration/issues/64","repository_url":"https://api.github.com/repos/sgeisler/test-redmine-issue-migration","labels_url":"https://api.github.com/repos/sgeisler/test-redmine-issue-migration/issues/64/labels{/name}","comments_url":"https://api.github.com/repos/sgeisler/test-redmine-issue-migration/issues/64/comments","events_url":"https://api.github.com/repos/sgeisler/test-redmine-issue-migration/issues/64/events","html_url":"https://github.com/sgeisler/test-redmine-issue-migration/issues/64","id":177673130,"number":64,"title":"Sqlalchemy-Migrate evaluieren","user":{"login":"sgeisler","id":1876998,"avatar_url":"https://avatars.githubusercontent.com/u/1876998?v=3","gravatar_id":"","url":"https://api.github.com/users/sgeisler","html_url":"https://github.com/sgeisler","followers_url":"https://api.github.com/users/sgeisler/followers","following_url":"https://api.github.com/users/sgeisler/following{/other_user}","gists_url":"https://api.github.com/users/sgeisler/gists{/gist_id}","starred_url":"https://api.github.com/users/sgeisler/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sgeisler/subscriptions","organizations_url":"https://api.github.com/users/sgeisler/orgs","repos_url":"https://api.github.com/users/sgeisler/repos","events_url":"https://api.github.com/users/sgeisler/events{/privacy}","received_events_url":"https://api.github.com/users/sgeisler/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/sgeisler/test-redmine-issue-migration/milestones/1","html_url":"https://github.com/sgeisler/test-redmine-issue-migration/milestones/0.1%20-%20Nutzerverwaltung","labels_url":"https://api.github.com/repos/sgeisler/test-redmine-issue-migration/milestones/1/labels","id":2012056,"number":1,"title":"0.1 - Nutzerverwaltung","description":null,"creator":{"login":"sgeisler","id":1876998,"avatar_url":"https://avatars.githubusercontent.com/u/1876998?v=3","gravatar_id":"","url":"https://api.github.com/users/sgeisler","html_url":"https://github.com/sgeisler","followers_url":"https://api.github.com/users/sgeisler/followers","following_url":"https://api.github.com/users/sgeisler/following{/other_user}","gists_url":"https://api.github.com/users/sgeisler/gists{/gist_id}","starred_url":"https://api.github.com/users/sgeisler/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sgeisler/subscriptions","organizations_url":"https://api.github.com/users/sgeisler/orgs","repos_url":"https://api.github.com/users/sgeisler/repos","events_url":"https://api.github.com/users/sgeisler/events{/privacy}","received_events_url":"https://api.github.com/users/sgeisler/received_events","type":"User","site_admin":false},"open_issues":2,"closed_issues":57,"state":"open","created_at":"2016-09-18T18:41:37Z","updated_at":"2016-09-18T20:02:05Z","due_on":null,"closed_at":null},"comments":3,"created_at":"2016-09-18T20:02:05Z","updated_at":"2016-09-18T20:02:06Z","closed_at":null,"body":"---\n\n\nAuthor Name: **JanLo** (JanLo)\nOriginal Redmine Issue: 138, http://projecthost.wh2.tu-dresden.de/redmine/issues/138\nOriginal Date: 2011/11/14\nOriginal Assignee: jacobs\n\n---\n\nÄnderungen am Schema sind einfach, solang dieses noch nicht mit Daten gefüllt ist bzw. Produktiv genutzt wird. Danach ist es immer kompliziert, da sqlalchemy \"neue\" Elemente nur auf der Ebene der Entitäten (also eine \"neue Tabelle\") erkennt. Wenn man nur ein Feld hinzufügt muss das ganze Schema gedropt und wieder erstellt werden - wobei natürlich die Inhalte verloren gehen.\r\n\r\nUm dieses Problem, welches uns früher oder später erreicht so klein wie Möglich zu halten ist es wichtig, die Testdaten während der Entwicklung zum einem in einem unabhängigem Format zu haben um sie problemlos wieder importieren zu können und zum anderem, eine möglichkeit zu haben das Schema während des Produktiveinsatzes inkrementell und versioniert zu ändern.\r\n\r\nFür letzteres gibt es z.B. \"Sqlalchemy-Migrate\":http://code.google.com/p/sqlalchemy-migrate/\r\n\r\nIch habe das noch nie benutzt und irgendwer müsste es sich mal anschauen:\r\n* ob es für unser Projekt geeignet ist\r\n* wie es funktioniert\r\n* Was es bei der Erstellung der Modelle zu beachten gibt\r\n* ...\r\n\r\nAnschließend sollte dazu eine Doku im Wiki landen.\n\n\n"},"comment":{"url":"https://api.github.com/repos/sgeisler/test-redmine-issue-migration/issues/comments/247872258","html_url":"https://github.com/sgeisler/test-redmine-issue-migration/issues/64#issuecomment-247872258","issue_url":"https://api.github.com/repos/sgeisler/test-redmine-issue-migration/issues/64","id":247872258,"user":{"login":"sgeisler","id":1876998,"avatar_url":"https://avatars.githubusercontent.com/u/1876998?v=3","gravatar_id":"","url":"https://api.github.com/users/sgeisler","html_url":"https://github.com/sgeisler","followers_url":"https://api.github.com/users/sgeisler/followers","following_url":"https://api.github.com/users/sgeisler/following{/other_user}","gists_url":"https://api.github.com/users/sgeisler/gists{/gist_id}","starred_url":"https://api.github.com/users/sgeisler/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sgeisler/subscriptions","organizations_url":"https://api.github.com/users/sgeisler/orgs","repos_url":"https://api.github.com/users/sgeisler/repos","events_url":"https://api.github.com/users/sgeisler/events{/privacy}","received_events_url":"https://api.github.com/users/sgeisler/received_events","type":"User","site_admin":false},"created_at":"2016-09-18T20:02:06Z","updated_at":"2016-09-18T20:02:06Z","body":"---\n\nOriginal Redmine Comment\nAuthor Name: **jacobs** (jacobs)\nOriginal Date: 2011/11/13 15:15:26 +0100\n\n---\n\nHabe es mal installiert und initialisiert.\r\nLeider konnte ich bis jetzt noch keine Migration vornehmen, da ich nicht weiß, wie ich auf das sqlalchemy Model zugreifen soll."}}
{"actor":{"display_login":"sgeisler"}}