{"id":67,"date":"2012-01-03T13:01:32","date_gmt":"2012-01-03T04:01:32","guid":{"rendered":"http:\/\/ec2-52-35-32-26.us-west-2.compute.amazonaws.com\/blog\/2012\/01\/03\/20120103130132\/"},"modified":"2012-01-03T13:01:32","modified_gmt":"2012-01-03T04:01:32","slug":"20120103130132","status":"publish","type":"post","link":"http:\/\/daimlars.jp\/blog\/?p=67","title":{"rendered":"iTunes\u3067\u518d\u751f\u30c1\u30e3\u30fc\u30c8\u30e9\u30f3\u30ad\u30f3\u30b0\u3092\u5b9a\u671f\u7684\u306b\u81ea\u52d5\u3067\u4f5c\u308a\u305f\u3044(3)"},"content":{"rendered":"

\u3072\u3068\u307e\u305a\u3001\u4f5c\u3063\u3066\u307f\u305f\u3002<\/p>\n<\/p>\n

MySQL<\/a>\u3067\u30c7\u30fc\u30bf\u7ba1\u7406\u3092\u3057\u3066\u3001\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u5b9f\u884c\u3059\u308b\u3068\u3001\u524d\u56de\u304b\u3089\u306e\u518d\u751f\u56de\u6570\u304c\u5dee\u5206\u3068\u3057\u3066\u767b\u9332\u3055\u308c\u308b\u3002<\/p>\n

DB\u306f\u3056\u3063\u3068\u3053\u3093\u306a\u69cb\u6210\u3067\u30c6\u30fc\u30d6\u30eb\u306f\uff12\u3064\u306e\u307f\u3002<\/p>\n

mysql<\/a>> desc tbm_track;<\/p>\n

+———————-+————–+——+—–+———+——-+<\/p>\n

| Field | Type | Null | Key | Default | Extra |<\/p>\n

+———————-+————–+——+—–+———+——-+<\/p>\n

| Track_id | int(11) | NO | PRI | NULL | |<\/p>\n

| Name | varchar(160) | YES | | NULL | |<\/p>\n

| Artist | varchar(80) | YES | | NULL | |<\/p>\n

| Album_Artist | varchar(45) | YES | | NULL | |<\/p>\n

| Album | varchar(200) | YES | | NULL | |<\/p>\n

| Genre | varchar(45) | YES | | NULL | |<\/p>\n

| Kind | varchar(45) | YES | | NULL | |<\/p>\n

| Size | int(11) | YES | | NULL | |<\/p>\n

| Total_Time | int(11) | YES | | NULL | |<\/p>\n

| Disc_Number | int(11) | YES | | NULL | |<\/p>\n

| Disc_Count | int(11) | YES | | NULL | |<\/p>\n

| Year | int(11) | YES | | NULL | |<\/p>\n

| Date_Modified | datetime | YES | | NULL | |<\/p>\n

| Date_Added | datetime | YES | | NULL | |<\/p>\n

| Bit_Rate | int(11) | YES | | NULL | |<\/p>\n

| Sample_Rate | int(11) | YES | | NULL | |<\/p>\n

| Play_Count | int(11) | YES | | NULL | |<\/p>\n

| play_date | datetime | YES | | NULL | |<\/p>\n

| Play_Date_UTC<\/a> | datetime | YES | | NULL | |<\/p>\n

| Sort_Atrist | varchar(45) | YES | | NULL | |<\/p>\n

| Compilation | varchar(45) | YES | | NULL | |<\/p>\n

| Persistent_ID | varchar(45) | YES | | NULL | |<\/p>\n

| Track_Type | varchar(45) | YES | | NULL | |<\/p>\n

| Location | varchar(500) | YES | | NULL | |<\/p>\n

| File_Folder_Count | int(11) | YES | | NULL | |<\/p>\n

| Lobrary_Folder_Count | int(11) | YES | | NULL | |<\/p>\n

+———————-+————–+——+—–+———+——-+<\/p>\n

26 rows in set (0.02 sec)<\/p>\n<\/p>\n

mysql<\/a>> desc tbl_update<\/p>\n

-> ;<\/p>\n

+————————+————-+——+—–+———+——-+<\/p>\n

| Field | Type | Null | Key | Default | Extra |<\/p>\n

+————————+————-+——+—–+———+——-+<\/p>\n

| Track_ID | int(11) | NO | PRI | NULL | |<\/p>\n

| Update_data | datetime | NO | PRI | NULL | |<\/p>\n

| Type | varchar(45) | YES | | NULL | |<\/p>\n

| Play_Count | int(11) | YES | | NULL | |<\/p>\n

| Incremental_Play_Count | int(11) | YES | | NULL | |<\/p>\n

+————————+————-+——+—–+———+——-+<\/p>\n

5 rows in set, 1 warning (0.02 sec)<\/p>\n<\/p>\n

mysql<\/a>><\/p><\/blockquote>\n

Java<\/a>\u306e\u30bd\u30fc\u30b9\u306f\u3072\u3068\u307e\u305a\u52d5\u304b\u3057\u305f\u30ec\u30d9\u30eb\u3002XML<\/a>\u306e\u8aad\u53d6\u306fhttp:\/\/d.hatena.ne.jp\/terazzo\/20080524\/1211656594<\/a>\u3092\u53c2\u8003\u306b\u3057\u3066\u3001\u305d\u3053\u306e\u30bd\u30fc\u30b9\u306f\u5272\u611b\u3002<\/p>\n

import java<\/a>.io.IOException;<\/p>\n

import java<\/a>.net.URL;<\/p>\n

import java<\/a>.util.Date;<\/p>\n

import java<\/a>.util.List;<\/p>\n

import java<\/a>.util.Map;<\/p>\n<\/p>\n

import javax.persistence.EntityManager;<\/p>\n

import javax.persistence.EntityManagerFactory;<\/p>\n

import javax.persistence.EntityTransaction;<\/p>\n

import javax.persistence.Persistence;<\/p>\n

import javax.persistence.Query;<\/p>\n<\/p>\n

import org.xml<\/a>.sax.SAXException;<\/p>\n<\/p>\n

import sample.plist.PropertyListUtils;<\/p>\n<\/p>\n

public class ItunesList {<\/p>\n<\/p>\n

\/**<\/p>\n

* @param args<\/p>\n

*\/<\/p>\n

public static void main(String[] args) {<\/p>\n

\/\/ TODO \u81ea\u52d5\u751f\u6210\u3055\u308c\u305f\u30e1\u30bd\u30c3\u30c9<\/a>\u30fb\u30b9\u30bf\u30d6<\/p>\n

ItunesList t = new ItunesList();<\/p>\n

try{<\/p>\n

t.printTracks();<\/p>\n

}catch (Exception e){<\/p>\n

e.printStackTrace();<\/p>\n

}<\/p>\n

}<\/p>\n

private static final String TEST_FILE_PATH = “file:C:\\\\Users\\\\jun\\\\Music\\\\iTunes<\/a>\\\\iTunes<\/a> Music Library.xml<\/a>“;<\/p>\n<\/p>\n

public void printTracks() throws IOException, SAXException {<\/p>\n<\/p>\n

\/\/ xml<\/a>\u30d5\u30a1\u30a4\u30eb\u306e\u8aad\u307f\u8fbc\u307f<\/p>\n

\/\/URL url = getClass().getResource(TEST_FILE_PATH);<\/p>\n

URL url = new URL(TEST_FILE_PATH);<\/p>\n

Object content = PropertyListUtils.load(url);<\/p>\n

Map tracks = (Map)*1<\/a> {<\/p>\n

try{<\/p>\n

Integer track_id_xml<\/a> = (Integer)xml<\/a>_track.get(“Track ID”);<\/p>\n<\/p>\n

\/\/\u3059\u3067\u306bDB\u306b\u767b\u9332\u6e08\u307f\u304b\u30c1\u30a7\u30c3\u30af<\/p>\n

boolean already_rip_check=false;<\/p>\n

for(TbmTrack tbm_track_db : db_mater_list){<\/p>\n

if(tbm_track_db.getTrack_id() == track_id_xml<\/a>.intValue()){<\/p>\n

\/\/\u518d\u751f\u56de\u6570\u3092\u66f4\u65b0<\/p>\n

already_rip_check = true;<\/p>\n

if*2<\/a>.intValue() ){<\/p>\n

TblUpdate update = this.setTblUpdate(tbm_track_db,(Integer)xml<\/a>_track.get(“Play Count”));<\/p>\n

em.persist(update);<\/p>\n

tbm_track_db.setPlay_Count*3<\/a>;<\/p>\n

}<\/p>\n

break;<\/p>\n

}<\/p>\n

}<\/p>\n

if(!already_rip_check){<\/p>\n

\/\/\u8a72\u5f53\u30ec\u30b3\u30fc\u30c9\u304c\u7121\u3044\u306e\u3067\u65b0\u898f\u8ffd\u52a0<\/p>\n

TbmTrack track = setTbmTrack(xml<\/a>_track);<\/p>\n

em.persist(track);<\/p>\n

}<\/p>\n

}catch (Exception e){<\/p>\n

e.printStackTrace();<\/p>\n

}<\/p>\n<\/p>\n

}<\/p>\n

tx.commit();<\/p>\n

em.close();<\/p>\n

emf.close();<\/p>\n

}<\/p>\n<\/p>\n

private TblUpdate setTblUpdate(TbmTrack tbmtrack,Integer fromXml){<\/p>\n

TblUpdate update = new TblUpdate();<\/p>\n

update.setTrack_ID(tbmtrack.getTrack_id());<\/p>\n

update.setUpdate_data(new Date());<\/p>\n

update.setPlay_Count(tbmtrack.getPlay_Count());<\/p>\n

update.setIncremental_Play_Count(fromXml.intValue() – tbmtrack.getPlay_Count());<\/p>\n

return update;<\/p>\n

}<\/p>\n<\/p>\n

private TbmTrack setTbmTrack(Map xml<\/a>_track) {<\/p>\n

TbmTrack track = new TbmTrack();<\/p>\n

track.setTrack_id*4<\/a>;<\/p>\n

track.setAlbum*5<\/a>;<\/p>\n

track.setAlbum_Artist*6<\/a>;<\/p>\n

track.setArtist*7<\/a>;<\/p>\n

if(xml<\/a>_track.get(“Bit Rate”) != null){<\/p>\n

track.setBit_Rate*8<\/a>;<\/p>\n

}<\/p>\n

track.setCompilation*9<\/a>;<\/p>\n

track.setDate_Added*10<\/a>;<\/p>\n

track.setName*11<\/a>;<\/p>\n

track.setGenre*12<\/a>;<\/p>\n

track.setKind*13<\/a>;<\/p>\n

track.setSize*14<\/a>;<\/p>\n

if(xml<\/a>_track.get(“Disc Number”) != null){<\/p>\n

track.setDisc_Number*15<\/a>;<\/p>\n

}<\/p>\n

if(xml<\/a>_track.get(“Disc Count”) != null){<\/p>\n

track.setDisc_Count*16<\/a>;<\/p>\n

}<\/p>\n

if(xml<\/a>_track.get(“Year”) != null){<\/p>\n

track.setYear*17<\/a>;<\/p>\n

}<\/p>\n

if(xml<\/a>_track.get(“Date Modified”) != null){<\/p>\n

track.setDate_Modified*18<\/a>;<\/p>\n

}<\/p>\n

if(xml<\/a>_track.get(“Sample Rate”) != null){<\/p>\n

track.setSample_Rate*19<\/a>;<\/p>\n

}<\/p>\n

if(xml<\/a>_track.get(“Play Count”) != null){<\/p>\n

track.setPlay_Count*20<\/a>;<\/p>\n

}<\/p>\n

if(xml<\/a>_track.get(“Play Date”) != null){<\/p>\n

track.setPlay_Date(new Date(((Integer) xml<\/a>_track.get(“Play Date”)).longValue()));<\/p>\n

}<\/p>\n

track.setPlay_Date_UTC<\/a>*21<\/a>;<\/p>\n

track.setCompilation*22<\/a>;<\/p>\n

track.setPersistent_ID*23<\/a>;<\/p>\n

track.setTrack_Type*24<\/a>;<\/p>\n

return track;<\/p>\n

}<\/p>\n<\/p>\n

public static List getAllRecordsTbmTrack(EntityManager em){<\/p>\n

Query q = em.createQuery(“select t from TbmTrack t”);<\/p>\n

List list = q.getResultList();<\/p>\n

return list;<\/p>\n

}<\/p>\n

}<\/p><\/blockquote>\n

\n

*1<\/a>:<\/span>Map) content).get(“Tracks”);<\/p>\n

int i=1;<\/p>\n<\/p>\n

EntityManagerFactory emf = Persistence.createEntityManagerFactory(“JPA<\/a>_test”);<\/p>\n

EntityManager em = emf.createEntityManager();<\/p>\n<\/p>\n

\/\/ DB\u306e\u6700\u65b0\u60c5\u5831\u3092\u53d6\u5f97<\/p>\n

List db_mater_list = getAllRecordsTbmTrack(em);<\/p>\n<\/p>\n

EntityTransaction tx = em.getTransaction();<\/p>\n

tx.begin();<\/p>\n

for (Map xml<\/a>_track : tracks.values(<\/span><\/p>\n

*2<\/a>:<\/span>xml<\/a>_track.get(“Play Count”) != null) &&<\/p>\n

tbm_track_db.getPlay_Count() != ((Integer)xml<\/a>_track.get(“Play Count”<\/span><\/p>\n

*3<\/a>:<\/span>Integer)xml<\/a>_track.get(“Play Count”<\/span><\/p>\n

*4<\/a>:<\/span>Integer)xml<\/a>_track.get(“Track ID”<\/span><\/p>\n

*5<\/a>:<\/span>String)xml<\/a>_track.get(“Album”<\/span><\/p>\n

*6<\/a>:<\/span>String)xml<\/a>_track.get(“Album Artist”<\/span><\/p>\n

*7<\/a>:<\/span>String)xml<\/a>_track.get(“Artist”<\/span><\/p>\n

*8<\/a>:<\/span>Integer)xml<\/a>_track.get(“Bit Rate”<\/span><\/p>\n

*9<\/a>:<\/span>String)xml<\/a>_track.get(“Compilation”<\/span><\/p>\n

*10<\/a>:<\/span>Date)xml<\/a>_track.get(“Date Added”<\/span><\/p>\n

*11<\/a>:<\/span>String)xml<\/a>_track.get(“Name”<\/span><\/p>\n

*12<\/a>:<\/span>String)xml<\/a>_track.get(“Genre”<\/span><\/p>\n

*13<\/a>:<\/span>String)xml<\/a>_track.get(“Kind”<\/span><\/p>\n

*14<\/a>:<\/span>Integer)xml<\/a>_track.get(“Size”<\/span><\/p>\n

*15<\/a>:<\/span>Integer)xml<\/a>_track.get(“Disc Number”<\/span><\/p>\n

*16<\/a>:<\/span>Integer)xml<\/a>_track.get(“Disc Count”<\/span><\/p>\n

*17<\/a>:<\/span>Integer)xml<\/a>_track.get(“Year”<\/span><\/p>\n

*18<\/a>:<\/span>Date)xml<\/a>_track.get(“Date Modified”<\/span><\/p>\n

*19<\/a>:<\/span>Integer)xml<\/a>_track.get(“Sample Rate”<\/span><\/p>\n

*20<\/a>:<\/span>Integer)xml<\/a>_track.get(“Play Count”<\/span><\/p>\n

*21<\/a>:<\/span>Date)xml<\/a>_track.get(“Play Date UTC<\/a>“<\/span><\/p>\n

*22<\/a>:<\/span>String)xml<\/a>_track.get(“Compilation”<\/span><\/p>\n

*23<\/a>:<\/span>String)xml<\/a>_track.get(“Persistent ID”<\/span><\/p>\n

*24<\/a>:<\/span>String)xml<\/a>_track.get(“Track Type”<\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\u3072\u3068\u307e\u305a\u3001\u4f5c\u3063\u3066\u307f\u305f\u3002 MySQL\u3067\u30c7\u30fc\u30bf\u7ba1\u7406\u3092\u3057\u3066\u3001\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u5b9f\u884c\u3059\u308b\u3068\u3001\u524d\u56de\u304b\u3089\u306e\u518d\u751f\u56de\u6570\u304c\u5dee\u5206\u3068\u3057\u3066\u767b\u9332\u3055\u308c\u308b\u3002 DB\u306f\u3056\u3063\u3068\u3053\u3093\u306a\u69cb\u6210\u3067\u30c6\u30fc\u30d6\u30eb\u306f\uff12\u3064\u306e\u307f\u3002 mysql> desc tbm_track; […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-67","post","type-post","status-publish","format-standard","hentry","category-java"],"_links":{"self":[{"href":"http:\/\/daimlars.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts\/67","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/daimlars.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/daimlars.jp\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/daimlars.jp\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/daimlars.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=67"}],"version-history":[{"count":0,"href":"http:\/\/daimlars.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts\/67\/revisions"}],"wp:attachment":[{"href":"http:\/\/daimlars.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=67"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/daimlars.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=67"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/daimlars.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=67"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}