def setUp(self):
self.database = tempfile.mktemp()
conn = firebirdsql.create_database(
auth_plugin_name=self.auth_plugin_name,
wire_crypt=self.wire_crypt,
host=self.host,
port=self.port,
database=self.database,
user=self.user,
password=self.password,
page_size=self.page_size)
cur = conn.cursor()
cur.execute('CREATE TABLE test_table (a integer)')
cur.execute('''
CREATE TRIGGER trig_test_insert_event
FOR test_table
after insert
AS BEGIN
post_event 'event_a';
post_event 'event_b';
post_event 'event_c';
post_event 'event_a';
END''')
cur.execute('''
CREATE TRIGGER trig_test_delete_event
FOR test_table
after delete
AS BEGIN
post_event 'event_d';
END''')
conn.commit()
conn.close()
def setUp(self):
self.database=tempfile.mktemp()
conn = firebirdsql.create_database(
auth_plugin_name=self.auth_plugin_name,
wire_crypt=self.wire_crypt,
host=self.host,
port=self.port,
database=self.database,
user=self.user,
password=self.password,
page_size=self.page_size)
cur = conn.cursor()
cur.execute('CREATE TABLE test_table (a integer)')
cur.execute('''
CREATE TRIGGER trig_test_insert_event
FOR test_table
after insert
AS BEGIN
post_event 'event_a';
post_event 'event_b';
post_event 'event_c';
post_event 'event_a';
END''')
conn.commit()
conn.close()
def setUp(self):
self.database = tempfile.mktemp()
self.connection = firebirdsql.create_database(host=self.host,
port=self.port,
database=self.database,
user=self.user,
password=self.password,
page_size=self.page_size)
def _create_database(self, test_database_name, verbosity):
conn = Database.create_database(
host=self.connection.settings_dict['HOST'],
database=self.connection.settings_dict['NAME'],
user=self.connection.settings_dict['USER'],
password=self.connection.settings_dict['PASSWORD'],
page_size=self.connection.settings_dict.get('PAGE_SIZE', 32768),
)
conn.close()
def setUp(self):
self.database=tempfile.mktemp()
self.connection = firebirdsql.create_database(
host=self.host,
port=self.port,
database=self.database,
user=self.user,
password=self.password,
page_size=self.page_size)
def setUp(self):
self.database = tempfile.mktemp()
self.connection = firebirdsql.create_database(
auth_plugin_name=self.auth_plugin_name,
wire_crypt=self.wire_crypt,
host=self.host,
port=self.port,
database=self.database,
user=self.user,
password=self.password,
page_size=self.page_size)
def setUp(self):
self.database=tempfile.mktemp()
self.connection = firebirdsql.create_database(
auth_plugin_name=self.auth_plugin_name,
wire_crypt=self.wire_crypt,
host=self.host,
port=self.port,
database=self.database,
user=self.user,
password=self.password,
page_size=self.page_size)
print(msg)
if __name__ == '__main__':
if sys.platform in ('win32', 'darwin'):
fbase = os.path.abspath('.') + '/test'
else:
import tempfile
fbase = tempfile.mktemp()
TEST_HOST = 'localhost'
TEST_PORT = 3050
TEST_DATABASE = fbase + '.fdb'
TEST_DSN = TEST_HOST + '/' + str(TEST_PORT) + ':' + TEST_DATABASE
print('dsn=', TEST_DSN)
TEST_USER = '******'
TEST_PASS = '******'
conn = firebirdsql.create_database(dsn=TEST_DSN,
user=TEST_USER, password=TEST_PASS, page_size=2<<13)
conn.cursor().execute('''
CREATE TABLE foo (
a INTEGER NOT NULL,
b VARCHAR(30) NOT NULL UNIQUE,
c VARCHAR(1024),
d DECIMAL(16,3) DEFAULT -0.123,
e DATE DEFAULT '1967-08-11',
f TIMESTAMP DEFAULT '1967-08-11 23:45:01',
g TIME DEFAULT '23:45:01',
h BLOB SUB_TYPE 1,
i DOUBLE PRECISION DEFAULT 0.0,
j FLOAT DEFAULT 0.0,
PRIMARY KEY (a),
CONSTRAINT CHECK_A CHECK (a <> 0)
)
if sys.platform in ('win32', 'darwin'):
fbase = os.path.abspath('.') + '/test'
else:
import tempfile
fbase = tempfile.mktemp()
TEST_HOST = 'localhost'
TEST_PORT = 3050
TEST_DATABASE = fbase + '.fdb'
TEST_DSN = TEST_HOST + '/' + str(TEST_PORT) + ':' + TEST_DATABASE
print('dsn=', TEST_DSN)
TEST_USER = '******'
TEST_PASS = '******'
conn = firebirdsql.create_database(dsn=TEST_DSN,
user=TEST_USER,
password=TEST_PASS)
conn.cursor().execute('''
CREATE TABLE foo (
a INTEGER NOT NULL,
b VARCHAR(30) NOT NULL UNIQUE,
c VARCHAR(1024),
d DECIMAL(16,3) DEFAULT -0.123,
e DATE DEFAULT '1967-08-11',
f TIMESTAMP DEFAULT '1967-08-11 23:45:01',
g TIME DEFAULT '23:45:01',
h BLOB SUB_TYPE 0,
i DOUBLE PRECISION DEFAULT 0.0,
j FLOAT DEFAULT 0.0,
PRIMARY KEY (a),
CONSTRAINT CHECK_A CHECK (a <> 0)
def setUp(self):
self.database=tempfile.mktemp()
self.connection = firebirdsql.create_database(
host=self.host,
port=self.port,
database=self.database,
user=self.user,
password=self.password,
page_size=self.page_size)
cur = self.connection.cursor()
cur.execute('''
CREATE TABLE foo (
a INTEGER NOT NULL,
b VARCHAR(30) NOT NULL UNIQUE,
c VARCHAR(1024),
d DECIMAL(16,3) DEFAULT -0.123,
e DATE DEFAULT '1967-08-11',
f TIMESTAMP DEFAULT '1967-08-11 23:45:01',
g TIME DEFAULT '23:45:01',
h BLOB SUB_TYPE 1,
i DOUBLE PRECISION DEFAULT 0.0,
j FLOAT DEFAULT 0.0,
PRIMARY KEY (a),
CONSTRAINT CHECK_A CHECK (a <> 0)
)
''')
cur.execute('''
CREATE TABLE bar_empty (
k INTEGER NOT NULL,
abcdefghijklmnopqrstuvwxyz INTEGER
)
''')
cur.execute('''
CREATE PROCEDURE foo_proc
RETURNS (out1 INTEGER, out2 VARCHAR(30))
AS
BEGIN
out1 = 1;
out2 = 'ABC';
END
''')
cur.execute('''
CREATE PROCEDURE bar_proc (param_a INTEGER, param_b VARCHAR(30))
RETURNS (out1 INTEGER, out2 VARCHAR(30))
AS
BEGIN
out1 = param_a;
out2 = param_b;
END
''')
cur.execute('''
CREATE PROCEDURE baz_proc(param_a INTEGER)
RETURNS (out1 INTEGER, out2 VARCHAR(30))
AS
BEGIN
SELECT a, b FROM foo
WHERE a= :param_a
INTO :out1, :out2;
SUSPEND;
END
''')
self.connection.commit()
