public StyleFinder(MySqlConnection conn) { cmdSelectStyle = new MySqlCommand("SELECT * FROM `styles` WHERE `style` = @style;", conn); cmdSelectStyle.Prepare(); cmdSelectStyle.Parameters.Add("style", MySqlDbType.MediumText); cmdInsertStyle = new InsertBuilder(conn, "styles") .AddString("style") .Build(); }
public GenreFinder(MySqlConnection conn) { cmdSelectGenre = new MySqlCommand("SELECT * FROM `genres` WHERE `genre` = @genre;", conn); cmdSelectGenre.Prepare(); cmdSelectGenre.Parameters.Add("genre", MySqlDbType.MediumText); cmdInsertGenre = new InsertBuilder(conn, "genres") .AddString("genre") .Build(); }
protected override void Init() { base.Init(); this.cmdMaster = new InsertBuilder(conn, "masters") .AddInt32("id") .AddInt32("main_release") .AddString("title") .AddString("joined_artists") .AddInt32("year") .AddString("notes") .Build(); }
private void Init() { cmdArtist = new InsertBuilder(this.conn, "artists") .AddString("name") .AddString("realname") .AddString("profile") .Build(); cmdAlias = new InsertBuilder(this.conn, "artists_aliases") .AddInt32("artist") .AddInt32("number") .AddString("alias") .Build(); cmdNameVariation = new InsertBuilder(this.conn, "artists_namevariations") .AddInt32("artist") .AddInt32("number") .AddString("namevariation") .Build(); cmdUrl = new InsertBuilder(this.conn, "artists_urls") .AddInt32("artist") .AddInt32("number") .AddString("url") .Build(); cmdImage = new InsertBuilder(this.conn, "artists_images") .AddInt32("artist") .AddInt32("number") .AddString("type") .AddInt32("width") .AddInt32("height") .AddString("uri") .AddString("uri150") .Build(); cmdGroup = new InsertBuilder(this.conn, "artists_groups") .AddInt32("artist") .AddInt32("number") .AddString("group") .Build(); cmdMember = new InsertBuilder(this.conn, "artists_members") .AddInt32("artist") .AddInt32("number") .AddString("member") .Build(); }
protected virtual void Init() { this.genreFinder = new GenreFinder(this.conn); this.styleFinder = new StyleFinder(this.conn); this.cmdRelease = new InsertBuilder(conn, "releases") .AddInt32("id") .AddString("master_id") .AddString("status") .AddString("title") .AddString("joined_artists") .AddString("country") .AddString("releasedate") .AddString("notes") .Build(); this.cmdReleaseArtist = new InsertBuilder(conn, "releases_artists") .AddInt32("release") .AddInt32("master") .AddInt32("number") .AddInt32("artist") .AddString("namevariation") .AddString("join") .Build(); this.cmdReleaseFormat = new InsertBuilder(conn, "releases_formats") .AddInt32("release") .AddInt32("number") .AddString("name") .AddInt32("quantity") .Build(); this.cmdReleaseFormatDescription = new InsertBuilder(conn, "releases_formats_descriptions") .AddInt32("release_format") .AddInt32("number") .AddString("description") .Build(); this.cmdReleaseGenre = new InsertBuilder(conn, "releases_genres") .AddInt32("release") .AddInt32("master") .AddInt32("number") .AddInt32("genre") .Build(); this.cmdReleaseImage = new InsertBuilder(conn, "releases_images") .AddInt32("release") .AddInt32("master") .AddInt32("number") .AddString("type") .AddInt32("width") .AddInt32("height") .AddString("uri") .AddString("uri150") .Build(); this.cmdReleaseLabel = new InsertBuilder(conn, "releases_labels") .AddInt32("release") .AddInt32("number") .AddString("catno") .AddString("name") .Build(); this.cmdReleaseIdentifier = new InsertBuilder(conn, "releases_identifiers") .AddInt32("release") .AddInt32("number") .AddString("type") .AddString("value") .AddString("description") .Build(); this.cmdReleaseStyle = new InsertBuilder(conn, "releases_styles") .AddInt32("release") .AddInt32("master") .AddInt32("number") .AddInt32("style") .Build(); this.cmdReleaseTrack = new InsertBuilder(conn, "releases_tracks") .AddInt32("release") .AddInt32("master") .AddInt32("number") .AddString("position") .AddString("title") .AddInt32("duration") .Build(); this.cmdReleaseTrackArtist = new InsertBuilder(conn, "releases_tracks_artists") .AddInt32("track") .AddInt32("number") .AddString("artist") .AddString("namevariation") .AddString("join") .Build(); this.cmdReleaseTrackExtraArtist = new InsertBuilder(conn, "releases_tracks_extraartists") .AddInt32("track") .AddInt32("number") .AddString("name") .AddString("namevariation") .AddString("role") .Build(); this.cmdReleaseFts = new InsertBuilder(conn, "releases_fts") .AddInt32("id") .AddString("fts") .Build(); Console.WriteLine("Creating ArtistFinder..."); this.artistFinder = new ArtistFinder(this.conn); }