vector623

var apolloUpdateAdjustment = new Apollo.UpdateAdjustment
{
    supply = record["SUPPLY"].ToString(),
    prosales = record["ProSales"].ToString(),
    release_date = record["Release Date"].ToString(),
    reason_for_update = record["Reason For Update"].ToString(),
    itemid = Convert.ToInt64(record["ItemID"].ToString()),
};

vector623

scp root@oldhost:/root/.bash_history /tmp/migrate.sh
sudo sh /tmp/migrate.sh

vector623

public class Startup
{
    public IConfigurationRoot Configuration { get; }
    public ILoggerFactory LoggerFactory { get; }
    public DbConnectionStringBuilder DbConnectionStringBuilder { get; }
    
    public Startup()
    {
        Configuration = new ConfigurationBuilder()
            .AddEnvironmentVariables("TROICENET_")

vector623

public class StatusController : Controller
{
    public ILoggerFactory LoggerFactory { get; }
    public DbConnectionStringBuilder ConnectionStringBuilder { get; }
    public StatusController(DbConnectionStringBuilder connectionStringBuilder, ILoggerFactory loggerFactory)
    {
        ConnectionStringBuilder = connectionStringBuilder;
        LoggerFactory = loggerFactory;
    }
}

vector623

static class Program
{
    public static IConfigurationRoot Configuration { get; }
    public static ILoggerFactory LoggerFactory { get; }
    public static DbConnectionStringBuilder DbConnectionStringBuilder { get; }
    static Program()
    {
        Configuration = new ConfigurationBuilder()
            .AddEnvironmentVariables("TROICENETDEV_")
            .Build();         

vector623

using System.Linq;
using System.Net.Http;
using System.Net.Http.Headers;
using Microsoft.AspNetCore.Routing;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;

namespace GithubPullerDemo
{
    public class GitHubRepo

vector623

## General Stuff

### List of all tables
SELECT * FROM pg_catalog.pg_tables

### Create new user and give it superuser access
create user adminuser createuser password '1234Admin';
alter user adminuser createuser;

### Create user without superuser privilege

vector623

public IActionResult WarehouseTransactions()
{
    dynamic logs = new ExpandoObject();
    try
    {
        using (var athenaDb = LocalDB.GetConnection())
        using (var remoteDb = RemoteDB.GetConnection())
        {
            //download ids+lastmodified timestamp for source and destination
            var sourceTransationState = athenaDb

vector623

Log.Logger = new LoggerConfiguration()
    .MinimumLevel.Debug()
    .Destructure.ByTransforming<ExpandoObject>(JsonConvert.SerializeObject)
    .WriteTo.AzureAnalytics(
        workspaceId: Configuration["AZUREANALYTICS_WORKSPACEID"],
        authenticationId: Configuration["AZUREANALYTICS_AUTHENTICATIONID"],
        logName: "logTableName",
        restrictedToMinimumLevel: LogEventLevel.Debug, 
        batchSize: 10)
    .CreateLogger();

vector623

Table of Contents

• GPG Intro
• GPG Usage
  • Create signing key for git
    • Example
  • Export and backup of keys
• Git configuration
  • GitHub user settings
• Configure git locally