Converting timestamp in mysql to postgres #1
Description
Hi,
Is there a way I can alter the table conversion, this error occurred because the mysql table has a datetime, or fix this issue (below)?
Regards
Mark
LINE 10: created_at DATETIME NOT NULL,
^
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/Users/mark/opt/anaconda3/envs/dyn/bin/sqlacrossover", line 8, in <module>
sys.exit(main())
File "/Users/mark/opt/anaconda3/envs/dyn/lib/python3.7/site-packages/sqlacrossover.py", line 177, in main
target.create_all(source.meta)
File "/Users/mark/opt/anaconda3/envs/dyn/lib/python3.7/site-packages/sqlacrossover.py", line 44, in create_all
metadata.create_all(self.engine)
File "/Users/mark/opt/anaconda3/envs/dyn/lib/python3.7/site-packages/sqlalchemy/sql/schema.py", line 4465, in create_all
ddl.SchemaGenerator, self, checkfirst=checkfirst, tables=tables
File "/Users/mark/opt/anaconda3/envs/dyn/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 2104, in _run_visitor
conn._run_visitor(visitorcallable, element, **kwargs)
File "/Users/mark/opt/anaconda3/envs/dyn/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1663, in _run_visitor
visitorcallable(self.dialect, self, **kwargs).traverse_single(element)
File "/Users/mark/opt/anaconda3/envs/dyn/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 144, in traverse_single
return meth(obj, **kw)
File "/Users/mark/opt/anaconda3/envs/dyn/lib/python3.7/site-packages/sqlalchemy/sql/ddl.py", line 787, in visit_metadata
_is_metadata_operation=True,
File "/Users/mark/opt/anaconda3/envs/dyn/lib/python3.7/site-packages/sqlalchemy/sql/visitors.py", line 144, in traverse_single
return meth(obj, **kw)
File "/Users/mark/opt/anaconda3/envs/dyn/lib/python3.7/site-packages/sqlalchemy/sql/ddl.py", line 832, in visit_table
include_foreign_key_constraints, # noqa
File "/Users/mark/opt/anaconda3/envs/dyn/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1020, in execute
return meth(self, multiparams, params)
File "/Users/mark/opt/anaconda3/envs/dyn/lib/python3.7/site-packages/sqlalchemy/sql/ddl.py", line 72, in _execute_on_connection
return connection._execute_ddl(self, multiparams, params)
File "/Users/mark/opt/anaconda3/envs/dyn/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1082, in _execute_ddl
compiled,
File "/Users/mark/opt/anaconda3/envs/dyn/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1324, in _execute_context
e, statement, parameters, cursor, context
File "/Users/mark/opt/anaconda3/envs/dyn/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1518, in _handle_dbapi_exception
sqlalchemy_exception, with_traceback=exc_info[2], from_=e
File "/Users/mark/opt/anaconda3/envs/dyn/lib/python3.7/site-packages/sqlalchemy/util/compat.py", line 178, in raise_
raise exception
File "/Users/mark/opt/anaconda3/envs/dyn/lib/python3.7/site-packages/sqlalchemy/engine/base.py", line 1284, in _execute_context
cursor, statement, parameters, context
File "/Users/mark/opt/anaconda3/envs/dyn/lib/python3.7/site-packages/sqlalchemy/engine/default.py", line 590, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.ProgrammingError: (psycopg2.errors.UndefinedObject) type "datetime" does not exist
LINE 10: created_at DATETIME NOT NULL,
^
[SQL:
CREATE TABLE account_vetos (
id SERIAL NOT NULL,
email_address VARCHAR(255),
reason TEXT,
status INTEGER,
notes TEXT,
origin VARCHAR(255),
site_id INTEGER,
created_at DATETIME NOT NULL,
updated_at DATETIME NOT NULL,
PRIMARY KEY (id)
)
]
(Background on this error at: http://sqlalche.me/e/f405)