コード例 #1
0
ファイル: gen_cryt.py プロジェクト: eugeneai/DME
def get_volume(dsn, year):
	conn=ODBC.connect(dsn=dsn, user="", password="")
	cursor=conn.cursor()
	query='select kind, V1 as mol1, V2 as mol2, Vsr as srd, Vpr as prs, VIspper as spl_per, Vper as per from "S%s$"' % year
	#print query
	cursor.execute(query)
	#print cursor.description
	#print cursor.fetchall()
	rc=ModelParameter()
	data=cursor.fetchone()
	s=0
	while data:
		(kind, mol1, mol2, srd, prs, spl_per, per)=data
		spl=spl_per - per
		kind=int(kind)
		setattr(rc, "mol1_%i" % kind, mol1)
		setattr(rc, "mol2_%i" % kind, mol2)
		setattr(rc, "srd_%i" % kind, srd)
		setattr(rc, "prs_%i" % kind, prs)
		setattr(rc, "spl_%i" % kind, spl)
		setattr(rc, "per_%i" % kind, per)
		s+=mol1+ mol2+ srd+ prs+ spl_per
		data=cursor.fetchone()
	print "Summ vol:", s
	return ModelParameter({"V":rc})
コード例 #2
0
ファイル: Forest.py プロジェクト: eugeneai/DME
	def __init__(self, dsn, regions, last_year=2050, tree_names=[], **keyargs):
		global ForestKind
		self.dsn=dsn
		self.last_year=last_year
		tree_names=FOREST_KIND
		self.regions=regions
		self.conn=ODBC.connect(dsn=dsn, user="", password="")

		ForestModel.__init__(self, tree_names, **keyargs)

		self.options["culture_kind"]=101 # i.e. Sosna
コード例 #3
0
ファイル: icODBC.py プロジェクト: XHermitOne/defis
 def connect(self):
     """
     Установить связь с БД.
     """
     self.disconnect()
     connection_string = self.getConnectionString()
     try:
         self.connection = mx_odbc.DriverConnect(connection_string)
     except:
         io_prnt.outErr(
             u'ODBC: Ошибка установления связи с БД. ConnectionString: <%s>'
             % connection_string)
     return self.connection
コード例 #4
0
ファイル: Forest.py プロジェクト: eugeneai/DME
	def __init__(self, dsn, **keyargs):
		conn=ODBC.connect(dsn=dsn, user="", password="")
		c=conn.cursor()
		c.execute("select P34, LESX from bd_les_o")
		all=c.fetchall()
		n=[]
		for (year, name) in all:
			try:
				if int(year)>0:
					n.append(int(name))
			except ValueError:
				pass
		#print n
		#n=[11252218,11252207]
		#n=[11252218]
		GISForestModel.__init__(self, dsn, n, **keyargs)
コード例 #5
0
ファイル: Forest.py プロジェクト: eugeneai/DME
	def __init__(self, dsn, year=1973, tree_names=[], **keyargs):
		global ForestKind
		self.dsn=dsn
		self.year=year
		if DEBUG<10:
			self.conn=ODBC.connect(dsn, user="", password="", clear_auto_commit=0)
			cursor=self.conn.cursor()
			cursor.execute('select Kind from "S%s$"' % year)
			fks=cursor.fetchall()
			if fks is None:
				raise ValueError, "wrong year is given (returned empty set)"
			tree_names=map(lambda (x,): int(x), fks)
		else:
			tree_names=[101,102,103,104,105,124,125]
		#tree_names=[101]
		if DEBUG:
			print "tree_names:", tree_names
		#raw_input("Connect debugger")
		ForestModel.__init__(self, tree_names, **keyargs)

		self.options["culture_kind"]=101 # i.e. Sosna
コード例 #6
0
import mx.ODBC.Windows as odbc
import dbcp # contains pp function
conn = odbc.connect("MyDSN")
curs = conn.cursor()
curs.execute("""SELECT Name, LinkText, Pageset FROM StdPage
                ORDER BY PageSet, Name""")
rows = curs.fetchall()
print "\n\nWithout rowlens:"
print dbcp.pp(curs, rows)
print "\n\nWith rowlens:"
print dbcp.pp(curs, rows, rowlens=1)
conn.close()
コード例 #7
0
import mx.ODBC.Windows as odbc

#To find out what you can use to access the database, run this command
#datasource = odbc.DataSources()

#2 possible ways to hit an access file
driv='DRIVER={Microsoft Access Driver (*.mdb)};DBQ=c:/tmp/a.mdb'
#driv2='FILEDSN=c:/tmp/a.mdb'

conn = odbc.DriverConnect(driv)
c = conn.cursor()
c.execute ("select * from the_table_name  where columna = 'fred'")

#get column names
cols= [ i[0] for i in c.description ]
print('\n\ncols=',cols)

##print '\n\n',c.fetchone()
rows = c.fetchall()
print('\n\n','length of rows: ',len(rows))

print('\n\n')
cnt = 0
for r in rows:
   cnt += 1
   print(cnt,'  ',r)
   if cnt > 10:
      break
コード例 #8
0
ファイル: cb2_7_14_sol_1.py プロジェクト: ch1huizong/study
import dtuple
import mx.ODBC.Windows as odbc
flist = ["Name", "Num", "LinkText"]
descr = dtuple.TupleDescriptor([[n] for n in flist])
conn = odbc.connect("HoldenWebSQL")  # Connect to a database
curs = conn.cursor()  # Create a cursor
sql = """SELECT %s FROM StdPage
            WHERE PageSet='Std' AND Num<25
            ORDER BY PageSet, Num""" % ", ".join(flist)
print sql
curs.execute(sql)
rows = curs.fetchall()
for row in rows:
    row = dtuple.DatabaseTuple(descr, row)
    print "Attribute: Name: %s Number: %d" % (row.Name, row.Num or 0)
    print "Subscript: Name: %s Number: %d" % (row[0], row[1] or 0)
    print "Mapping:   Name: %s Number: %d" % (row["Name"], row["Num"] or 0)
conn.close()
コード例 #9
0
ファイル: recipe-81252.py プロジェクト: jacob-carrier/code
import dtuple
import mx.ODBC.Windows as odbc

flist = ["Name", "Num", "LinkText"]

descr = dtuple.TupleDescriptor([[n] for n in flist])

conn = odbc.connect("HoldenWebSQL") # Connect to a database
curs = conn.cursor()                # Create a cursor

sql = """SELECT %s FROM StdPage
            WHERE PageSet='Std' AND Num<25
            ORDER BY PageSet, Num""" % ", ".join(flist)
print sql
curs.execute(sql)
rows = curs.fetchall()

for row in rows:
    row = dtuple.DatabaseTuple(descr, row)
    print "Attribute: Name: %s Number: %d" % (row.Name, row.Num or 0)
    print "Subscript: Name: %s Number: %d" % (row[0], row[1] or 0)
    print "Mapping:   Name: %s Number: %d" % (row["Name"], row["Num"] or 0)

conn.close()
コード例 #10
0
import mx.ODBC.Windows as odbc
import dbcp  # contains pp function
conn = odbc.connect("MyDSN")
curs = conn.cursor()
curs.execute("""SELECT Name, LinkText, Pageset FROM StdPage
                ORDER BY PageSet, Name""")
rows = curs.fetchall()
print "\n\nWithout rowlens:"
print dbcp.pp(curs, rows)
print "\n\nWith rowlens:"
print dbcp.pp(curs, rows, rowlens=1)
conn.close()
コード例 #11
0
ファイル: odbc_dbd.py プロジェクト: MaxTyutyunnikov/lino
	def __init__(self,dsn,isTemporary=False):
		#self.dbapi = sqlite
		self._dbconn = odbc.connect(dsn)
		self._isTemporary = isTemporary
		self._dsn = dsn
コード例 #12
0
 def __init__(self, dsn, isTemporary=False):
     #self.dbapi = sqlite
     self._dbconn = odbc.connect(dsn)
     self._isTemporary = isTemporary
     self._dsn = dsn