jsagf g

ajt ytdfaysfdgsa fjufasfhdjgsafhgsdfja ygfug dgf gfhgd fagfdj dgf kfdhua g

Mój kot:

faecvh gaevsafdjs jqU FDJSXMHN VkdgfmjFMHVDGFV k<hD BSFCHMVMSFGDHA FGHSDF VGGHGHJGYHJ JGJMGSFSDGg hjkgds fgjsfkdyshgfhkd ggf hkgksg fdgfk agfhd fkaydvfmgf fjgd fmjgdf kdgf kgf dj fdfkjgfj kgdkfdfkg kkgfjksgf bkstr kytbyj rg jhmfhj jhgfdh hyhyhydjkgfjkgfjgfhgjkgfg fgjd hdgbfjshkf ihe iwahkjhgf uhegw jgf jegfhdgf ukeg
ABCD
1248
241664
38641024
4162564098
5321024…..
Jakaś tabelka 😀

Muzeum

Nagradzane wystawy z udziałem artystów o międzynarodowej renomie.

Czytaj dalej

Sklep

To tutaj mój kot, ..y-yyy znaczy ja sprzedaję sprzety i sprzeciki!

Kup teraz
  • A
  • B
  • oraz C
  • D
  • E i F
  • G
  • H /w I J K
  • L i jego kumpel Ł
  • M
  • N (N nie lubi M </3)
  • O
  • P + R = <3
  • oraz inni

CHATGPT – I jego dylemat

Wiem, że kiedy ostatnio kładłem się spać, moje myśli krążyły wokół kwestii niezwykle istotnych dla ludzkości: jak rozwiązać problem niedoboru skarpetek w pralniach samoobsługowych? Wydaje się, że to zagadnienie ma potencjał, aby stać się kluczowym punktem dyskusji na forum międzynarodowym. Ale zanim zanurzymy się w ten głęboki dygresji, musimy omówić znaczenie szalonych kotletów wieprzowych w kosmosie. Tak, tak, słyszałeś mnie dobrze. Niezliczone istoty pozaziemskie wpatrują się w naszą planetę, wzdychając po smaku chrupiących kotletów wieprzowych w sosie barbecue. Ale czy możemy dostarczyć im te przysmaki w odpowiednim stanie? To pytanie, które trapiło mnie od lat.
Och, a pamiętasz towarzysza zebrę, który prowadził kurs jogi dla steków? To było coś, co przeszkadzało mi spać przez wiele nocy. W końcu zrozumiałem, że każdy ma swoje powołanie, nawet jeśli jest to szokująco absurdalne.
A co z dzikim światem internetowych memów? Czy możemy zrozumieć ich prawdziwe znaczenie, czy są tylko szumem w cyberprzestrzeni? Mam wrażenie, że gdzieś tam, między śmiesznymi kotami a memami z politologami, kryje się klucz do ludzkiej egzystencji.
A teraz, kiedy poruszamy temat egzystencji, nie możemy zapomnieć o kaczorze, który próbował otworzyć własną kawiarnię z kawą zbożową. To była próba bez precedensu, która zdumiała nawet najbardziej doświadczonych baristów. Ale, hej, ktoś musi próbować, prawda?
I co z owocami, które marzą o podboju świata i budowie własnego imperium bananowego? Czy są one tylko niewinymi owocami, czy też skrywają mroczne plany podboju?
Ale przede wszystkim, kto naprawdę kontroluje przemyt skarpetek przez tunel pod naszym domem? Czy to króliki z kosmosu czy raczej tajemnicze stworzenia z mrocznych zakamarków oceanu?
Tak więc, gdy spoglądamy w głąb otchłani losowości, tracimy się w wirze absurdalnych myśli i niespełnionych marzeń o kawie zbożowej. Ale cóż, życie jest pełne niespodzianek, prawda?
Skip to content
 
Search…
All gists
Back to GitHub
Sign in
Sign up
Instantly share code, notes, and snippets.

@dschilling
dschilling/CodeGenerator.cs
Created 12 years ago
Code
Revisions
3
Stars
2
Clone this repository at &lt;script src=&quot;https://gist.github.com/dschilling/3217856.js&quot;&gt;&lt;/script&gt;
<script src="https://gist.github.com/dschilling/3217856.js"></script>
Random Code Generator
CodeGenerator.cs
/***************************************************************************************************
 * Copyright 2012 (c) Daniel Schilling <http://stackoverflow.com/users/221708/daniel-schilling>
 *
 * Permission is hereby granted, free of charge, to any person obtaining a copy of this software and
 * associated documentation files (the "Software"), to deal in the Software without restriction,
 * including without limitation the rights to use, copy, modify, merge, publish, distribute,
 * sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is
 * furnished to do so, subject to the following conditions:
 *
 * The above copyright notice and this permission notice shall be included in all copies or
 * substantial portions of the Software.
 *
 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT
 * NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
 * NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM,
 * DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
 * OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
 **************************************************************************************************/

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using Microsoft.SqlServer.Server;

namespace CodeGenerator
{
    /// <summary>
    /// A tool for generating unique random codes.
    /// </summary>
    /// <example>
    /// <code>
    /// using (var connection = new SqlConnection(ConnectionString))
    /// {
    ///     connection.Open();
    ///     var codeLength = GetCurrentCodeLength(connection);
    ///     using (var generator = new CodeGenerator(connection, codeLength))
    ///     {
    ///         var codes = generator.GenerateCodes(10000);
    ///         foreach(var code in codes)
    ///             Console.WriteLine(code);
    ///         if (generator.CodeLength > codeLength)
    ///         {
    ///             SaveNewCodeLength(generator.CodeLength);
    ///             NotifyDeveloperOfApproachingCodePoolExhaustion(
    ///                 generator.CodeLength,
    ///                 CodeGenerator.MaxCodeLength);
    ///         }
    ///     }
    /// }
    /// </code>
    /// </example>
    public class CodeGenerator : IDisposable
    {
        public const int MaxCodeLength = 8;
        private const string AvailableChars = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789";

        private const string Query = @"
            DECLARE @batchid uniqueidentifier;
            SET @batchid = NEWID();
            INSERT INTO dbo.Voucher (Code, BatchId)
            SELECT DISTINCT b.Code, @batchid
            FROM @batch b
            WHERE NOT EXISTS (
                SELECT Code
                FROM dbo.Voucher v
                WHERE b.Code = v.Code
            );
            SELECT Code
            FROM dbo.Voucher
            WHERE BatchId = @batchid;";

        private static readonly SqlMetaData[] BatchMetaData = new[]
        {
            new SqlMetaData("Code", SqlDbType.NVarChar, MaxCodeLength)
        };

        private readonly SqlConnection _connection;
        private readonly StringBuilder _builder;
        private readonly Random _random = new Random(Guid.NewGuid().GetHashCode());
        private readonly int _batchSize;
        private readonly double _collisionThreshold;
        private readonly SqlCommand _command;
        private readonly SqlParameter _batchParameter;

        private bool _disposed;

        public int CodeLength { get; private set; }

        /// <summary>
        /// Create a CodeGenerator instance.
        /// </summary>
        /// <param name="connection">
        /// The connection to the database.  Must be open.  Calling code is responsible for
        /// creating, opening, and disposing the connection.
        /// </param>
        /// <param name="codeLength">
        /// The initial code length, which will grow as needed as codes are used up.  However, you
        /// still need to persist the <c>CodeLength</c> property value and initialize this parameter
        /// correctly.  Otherwise, if you always supply the same initial
        /// <paramref name="codeLength"/> - say "4", then ALL of the 4-digit codes will eventually
        /// become used up instead of maintaining the sparseness dictated by the collision
        /// threshold.
        /// </param>
        public CodeGenerator(SqlConnection connection, int codeLength)
            : this(connection, codeLength, 500, 0.01)
        { }

        /// <summary>
        /// Create a CodeGenerator instance.
        /// </summary>
        /// <param name="connection">
        /// The connection to the database.  Must be open.  Calling code is responsible for
        /// creating, opening, and disposing the connection.
        /// </param>
        /// <param name="codeLength">
        /// The initial code length, which will grow as needed as codes are used up.  However, you
        /// still need to persist the <c>CodeLength</c> property value and initialize this parameter
        /// correctly.  Otherwise, if you always supply the same initial
        /// <paramref name="codeLength"/> - say "4", then ALL of the 4-digit codes will eventually
        /// become used up instead of maintaining the sparseness dictated by the
        /// <paramref name="collisionThreshold"/> parameter.
        /// </param>
        /// <param name="batchSize">
        /// The number of codes to generate, test, and insert at once.  Tune this value for best
        /// performance.  In my tests, 500 worked well.
        /// </param>
        /// <param name="collisionThreshold">
        /// A value between 0 (inclusive) and 1 (exclusive).  Supply a small value (perhaps 0.01) to
        /// keep codes sparse.  A value that is too high (above 0.5) will result in sub-optimum
        /// performance.
        /// </param>
        public CodeGenerator(SqlConnection connection, int codeLength, int batchSize, double collisionThreshold)
        {
            if (collisionThreshold >= 1.0)
                throw new ArgumentOutOfRangeException("collisionThreshold", collisionThreshold, "must be less than 1");

            _connection = connection;
            CodeLength = codeLength;
            _batchSize = batchSize;
            _collisionThreshold = collisionThreshold;

            _builder = new StringBuilder(codeLength + 1);

            _command = _connection.CreateCommand();
            _command.CommandText = Query;

            _batchParameter = _command.Parameters.Add("@batch", SqlDbType.Structured);
            _batchParameter.TypeName = "dbo.VoucherCodeList";
        }

        public void Dispose()
        {
            if (_disposed)
                return;

            _command.Dispose();
            _disposed = true;
        }

        /// <summary>
        /// Generates unique random codes and inserts them into the database.
        /// </summary>
        /// <param name="numberOfCodes">The number of codes you need.</param>
        /// <returns>A list of unique random codes.</returns>
        public ICollection<string> GenerateCodes(int numberOfCodes)
        {
            var result = new List<string>(numberOfCodes);

            while (result.Count < numberOfCodes)
            {
                var batchSize = Math.Min(_batchSize, numberOfCodes - result.Count);
                var batch = GetBatch(batchSize);
                var oldResultCount = result.Count;
                
                result.AddRange(FilterAndSecureBatch(batch));

                var filteredBatchSize = result.Count - oldResultCount;
                var collisionRatio = ((double)batchSize - filteredBatchSize) / batchSize;

                if (collisionRatio > _collisionThreshold)
                    CodeLength++;
            }

            return result;
        }

        private IEnumerable<string> GetBatch(int batchSize)
        {
            for (var i = 0; i < batchSize; i++)
                yield return GenerateRandomCode();
        }

        private string GenerateRandomCode()
        {
            _builder.Clear();
            for (var i = 0; i < CodeLength; i++)
                _builder.Append(AvailableChars[_random.Next(AvailableChars.Length)]);
            return _builder.ToString();
        }

        private IEnumerable<string> FilterAndSecureBatch(IEnumerable<string> batch)
        {
            _batchParameter.Value = batch.Select(x =>
            {
                var record = new SqlDataRecord(BatchMetaData);
                record.SetString(0, x);
                return record;
            });

            using (var reader = _command.ExecuteReader())
                while (reader.Read())
                    yield return reader.GetString(0);
        }

        /// <summary>
        /// Creates the database schema required by the CodeCenerator.
        /// </summary>
        /// <param name="connection">An open connection to the database.</param>
        public static void CreateSchema(SqlConnection connection)
        {
            using (var command = connection.CreateCommand())
            {
                command.CommandText = @"
                    CREATE TABLE dbo.Voucher (
                        Code nvarchar(" + MaxCodeLength + @") COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL PRIMARY KEY,
                        BatchId uniqueidentifier NOT NULL
                    );
                    CREATE NONCLUSTERED INDEX IX_Voucher ON dbo.Voucher (BatchId ASC);
                    CREATE TYPE dbo.VoucherCodeList AS TABLE (
                        Code nvarchar(" + MaxCodeLength + @") COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL
                    );";

                command.ExecuteNonQuery();
            }
        }
    }
}
@kiokikalleryt
kiokikalleryt commented on Jun 26, 2020
`/***************************************************************************************************

Copyright 2012 (c) Daniel Schilling http://stackoverflow.com/users/221708/daniel-schilling
Permission is hereby granted, free of charge, to any person obtaining a copy of this software and
associated documentation files (the "Software"), to deal in the Software without restriction,
including without limitation the rights to use, copy, modify, merge, publish, distribute,
sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is
furnished to do so, subject to the following conditions:
The above copyright notice and this permission notice shall be included in all copies or
substantial portions of the Software.
THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT
NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND
NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM,
DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM,
OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
**************************************************************************************************/
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using Microsoft.SqlServer.Server;

namespace CodeGenerator
{
///


/// A tool for generating unique random codes.
///

///
/// 
/// using (var connection = new SqlConnection(ConnectionString))
/// {
///     connection.Open();
///     var codeLength = GetCurrentCodeLength(connection);
///     using (var generator = new CodeGenerator(connection, codeLength))
///     {
///         var codes = generator.GenerateCodes(10000);
///         foreach(var code in codes)
///             Console.WriteLine(code);
///         if (generator.CodeLength > codeLength)
///         {
///             SaveNewCodeLength(generator.CodeLength);
///             NotifyDeveloperOfApproachingCodePoolExhaustion(
///                 generator.CodeLength,
///                 CodeGenerator.MaxCodeLength);
///         }
///     }
/// }
/// 
///
public class CodeGenerator : IDisposable
{
public const int MaxCodeLength = 8;
private const string AvailableChars = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789";
    private const string Query = @"
        DECLARE @batchid uniqueidentifier;
        SET @batchid = NEWID();
        INSERT INTO dbo.Voucher (Code, BatchId)
        SELECT DISTINCT b.Code, @batchid
        FROM @batch b
        WHERE NOT EXISTS (
            SELECT Code
            FROM dbo.Voucher v
            WHERE b.Code = v.Code
        );
        SELECT Code
        FROM dbo.Voucher
        WHERE BatchId = @batchid;";

    private static readonly SqlMetaData[] BatchMetaData = new[]
    {
        new SqlMetaData("Code", SqlDbType.NVarChar, MaxCodeLength)
    };

    private readonly SqlConnection _connection;
    private readonly StringBuilder _builder;
    private readonly Random _random = new Random(Guid.NewGuid().GetHashCode());
    private readonly int _batchSize;
    private readonly double _collisionThreshold;
    private readonly SqlCommand _command;
    private readonly SqlParameter _batchParameter;

    private bool _disposed;

    public int CodeLength { get; private set; }

    /// <summary>
    /// Create a CodeGenerator instance.
    /// </summary>
    /// <param name="connection">
    /// The connection to the database.  Must be open.  Calling code is responsible for
    /// creating, opening, and disposing the connection.
    /// </param>
    /// <param name="codeLength">
    /// The initial code length, which will grow as needed as codes are used up.  However, you
    /// still need to persist the <c>CodeLength</c> property value and initialize this parameter
    /// correctly.  Otherwise, if you always supply the same initial
    /// <paramref name="codeLength"/> - say "4", then ALL of the 4-digit codes will eventually
    /// become used up instead of maintaining the sparseness dictated by the collision
    /// threshold.
    /// </param>
    public CodeGenerator(SqlConnection connection, int codeLength)
        : this(connection, codeLength, 500, 0.01)
    { }

    /// <summary>
    /// Create a CodeGenerator instance.
    /// </summary>
    /// <param name="connection">
    /// The connection to the database.  Must be open.  Calling code is responsible for
    /// creating, opening, and disposing the connection.
    /// </param>
    /// <param name="codeLength">
    /// The initial code length, which will grow as needed as codes are used up.  However, you
    /// still need to persist the <c>CodeLength</c> property value and initialize this parameter
    /// correctly.  Otherwise, if you always supply the same initial
    /// <paramref name="codeLength"/> - say "4", then ALL of the 4-digit codes will eventually
    /// become used up instead of maintaining the sparseness dictated by the
    /// <paramref name="collisionThreshold"/> parameter.
    /// </param>
    /// <param name="batchSize">
    /// The number of codes to generate, test, and insert at once.  Tune this value for best
    /// performance.  In my tests, 500 worked well.
    /// </param>
    /// <param name="collisionThreshold">
    /// A value between 0 (inclusive) and 1 (exclusive).  Supply a small value (perhaps 0.01) to
    /// keep codes sparse.  A value that is too high (above 0.5) will result in sub-optimum
    /// performance.
    /// </param>
    public CodeGenerator(SqlConnection connection, int codeLength, int batchSize, double collisionThreshold)
    {
        if (collisionThreshold >= 1.0)
            throw new ArgumentOutOfRangeException("collisionThreshold", collisionThreshold, "must be less than 1");

        _connection = connection;
        CodeLength = codeLength;
        _batchSize = batchSize;
        _collisionThreshold = collisionThreshold;

        _builder = new StringBuilder(codeLength + 1);

        _command = _connection.CreateCommand();
        _command.CommandText = Query;

        _batchParameter = _command.Parameters.Add("@batch", SqlDbType.Structured);
        _batchParameter.TypeName = "dbo.VoucherCodeList";
    }

    public void Dispose()
    {
        if (_disposed)
            return;

        _command.Dispose();
        _disposed = true;
    }

    /// <summary>
    /// Generates unique random codes and inserts them into the database.
    /// </summary>
    /// <param name="numberOfCodes">The number of codes you need.</param>
    /// <returns>A list of unique random codes.</returns>
    public ICollection<string> GenerateCodes(int numberOfCodes)
    {
        var result = new List<string>(numberOfCodes);

        while (result.Count < numberOfCodes)
        {
            var batchSize = Math.Min(_batchSize, numberOfCodes - result.Count);
            var batch = GetBatch(batchSize);
            var oldResultCount = result.Count;
            
            result.AddRange(FilterAndSecureBatch(batch));

            var filteredBatchSize = result.Count - oldResultCount;
            var collisionRatio = ((double)batchSize - filteredBatchSize) / batchSize;

            if (collisionRatio > _collisionThreshold)
                CodeLength++;
        }

        return result;
    }

    private IEnumerable<string> GetBatch(int batchSize)
    {
        for (var i = 0; i < batchSize; i++)
            yield return GenerateRandomCode();
    }

    private string GenerateRandomCode()
    {
        _builder.Clear();
        for (var i = 0; i < CodeLength; i++)
            _builder.Append(AvailableChars[_random.Next(AvailableChars.Length)]);
        return _builder.ToString();
    }

    private IEnumerable<string> FilterAndSecureBatch(IEnumerable<string> batch)
    {
        _batchParameter.Value = batch.Select(x =>
        {
            var record = new SqlDataRecord(BatchMetaData);
            record.SetString(0, x);
            return record;
        });

        using (var reader = _command.ExecuteReader())
            while (reader.Read())
                yield return reader.GetString(0);
    }

    /// <summary>
    /// Creates the database schema required by the CodeCenerator.
    /// </summary>
    /// <param name="connection">An open connection to the database.</param>
    public static void CreateSchema(SqlConnection connection)
    {
        using (var command = connection.CreateCommand())
        {
            command.CommandText = @"
                CREATE TABLE dbo.Voucher (
                    Code nvarchar(" + MaxCodeLength + @") COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL PRIMARY KEY,
                    BatchId uniqueidentifier NOT NULL
                );
                CREATE NONCLUSTERED INDEX IX_Voucher ON dbo.Voucher (BatchId ASC);
                CREATE TYPE dbo.VoucherCodeList AS TABLE (
                    Code nvarchar(" + MaxCodeLength + @") COLLATE SQL_Latin1_General_CP1_CS_AS NOT NULL
                );";

            command.ExecuteNonQuery();
        }
    }
}
}`

 to join this conversation on GitHub. Already have an account? Sign in to comment
Footer
© 2024 GitHub, Inc.
Footer navigation
Terms
Privacy
Security
Status
Docs
Contact
Manage cookies
Do not share my personal information