[Tizen-submit] 20720: New package Tizen:IVI:Genivi/media-data-sdk

noreply at tizen.org noreply at tizen.org
Fri Jan 31 06:18:04 GMT 2014


Hi,
Adding new package media-data-sdk in project Tizen:IVI:Genivi. Please review and accept ASAP.

Justification for this new package:

Submitter: Graydon, Tracy <tracy.graydon at intel.com>
Comments: submit/tizen_ivi_genivi/20140131.061130
Git project: platform/core/multimedia/media-data-sdk
Tag: submit/tizen_ivi_genivi/20140131.061130
Commit: d06cc527cfd9ffeeaebfb473b736130812d2b958 resetting manifest requested domain to floor

Thank You,
Graydon, Tracy

[This message was auto-generated]

---

Request: #20720

  submit:       Tizen:IVI:Genivi:build/media-data-sdk(cleanup) -> Tizen:IVI:Genivi


Message:
Submitter: Graydon, Tracy <tracy.graydon at intel.com>
Comments: submit/tizen_ivi_genivi/20140131.061130
Git project: platform/core/multimedia/media-data-sdk
Tag: submit/tizen_ivi_genivi/20140131.061130
Commit: d06cc527cfd9ffeeaebfb473b736130812d2b958 resetting manifest requested domain to floor

State:   new        2014-01-31T06:19:46 tizenrobot
Comment: <no comment>
new:
----
  media-data-sdk-0.1.42.tar.gz
  media-data-sdk.manifest
  media-data-sdk.spec

spec files:
-----------

++++++ new spec file:
--- media-data-sdk.spec
+++ media-data-sdk.spec
@@ -0,0 +1,170 @@
+%define _optdir	/opt/usr
+
+Name:       media-data-sdk
+VCS:        platform/core/multimedia/media-data-sdk#d06cc527cfd9ffeeaebfb473b736130812d2b958
+Summary:    Media data for SDK. Image/Sounds/Videos and Others.
+Version: 0.1.42
+Release:    1
+Group:      TO_BE/FILLED_IN
+License:    Apache License, Version 2.0
+Source0:    %{name}-%{version}.tar.gz
+Source1001: 	media-data-sdk.manifest
+Requires(post): coreutils
+Requires(post): sqlite
+BuildRequires: cmake
+
+%description
+Description: Media data for SDK. Image/Sounds/Videos and Others.
+
+%prep
+%setup -q
+cp %{SOURCE1001} .
+LDFLAGS+="-Wl,--rpath=%{PREFIX}/lib -Wl,--as-needed -Wl,--hash-style=both"; export LDFLAGS
+
+cmake . -DCMAKE_INSTALL_PREFIX=%{_optdir}
+
+%build
+make %{?jobs:-j%jobs}
+
+%install
+%make_install
+
+##change permission install files
+chmod 666 %{buildroot}/opt/usr/media/Images/*
+
+##delete unusing files
+rm %{buildroot}/opt/usr/media/Downloads/.gitignore
+rm %{buildroot}/opt/usr/media/Videos/.gitignore
+rm %{buildroot}/opt/usr/media/Camera/.gitignore
+rm %{buildroot}/opt/usr/media/Sounds/Voice\ recorder/.gitignore
+
+#Create DB
+mkdir -p %{buildroot}/opt/usr/dbspace
+sqlite3 %{buildroot}/opt/usr/dbspace/.media.db 'PRAGMA journal_mode = PERSIST;
+
+	CREATE TABLE IF NOT EXISTS album (album_id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL, artist TEXT, album_art TEXT, unique(name, artist));
+	CREATE TABLE IF NOT EXISTS bookmark (bookmark_id INTEGER PRIMARY KEY AUTOINCREMENT, media_uuid TEXT NOT NULL, marked_time INTEGER DEFAULT 0, thumbnail_path  TEXT, unique(media_uuid, marked_time));
+	CREATE TABLE IF NOT EXISTS folder (folder_uuid TEXT PRIMARY KEY, path TEXT NOT NULL UNIQUE, name TEXT NOT NULL, modified_time INTEGER DEFAULT 0, storage_type INTEGER, unique(path, name, storage_type));
+	CREATE TABLE IF NOT EXISTS media (media_uuid TEXT PRIMARY KEY, path TEXT NOT NULL UNIQUE, file_name TEXT NOT NULL, media_type INTEGER, mime_type TEXT, size INTEGER DEFAULT 0, added_time INTEGER DEFAULT 0, modified_time INTEGER DEFAULT 0, folder_uuid TEXT NOT NULL, thumbnail_path TEXT, title TEXT, album_id INTEGER DEFAULT 0, album TEXT, artist TEXT, genre TEXT, composer TEXT, year TEXT, recorded_date TEXT, copyright TEXT, track_num TEXT, description TEXT, bitrate INTEGER DEFAULT -1, samplerate INTEGER DEFAULT -1, channel INTEGER DEFAULT -1, duration INTEGER DEFAULT -1, longitude DOUBLE DEFAULT 0, latitude DOUBLE DEFAULT 0, altitude DOUBLE DEFAULT 0, width INTEGER DEFAULT -1, height INTEGER DEFAULT -1, datetaken TEXT, orientation INTEGER DEFAULT -1, burst_id TEXT, played_count INTEGER DEFAULT 0, last_played_time INTEGER DEFAULT 0, last_played_position INTEGER DEFAULT 0, rating INTEGER DEFAULT 0, favourite INTEGER DEFAULT 0, author TEXT, provider TEXT, content_name TEXT, categ
 ory TEXT, location_tag TEXT, age_rating TEXT, keyword TEXT, is_drm INTEGER DEFAULT 0, storage_type INTEGER, validity INTEGER DEFAULT 1, unique(path, file_name) );
+	CREATE TABLE IF NOT EXISTS playlist ( playlist_id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL UNIQUE, thumbnail_path TEXT );
+	CREATE TABLE IF NOT EXISTS playlist_map ( _id INTEGER PRIMARY KEY AUTOINCREMENT, playlist_id INTEGER NOT NULL, media_uuid TEXT NOT NULL, play_order INTEGER NOT NULL );
+	CREATE TABLE IF NOT EXISTS tag ( tag_id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT NOT NULL UNIQUE );
+	CREATE TABLE IF NOT EXISTS tag_map ( _id INTEGER PRIMARY KEY AUTOINCREMENT, tag_id INTEGER NOT NULL, media_uuid TEXT NOT NULL, unique(tag_id, media_uuid) );
+	CREATE INDEX folder_folder_uuid_idx on folder (folder_uuid);
+	CREATE INDEX folder_uuid_idx on media (folder_uuid);
+	CREATE INDEX media_album_idx on media (album);
+	CREATE INDEX media_artist_idx on media (artist);
+	CREATE INDEX media_author_idx on media (author);
+	CREATE INDEX media_category_idx on media (category);
+	CREATE INDEX media_composer_idx on media (composer);
+	CREATE INDEX media_content_name_idx on media (content_name);
+	CREATE INDEX media_file_name_idx on media (file_name);
+	CREATE INDEX media_genre_idx on media (genre);
+	CREATE INDEX media_location_tag_idx on media (location_tag);
+	CREATE INDEX media_media_type_idx on media (media_type);
+	CREATE INDEX media_media_uuid_idx on media (media_uuid);
+	CREATE INDEX media_modified_time_idx on media (modified_time);
+	CREATE INDEX media_path_idx on media (path);
+	CREATE INDEX media_provider_idx on media (provider);
+	CREATE INDEX media_title_idx on media (title);
+
+	CREATE VIEW IF NOT EXISTS playlist_view AS
+	SELECT 
+	p.playlist_id, p.name, p.thumbnail_path, media_count, pm._id as pm_id, pm.play_order, m.media_uuid, path, file_name, media_type, mime_type, size, added_time, modified_time, m.thumbnail_path, description, rating, favourite, author, provider, content_name, category, location_tag, age_rating, keyword, is_drm, storage_type, longitude, latitude, altitude, width, height, datetaken, orientation, title, album, artist, genre, composer, year, recorded_date, copyright, track_num, bitrate, duration, played_count, last_played_time, last_played_position, samplerate, channel FROM playlist AS p 

Please refer to OBS webUI for more details about this SR.


More information about the Tizen-submit mailing list