| chat.freenode.net #tryton log beginning Sun Mar 18 00:00:01 CET 2012 | ||
| 2012-03-18 17:50 <dhruvbaldawa> hey, are any of the devs available right now ? | ||
| 2012-03-18 17:52 <dhruvbaldawa> i have been building these Specialized Syntax to SQL Translator project since last year or so | ||
| 2012-03-18 17:52 <dhruvbaldawa> which is similar to the python-sql project | ||
| 2012-03-18 17:52 <dhruvbaldawa> so I wanted to discuss regarding it as a GSoC project | ||
| 2012-03-18 17:54 <dhruvbaldawa> A link to the page: http://dhruvb.com/blog/content/specialized-syntax-quick-sql-query-building | ||
| 2012-03-18 17:54 <cedk> dhruvbaldawa: hi | ||
| 2012-03-18 17:54 <dhruvbaldawa> cedk: hi ! | ||
| 2012-03-18 17:57 <cedk> dhruvbaldawa: do you take a look at python-sql | ||
| 2012-03-18 17:57 <dhruvbaldawa> cedk: yeah, i did | ||
| 2012-03-18 17:57 <dhruvbaldawa> i have a similar implementation used in my project | ||
| 2012-03-18 17:58 <dhruvbaldawa> like i have a object oriented inteface which my parser uses for generating SQL queries | ||
| 2012-03-18 17:58 <dhruvbaldawa> ORM to be more general | ||
| 2012-03-18 17:58 <cedk> dhruvbaldawa: we don't want ORM | ||
| 2012-03-18 17:59 <cedk> dhruvbaldawa: it is just a pythonic way to write SQL queries | ||
| 2012-03-18 17:59 <dhruvbaldawa> cedk: i know, i saw your implementation of python-sql | ||
| 2012-03-18 17:59 <cedk> dhruvbaldawa: we don't want to hide SQL | ||
| 2012-03-18 18:00 <cedk> dhruvbaldawa: so the goal of the gsoc proposal is to complete the current implementation and start to use it in trytond | ||
| 2012-03-18 18:00 <dhruvbaldawa> ok, i have been working on a similar thing as a submodule, its not a fully-functional ORM, but something that implements similar functionality | ||
| 2012-03-18 18:00 <dhruvbaldawa> just as you said, a pythonic way to generate SQL queries | ||
| 2012-03-18 18:01 <dhruvbaldawa> cedk: are you familiar with PHP ? i can show you the most basic implementation of what i was doing to initially build this project | ||
| 2012-03-18 18:01 <dhruvbaldawa> but then i shifted to Python | ||
| 2012-03-18 18:02 <dhruvbaldawa> cedk: its very similar to python-sql, but had limited functionalities | ||
| 2012-03-18 18:04 <cedk> dhruvbaldawa: ok you can show | ||
| 2012-03-18 18:05 <dhruvbaldawa> https://github.com/dhruvbaldawa/ConMS/blob/master/conms/compiler.php | ||
| 2012-03-18 18:05 <dhruvbaldawa> just see the Query_Builder class | ||
| 2012-03-18 18:05 <dhruvbaldawa> *QueryBuilder | ||
| 2012-03-18 18:06 <cedk> dhruvbaldawa: ok I see | ||
| 2012-03-18 18:06 <cedk> dhruvbaldawa: with python-sql, we want to cover all the standard SQL | ||
| 2012-03-18 18:07 <dhruvbaldawa> cedk: yeah, ok | ||
| 2012-03-18 18:07 <cedk> dhruvbaldawa: and after that, having some flavor when generating the string for specific database | ||
| 2012-03-18 18:07 <dhruvbaldawa> cedk: so, thats what i wanted to ask, what are things are required/expected ? | ||
| 2012-03-18 18:08 <dhruvbaldawa> cedk: yeah, thats of importance, so there will be a layer of abstractions to the database | ||
| 2012-03-18 18:09 <cedk> dhruvbaldawa: not a layer, python-sql must be database independent | ||
| 2012-03-18 18:09 <cedk> dhruvbaldawa: it is just went generating string that some parts could be generate differently | ||
| 2012-03-18 18:10 <dhruvbaldawa> cedk: yes, i am talking about inside python-sql, you will require an abstraction, so that you generate specific to that particular database | ||
| 2012-03-18 18:11 <dhruvbaldawa> cedk: by database i refer to say sqlite, mysql, postgresql, etc. | ||
| 2012-03-18 18:11 <cedk> https://code.google.com/p/python-sql/source/browse/sql/__init__.py#258 | ||
| 2012-03-18 18:14 <dhruvbaldawa> aah, ok | ||
| 2012-03-18 18:14 <dhruvbaldawa> i was thinking something different | ||
| 2012-03-18 18:17 <dhruvbaldawa> cedk: so what are the expectations of this project ? | ||
| 2012-03-18 18:20 <cedk> dhruvbaldawa: a full implementation with flavors for PostgreSQL, SQLite and MySQL | ||
| 2012-03-18 18:20 <cedk> dhruvbaldawa: and include it in trytond | ||
| 2012-03-18 18:20 <dhruvbaldawa> cedk: ok, sounds pretty good :-) | ||
| 2012-03-18 18:21 <dhruvbaldawa> the mailing list ? | ||
| 2012-03-18 18:21 <dhruvbaldawa> what is trytond ? | ||
| 2012-03-18 18:22 <cedk> dhruvbaldawa: trytond is the server | ||
| 2012-03-18 18:24 <dhruvbaldawa> cedk: ok, so do you want me to drop a mail to the mailing list regarding the discussion we just had ? and the project | ||
| 2012-03-18 18:24 <cedk> dhruvbaldawa: is it you who already send on the mailing list? | ||
| 2012-03-18 18:25 <dhruvbaldawa> cedk: no, thats not me :-) | ||
| 2012-03-18 18:26 <cedk> dhruvbaldawa: so yes why not. It is good to present you to the community | ||
| 2012-03-18 18:26 <dhruvbaldawa> cedk: :-) | ||
| 2012-03-18 18:30 <udono> Hi, I read a small misunderstanding here: "(2012-03-18 18:19:46) cedk: dhruvbaldawa: and include it in trytond" cedk, may you please point some link to trytond code which should include python-sql | ||
| 2012-03-18 18:30 <cedk> udono: every where there is SQL | ||
| 2012-03-18 18:33 <udono> dhruvbaldawa: hi, just to make clear, "trytond" means the code under http://hg.tryton.org/trytond , not the mailing list... | ||
| 2012-03-18 18:35 <dhruvbaldawa> udono: thanks :-) | ||
| 2012-03-18 18:38 <dhruvbaldawa> udono: cedk: where can i find some sample SQL code used in trytond ? i tried looking in the models and backend folders, but they contain query generation and some database abstraction code | ||
| 2012-03-18 18:39 <udono> dhruvbaldawa: maybe here: http://hg.tryton.org/trytond/file/4661a1c17b45/trytond/model/modelsql.py | ||
| 2012-03-18 18:40 <dhruvbaldawa> oh ok, so i need to replace that with python-sql ? is it ? | ||
| 2012-03-18 18:41 <cedk> dhruvbaldawa: yes it is the bigest place | ||
| 2012-03-18 18:43 <dhruvbaldawa> cedk: biggest ? so there are other places also ? | ||
| 2012-03-18 18:44 <dhruvbaldawa> cedk: just asking :-) | ||
| 2012-03-18 18:44 <cedk> dhruvbaldawa: yes possible, we don't have a map :-) | ||
| 2012-03-18 18:45 <dhruvbaldawa> ok | ||
| 2012-03-18 18:46 <dhruvbaldawa> i will just introduce myself with the community and drop a mail in tryton-dev | ||
| 2012-03-18 18:47 <udono> dhruvbaldawa: +1 |
Generated by irclog2html.py 2.17.3 by Marius Gedminas - find it at https://mg.pov.lt/irclog2html/!