return self.select("context LIKE '%s'" % pattern, orderBy="context")
else:
return self.select(orderBy="context")
search = classmethod(search)
def allAttrs(self):
attrs = {}
attrs['context'] = self.context
attrs['value'] = self.value
return attrs
# upgrade "setting" table
# which is the actual version
v = Version.selectBy(context='setting')
if v.count() == 1:
versionNb = v[0].versionNb
else:
versionNb = 0
Version(context='setting',versionNb=0)
# transform database to SQLObject format
if versionNb <= 0:
Setting.createTable(ifNotExists=True)
if isinstance(dbConnection,MySQLConnection):
dbConnection.query('ALTER TABLE %s.`member` TYPE = MYISAM;' % dbConnection.db)
Setting(context="site",value="office")
Setting(context="organisation",value="My Sport Club")
Setting(context="link",value="www.my_sport_club.org")
Setting(context="mailAddress",value="support@my_sport_club.org")
return None
else:
return int(s[2:])
def str2Int(s):
if (s == None) or (s == ""):
return 0
else:
return int(s)
#
# Transform and update database if required
#
# which is the actual version
v = Version.selectBy(context='member')
if v.count() == 1:
versionNb = v[0].versionNb
else:
versionNb = 0
Version(context='member',versionNb=0)
# transform database to SQLObject format
if versionNb <= 0:
Member.createTable(ifNotExists=True)
if isinstance(dbConnection,MySQLConnection):
dbConnection.query('ALTER TABLE %s.`member` TYPE = MYISAM;' % dbConnection.db)
for x in accountsmi.select():
Member(
accountNb=int(x.mitgliedsNr),
newAccountNb=neueMitgliedsNr2Int(x.neueMitgliedsNr),
SQLObject for the MiddleKit database format
'''
_connection = dbConnection
_fromDatabase = True
_idName = 'transfersId'
_style = MixedCaseStyle(longID=True)
except:
pass
#
# Transform and update database if required
#
# which is the actual version
v = Version.selectBy(context='transfer')
if v.count() == 1:
versionNb = v[0].versionNb
else:
versionNb = 0
Version(context='transfer',versionNb=0)
# transform database to SQLObject format
if versionNb <= 0:
Transfer.createTable(ifNotExists=True)
if isinstance(dbConnection,MySQLConnection):
dbConnection.query('ALTER TABLE %s.`transfer` TYPE = MYISAM;' % dbConnection.db)
for x in transfers.select():
Transfer(
bookingId=x.tAID,
transferId=x.transferID,
SQLObject for the MiddleKit database format
'''
_connection = dbConnection
_fromDatabase = True
_idName = 'pricesId'
_style = MixedCaseStyle(longID=True)
except:
pass
#
# Transform and update database if required
#
# which is the actual version
v = Version.selectBy(context='price')
if v.count() == 1:
versionNb = v[0].versionNb
else:
versionNb = 1
Version(context='price',versionNb=0)
# transform database to SQLObject format
if versionNb <= 0:
Price.createTable(ifNotExists=True)
if isinstance(dbConnection,MySQLConnection):
dbConnection.query('ALTER TABLE %s.`price` TYPE = MYISAM;' % dbConnection.db)
for x in prices.select():
Price(
transferCode=x.bKZ,
debit=x.soll,
SQLObject for the MiddleKit database format
'''
_connection = dbConnection
_fromDatabase = True
_idName = 'bLZId'
_style = MixedCaseStyle(longID=True)
except:
pass
#
# Transform and update database if required
#
# which is the actual version
v = Version.selectBy(context='bankcode')
if v.count() == 1:
versionNb = v[0].versionNb
else:
versionNb = 0
Version(context='bankcode',versionNb=0)
# transform database to SQLObject format
if versionNb <= 0:
BankCode.createTable(ifNotExists=True)
if isinstance(dbConnection,MySQLConnection):
dbConnection.query('ALTER TABLE %s.`bank_code` TYPE = MYISAM;' % dbConnection.db)
for x in blz.select():
BankCode(
bankName=x.bank,
bankCode=x.bLZ,
