===========================================================
.___ __ __
_________________ __ __ __| _/|__|/ |_
/ ___\_` __ \__ \ | | \/ __ | | \\_ __\
/ /_/ > | \// __ \| | / /_/ | | || |
\___ /|__| (____ /____/\____ | |__||__|
/_____/ \/ \/
grep rough audit - static analysis tool
v2.8 written by @Wireghoul
=================================[justanotherhacker.com]===
goiardi-0.11.10/client/postgres_funcs.go-31- }
goiardi-0.11.10/client/postgres_funcs.go:32: _, err = tx.Exec("SELECT goiardi.merge_clients($1, $2, $3, $4, $5, $6)", c.Name, c.NodeName, c.Validator, c.Admin, c.pubKey, c.Certificate)
goiardi-0.11.10/client/postgres_funcs.go-33- if err != nil {
##############################################
goiardi-0.11.10/client/postgres_funcs.go-50- }
goiardi-0.11.10/client/postgres_funcs.go:51: _, err = tx.Exec("SELECT goiardi.rename_client($1, $2)", c.Name, newName)
goiardi-0.11.10/client/postgres_funcs.go-52- if err != nil {
##############################################
goiardi-0.11.10/client/sql_funcs.go-54- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/client/sql_funcs.go:55: sqlStatement = "select c.name, nodename, validator, admin, o.name, public_key, certificate FROM goiardi.clients c JOIN goiardi.organizations o on c.organization_id = o.id WHERE c.name = $1"
goiardi-0.11.10/client/sql_funcs.go-56- }
##############################################
goiardi-0.11.10/client/sql_funcs.go-123- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/client/sql_funcs.go:124: _, err = tx.Exec("DELETE FROM goiardi.clients WHERE name = $1", c.Name)
goiardi-0.11.10/client/sql_funcs.go-125- }
##############################################
goiardi-0.11.10/config/config.go-913-// ListenAddr builds the address and port goiardi is configured to listen on.
goiardi-0.11.10/config/config.go:914:func ListenAddr() string {
goiardi-0.11.10/config/config.go-915- listenAddr := net.JoinHostPort(Config.Ipaddress, strconv.Itoa(Config.Port))
##############################################
goiardi-0.11.10/cookbook/sql_funcs.go-47- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/cookbook/sql_funcs.go:48: sqlStatement = "SELECT count(*) AS c FROM goiardi.cookbook_versions cbv WHERE cbv.cookbook_id = $1"
goiardi-0.11.10/cookbook/sql_funcs.go-49- }
##############################################
goiardi-0.11.10/cookbook/sql_funcs.go-276- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/cookbook/sql_funcs.go:277: sqlStatement = "SELECT id, name FROM goiardi.cookbooks WHERE name = $1"
goiardi-0.11.10/cookbook/sql_funcs.go-278- }
##############################################
goiardi-0.11.10/cookbook/sql_funcs.go-317- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/cookbook/sql_funcs.go:318: _, err = tx.Exec("DELETE FROM goiardi.cookbook_versions WHERE cookbook_id = $1", c.id)
goiardi-0.11.10/cookbook/sql_funcs.go-319- }
##############################################
goiardi-0.11.10/cookbook/sql_funcs.go-330- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/cookbook/sql_funcs.go:331: _, err = tx.Exec("DELETE FROM goiardi.cookbooks WHERE id = $1", c.id)
goiardi-0.11.10/cookbook/sql_funcs.go-332- }
##############################################
goiardi-0.11.10/cookbook/sql_funcs.go-385- } else {
goiardi-0.11.10/cookbook/sql_funcs.go:386: sqlStatement = "SELECT cv.id, cookbook_id, definitions, libraries, attributes, recipes, providers, resources, templates, root_files, files, metadata, major_ver, minor_ver, patch_ver, frozen, c.name FROM goiardi.cookbook_versions cv LEFT JOIN goiardi.cookbooks c ON cv.cookbook_id = c.id WHERE cookbook_id = $1 ORDER BY major_ver DESC, minor_ver DESC, patch_ver DESC"
goiardi-0.11.10/cookbook/sql_funcs.go-387- }
##############################################
goiardi-0.11.10/cookbook/sql_funcs.go-428- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/cookbook/sql_funcs.go:429: sqlStatement = "SELECT cv.id, cookbook_id, definitions, libraries, attributes, recipes, providers, resources, templates, root_files, files, metadata, major_ver, minor_ver, patch_ver, frozen, c.name FROM goiardi.cookbook_versions cv LEFT JOIN goiardi.cookbooks c ON cv.cookbook_id = c.id WHERE cookbook_id = $1 AND major_ver = $2 AND minor_ver = $3 AND patch_ver = $4"
goiardi-0.11.10/cookbook/sql_funcs.go-430- }
##############################################
goiardi-0.11.10/cookbook/sql_funcs.go-467- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/cookbook/sql_funcs.go:468: sqlStatement = "SELECT COUNT(cv.id) FROM goiardi.cookbook_versions cv LEFT JOIN goiardi.cookbooks c ON cv.cookbook_id = c.id WHERE cookbook_id = $1 AND major_ver = $2 AND minor_ver = $3 AND patch_ver = $4"
goiardi-0.11.10/cookbook/sql_funcs.go-469- }
##############################################
goiardi-0.11.10/cookbook/sql_funcs.go-499- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/cookbook/sql_funcs.go:500: _, err = tx.Exec("DELETE FROM goiardi.cookbook_versions WHERE id = $1", cbv.id)
goiardi-0.11.10/cookbook/sql_funcs.go-501- }
##############################################
goiardi-0.11.10/databag/sql_funcs.go-46- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/databag/sql_funcs.go:47: sqlStatement = "SELECT id, name FROM goiardi.data_bags WHERE name = $1"
goiardi-0.11.10/databag/sql_funcs.go-48- }
##############################################
goiardi-0.11.10/databag/sql_funcs.go-82- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/databag/sql_funcs.go:83: sqlStatement = "SELECT dbi.id, dbi.data_bag_id, dbi.name, dbi.orig_name, db.name, dbi.raw_data FROM goiardi.data_bag_items dbi JOIN goiardi.data_bags db on dbi.data_bag_id = db.id WHERE dbi.orig_name = $1 AND dbi.data_bag_id = $2"
goiardi-0.11.10/databag/sql_funcs.go-84- }
##############################################
goiardi-0.11.10/databag/sql_funcs.go-103- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/databag/sql_funcs.go:104: sqlStatement = "SELECT COUNT(dbi.id) FROM goiardi.data_bag_items dbi JOIN goiardi.data_bags db on dbi.data_bag_id = db.id WHERE dbi.orig_name = $1 AND dbi.data_bag_id = $2"
goiardi-0.11.10/databag/sql_funcs.go-105- }
##############################################
goiardi-0.11.10/databag/sql_funcs.go-135- }
goiardi-0.11.10/databag/sql_funcs.go:136: sqlStmt = fmt.Sprintf("SELECT dbi.id, dbi.data_bag_id, dbi.name, dbi.orig_name, db.name, dbi.raw_data FROM goiardi.data_bag_items dbi JOIN goiardi.data_bags db on dbi.data_bag_id = db.id WHERE dbi.data_bag_id = $1 AND dbi.orig_name IN (%s)", strings.Join(bind, ", "))
goiardi-0.11.10/databag/sql_funcs.go-137- }
##############################################
goiardi-0.11.10/databag/sql_funcs.go-181- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/databag/sql_funcs.go:182: _, err = tx.Exec("UPDATE goiardi.data_bag_items SET raw_data = $1, updated_at = NOW() WHERE id = $2", rawb, dbi.id)
goiardi-0.11.10/databag/sql_funcs.go-183- }
##############################################
goiardi-0.11.10/databag/sql_funcs.go-202- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/databag/sql_funcs.go:203: _, err = tx.Exec("DELETE FROM goiardi.data_bag_items WHERE id = $1", dbi.id)
goiardi-0.11.10/databag/sql_funcs.go-204- }
##############################################
goiardi-0.11.10/databag/sql_funcs.go-221- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/databag/sql_funcs.go:222: sqlStatement = "SELECT dbi.id, dbi.data_bag_id, dbi.name, dbi.orig_name, db.name, dbi.raw_data FROM goiardi.data_bag_items dbi JOIN goiardi.data_bags db on dbi.data_bag_id = db.id WHERE dbi.data_bag_id = $1"
goiardi-0.11.10/databag/sql_funcs.go-223- }
##############################################
goiardi-0.11.10/databag/sql_funcs.go-256- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/databag/sql_funcs.go:257: sqlStatement = "SELECT count(*) FROM goiardi.data_bag_items WHERE data_bag_id = $1"
goiardi-0.11.10/databag/sql_funcs.go-258- }
##############################################
goiardi-0.11.10/databag/sql_funcs.go-281- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/databag/sql_funcs.go:282: sqlStatement = "SELECT orig_name FROM goiardi.data_bag_items WHERE data_bag_id = $1"
goiardi-0.11.10/databag/sql_funcs.go-283- }
##############################################
goiardi-0.11.10/databag/sql_funcs.go-320- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/databag/sql_funcs.go:321: _, err = tx.Exec("DELETE FROM goiardi.data_bag_items WHERE data_bag_id = $1", db.id)
goiardi-0.11.10/databag/sql_funcs.go-322- }
##############################################
goiardi-0.11.10/databag/sql_funcs.go-332- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/databag/sql_funcs.go:333: _, err = tx.Exec("DELETE FROM goiardi.data_bags WHERE id = $1", db.id)
goiardi-0.11.10/databag/sql_funcs.go-334- }
##############################################
goiardi-0.11.10/datastore/db.go-150- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/datastore/db.go:151: prepStatement = fmt.Sprintf("SELECT id FROM goiardi.%s WHERE name = $1", kind)
goiardi-0.11.10/datastore/db.go-152- }
##############################################
goiardi-0.11.10/docs/features/logging.rst-10-
goiardi-0.11.10/docs/features/logging.rst:11:Log levels can be set in goiardi with either the ``log-level`` option in the configuration file, the ``--log-level`` flag on the command line, the ``$GOIARDI_LOG_LEVEL`` environment variable, or with one to five ``-V`` flags on the command line. Log level options are "debug", "info", "warning", "error", "critical", and "fatal". More ``-V`` on the command line means more spewing into the log.
##############################################
goiardi-0.11.10/docs/features/persistence.rst-59-
goiardi-0.11.10/docs/features/persistence.rst:60:* Create the user: ``$ createuser goiardi <additional options>``
goiardi-0.11.10/docs/features/persistence.rst:61:* Create the database, if you decided to: ``$ createdb goiardi_db <additional options>``. If you created a user, make it the owner of the goiardi db with ``-O goiardi``.
goiardi-0.11.10/docs/features/persistence.rst-62-
##############################################
goiardi-0.11.10/docs/installation.rst-9-
goiardi-0.11.10/docs/installation.rst:10:2. Make sure your ``$GOROOT`` and ``$PATH`` are set up correctly per the Go installation instructions.
goiardi-0.11.10/docs/installation.rst-11-
##############################################
goiardi-0.11.10/docs/installation.rst-34-
goiardi-0.11.10/docs/installation.rst:35:Additionally, many of goiardi's options that can be set with flags can also be set with environment variables. Where this is the case, the option's description will be followed by an environment variable name (like ``$GOIARDI_HANDY_OPTION``).
goiardi-0.11.10/docs/installation.rst-36-
##############################################
goiardi-0.11.10/environment/postgres_funcs.go-45-
goiardi-0.11.10/environment/postgres_funcs.go:46: _, err = tx.Exec("SELECT goiardi.merge_environments($1, $2, $3, $4, $5)", e.Name, e.Description, dab, oab, cvb)
goiardi-0.11.10/environment/postgres_funcs.go-47- if err != nil {
##############################################
goiardi-0.11.10/environment/sql_funcs.go-88- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/environment/sql_funcs.go:89: sqlStatement = "SELECT name, description, default_attr, override_attr, cookbook_vers FROM goiardi.environments WHERE name = $1"
goiardi-0.11.10/environment/sql_funcs.go-90- }
##############################################
goiardi-0.11.10/environment/sql_funcs.go-154- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/environment/sql_funcs.go:155: sqlStatement = "DELETE FROM goiardi.environments WHERE name = $1"
goiardi-0.11.10/environment/sql_funcs.go-156- }
##############################################
goiardi-0.11.10/filestore/postgres_funcs.go-35-
goiardi-0.11.10/filestore/postgres_funcs.go:36: _, err = tx.Exec("INSERT INTO goiardi.file_checksums (organization_id, checksum) VALUES (1, $1)", f.Chksum)
goiardi-0.11.10/filestore/postgres_funcs.go-37- if err != nil {
##############################################
goiardi-0.11.10/filestore/postgres_funcs.go-53- }
goiardi-0.11.10/filestore/postgres_funcs.go:54: deleteQuery := "DELETE FROM goiardi.file_checksums WHERE checksum = ANY($1::varchar(32)[])"
goiardi-0.11.10/filestore/postgres_funcs.go-55- _, err = tx.Exec(deleteQuery, "{"+strings.Join(fileHashes, ",")+"}")
##############################################
goiardi-0.11.10/filestore/sql_funcs.go-34- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/filestore/sql_funcs.go:35: sqlStatement = "SELECT checksum FROM goiardi.file_checksums WHERE checksum = $1"
goiardi-0.11.10/filestore/sql_funcs.go-36- }
##############################################
goiardi-0.11.10/filestore/sql_funcs.go-57- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/filestore/sql_funcs.go:58: sqlStatement = "DELETE FROM goiardi.file_checksums WHERE checksum = $1"
goiardi-0.11.10/filestore/sql_funcs.go-59- }
##############################################
goiardi-0.11.10/goiardi.go-250-
goiardi-0.11.10/goiardi.go:251: listenAddr := config.ListenAddr()
goiardi-0.11.10/goiardi.go-252- var err error
##############################################
goiardi-0.11.10/indexer/postgres_indexer.go-39- // organization_id will obviously not always be 1
goiardi-0.11.10/indexer/postgres_indexer.go:40: err = tx.QueryRow("SELECT count(*) FROM goiardi.search_collections WHERE organization_id = $1 AND name IN ('node', 'client', 'environment', 'role')", 1).Scan(&c)
goiardi-0.11.10/indexer/postgres_indexer.go-41- if err != nil {
##############################################
goiardi-0.11.10/indexer/postgres_indexer.go-87- }
goiardi-0.11.10/indexer/postgres_indexer.go:88: _, err = tx.Exec("SELECT goiardi.delete_search_collection($1, $2)", col, 1)
goiardi-0.11.10/indexer/postgres_indexer.go-89- if err != nil {
##############################################
goiardi-0.11.10/indexer/postgres_indexer.go-101- }
goiardi-0.11.10/indexer/postgres_indexer.go:102: _, err = tx.Exec("SELECT goiardi.delete_search_item($1, $2, $3)", idxName, doc, 1)
goiardi-0.11.10/indexer/postgres_indexer.go-103- if err != nil {
##############################################
goiardi-0.11.10/indexer/postgres_indexer.go-119- var scID int32
goiardi-0.11.10/indexer/postgres_indexer.go:120: err = tx.QueryRow("SELECT id FROM goiardi.search_collections WHERE organization_id = $1 AND name = $2", 1, collectionName).Scan(&scID)
goiardi-0.11.10/indexer/postgres_indexer.go-121- if err != nil {
##############################################
goiardi-0.11.10/indexer/postgres_indexer.go-124- }
goiardi-0.11.10/indexer/postgres_indexer.go:125: _, err = tx.Exec("SELECT goiardi.delete_search_item($1, $2, $3)", collectionName, itemName, 1)
goiardi-0.11.10/indexer/postgres_indexer.go-126- if err != nil {
##############################################
goiardi-0.11.10/indexer/postgres_indexer.go-186-func (p *PostgresIndex) Endpoints() ([]string, error) {
goiardi-0.11.10/indexer/postgres_indexer.go:187: sqlStmt := "SELECT ARRAY_AGG(name) FROM goiardi.search_collections WHERE organization_id = $1"
goiardi-0.11.10/indexer/postgres_indexer.go-188- stmt, err := datastore.Dbh.Prepare(sqlStmt)
##############################################
goiardi-0.11.10/indexer/postgres_indexer.go-220-
goiardi-0.11.10/indexer/postgres_indexer.go:221: sqlStmt := "DELETE FROM goiardi.search_items WHERE organization_id = $1"
goiardi-0.11.10/indexer/postgres_indexer.go-222- _, err = tx.Exec(sqlStmt, 1)
##############################################
goiardi-0.11.10/indexer/postgres_indexer.go-226- }
goiardi-0.11.10/indexer/postgres_indexer.go:227: sqlStmt = "DELETE FROM goiardi.search_collections WHERE organization_id = $1"
goiardi-0.11.10/indexer/postgres_indexer.go-228- _, err = tx.Exec(sqlStmt, 1)
##############################################
goiardi-0.11.10/loginfo/sql_funcs.go-103- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/loginfo/sql_funcs.go:104: sqlStmt = "SELECT id, actor_type, actor_info, time, action, object_type, object_name, extended_info FROM goiardi.log_infos WHERE id = $1"
goiardi-0.11.10/loginfo/sql_funcs.go-105- }
##############################################
goiardi-0.11.10/loginfo/sql_funcs.go-132- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/loginfo/sql_funcs.go:133: sqlStmt = "SELECT id FROM goiardi.log_infos WHERE id = $1"
goiardi-0.11.10/loginfo/sql_funcs.go-134- }
##############################################
goiardi-0.11.10/loginfo/sql_funcs.go-162- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/loginfo/sql_funcs.go:163: sqlStmt = "DELETE FROM goiardi.log_infos WHERE id = $1"
goiardi-0.11.10/loginfo/sql_funcs.go-164- }
##############################################
goiardi-0.11.10/loginfo/sql_funcs.go-184- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/loginfo/sql_funcs.go:185: sqlStmt = "DELETE FROM goiardi.log_infos WHERE id <= $1"
goiardi-0.11.10/loginfo/sql_funcs.go-186- }
##############################################
goiardi-0.11.10/node/postgres_funcs.go-26-func (n *Node) savePostgreSQL(tx datastore.Dbhandle, rlb, aab, nab, dab, oab []byte) error {
goiardi-0.11.10/node/postgres_funcs.go:27: _, err := tx.Exec("SELECT goiardi.merge_nodes($1, $2, $3, $4, $5, $6, $7)", n.Name, n.ChefEnvironment, rlb, aab, nab, dab, oab)
goiardi-0.11.10/node/postgres_funcs.go-28- if err != nil {
##############################################
goiardi-0.11.10/node/postgres_funcs.go-38- }
goiardi-0.11.10/node/postgres_funcs.go:39: _, err = tx.Exec("SELECT goiardi.insert_node_status($1, $2)", ns.Node.Name, ns.Status)
goiardi-0.11.10/node/postgres_funcs.go-40- if err != nil {
##############################################
goiardi-0.11.10/node/postgres_funcs.go-48- if isDown != ns.Node.isDown {
goiardi-0.11.10/node/postgres_funcs.go:49: _, err = tx.Exec("UPDATE goiardi.nodes SET is_down = $1, updated_at = NOW() WHERE name = $2", isDown, ns.Node.Name)
goiardi-0.11.10/node/postgres_funcs.go-50- if err != nil {
##############################################
goiardi-0.11.10/node/postgres_funcs.go-76- var nodes []*Node
goiardi-0.11.10/node/postgres_funcs.go:77: sqlStmt := "SELECT n.name, chef_environment, n.run_list, n.automatic_attr, n.normal_attr, n.default_attr, n.override_attr FROM goiardi.node_latest_statuses n WHERE n.status = $1 AND n.name = ANY($2::text[])"
goiardi-0.11.10/node/postgres_funcs.go-78- stmt, err := datastore.Dbh.Prepare(sqlStmt)
##############################################
goiardi-0.11.10/node/sql_funcs.go-91- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/node/sql_funcs.go:92: sqlStmt = "select n.name, chef_environment, n.run_list, n.automatic_attr, n.normal_attr, n.default_attr, n.override_attr from goiardi.nodes n where n.name = $1"
goiardi-0.11.10/node/sql_funcs.go-93- }
##############################################
goiardi-0.11.10/node/sql_funcs.go-203- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/node/sql_funcs.go:204: sqlStmt = "DELETE FROM goiardi.nodes WHERE name = $1"
goiardi-0.11.10/node/sql_funcs.go-205- }
##############################################
goiardi-0.11.10/node/sql_funcs.go-229- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/node/sql_funcs.go:230: sqlStmt = "DELETE FROM goiardi.node_statuses WHERE updated_at >= $1"
goiardi-0.11.10/node/sql_funcs.go-231- }
##############################################
goiardi-0.11.10/node/sql_funcs.go-260- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/node/sql_funcs.go:261: sqlStmt = "INSERT INTO goiardi.node_statuses (node_id, status, updated_at) SELECT id, $1, $2 FROM goiardi.nodes WHERE name = $3"
goiardi-0.11.10/node/sql_funcs.go-262- }
##############################################
goiardi-0.11.10/node/sql_funcs.go-312- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/node/sql_funcs.go:313: sqlStmt = "SELECT n.name, chef_environment, n.run_list, n.automatic_attr, n.normal_attr, n.default_attr, n.override_attr FROM goiardi.nodes n WHERE n.chef_environment = $1"
goiardi-0.11.10/node/sql_funcs.go-314- }
##############################################
goiardi-0.11.10/node/sql_funcs.go-383- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/node/sql_funcs.go:384: sqlStmt = "SELECT status, updated_at FROM goiardi.node_latest_statuses WHERE name = $1"
goiardi-0.11.10/node/sql_funcs.go-385- }
##############################################
goiardi-0.11.10/node/sql_funcs.go-409- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/node/sql_funcs.go:410: sqlStmt = "SELECT status, ns.updated_at FROM goiardi.node_statuses ns JOIN goiardi.nodes n ON ns.node_id = n.id WHERE n.name = $1 ORDER BY ns.id"
goiardi-0.11.10/node/sql_funcs.go-411- }
##############################################
goiardi-0.11.10/report/postgres_funcs.go-67- // syntax.
goiardi-0.11.10/report/postgres_funcs.go:68: _, err = tx.Exec("SELECT goiardi.merge_reports($1, $2, $3, $4, $5, $6, $7, $8, $9)", r.RunID, r.NodeName, r.StartTime, r.EndTime, r.TotalResCount, r.Status, r.RunList, res, dat)
goiardi-0.11.10/report/postgres_funcs.go-69- if err != nil {
##############################################
goiardi-0.11.10/report/sql_funcs.go-35- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/report/sql_funcs.go:36: sqlStmt = "SELECT count(*) AS c FROM goiardi.reports WHERE run_id = $1"
goiardi-0.11.10/report/sql_funcs.go-37- }
##############################################
goiardi-0.11.10/report/sql_funcs.go-71- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/report/sql_funcs.go:72: sqlStmt = "SELECT run_id, start_time, end_time, total_res_count, status, run_list, resources, data, node_name FROM goiardi.reports WHERE run_id = $1"
goiardi-0.11.10/report/sql_funcs.go-73- }
##############################################
goiardi-0.11.10/report/sql_funcs.go-97- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/report/sql_funcs.go:98: sqlStmt = "DELETE FROM goiardi.reports WHERE run_id = $1"
goiardi-0.11.10/report/sql_funcs.go-99- }
##############################################
goiardi-0.11.10/report/sql_funcs.go-123- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/report/sql_funcs.go:124: sqlStmt = "DELETE FROM goiardi.reports WHERE end_time >= $1"
goiardi-0.11.10/report/sql_funcs.go-125- }
##############################################
goiardi-0.11.10/report/sql_funcs.go-180- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/report/sql_funcs.go:181: sqlStmt = "SELECT run_id, start_time, end_time, total_res_count, status, run_list, resources, data, node_name FROM goiardi.reports WHERE start_time >= $1 AND start_time <= $2 LIMIT $3"
goiardi-0.11.10/report/sql_funcs.go-182- }
##############################################
goiardi-0.11.10/report/sql_funcs.go-186- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/report/sql_funcs.go:187: sqlStmt = "SELECT run_id, start_time, end_time, total_res_count, status, run_list, resources, data, node_name FROM goiardi.reports WHERE start_time >= $1 AND start_time <= $2 AND status = $3 LIMIT $4"
goiardi-0.11.10/report/sql_funcs.go-188- }
##############################################
goiardi-0.11.10/report/sql_funcs.go-233- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/report/sql_funcs.go:234: sqlStmt = "SELECT run_id, start_time, end_time, total_res_count, status, run_list, resources, data, node_name FROM goiardi.reports WHERE node_name = $1 AND start_time >= $2 AND start_time <= $3 LIMIT $4"
goiardi-0.11.10/report/sql_funcs.go-235- }
##############################################
goiardi-0.11.10/report/sql_funcs.go-239- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/report/sql_funcs.go:240: sqlStmt = "SELECT run_id, start_time, end_time, total_res_count, status, run_list, resources, data, node_name FROM goiardi.reports WHERE node_name = $1 AND start_time >= $2 AND start_time <= $3 AND status = $4 LIMIT $5"
goiardi-0.11.10/report/sql_funcs.go-241- }
##############################################
goiardi-0.11.10/role/postgres_funcs.go-45- }
goiardi-0.11.10/role/postgres_funcs.go:46: _, err = tx.Exec("SELECT goiardi.merge_roles($1, $2, $3, $4, $5, $6)", r.Name, r.Description, rlb, erb, dab, oab)
goiardi-0.11.10/role/postgres_funcs.go-47- if err != nil {
##############################################
goiardi-0.11.10/role/sql_funcs.go-80- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/role/sql_funcs.go:81: sqlStmt = "SELECT name, description, run_list, env_run_lists, default_attr, override_attr FROM goiardi.roles WHERE name = $1"
goiardi-0.11.10/role/sql_funcs.go-82- }
##############################################
goiardi-0.11.10/role/sql_funcs.go-150- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/role/sql_funcs.go:151: sqlStmt = "DELETE FROM goiardi.roles WHERE name = $1"
goiardi-0.11.10/role/sql_funcs.go-152- }
##############################################
goiardi-0.11.10/sandbox/postgres_funcs.go-46- }
goiardi-0.11.10/sandbox/postgres_funcs.go:47: _, err = tx.Exec("SELECT goiardi.merge_sandboxes($1, $2, $3, $4)", s.ID, s.CreationTime, ckb, s.Completed)
goiardi-0.11.10/sandbox/postgres_funcs.go-48- if err != nil {
##############################################
goiardi-0.11.10/sandbox/sql_funcs.go-44- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/sandbox/sql_funcs.go:45: sqlStmt = "SELECT sbox_id, creation_time, checksums, completed FROM goiardi.sandboxes WHERE sbox_id = $1"
goiardi-0.11.10/sandbox/sql_funcs.go-46- }
##############################################
goiardi-0.11.10/sandbox/sql_funcs.go-68- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/sandbox/sql_funcs.go:69: sqlStmt = "DELETE FROM goiardi.sandboxes WHERE sbox_id = $1"
goiardi-0.11.10/sandbox/sql_funcs.go-70- }
##############################################
goiardi-0.11.10/scripts/lfs-s3-conv.sh-35-
goiardi-0.11.10/scripts/lfs-s3-conv.sh:36:for FILE in `ls $DIR`; do
goiardi-0.11.10/scripts/lfs-s3-conv.sh:37: prefix=`echo $FILE | cut -c 1-2`
goiardi-0.11.10/scripts/lfs-s3-conv.sh-38- s3cmd --region=$REGION $AMZ_ARGS put $DIR/$FILE s3://${BUCKET}/default/file_store/$prefix/$FILE
##############################################
goiardi-0.11.10/search/postgres_search.go-54- // check that the endpoint actually exists
goiardi-0.11.10/search/postgres_search.go:55: sqlStmt := "SELECT 1 FROM goiardi.search_collections WHERE organization_id = $1 AND name = $2"
goiardi-0.11.10/search/postgres_search.go-56- stmt, serr := datastore.Dbh.Prepare(sqlStmt)
##############################################
goiardi-0.11.10/search/postgres_search.go-84- builtinIdx = true
goiardi-0.11.10/search/postgres_search.go:85: sqlStmt = fmt.Sprintf("SELECT COALESCE(ARRAY_AGG(name), '{}'::text[]) FROM goiardi.%ss WHERE organization_id = $1", idx)
goiardi-0.11.10/search/postgres_search.go-86- } else {
goiardi-0.11.10/search/postgres_search.go:87: sqlStmt = "SELECT COALESCE(ARRAY_AGG(orig_name), '{}'::text[]) FROM goiardi.data_bag_items JOIN goiardi.data_bags ON goiardi.data_bag_items.data_bag_id = goiardi.data_bags.id WHERE goiardi.data_bags.organization_id = $1 AND goiardi.data_bags.name = $2"
goiardi-0.11.10/search/postgres_search.go-88- }
##############################################
goiardi-0.11.10/search/postgres_search.go-514- if idx == "node" || idx == "client" || idx == "environment" || idx == "role" {
goiardi-0.11.10/search/postgres_search.go:515: itemsStatement = fmt.Sprintf("SELECT name AS item_name FROM goiardi.%ss WHERE organization_id = $1", idx)
goiardi-0.11.10/search/postgres_search.go-516- } else {
goiardi-0.11.10/search/postgres_search.go:517: itemsStatement = fmt.Sprintf("SELECT orig_name AS item_name FROM goiardi.data_bag_items JOIN goiardi.data_bags ON goiardi.data_bag_items.data_bag_id = goiardi.data_bags.id WHERE goiardi.data_bags.organization_id = $1 AND goiardi.data_bags.name = $2")
goiardi-0.11.10/search/postgres_search.go-518- pcount = 3
##############################################
goiardi-0.11.10/search/postgres_search.go-526-
goiardi-0.11.10/search/postgres_search.go:527: withStatement := fmt.Sprintf("WITH found_items AS (SELECT item_name, path, value FROM goiardi.search_items si WHERE si.organization_id = $1 AND si.search_collection_id = (SELECT id FROM goiardi.search_collections WHERE name = $2) AND path OPERATOR(goiardi.?) ARRAY[ %s ]::goiardi.lquery[]), items AS (%s)", strings.Join(params, ", "), itemsStatement)
goiardi-0.11.10/search/postgres_search.go-528- var selectStmt string
##############################################
goiardi-0.11.10/shovey/postgres_funcs.go-83- }
goiardi-0.11.10/shovey/postgres_funcs.go:84: _, err = tx.Exec("SELECT goiardi.merge_shoveys($1, $2, $3, $4, $5)", s.RunID, s.Command, s.Status, s.Timeout, s.Quorum)
goiardi-0.11.10/shovey/postgres_funcs.go-85- if err != nil {
##############################################
goiardi-0.11.10/shovey/postgres_funcs.go-100- }
goiardi-0.11.10/shovey/postgres_funcs.go:101: _, err = tx.Exec("SELECT goiardi.merge_shovey_runs($1, $2, $3, $4, $5, $6, $7)", sr.ShoveyUUID, sr.NodeName, sr.Status, sr.AckTime, sr.EndTime, sr.Error, sr.ExitStatus)
goiardi-0.11.10/shovey/postgres_funcs.go-102- if err != nil {
##############################################
goiardi-0.11.10/shovey/sql_funcs.go-32- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/shovey/sql_funcs.go:33: sqlStmt = "SELECT count(*) AS c FROM goiardi.shoveys WHERE run_id = $1"
goiardi-0.11.10/shovey/sql_funcs.go-34- }
##############################################
goiardi-0.11.10/shovey/sql_funcs.go-85- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/shovey/sql_funcs.go:86: sqlStatement = "SELECT run_id, ARRAY(SELECT node_name FROM goiardi.shovey_runs WHERE shovey_uuid = $1), command, created_at, updated_at, status, timeout, quorum FROM goiardi.shoveys WHERE run_id = $1"
goiardi-0.11.10/shovey/sql_funcs.go-87- } else {
##############################################
goiardi-0.11.10/shovey/sql_funcs.go-152- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/shovey/sql_funcs.go:153: sqlStatement = "SELECT id, shovey_uuid, node_name, status, ack_time, end_time, error, exit_status FROM goiardi.shovey_runs WHERE shovey_uuid = $1 and node_name = $2"
goiardi-0.11.10/shovey/sql_funcs.go-154- } else {
##############################################
goiardi-0.11.10/shovey/sql_funcs.go-185- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/shovey/sql_funcs.go:186: sqlStatement = "SELECT id, shovey_uuid, node_name, status, ack_time, end_time, error, exit_status FROM goiardi.shovey_runs WHERE shovey_uuid = $1"
goiardi-0.11.10/shovey/sql_funcs.go-187- } else {
##############################################
goiardi-0.11.10/shovey/sql_funcs.go-249- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/shovey/sql_funcs.go:250: sqlStatement = "UPDATE goiardi.shovey_runs SET status = 'cancelled', end_time = NOW() WHERE shovey_uuid = $1 AND status NOT IN ('invalid', 'succeeded', 'failed', 'down', 'nacked')"
goiardi-0.11.10/shovey/sql_funcs.go-251- } else {
##############################################
goiardi-0.11.10/shovey/sql_funcs.go-279- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/shovey/sql_funcs.go:280: sqlStatement = "SELECT count(id) FROM goiardi.shovey_runs WHERE shovey_uuid = $1 AND status IN ('invalid', 'succeeded', 'failed', 'down', 'nacked')"
goiardi-0.11.10/shovey/sql_funcs.go-281- } else {
##############################################
goiardi-0.11.10/shovey/sql_funcs.go-416- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/shovey/sql_funcs.go:417: sqlStatement = "SELECT sr.shovey_uuid, sr.node_name, seq, output_type, streams.output, is_last, created_at FROM goiardi.shovey_run_streams streams JOIN goiardi.shovey_runs sr ON streams.shovey_run_id = sr.id WHERE shovey_run_id = $1 AND output_type = $2 AND seq >= $3"
goiardi-0.11.10/shovey/sql_funcs.go-418- } else {
##############################################
goiardi-0.11.10/user/postgres_funcs.go-35- }
goiardi-0.11.10/user/postgres_funcs.go:36: _, err = tx.Exec("SELECT goiardi.merge_users($1, $2, $3, $4, $5, $6, $7, $8)", u.Username, u.Name, u.Email, u.Admin, u.pubKey, u.passwd, u.salt, defaultOrgID)
goiardi-0.11.10/user/postgres_funcs.go-37- if err != nil {
##############################################
goiardi-0.11.10/user/postgres_funcs.go-54- }
goiardi-0.11.10/user/postgres_funcs.go:55: _, err = tx.Exec("SELECT goiardi.rename_user($1, $2, $3)", u.Username, newName, defaultOrgID)
goiardi-0.11.10/user/postgres_funcs.go-56- if err != nil {
##############################################
goiardi-0.11.10/user/sql_funcs.go-56- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/user/sql_funcs.go:57: sqlStatement = "select name, displayname, admin, public_key, email, passwd, salt FROM goiardi.users WHERE name = $1"
goiardi-0.11.10/user/sql_funcs.go-58- }
##############################################
goiardi-0.11.10/user/sql_funcs.go-79- } else if config.Config.UsePostgreSQL {
goiardi-0.11.10/user/sql_funcs.go:80: _, err = tx.Exec("DELETE FROM goiardi.users WHERE name = $1", u.Username)
goiardi-0.11.10/user/sql_funcs.go-81- }