Skip to content

Instantly share code, notes, and snippets.

@adityarama1210
adityarama1210 / user_test.go
Created March 11, 2021 03:32
User Test Example
package user
import (
"database/sql"
"errors"
"reflect"
"testing"
)
func Test_GetUserProfile(t *testing.T) {
@adityarama1210
adityarama1210 / main.go
Last active January 25, 2021 07:39
Example of save queries
func getUser(username string) (User, error) {
var userObject User
// RISK TO SQL INJECTION EXAMPLE
// assuming username = string values from client parameter and we have userObject with user type struct
query := `SELECT * FROM users WHERE username = ` + username
err := db.QueryRow(query).Scan(&userObject)
if err != nil {
// handle error
@adityarama1210
adityarama1210 / main.go
Created January 10, 2021 10:29
Test Uploader GCP
package main
import (
"context"
"fmt"
"io"
"log"
"mime/multipart"
"net/http"
"os"
@adityarama1210
adityarama1210 / main.go
Created January 9, 2021 16:08
Cache Test
package main
import (
"database/sql"
"encoding/json"
"errors"
"fmt"
"log"
"net/http"
"time"
@adityarama1210
adityarama1210 / main.go
Last active January 3, 2021 07:42
Main bulk DB Experiment Script
package main
import (
"log"
"time"
"github.com/lib/pq"
"github.com/jmoiron/sqlx"
)
@adityarama1210
adityarama1210 / seeds.sql
Created January 3, 2021 07:40
SQL for Bulk Query Experiment
CREATE TABLE users (
id SERIAL PRIMARY KEY,
name VARCHAR(20) NOT NULL
);
INSERT INTO users (name) VALUES
('jmgzxzatjp'),('rxdqwcmhxv'),('gzusiinshx'),('jhjpjqhsrr'),('vrneswnoxt'),('bpekyumlzv'),('flhuiyxdle'),('wszpqdormm'),('xkrroujuhz'),('yykggdmxqp'),('vzppqdymnr'),('jeumcmyaoq'),('nbzocspmkl'),('alaqeiahku'),('ytkocojmub'),('rsntfgutiu'),('aagqzcdptb'),('wolovipdas'),('kyuweqouzf'),('vopgcakgkv'),('atpqwfbqwr'),('cdnipomsql'),('ahpiotvbdw'),('jqhmmmoxdb'),('yekgeflnmh'),('kywievcxin'),('ugfkrqnwdb'),('jddtwemlkz'),('pdbfxgirya'),('wlaslsmcpx'),('ndyvbcmfkw'),('aozszmnvff'),('hywjpgosgl'),('omctyuatqz'),('oxmhkohqbp'),('rxjtpcmdkk'),('cswsgqwdrr'),('xxkgykmjjl'),('orwqzjccpj'),('uknhoumwuw'),('sloolmdoqx'),('ypqwgehooi'),('utwrhyyzax'),('mievkiforf'),('jyjrxogslq'),('zaduszxmgo'),('bagtbrowuy'),('hgntanbpdh'),('dlcokydxwa'),('opdgcbvwuw'),('jnsffjeyvf'),('johteybbgl'),('keypoduwbk'),('sqpepbkeem'),('cnrvrfunvk'),('rtaibbtkyq'),('fagiwlepof'),('ayoyskiala'),('gumhopjlik'),('xqyxpbrjru'),('dmcaiek
@adityarama1210
adityarama1210 / main.go
Last active December 5, 2020 01:09
function in main.go for elastic APM
func processingRequest(ctx context.Context) {
span, ctx := apm.StartSpan(ctx, "processingRequest", "custom")
defer span.End()
doSomething(ctx)
// time sleep simulate some processing time
time.Sleep(15 * time.Millisecond)
return
}
@adityarama1210
adityarama1210 / main.go
Created December 5, 2020 00:45
go elastic main function
package main
import (
"context"
"encoding/json"
"log"
"net/http"
"time"
"github.com/gin-gonic/gin"