C# Class reExp.Models.DB.DB

ファイルを表示 Open project: ren85/rextester_win

Public Methods

Method Description
CancelVote ( string guid, bool up ) : void
CodeWithVotes_Get ( string guid ) : object>>.List
Code_Get ( string guid ) : object>>.List
Code_Insert ( string title, string code, string input, string output, string compiler_args, int lang, int editor, string guid, int userId, string error, string warning, bool show_warnings, int status, string stats, bool wall, bool live, bool personal ) : void
Code_Update ( string newguid, string code, string input, string output, string compiler_args, string oldguid, string error, string warning, bool show_warnings, int status, string stats, string title ) : void
Comment_Get ( int Comments_ID ) : object>>.List
Comment_Last_Id ( int Code_id ) : object>>.List
Comments_Delete ( int comments_id ) : void
Comments_Get ( string guid ) : object>>.List
Comments_Insert ( int code_id, int user_id, string text ) : void
Comments_Update ( int comments_id, string text ) : void
DeleteCodeWallItem ( int wall_id ) : void
DeleteUserItem ( int id ) : bool
DeleteUserWallItem ( int id ) : bool
Delete_Code ( string guid ) : void
Delete_Code_Helper ( int pid ) : void
Delete_Code_Live ( string guid ) : void
GetDeleteUserItemsSearchId ( int id ) : string
GetNotifications ( ) : object>>.List
GetNotificationsCount ( ) : object>>.List
GetRelated ( int Code_id ) : object>>.List
GetRights ( string guid ) : object>>.List
GetSubscriptions ( ) : object>>.List
GetUser ( string name ) : object>>.List
GetUserByCodeId ( int code_id ) : object>>.List
GetUserByGuid ( string guid ) : object>>.List
GetUserWallCodesTotal ( int id ) : object>>.List
GetUserWallId ( ) : object>>.List
GetUserWallUserID ( int id ) : object>>.List
GetUserWallsCode ( int id, int page, int sort ) : object>>.List
GetUserWallsTotal ( ) : object>>.List
GetUsersItems ( int userId, int page ) : object>>.List
GetUsersTotal ( int userId ) : object>>.List
GetUsersWalls ( int page ) : object>>.List
GetVersions ( string guid ) : object>>.List
GetWallsCode ( int page, int sort, int lang ) : object>>.List
GetWallsName ( int id ) : object>>.List
GetWallsTotal ( int lang ) : object>>.List
Get_Lang_Counter ( ) : object>>.List
Get_User_profile ( int UserId ) : object>>.List
GoogleEmailExists ( string email ) : object>>.List
HowVoted ( string guid ) : object>>.List
IncrementViews ( string guid ) : void
Increment_Lang_Counter ( string data, string input, string compiler_args, string result, int lang, bool is_api ) : void
InsertUser ( string name, string passwordHash, string emailHash ) : void
IsLive ( string guid ) : object>>.List
IsUserSubscribed ( int wall_id ) : object>>.List
Live_Code_Get ( string guid ) : object>>.List
Live_Code_Insert ( string guid, string version_token ) : void
Live_Code_Update ( string newguid, string code, string input, string output, string compiler_args, string oldguid, string error, string warning, bool show_warnings, int status, string stats, string title ) : void
Log_Code_Insert ( string data, string input, string compiler_args, string result, int lang ) : void
Log_Info_Insert ( string info, string type ) : void
Notification_Insert ( int user_id, string name, int code_id, int created_user_id ) : void
Privacy_Info_Insert ( string privacy_option, string privacy_users, string guid ) : void
Regex_Get ( string guid ) : object>>.List
Regex_Insert ( string regex, string text, string output, string options, string guid, int userId ) : void
Regex_Replace_Get ( string guid ) : object>>.List
Regex_Replace_Insert ( string regex, string replacement, string text, string output, string options, string guid, int userId ) : void
Save_User_profile ( int UserId, int language_choice, int editor_choice ) : void
Subscribe ( int wall_id, bool is_subscribed ) : void
UpdateSubscriptionsCheckedDate ( ) : void
Vote ( string guid, bool up ) : void

Private Methods

Method Description
ExecuteNonQuery ( string query, List pars ) : void
ExecuteQuery ( string query, List pars ) : object>>.List
GetConnection ( ) : SQLiteConnection

Method Details

CancelVote() public static method

public static CancelVote ( string guid, bool up ) : void
guid string
up bool
return void

CodeWithVotes_Get() public static method

public static CodeWithVotes_Get ( string guid ) : object>>.List
guid string
return object>>.List

Code_Get() public static method

public static Code_Get ( string guid ) : object>>.List
guid string
return object>>.List

Code_Insert() public static method

public static Code_Insert ( string title, string code, string input, string output, string compiler_args, int lang, int editor, string guid, int userId, string error, string warning, bool show_warnings, int status, string stats, bool wall, bool live, bool personal ) : void
title string
code string
input string
output string
compiler_args string
lang int
editor int
guid string
userId int
error string
warning string
show_warnings bool
status int
stats string
wall bool
live bool
personal bool
return void

Code_Update() public static method

public static Code_Update ( string newguid, string code, string input, string output, string compiler_args, string oldguid, string error, string warning, bool show_warnings, int status, string stats, string title ) : void
newguid string
code string
input string
output string
compiler_args string
oldguid string
error string
warning string
show_warnings bool
status int
stats string
title string
return void

Comment_Get() public static method

public static Comment_Get ( int Comments_ID ) : object>>.List
Comments_ID int
return object>>.List

Comment_Last_Id() public static method

public static Comment_Last_Id ( int Code_id ) : object>>.List
Code_id int
return object>>.List

Comments_Delete() public static method

public static Comments_Delete ( int comments_id ) : void
comments_id int
return void

Comments_Get() public static method

public static Comments_Get ( string guid ) : object>>.List
guid string
return object>>.List

Comments_Insert() public static method

public static Comments_Insert ( int code_id, int user_id, string text ) : void
code_id int
user_id int
text string
return void

Comments_Update() public static method

public static Comments_Update ( int comments_id, string text ) : void
comments_id int
text string
return void

DeleteCodeWallItem() public static method

public static DeleteCodeWallItem ( int wall_id ) : void
wall_id int
return void

DeleteUserItem() public static method

public static DeleteUserItem ( int id ) : bool
id int
return bool

DeleteUserWallItem() public static method

public static DeleteUserWallItem ( int id ) : bool
id int
return bool

Delete_Code() public static method

public static Delete_Code ( string guid ) : void
guid string
return void

Delete_Code_Helper() public static method

public static Delete_Code_Helper ( int pid ) : void
pid int
return void

Delete_Code_Live() public static method

public static Delete_Code_Live ( string guid ) : void
guid string
return void

GetDeleteUserItemsSearchId() public static method

public static GetDeleteUserItemsSearchId ( int id ) : string
id int
return string

GetNotifications() public static method

public static GetNotifications ( ) : object>>.List
return object>>.List

GetNotificationsCount() public static method

public static GetNotificationsCount ( ) : object>>.List
return object>>.List

GetRelated() public static method

public static GetRelated ( int Code_id ) : object>>.List
Code_id int
return object>>.List

GetRights() public static method

public static GetRights ( string guid ) : object>>.List
guid string
return object>>.List

GetSubscriptions() public static method

public static GetSubscriptions ( ) : object>>.List
return object>>.List

GetUser() public static method

public static GetUser ( string name ) : object>>.List
name string
return object>>.List

GetUserByCodeId() public static method

public static GetUserByCodeId ( int code_id ) : object>>.List
code_id int
return object>>.List

GetUserByGuid() public static method

public static GetUserByGuid ( string guid ) : object>>.List
guid string
return object>>.List

GetUserWallCodesTotal() public static method

public static GetUserWallCodesTotal ( int id ) : object>>.List
id int
return object>>.List

GetUserWallId() public static method

public static GetUserWallId ( ) : object>>.List
return object>>.List

GetUserWallUserID() public static method

public static GetUserWallUserID ( int id ) : object>>.List
id int
return object>>.List

GetUserWallsCode() public static method

public static GetUserWallsCode ( int id, int page, int sort ) : object>>.List
id int
page int
sort int
return object>>.List

GetUserWallsTotal() public static method

public static GetUserWallsTotal ( ) : object>>.List
return object>>.List

GetUsersItems() public static method

public static GetUsersItems ( int userId, int page ) : object>>.List
userId int
page int
return object>>.List

GetUsersTotal() public static method

public static GetUsersTotal ( int userId ) : object>>.List
userId int
return object>>.List

GetUsersWalls() public static method

public static GetUsersWalls ( int page ) : object>>.List
page int
return object>>.List

GetVersions() public static method

public static GetVersions ( string guid ) : object>>.List
guid string
return object>>.List

GetWallsCode() public static method

public static GetWallsCode ( int page, int sort, int lang ) : object>>.List
page int
sort int
lang int
return object>>.List

GetWallsName() public static method

public static GetWallsName ( int id ) : object>>.List
id int
return object>>.List

GetWallsTotal() public static method

public static GetWallsTotal ( int lang ) : object>>.List
lang int
return object>>.List

Get_Lang_Counter() public static method

public static Get_Lang_Counter ( ) : object>>.List
return object>>.List

Get_User_profile() public static method

public static Get_User_profile ( int UserId ) : object>>.List
UserId int
return object>>.List

GoogleEmailExists() public static method

public static GoogleEmailExists ( string email ) : object>>.List
email string
return object>>.List

HowVoted() public static method

public static HowVoted ( string guid ) : object>>.List
guid string
return object>>.List

IncrementViews() public static method

public static IncrementViews ( string guid ) : void
guid string
return void

Increment_Lang_Counter() public static method

public static Increment_Lang_Counter ( string data, string input, string compiler_args, string result, int lang, bool is_api ) : void
data string
input string
compiler_args string
result string
lang int
is_api bool
return void

InsertUser() public static method

public static InsertUser ( string name, string passwordHash, string emailHash ) : void
name string
passwordHash string
emailHash string
return void

IsLive() public static method

public static IsLive ( string guid ) : object>>.List
guid string
return object>>.List

IsUserSubscribed() public static method

public static IsUserSubscribed ( int wall_id ) : object>>.List
wall_id int
return object>>.List

Live_Code_Get() public static method

public static Live_Code_Get ( string guid ) : object>>.List
guid string
return object>>.List

Live_Code_Insert() public static method

public static Live_Code_Insert ( string guid, string version_token ) : void
guid string
version_token string
return void

Live_Code_Update() public static method

public static Live_Code_Update ( string newguid, string code, string input, string output, string compiler_args, string oldguid, string error, string warning, bool show_warnings, int status, string stats, string title ) : void
newguid string
code string
input string
output string
compiler_args string
oldguid string
error string
warning string
show_warnings bool
status int
stats string
title string
return void

Log_Code_Insert() public static method

public static Log_Code_Insert ( string data, string input, string compiler_args, string result, int lang ) : void
data string
input string
compiler_args string
result string
lang int
return void

Log_Info_Insert() public static method

public static Log_Info_Insert ( string info, string type ) : void
info string
type string
return void

Notification_Insert() public static method

public static Notification_Insert ( int user_id, string name, int code_id, int created_user_id ) : void
user_id int
name string
code_id int
created_user_id int
return void

Privacy_Info_Insert() public static method

public static Privacy_Info_Insert ( string privacy_option, string privacy_users, string guid ) : void
privacy_option string
privacy_users string
guid string
return void

Regex_Get() public static method

public static Regex_Get ( string guid ) : object>>.List
guid string
return object>>.List

Regex_Insert() public static method

public static Regex_Insert ( string regex, string text, string output, string options, string guid, int userId ) : void
regex string
text string
output string
options string
guid string
userId int
return void

Regex_Replace_Get() public static method

public static Regex_Replace_Get ( string guid ) : object>>.List
guid string
return object>>.List

Regex_Replace_Insert() public static method

public static Regex_Replace_Insert ( string regex, string replacement, string text, string output, string options, string guid, int userId ) : void
regex string
replacement string
text string
output string
options string
guid string
userId int
return void

Save_User_profile() public static method

public static Save_User_profile ( int UserId, int language_choice, int editor_choice ) : void
UserId int
language_choice int
editor_choice int
return void

Subscribe() public static method

public static Subscribe ( int wall_id, bool is_subscribed ) : void
wall_id int
is_subscribed bool
return void

UpdateSubscriptionsCheckedDate() public static method

public static UpdateSubscriptionsCheckedDate ( ) : void
return void

Vote() public static method

public static Vote ( string guid, bool up ) : void
guid string
up bool
return void