database

const (
	DriverName = "sqlite3"
	DbName     = "/home/ubuntu/ECE_422_Project_1/db/sfs.db"
)

const AddCheckSum = `
	INSERT INTO check_sums (file_path, check_sum) VALUES (?, ?)
`

const AddGroupPermissionsQuery = `` /* 147-byte string literal not displayed */

const AddGroupQuery = `INSERT INTO groups (group_name) values ($1)`

const AddPermissionForAllUsersGroups = `` /* 249-byte string literal not displayed */

const AddUserPermissionsQuery = `
INSERT
INTO file_permissions
select ?, id, null, TRUE, TRUE
from users
where username = ?;
`

const AddUserQuery = `INSERT INTO users (username, password) values ($1, $2)`

const AddUserToGroupQuery = `` /* 155-byte string literal not displayed */

const AuthenticateUserQuery = `` /* 265-byte string literal not displayed */

const ChangeFilePathCheckSums = `
UPDATE check_sums
SET file_path = ?
WHERE file_path = ?;
`

const ChangeFilePathPermission = `
UPDATE file_permissions
SET file_path = ?
WHERE file_path = ?;
`

const CheckUserExistsQuery = `` /* 263-byte string literal not displayed */

const CheckUserGroupsPermissionQuery = `` /* 551-byte string literal not displayed */

const CheckUserHasPermissionQuery = `` /* 407-byte string literal not displayed */

const GetCheckSum = `
	select check_sum
	from check_sums
	where file_path = ?
`

const Schema = `` /* 1023-byte string literal not displayed */

const UpdateCheckSum = `
	UPDATE check_sums
	SET check_sum = ?
	WHERE file_path = ?
`

const UpdateGroupPermissions = `` /* 277-byte string literal not displayed */