[symfony-users] tinyMCE jQuery + symfony 1.4
Hi! I've got some problems to make the tinyMCE jQuery works. I've installed the FormExtra plugin, edited the view YAML, and used the widget. I have a javascript error telling me that .tinyMCE is not declared and by checking the javascript I can see that it refers to the basic tinyMCE javascript but not to the jQuery one. The thing is then, I guess I have to extend the tinyMCE widget that is coming with FormExtra, but I have no idea how to do that. Do I have to create a new widget that extend the tinyMCE? Where do I put the new class files? I've read some stuff and I kind of understand I need to create the configure and render class, but I can't find a really good explanation in the docs. Thanks in advance! -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en
[symfony-users] Re: Unavailable and Error page - can't use helpers or else?
I would add a small question there: I have several app. I want to use the same custom 404 page for example, without copying/pasting for each app. Possible? Doesn't it make more sense to be able to define this in the global config? On Apr 22, 10:24 am, godbout guillaume.lecler...@gmail.com wrote: Hi! I'm customizing my error and unavailable page and I'm a bit surprised to see that the include_stylesheet and other helpers don't work. I want to use the same sheets that for my app. Can't I use any symfony framework functionalities in those 2 files? Thx, Cheers -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group athttp://groups.google.com/group/symfony-users?hl=en -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en
[symfony-users] Seems like Doctrine is building my filters on an old schema?
Hello Sir,
I used to have a backend module generated by the doctrine admin-gen.
I've changed the schema to replace the sf_guard_user_id in one of the
table by a user_id.
Here is the old schema:
SectionUser:
columns:
sf_guard_user_id:{ type: integer(4), notnull:
true }
section_id: { type: integer(4), notnull: true }
type: { type: enum, length: 20, values:
['TEACHER', 'STUDENT', 'OTHER'] }
relations:
Section:{ local: section_id, foreign: id, class:
Section, foreignAlias: SectionUsers, onDelete: CASCADE }
User: { local: sf_guard_user_id, foreign: id,
class: sfGuardUser, foreignAlias: SectionUsers, onDelete: CASCADE }
Here is the new one:
SectionUser:
columns:
user_id:{ type: integer(4), notnull: true }
section_id: { type: integer(4), notnull: true }
type: { type: enum, length: 20, values:
['TEACHER', 'STUDENT', 'OTHER'] }
relations:
Section:{ local: section_id, foreign: id, class:
Section, foreignAlias: SectionUsers, onDelete: CASCADE }
User: { local: user_id, foreign: id, class:
sfGuardUser, foreignAlias: SectionUsers, onDelete: CASCADE }
Migrations classes have been build and run, no pb.
However now I have problem with the sources. When I do a
doctrine:build --all-classes, here is what I find in a
BaseSectionFormFilter.class.php:
public function addUsersListColumnQuery(Doctrine_Query $query, $field,
$values)
{
if (!is_array($values))
{
$values = array($values);
}
if (!count($values))
{
return;
}
$query-leftJoin('r.SectionUser SectionUser')
-andWhereIn('SectionUser.sf_guard_user_id', $values);
}
Of course the reference to sf_guard_user_id crashes, it should be
user_id.
I've tried any cc, clean-model-files, etc... but without success. Any
idea?
Thx in advance,
Guill
--
If you want to report a vulnerability issue on symfony, please send it to
security at symfony-project.com
You received this message because you are subscribed to the Google
Groups symfony users group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
[symfony-users] Re: Seems like Doctrine is building my filters on an old schema?
Ok, found a way to correct that.
I've added the local and foreign id in the many-to-many relationships.
I've got an old table where I haven't updated the sf_guard_user_id to
user_id because i'm gonna drop it later, and it seems that when I
don't specify a local/foreign_id Doctrine is using this one instead of
the new user_id.
This might help some other people!
Cheers,
On Apr 27, 5:40 pm, godbout guillaume.lecler...@gmail.com wrote:
Hello Sir,
I used to have a backend module generated by the doctrine admin-gen.
I've changed the schema to replace the sf_guard_user_id in one of the
table by a user_id.
Here is the old schema:
SectionUser:
columns:
sf_guard_user_id: { type: integer(4), notnull:
true }
section_id: { type: integer(4), notnull: true }
type: { type: enum, length: 20, values:
['TEACHER', 'STUDENT', 'OTHER'] }
relations:
Section: { local: section_id, foreign: id, class:
Section, foreignAlias: SectionUsers, onDelete: CASCADE }
User: { local: sf_guard_user_id, foreign: id,
class: sfGuardUser, foreignAlias: SectionUsers, onDelete: CASCADE }
Here is the new one:
SectionUser:
columns:
user_id: { type: integer(4), notnull: true }
section_id: { type: integer(4), notnull: true }
type: { type: enum, length: 20, values:
['TEACHER', 'STUDENT', 'OTHER'] }
relations:
Section: { local: section_id, foreign: id, class:
Section, foreignAlias: SectionUsers, onDelete: CASCADE }
User: { local: user_id, foreign: id, class:
sfGuardUser, foreignAlias: SectionUsers, onDelete: CASCADE }
Migrations classes have been build and run, no pb.
However now I have problem with the sources. When I do a
doctrine:build --all-classes, here is what I find in a
BaseSectionFormFilter.class.php:
public function addUsersListColumnQuery(Doctrine_Query $query, $field,
$values)
{
if (!is_array($values))
{
$values = array($values);
}
if (!count($values))
{
return;
}
$query-leftJoin('r.SectionUser SectionUser')
-andWhereIn('SectionUser.sf_guard_user_id', $values);
}
Of course the reference to sf_guard_user_id crashes, it should be
user_id.
I've tried any cc, clean-model-files, etc... but without success. Any
idea?
Thx in advance,
Guill
--
If you want to report a vulnerability issue on symfony, please send it to
security at symfony-project.com
You received this message because you are subscribed to the Google
Groups symfony users group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group
athttp://groups.google.com/group/symfony-users?hl=en
--
If you want to report a vulnerability issue on symfony, please send it to
security at symfony-project.com
You received this message because you are subscribed to the Google
Groups symfony users group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
[symfony-users] Unavailable and Error page - can't use helpers or else?
Hi! I'm customizing my error and unavailable page and I'm a bit surprised to see that the include_stylesheet and other helpers don't work. I want to use the same sheets that for my app. Can't I use any symfony framework functionalities in those 2 files? Thx, Cheers -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en
[symfony-users] Re: Database changes
Yeah, and it looks like it's the same guy that is asking the same thing over and over... http://groups.google.com/group/symfony-users/browse_thread/thread/6f50773c4d21d00/0b0195e283f7cacb?lnk=gstq=Parijat+Kalia#0b0195e283f7cacb On Apr 22, 10:09 am, Eno symb...@gmail.com wrote: On Wed, 21 Apr 2010, Parijat Kalia wrote: The one sucky part about symfony for me is how to handle database changes. I mean, if I need to go about changing db fields, then must i loose all my existing data? I am sure there is a very easy way around this, coz if there is a long way around it, then that would be crazy as db changes happen all the time. Migrations are your friend. (If you're still using Propel, then this might be incentive to switch to Doctrine :-) http://www.doctrine-project.org/documentation/cookbook/1_0/en/symfony... This questions comes up on the list every month or two... -- -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group athttp://groups.google.com/group/symfony-users?hl=en -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en
[symfony-users] Re: sfValidatorDoctrineUnique doesn't work when only defined in BaseForm?
Sure.
// BaseSubscriberForm.class.php --
abstract class BaseSubscriberForm extends BaseFormDoctrine
{
public function setup()
{
$this-setWidgets(array(
'id' = new sfWidgetFormInputHidden(),
'email' = new sfWidgetFormInputText(),
'deleted_at' = new sfWidgetFormDateTime(),
'created_at' = new sfWidgetFormDateTime(),
'updated_at' = new sfWidgetFormDateTime(),
));
$this-setValidators(array(
'id' = new sfValidatorDoctrineChoice(array('model' =
$this-getModelName(), 'column' = 'id', 'required' = false)),
'email' = new sfValidatorString(array('max_length' =
255)),
'deleted_at' = new sfValidatorDateTime(array('required' =
false)),
'created_at' = new sfValidatorDateTime(),
'updated_at' = new sfValidatorDateTime(),
));
$this-validatorSchema-setPostValidator(
new sfValidatorDoctrineUnique(array('model' = 'Subscriber',
'column' = array('email')))
);
$this-widgetSchema-setNameFormat('subscriber[%s]');
$this-errorSchema = new sfValidatorErrorSchema($this-
validatorSchema);
$this-setupInheritance();
parent::setup();
}
public function getModelName()
{
return 'Subscriber';
}
}
// SubscriberForm.class.php --
class SubscriberForm extends BaseSubscriberForm
{
public function configure()
{
unset($this['id'], $this['deleted_at'], $this['created_at'],
$this['updated_at']);
$this-widgetSchema-setLabel('email', 'Your email');
$this-setValidators(array(
'email' = new sfValidatorEmail(array('trim' = true), array(
'required' = 'Forgot to type your email? Try again! ',
'invalid' = 'Oups, this doesn\'t look like a valid email.
Try again!'
)),
));
$this-validatorSchema-setPostValidator(
new sfValidatorDoctrineUnique(array('model' = 'Subscriber',
'column' = array('email')))
);
$this-widgetSchema-setFormFormatterName('list');
}
}
As you can see the PostValidator is the same. If I don't put it in
SubscriberForm it doesn't work.
On Apr 12, 6:52 pm, Alan Bem alan@gmail.com wrote:
Can you put somewhere code of those classes?
Alan
On Mon, Apr 12, 2010 at 5:00 AM, godbout guillaume.lecler...@gmail.comwrote:
Hi Alan,
Obviously I wasn't really awake that day...
The form is SubscriberForm (not NewsletterForm) and it extends
BaseSubscriberForm.
I had to copy/paste the code from BaseSubscriberForm to SubscriberForm
to make it work.
On Apr 11, 8:37 pm, Alan Bem alan@gmail.com wrote:
Aren't you talking about two different Forms? It seems that first
post-validator comes from (Base)SubscriberForm, but you complaint about
NewsletterForm.
Is there inheritance relationship beetween them?
Cheers
On Sat, Apr 10, 2010 at 5:05 PM, godbout guillaume.lecler...@gmail.com
wrote:
Hi there!
I have a very simple thing to do: allowing visitors to register their
email for a newsletter.
The email field is defined as unique in the db, and Doctrine created
me the BaseForm with the following code:...
[code]$this-validatorSchema-setPostValidator(
new sfValidatorDoctrineUnique(array('model' = 'Subscriber',
'column' = array('email')))
);
[/code]
...which is exactly what I want. But it didn't work until I copy/
pasted exactly the same code in my NewsletterForm.
Any explanation for that?
My NewsletterForm doesn't contain much, but it redefined the email
field validator from ValidatorString to ValidatorEmail. Would that
cause the problem? I'm still surprised.
Let me know if you have an idea ;-)
Guill
--
If you want to report a vulnerability issue on symfony, please send it
to
security at symfony-project.com
You received this message because you are subscribed to the Google
Groups symfony users group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.comsymfony-users%2bunsubscr...@goog
legroups.com
symfony-users%2bunsubscr...@goog legroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
To unsubscribe, reply using remove me as the subject.
--
If you want to report a vulnerability issue on symfony, please send it to
security at symfony-project.com
You received this message because you are subscribed to the Google
Groups symfony users group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.comsymfony-users%2bunsubscr...@goog
legroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
--
If you want to report a vulnerability issue on symfony, please send it to
security at symfony-project.com
[symfony-users] Re: sfValidatorDoctrineUnique doesn't work when only defined in BaseForm?
Hi Alan,
Obviously I wasn't really awake that day...
The form is SubscriberForm (not NewsletterForm) and it extends
BaseSubscriberForm.
I had to copy/paste the code from BaseSubscriberForm to SubscriberForm
to make it work.
On Apr 11, 8:37 pm, Alan Bem alan@gmail.com wrote:
Aren't you talking about two different Forms? It seems that first
post-validator comes from (Base)SubscriberForm, but you complaint about
NewsletterForm.
Is there inheritance relationship beetween them?
Cheers
On Sat, Apr 10, 2010 at 5:05 PM, godbout guillaume.lecler...@gmail.comwrote:
Hi there!
I have a very simple thing to do: allowing visitors to register their
email for a newsletter.
The email field is defined as unique in the db, and Doctrine created
me the BaseForm with the following code:...
[code]$this-validatorSchema-setPostValidator(
new sfValidatorDoctrineUnique(array('model' = 'Subscriber',
'column' = array('email')))
);
[/code]
...which is exactly what I want. But it didn't work until I copy/
pasted exactly the same code in my NewsletterForm.
Any explanation for that?
My NewsletterForm doesn't contain much, but it redefined the email
field validator from ValidatorString to ValidatorEmail. Would that
cause the problem? I'm still surprised.
Let me know if you have an idea ;-)
Guill
--
If you want to report a vulnerability issue on symfony, please send it to
security at symfony-project.com
You received this message because you are subscribed to the Google
Groups symfony users group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.comsymfony-users%2bunsubscr...@goog
legroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
To unsubscribe, reply using remove me as the subject.
--
If you want to report a vulnerability issue on symfony, please send it to
security at symfony-project.com
You received this message because you are subscribed to the Google
Groups symfony users group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
[symfony-users] sfValidatorDoctrineUnique doesn't work when only defined in BaseForm?
Hi there!
I have a very simple thing to do: allowing visitors to register their
email for a newsletter.
The email field is defined as unique in the db, and Doctrine created
me the BaseForm with the following code:...
[code]$this-validatorSchema-setPostValidator(
new sfValidatorDoctrineUnique(array('model' = 'Subscriber',
'column' = array('email')))
);
[/code]
...which is exactly what I want. But it didn't work until I copy/
pasted exactly the same code in my NewsletterForm.
Any explanation for that?
My NewsletterForm doesn't contain much, but it redefined the email
field validator from ValidatorString to ValidatorEmail. Would that
cause the problem? I'm still surprised.
Let me know if you have an idea ;-)
Guill
--
If you want to report a vulnerability issue on symfony, please send it to
security at symfony-project.com
You received this message because you are subscribed to the Google
Groups symfony users group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
To unsubscribe, reply using remove me as the subject.
[symfony-users] Re: Unable to use namespaces with symfony
If I'm not talking crazy, namespaces are available in symfony 2 using php 5.3. I wouldn't expect them to work in 1.4 yet. On Apr 3, 11:25 pm, Amadeus jos...@enradia.com wrote: Hi I am trying to use classes with namespaces such as Doctrine 2 or my own stuff but not matter what I use symfony gives me a Fatal Error: cannot redeclare class XYZ... Does anyone have an idea? The autoload config and cache only have one instance of the file in question. Somehow its trying to load it again. Are namespaces not possible with Symfony 1.4? -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en
[symfony-users] Re: Losing data upon creating new tables
Parijat, Follow the doc given by Tom. Then, once you understand, just remember that for creating the migration classes correctly you will have to do that in the correct order: 1 - your schema yml files and your database structure should match 2 - update the classes to match your schema yml by doing a doctrine:build --all-classes 3 - modify your schema yml files according to your needs 4 - run the task doctrine:generate-migrations-diff. This is gonna check the differences between your model files and your schema yml files and create the migration classes for you that will help you migrate the database. That is why it's important that at the beginning, your classes, your schema and your db match (happens when you do step 1 and 2) 5 - once the migration classes are generated, you can try to run the migration by doctrine:migrate 6 - if it works, update your classes to match the new schema yml files (doctrine:build --all-classes). if it doesn't, you have to correct the stuff manually (db and/or migrations classes). Update your classes ONLY if migration worked. Else, you'll not be able to generate the classes again (because your schema files and your model classes will match) Let me know if you get it. Cheers, Guill On Mar 25, 6:29 am, Tom Haskins-Vaughan t...@templestreetmedia.com wrote: http://www.symfony-project.org/doctrine/1_2/en/07-Migrations I don't know if there are any major differences for sf1.4. On Wed, Mar 24, 2010 at 4:53 PM, Parijat Kalia kaliapari...@gmail.com wrote: Migrations? I haven't yet heard of them. Does the book cover it by any chance? Please give me some pointers on where I can learn more about migrations. That would be awesome. Thanks! On Wed, Mar 24, 2010 at 11:47 AM, Eno symb...@gmail.com wrote: On Tue, 23 Mar 2010, Parijat Kalia wrote: I don't want that to happen. Is symfony trying to tell me that there is no way around this? That I absolutely must loose all my data so as to be able to add new data? OMG! That's why migrations in Doctrine rock. -- A -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en To unsubscribe from this group, send email to symfony-users+unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject. -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en To unsubscribe from this group, send email to symfony-users+unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject. -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en To unsubscribe from this group, send email to symfony-users+unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject.
[symfony-users] Re: How to use one connection for generated migration diff files
Wondering also. Seems there is no connection option from the doctrine:migrate task, looking at the help. On Mar 25, 6:44 pm, jp_morvan sacri...@free.fr wrote: Hi, I've two connections in databases.yml : all: connection1: class: sfDoctrineDatabase param: dsn: 'mysql:host=myhost;dbname=dbname1;' username: username password: pwd connection2: class: sfDoctrineDatabase param: dsn: 'mysql:host=myhost;dbname=dbname2;' username: username password: pwd I've changed some stuff in schema.yml (add foreign key on one table from connection2 to another table from connection 1). If I build all, there is no problem, relation is good. But I don't want to. I used symfony doctrine:generate-migrations-diff. So, I've now 2 generated migrations files. But I don't find where I can say that this migration action have to use connection1 and this other action have to use connection2. Have you an idea ? -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en To unsubscribe from this group, send email to symfony-users+unsubscribegooglegroups.com or reply to this email with the words REMOVE ME as the subject.
[symfony-users] Re: symfony and doctrine migrations - who to believe?
Got it.
Actually it's not correctly explained in the slides, maybe because
it's quite new?
Anyway here is how it works:
- generate-migrations-db: creates the migration files from the
beginning. So useless if you don't want to drop and re-create the db.
- generate-migrations-models: same thing, but from the models
- generate-migrations-diff: make the diff between the models and the
schema yml files. So as Florian explained, be careful to not build the
models before doing the diff.
But there's the other solution I was looking for: make your own task
with Doctrine_Core::generateMigrationsFromDiff like this:
- Doctrine_Core::generateMigrationsFromDiff('/path/to/migration/
classes', 'doctrine_db_connection_name', '/path/to/schema.yml');
Then the migrations classes will be created, even if your models and
schema are the same, as long as the db is different from the schema!
Guill
On Mar 5, 10:36 am, godbout guillaume.lecler...@gmail.com wrote:
Hi Florian!
Thx for the help.
Yah, you're right, I meant 'generate-migrations-diff'. Was a bit tired
from the day probably :-p
Yah, also I got the flow. Actually I think I've found why it didn't
work, there's an error in the yml file (found when I've tried to build
the classes anyway).
But it still very blur on the generate-migrations-db and generate-
migrations-models. Is there any comparison made between the db and the
yml? Or it is just taking db, or the model, and produce a pile of file
that just helps you to re-create the db?
Guill
On Mar 5, 4:39 am, Florian sideral.undergro...@gmail.com wrote:
hi,
you surely wanted to say 'generate-migrations-diff' in your third
try ?
The doctrine:generate-migrations-diff task calculates the difference
between your model classes and the yml schema.
So when you want to modify your model, do this in *this exact order* :
- make sure your model is up to date before modifying your schema by
calling: php symfony doctrine:build --all-classes --sql
- modify your schema.yml with whatever you want
- run php symfony doctrine:generate-migrations-diff
- look at your lib/migration/doctrine folder if everything gone fine
If you build your model before calling doctrine:generate-migrations-
diff, doctrine won't know what has changed and will do nothing.
Hope it helps!
Florian
On 4 mar, 14:38,godboutguillaume.lecler...@gmail.com wrote:
Hi guys.
I want to use the symfony tasks for the doctrine migration but I can't
find any consistent piece of information.
I read this:
-http://www.doctrine-project.org/documentation/manual/1_2/en/migrations
and this:
-http://www.symfony-project.org/reference/1_4/en/16-Tasks#chapter_16_s...
and I've watched these slides:
-http://www.slideshare.net/weaverryan/the-art-of-doctrine-migrations
and those ones:
-http://www.slideshare.net/denderello/symfony-live-2010-using-doctrine...
Sometimes it says that the generate-migrations-db will make a
comparison between the db and the schema.yml and generate the classes,
sometimes it says that it will just take the db and make the classes.
I don't see the point of the second information, but this is what
happens for me. Whatever is in the schema.yml is not taken in
consideration, and I end up with migration classes that just create
the same db that I have and not the updates from my yml files.
Same thing for generate-migrations-models. My models are the same than
the db, but not than the yml files. But whatever, the migration
classes just a copy of the model and doesn't pay attention to the yml
files.
I've tried the last one: generate-migrations-models. According to some
of the links it actually does the difference between the yml files and
the model (well, on some other links it's the definition of the
generate-migrations-models function, so I don't get it...). I can't
really see the model because it lamentably failed with a ToPrfx...
something class not found.
Anybody to lighten me up on that?
Cheers in advance,
Guill
--
If you want to report a vulnerability issue on symfony, please send it to
security at symfony-project.com
You received this message because you are subscribed to the Google
Groups symfony users group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
[symfony-users] symfony and doctrine migrations - who to believe?
Hi guys. I want to use the symfony tasks for the doctrine migration but I can't find any consistent piece of information. I read this: - http://www.doctrine-project.org/documentation/manual/1_2/en/migrations and this: - http://www.symfony-project.org/reference/1_4/en/16-Tasks#chapter_16_sub_doctrine_generate_migrations_db and I've watched these slides: - http://www.slideshare.net/weaverryan/the-art-of-doctrine-migrations and those ones: - http://www.slideshare.net/denderello/symfony-live-2010-using-doctrine-migrations Sometimes it says that the generate-migrations-db will make a comparison between the db and the schema.yml and generate the classes, sometimes it says that it will just take the db and make the classes. I don't see the point of the second information, but this is what happens for me. Whatever is in the schema.yml is not taken in consideration, and I end up with migration classes that just create the same db that I have and not the updates from my yml files. Same thing for generate-migrations-models. My models are the same than the db, but not than the yml files. But whatever, the migration classes just a copy of the model and doesn't pay attention to the yml files. I've tried the last one: generate-migrations-models. According to some of the links it actually does the difference between the yml files and the model (well, on some other links it's the definition of the generate-migrations-models function, so I don't get it...). I can't really see the model because it lamentably failed with a ToPrfx... something class not found. Anybody to lighten me up on that? Cheers in advance, Guill -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en
[symfony-users] Re: symfony and doctrine migrations - who to believe?
Hi Florian! Thx for the help. Yah, you're right, I meant 'generate-migrations-diff'. Was a bit tired from the day probably :-p Yah, also I got the flow. Actually I think I've found why it didn't work, there's an error in the yml file (found when I've tried to build the classes anyway). But it still very blur on the generate-migrations-db and generate- migrations-models. Is there any comparison made between the db and the yml? Or it is just taking db, or the model, and produce a pile of file that just helps you to re-create the db? Guill On Mar 5, 4:39 am, Florian sideral.undergro...@gmail.com wrote: hi, you surely wanted to say 'generate-migrations-diff' in your third try ? The doctrine:generate-migrations-diff task calculates the difference between your model classes and the yml schema. So when you want to modify your model, do this in *this exact order* : - make sure your model is up to date before modifying your schema by calling: php symfony doctrine:build --all-classes --sql - modify your schema.yml with whatever you want - run php symfony doctrine:generate-migrations-diff - look at your lib/migration/doctrine folder if everything gone fine If you build your model before calling doctrine:generate-migrations- diff, doctrine won't know what has changed and will do nothing. Hope it helps! Florian On 4 mar, 14:38, godbout guillaume.lecler...@gmail.com wrote: Hi guys. I want to use the symfony tasks for the doctrine migration but I can't find any consistent piece of information. I read this: -http://www.doctrine-project.org/documentation/manual/1_2/en/migrations and this: -http://www.symfony-project.org/reference/1_4/en/16-Tasks#chapter_16_s... and I've watched these slides: -http://www.slideshare.net/weaverryan/the-art-of-doctrine-migrations and those ones: -http://www.slideshare.net/denderello/symfony-live-2010-using-doctrine... Sometimes it says that the generate-migrations-db will make a comparison between the db and the schema.yml and generate the classes, sometimes it says that it will just take the db and make the classes. I don't see the point of the second information, but this is what happens for me. Whatever is in the schema.yml is not taken in consideration, and I end up with migration classes that just create the same db that I have and not the updates from my yml files. Same thing for generate-migrations-models. My models are the same than the db, but not than the yml files. But whatever, the migration classes just a copy of the model and doesn't pay attention to the yml files. I've tried the last one: generate-migrations-models. According to some of the links it actually does the difference between the yml files and the model (well, on some other links it's the definition of the generate-migrations-models function, so I don't get it...). I can't really see the model because it lamentably failed with a ToPrfx... something class not found. Anybody to lighten me up on that? Cheers in advance, Guill -- If you want to report a vulnerability issue on symfony, please send it to security at symfony-project.com You received this message because you are subscribed to the Google Groups symfony users group. To post to this group, send email to symfony-users@googlegroups.com To unsubscribe from this group, send email to symfony-users+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en
[symfony-users] doctrine + admin-gen + customize filter + inner join = every table must have its own alias
Hi there!
I'm using symfony 1.2 with doctrine.
I'm having trouble trying to customize a filter done by the admin-
gen.
I added a sfWidgetFormDoctrineChoice, this works greats. Keys and
values are ok.
Then I added to my form filter class a getFields method, and a
addCodeColumnQuery method.
My code field comes from another table and I need a inner join to get
that.
So finally in my addCodeColumnQuery, I add what I need to complete the
query:
Here's the code:
---
$alias = $query-getRootAlias();
$query-innerJoin($alias .'.TplProgram T')-addWhere('T.code = ?',
$values);
---
The sql created by symfony end up being:
---
SELECT COUNT(*) AS num_results FROM (SELECT p.id FROM program_year p
INNER JOIN tpl_program t ON p.tpl_program_id = t.id WHERE t.code = ?
GROUP BY p.id)
---
and that's where the problem is. Mysql refuse to take it as long as I
don't have a 'AS XXX' at the end of the query.
How can I add that using the Doctrine_Query type?
Thx a lot in advance!
Guill
--
You received this message because you are subscribed to the Google Groups
symfony users group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en.
[symfony-users] Re: doctrine + admin-gen + customize filter + inner join = every table must have its own alias
My mistake. The sql query actually works. There is no 'AS' explicitly
written, it's the first time I see a query working like this. But it
does, I just didn't copy it correctly. The problem was something else
and it's resolved.
Thx
On Jan 20, 4:10 pm, godbout guillaume.lecler...@gmail.com wrote:
Hi there!
I'm using symfony 1.2 with doctrine.
I'm having trouble trying to customize a filter done by the admin-
gen.
I added a sfWidgetFormDoctrineChoice, this works greats. Keys and
values are ok.
Then I added to my form filter class a getFields method, and a
addCodeColumnQuery method.
My code field comes from another table and I need a inner join to get
that.
So finally in my addCodeColumnQuery, I add what I need to complete the
query:
Here's the code:
---
$alias = $query-getRootAlias();
$query-innerJoin($alias .'.TplProgram T')-addWhere('T.code = ?',
$values);
---
The sql created by symfony end up being:
---
SELECT COUNT(*) AS num_results FROM (SELECT p.id FROM program_year p
INNER JOIN tpl_program t ON p.tpl_program_id = t.id WHERE t.code = ?
GROUP BY p.id)
---
and that's where the problem is. Mysql refuse to take it as long as I
don't have a 'AS XXX' at the end of the query.
How can I add that using the Doctrine_Query type?
Thx a lot in advance!
Guill
--
You received this message because you are subscribed to the Google Groups
symfony users group.
To post to this group, send email to symfony-us...@googlegroups.com.
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en.
[symfony-users] Jobeet day 7 - can't see how the code can give those screenshots
Hi there!
I've got a problem on day 7 that brings me errors on later days when I
run the tests.
I try to explain:
As long as we sort the jobs by 'expires_at DESC', I understand that
the job in 'Sensio Labs' appear first (even if in my case it is not
followed by company 100 but company 114 instead...). But then, how can
this work when, after refactoring, we sort by 'created_at DESC'?
Is it a typing mistake or there is some magic that I don't understand
here?
Thanks in advance!
[code]
public function addActiveJobsQuery(Doctrine_Query $q = null)
{
if (is_null($q))
{
$q = Doctrine_Query::create()
-from('JobeetJob j');
}
$alias = $q-getRootAlias();
$q-andWhere($alias . '.expires_at ?', date('Y-m-d H:i:s', time
()))
-addOrderBy($alias . '.created_at DESC');
return $q;
}
[/code]
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
symfony users group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
-~--~~~~--~~--~--~---
