SQLiteDataSource

Attributes

attributedb_path

= Path(db_path)

attributetable_name

= table_name

attributeallow_null

= allow_null

attributeunique

= unique

attributeunique_columns

= unique_columns

attributetable_exists

Check if the table exists in the database.

Functions

func__init__(self, db_path, table_name, allow_null=False, unique=True, unique_columns=None)

paramself

paramdb_pathstr | Path

paramtable_namestr

paramallow_nullbool

= False

paramuniquebool

= True

paramunique_columnslist[str] | None

= None

Returns

None

funcexists(self) → bool

Check if the database file exists.

paramself

Returns

bool

True if the SQLite database file exists on disk

func_table_exists(self)

paramself

Returns

None

func_columns(self) → list[str]

paramself

Returns

list[str]

func_create_if_not_exists(self, columns)

paramself

paramcolumnslist[str]

Returns

None

funcload_data(self) → pd.DataFrame

Load data from the data source.

paramself

Returns

pandas.pandas.DataFrame

funcsave_data(self, data, overwrite=False)

Save data to the data source. Accepts single dict, list of dicts, or DataFrame.

paramself

paramdataUnion[Dict[str, Any], List[Dict[str, Any]], pd.DataFrame]

paramoverwritebool

= False

Returns

None

funcquery_data(self, conditions) → pd.DataFrame

Query data from the data source based on specified conditions.

paramself

paramconditionsDict[str, Any]

Returns

pandas.pandas.DataFrame

funcupdate_data(self, conditions, updates)

Update existing data in the data source based on specified conditions.

paramself

paramconditionsDict[str, Any]

paramupdatesT

Returns

None

funcdelete_data(self, conditions)

Delete data from the data source based on specified conditions.

paramself

paramconditionsDict[str, Any]

Returns

None

funcgrab_column(self, column_name) → pd.Series

Retrieve a specific column from the data source.

paramself

paramcolumn_namestr

Returns

pandas.pandas.Series

funcgrab_row(self, index) → pd.Series

Retrieve a specific row from the data source.

paramself

paramindexint

Returns

pandas.pandas.Series

Attributes

Functions

On this page