Package com.pugh.sockso.db

Examples of com.pugh.sockso.db.Database

265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
       
        try {
           
            final User user = getUser();
            final Request req = getRequest();
            final Database db = getDatabase();
            final String sql = " update users " +
                               " set email = ?, " +
                                   " pass = ? " +
                               " where id = ? ";
           
            st = db.prepare( sql );
            st.setString( 1, req.getArgument("email") );
            st.setString( 2, Utils.md5(req.getArgument("pass1")) );
            st.setInt( 3, user.getId() );
            st.execute();
           
View Full Code Here
394
395
396
397
398
399
400
401
402
403
404
        final String name = req.getArgument( "name" ).trim();
        final String pass1 = req.getArgument( "pass1" );
        final String pass2 = req.getArgument( "pass2" );
        final String email = req.getArgument( "email" ).trim();
       
        final Database db = getDatabase();
        final Validater v = new Validater( db );
       
        if ( !v.checkRequiredFields(new String[]{name,pass1,email}) )
            throw new BadRequestException( locale.getString("www.error.missingField") );
        if ( !pass1.equals(pass2) )
View Full Code Here
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
        ResultSet rs = null;
        PreparedStatement st = null;

        try {

            final Database db = getDatabase();
            final String sql = " select id, name " +
                               " from users " +
                               " where name = ? " +
                               " limit 1 ";

            st = db.prepare( sql );
            st.setString( 1, name );
            rs = st.executeQuery();

            if ( rs.next() ) {
                return new User( rs.getInt("id"), rs.getString("name") );
View Full Code Here
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
        final User user = getUser();
        final Locale locale = getLocale();

        if ( user == null ) throw new BadRequestException( locale.getString("www.json.error.notLoggedIn"), 403 );

        final Database db = getDatabase();
        final int id = Integer.parseInt( req.getUrlParam(2) );
        final String sql = " select 1 " +
                           " from playlists p " +
                           " where p.id = ? " +
                               " and p.user_id = ? ";

        ResultSet rs = null;
        PreparedStatement st = null;
       
        try {

            // check user owns playlist before deleting it
            st = db.prepare( sql );
            st.setInt( 1, id );
            st.setInt( 2, user.getId() );
            rs = st.executeQuery();
            if ( !rs.next() )
                throw new BadRequestException( "You don't own that playlist", 403 );
View Full Code Here
240
241
242
243
244
245
246
247
248
249
250
        ResultSet rs = null;
        PreparedStatement st = null;
       
        try {
       
            final Database db = getDatabase();
            final Request req = getRequest();
            final String path = req.getArgument( "path" );
           
            final TTracksForPath tpl = new TTracksForPath();
            tpl.setTracks( Track.getTracksFromPath(db,path) );
View Full Code Here
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
        ResultSet rs = null;
        PreparedStatement st = null;

        try {
           
            final Database db = getDatabase();
            final Locale locale = getLocale();
            final Request req = getRequest();
            final String path = convertPath( req.getArgument("path") );
            final String sql = Track.getSelectFromSql() +
                    " where t.path = ? ";
           
            st = db.prepare( sql );
            st.setString( 1, path );
            rs = st.executeQuery();
           
            if ( !rs.next() )
                throw new BadRequestException( locale.getString("www.error.trackNotFound"), 404 );
View Full Code Here
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
                path += "/" + req.getUrlParam( i );
        }
               
        try {

            final Database db = getDatabase();
            final String sql = " select c.path " +
                               " from collection c " +
                               " where c.id = ? ";
            st = db.prepare( sql );
            st.setInt( 1, collectionId );
            rs = st.executeQuery();

            // check the collection exists and we got it's root path
            if ( rs.next() ) {
View Full Code Here
469
470
471
472
473
474
475
476
477
478
479
            result = locale.getString("www.json.error.noArguments");
        else if ( user == null )
            result = locale.getString("www.json.error.notLoggedIn");
        else {
           
            final Database db = getDatabase();
            final List<Track> vTracks = Track.getTracksFromPlayArgs( db, args );
            final Track[] tracks = new Track[ vTracks.size() ];
           
            for ( int i=0; i<vTracks.size(); i++ )
                tracks[i] = vTracks.get( i );
View Full Code Here
23
24
25
26
27
28
29
30
31
32
33
     *
     */
   
    public void handleRequest() throws IOException, SQLException, BadRequestException {
       
        final Database db = getDatabase();
        final Playlist playlist = Playlist.find( db, Integer.parseInt( getRequest().getUrlParam(2) ) );
       
        if ( playlist == null ) {
            throw new BadRequestException( "Invalid playlist ID" );
        }
View Full Code Here
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
        PreparedStatement st = null;
        ResultSet rs = null;

        try {

            final Database db = getDatabase();
            final String sql = " select ar.id as id, ar.name as name, count(t.id) as playCount " +
                    " from play_log l " +
                        " inner join tracks t " +
                        " on t.id = l.track_id " +
                        " inner join artists ar " +
                        " on ar.id = t.artist_id " +
                    " group by ar.id, ar.name " +
                    " order by playCount desc " +
                    " limit ? ";
           
            st = db.prepare( sql );
            st.setInt( 1, total );
            rs = st.executeQuery();
           
            final List<Artist> topArtists = new ArrayList<Artist>();
           
View Full Code Here
TOP

Related Classes of com.pugh.sockso.db.Database

  • com.pugh.sockso.DBPropertiesTest
  • com.pugh.sockso.gui.action.ImportPlaylistTest
  • com.pugh.sockso.music.DBCollectionManagerTest
  • com.pugh.sockso.music.TrackTest
  • com.pugh.sockso.tests.TestResponse
  • com.pugh.sockso.web.action.AbstractCoverSearchTest
  • com.pugh.sockso.web.action.api.PlaylistAction
  • com.pugh.sockso.web.action.browse.Albumer
  • com.pugh.sockso.web.action.browse.AlbumerTest
  • com.pugh.sockso.web.action.browse.Artister
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.