Unleasharp.DB.MySQL 1.0.0

🐬 Unleasharp.DB.MySQL

MySQL implementation of Unleasharp.DB.Base. This repository provides a MySQL-specific implementation that leverages the base abstraction layer for common database operations.

📦 Installation

Install the NuGet package using one of the following methods:

Package Manager Console

Install-Package Unleasharp.DB.MySQL

.NET CLI

dotnet add package Unleasharp.DB.MySQL

PackageReference (Manual)

<PackageReference Include="Unleasharp.DB.MySQL" Version="1.0.0" />

🎯 Features

• MySQL-Specific Query Rendering: Custom query building and rendering tailored for MySQL
• Connection Management: Robust connection handling through ConnectorManager
• Query Builder Integration: Seamless integration with the base QueryBuilder
• Schema Definition Support: Full support for table and column attributes

🚀 Connection Initialization

The ConnectorManager handles database connections. You can initialize it using a connection string or MySqlConnectionStringBuilder.

Using Connection String

ConnectorManager DBConnector = new ConnectorManager("Server=localhost;Database=unleasharp;Uid=unleasharp;Pwd=unleasharp;");

Using Fluent Configuration

ConnectorManager DBConnector = new ConnectorManager()
    .WithAutomaticConnectionRenewal(true)
    .WithAutomaticConnectionRenewalInterval(TimeSpan.FromHours(1))
    .Configure(config => {
        config.ConnectionString = "Server=localhost;Database=unleasharp;Uid=unleasharp;Pwd=unleasharp;";
    });

Using MySqlConnectionStringBuilder

ConnectorManager DBConnector = new ConnectorManager(
    new MySqlConnectionStringBuilder("Server=localhost;Database=unleasharp;Uid=unleasharp;Pwd=unleasharp;")
);

📝 Usage Examples

Sample Table Structure

using System.ComponentModel;
using Unleasharp.DB.Base.SchemaDefinition;

namespace Unleasharp.DB.MySQL.Sample;

[Table("example_table")]
[Key("id", Field = "id", KeyType = Unleasharp.DB.Base.QueryBuilding.KeyType.PRIMARY)]
public class ExampleTable 
{
    [Column("id", "bigint", Unsigned = true, PrimaryKey = true, AutoIncrement = true, NotNull = true, Length = 20)]
    public ulong? ID { get; set; }
    
    [Column("_mediumtext", "mediumtext")]
    public string MediumText { get; set; }
    
    [Column("_longtext", "longtext")]
    public string _longtext { get; set; }
    
    [Column("_json", "longtext")]
    public string _json { get; set; }
    
    [Column("_longblob", "longblob")]
    public byte[] CustomFieldName { get; set; }
    
    [Column("_enum", "enum")]
    public EnumExample? _enum { get; set; }
    
    [Column("_varchar", "varchar", Length = 255)]
    public string _varchar { get; set; }
}

public enum EnumExample 
{
    NONE,
    Y,
    [Description("NEGATIVE")]
    N
}

Sample Program

using System;
using System.Collections.Generic;
using Unleasharp.DB.MySQL;
using Unleasharp.DB.Base.QueryBuilding;

namespace Unleasharp.DB.MySQL.Sample;

internal class Program 
{
    static void Main(string[] args) 
    {
        // Initialize database connection
        ConnectorManager DBConnector = new ConnectorManager("Server=192.168.1.8;Database=unleasharp;Uid=unleasharp;Pwd=unleasharp;");
        
        // Create table
        DBConnector.QueryBuilder().Build(Query => Query.Create<ExampleTable>()).Execute();
        
        // Insert data
        DBConnector.QueryBuilder().Build(Query => { Query
            .From<ExampleTable>()
            .Value(new ExampleTable {
                MediumText = "Medium text example value",
                _enum      = EnumExample.N
            })
            .Values(new List<ExampleTable> {
                new ExampleTable {
                    _json           = @"{""sample_json_field"": ""sample_json_value""}",
                    _enum           = EnumExample.Y,
                    CustomFieldName = new byte[8] { 81,47,15,21,12,16,23,39 }
                },
                new ExampleTable {
                    _longtext = "Long text example value",
                    ID        = 999 // RandomID placeholder
                }
            })
            .Insert();
        }).Execute();
        
        // Select single row
        ExampleTable Row = DBConnector.QueryBuilder().Build(Query => Query
            .From("example_table")
            .OrderBy("id", OrderDirection.ASC)
            .Limit(1)
            .Select()
        ).FirstOrDefault<ExampleTable>();
        
        // Select multiple rows with different class naming
        List<example_table> Rows = DBConnector.QueryBuilder().Build(Query => Query
            .From("example_table")
            .OrderBy("id", OrderDirection.DESC)
            .Select()
        ).ToList<example_table>();
    }
}

Sample Query Rendering

// Complex query demonstration with subqueries
Query VeryComplexQuery = Query.GetInstance()
    .Select("query_field")
    .Select($"COUNT({new FieldSelector("table_x", "table_y")})", true)
    .From("query_from")
    .Where("field", "value")
    .WhereIn(
        "field_list",
        Query.GetInstance()
            .Select("*", false)
            .From("subquery_table")
            .Where("subquery_field", true)
            .WhereIn(
                "subquery_in_field",
                Query.GetInstance()
                    .Select("subquery_subquery_in_field")
                    .From("subquery_subquery_in_table")
                    .Where("subquery_subquery_in_where", true)
            )
            .Limit(100)
    )
    .WhereIn("field_list", new List<dynamic> { null, 123, 456, "789" })
    .Join("another_table", new FieldSelector("table_x", "field_x"), new FieldSelector("table_y", "field_y"))
    .OrderBy(new OrderBy {
        Field     = new FieldSelector("order_field"),
        Direction = OrderDirection.DESC
    })
    .GroupBy("group_first")
    .GroupBy("group_second")
    .Limit(100);

// Render raw SQL query
Console.WriteLine(VeryComplexQuery.Render());

// Render prepared statement query (with placeholders)
Console.WriteLine(VeryComplexQuery.RenderPrepared());

📦 Dependencies

• Unleasharp.DB.Base - Base abstraction layer
• MySqlConnector - MySQL driver for .NET

📋 Version Compatibility

This library targets .NET 8.0 and later versions. For specific version requirements, please check the package dependencies.

📄 License

This project is licensed under the MIT License - see the LICENSE file for details.

For more information about Unleasharp.DB.Base, visit: Unleasharp.DB.Base