diff options
Diffstat (limited to 'rgdb/datacnst.go')
-rw-r--r-- | rgdb/datacnst.go | 34 |
1 files changed, 34 insertions, 0 deletions
diff --git a/rgdb/datacnst.go b/rgdb/datacnst.go new file mode 100644 index 0000000..4dcc8a7 --- /dev/null +++ b/rgdb/datacnst.go @@ -0,0 +1,34 @@ +// Copyright 2021 SNIX LLC sina@snix.ir +// +// This program is free software; you can redistribute it and/or +// modify it under the terms of the GNU General Public License +// version 2 as published by the Free Software Foundation. +// This program is distributed in the hope that it will be useful, +// but WITHOUT ANY WARRANTY; without even the implied warranty of +// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +// GNU General Public License for more details. + +package rgdb + +import "time" + +const ( + databaseMaxConn = 128 + databaseMaxLife = 5 * time.Minute +) +const ( + sqlConnect = "%v:%v@tcp(%v)/%v?parseTime=true" + driverName = "mysql" +) + +const ( + regexExtin = "err: this pattern already exists in database" +) + +const ( + sqlSelect = "SELECT regexid, regexstr FROM regext" + sqlRgByID = "SELECT regexstr from regext where regexid=?" + sqlDelete = "DELETE FROM regext WHERE regexid=?" + sqlExistX = "SELECT EXISTS(SELECT * FROM regext WHERE regexstr=?)" + sqlInsert = "INSERT INTO regext (regexstr) VALUES (?)" +) |