import fdb

ruta = 'ale.fdb'

try:
    con = fdb.connect(
    dsn = ruta,
    user = 'sysdba',
    password = '*******',
    charset = 'utf-8'
    )
    print('Conectado !!')
    print('**************************************************')
except:
    print('Fallo la conexion', ruta)

# ********************************************

cx = con.cursor()
sql2 = '''
CREATE TABLE RUBY (
  Id BIGINT NOT NULL PRIMARY KEY,
  nombre VARCHAR(60) CHARACTER SET UTF8 NOT NULL,
  correo VARCHAR(60) CHARACTER SET UTF8 NOT NULL UNIQUE,
  pais VARCHAR(60) CHARACTER SET UTF8 NOT NULL,
  contra VARCHAR(60) CHARACTER SET UTF8 NOT NULL
  );

CREATE GENERATOR gen_ruby_id;
SET GENERATOR gen_ruby_id TO 0;

CREATE TRIGGER BI_RUBY_ID FOR RUBY
ACTIVE BEFORE INSERT
POSITION 0
AS
BEGIN
if (NEW.id is NULL) THEN NEW.id = GEN_ID(gen_ruby_id, 1);
END

'''


cx.execute(sql2)

con.commit()
con.close()

print('Tabla creada !!!')
input()