{"id":16,"date":"2021-10-21T17:24:18","date_gmt":"2021-10-21T17:24:18","guid":{"rendered":"https:\/\/blogs.oregonstate.edu\/rayls\/?p=16"},"modified":"2021-10-21T17:24:18","modified_gmt":"2021-10-21T17:24:18","slug":"orms-object-relational-mappers","status":"publish","type":"post","link":"https:\/\/blogs.oregonstate.edu\/rayls\/2021\/10\/21\/orms-object-relational-mappers\/","title":{"rendered":"ORMs: Object-relational Mappers"},"content":{"rendered":"\n

Object-relational mappers are libraries that help programmers map the database data into objects that are more easily usable in their programming language of choice. By abstracting away the database, programmers can then use their programming language to create their tables and access or modify the data in them. There is no need to write a query in your database language, which can help to speed up the development process. <\/p>\n\n\n\n

Django’s ORM<\/h2>\n\n\n\n

Django, a popular Python backend framework, offers an ORM that can speed up your web development. With Django\u2019s ORM, you can create models which will be used to generate the tables in your database, and you can use the functions in the database API to then access and modify data in those tables.<\/p>\n\n\n\n

Models<\/h2>\n\n\n\n
\"\"<\/figure>\n\n\n\n

Each model is a Python class and contains data fields which will be the columns in the table. Django provides a wide variety of DataFields that map to the various data types available in some popular SQL languages. The DataFields can also be passed parameters so that you can set a max length for a char datatype just like you would in SQL for instance. <\/p>\n\n\n\n

Querying your Database<\/h2>\n\n\n\n

The database API provided by Django allows you to perform CRUD operations without ever touching SQL as well. We will use the example model from above to write some sample queries to show how this works. <\/p>\n\n\n\n

Create<\/strong><\/p>\n\n\n\n

\"\"
Creates a user with the name Tyler Rayls.<\/figcaption><\/figure>\n\n\n\n

Retrieve<\/strong><\/p>\n\n\n\n

\"\"
Since we have only made one user, we can get the only user with the name Tyler.<\/figcaption><\/figure>\n\n\n\n

Update<\/strong><\/p>\n\n\n\n

\"\"
Changes the user’s name from Tyler Rayls to John Doe.<\/figcaption><\/figure>\n\n\n\n

Delete<\/strong><\/p>\n\n\n\n

\"\"
Deletes the only user in our database. <\/figcaption><\/figure>\n\n\n\n

Conclusion<\/h2>\n\n\n\n

ORMs are a useful tool because they can help speed up web development. They do this by abstracting away the database so that programmers can work in their language of choice and access their data in objects they are familiar with. <\/p>\n","protected":false},"excerpt":{"rendered":"

Object-relational mappers are libraries that help programmers map the database data into objects that are more easily usable in their programming language of choice. By abstracting away the database, programmers can then use their programming language to create their tables and access or modify the data in them. There is no need to write a […]<\/p>\n","protected":false},"author":11633,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-16","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/blogs.oregonstate.edu\/rayls\/wp-json\/wp\/v2\/posts\/16","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.oregonstate.edu\/rayls\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.oregonstate.edu\/rayls\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.oregonstate.edu\/rayls\/wp-json\/wp\/v2\/users\/11633"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.oregonstate.edu\/rayls\/wp-json\/wp\/v2\/comments?post=16"}],"version-history":[{"count":1,"href":"https:\/\/blogs.oregonstate.edu\/rayls\/wp-json\/wp\/v2\/posts\/16\/revisions"}],"predecessor-version":[{"id":22,"href":"https:\/\/blogs.oregonstate.edu\/rayls\/wp-json\/wp\/v2\/posts\/16\/revisions\/22"}],"wp:attachment":[{"href":"https:\/\/blogs.oregonstate.edu\/rayls\/wp-json\/wp\/v2\/media?parent=16"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.oregonstate.edu\/rayls\/wp-json\/wp\/v2\/categories?post=16"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.oregonstate.edu\/rayls\/wp-json\/wp\/v2\/tags?post=16"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}