ChinookDatabase Source Control Rss Feed

Patch Uploaded: #3717

NelsonCabral — Sun, 30 Aug 2009 11:50:07 GMT

NelsonCabral has uploaded a patch.

Description:
SQLite version 0.1
Commented out two parts :
- initial db drop and create, it looks like I cannot 'create a db' in a sqlite file, as a file = a db
- foreign keys constraints. SQLite doesn't support directly foreign keys, see http://www.justatheory.com/computers/databases/sqlite/foreign_key_triggers.html for a way to implement them with trigger
Easy test with firefox's sqlite manager extension

Source code checked in, #50685

lerocha — Sat, 16 May 2009 23:53:47 GMT

Renaming T4 template include file to use .ttinclude extension and fixing issue to generate files with UTF16 encoding.

Source code checked in, #49579

lerocha — Tue, 28 Apr 2009 05:04:29 GMT

Auto-generating the main T4 template file (chinook.t4) from the ChinookMetadata assembly and refactoring existing T4 templates to include Chinook.t4.

Source code checked in, #45543

lerocha — Tue, 06 Jan 2009 03:00:42 GMT

Work Item # 20453: Adding missing GO command in the SQL Server script. The missing command was causing the script to fail when creating the database for the first time.

Source code checked in, #45521

lerocha — Mon, 05 Jan 2009 03:23:44 GMT

Copying SQL Compact scripts to output directory.

Source code checked in, #45519

lerocha — Mon, 05 Jan 2009 02:57:26 GMT

Adding post-build event to copy ChinookMetadata.dll to Lib folder.

Source code checked in, #45517

lerocha — Mon, 05 Jan 2009 02:44:19 GMT

Replacying the dependency on the ChinookMetadata project by the Lib\ChinookMetadata.dll. This way, it will be possible to run all T4 templates without rebuilding the entire solution first.

Source code checked in, #45516

lerocha — Mon, 05 Jan 2009 02:17:11 GMT

Fixing invalid characters on the customer table data.

Source code checked in, #45513

lerocha — Mon, 05 Jan 2009 00:08:05 GMT

Adding new column Total to the invoice table.

Source code checked in, #45502

lerocha — Sun, 04 Jan 2009 08:07:10 GMT

1. Work Item #20381: Creating additional sample data for customer table. 2. Refactoring unit test for checking unicode characters of customer records. 3. Creating two separate scripts for SQL Server Compact: CreateTables.sqlce and DropTables.sqlce.

Source code checked in, #45378

lerocha — Tue, 30 Dec 2008 11:32:39 GMT

1. Creating unit tests to verify that all fields are populated properly in each table. 2. Changing type of Quantity field to integer. 3. Using NUMERIC data type for System.Decimal in SQL Server and MySQL.

Source code checked in, #45376

lerocha — Tue, 30 Dec 2008 07:52:16 GMT

Updating versions of NUnit and MySql.Data assemblies in the Lib folder.

Source code checked in, #45373

lerocha — Tue, 30 Dec 2008 05:25:15 GMT

Work Item #20383: Adding support for SQL Server Compact.

Source code checked in, #45367

lerocha — Mon, 29 Dec 2008 23:50:53 GMT

1. Cleanning up SQL scripts. 2. Using sqlcmd.exe instead of osql.exe for SQL Server. 3. Using strong typed dataset on T4 templates for SQL scripts.

Source code checked in, #45329

lerocha — Mon, 29 Dec 2008 08:25:34 GMT

Removing obsolete files.

Source code checked in, #45328

lerocha — Mon, 29 Dec 2008 07:51:29 GMT

1. Work item # 20382: Adding a many-to-many relationship to the database schema (a Playlist can have many Tracks, and a Track can belong to multiple Playlists). 2. Work item # 20385: Changing version number to 1.1 3. Using XPath to navigate through iTunes library file in order to populate the Chinook database with media information. 4. Using strong typed dataset (ChinookDataSet). 5. Creating a new project (ChinookMetadata) to contain the database schema and classes used by T4 templates (for example: importing from iTunes library file).

Source code checked in, #36499

lerocha — Sun, 17 Aug 2008 23:25:09 GMT

1. Using UTF-16 for encoding in order to get the scripts to populate data properly. 2. Updating SQL scripts to use Unicode strings. 3. Creating unit test to verify that data is properly encoded. 4. Adding CreatAll.bat to create all databases.

Source code checked in, #36300

lerocha — Sun, 17 Aug 2008 08:12:32 GMT

Creating unit tests to verify that tables were created and populated for all database servers.

Source code checked in, #36276

lerocha — Sun, 17 Aug 2008 03:52:40 GMT

Adding version information (Version 1.0) to generated scripts.

Source code checked in, #36268

lerocha — Sun, 17 Aug 2008 01:42:41 GMT

1. Adding new table (Genre) and new fields to the Track table (GenreId, Composer). 2. Adding T4 template code to random generate sales information (Invoice and InvoiceLine records).