summaryrefslogtreecommitdiff
path: root/src/main.rs
blob: d9a8272359a3689a75bd70cf75c84931c4b5c8b3 (plain)
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
79
#![feature(proc_macro_hygiene, decl_macro)]

#[macro_use]
extern crate rocket;
use rspotify::spotify::client::Spotify;
use rspotify::spotify::oauth2::{SpotifyClientCredentials, SpotifyOAuth};
use rspotify::spotify::util::get_token;

mod serve;

fn main() {
    // Set client_id and client_secret in .env file or
    // export CLIENT_ID="your client_id"
    // export CLIENT_SECRET="secret"
    // export REDIRECT_URI=your-direct-uri

    // Or set client_id, client_secret,redirect_uri explictly
    // let oauth = SpotifyOAuth::default()
    //     .client_id("this-is-my-client-id")
    //     .client_secret("this-is-my-client-secret")
    //     .redirect_uri("http://localhost:8888/callback")
    //     .build();
    //
    let mut db = noria::ControllerHandle::from_zk("127.0.0.1:2181").unwrap();

    //db.ready();
    println!("test {:?}", db.url());
    db.install_recipe(
        "
    CREATE TABLE Article (aid int, title varchar(255), url text, PRIMARY KEY(aid));
    CREATE TABLE Vote (aid int, uid int);
",
    );
    println!("test");
    // we can then get handles that let us insert into the new tables
    let mut article = db.table("Article").unwrap();
    let mut vote = db.table("Vote").unwrap();

    // let's make a new article
    let aid = 42;
    let title = "I love Soup";
    let url = "https://pdos.csail.mit.edu";
    article
        .insert(vec![aid.into(), title.into(), url.into()])
        .unwrap();

    // and then vote for it
    vote.insert(vec![aid.into(), 1.into()]).unwrap();
    println!("test");

    // we can also declare views that we want want to query
    db.extend_recipe(
        "
    VoteCount: \
      SELECT Vote.aid, COUNT(uid) AS votes \
      FROM Vote GROUP BY Vote.aid;
    QUERY ArticleWithVoteCount: \
      SELECT Article.aid, title, url, VoteCount.votes AS votes \
      FROM Article LEFT JOIN VoteCount ON (Article.aid = VoteCount.aid) \
      WHERE Article.aid = ?;",
    );

    // and then get handles that let us execute those queries to fetch their results
    let mut awvc = db.view("ArticleWithVoteCount").unwrap();
    // looking up article 42 should yield the article we inserted with a vote count of 1
    assert_eq!(
        awvc.lookup(&[aid.into()], true).unwrap(),
        vec![vec![
            noria::DataType::from(aid),
            title.into(),
            url.into(),
            1.into()
        ]]
    );

    rocket::ignite()
        .mount("/", routes![serve::token, serve::get_tracks])
        .launch();
}