Something about OOP

[Anubhav]

Hey guyz,

After searching and researching about OOP in 1.4, I found the function list of OOP ( server ).

I wanted to make my scripts easier but I din't understood how to use some functions.

THESE are they -

create (function: dbConnect)

exec (function: dbExec)

query (function: dbQuery)

please help

[Anubhav]

Any help? Please help me guyz! Don't be lazy to answer, I realy want to know how to use this this functions!

[Saml1er]

  
local handler = Connection.create ( "sqlite", "file.db", "", "", "share=0" ) 
handler:exec(...)  
handler:query(...) 
  

[Anubhav]

Explain it to me please

[ixjf]

Read the OOP Introduction.

[Anubhav]

Thanks, I got everything!

[Blaawee]

Here is an example

connection = {} 
connection_mt = { __index = connection } 
  
local validDatabaseType = { 
    mysql = true, 
    sqlite = true 
} 
  
function connection:create( databaseType, host, username, password, options ) 
    if databaseType and type( databaseType ) ~= 'string' then 
        outputDebugString ( 'Bad argument @argument #1 Must be string. ', 0, 112, 112, 112 ); 
        return 
    end 
     
    if not validDatabaseType[ databaseType ] then 
        outputDebugString ( 'Bad argument @argument #1 Unvalid datebase type. ', 0, 112, 112, 112 ); 
        return 
    end 
     
    if databaseType == 'sqlite' then 
        username = ''; 
        password = ''; 
    else 
        username = username; 
        password = password; 
    end 
     
    local connet =  
    {  
        type = databaseType, 
        host = host, 
        username = username, 
        password = password, 
        options = options or '', 
        connection = dbConnect( databaseType, host, username, password, options ) 
    }; 
     
    setmetatable( connet, connection_mt ); 
    return connet; 
end 
  
  
function connection:exec( query, ... ) 
    if query and type( query ) == 'string' then  
        return dbExec( self.connection, query, ... ); 
    end 
end 

local myConnetion = connection:create( 'sqlite', 'path' ) 
myConnetion:exec( 'blablabla', blablabla )