Mohit Khare mkfeuhrer

## postgres_commands.md

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                mkfeuhrer
                / postgres_commands.md
            
            
              Created
              April 30, 2020 08:37
            
              
                Postgres Commands
              
          
    Get into the database -
psql -U <username> -d <database-name>
To list all databases - \list
To list all tables in a database - \dt

  
## transaction_postgres_gorm.go
// Here - db is package name for Postgres Gorm db setup

// Begin Transaction
txn, err1 := db.Begin()
if err1 != nil {
  return err1
}
defer func() {
  // Rollback in case of Failure
  // Note - within a transaction don't use db, use txn only.

## basic_query_postgres_gorm.go
// here db is package name where you created the setup

// Here dbConfig stores DB parameters as configs.
postgresStore, err := db.New(dbconfig)
if err != nil {
  logger.Log.Error("errors.postgres.initialize", err)
  return
}

sqlStatement := `select * from users where id=?;`

## postgres_gorm_setup.go
package db

import (
	"github.com/jinzhu/gorm"
)

type PostgresStore interface {
	DB() *gorm.DB
	Begin() (PostgresStore, error)
	Commit() error

## Softathlon_1st_round_Score_Scipt.ipynb

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                mkfeuhrer
                / Softathlon_1st_round_Score_Scipt.ipynb
            
            
              Created
              September 2, 2018 12:17
            
              
                Softathlon Round 1 result generaton scipt
              
          
      Loading

      Sorry, something went wrong. Reload?
      Sorry, we cannot display this file.
      Sorry, this file is invalid so it cannot be displayed.
      
          Viewer requires iframe.
	// Here - db is package name for Postgres Gorm db setup

	// Begin Transaction
	txn, err1 := db.Begin()
	if err1 != nil {
	return err1
	}
	defer func() {
	// Rollback in case of Failure
	// Note - within a transaction don't use db, use txn only.
	// here db is package name where you created the setup

	// Here dbConfig stores DB parameters as configs.
	postgresStore, err := db.New(dbconfig)
	if err != nil {
	logger.Log.Error("errors.postgres.initialize", err)
	return
	}

	sqlStatement := `select * from users where id=?;`
	package db

	import (
	"github.com/jinzhu/gorm"
	)

	type PostgresStore interface {
	DB() *gorm.DB
	Begin() (PostgresStore, error)
	Commit() error