database

package

v0.0.0-...-8076ccd Latest Latest Go to latest Published: Sep 6, 2020 License: GPL-3.0 Imports: 6 Imported by: 0

Details

Valid go.mod file

The Go module system was introduced in Go 1.11 and is the official dependency management solution for Go.
Redistributable license

Redistributable licenses place minimal restrictions on how software can be used, modified, and redistributed.
Tagged version

Modules with tagged versions give importers more predictable builds.
Stable version

When a project reaches major version v1 it is considered stable.
Learn more about best practices

Repository

github.com/fengjijiao/telegram-web-url-moniter-bot

Links

Open Source Insights

Documentation ¶

Index ¶

func CreateTable(db *sqlx.DB, create_sql string) error
func DeleteUrl(db *sqlx.DB, url string, uid int) error
func DeleteUrls(db *sqlx.DB, uid int) error
func GetTelegramIdViaUid(db *sqlx.DB, uid int) (int, error)
func GetUidViaTelegramId(db *sqlx.DB, telegram_id int) (int, error)
func GetUrls(db *sqlx.DB) (*[]UrlVar, error)
func GetUrlsViaUid(db *sqlx.DB, uid int) (*[]UrlVar, error)
func OpenOrCreateDatabase(filepath string) (*sqlx.DB, error)
func RemoveDatabase(filepath string)
func UpdateLastStatus(db *sqlx.DB, last_status string, rid int) error
func UpdateLastStatusCode(db *sqlx.DB, last_statuscode, rid int) error
func UpdateLastTimestamp(db *sqlx.DB, rid int) error
func UrlExists(db *sqlx.DB, url string, uid int) bool
func UserExists(db *sqlx.DB, telegram_id int) bool
type UrlVar
- func (uv *UrlVar) InsertUrl(db *sqlx.DB) error
type UserVar
- func GetUserInfoViaTelegramId(db *sqlx.DB, telegram_id int) (*UserVar, error)
- func GetUserInfoViaUid(db *sqlx.DB, uid int) (*UserVar, error)
- func (uv *UserVar) InsertUser(db *sqlx.DB) error

Constants ¶

This section is empty.

Variables ¶

This section is empty.

Functions ¶

func CreateTable ¶

func CreateTable(db *sqlx.DB, create_sql string) error

func DeleteUrl ¶

func DeleteUrl(db *sqlx.DB, url string, uid int) error

func DeleteUrls ¶

func DeleteUrls(db *sqlx.DB, uid int) error

func GetTelegramIdViaUid ¶

func GetTelegramIdViaUid(db *sqlx.DB, uid int) (int, error)

func GetUidViaTelegramId ¶

func GetUidViaTelegramId(db *sqlx.DB, telegram_id int) (int, error)

func GetUrls ¶

func GetUrls(db *sqlx.DB) (*[]UrlVar, error)

func GetUrlsViaUid ¶

func GetUrlsViaUid(db *sqlx.DB, uid int) (*[]UrlVar, error)

func OpenOrCreateDatabase ¶

func OpenOrCreateDatabase(filepath string) (*sqlx.DB, error)

func RemoveDatabase ¶

func RemoveDatabase(filepath string)

func UpdateLastStatus ¶

func UpdateLastStatus(db *sqlx.DB, last_status string, rid int) error

func UpdateLastStatusCode ¶

func UpdateLastStatusCode(db *sqlx.DB, last_statuscode, rid int) error

func UpdateLastTimestamp ¶

func UpdateLastTimestamp(db *sqlx.DB, rid int) error

func UrlExists ¶

func UrlExists(db *sqlx.DB, url string, uid int) bool

func UserExists ¶

func UserExists(db *sqlx.DB, telegram_id int) bool

Types ¶

type UrlVar ¶

type UrlVar struct {
	Rid             int    `db:"rid"`
	Url             string `db:"url"`
	CreateTimestamp int    `db:"create_timestamp"`
	LastTimestamp   int    `db:"last_timestamp"`
	Uid             int    `db:"uid"`
	LastStatusCode  int    `db:"last_statuscode"`
	LastStatus      string `db:"last_status"`
}

func (*UrlVar) InsertUrl ¶

func (uv *UrlVar) InsertUrl(db *sqlx.DB) error

type UserVar ¶

type UserVar struct {
	Uid            int `db:"uid"`
	TelegramId     int `db:"telegram_id"`
	StartTimestamp int `db:"start_timestamp"`
	LastTimestamp  int `db:"last_timestamp"`
}

func GetUserInfoViaTelegramId ¶

func GetUserInfoViaTelegramId(db *sqlx.DB, telegram_id int) (*UserVar, error)

func GetUserInfoViaUid ¶

func GetUserInfoViaUid(db *sqlx.DB, uid int) (*UserVar, error)

func (*UserVar) InsertUser ¶

func (uv *UserVar) InsertUser(db *sqlx.DB) error

Source Files ¶

View all Source files

?	: This menu
/	: Search site
f or F	: Jump to
y or Y	: Canonical URL