{"id":54,"date":"2016-03-29T18:59:45","date_gmt":"2016-03-29T16:59:45","guid":{"rendered":"http:\/\/antek.atthost24.pl\/?p=54"},"modified":"2016-03-25T07:56:58","modified_gmt":"2016-03-25T06:56:58","slug":"orm-w-androidzie","status":"publish","type":"post","link":"https:\/\/blog.lantkowiak.pl\/index.php\/2016\/03\/29\/orm-w-androidzie\/","title":{"rendered":"ORM w Androidzie"},"content":{"rendered":"

W tym wpisie<\/a> napisa\u0142em kilka s\u0142\u00f3w o przechowywaniu danych w mojej aplikacji. Wspomina\u0142em tam r\u00f3wnie\u017c, \u017ce z powodu prostego schematu bazy danych nie zamierzam u\u017cywa\u0107 ORMa. No wi\u0119c… sytuacja si\u0119 troch\u0119 zmieni\u0142a \ud83d\ude42<\/p>\n

Po napisaniu kilku insert\u00f3w, select\u00f3w itd. stwierdzi\u0142em jednak, \u017ce odrobina pomocy od strony jakiego\u015b framework’u nie zaszkodzi \ud83d\ude42<\/p>\n

Po przejrzeniu dost\u0119pnych framework\u00f3w wybra\u0142em ORMLite<\/a>. Cytuj\u0105c opis ze strony:<\/p>\n

Object Relational Mapping Lite (ORM Lite) provides some simple<\/a>, lightweight functionality for persisting Java objects to SQL databases while avoiding the complexity and overhead of more standard ORM packages.<\/pre>\n
Jedyn\u0105 funkcjonalno\u015bci\u0105 (przynajmniej na ten moment), kt\u00f3rej brakuje mi w ORMLite to wpieranie relacji many-to-many. No ale jak to m\u00f3wi\u0105 – nie mo\u017cna mie\u0107 wszystkiego \ud83d\ude42<\/p>\n
Sama konfiguracja by\u0142a dosy\u0107 \u0142atwa. Pierwszym krokiem jest dodanie zale\u017cno\u015bci do gradle:<\/p>\n
'com.j256.ormlite:ormlite-android:4.45'<\/pre>\n
Dalej ju\u017c pozosta\u0142o tylko stworzy\u0107 encje:<\/p>\n
@DatabaseTable(tableName = \"documents\")\r\nclass Document {\r\n  @DatabaseField(generatedId = true)\r\n  var id: Int = _\r\n  @DatabaseField(canBeNull = false)\r\n  var title: String = _\r\n  @DatabaseField(canBeNull = false)\r\n  var createDate: Date = _\r\n}<\/pre>\n
DAO dla naszej encji:<\/p>\n
class DocumentDao(val dao: Dao[Document, Integer]) extends RuntimeExceptionDao[Document, Integer](dao) {\r\n  def getAllDocuments: List[Document] = {\r\n    dao.queryForAll().toList\r\n  }\r\n}<\/pre>\n
DAO rozszerza klase\u00a0RuntimeExceptionDao. Zaimplementowa\u0142em to w ten spos\u00f3b poniewa\u017c podstawowe DAO dostarczane przez ORMLite wymaga obs\u0142ugi java.sql.SQLException, kt\u00f3ry mo\u017ce zosta\u0107 rzucony przez ka\u017cd\u0105 metod\u0119 DAO. RuntimeExceptionDao (jak sama nazwa wskazuje) rzucza RuntimeException zamiast wspomnianego wczesniej\u00a0SQLException.<\/p>\n
Jeszcze jedn\u0105 rzecz\u0105, na kt\u00f3r\u0105 warto zwr\u00f3ci\u0107 uwag\u0119 to poni\u017csza linijka:<\/p>\n
dao.queryForAll().toList<\/pre>\n
Metoda\u00a0queryForAll() zwraca java.util.List. Aby przekonwertowa\u0107 to na liste Scala’ow\u0105 wystarczy na tej li\u015bcie\u00a0wywo\u0142a\u0107 metod\u0119 toList.<\/p>\n
Kolejnym krokiem jest implementacja klasy rozszerzaj\u0105ca\u00a0OrmLiteSqliteOpenHelper. Moja implementacja wygl\u0105da nast\u0119puj\u0105co:<\/p>\n
class OrmDatabaseHelper(val context: Context) extends OrmLiteSqliteOpenHelper(context, DbConstants.DatabaseName, null, DbConstants.DatabaseVersion) {\r\n  override def onUpgrade(database: SQLiteDatabase, connectionSource: ConnectionSource, oldVersion: Int, newVersion: Int): Unit = {\r\n    TableUtils.createTable(connectionSource, classOf[Document])\r\n  }\r\n\r\n  override def onCreate(database: SQLiteDatabase, connectionSource: ConnectionSource): Unit = {}\r\n}<\/pre>\n
Mamy dwie metody – jedna jest wywo\u0142ywana przy tworzeniu bazy danych, a druga w momencie jej upgrade’u. Przy tworzeniu bazy danych \u00a0u\u017cywamy metody statycznej<\/p>\n
TableUtils.createTable(connectionSource, classOf[Document])<\/pre>\n
I ostatni\u0105 rzecz\u0105, kt\u00f3r\u0105 musimy zrobi\u0107 to utworzenie instancji DAO, kt\u00f3rych b\u0119dziemy u\u017cywa\u0107. Aby to zrobi\u0107 musimy tylko wywo\u0142a\u0107 metod\u0119 OrmDatabaseHelper.getDao(Class<T>), a zwr\u00f3cone DAO przekaza\u0107 jako parametr konstruktora dla\u00a0RuntimeExceptionDao.<\/p>\n","protected":false},"excerpt":{"rendered":"
W tym wpisie napisa\u0142em kilka s\u0142\u00f3w o przechowywaniu danych w mojej aplikacji. Wspomina\u0142em tam r\u00f3wnie\u017c, \u017ce z powodu prostego schematu bazy danych nie zamierzam u\u017cywa\u0107 ORMa. No wi\u0119c……<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,6],"tags":[5,3,4],"class_list":["post-54","post","type-post","status-publish","format-standard","hentry","category-daj-sie-poznac","category-simple-document-manager","tag-android","tag-dajsiepoznac","tag-sdm"],"yoast_head":"\nORM w Androidzie - Lukasz Antkowiak's blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/blog.lantkowiak.pl\/index.php\/2016\/03\/29\/orm-w-androidzie\/\" \/>\n<meta property=\"og:locale\" content=\"pl_PL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"ORM w Androidzie - Lukasz Antkowiak's blog\" \/>\n<meta property=\"og:description\" content=\"W tym wpisie napisa\u0142em kilka s\u0142\u00f3w o przechowywaniu danych w mojej aplikacji. Wspomina\u0142em tam r\u00f3wnie\u017c, \u017ce z powodu prostego schematu bazy danych nie zamierzam u\u017cywa\u0107 ORMa. No wi\u0119c…...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blog.lantkowiak.pl\/index.php\/2016\/03\/29\/orm-w-androidzie\/\" \/>\n<meta property=\"og:site_name\" content=\"Lukasz Antkowiak's blog\" \/>\n<meta property=\"article:published_time\" content=\"2016-03-29T16:59:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2016-03-25T06:56:58+00:00\" \/>\n<meta name=\"author\" content=\"\u0141ukasz Antkowiak\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Napisane przez\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u0141ukasz Antkowiak\" \/>\n\t<meta name=\"twitter:label2\" content=\"Szacowany czas czytania\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minuty\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/blog.lantkowiak.pl\/index.php\/2016\/03\/29\/orm-w-androidzie\/\",\"url\":\"https:\/\/blog.lantkowiak.pl\/index.php\/2016\/03\/29\/orm-w-androidzie\/\",\"name\":\"ORM w Androidzie - Lukasz Antkowiak's blog\",\"isPartOf\":{\"@id\":\"https:\/\/blog.lantkowiak.pl\/#website\"},\"datePublished\":\"2016-03-29T16:59:45+00:00\",\"dateModified\":\"2016-03-25T06:56:58+00:00\",\"author\":{\"@id\":\"https:\/\/blog.lantkowiak.pl\/#\/schema\/person\/009bfc4db220c225786c59b1748ba1e6\"},\"breadcrumb\":{\"@id\":\"https:\/\/blog.lantkowiak.pl\/index.php\/2016\/03\/29\/orm-w-androidzie\/#breadcrumb\"},\"inLanguage\":\"pl-PL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/blog.lantkowiak.pl\/index.php\/2016\/03\/29\/orm-w-androidzie\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/blog.lantkowiak.pl\/index.php\/2016\/03\/29\/orm-w-androidzie\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Strona g\u0142\u00f3wna\",\"item\":\"https:\/\/blog.lantkowiak.pl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ORM w Androidzie\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/blog.lantkowiak.pl\/#website\",\"url\":\"https:\/\/blog.lantkowiak.pl\/\",\"name\":\"Lukasz Antkowiak's blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/blog.lantkowiak.pl\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"pl-PL\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/blog.lantkowiak.pl\/#\/schema\/person\/009bfc4db220c225786c59b1748ba1e6\",\"name\":\"\u0141ukasz Antkowiak\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"pl-PL\",\"@id\":\"https:\/\/blog.lantkowiak.pl\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/e18e2bfe319da9b5757cf7f7ae1bfecf?s=96&d=monsterid&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/e18e2bfe319da9b5757cf7f7ae1bfecf?s=96&d=monsterid&r=g\",\"caption\":\"\u0141ukasz Antkowiak\"},\"description\":\"dd\",\"url\":\"https:\/\/blog.lantkowiak.pl\/index.php\/author\/antek\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"ORM w Androidzie - Lukasz Antkowiak's blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/blog.lantkowiak.pl\/index.php\/2016\/03\/29\/orm-w-androidzie\/","og_locale":"pl_PL","og_type":"article","og_title":"ORM w Androidzie - Lukasz Antkowiak's blog","og_description":"W tym wpisie napisa\u0142em kilka s\u0142\u00f3w o przechowywaniu danych w mojej aplikacji. Wspomina\u0142em tam r\u00f3wnie\u017c, \u017ce z powodu prostego schematu bazy danych nie zamierzam u\u017cywa\u0107 ORMa. No wi\u0119c…...","og_url":"https:\/\/blog.lantkowiak.pl\/index.php\/2016\/03\/29\/orm-w-androidzie\/","og_site_name":"Lukasz Antkowiak's blog","article_published_time":"2016-03-29T16:59:45+00:00","article_modified_time":"2016-03-25T06:56:58+00:00","author":"\u0141ukasz Antkowiak","twitter_card":"summary_large_image","twitter_misc":{"Napisane przez":"\u0141ukasz Antkowiak","Szacowany czas czytania":"2 minuty"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/blog.lantkowiak.pl\/index.php\/2016\/03\/29\/orm-w-androidzie\/","url":"https:\/\/blog.lantkowiak.pl\/index.php\/2016\/03\/29\/orm-w-androidzie\/","name":"ORM w Androidzie - Lukasz Antkowiak's blog","isPartOf":{"@id":"https:\/\/blog.lantkowiak.pl\/#website"},"datePublished":"2016-03-29T16:59:45+00:00","dateModified":"2016-03-25T06:56:58+00:00","author":{"@id":"https:\/\/blog.lantkowiak.pl\/#\/schema\/person\/009bfc4db220c225786c59b1748ba1e6"},"breadcrumb":{"@id":"https:\/\/blog.lantkowiak.pl\/index.php\/2016\/03\/29\/orm-w-androidzie\/#breadcrumb"},"inLanguage":"pl-PL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog.lantkowiak.pl\/index.php\/2016\/03\/29\/orm-w-androidzie\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/blog.lantkowiak.pl\/index.php\/2016\/03\/29\/orm-w-androidzie\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Strona g\u0142\u00f3wna","item":"https:\/\/blog.lantkowiak.pl\/"},{"@type":"ListItem","position":2,"name":"ORM w Androidzie"}]},{"@type":"WebSite","@id":"https:\/\/blog.lantkowiak.pl\/#website","url":"https:\/\/blog.lantkowiak.pl\/","name":"Lukasz Antkowiak's blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blog.lantkowiak.pl\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"pl-PL"},{"@type":"Person","@id":"https:\/\/blog.lantkowiak.pl\/#\/schema\/person\/009bfc4db220c225786c59b1748ba1e6","name":"\u0141ukasz Antkowiak","image":{"@type":"ImageObject","inLanguage":"pl-PL","@id":"https:\/\/blog.lantkowiak.pl\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/e18e2bfe319da9b5757cf7f7ae1bfecf?s=96&d=monsterid&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/e18e2bfe319da9b5757cf7f7ae1bfecf?s=96&d=monsterid&r=g","caption":"\u0141ukasz Antkowiak"},"description":"dd","url":"https:\/\/blog.lantkowiak.pl\/index.php\/author\/antek\/"}]}},"_links":{"self":[{"href":"https:\/\/blog.lantkowiak.pl\/index.php\/wp-json\/wp\/v2\/posts\/54","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.lantkowiak.pl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.lantkowiak.pl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.lantkowiak.pl\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.lantkowiak.pl\/index.php\/wp-json\/wp\/v2\/comments?post=54"}],"version-history":[{"count":3,"href":"https:\/\/blog.lantkowiak.pl\/index.php\/wp-json\/wp\/v2\/posts\/54\/revisions"}],"predecessor-version":[{"id":57,"href":"https:\/\/blog.lantkowiak.pl\/index.php\/wp-json\/wp\/v2\/posts\/54\/revisions\/57"}],"wp:attachment":[{"href":"https:\/\/blog.lantkowiak.pl\/index.php\/wp-json\/wp\/v2\/media?parent=54"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.lantkowiak.pl\/index.php\/wp-json\/wp\/v2\/categories?post=54"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.lantkowiak.pl\/index.php\/wp-json\/wp\/v2\/tags?post=54"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}