zikani03

module go.zikani.me/labs/transactionizer

go 1.21.1

require (
	github.com/jmoiron/sqlx v1.3.5
	github.com/lib/pq v1.3.0
	github.com/speps/go-hashids/v2 v2.0.1
	github.com/zikani03/pgadvisorylock v0.2.0
)

zikani03

{
	// VS Code Snippers for PrimeVue components
	// @author Zikani Nyirenda Mwase <[email protected]>
	"p-inputtext": {
		"scope": "vue,javascript,typescript,html",
		"prefix": "pi:text",
		"body": [
			"<div class=\"field\">",
			"  <div class=\"p-float-label\">",
			"    <InputText id=\"$1\" v-model=\"$1\"/>",

zikani03

#!/usr/bin/python
"""Changes remote urls for repositories in a given directory to SSH remotes
for repositories in a given directory. Since GitHub removed password based auth.

Run it using: `python chremote.py --d /path/to/directory`

Basic interaction is outlined below;

```
$ ls /path/to/directory

zikani03

This is a simple experiment using a build of Java 16 to create a simple Spark Java application that's backed by Project Loom's Virtual Threads as Jetty's ThreadPool implementation. It is based on prior art

What does it do?

It's basically a web server whose routes/endpoints are specified with Spark to serve an HTML page and some JavaScript - written inline using Text Blocks!.

zikani03

import java.io.IOException;
import java.io.OutputStream;

/**
 * <p>
 * MultiplexOutputStream allows you to write to multiple output streams "at once".
 * It allows you to use one outputstream writer to write to multiple outputstreams
 * without repeating yourself.
 * Based off <a href="https://github.com/creditdatamw/kapenta/blob/master/src/main/java/com/creditdatamw/labs/kapenta/io/MultiplexOutputStream.java">MultiplexOutputStream.java</a>
 */

zikani03

extern crate zip;
extern crate quick_xml;
extern crate html_entities;

use std::io::BufReader;
use std::fs::File;
use std::io::Read;
use std::ops::Deref;
use std::collections::BTreeMap;
use zip::read::ZipArchive;

zikani03

var pg = require('pg');

var client = new pg.Client('postgresql://username:password@localhost:5432/labs');

client.connect();

client.query('LISTEN events', function(err, msg) {
    if (err) throw err;
});

zikani03

import java.util.HashMap;
import spark.Filter;
import spark.Request;
import spark.Response;
import spark.Spark;

/**
 * Really simple helper for enabling CORS in a spark application;
 */
public final class CorsFilter {

zikani03

var cmd = require("cmd.js"),
	truncate = require("./truncate");

cmd.module('truncate', truncate);

var articles = [
	{ title: "Lorem ipsum dolor sit amet, musis nihilominus admonendus tu tu", body : "Lorem ipsum dolor sit amet, caelum levaverunt te finis puellam. Aderit omnia salva deus Hellenici silentio flebam terris classes nostram."},
	{ title: "My first article", body: "Ego esse ait mea Christianis, concursus male nuptiarum civibus nescis. Quos ducem cum magna duobus discessit de me in deinde cupis ei."},
	{ title: "My second article post", body : "Mansione sed eu fugiens laudo in, zurziaca in fuerat construeret cena. Nubila grata gratias eos est Apollonius in modo invenit nutricis actum in lucem."},
	{ title: "This is just an article", body : "Filiam sunt amore tolle quae non potentiae cognoscitivarum non ait. Neminem habere matrem Domini in fuerat eum filiam rex Dionysiadi rex Dionysiadi rex in modo ad per sanctus primum subsannio."}

zikani03

-- @name row_to_csv
-- @descr create a csv record of any row from any table in MSSQL 2005+
-- @param table_name : full schema qualified name e.g. [dbo].[companies]
-- @param conditions select conditions .e.g "WHERE companies.company_id = 50
CREATE FUNCTION dbo.row_to_csv( @table_name as varchar(100) , @conditions as varchar(200))
  returns varchar(2048)
AS
begin

IF  NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N''+@table_name) AND type in (N'U'))