IronPython + Firebird .NET provider 2.0 でテーブル一覧 [DotNET]
.NET Provider のインストールパスや接続文字列は、適当に変更してくだされ
import clr
from System import Environment
fbClientFolder = Environment.GetFolderPath(
Environment.SpecialFolder.ProgramFiles)
# Append %ProgamFiles%\FirebirdClient
clr.Path.append(fbClientFolder + '\\FirebirdClient')
clr.AddReferenceToFile('FirebirdSql.Data.FirebirdClient.dll')
from FirebirdSql.Data.FirebirdClient import *
conn_string = '''
User=SYSDBA;
Password=masterkey;
Database=c:\\test.fdb;
DataSource=localhost;
Port=3050;Dialect=3;
Charset=SJIS_0208;
Role=;
Connection lifetime=0;
Connection timeout=15;
Pooling=True;
Packet Size=8192;
Server Type=0'''
def fb_tables():
sqlStmt = '''select rdb$relation_name TABLE_NAME,
rdb$owner_name TABLE_OWNER, rdb$view_source VIEW_SOURCE,
rdb$system_flag SYSTEM_FLAG
from rdb$relations where rdb$flags=1
order by rdb$relation_name'''
conn = FbConnection(conn_string)
conn.Open()
cmd = FbCommand(sqlStmt, conn)
dr = cmd.ExecuteReader()
for r in dr:
print r['TABLE_NAME'], r['TABLE_OWNER']
if __name__ == '__main__':
fb_tables()
Cialis 0 5 <a href=http://apcialisle.com/#>Buy Cialis</a> Zithromax Full Or Empty Stomach <a href=http://apcialisle.com/#>cheapest cialis 20mg</a> Priligy Avis Blog
by JanTrum (2020-03-16 19:43)
Kamagra En Sachet <a href=https://abcialisnews.com/#>Cialis</a> Calculate Dosage For Amoxicillin 400 5ml <a href=https://abcialisnews.com/#>Cialis</a> Sildenafil GСЂВ nСЂВ rique
by JanTrum (2020-04-22 02:41)
Levitra Prix Orodispersible <a href=https://abcialisnews.com/>cialis buy</a> Orlistat En Ligne <a href=https://abcialisnews.com/#>cialis 20mg price at walmart</a> Order Acticin With Overnight Delivery
by adjunny (2020-06-13 08:56)
generic cialis low price https://agenericcialise.com/ - buying cialis online usa N <a href=https://agenericcialise.com/#>buy cialis online safely</a> Tadalis Sx France
by hoacits (2020-06-24 18:16)