File: dbstack.pmod

package info (click to toggle)
libroxen-logsql 1.0-6
  • links: PTS
  • area: main
  • in suites: woody
  • size: 56 kB
  • sloc: makefile: 37
file content (77 lines) | stat: -rwxr-xr-x 2,123 bytes parent folder | download | duplicates (3)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
#if constant(thread_create)
static inherit Thread.Mutex;
#define THREAD_SAFE
#define LOCK() do { object key; catch(key=lock())
#define UNLOCK() key=0; } while(0)
#else
#undef THREAD_SAFE
#define LOCK() do {
#define UNLOCK() } while(0)
#endif

class db_handler
{
#ifdef THREAD_SAFE
      static inherit Thread.Mutex;
#endif
      array (object) dbs = ({});
      string db_name, db_user, db_password, host;
      int num_dbs;  
      void create(string|void _host, string _db, int num, string|void _user,
                  string|void _password) {
         db_name = _db;
         host = _host;
         db_user = _user;
         db_password = _password;
         num_dbs=num;
         mixed err;
         for(int i = 0; i < num; i++) {
            err=catch( dbs += ({ Sql.sql(host, db_name, db_user, db_password) }));
            if(err)
               perror("Error creating db object:\n" +
                      describe_backtrace(err)+"\n");
         }
      }
       
      void|object handle(void|object d)
      {
         LOCK();
         int count;
         dbs -= ({0});
         if(objectp(d)) {
            // werror("returning a db object...\n");
            if(search(dbs, d) == -1) {
               if(sizeof(dbs)>(2*num_dbs)) {
                  werror("Dropping db because of inventory...\n");
                  destruct(d);
               }
               else {
                  dbs += ({d});
                  //werror("Handler ++ ("+sizeof(dbs)+")\n");
               }
            }
            else {
//               werror("Handler: duplicate return: \n");
            }
            //      destruct(d);
         } 

         else {
            // werror("requesting a db object...\n");
            if(!sizeof(dbs)) {
               werror("Handler: New DB created (none left).\n");
               d = Sql.sql(host, db_name, db_user, db_password);
               //d->set_timeout(60);
            } else {
               d = dbs[0];
               dbs -= ({d});
               //werror("Handler -- ("+sizeof(dbs)+")\n");
            }
         }
         UNLOCK();
         return d;
      }
}