ios - How to store database into struct using swift3? -

-

i have function database , return in mutablearray, need database in struct.

do need mutablearray struct or should data straight struct?

i have no idea how approach or how store database struct

my code:

class crimesinfo: nsobject {  var name: string = string() var detail: string = string() var time: string = string() }

the function:

func getallcrimesdata() -> nsmutablearray {     sharedinstance.database!.open()     let resultset: fmresultset! = sharedinstance.database!.executequery("select * crimetable", withargumentsin: nil)     let marrcrimesinfo : nsmutablearray = nsmutablearray()     if (resultset != nil) {         while resultset.next() {             let crimesinfo : crimesinfo = crimesinfo()             crimesinfo.name = resultset.string(forcolumn: "name")             crimesinfo.detail = resultset.string(forcolumn: "detail")             crimesinfo.time = resultset.string(forcolumn: "time")             marrcrimesinfo.add(crimesinfo)         }     }

there's lot going on here. here of thoughts:

  1. your getallcrimesdata gets crimesinfo. "data" or "into, pick one, stay consistent.
  2. your getallcrimesdata return array of kinds of data mushed together. there's no need this, fill out structs immediately, rather worrying parsing array structs later.
  3. there's never reason use nsarray, nsdictionary, or mutable versions in swift. use native swift type.
  4. use safe guard let or if let checking deal optionality of resultset, rather using implicitly-unwrapped optional.
  5. there's no reason make crimesinfo class
  6. there's no reason make crimesinfo inherit nsobject
  7. there's no reason pre-fil name/detail/time empty string. doubt want crime named "".

here's how write this:

struct crimeinfo: nsobject {     let name: string     let details: string     let time: string      init(name: string, detail: string, time: string) {         self.name = name         self.details = details         self.time = time     }      init(fromresultset: fmresultset) {         self.init(             name: resultset.string(forcolumn: "name"),             details: resultset.string(forcolumn: "detail"),             time: resultset.string(forcolumn: "time")         )     } }  let crimesintoquery = "select * crimetable"  func getallcrimesinfo() -> [crimeinfo] {     let database = sharedinstance.database!     database.open()      guard let resultset = database.executequery(crimesintoquery, withargumentsin: nil) {         else return []     }      var crimes = [crimeinfo]()      while resultset.next() {         crimes.add(crimeinfo(fromresultset: resultset))     }      return crimes }

Comments

Post a Comment

Popular posts from this blog

php - How to display all orders for a single product showing the most recent first? Woocommerce -

-
i have password protected page on frontend. on page, want display full list of purchases associated single woocommerce product id. option 1: i've looked through woocommerce docs , , found: wc_cli_order , list_( $args, $assoc_args ) function lists orders. presumably, orders can filtered product id [--=] filter orders based on order property. line item fields (numeric array, started index zero): line_items.0.product_id option 2: i found article , based on customer id. i've modified code based on guesses meta_key , meta_value. $customer_orders = get_posts( array( 'numberposts' => -1, 'meta_key' => '_product', 'meta_value' => get_product_id(), 'post_type' => wc_get_order_types(), 'post_status' => array_keys( wc_get_order_statuses() ), ) ); how display orders single product showing recent order first? here solution put based on these articles: http://www.w...
Read more

asp.net - How to correctly use QUERY_STRING in ISAPI rewrite? -

-
i'm having difficult time , hope guys can help. using helicon isapi rewrite version 3.1.0.104 on our iis server. edit http.conf file , have tried , still fail. this trying do: redirect url: https://www.domain.com/switch-by-version?version=2.8.5.2594 to: https://test.domain.com/load/load.aspx?tver=2.8.5.2594 the version number @ end source url change, , need target url have same version number @ end of url example above shows. i tried following not work: rewritecond %{query_string} ^version=(\d\d?)\.(\d\d?)\.(\d\d?)\.(.*)$ [nc] rewriterule ^/switch-by-version(.*)$ https://test.domain.com/load/load.aspx?tver=%1 [r=307,nc,l] any appreciated! thanks. if it's running in equivalent context of .htaccess , rule shouldn't start / . here's simpler version: rewritecond %{query_string} ^version=(\d+\.\d+\.\d+(?:\..+)?)$ [nc] rewriterule ^switch-by-version/?$ https://test.domain.com/load/load.aspx?tver=%1 [r=307,nc,l]
Read more

angularjs - How restrict admin panel using in backend laravel and admin panel on angular? -

-
https://scotch.io/tutorials/token-based-authentication-for-angularjs-and-laravel-apps following tutorials, try write authentication restrict admin panel, didn't understood how can that. this admin panel, admin panel don't want show , request database unauthenticated users. my laravel-routes route::get('/admin',function(){ return view('index'); }); route::get('/api/v1/employees/{id?}', 'employees@index'); route::get('/api/v1/users/{id?}', 'employees@users'); route::post('/api/v1/employees', 'employees@store'); route::post('/api/v1/employees/{id}', 'employees@update'); route::delete('/api/v1/employees/{id}', 'employees@destroy'); route::group(['prefix' => 'api'], function() { route::resource('authenticate', 'authenticatecontroller', ['only' => ['index']]); route::post('authenticate', 'authentic...
Read more