The line: lists:usort(DefinedFields) in erlydb.erl, function get_db_fields breaks the order of return value from fields().
Afer removing usort, all tests pass. I have only tested with Postgres. Ngoc. On Jan 10 2008, 6:55 pm, "[email protected]" <[email protected]> wrote: > Hi Yariv, > > On Jan 10, 4:19 pm, "Yariv Sadan" <[email protected]> wrote: > > > I haven't actually ran this test code in a while so it could be > > broken. What DBMS are you using? > > The same error occurs with bothMySQLandPostgreSQL. The error > message that I posted came fromMySQL. I plan > to use it withPostgreSQL, though. > > > Btw, it should be quite easy to use ErlyDB without ErlyWeb. Just call > > erlydb:start() followed by erlydb:code_gen(). > > I am just getting started, so I figured I would start by running the > tests. > > Is there a complete example somewhere that I could start with > instead? > > > Yariv > > Thanks, > Jake > > > On Jan 9, 2008 4:47 AM, Jake Morrison <[email protected]> wrote: > > > > Hi, > > > > I am trying to get erlydb running outside of erlyweb. So I tried to run > > > the > > > test/erlydb/erlydb_test.erl program. It's not working, though. I had to > > > swap around the parameters on the code_gen call. So it obviously hasn't > > > been run since things changed in 0.7. > > > > After that change, it runs for a while, but fails later on. Something is > > > going wrong with the code gen, I guess, as the order of the parameters > > > is not matching up in the generated SQL. > > > > before save: {developer,true,undefined,<<"Joe Armstrong">>,<<"Sweden">>} > > > mysql_conn:426: fetch <<"BEGIN">> (id <0.41.0>) > > > mysql_conn:426: fetch <<"INSERT INTO person(type,name,country) VALUES > > > ('developer','Sweden','Joe Armstrong')">> (id <0.41.0>) > > > mysql_conn:426: fetch <<"SELECT last_insert_id()">> (id <0.41.0>) > > > mysql_conn:426: fetch <<"COMMIT">> (id < 0.41.0>) > > > > So a 'developer' is getting created like > > > developer:new(<<"Joe Armstrong">>, <<"Sweden">>) > > > But when it is inserted into the table, the name and country are reversed. > > > > The fields() are defined in developer.erl as [name, country]. > > > > Any ideas what's going wrong? > > > > Thanks, > > > Jake (Reach on freenode) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "erlyweb" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/erlyweb?hl=en -~----------~----~----~----~------~----~------~--~---
