[Gambas-user] SHELL command with python does not execute!

[Vassilis K]

I am using python because it executes the table creation commands with
the same type like in terminal mode. For example in python we write:

sql = """CREATE TABLE Aplianikis (
         aa BIGINT(20) NOT NULL auto_increment,
         Eponimia VARCHAR(40) NOT NULL,
         AFM  VARCHAR(18) NOT NULL,
         Hmerominia DATE NOT NULL,
         Checkbox TINYINT(1) NOT NULL,
         primary key(aa)
         )
         DEFAULT CHARSET=utf8
         """
         
cursor.execute(sql)

Because of this I assume that there is less possibility of errors.

Do you suggest to use the Gambas code for table and database creation?