<commit_before>---
#global settings
my_server_id: 100
replica_batch_size: 1000
batch_retention: '1 day'
copy_max_memory: 300M
my_database:  db_replica
pg_database: db_replication
#copy mode when initialising, it can be file (dumps to out_dir a csv file) or direct (copy the file in memory)
copy_mode: 'file'  
out_dir: /tmp
source_name: 'default'
dest_schema: 'my_schema'


#seconds between each replica loop
sleep_loop: 10 

#Pause the replica for the given amount of seconds if a reindex process is found
pause_on_reindex: Yes
sleep_on_reindex: 30

#list the application names which are supposed to reindex the database
reindex_app_names:
    - 'reindexdb'
    - 'my_custom_reindex'

hexify: 
    - 'blob'
    - 'tinyblob'
    - 'mediumblob'
    - 'longblob'
    - 'binary'
    - 'varbinary'
    - 'geometry'
 
pid_dir: '~/.pg_chameleon/pid/'


log_dir: '~/.pg_chameleon/logs/'
log_level: 'debug'
log_dest: 'stdout'
log_days_keep: 10
#log_dest: 'file'
#log_level: 'info'
#log_level: 'debug'


#mysql connection's charset. 
my_charset: 'utf8'
#postgresql connection's charset. 
pg_charset: 'utf8'
#include tables only
tables_limit:
    

#mysql slave setup
mysql_conn:
    host: localhost
    port: 3306
    user: replication_username
    passwd: <PASSWORD>

#postgres connection
pg_conn:
    host: localhost
    port: 5432
    user: replication_username
    password: <PASSWORD>
 
type_override:
    tinyint:
        dimension: 1
        typedest: boolean
<commit_msg>update config-example with the correct override syntax<commit_after>---
#global settings
my_server_id: 100
replica_batch_size: 1000
batch_retention: '1 day'
copy_max_memory: 300M
my_database:  db_replica
pg_database: db_replication
#copy mode when initialising, it can be file (dumps to out_dir a csv file) or direct (copy the file in memory)
copy_mode: 'file'  
out_dir: /tmp
source_name: 'default'
dest_schema: 'my_schema'


#seconds between each replica loop
sleep_loop: 10 

#Pause the replica for the given amount of seconds if a reindex process is found
pause_on_reindex: Yes
sleep_on_reindex: 30

#list the application names which are supposed to reindex the database
reindex_app_names:
    - 'reindexdb'
    - 'my_custom_reindex'

hexify: 
    - 'blob'
    - 'tinyblob'
    - 'mediumblob'
    - 'longblob'
    - 'binary'
    - 'varbinary'
    - 'geometry'
 
pid_dir: '~/.pg_chameleon/pid/'


log_dir: '~/.pg_chameleon/logs/'
log_level: 'debug'
log_dest: 'stdout'
log_days_keep: 10
#log_dest: 'file'
#log_level: 'info'
#log_level: 'debug'


#mysql connection's charset. 
my_charset: 'utf8'
#postgresql connection's charset. 
pg_charset: 'utf8'
#include tables only
tables_limit:
    

#mysql slave setup
mysql_conn:
    host: localhost
    port: 3306
    user: replication_username
    passwd: <PASSWORD>

#postgres connection
pg_conn:
    host: localhost
    port: 5432
    user: replication_username
    password: <PASSWORD>
 
type_override:
    "tinyint(1)":
        typedest: boolean

{'fraction_non_alphanumeric': 0.09308600337268128, 'fraction_numerical': 0.01888701517706577, 'mean_word_length': 3.976510067114094, 'pattern_counts': {'":': 1, '<': 7, '<?xml version=': 0, '>': 7, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '6856357', 'n_tokens_mistral': 1119, 'n_tokens_neox': 1039, 'n_words': 308}