private static PhpResource Open(string filename, int mode, PhpReference error, bool persistent) { if (persistent) { PhpException.FunctionNotSupported(PhpError.Notice); } SQLiteConnectionStringBuilder csb = new SQLiteConnectionStringBuilder(); csb.DataSource = filename; csb.Version = 3; try { PhpSQLiteDbConnection connection = new PhpSQLiteDbConnection(csb.ConnectionString); if (error != null) { error.Value = null; } return(connection); } catch (Exception ex) { if (error != null) { error.Value = ex.Message; } return(null); } }
private static PhpResource Open(string filename, int mode, PhpReference error, bool persistent) { if (persistent) PhpException.FunctionNotSupported(PhpError.Notice); SQLiteConnectionStringBuilder csb = new SQLiteConnectionStringBuilder(); csb.DataSource = filename; csb.Version = 3; try { PhpSQLiteDbConnection connection = new PhpSQLiteDbConnection(csb.ConnectionString); if (error != null) { error.Value = null; } return connection; } catch (Exception ex) { if (error != null) { error.Value = ex.Message; } return null; } }
public static void Close(PhpResource linkIdentifier) { PhpSQLiteDbConnection connection = PhpSQLiteDbConnection.ValidConnection(linkIdentifier); if (connection != null) { connection.Close(); } }
public static void CreateFunction(PhpResource dbhandle, string function_name, object callback, int num_args) { PhpSQLiteDbConnection connection = PhpSQLiteDbConnection.ValidConnection(dbhandle); PhpCallback cb = PHP.Core.Convert.ObjectToCallback(callback); int paramCount = cb.TargetRoutine.PhpFunction.ArgFullInfo.GetParameters().Length; Delegate d = null; connection.Connection.RegisterFunction(function_name, paramCount, FunctionType.Scalar, d); //SQLiteFunction.RegisterFunction() }
public static bool Exec(object arg1, object arg2, PhpReference error_message) { PhpSQLiteDbConnection connection = PhpSQLiteDbConnection.ValidConnection(arg1 as PhpResource); string query; if (connection == null) { connection = PhpSQLiteDbConnection.ValidConnection(arg2 as PhpResource); query = PHP.Core.Convert.ObjectToString(arg1); } else { query = PHP.Core.Convert.ObjectToString(arg2); } if (query == null || connection == null) { return(false); } try { connection.ExecuteCommand(query, System.Data.CommandType.Text, true, null, true); if (error_message != null) { error_message.Value = null; } return(true); } catch (Exception ex) { if (error_message != null) { error_message.Value = ex.Message; } return(false); } }
public static PhpResource Query(object arg1, object arg2, QueryResultKeys result_type, PhpReference error_msg) { PhpSQLiteDbConnection connection = PhpSQLiteDbConnection.ValidConnection(arg1 as PhpResource); string query; if (connection == null) { connection = PhpSQLiteDbConnection.ValidConnection(arg2 as PhpResource); query = PHP.Core.Convert.ObjectToString(arg1); } else { query = PHP.Core.Convert.ObjectToString(arg2); } if (query == null || connection == null) { return(null); } try { var result = connection.ExecuteQuery(query, true); if (error_msg != null) { error_msg.Value = null; } return(result); } catch (Exception ex) { if (error_msg != null) { error_msg.Value = ex.Message; } return(null); } }