Class: Catori::Db

Inherits:
Object
  • Object
show all
Defined in:
lib/catori/Db.rb

Constant Summary collapse

@@db = 
nil

Class Method Summary collapse

Class Method Details

.actualizarAlbumFecha(oInfo) ⇒ Object 



65
66
67
68
69
70
71
 
# File 'lib/catori/Db.rb', line 65

def self.actualizarAlbumFecha(oInfo)
	sAlbum=oInfo.album
	sFecha=oInfo.year
	sArtist=oInfo.artist
	sql="UPDATE album SET album_year=? WHERE artist_id=? and album_id=?"
	@@db.execute(sql,sFecha,sArtist.crearSha,sAlbum.crearSha)
end

.actualizarArchivo(oInfo) ⇒ Object 



72
73
74
75
76
77
78
79
80
 
# File 'lib/catori/Db.rb', line 72

def self.actualizarArchivo(oInfo)
	sPathId=oInfo.sFile.crearSha();
	sAlbum=oInfo.album.crearSha
	sArtist=oInfo.artist.crearSha
	sSong=oInfo.title.crearSha
	raise "Error con el id de archivo" if (@@db.select_one("SELECT COUNT(*) from file WHERE cd_id=? AND file_id=?",oInfo.cd,sPathId).to_s=="0")
	sql="UPDATE file SET artist_id=?,album_id=?,song_id=? WHERE cd_id=? AND file_id=?"
	@@db.execute(sql,sArtist,sAlbum,sSong,oInfo.cd,sPathId)
end

.conectar ⇒ Object 



12
13
14
15
16
17
18
 
# File 'lib/catori/Db.rb', line 12

def self.conectar
	if @@db.nil?
		data=self.data_conexion
		@@db=DBI.connect('DBI:Mysql:'+data['database'], data['user'], data['password'])
	end
	@@db
end

.data_conexion ⇒ Object 



19
20
21
22
23
24
25
26
27
28
 
# File 'lib/catori/Db.rb', line 19

def self.data_conexion
	if(File.exists?(Catori::CONFIG_FILE))
		data={}
		require 'yaml'
		File.open( Catori::CONFIG_FILE ) { |yf| data=YAML::load( yf ) }
	else
		raise "Install the application using catori --install"
	end
	data
end

.llenarAlbum(oInfo) ⇒ Object 



55
56
57
58
59
60
61
62
63
64
 
# File 'lib/catori/Db.rb', line 55

def self.llenarAlbum(oInfo)
	sAlbum=oInfo.album
	sFecha=oInfo.year
	sArtist=oInfo.artist
	if(@@db.select_one("select COUNT(*) from album WHERE artist_id=? AND album_id=?",sArtist.crearSha,sAlbum.crearSha).to_s=="0")
		#puts "Agregar album #{sAlbum}"
		sql="INSERT INTO album (artist_id,album_id,album_name,album_year) VALUES (?,?,?,?)"
		@@db.execute(sql,sArtist.crearSha,sAlbum.crearSha,sAlbum,sFecha)
	end
end

.llenarArtista(oInfo) ⇒ Object 



47
48
49
50
51
52
53
54
 
# File 'lib/catori/Db.rb', line 47

def self.llenarArtista(oInfo)
	sArtist=oInfo.artist
	if(@@db.select_one("select COUNT(*) from artist WHERE artist_id=?",sArtist.crearSha).to_s=="0")
		#puts "Agregar artista #{sArtist}"
		sql="INSERT INTO artist (artist_id,artist_name) VALUES (?,?)"
		@@db.execute(sql,sArtist.crearSha,sArtist)
	end
end

.llenarCancion(oInfo) ⇒ Object 



29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
 
# File 'lib/catori/Db.rb', line 29

def self.llenarCancion(oInfo)
	sSong=oInfo.title
	if(@@db.select_one("select COUNT(*) from song WHERE song_id=?",sSong.crearSha).to_s=="0")
		#puts "Agregar cancion #{sSong}"
		sql="INSERT INTO song (song_id,song_name) VALUES (?,?)"
		@@db.execute(sql,sSong.crearSha,sSong)
	end
	sAlbum=oInfo.album
	sArtist=oInfo.artist
	if(@@db.select_one("select COUNT(*) from album_song WHERE artist_id=? AND album_id=? and song_id=?",sArtist.crearSha,sAlbum.crearSha,sSong.crearSha).to_s=="0")
		#puts "Agregar cancion en album #{sSong}"
		sql="INSERT INTO album_song (artist_id,album_id,song_id,as_track) VALUES (?,?,?,?)"
		@@db.execute(sql, sArtist.crearSha, sAlbum.crearSha, sSong.crearSha, oInfo.tracknumber)
	elsif(@@db.select_one("SELECT COUNT(*) from album_song WHERE as_track!=? and artist_id=? and album_id=? and song_id=?",oInfo.tracknumber, sArtist.crearSha, sAlbum.crearSha, sSong.crearSha))
		sql="UPDATE album_song SET as_track=? WHERE artist_id=? and album_id=? and song_id=?"
		@@db.execute(sql,oInfo.tracknumber,sArtist.crearSha, sAlbum.crearSha, sSong.crearSha)
	end
end