fruit / sfcachetaggingplugin Goto Github PK

http://pecl.php.net/package/SQLite

All necessary methods done in PDO.

Create new cache sfSQLitePDOCache and test it using Symfony build-in backend driver tester

Example:

List of flights with search filter. User makes a query for flights in Riga airport, where due to weather conditions is closed whole airport. List will be empty and cache tags will be:

array('Flight' => 123456789); # collection tag

After some time, operator activates all flights in closed Airport, collection will never invalidated.

Transactions inner and outer

When Doctrine objects are deleted/updated inside the Doctrine transaction, object tags are not restored to pre-transaction start point if transaction was aborted or rollback-ed.

$conn = Doctrine_Manager::getInstance()->getCurrentConnection();
try
{
  $conn->beginTransaction();

  ArticleTable::getInstance()
    ->createQuery()
    ->delete()
    ->where('id > 0')
    ->execute();

  // all Article tags should be postponed for removal
  $conn->commit();
  // postponed tags is removed physically here
}
catch (Exception $e)
{
  $conn->rollback();
  // the postponed tags removal should be canceled
}

Transaction savepoints

Why Doctrine does not supports fully transaction savepoints explained on http://wiki.sahanafoundation.org/.
Then, it makes no sense to implement tag updates rollback/commit within savepoints.

If Cachetagging is configured before the SoftDelete behaviour then the Doctrine_Template_Listener_Cachetaggable::preDqlDelete function is not aware of the SoftDelete query addendum.

Reported by @paulkmoore

Example: Useful when you create new object with is_enabled = false, this object will temporary not display in front-end, but in back-end listing should not be cached.

ModelName:
  Cachetaggable:
    defaultValuesInNewObjectSkipsCollectionInvalidation:
      is_enabled: false
      publish_on: null

Check for bugs, problems, errors when model has NestedSet behavior with plugin's behavior Cachetaggable.

  MyModel:
    actAs:
      Cachetaggable: ~
      NestedSet: ~

Idea is to implement/use Doctrine_Cache_* classes to store correctly Doctrine_Record and Doctrine_Collection classes.

As now, it does not work like it should. Fetched objects from cache can't updated and then saved.

When cache is disabled, it is pointless to collect $tagName. Its needed tests on this issue.

#
# Class: sfCachetaggableDoctrineRecord
#
public function link ($alias, $ids, $now = false)
{
  $self = parent::link($alias, $ids, $now);

  $tagNames = $this->getTagNamesByAlias($alias, $ids);

  if ($tagNames)
  {
    sfCacheTaggingToolkit::getTaggingCache()->invalidateTags($tagNames);
  }

  return $self;
}

Add sqlite3 backend as replacement of pecl's libraries "SQLite" & "SQLite_pdo"

Main reason of this decision is to allow to other plugin users/developers to test plugin integrity by changing some peaces of code.

TODO:

• Create project inside fixtures folders to keen all tests holistic.
• Using sfTaskExtraPlugin initialize all required plugin structure and sync current plugin with new test folder organisation.
• Add notes to README how to run plugin tests

It's enough to remove record`s tag.

Same issue with DQL delete() queries.

Should return tags NOT recursively:
Doctrine_Record::getTags(false);

Should return tags recursively:
Doctrine_Record::getTags(true);
Doctrine_Record::getTags();

Equal behavior for Doctrine_Collection::getTags()

Backends to check:

• apc
• memcache
• sqlite_pdo

Also to check:

• passed keys order matches to returned key=>value order

Passing table name as string:
sfComponent::addActionCollectionTags('Article');

Passing table as Doctrine_Table instance:
sfComponent::addActionCollectionTags(ArticleTable::getInstance());

will add 1 tag:
array('Article' => 123467890);

May be add separate method setActionCollectionTags

When updating i18n-table column, does not increases object`s tag version.

There are some solutions/ideas: