Core

SQL

SQL helper.

3 public methods

Import

from Xenonix.Core import SQL

Filter methods, arguments, and configuration keys on this page.

Use Config(...) with these keys where the class exposes configuration.

This object does not expose a public Config table.

Creates a new SQL instance.

Create(Host, User, Pass, Database, Port=3306)

Argument	Default	Accepted values	What it does
`Host`	Required	Any valid value	Host value used by the operation.
`User`	Required	Any valid value	User value used by the operation.
`Pass`	Required	Any valid value	Pass value used by the operation.
`Database`	Required	Any valid value	Database value used by the operation.
`Port`	`3306`	Any valid value	Port value used by the operation.

Creates a new SQL object.

Runs the Get operation for SQL.

Get(SqlCommand, Keys=True)

Argument	Default	Accepted values	What it does
`SqlCommand`	Required	Any valid value	SqlCommand value used by the operation.
`Keys`	`True`	Any valid value	Turns keys on or off.

Returns the calculated result.

Runs the Post operation for SQL.

Post(SqlCommand)

Argument	Default	Accepted values	What it does
`SqlCommand`	Required	Any valid value	SqlCommand value used by the operation.

Runs the operation. Some methods update the object in place.