i> 4 S SK rS SKrS SKJr " S S5 rg) N)Configc h \ rS rSrSr\S 5 r\S 5 r\S 5 r\S 5 r \S 5 r
Sr g )
AppSettingsModel z
Model for managing application-wide settings in a key-value store.
The `setting_value` is stored as a JSON string to accommodate various data types.
c D [ R R [ R [ R
[ R [ R [ R S9$ ! [ R R a n [ SU 35 Sn A gSn A ff = f)z"Establishes a database connection.)hostportuserpassworddatabasez$Error connecting to MySQL Database: N) mysql connectorconnectr DB_HOSTDB_PORTDB_USER DB_PASSWORDDB_NAMEErrorprint)es 1/var/www/fran/franai/models/app_settings_model.pyget_db_connection"AppSettingsModel.get_db_connection sw
??**^^^^^^ ++ +
$$ 8< = s A&A) ) B BB c
[ R 5 n U ( d g U R 5 nUR S5 U R 5 [ S5 U R 5 ( a! WR 5 U R 5 gg! [ R R a n[ SU 35 SnANhSnAff = f! U R 5 ( a! WR 5 U R 5 f f = f)z;Creates the app_settings table if it doesn't already exist.Na=
CREATE TABLE IF NOT EXISTS app_settings (
id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
setting_key TEXT NOT NULL,
setting_value TEXT NOT NULL,
UNIQUE INDEX idx_setting_key (setting_key(191))
)
z=[OK] 'app_settings' table exists or was successfully created.z%Error creating 'app_settings' table: ) r r cursorexecutecommitr r
r r is_connectedclose)connr r s r create_table_if_not_exists+AppSettingsModel.create_table_if_not_exists s 113 [[]F NN
KKM Q R ""
# $$ ? 9!= > > ? ""
#s) R3SH /0 )
""
# ,,i8 H Fs=GYFZZrst363GH /0H
$$ 1!5 6I ""
# ""
#sS 3C, B/3C, /6C)%C, (C))C, , E
EEE EE 8Fc 6 [ R 5 nU( d g UR 5 nSnU R 5 VVs/ s H u pEU[ R
" U5 4PM nnnUR
X65 UR 5 [ S[ U5 S35 UR 5 ( a! UR 5 UR 5 ggs snnf ! [ R R a^ n[ SU 35 UR 5 SnAUR 5 ( a! WR 5 UR 5 ggSnAff = f! UR 5 ( a! WR 5 UR 5 f f = f)zd
Updates or inserts multiple settings from a dictionary.
Returns True on success, False on failure.
Fz
INSERT INTO app_settings (setting_key, setting_value)
VALUES (%s, %s)
ON DUPLICATE KEY UPDATE
setting_value = VALUES(setting_value)
z[OK] Successfully saved z settings to the database.TzError saving settings: N)r r r itemsr) dumps executemanyr r lenr r r
r r rollback)
settings_dictr! r querykeyvaluedata_to_insertr s r update_settings AppSettingsModel.update_settingsP sQ 113 [[]FE ? 9
KKM" V__$55IJK ""
# $$ : 4QC8 9 9 : ""
#s* B C/ / D%
D D( D%%D( (8E N) __name__
__module__ __qualname____firstlineno____doc__ staticmethodr r" r/ r< rS __static_attributes__rU r r r sl
2 6 D ( ( r] r )mysql.connectorr
r) franai.services.configr r rU r] r r` s )W W r]