def __init__(self, inst, propname, givenargs):
"""
Constructor.
@param inst: The L{DBObject} instance.
@param propname: The property name in the L{DBObject} instance that
results in this class being created.
@param givenargs: Any arguments given (through the use of a C{dict}
in the class variable in L{DBObject} rather than a string to describe
the relationship). The given args can include, for all relationships,
a C{class_name}. Depending on the relationship, C{association_foreign_key}
and C{foreign_key} might also be used.
"""
self.infl = Inflector()
self.inst = inst
self.dbconfig = Registry.getConfig()
## Set args
self.args = {
'class_name': propname,
'association_foreign_key': self.infl.foreignKey(self.infl.singularize(propname)),
'foreign_key': self.infl.foreignKey(self.inst.__class__.__name__),
'polymorphic': False
}
self.args.update(givenargs)
otherklassname = self.infl.classify(self.args['class_name'])
if not self.args['polymorphic']:
self.otherklass = Registry.getClass(otherklassname)
self.othername = self.args['association_foreign_key']
self.thisclass = self.inst.__class__
self.thisname = self.args['foreign_key']
def __init__(self, inst, propname, givenargs):
"""
Constructor.
@param inst: The L{DBObject} instance.
@param propname: The property name in the L{DBObject} instance that
results in this class being created.
@param givenargs: Any arguments given (through the use of a C{dict}
in the class variable in L{DBObject} rather than a string to describe
the relationship). The given args can include, for all relationships,
a C{class_name}. Depending on the relationship, C{association_foreign_key}
and C{foreign_key} might also be used.
"""
self.infl = Inflector()
self.inst = inst
self.dbconfig = Registry.getConfig()
## Set args
self.args = {
'class_name': propname,
'association_foreign_key': self.infl.foreignKey(self.infl.singularize(propname)),
'foreign_key': self.infl.foreignKey(self.inst.__class__.__name__),
'polymorphic': False
}
self.args.update(givenargs)
otherklassname = self.infl.classify(self.args['class_name'])
if not self.args['polymorphic']:
self.otherklass = Registry.getClass(otherklassname)
self.othername = self.args['association_foreign_key']
self.thisclass = self.inst.__class__
self.thisname = self.args['foreign_key']
def setup(cls, database):
Log.info("Initializing database")
# create the database connection pool
# sqlite requires that foreign key support be turned on with every connection
# to ensure that we have this turned on we use only one connection
Registry.DBPOOL = adbapi.ConnectionPool('sqlite3', database=database, check_same_thread=False, cp_max=1)
# register our classes with the registry
Registry.register(Record, Measurement)
def register(self):
"""Register class relationships
"""
# Application, AppInterface and AppProperty
Registry.register(Application, AppInterface, AppProperty)
# AppInterface and the concrete classes
Registry.register(Reflector, AzureIotHttps, AppInterface)
def setUp(self):
configfile = os.path.join(
os.path.dirname(inspect.getsourcefile(TestBase)), "test.conf")
config.read_config(configfile)
Registry.DBPOOL = adbapi.ConnectionPool(config.dbtype,
**config.dbparams)
Registry.register(models.Cracker, models.Report, models.Legacy)
yield database.clean_database()
main.configure_logging()
def setUp(self, config_basename="test.conf"):
configfile = os.path.join(
os.path.dirname(inspect.getsourcefile(TestBase)),
config_basename
)
config.read_config(configfile)
Registry.DBPOOL = adbapi.ConnectionPool(config.dbtype, **config.dbparams)
Registry.register(models.Cracker, models.Report, models.Legacy)
yield database.clean_database(quiet=True)
main.configure_logging()
def setupRegistry(self, passd):
user, db = self.db_data
self.logger.info("Starting MySQL DB Pool... @{0}:{1}".format(*self.db_data))
try:
Registry.register(Penguin, Igloo, Avatar, Currency, Ninja, Asset, Ban, CareItem, Friend, Request, Ignore,
Inventory, Mail, Membership, MusicTrack, Puffle, Stamp, StampCover, Coin)
Registry.register(Igloo, IglooFurniture, IglooLike)
Registry.DBPOOL = ReconnectingMySQLConnectionPool('MySQLdb', user=user, passwd=passd, db=db, cp_reconnect=True)
self.conn = True
except Exception, e:
self.logger.error("Unable to start MySQL Pool on given details. (E:{0})".format(e))
self.conn = False
def find(klass, id=None, where=None, group=None, limit=None, orderby=None):
"""
Find instances of a given class.
@param id: The integer of the C{klass} to find. For instance, C{Klass.find(1)}
will return an instance of Klass from the row with an id of 1 (unless it isn't
found, in which case C{None} is returned).
@param where: A C{list} whose first element is the string version of the
condition with question marks in place of any parameters. Further elements
of the C{list} should be the values of any parameters specified. For instance,
C{['first_name = ? AND age > ?', 'Bob', 21]}.
@param group: A C{str} describing the grouping, like C{group='first_name'}.
@param limit: An C{int} specifying the limit of the results. If this is 1,
then the return value will be either an instance of C{klass} or C{None}.
@param orderby: A C{str} describing the ordering, like C{orderby='first_name DESC'}.
@return: A C{Deferred} which returns the following to a callback:
If id is specified (or C{limit} is 1) then a single
instance of C{klass} will be returned if one is found that fits the criteria, C{None}
otherwise. If id is not specified and C{limit} is not 1, then a C{list} will
be returned with all matching results.
"""
config = Registry.getConfig()
d = config.select(klass.tablename(), id, where, group, limit, orderby)
return d.addCallback(createInstances, klass)
def find(klass, id=None, where=None, group=None, limit=None, orderby=None):
"""
Find instances of a given class.
@param id: The integer of the C{klass} to find. For instance, C{Klass.find(1)}
will return an instance of Klass from the row with an id of 1 (unless it isn't
found, in which case C{None} is returned).
@param where: A C{list} whose first element is the string version of the
condition with question marks in place of any parameters. Further elements
of the C{list} should be the values of any parameters specified. For instance,
C{['first_name = ? AND age > ?', 'Bob', 21]}.
@param group: A C{str} describing the grouping, like C{group='first_name'}.
@param limit: An C{int} specifying the limit of the results. If this is 1,
then the return value will be either an instance of C{klass} or C{None}.
@param orderby: A C{str} describing the ordering, like C{orderby='first_name DESC'}.
@return: A C{Deferred} which returns the following to a callback:
If id is specified (or C{limit} is 1) then a single
instance of C{klass} will be returned if one is found that fits the criteria, C{None}
otherwise. If id is not specified and C{limit} is not 1, then a C{list} will
be returned with all matching results.
"""
config = Registry.getConfig()
d = config.select(klass.tablename(), id, where, group, limit, orderby)
return d.addCallback(createInstances, klass)
def commit(self):
self._assertCorrectThread()
if not self._parent.is_active:
raise TransactionError("This transaction is inactive")
Registry.getConfig().txnGuard.txn = self._actual_parent
self._do_commit()
self.is_active = False
def rollback(self):
self._assertCorrectThread()
if not self._parent.is_active:
return
Registry.getConfig().txnGuard.txn = self._actual_parent
self._do_rollback()
self.is_active = False
def commit(self):
self._assertCorrectThread()
if not self._parent.is_active:
raise TransactionError("This transaction is inactive")
Registry.getConfig().txnGuard.txn = self._actual_parent
self._do_commit()
self.is_active = False
def rollback(self):
self._assertCorrectThread()
if not self._parent.is_active:
return
Registry.getConfig().txnGuard.txn = self._actual_parent
self._do_rollback()
self.is_active = False
def setUp(self):
yield initDB(self)
self.user = yield User(first_name="First", last_name="Last",
age=10).save()
self.avatar = yield Avatar(name="an avatar name",
user_id=self.user.id).save()
self.picture = yield Picture(name="a pic",
size=10,
user_id=self.user.id).save()
self.dbconfig = Registry.getConfig()
def _transaction(txn, args, kwargs):
config = Registry.getConfig()
config.txn = txn
# get the result of the functions *synchronously*, since this is in a transaction
try:
result = threads.blockingCallFromThread(reactor, interaction, txn, *args, **kwargs)
config.txn = None
return result
except Exception as e:
config.txn = None
raise TransactionError(str(e))
def _transaction(txn, args, kwargs):
config = Registry.getConfig()
config.txn = txn
# get the result of the functions *synchronously*, since this is in a transaction
try:
result = threads.blockingCallFromThread(reactor, interaction, txn, *args, **kwargs)
config.txn = None
return result
except Exception, e:
config.txn = None
raise TransactionError(str(e))
def _refresh(self, forced=False):
if self.DEBUG:
self.logger.info(
'Penguin ASync-Refresh-ing : Penguin - {}, Forced - {}'.format(
self.penguin['nickname'], forced))
if self.penguin['connectionLost']:
returnValue(0)
if self.firstTimeCall:
yield self._setupCache()
self.firstTimeCall = False
returnValue(1)
# coins update
self.penguin.penguin.coins = (yield Registry.getConfig(). \
execute("SELECT SUM(transaction) FROM coins where penguin_id = %s" % self.penguin['id']))[0][0]
if self.penguin['coins'] is None:
yield Coin(penguin_id=self.penguin['id'],
transaction=100,
comment="Player went bankrupt. "
"Giving them +100").save()
self.penguin.penguin.coins = 100
self.penguin.penguin.coins = int(self.penguin['coins'])
self.penguin.send('gtc', self.penguin['coins'])
for item in self.REFRESH_ITEMS:
if not hasattr(self.penguin.dbpenguin, item):
continue
relation = getattr(self.penguin.dbpenguin, item)
items_o = set(self.cache[item])
items_ = yield relation.get()
items_updated = set(items_)
items_added = items_updated - items_o
items_removed = items_o - items_updated
reactor.callFromThread(self.cacheHandlers[item], items_added,
items_removed, items_o)
reactor.callFromThread(self.cacheHandlers['igloos'])
GeneralEvent(
'Refresh-Cache',
self) # Refresh cache data for things other than those in here
if forced:
reactor.callFromThread(
self.RefreshManagerLoop.stop
) if self.RefreshManagerLoop.running else None
reactor.callFromThread(self.RefreshManagerLoop.start, self.REFRESH_INTERVAL, False) if \
not self.penguin['connectionLost'] else None
def test_refresh(self):
dateklass = Registry.getDBAPIClass("Date")
args = {'first_name': "a", "last_name": "b", "age": 10}
u = yield User(**args).save()
# mess up the props, then refresh
u.first_name = "something different"
u.last_name = "another thing"
yield u.refresh()
for key, value in args.items():
self.assertEqual(getattr(u, key), value)
def deleteAll(klass, where=None, transaction=None):
"""
Delete all instances of C{klass} in the database.
@param where: Conditionally delete instances. This parameter is of the same form
found in L{find}.
@return: A C{Deferred}.
"""
config = Registry.getConfig()
tablename = klass.tablename()
return config.delete(tablename, where, transaction)
def deleteAll(klass, where=None, transaction=None):
"""
Delete all instances of C{klass} in the database.
@param where: Conditionally delete instances. This parameter is of the same form
found in L{find}.
@return: A C{Deferred}.
"""
config = Registry.getConfig()
tablename = klass.tablename()
return config.delete(tablename, where, transaction)
def test_refresh(self):
dateklass = Registry.getDBAPIClass("Date")
args = {'first_name': "a", "last_name": "b", "age": 10}
u = yield User(**args).save()
# mess up the props, then refresh
u.first_name = "something different"
u.last_name = "another thing"
yield u.refresh()
for key, value in args.items():
self.assertEqual(getattr(u, key), value)
def transaction(func=None, nested=False, thread_check=True):
"""Starts a new transaction.
A Transaction object returned by this function can be used as a context manager,
which will atomatically be commited or rolledback if an exception is raised.
Transactions must only be used in db threads. This behaviour can be overriden by setting the
'thread_check' to False, allowing transactions to be started in arbitrary threads which is
useful to e.g simplify testcases.
If this function is used as decorator, the decorated function will be executed in a db thread and
gets the Transaction passed as first argument. Decorated functions are allowed to return Deferreds.
E.g:
@transaction
def someFunc(txn, param1):
# Runs in a db thread
d = someFunc(1) # will be calledback (in mainthread) when someFunc returns
You have to make sure, that you use blockingCallFromThread() or use synchronization if you need to
interact with code which runs in the mainthread. Also care has to be taken when waiting for Deferreds.
You must assure that the callbacks will be invoked from the db thread.
Per default transactions can be nested: Commiting such a "nested" transaction will simply do nothing,
but a rollback on it will rollback the outermost transaction. This allow creation of functions which will
either create a new transaction or will participate in an already ongoing tranaction which is handy for library code.
SAVEPOINT transactions can be used by either setting the 'nested' flag to true or by calling the 'nested_transaction' function.
"""
if nested and Registry.DBPOOL.dbapi.__name__ == "sqlite3":
# needs some modification on our side, see:
# http://docs.sqlalchemy.org/en/latest/dialects/sqlite.html#serializable-isolation-savepoints-transactional-ddl
raise NotImplementedError("sqlite currently not supported")
if func is None:
conn_pool = Registry.DBPOOL
cfg = Registry.getConfig()
if cfg.txnGuard.txn is None:
conn = conn_pool.connectionFactory(conn_pool)
return _RootTransaction(conn_pool, conn, thread_check=thread_check)
elif nested:
return _SavepointTransaction(cfg.txnGuard.txn,
thread_check=thread_check)
else:
return _Transaction(cfg.txnGuard.txn, thread_check=thread_check)
else:
return _transaction_dec(
func,
functools.partial(transaction,
nested=nested,
thread_check=thread_check))
def test_update(self):
dateklass = Registry.getDBAPIClass("Date")
args = {'first_name': "a", "last_name": "b", "age": 10}
u = yield User(**args).save()
args = {'first_name': "b", "last_name": "a", "age": 100}
for key, value in args.items():
setattr(u, key, value)
yield u.save()
u = yield User.find(u.id)
for key, value in args.items():
self.assertEqual(getattr(u, key), value)
def count(klass, where=None):
"""
Count instances of a given class.
@param where: An optional C{list} whose first element is the string version of the
condition with question marks in place of any parameters. Further elements
of the C{list} should be the values of any parameters specified. For instance,
C{['first_name = ? AND age > ?', 'Bob', 21]}.
@return: A C{Deferred} which returns the total number of db records to a callback.
"""
config = Registry.getConfig()
return config.count(klass.tablename(), where=where)
def count(klass, where=None):
"""
Count instances of a given class.
@param where: An optional C{list} whose first element is the string version of the
condition with question marks in place of any parameters. Further elements
of the C{list} should be the values of any parameters specified. For instance,
C{['first_name = ? AND age > ?', 'Bob', 21]}.
@return: A C{Deferred} which returns the total number of db records to a callback.
"""
config = Registry.getConfig()
return config.count(klass.tablename(), where=where)
def test_update(self):
dateklass = Registry.getDBAPIClass("Date")
args = {'first_name': "a", "last_name": "b", "age": 10}
u = yield User(**args).save()
args = {'first_name': "b", "last_name": "a", "age": 100}
for key, value in args.items():
setattr(u, key, value)
yield u.save()
u = yield User.find(u.id)
for key, value in args.items():
self.assertEqual(getattr(u, key), value)
def connect(cls, connection, *args, **kwargs):
"This is how we instantiate a DatastoreSQL object with connection"
obj = cls(connection, *args, **kwargs)
Registry.DBPOOL = adbapi.ConnectionPool(
'pyodbc',
obj.config['connection'],
autocommit=True,
cp_reconnect=True
)
obj.raw_db = Registry.DBPOOL # Accessible if we need *really* low-level access to DB.
obj.db = Registry.getConfig()
return obj
def deleteAll(klass, where=None):
"""
Delete all instances of C{klass} in the database without instantiating the records
first or invoking callbacks (L{beforeDelete} is not called). This will run a single
SQL DELETE statement in the database.
@param where: Conditionally delete instances. This parameter is of the same form
found in L{find}.
@return: A C{Deferred}.
"""
config = Registry.getConfig()
tablename = klass.tablename()
return config.delete(tablename, where)
def deleteAll(klass, where=None):
"""
Delete all instances of C{klass} in the database without instantiating the records
first or invoking callbacks (L{beforeDelete} is not called). This will run a single
SQL DELETE statement in the database.
@param where: Conditionally delete instances. This parameter is of the same form
found in L{find}.
@return: A C{Deferred}.
"""
config = Registry.getConfig()
tablename = klass.tablename()
return config.delete(tablename, where)
def sendMessage(subject, body, sender_id, receiver_id):
now = datetime.now()
Timestamp = Registry.getDBAPIClass("Timestamp")
# save message to datastore
message = Message(
subject=subject,
body=body,
sender_id=sender_id,
receiver_id=receiver_id,
sent_at=Timestamp(now.year, now.month, now.day, now.hour, now.minute, now.second)
)
message.save()
# js client is subscribed to topic with name inbox_user_<user_id> so it will publish to their list
self.publish('com.vik.inbox_user_' + str(message.receiver_id), formatMessage(message))
def transaction(func=None, nested=False, thread_check=True):
"""Starts a new transaction.
A Transaction object returned by this function can be used as a context manager,
which will atomatically be commited or rolledback if an exception is raised.
Transactions must only be used in db threads. This behaviour can be overriden by setting the
'thread_check' to False, allowing transactions to be started in arbitrary threads which is
useful to e.g simplify testcases.
If this function is used as decorator, the decorated function will be executed in a db thread and
gets the Transaction passed as first argument. Decorated functions are allowed to return Deferreds.
E.g:
@transaction
def someFunc(txn, param1):
# Runs in a db thread
d = someFunc(1) # will be calledback (in mainthread) when someFunc returns
You have to make sure, that you use blockingCallFromThread() or use synchronization if you need to
interact with code which runs in the mainthread. Also care has to be taken when waiting for Deferreds.
You must assure that the callbacks will be invoked from the db thread.
Per default transactions can be nested: Commiting such a "nested" transaction will simply do nothing,
but a rollback on it will rollback the outermost transaction. This allow creation of functions which will
either create a new transaction or will participate in an already ongoing tranaction which is handy for library code.
SAVEPOINT transactions can be used by either setting the 'nested' flag to true or by calling the 'nested_transaction' function.
"""
if nested and Registry.DBPOOL.dbapi.__name__ == "sqlite3":
# needs some modification on our side, see:
# http://docs.sqlalchemy.org/en/latest/dialects/sqlite.html#serializable-isolation-savepoints-transactional-ddl
raise NotImplementedError("sqlite currently not supported")
if func is None:
conn_pool = Registry.DBPOOL
cfg = Registry.getConfig()
if cfg.txnGuard.txn is None:
conn = conn_pool.connectionFactory(conn_pool)
return _RootTransaction(conn_pool, conn, thread_check=thread_check)
elif nested:
return _SavepointTransaction(cfg.txnGuard.txn, thread_check=thread_check)
else:
return _Transaction(cfg.txnGuard.txn, thread_check=thread_check)
else:
return _transaction_dec(func, functools.partial(transaction, nested=nested, thread_check=thread_check))
def __init__(self, **kwargs):
"""
Constructor. DO NOT OVERWRITE. Use the L{DBObject.afterInit} method.
@param kwargs: An optional dictionary containing the properties that
should be initially set for this object.
@see: L{DBObject.afterInit}
"""
self.id = None
self._deleted = False
self.errors = Errors()
self.updateAttrs(kwargs)
self._config = Registry.getConfig()
if self.__class__.RELATIONSHIP_CACHE is None:
self.__class__.initRelationshipCache()
def __init__(self, **kwargs):
"""
Constructor. DO NOT OVERWRITE. Use the L{DBObject.afterInit} method.
@param kwargs: An optional dictionary containing the properties that
should be initially set for this object.
@see: L{DBObject.afterInit}
"""
self.id = None
self._deleted = False
self.errors = Errors()
self.updateAttrs(kwargs)
self._config = Registry.getConfig()
if self.__class__.RELATIONSHIP_CACHE is None:
self.__class__.initRelationshipCache()
def test_creation(self):
# test creating blank object
u = yield User().save()
self.assertTrue(type(u.id) == int or type(u.id) == long)
# test creating object with props that don't correspond to columns
u = yield User(a_fake_column="blech").save()
self.assertTrue(type(u.id) == int or type(u.id) == long)
# Test table doesn't exist
f = FakeObject(blah = "something")
self.failUnlessFailure(f.save(), ImaginaryTableError)
dateklass = Registry.getDBAPIClass("Date")
args = {'first_name': "a", "last_name": "b", "age": 10, "dob": dateklass(2000, 1, 1)}
u = yield User(**args).save()
for key, value in args.items():
self.assertEqual(getattr(u, key), value)
def test_creation(self):
# test creating blank object
u = yield User().save()
self.assertTrue(type(u.id) == int or type(u.id) == long)
# test creating object with props that don't correspond to columns
u = yield User(a_fake_column="blech").save()
self.assertTrue(type(u.id) == int or type(u.id) == long)
# Test table doesn't exist
f = FakeObject(blah = "something")
self.failUnlessFailure(f.save(), ImaginaryTableError)
dateklass = Registry.getDBAPIClass("Date")
args = {'first_name': "a", "last_name": "b", "age": 10, "dob": dateklass(2000, 1, 1)}
u = yield User(**args).save()
for key, value in args.items():
self.assertEqual(getattr(u, key), value)
def __init__(self, parent, thread_check=True):
# Transactions must be started in db thread unless explicitely permitted
if thread_check and threading.current_thread() not in Registry.DBPOOL.threadpool.threads:
raise TransactionError("Transaction must only be started in a db pool thread")
if parent is None:
self._root = self
else:
self._root = parent._root
self._actual_parent = parent
self.is_active = True
self._threadId = threadable.getThreadID()
self._savepoint_seq = 0
if not self._parent.is_active:
raise TransactionError("Parent transaction is inactive")
Registry.getConfig().txnGuard.txn = self
def __init__(self, parent, thread_check=True):
# Transactions must be started in db thread unless explicitely permitted
if thread_check and threading.current_thread(
) not in Registry.DBPOOL.threadpool.threads:
raise TransactionError(
"Transaction must only be started in a db pool thread")
if parent is None:
self._root = self
else:
self._root = parent._root
self._actual_parent = parent
self.is_active = True
self._threadId = threadable.getThreadID()
self._savepoint_seq = 0
if not self._parent.is_active:
raise TransactionError("Parent transaction is inactive")
Registry.getConfig().txnGuard.txn = self
HABTM = [dict(name='blogposts', join_table='posts_categories')]
class FakeObject(DBObject):
pass
class Coltest(DBObject):
pass
class Transaction(DBObject):
pass
class Boy(DBObject):
HASMANY = [{'name': 'nicknames', 'as': 'nicknameable'}]
class Girl(DBObject):
HASMANY = [{'name': 'nicknames', 'as': 'nicknameable'}]
class Nickname(DBObject):
BELONGSTO = [{'name': 'nicknameable', 'polymorphic': True}]
Registry.register(Picture, User, Comment, Avatar, FakeObject, FavoriteColor)
Registry.register(Boy, Girl, Nickname)
Registry.register(Blogpost, Category)
self.intent_formula_version
}
if self.date_created:
values_dict["date_created"] = self.date_created.isoformat()
for intent_keyword in self.intent_keywords:
for field_type in KEYWORD_RECORDING_TYPES:
keyword_field_name = "{}_{}".format(intent_keyword, field_type)
values_dict[keyword_field_name] = getattr(
self, keyword_field_name)
return values_dict
Registry.register(PresenceBrowsingData, PresenceBrowsingIntentSnapshot)
@inlineCallbacks
def non_blocking_create_presence_browsing_session_data_row():
presence_browsing_session_data_row = PresenceBrowsingData()
for browsing_keyword in PRESENCE_INTENT_KEYWORDS:
setattr(presence_browsing_session_data_row,
"{}_{}".format(browsing_keyword, "clicks"), 0)
setattr(presence_browsing_session_data_row,
"{}_{}".format(browsing_keyword, "hover_time"), 0.0)
current_date_time = datetime.utcnow()
presence_browsing_session_data_row.date_created = current_date_time
presence_browsing_session_data_row.date_last_updated = current_date_time
configfile = args.config
try:
config.read_config(args.config)
except ConfigParser.NoSectionError, e:
print("Error in reading the configuration file from \"{}\": {}.".format(args.config, e))
print("Please review the configuration file. Look at the supplied denyhosts-server.conf.example for more information.")
sys.exit()
configure_logging()
peering.load_keys()
Registry.DBPOOL = adbapi.ConnectionPool(config.dbtype, **config.dbparams)
Registry.register(models.Cracker, models.Report, models.Legacy)
single_shot = False
if not args.force and (args.recreate_database
or args.evolve_database
or args.purge_legacy_addresses
or args.purge_reported_addresses
or args.recreate_database
or args.bootstrap_from_peer
or args.purge_ip is not None):
print("WARNING: do not run this method when denyhosts-server is running.")
reply = raw_input("Are you sure you want to continue (Y/N): ")
if not reply.upper().startswith('Y'):
sys.exit()
HASONE = ['avatar']
HABTM = ['favorite_colors']
class Picture(DBObject):
BELONGSTO = ['user']
class Avatar(DBObject):
pass
class FavoriteColor(DBObject):
HABTM = ['users']
class FakeObject(DBObject):
pass
class Coltest(DBObject):
pass
class Boy(DBObject):
HASMANY = [{'name': 'nicknames', 'as': 'nicknameable'}]
class Girl(DBObject):
HASMANY = [{'name': 'nicknames', 'as': 'nicknameable'}]
class Nickname(DBObject):
BELONGSTO = [{'name': 'nicknameable', 'polymorphic': True}]
Registry.register(Picture, User, Avatar, FakeObject, FavoriteColor)
Registry.register(Boy, Girl, Nickname)
def __eq__(self, other):
"""
Determine if this object is the same as another (only taking
the type of the other class and it's C{id} into account).
@param other: The other object to compare this one to.
@return: A boolean.
"""
eqclass = self.__class__.__name__ == other.__class__.__name__
eqid = hasattr(other, 'id') and self.id == other.id
return eqclass and eqid
def __neq__(self, other):
"""
Determine if this object is not the same as another (only taking
the type of the other class and it's C{id} into account).
@param other: The other object to compare this one to.
@return: A boolean.
"""
return not self == other
__repr__ = __str__
Registry.register(DBObject)
def setUp(self):
yield initDB(self)
self.user = yield User(first_name="First", last_name="Last", age=10).save()
self.avatar = yield Avatar(name="an avatar name", user_id=self.user.id).save()
self.picture = yield Picture(name="a pic", size=10, user_id=self.user.id).save()
self.dbconfig = Registry.getConfig()
return object.__getattribute__(self, name)
def __eq__(self, other):
"""
Determine if this object is the same as another (only taking
the type of the other class and it's C{id} into account).
@param other: The other object to compare this one to.
@return: A boolean.
"""
eqclass = self.__class__.__name__ == other.__class__.__name__
eqid = hasattr(other, 'id') and self.id == other.id
return eqclass and eqid
def __neq__(self, other):
"""
Determine if this object is not the same as another (only taking
the type of the other class and it's C{id} into account).
@param other: The other object to compare this one to.
@return: A boolean.
"""
return not self == other
__repr__ = __str__
Registry.register(DBObject)
def _setupCache(self):
self.penguin.penguin.recentStamps = []
database_penguin = self.penguin.dbpenguin
self.cache.avatar = yield database_penguin.avatar.get()
if self.cache.avatar is None:
self.cache.avatar = yield Avatar(
penguin_id=self.penguin['id']).save()
yield self.cache.avatar.refresh()
self.cache.inventories = yield database_penguin.inventories.get()
self.cache.assets = yield database_penguin.assets.get()
self.cache.friends = yield database_penguin.friends.get()
self.cache.requests = []
friends_data = []
for friend in self.cache.friends:
friendObj = (yield Penguin.find(where=['swid = ?', friend.friend],
limit=1))
if friendObj is None:
continue
friend.friend_id = friendObj.id
friend.onlinePresence = {'online_status': False}
data = [
int(friendObj.id), friendObj.nickname, friendObj.swid,
friend.bff
]
friends_data.append('|'.join(map(str, data)))
self.penguin.send('fl', (yield database_penguin.requests.count()),
*friends_data)
self.cache.ignores = yield database_penguin.ignores.get()
self.cache.careItems = yield database_penguin.careItems.get()
self.cache.stamps = yield database_penguin.stamps.get()
self.cache.mails = yield database_penguin.mails.get()
self.cache.bans = yield database_penguin.bans.get()
self.cache.puffles = yield database_penguin.puffles.get()
self.cache.stampCovers = yield database_penguin.stampCovers.get()
self.cache.igloos = deque()
igloos = yield database_penguin.igloos.get(limit=6)
for igloo in igloos:
iglooCache = PenguinObject()
iglooCache.igloo = igloo
iglooCache.iglooFurnitures = yield igloo.iglooFurnitures.get(
limit=99)
iglooCache.iglooLikes = yield igloo.iglooLikes.get()
self.cache.igloos.append(iglooCache)
self.cache.memberships = yield database_penguin.memberships.get()
self.cacheHandlers.inventories = self.handleInventory
self.cacheHandlers.assets = self.handleAssets
self.cacheHandlers.friends = self.handleFriends
self.cacheHandlers.requests = self.handleRequests
self.cacheHandlers.ignores = self.handleIgnores
self.cacheHandlers.careItems = self.handleCareItems
self.cacheHandlers.stamps = self.handleStamps
self.cacheHandlers.mails = self.handleMails
self.cacheHandlers.bans = self.handleBans
self.cacheHandlers.puffles = self.handlePuffles
self.cacheHandlers.stampCovers = self.handleStampCovers
self.cacheHandlers.igloos = self.handleIgloos
self.penguin.penguin.coins = (yield Registry.getConfig().\
execute("SELECT COALESCE(SUM(transaction), 0) FROM coins where penguin_id = %s" % self.penguin['id']))[0][0]
self.penguin.penguin.igloo = yield self.initPenguinIglooRoom(
self.penguin['id'])
if self.penguin['igloo']._id not in self.getIgloos():
igloo = yield database_penguin.igloos.get(
where=['id = ?', self.penguin['igloo']._id], limit=1)
iglooCache = PenguinObject()
iglooCache.igloo = igloo
iglooCache.iglooFurnitures = yield igloo.iglooFurnitures.get(
limit=99)
iglooCache.iglooLikes = yield igloo.iglooLikes.get()
self.cache.igloos.append(iglooCache)
self.penguin.penguin.currentIgloo = self.getIgloos()[
self.penguin.dbpenguin.igloo].igloo
self.setupCJMats()
membership = yield database_penguin.memberships.get(
orderby='expires desc', limit=1)
if membership is None:
#no membership records, give a free 7 day trial
trialExpiry = time.time() + 7 * 24 * 60 * 60
membership = yield \
Membership(penguin_id=self.penguin['id'],
expires=Registry.getDBAPIClass("TimestampFromTicks")(trialExpiry),
comments='Redeemed 7-day auto free trial membership. - Timeline Server').save()
self.penguin.penguin.member = MembershipHandler(
membership, self.penguin)
self.cache.avatar = yield database_penguin.avatar.get()
if self.cache.avatar is None:
self.cache.avatar = yield Avatar(
penguin_id=self.penguin['id']).save()
GeneralEvent('Setup-Cache', self)
self.CacheInitializedDefer.callback(True)
def get_polymorphic(row):
kid = getattr(row, "%s_id" % self.args['class_name'])
kname = getattr(row, "%s_type" % self.args['class_name'])
return Registry.getClass(kname).find(kid)
conn = psycopg2.connect(user=user, password=password, database=database)
cur = conn.cursor()
register_composite('label', cur, globally=True, factory=LabelComposite)
register_composite('security_attribute', cur, globally=True, factory=SecuritAttributeComposite)
cur.execute("SELECT oid FROM pg_type WHERE typname = 'timestamptz';")
timestamptz_oid = cur.fetchone()[0]
DT = psycopg2.extensions.new_type((timestamptz_oid,), "timestamptz", castDatetime)
psycopg2.extensions.register_type(DT)
conn.close()
Registry.DBPOOL = adbapi.ConnectionPool('psycopg2', user=user, password=password, database=database)
# ORM Objects
class ServiceConnection(DBObject):
HASMANY = ['SubConnections']
class SubConnection(DBObject):
BELONGSTO = ['ServiceConnection']
Registry.register(ServiceConnection, SubConnection)
def __init__(self, driver, **kwargs):
conf = {'cp_reconnect': True, 'charset': 'utf8'}
conf.update(kwargs)
Registry.DBPOOL = adbapi.ConnectionPool(driver, **conf)
self.dbconfig = Registry.getConfig()
def register_classes(*args):
Registry.register(*args)
def get_likes_count(self):
likes = yield Registry.getConfig().execute("SELECT COALESCE(SUM(likes), 0) FROM igloo_likes where "
"igloo_id = %s" % (self.id))
returnValue(likes[0][0])
globally=True,
factory=SecuritAttributeComposite)
cur.execute("SELECT oid FROM pg_type WHERE typname = 'timestamptz';")
timestamptz_oid = cur.fetchone()[0]
DT = psycopg2.extensions.new_type((timestamptz_oid, ), "timestamptz",
castDatetime)
psycopg2.extensions.register_type(DT)
conn.close()
Registry.DBPOOL = adbapi.ConnectionPool('psycopg2',
user=user,
password=password,
database=database)
# ORM Objects
class ServiceConnection(DBObject):
HASMANY = ['SubConnections']
class SubConnection(DBObject):
BELONGSTO = ['ServiceConnection']
Registry.register(ServiceConnection, SubConnection)
# -*- coding: utf-8 -*-
from twistar.dbobject import DBObject
from twistar.registry import Registry
class User(DBObject):
HASMANY = [
'media_encryption_keys',
]
class MediaEncryptionKey(DBObject):
BELONGSTO = [
'user',
]
Registry.register(User, MediaEncryptionKey)
HABTM = [dict(name='blogposts', join_table='posts_categories')]
class FakeObject(DBObject):
pass
class Coltest(DBObject):
pass
class Transaction(DBObject):
pass
class Boy(DBObject):
HASMANY = [{'name': 'nicknames', 'as': 'nicknameable'}]
class Girl(DBObject):
HASMANY = [{'name': 'nicknames', 'as': 'nicknameable'}]
class Nickname(DBObject):
BELONGSTO = [{'name': 'nicknameable', 'polymorphic': True}]
Registry.register(Picture, User, Avatar, FakeObject, FavoriteColor)
Registry.register(Boy, Girl, Nickname)
Registry.register(Blogpost, Category)
HASMANY = [{'name': 'nicknames', 'as': 'nicknameable'}]
class Nickname(DBObject):
BELONGSTO = [{'name': 'nicknameable', 'polymorphic': True}]
class Pen(DBObject):
pass
class Table(DBObject):
HABTM = ['pens']
HASMANY = ['rubbers']
class Rubber(DBObject):
pass
class Role(DBObject):
BELONGSTO = ['serviceclass']
class Serviceclass(DBObject):
HASMANY = ['roles']
BELONGSTO = ['superclass']
class Superclass(DBObject):
HASONE = ['serviceclass']
Registry.register(Picture, User, Comment, Avatar, FakeObject, FavoriteColor)
Registry.register(Boy, Girl, Nickname)
Registry.register(Blogpost, Category)
Registry.register(Pen, Table, Rubber)
Registry.register(Role, Serviceclass, Superclass)
HABTM = ['users']
class FakeObject(DBObject):
pass
class Coltest(DBObject):
pass
class Boy(DBObject):
HASMANY = [{'name': 'nicknames', 'as': 'nicknameable'}]
class Girl(DBObject):
HASMANY = [{'name': 'nicknames', 'as': 'nicknameable'}]
class Nickname(DBObject):
BELONGSTO = [{'name': 'nicknameable', 'polymorphic': True}]
class Pen(DBObject):
pass
class Table(DBObject):
HABTM = ['pens']
HASMANY = ['rubbers']
class Rubber(DBObject):
pass
Registry.register(Picture, User, Comment, Avatar, FakeObject, FavoriteColor)
Registry.register(Boy, Girl, Nickname)
Registry.register(Pen, Table, Rubber)
def cleanUndetected():
Registry.getConfig().delete("analog", where=["detected=0 AND dynamic>0"])
Registry.getConfig().delete("relay", where=["detected=0 AND dynamic>0"])
Registry.getConfig().delete("input", where=["detected=0 AND dynamic>0"])
Registry.getConfig().delete("actions", where=["detected=0 AND dynamic>0"])
Registry.getConfig().delete("output", where=["detected=0 AND dynamic>0"])
Registry.getConfig().delete("pwm", where=["detected=0 AND dynamic>0"])
pass
class Table(DBObject):
HABTM = ['pens']
HASMANY = ['rubbers']
class Rubber(DBObject):
pass
class Role(DBObject):
BELONGSTO = ['serviceclass']
class Serviceclass(DBObject):
HASMANY = ['roles']
BELONGSTO = ['superclass']
class Superclass(DBObject):
HASONE = ['serviceclass']
Registry.register(Picture, User, Comment, Avatar, FakeObject, FavoriteColor)
Registry.register(Boy, Girl, Nickname)
Registry.register(Blogpost, Category)
Registry.register(Pen, Table, Rubber)
Registry.register(Role, Serviceclass, Superclass)
def get_polymorphic(row):
kid = getattr(row, "%s_id" % self.args['class_name'])
kname = getattr(row, "%s_type" % self.args['class_name'])
return Registry.getClass(kname).find(kid)
try:
config.read_config(args.config)
except ConfigParser.NoSectionError, e:
print(
"Error in reading the configuration file from \"{}\": {}.".format(
args.config, e))
print(
"Please review the configuration file. Look at the supplied denyhosts-server.conf.example for more information."
)
sys.exit()
configure_logging()
Registry.DBPOOL = adbapi.ConnectionPool(config.dbtype, **config.dbparams)
Registry.register(models.Cracker, models.Report, models.Legacy)
single_shot = False
if not args.force and (args.recreate_database or args.evolve_database
or args.purge_legacy_addresses
or args.purge_reported_addresses
or args.recreate_database
or args.purge_ip is not None):
print(
"WARNING: do not run this method when denyhosts-server is running."
)
reply = raw_input("Are you sure you want to continue (Y/N): ")
if not reply.upper().startswith('Y'):
sys.exit()
def afterInit(self):
"""
depickle our config
"""
if hasattr(self, 'config'):
self.config = cPickle.loads(self.config)
def beforeSave(self):
self.config = cPickle.dumps(self.config)
def setConfig(self, config, subtype):
self.config = {}
for field in subtype.fields.keys():
if field in subtype.requiredFields and config.get(field, "") == "":
self.errors.add(field, "cannot be blank")
self.config[field] = config.get(field, "")
class Publisher(DBObject):
BELONGSTO = ['user', 'node']
class Message(DBObject):
BELONGSTO = ['node']
Message.validatesPresenceOf('body')
Registry.register(User, Node, Address, Subscription, Publisher, Message)
