Chapter 8 covers manipulating spatial and tabular data. You may want to briefly refamiliarize yourself with “for” and “while” loops before reading this chapter. It would also be wise to familiarize yourself with Structured Query Language (SQL).<\/p>\n
Important details to remember:<\/p>\n
– Once a script creates an exclusive lock, the lock will continue to exist until the script releases the lock.<\/p>\n
Terms<\/p>\n
cursor – is a database technology term for accessing a set of records in a table. It works the way list functions work.<\/p>\n
search cursor – retrieves rows<\/p>\n
insert cursor – inserts rows<\/p>\n
update cursor – updates and deletes rows<\/p>\n
rows – records in a table<\/p>\n
with statements – Good to use when you have two operations that you want to run as a pair<\/p>\n
data locks – prevent multiple processes from changing the same table at the same time in two different applications. (includes shared lock and exclusive locks)<\/p>\n
shared lock – is applied when a table or dataset is accessed<\/p>\n
exclusive lock – are applied when changes are being made to a table or dataset<\/p>\n
parsing – splitting the fully qualified name for a dataset into its components <\/p>\n
Table 8.1 (pg 248) describes the cursor methods of each class<\/p>\n","protected":false},"excerpt":{"rendered":"
Chapter 8 covers manipulating spatial and tabular data. You may want to briefly refamiliarize yourself with “for” and “while” loops before reading this chapter. It would also be wise to familiarize yourself with Structured Query Language (SQL). Important details to Continue Reading<\/a><\/span><\/p>\n","protected":false},"author":2121,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-108","post","type-post","status-publish","format-standard","hentry","category-chapter-notes"],"_links":{"self":[{"href":"https:\/\/sites.owu.edu\/geog-293\/wp-json\/wp\/v2\/posts\/108","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sites.owu.edu\/geog-293\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sites.owu.edu\/geog-293\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sites.owu.edu\/geog-293\/wp-json\/wp\/v2\/users\/2121"}],"replies":[{"embeddable":true,"href":"https:\/\/sites.owu.edu\/geog-293\/wp-json\/wp\/v2\/comments?post=108"}],"version-history":[{"count":2,"href":"https:\/\/sites.owu.edu\/geog-293\/wp-json\/wp\/v2\/posts\/108\/revisions"}],"predecessor-version":[{"id":110,"href":"https:\/\/sites.owu.edu\/geog-293\/wp-json\/wp\/v2\/posts\/108\/revisions\/110"}],"wp:attachment":[{"href":"https:\/\/sites.owu.edu\/geog-293\/wp-json\/wp\/v2\/media?parent=108"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sites.owu.edu\/geog-293\/wp-json\/wp\/v2\/categories?post=108"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sites.owu.edu\/geog-293\/wp-json\/wp\/v2\/tags?post=108"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}