Skip to content

Correction of the "no results for selection" error in Insert queries #1

@EasyFor314

Description

@EasyFor314

Fix pls.

sql.py/sql/__init__.py

Lines 893 to 907 in 122e35d

def query(source, params=None):
db_ = None
try:
db_ = db.get()
cursor = db_.cursor()
cursor.execute(*debug(source, params))
log.debug(color.cyan('Total %s'), cursor.rowcount)
if cursor.rowcount > 0:
result = []
for record in cursor:
result.append(record)
return result
finally:
db_.commit()
db.put(db_)

if cursor.description:  # This means it's a SELECT
            result = []
            for record in cursor:
                result.append(record)
            return result

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions