-
Notifications
You must be signed in to change notification settings - Fork 1
/
sqlite.cs
78 lines (74 loc) · 2.08 KB
/
sqlite.cs
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
78
using System;
using System.Data.SQLite;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.IO;
namespace sqlite
{
public class sql
{
private SQLiteCommand cmd { get; set; }
private SQLiteConnection db { get; set; }
public sql(string path)
{
if (File.Exists(path))
{
db = new SQLiteConnection("Data Source=" + path);
Directory.CreateDirectory("data");
db.Open();
cmd = db.CreateCommand();
}
else
{
db = new SQLiteConnection("Data Source=" + path);
db.Open();
cmd = db.CreateCommand();
cmd.CommandText = "create table kv(k TEXT PRIMARY KEY NOT NULL,v TEXT NOT NULL)";
cmd.ExecuteNonQuery();
}
}
public void dput(string k, string v)
{
if (haskey(k))
{
cmd.CommandText = "update kv set v = '{v}' where k = '{k}'";
cmd.ExecuteNonQuery();
}
else
{
cmd.CommandText = $"insert into kv(k,v) VALUES ('{k}','{v}')";
cmd.ExecuteNonQuery();
}
}
public string dget(string k)
{
cmd.CommandText = $"select * from kv where k = {k}";
var i = cmd.ExecuteReader();
if (i.HasRows)
{
i.Read();
return i.GetString(1);
}
else
return "nil";
}
public void ddel(string k)
{
if (haskey(k))
{
cmd.CommandText = $"delete from kv where k = {k}";
var i = cmd.ExecuteReader();
}
}
private bool haskey(string k)
{
cmd.CommandText = $"select * from kv where k = {k}";
var i = cmd.ExecuteReader();
var r = i.HasRows;
i.Close();
return r;
}
}
}