pg_chameleon debug 1

MySQL example schema

desc accounts;
+--------------------------------+--------------+------+-----+-----------------+----------------+
| Field                          | Type         | Null | Key | Default         | Extra          |
+--------------------------------+--------------+------+-----+-----------------+----------------+
| id                             | int(11)      | NO   | PRI | NULL            | auto_increment |
| name                           | varchar(255) | YES  |     | Current Account |                |
| number                         | varchar(50)  | YES  | MUL | NULL            |                |
| tpsa_number                    | varchar(45)  | YES  |     | NULL            |                |
| type                           | varchar(45)  | YES  | MUL | current         |                |
| balance                        | bigint(11)   | YES  |     | 0               |                |
| available_balance              | bigint(11)   | YES  |     | 0               |                |
| currency                       | varchar(5)   | YES  |     | ZAR             |                |
| minimum_balance                | int(11)      | YES  |     | 0               |                |
| payroll_payment_fee            | int(11)      | YES  |     | NULL            |                |
| wist_id                        | varchar(45)  | YES  |     | NULL            |                |
| hashed_wist_pin                | varchar(45)  | YES  |     | NULL            |                |
| process_uuid                   | varchar(45)  | YES  |     | NULL            |                |
| visible_to_admin               | tinyint(1)   | YES  |     | 1               |                |
| payroll                        | tinyint(1)   | YES  |     | 0               |                |
| payroll_tax                    | tinyint(1)   | YES  |     | 0               |                |
| auto_eft_beneficiary_id        | varchar(45)  | YES  |     | NULL            |                |
| lock                           | varchar(45)  | YES  |     | NULL            |                |
| debt_collector_flag            | int(11)      | YES  |     | 0               |                |
| requires_payment_authorisation | tinyint(1)   | YES  |     | 0               |                |
| created_at                     | datetime(6)  | YES  |     | NULL            |                |
| updated_at                     | datetime(6)  | YES  |     | NULL            |                |
| deleted_at                     | datetime(6)  | YES  | MUL | NULL            |                |
| user_id                        | int(11)      | YES  | MUL | NULL            |                |
| other_numbers                  | varchar(255) | YES  | MUL | NULL            |                |
| merchant_id                    | int(11)      | YES  |     | NULL            |                |
| last_user_transaction_date     | datetime     | YES  |     | NULL            |                |
| mongo_id                       | varchar(45)  | YES  | MUL | NULL            |                |
+--------------------------------+--------------+------+-----+-----------------+----------------+

(venv) [root@staal1 ~/venv/bin]# ./chameleon.py --debug create_schema
Traceback (most recent call last):
  File "./chameleon.py", line 48, in <module>
    replica = replica_engine(args.config, args.debug, args.nolock)
  File "/root/venv/lib/python3.6/site-packages/pg_chameleon/lib/global_lib.py", line 213, in __init__
    self.my_eng=mysql_engine(self.global_config, self.logger)
  File "/root/venv/lib/python3.6/site-packages/pg_chameleon/lib/mysql_lib.py", line 77, in __init__
    self.mysql_con.connect_db()
  File "/root/venv/lib/python3.6/site-packages/pg_chameleon/lib/mysql_lib.py", line 48, in connect_db
    cursorclass=pymysql.cursors.DictCursor
  File "/root/venv/lib/python3.6/site-packages/pymysql/__init__.py", line 90, in Connect
    return Connection(*args, **kwargs)
  File "/root/venv/lib/python3.6/site-packages/pymysql/connections.py", line 706, in __init__
    self.connect()
  File "/root/venv/lib/python3.6/site-packages/pymysql/connections.py", line 932, in connect
    self._request_authentication()
  File "/root/venv/lib/python3.6/site-packages/pymysql/connections.py", line 1131, in _request_authentication
    authresp = _scramble(self.password.encode('latin1'), self.salt)
AttributeError: 'int' object has no attribute 'encode'