AudioFerret - Revision history

Woozle: starting in on v2

2012-12-24T03:17:38Z

starting in on v2

← Older revision		Revision as of 03:17, 24 December 2012
Line 10:		Line 10:
	==Versions==		==Versions==
	* [[/v1]] - the first schema, with Albums and Artists in separate tables		* [[/v1]] - the first schema, with Albums and Artists in separate tables
			* [[/v2]] - a redesign that is less stupid

Woozle: moved all SQL to subpages

2012-01-10T02:52:45Z

moved all SQL to subpages

Show changes

Woozle: /* qryArtists_index */ artists->artist

2010-04-14T19:06:09Z

qryArtists_index: artists->artist

← Older revision		Revision as of 19:06, 14 April 2010
Line 144:		Line 144:
	id,		id,
	name		name
	FROM ~~Artists~~		FROM Artist
	UNION		UNION
	SELECT		SELECT
	id,		id,
	sort		sort
	FROM ~~Artists~~ WHERE NULLIF(sort,'') IS NOT NULL ORDER BY name;</mysql>		FROM Artist WHERE NULLIF(sort,'') IS NOT NULL ORDER BY name;</mysql>

	===Optional SQL===		===Optional SQL===

66.93.241.126: /* SQL */ singularizing albums, artists, titles

2010-04-11T20:05:36Z

SQL: singularizing albums, artists, titles

← Older revision		Revision as of 20:05, 11 April 2010
Line 10:		Line 10:
	<mysql>CREATE DATABASE /!32312 IF NOT EXISTS/ audioferret;		<mysql>CREATE DATABASE /!32312 IF NOT EXISTS/ audioferret;
	USE audioferret;		USE audioferret;
	CREATE TABLE `~~Albums~~` (		CREATE TABLE `Album` (
	`id` int(11) NOT NULL auto_increment,		`id` int(11) NOT NULL auto_increment,
	`idartist` int(11) default NULL,		`idartist` int(11) default NULL,
Line 21:		Line 21:
	) ENGINE=MyISAM DEFAULT CHARSET=latin1;		) ENGINE=MyISAM DEFAULT CHARSET=latin1;

	CREATE TABLE `~~Artists~~` (		CREATE TABLE `Artist` (
	`id` int(11) NOT NULL auto_increment,		`id` int(11) NOT NULL auto_increment,
	`name` varchar(50) default NULL,		`name` varchar(50) default NULL,
Line 36:		Line 36:
	) ENGINE=MyISAM AUTO_INCREMENT=9068 DEFAULT CHARSET=latin1;		) ENGINE=MyISAM AUTO_INCREMENT=9068 DEFAULT CHARSET=latin1;

	CREATE TABLE `~~Titles~~` (		CREATE TABLE `Title` (
	`id` int(11) NOT NULL auto_increment,		`id` int(11) NOT NULL auto_increment,
	`album_id` int(11) default NULL,		`album_id` int(11) default NULL,

Woozle: /* Overview */ +category:software/incomplete

2008-08-17T13:28:40Z

Overview: +category:software/incomplete

← Older revision		Revision as of 13:28, 17 August 2008
Line 1:		Line 1:
	==Overview==		==Overview==
	[[AudioFerret]] is a [[client-server]] software system for managing audio files for playback. It is intended to replicate the functions of an old-style distributed [[jukebox]], where multiple locations could request songs which were then queued for play on the main "server" unit audible to everyone in the location, but without any unnecessary limitations (e.g. the old units could only host so many songs, and there was no way to view information about what was being played) and making the best use of now-available tools (e.g. wiki pages for more information).		[[category:software/incomplete]][[AudioFerret]] is a [[client-server]] software system for managing audio files (it could also work with video files) for playback. It is intended to replicate the functions of an old-style distributed [[jukebox]], where multiple locations could request songs which were then queued for play on the main "server" unit audible to everyone in the location, but without any unnecessary limitations (e.g. the old units could only host so many songs, and there was no way to view information about what was being played) and making the best use of now-available tools (e.g. wiki pages for more information).

	This project is still under development; I have working clients written in [[MS Access 97]] and [[Gambas]], and a [[PHP]] client partly written; the audio server was originally written in Access 97 but I have now written one in Gambas which generally works better (although it needs some fixes and improvements).		This project is still under development; I have working clients written in [[MS Access 97]] and [[Gambas]], and a [[PHP]] client partly written; the audio server was originally written in Access 97 but I have now written one in Gambas which generally works better (although it needs some fixes and improvements).

Woozle: /* qryCbx_Titles */ qryArtists_index

2008-08-10T01:15:38Z

qryCbx_Titles: qryArtists_index

@@ Line 139: / Line 139: @@
    ) LEFT JOIN Artists AS aa ON ab.idArtist=aa.ID
 ORDER BY t.name,t.track;</mysql>
 ===Optional SQL===

Woozle: /* qryCbx_Titles */ tested & fixed

2008-02-22T16:59:04Z

qryCbx_Titles: tested & fixed

← Older revision		Revision as of 16:59, 22 February 2008
Line 131:		Line 131:
	SELECT		SELECT
	t.ID,		t.ID,
	CONCAT_WS(' - ',t.~~Name~~,IF(t.Artist_ID IS NULL,aa.Name,at.Name),ab.Name) AS Track		CONCAT_WS(' - ',IF(t.name IS NULL,t.track,t.name),IF(t.Artist_ID IS NULL,aa.Name,at.Name),ab.Name) AS Track,
			t.album_id
	FROM		FROM
	(		(
	(Titles AS t LEFT JOIN Artists AS at ON ~~nz(~~t.Artist_ID)=at.ID)		(Titles AS t LEFT JOIN Artists AS at ON t.Artist_ID=at.ID)
	LEFT JOIN Albums AS ab ON ~~nz(~~t.Album_ID)=ab.ID		LEFT JOIN Albums AS ab ON t.Album_ID=ab.ID
	) LEFT JOIN Artists AS aa ON ~~nz(~~ab.idArtist)=aa.ID		) LEFT JOIN Artists AS aa ON ab.idArtist=aa.ID
	ORDER BY t.~~Name~~;</mysql>		ORDER BY t.name,t.track;</mysql>

	===Optional SQL===		===Optional SQL===

Woozle: /* qryCbx_Albums_byArtist */ qryCbx_Titles - from Access, not tested

2008-02-22T16:46:10Z

qryCbx_Albums_byArtist: qryCbx_Titles - from Access, not tested

@@ Line 127: / Line 127: @@
    FROM Albums AS a
 ORDER BY a.idartist, CONCAT(sort,name);</mysql>
 ===Optional SQL===

Woozle: /* SQL */ isUnavail flag

2008-02-01T00:54:58Z

SQL: isUnavail flag

← Older revision		Revision as of 00:54, 1 February 2008
Line 43:		Line 43:
	`name` varchar(255) default NULL,		`name` varchar(255) default NULL,
	`id_file` int(11) default NULL,		`id_file` int(11) default NULL,
			`isUnavail` bool default FALSE COMMENT "TRUE = don't show this title as needing a file assigned",
	`WhenAdded` DATETIME DEFAULT NULL COMMENT 'when the track was added to the database',		`WhenAdded` DATETIME DEFAULT NULL COMMENT 'when the track was added to the database',
	`WhenChanged` DATETIME DEFAULT NULL COMMENT 'when the track record was last modified',		`WhenChanged` DATETIME DEFAULT NULL COMMENT 'when the track record was last modified',

Woozle: /* SQL */ Artists.id should be auto-increment

2008-01-18T02:51:12Z

SQL: Artists.id should be auto-increment

← Older revision		Revision as of 02:51, 18 January 2008
Line 22:		Line 22:

	CREATE TABLE `Artists` (		CREATE TABLE `Artists` (
	`id` int(11) NOT NULL,		`id` int(11) NOT NULL auto_increment,
	`name` varchar(50) default NULL,		`name` varchar(50) default NULL,
	`filekey` varchar(10) default NULL,		`filekey` varchar(10) default NULL,
Line 103:		Line 103:
	CREATE OR REPLACE VIEW qryTrack_Playing AS		CREATE OR REPLACE VIEW qryTrack_Playing AS
	SELECT * from Tracks_Played ORDER BY ID DESC LIMIT 1;</mysql>		SELECT * from Tracks_Played ORDER BY ID DESC LIMIT 1;</mysql>

	===qryCbx_Artists===		===qryCbx_Artists===
	<mysql>CREATE OR REPLACE VIEW qryCbx_Artists AS		<mysql>CREATE OR REPLACE VIEW qryCbx_Artists AS