{"action":"opened","issue":{"url":"https://api.github.com/repos/balderdashy/sails/issues/2982","labels_url":"https://api.github.com/repos/balderdashy/sails/issues/2982/labels{/name}","comments_url":"https://api.github.com/repos/balderdashy/sails/issues/2982/comments","events_url":"https://api.github.com/repos/balderdashy/sails/issues/2982/events","html_url":"https://github.com/balderdashy/sails/issues/2982","id":83902614,"number":2982,"title":"how to use the database not depend on the ORM","user":{"login":"funkyLover","id":5418228,"avatar_url":"https://avatars.githubusercontent.com/u/5418228?v=3","gravatar_id":"","url":"https://api.github.com/users/funkyLover","html_url":"https://github.com/funkyLover","followers_url":"https://api.github.com/users/funkyLover/followers","following_url":"https://api.github.com/users/funkyLover/following{/other_user}","gists_url":"https://api.github.com/users/funkyLover/gists{/gist_id}","starred_url":"https://api.github.com/users/funkyLover/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/funkyLover/subscriptions","organizations_url":"https://api.github.com/users/funkyLover/orgs","repos_url":"https://api.github.com/users/funkyLover/repos","events_url":"https://api.github.com/users/funkyLover/events{/privacy}","received_events_url":"https://api.github.com/users/funkyLover/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2015-06-02T08:06:20Z","updated_at":"2015-06-02T08:06:20Z","closed_at":null,"body":"I got a mysql database,\r\nthe table and data is already existed,\r\nI am afraid of using sails' ORM will change the table's structure\r\nbut I truely need the built-In model methods\r\n\r\nsuch as I got a mysql table named 'groups'\r\n```\r\nCREATE TABLE IF NOT EXISTS `groups` (\r\n  `id` int(11) NOT NULL,\r\n  `creater_user_id` int(11) NOT NULL,\r\n  `conv_id` varchar(63) NOT NULL,\r\n  `icon_path` varchar(255) CHARACTER SET ascii DEFAULT NULL,\r\n  `subject` varchar(255) CHARACTER SET utf8mb4 NOT NULL,\r\n  `intro` varchar(255) CHARACTER SET utf8mb4 DEFAULT NULL,\r\n  `tags` varchar(255) CHARACTER SET ascii DEFAULT NULL,\r\n  `state` int(1) NOT NULL DEFAULT '1',\r\n  `created` datetime NOT NULL\r\n)\r\n```\r\nwhat should I do with my model `groups` so that I can use the build-in method like `Groups.create()`?\r\n\r\nIn addition the table `groups` structure maybe change later,\r\nis there someway can make that model adapt to the table's structure?\r\n"}}