cpoDesign

DOD (Definition of Done)

- code is ready
- code has unit tests
- code has integration tests
- applied SOLID

Documnetation
- documentation is procudes

cpoDesign

select * from sys.tables as t
inner join sys.columns as c
    on  t.object_id = c.object_id
inner join sys.index_columns as ic 
    on c.column_id = ic.column_id and c.object_id = ic.object_id
inner join sys.indexes as i
    on ic.index_id = i.index_id and ic.object_id = i.object_id
WHERE t.name = 'table_name' AND i.name = 'index_name'
-- where t.name = 'table_name' and c.name = 'column_name'

cpoDesign

public partial class ApiClient  
    {  
  
        private readonly HttpClient _httpClient;  
        private Uri BaseEndpoint { get; set; }  
  
        public ApiClient(Uri baseEndpoint)  
        {  
            if (baseEndpoint == null)  
            {  

cpoDesign

<?xml version="1.0" encoding="utf-8"?>
<package xmlns="http://schemas.microsoft.com/packaging/2010/07/nuspec.xsd">
    <metadata>
        <id>project</id>
        <version>0.0.1</version>
        <authors>authors</authors>
        <owners>Owners</owners>
        <requireLicenseAcceptance>false</requireLicenseAcceptance>
        <description>package desciptions</description>
    </metadata>

cpoDesign

       /// <summary>
        /// used to provide definition for gateway service about active keys for clients, to about active client configuration
        /// </summary>
        /// <param name="token"></param>
        /// <returns></returns>
        [HttpGet]
        public IActionResult GetClientList(string token)
        {
            if (ValidateToken(token))
            {

cpoDesign

string sendingIp = "192.168.0.1";
int sendingPort = 5000;
Uri uri = new Uri("http://google.com");
HttpWebRequest wr = (HttpWebRequest)WebRequest.Create(uri);
ServicePoint sp = ServicePointManager.FindServicePoint(uri);
sp.BindIPEndPointDelegate =
    (servicePoint,remoteEp,retryCount) =>
         {
             return new IPEndPoint(IPAddress.Parse(sendingIp),sendingPort);
         };

cpoDesign

steps:
- task: PublishBuildArtifacts@1
  displayName: Publish Artifact: DynamicPowerShellArguments
  inputs:
    PathtoPublish: test.ps1
    ArtifactName: DynamicPowerShellArguments
    publishLocation: Container

cpoDesign

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <startup>
    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.6.1" />
  </startup>
  <connectionStrings>
    <add name="ConnectionStringUnderTest" connectionString="Data Source=localhost;Initial Catalog=MyDatabaseCatalogToReplace;Integrated Security=True" />
  </connectionStrings>
  <appSettings>
    <add key="CommandTimeOut" value="90"/>

cpoDesign

Username            user
Domain              domain

# provide actual value if autodetection fails
# Workstation         pc-name

Proxy               my_proxy_server.com:80
NoProxy             127.0.0.*, 192.168.*

Listen              127.0.0.1:54321

cpoDesign

DROP TABLE IF EXISTS dbo.Product

DROP TRIGGER IF EXISTS trProductInsert

DROP PROCEDURE IF EXISTS [dbo].[InsertData]