Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
  • Sep 24 16:25
    iwazaru opened #1786
  • Sep 21 17:18
    Nekool edited #1785
  • Sep 19 10:35
    Nekool opened #1785
  • Sep 16 08:14
    KDecruz synchronize #1048
  • Sep 13 08:35
    dereuromark labeled #1783
  • Sep 13 08:34

    dereuromark on master

    refactoring \Propel\Common change signatures in tests polyfill of array_key_first and 41 more (compare)

  • Sep 13 08:34
    dereuromark closed #1753
  • Sep 09 13:17

    dereuromark on master

    Update old propel arguments Merge pull request #1784 from i… (compare)

  • Sep 09 13:17
    dereuromark closed #1784
  • Sep 09 13:16

    dereuromark on master

    Refactor: split out ObjectBuild… Call parent constructor in conc… Merge pull request #1779 from n… (compare)

  • Sep 09 13:16
    dereuromark closed #1779
  • Sep 09 12:57
    yaroslav-spryker commented #1784
  • Sep 09 08:31
    dereuromark commented #1735
  • Sep 09 08:30
    dereuromark commented #1735
  • Sep 09 08:16
    dereuromark synchronize #1735
  • Sep 09 08:16

    dereuromark on integration-bc-check

    Add test for integration BC. Update ci.yml Update ci.yml (compare)

  • Sep 07 17:53
    mringler commented #1783
  • Sep 07 11:03
    codecov-commenter commented #1784
  • Sep 07 11:03
    codecov-commenter commented #1784
  • Sep 07 11:03
    codecov-commenter commented #1784
Ryan Rentfro
@SourceCode
[Propel\Generator\Exception\BuildException]
Table "contact_controls" contains a foreign key to nonexistent table "company"
This is an example of the message expected in the situation.
Ryan Rentfro
@SourceCode
PR sent
EDILSON PEREIRA DA SILVA
@EdilsonLab_gitlab
Good afternoon! I have two banks practically the same, however one needs to get data from the other's table. Is it possible with propel using the same connection? I would like that whenever I do something on a certain table, they do it on the other bank. Could someone light my way? Thanks (I use mysql)
not bank, databases
EDILSON PEREIRA DA SILVA
@EdilsonLab_gitlab
I want Join query across different Database...
J Skoba
@SpikedCola
hi all, is "collection" a reserved keyword for propel class names?
J Skoba
@SpikedCola
*reserved suffix that is. i dont seem to be able to name a class "Product" and another class "ProductCollection", it seems to conflict with propel's internal Collection class
Robert Butler
@lighth7015
So question, how do I enable debugging for pgsql?
Tuğca Eker
@tugcaeker_twitter
Hi, I'm curious about "classPrefix" feature on the generator. It seems like broken and not adding the prefix to filenames and also class names.
Is there any documentation about it? Or maybe some examples?
Mark Sch.
@dereuromark
Hey guys. We are about to finalize the PHP8 support and the upcoming alpha-12 release.
Any last topics that need to go into that? Please also help to look/review into existing PRs and tickets here.
Jazzgeir
@Jazzgeir
It's great to hear that you're working on Propel. I have bumped into several "irregularities", but didn't report them. You're not always in the "mood" for error reporting etc. ;-)
The only concrete thing I can remember right now is the name space collisions that take place between foreign keys and field/column names. I solved it by "phpRenaming" the columns in question.
Joel DeSante
@JoelDesante
Hi, Propel seems to be regenerating all the files (instead of just the BaseClasses) which results in all my work being deleted when I make schema changes. Is there some setting that I might have turned on by accident?
Nevermind, this seems to be a ID10T error
My script was deleting the entire directory, then regenerating
Daniel Rose
@daniel-rose
Hi here, is there any possibility to generate orm classes without config and database connection?
Jazzgeir
@Jazzgeir
@daniel-rose, why would you create the ORM classes without config and connection?
ygnas
@ygnas:matrix.org
[m]
PdoConnection.php line 82: SQLSTATE[HY000] [2002] Connection timed out
could someone explain me this
always get this after ~30s
that's when i try to reverse database
and db is very small
for a test
Kamrul Hasan
@k-hasan-19

Hi everyone, facing an wierd issue. My php code is as following:
$cron = new Model_Cron(); $cron->setName('Test Cron'); $cron->setScript('my script'); echo "\n\n"; echo $cron->toJSON(); $cron->save();

But I am getting following error message from the mysql server:
Uncaught Exception PropelException: "Unable to execute INSERT statement [INSERT INTO `cron` (`ID`, `NAME`, `SCRIPT`) VALUES (:p0, :p1, :p2)] [wrapped: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'id' cannot be null]" at /home/socialcrm/scrm/admin/models/socialgoo/om/Model_BaseCron.php line 825

In the DB the id is set to auto increment
it is working on another mysql cluster with same propel settings
J Skoba
@SpikedCola
Hi @k-hasan-19 , can you share your database schema.xml ?
in addition to setting auto-increment in the db, you also need to set it in schema.xml , like so:
<column name="id" phpName="Id" type="INTEGER" size="10" sqlType="int(10) unsigned" primaryKey="true" autoIncrement="true" required="true"/>
(and then run propel build of course!)
Ian Middelkamp
@ianmiddelkamp
Hello! new to this group. I have been having some trouble implementing multiple databases. I have been successfully using propel for a couple weeks with one database, but I want to add another into my models. I was able to create a secondary schema file using the reverse command, but I don't know how to set up my config file or other files that I need to change.
Ian Middelkamp
@ianmiddelkamp
Currently I have two schema files, one called schema.xml, and another quotes_schema.xml
my propel.yml, and config.php are as follows:
Ian Middelkamp
@ianmiddelkamp

##propel.yml
propel:
    database:
        connections:
            default:
                adapter: mysql
                dsn: mysql:host=localhost;port=3306;dbname=accounts
                user: office
                password: --PASSWORD--
                settings:
                    charset: utf8


###generated-conf/config.php

<?php
$serviceContainer = \Propel\Runtime\Propel::getServiceContainer();
$serviceContainer->checkVersion('2.0.0-dev');
$serviceContainer->setAdapterClass('default', 'mysql');
$manager = new \Propel\Runtime\Connection\ConnectionManagerSingle();
$manager->setConfiguration(array (
  'dsn' => 'mysql:host=localhost;port=3306;dbname=accounts',
  'user' => 'root',
  'password' => '',
  'settings' =>
  array (
    'charset' => 'utf8',
    'queries' =>
    array (
    ),
  ),
  'classname' => '\\Propel\\Runtime\\Connection\\ConnectionWrapper',
  'model_paths' =>
  array (
    0 => 'src',
    1 => 'vendor',
  ),
));
$manager->setName('default');
$serviceContainer->setConnectionManager('default', $manager);
$serviceContainer->setDefaultDatasource('default');
and the first line of my secondary schema is <database name="quotes" defaultIdMethod="native" defaultPhpNamingMethod="underscore">

using propel model:build command, i get the following error ```
In GeneratorConfig.php line 225:

Invalid database name: no configured connection named quotes. ```

J Skoba
@SpikedCola
Hey @ianmiddelkamp I think you can accomplish this by defining a quotes connection in your propel.yml file. So where you have connections: default: ... you would duplicate the default:... block, change default to quotes, and update connection params accordingly.
Then when you regenerate config.php you should have two database connections, and the models will use the appropriate connection automatically.
Ian Middelkamp
@ianmiddelkamp

@SpikedCola Thanks for getting backed to me. I have added the next connection item as per your instruction. I think the part that I am missing is the regeneration of the config.php. I found in the documentation that the command config:convert, should create the config file. When ran this command, I get the same config.php file as posted above. There is no reference to the quotes configuration. Running model:build gives the same error as above. The documentation reads 'The config:convert command reads the runtime section of the configuration file and generates the relative PHP script." So I think I am just missing a run time section for my propel.yml file. So then I added a run time section:

propel:
    database:
        connections:
            default:
                adapter: mysql
                dsn: mysql:host=localhost;port=3306;dbname=accounts
                user: office
                password: ---PASSWORD---
                settings:
                    charset: utf8
            quotes:
              adapter: mysql
              dsn: mysql:host=localhost;port=3306;dbname=quotes
              user: office
              password:  ---PASSWORD---
              settings:
                  charset: utf8
    runtime:
      defaultConnection: default


      connections:
         - default 
         - quotes

But after, running config:convert again, there still is no change to the config.php file.

My sincere thanks for your time.

Ian Middelkamp
@ianmiddelkamp
@SpikedCola I got it to work! when I was running config:convert, I was in the wrong directory. Thanks for your time!
J Skoba
@SpikedCola
@ianmiddelkamp Glad you were able to get it working!
Ian Middelkamp
@ianmiddelkamp
Have a question about doing joins across these databases now. Do I need to do two separate queries to join tables across databases? It looks like the generated classes don't have set, get, etc. functions for querying across databases.
J Skoba
@SpikedCola
@ianmiddelkamp I never figured out how to do this with propel's model classes. I ended up writing a few raw sql queries to do joins across databases. Maybe someone else has some more helpful information
Ian Middelkamp
@ianmiddelkamp
@SpikedCola Or if is not a huge sql request, get one query from one connection, then convert to array, then merge the result of the other query converted to an array.
Kublai Gomez
@kublai_gitlab
Hi, considering that Propel 2 is in alpha release level, does anybody believes that we can use it in production environments?
Joseph W
@WillRun4Cake
Could someone please test the mailing list links on the Support page with a browser NOT logged in to their Google profile? When I click on either mailing list Google says "content unavailable". Are these mailing lists meant to be publicly available?
image.png
J Skoba
@SpikedCola
@WillRun4Cake I get the same message that you are getting, not sure.
Marek Kraus
@gamelaster
Also, sandbox and xsd links are dead :-(
nederdirk
@nederdirk:matrix.org
[m]

Hi, considering that Propel 2 is in alpha release level, does anybody believes that we can use it in production environments?

at my employer we're surely using it in production, relying on our test suite and composer.lock for stability.