- Development - lists.drupal.org

Re: [development] new dev q: are mysql queries possible within drupal?
by Alfonso Montero López 24 Nov '09

24 Nov '09

2009/11/19 <development-request(a)drupal.org>: >>> Thanks to everyone that replied. >>> >>> >>> To summarise then: >>> >>> 1) I need to make a custom module. >>> 2) The module should have a block for displaying the query and a menu >>> hook >>> 3) I can add the module to either primary links or navigation as a menu >>> item >>> 4) Rendered HTML using mysql commands is quite straight forward >>> 5) The tables being queried are easier to access within the main drupal >>> d/b but i can use a different db >>> >>> Regarding a different db, does this command: >>> >>> db_set_active('customerdb'); >>> >>> make *all* db queries go through customerdb or just the ones for my >>> module? >>> ie will drupal have any issues accessing the data it needs from say >>> "drupaldb" if I dont change >>> the active db back again? >>> Maybe Table Wizard (http://drupal.org/project/tw) module can help you to do it, also. In the docs there's info about querying external db's. Then you will be able to views-enable any table and from this on, you can do all sort of things, if I understood you well. HTH. Regards, -- Alfonso.

1 0

problem with db_rewrite_sql
by Lluís 24 Nov '09

24 Nov '09

I am using group by module, and db_rewrite_sql is giving me problems because it cause rows to be selected twice and SUM reports double their value. After doing some research I have found that if I change: function node_db_rewrite_sql($query, $primary_table, $primary_field) { if ($primary_field == 'nid' && !node_access_view_all_nodes()) { $return['join'] = _node_access_join_sql($primary_table); $return['where'] = _node_access_where_sql(); $return['distinct'] = 1; return $return; } } to: function node_db_rewrite_sql($query, $primary_table, $primary_field) { if ($primary_field == 'nid' && !node_access_view_all_nodes()) { if (($where=_node_access_where_sql('view','new_na'))!='') { $return['where'] = "".$primary_table.".".$primary_field." IN (SELECT new_na.nid FROM {node_access} new_na WHERE ".$where.")"; return $return; } } } everything works as expected. Is there any reason why using "INNER JOIN" is better than using " WHERE nid IN (SELECT ... FROM {node_access} ... )"? -- *Les normes hi són perquè hi pensis abans de saltar-te-les *La vida és com una taronja, què esperes a exprimir-la? *Si creus que l'educació és cara, prova la ignorància. *La vida és com una moneda, la pots gastar en el que vulguis però només una vegada. *Abans d'imprimir aquest missatge, pensa en el medi ambient.

4 5

new features in D6 core?
by Andrew Schulman 24 Nov '09

24 Nov '09

Are new features still being considered for Drupal 6 core? I've coded a new "Set language" option for the bulk node update form at admin/content/node. I filed an issue report with a patch and screenshot, at http://drupal.org/node/609262 . But from my reading of other issue reports, it seems that the 6.x API is considered to be frozen at this point. If I understand correctly, that would rule out including my patch, which adds some hooks to the locale module. Can someone please tell me if this is true, or even better, point me to a definitive statement? Thanks, Andrew.

33 59

Doing hook_update_N() when module is installed
by Randy Fay 23 Nov '09

23 Nov '09

I'm doing a module for infrastructure which is all about applying configuration updates, and it does only configuration, nothing else. I'd like to create hook_update_N() functions, but I'd also like all of them to be run when the module is installed. Is there any "correct" way to do this? Many modules implement the functionality in both hook_install and hook_update_N, and that's fine for database-only issues, which is what these were built around (like schema changes). But it doesnt' really make sense for site config changes. Obviously, I can run the hook functions from hook_install(), in direct or indirect ways. Suggestions? Thanks, -Randy -- Randy Fay Drupal Development, troubleshooting, and debugging randy(a)randyfay.com +1 970.462.7450

8 13

creating a new usermanagement things
by Kees Scherpenhuijzen 23 Nov '09

23 Nov '09

Hey all, When using drupal for a site where users can register themself for a event; what is the best way to store the data when you have different modules to manipulate them? By manipulating i mean: - Managing some fields like if the person have payed. - Managing multiple users to assign them to groups - Just show lists of users - Printing lists of each user data I'm right now looking a the module profile which is provided by drupal it self. but is see it is data stored in a separate table. Is it then the best way to create code which uses the "API" from profile? Is there anyone who has more experience with this? TIA, -- Kees

3 2

Creative querying
by Brian Vuyk 23 Nov '09

23 Nov '09

Hello all. I am trying to write a MySQL query for users and roles, and could use a little help along. Basically, I need to compile a list of users who have certain roles. On this site, users can have 4-5 roles which represent ascending privilege levels, and we need to find the highest privilege level a user can get. The problem is, the highest privilege level in terms of functionality isn't the highest numerically by role id. In essence, as output, I am trying to get results that show a user id in one column, and rid 6 if they have it, otherwise rid 8, otherwise rid 5, otherwise 7, otherwise 4. Edit: As I was typing this, I thought of another thing to try, and it seems to have worked: SELECT DISTINCT u.uid, ur.rid FROM {users} u RIGHT JOIN {users_roles} ur ON ur.uid = u.uid WHERE rid = 6 OR rid = 8 OR rid = 5 OR rid = 7 OR rid = 4 GROUP BY uid; This depends on MySQL's query evaluation to stop on the first match from the OR'd conditions that apply. Without the GROUP BY condition, this still returns a list of all uid / rid combinations... Since this email was already written, I thought I would send it along with the solution I have both so that: 1. If anyone else is trying to do something similar, they can see what I did. 2. It goes into the list archives for the same reason as #1. Brian

7 11

Drupal way of doing onchange
by Jeff Greenberg 23 Nov '09

23 Nov '09

Haven't delved into AHAH yet, this might force the issue. Using an easy (=less typing) example. A credit card form. When the credit card type is selected from a select, the selection needs to fire a javascript function that will disable fields that don't apply to that card type (such as CVV). Normally, I would have an onchange event for the select, and noticed that in the form api, while there is an attribute section to add miscellaneous attributes, the doc doesn't mention events as examples. And if putting an event there is legitimate, there isn't a mention of how to include the responding js function in the form. If AHAH is the way I'm supposed to handle this, I'd appreciate being pointed to a good similar example, because I'm a bit unclear from the AHAH entries in the form reference docs, for example, how to relate the myhandler/js entry to a physical location of the function, and how the function gets there. Thanks!

7 15

Drupal, SimpleTest and Continuous Integration
by Yannick Warnier 22 Nov '09

22 Nov '09

Hi there, I'm the lead developer of a GPL e-learning system called Dokeos, and occasional contributor to the Dokeos-Drupal module [1]. A few (12) months ago, we (Dokeos team) had to choose between PHPUnit and SimpleTest to cover our system with unit tests. As the Drupal community was in the same situation at that time, only a few weeks ahead, we decided to follow and chose SimpleTest. Unit Testing is not our final goal, and we want to implement something like Xinc [2] or PHPUnderControl [3] to have Continuous Integration, as it's called (a way to check when new code introduces regressions, basically). However, both seem to support better PHPUnit (I haven't tried PHPUnderControl, but I have broken a few teeth on SimpleTest + Phing + Xinc already, mainly because of conflicting versions of SimpleTest and complexity of the configuration files for Xinc). To get to the point, I would like to know if anybody has already configured that type of combination in the context of Drupal and would be so kind as to give me a link to some kind of report, examples or plain documentation about this. In any case, I will be looking at the problem myself (so far it's been only team members) and report here if it works, so it can be used with Drupal too (but the question is more like if Drupal has a few weeks in advance on our investigation there as well). Cheers, Yannick [1] http://drupal.org/project/Dokeos [2] http://code.google.com/p/xinc/ (LGPL) [3] http://www.phpundercontrol.org/about.html (not OSI license)

2 1

Possible to create nodereference field in Form API?
by Steve Edwards 20 Nov '09

20 Nov '09

I'm creating a form via Forms API in a module, and I need to create a nodereference field. Is there a way to do that, or can nodereference only be used as part of a CCK form? Thanks. Steve

1 0

FW: Unsubscribing
by Kipper Timmins 20 Nov '09

20 Nov '09

Dear list, How do I unsubscribe to the development emails? Regards Kevin

2 1