예제 #1
0
def main():
        global conn

        # Connect to a database
        # Set an optional parameter "use_std_interface" to "True"
        conn = python_ncbi_dbapi.connect('ftds', 'MSSQL', 'MS_DEV1', 'DBAPI_Sample', 'DBAPI_test', 'allowed', True)

        CreateSchema()

        CreateSaleStat()

        GetSaleStat()
예제 #2
0
def main():
    global conn

    # Connect to a database
    # Set an optional parameter "use_std_interface" to "True"
    conn = python_ncbi_dbapi.connect('ftds', 'MSSQL', 'MSDEV1', 'DBAPI_Sample',
                                     'DBAPI_test', 'allowed', True)

    CreateSchema()

    CreateSaleStat()

    GetSaleStat()
예제 #3
0
def main():
    global conn

    # Connect to a database
    # Set an optional parameter "use_std_interface" to "True"
    conn = python_ncbi_dbapi.connect("ftds", "MSSQL", "MS_DEV1", "DBAPI_Sample", "DBAPI_test", "allowed", True)

    CreateSchema()

    CreateCustomers()

    GetCustomers()

    # Delete the customer, and all her orders.
    DeleteCustomers()
예제 #4
0
def main():
        global conn

        # Connect to a database
        # Set an optional parameter "use_std_interface" to "True"
        conn = python_ncbi_dbapi.connect('ftds', 'MSSQL', 'MSDEV1', 'DBAPI_Sample', 'DBAPI_test', 'allowed', True)

        CreateSchema()

        CreateCustomers()

        GetCustomers()

        # Delete the customer, and all her orders.
        DeleteCustomers()
예제 #5
0
def main():
    global conn

    # Connect to a database
    # Set an optional parameter "use_std_interface" to "True"
    conn = python_ncbi_dbapi.connect('ftds', 'MSSQL', 'MSDEV1', 'DBAPI_Sample',
                                     'DBAPI_test', 'allowed', True)

    CreateSchema()

    CreateCustomers()

    GetCustomers()

    # Delete the customer, and all her orders.
    DeleteCustomers()
예제 #6
0
#
# Author: Sergey Sikorskiy
#
# Description: a basic NCBI DBAPI Python extension module usage pattern
# (import, connect, cursor, execute, fetchone)
#
# ===========================================================================

# 1) Import NCBI DBAPI Python extension module
import python_ncbi_dbapi

# 2) Connect to a database
# Parameters: connect(driver_name, db_type, server_name, db_name, user_name, user_pswd, use_std_interface)
# driver_name: ctlib, dblib, ftds, odbc, mysql
# db_type (case insensitive): SYBASE, MSSQL, MYSQL
# server_name: database server name
# db_name: default database name
# use_std_interface: an optional parameter (default value is "False")
conn = python_ncbi_dbapi.connect('ftds', 'MSSQL', 'MS_DEV1', 'DBAPI_Sample', 'anyone', 'allowed')

# 3) Allocate a cursor
cursor = conn.cursor()

# 4) Execute a SQL statement
cursor.execute('select qq = 57 + 33')

# 5) Get a result
result = cursor.fetchone()

print result
예제 #7
0
# Author: Sergey Sikorskiy
#
# Description: a basic NCBI DBAPI Python extension module usage pattern
# (import, connect, cursor, execute, fetchone)
#
# ===========================================================================

# 1) Import NCBI DBAPI Python extension module
import python_ncbi_dbapi

# 2) Connect to a database
# Parameters: connect(driver_name, db_type, server_name, db_name, user_name, user_pswd, use_std_interface)
# driver_name: ctlib, ftds, odbc, mysql
# db_type (case insensitive): SYBASE, MSSQL, MYSQL
# server_name: database server name
# db_name: default database name
# use_std_interface: an optional parameter (default value is "False")
conn = python_ncbi_dbapi.connect('ftds', 'MSSQL', 'MSDEV1', 'DBAPI_Sample',
                                 'anyone', 'allowed')

# 3) Allocate a cursor
cursor = conn.cursor()

# 4) Execute a SQL statement
cursor.execute('select qq = 57 + 33')

# 5) Get a result
result = cursor.fetchone()

print(result)
예제 #8
0
#
# Author: Sergey Sikorskiy
#
# ===========================================================================

import os, sys, python_ncbi_dbapi

if os.environ['SYBASE'] == None :
        os.environ['SYBASE'] = "/netopt/Sybase/clients/current/"

pswd_file = open( './.dblogin', 'r' )
db_params_line = pswd_file.readline().strip()
db_params = db_params_line.split(':')
db_name = db_params[0]

conn = python_ncbi_dbapi.connect( 'ftds', 'MSSQL', db_name, db_params[1], db_params[2], db_params[3] )

cursor = conn.cursor()

if len( sys.argv ) < 2 :
        print("Please, provide Taxid")
        sys.exit( 1 )

taxid = sys.argv[1]

sql = "select * from Taxonomy where taxid = " + taxid

cursor.execute( sql )

for record in cursor.fetchall() :
        print(record)
예제 #9
0
# Description: a NCBI DBAPI Python extension module usage example
# (import, connect, cursor, execute, fetchone, fetchmany, fetchall)
#
# ===========================================================================

# 1) Import NCBI DBAPI Python extension module
import python_ncbi_dbapi

# 2) Connect to a database
# Parameters: connect(driver_name, db_type, server_name, db_name, user_name, user_pswd, use_std_interface)
# driver_name: ctlib, dblib, ftds, odbc, mysql
# db_type (case insensitive): SYBASE, MSSQL, MYSQL
# server_name: database server name
# db_name: default database name
# use_std_interface: an optional parameter (default value is "False")
conn = python_ncbi_dbapi.connect("ftds", "MSSQL", "MS_DEV1", "DBAPI_Sample", "anyone", "allowed")

# 3) Allocate a cursor
cursor = conn.cursor()

# 4) Execute a SQL statement
cursor.execute("select name, type from sysobjects")

# 5) Fetch one records from a resultset using different functions

# 5.1) Fetch one record using 'fetchone()'
print "Fetch one record using 'fetchone()'"
print cursor.fetchone()

# 5.2) Fetch one record using 'fetchmany(1)'
print "Fetch one record using 'fetchmany(1)'"
예제 #10
0
#
# Author: Sergey Sikorskiy
#
# ===========================================================================

import os, sys, python_ncbi_dbapi

if os.environ['SYBASE'] == None :
        os.environ['SYBASE'] = "/netopt/Sybase/clients/current/"

pswd_file = open( './.dblogin', 'r' )
db_params_line = pswd_file.readline().strip()
db_params = db_params_line.split(':')
db_name = db_params[0]

conn = python_ncbi_dbapi.connect( 'ftds', 'MSSQL', db_name, db_params[1], db_params[2], db_params[3] )

cursor = conn.cursor()

if len( sys.argv ) < 2 :
        print("Please, provide Taxid")
        sys.exit( 1 )

taxid = sys.argv[1]

sql = "select * from Taxonomy where taxid = " + taxid

cursor.execute( sql )

for record in cursor.fetchall() :
        print(record)